Lochview High School is a large community school that uses a computer
system to monitor and control access to its many facilities.
(
a
)
The computer system operates smoothly thanks to the work of the
network manager
and
engineer
. Describe the role of each person in the
smooth running of the system.
Network Manager
Engineer
(
b
)
Staff and pupils have a
smartcard
which is used
to pay for food, gain access to teaching areas and
record attendance.
State
two
features of a smartcard that would be
useful in this situation.
1
2
(
c
)
Doors to the teaching areas remain locked until the computer receives
a signal that access is needed. When staff and pupils hold their
smartcards against the door’s scanner, the card is
verified
, access is
permitted and the doors automatically unlock.
(i)
State what is meant by
verification
.
(ii)
State the type of
processing
involved.
.
(
c
)
(continued)
(iii)
Describe
one
other software method of security that could be
used to restrict access to certain areas.
(
d
)
When pupils first join the school, their information is entered into the
computer system. This user data is stored in a
database
that can be
accessed by staff throughout the building at the same time.
State the term used to describe such a database.
(
e
)
Data about the pupils is used in a range of different processes from
registration to keeping a record of what they have purchased in the
school canteen.
State the term used to describe this data.
(
f
)
The
Data Protection Act
requires that the
data controller
ensures that
data is kept secure.
(i)
State
two
other responsibilities that the data controller has
under this Act.
1
2
(ii)
Identify the data controller is this situation. Circle the correct
answer.
Teacher Head Teacher Technician
2.
Mr Asimov keeps a record of his pupils’ homework marks. Part of the
spreadsheet is shown below.
A
B
C
D
E
F
G
H
1
Homework Record
Target Mark
60
2
3
Forename
Surname
HW1
HW2
HW3
HW4
Total
Mark
Letter
Home?
4
Charles
Babbage
5
10
3
7
25
YES
5
Daisy
Cameron
18
10
11
20
59
YES
6
Duncan
Cameron
13
12
14
15
54
YES
7
Lillian
Edwards
11
8
13
12
44
YES
8
Rian
Shah
14
15
16
11
56
YES
9
Holli
Chung
15
17
18
19
69
NO
10
Angus
Russell
19
18
20
13
70
NO
(
a
)
Cell G4 automatically calculates the total homework mark.
Complete the formula that was entered in cell G4.
=
(C4 :
)
(
b
)
The Total Mark is compared to the Target Mark in H1 to see
whether a letter should be sent home informing parents of concerns
with homework. Concerns are raised if the Total Mark is less than
the Target Mark. Cell H4 contains the formula that carries out this
comparison.
(i)
Complete the formula that was entered into cell H4.
=
IF
(
< H$1,
,
)
(ii)
The above formula contains a $ sign. Explain fully why this is
needed.