Page 1094 - SUBSEC October 2017_Neat

01229032/CSEC/SPEC/MS/2017
- 2 –

INFORMATION TECHNOLOGY
PAPER 032
MARK SCHEME
1. Specific Objectives:

a) 1 mark for typing the letter accurately

1 mark

b) 1 mark for the logo placed in the header
1 mark for use of another formatting feature.

2 marks

c) 1 mark for every two field names entered correctly.
(There are 10 fields to be entered)

5 marks
d) 1 mark for merging the documents.

1 mark

e) 1 mark for use of protection feature.
1 mark

Total 10 marks

2. Specific Objectives:

a) (i) Arial font, Np;d, 12 pt - 1 mark
Centre - 1 mark

2 marks
(ii) = (B2 -C2) * D2 1 mark

Replication - 1 mark 2 marks

(iii) Next to total revenue: = sum(E2:E6)
Next to Average Revenue: = avg(E2:E6) or =(A8/5)

2 marks

(iv) All cells with currency format - 1 mark
1 mark

(b) (i) Links data correctly - 1 mark
1 mark

(ii) Filter correctly applied - 1 mark

Extraction range setup correctly - 1 mark
2 marks

Total 10 marks