COMPUTING STUDIES

1.
Matthew has just started college.
(
a
) He wants to buy a computer that he could use when he is in the lecture hall
taking notes.
(i) State the
type
of computer he should buy.
(ii) State
one
reason for your choice of computer.
(
b
) No matter where he is in the college grounds, Matthew can connect to the
Internet
using his new computer.
State how his laptop is able to do this.
(
c
) While using the word processor to write an essay he mistakenly used the
same word twice.
“. . . . . . the the . . . . . .”
Name the feature of the word processing program that would highlight this
error.
1. (continued)
(
d
) The essay is 12 pages long. Throughout the essay he misspelled MacDonald
as McDonald.
(i) Name the feature of the word processing package that could be used to
correct this in a single operation.
(ii) Describe how he would use this feature to correct the names.
(
e
) Matthew only wants to print the last three pages of his essay.
State how he could do this.
(
f
) One of the other programs Matthew makes use of is a spreadsheet. The
word processor and spreadsheet have a
common HCI
.
State
one
reason why a “common HCI” is useful.

2.
Colour Metals produce special metal work for house
builders.
They pay their workers a basic weekly wage plus an
overtime amount if they work any extra hours for the week.
Part of their spreadsheet used to work out the weekly wage
is shown below.
(
a
) A formula is used in cell E3 to work out the wage.
Complete the formula.
= _____________ + ( ________ * ________ )
(
b
) Cell E8 also contains a formula.
Complete the formula.
= _____________ ( _________ : _________ )
(
c
) Describe how you would change the cells in column B to make them look
like column D.

2
2
2
A
B
C
D
E
1
Name
Basic
Wage
Overtime
worked
Hourly
Rate for
overtime
This
Weeks
Pay
2
3
Black, D
200
5
£17·00
£285·00
4
Hussein, D
176
12
£14·00
£344·00
5
Smith, F
150
10
£12·00
£270·00
6
Wong, L
220
15
£19·50
£512·50
7
8
Total
£1,411·50