Marking Scheme
2017 Computer Studies – Paper 2
1. (a) Typing values in the cells
√ Values in cell range Al: B6 @1
√ Margin cells AI:B1 @ 1
√ Text wrap in the tit1e A1:B1 @ 1
√ Typing column 1(range A9: A22) @ 1
√ Typing column 2 (range B9: B22) @ 2
√ Typing column 3(range C9: C22) @ 1
√ Typing column 4(range D9: D22) @ 1
√ Typing column 5 (range E9: E22) @ 1
√ Saving the workbook @ 1
Column title text (row 8)
√ Typing column title text (correct, bolded and completeness-A8. H8) @ 2
√ Wrapping titles @ 1
√ Applying bold face @ 1
√ Applying borders to all the visible cells @ l
Tatal = (15 marks)
(b) Naming the cells containing:
√ 1500 as SR @ 1
√ 2800 as DR @ 1
√ 3200 as VP @ 1
√ 300 as FR @ 1
(4 marks)
(c) (i) -If (D9 = “S”, C9* SR, if (D9= “D”, C9 * DR, if (D9 = “V”, C9 * VP)))
√ Use of the IF function @ 1
√ S selection @ 2
√ D selection @ 2
√ V selection (else) @ 2
√ Logic and syntax @ 1
(8 marks)
(ii) =If (E7 = “Yes”, FR * C7, 0)
Use of the function Al Selection of fridge H 1 Alternative selection @ 1 (3 marks)
(iii) √= G 7 * H7 @ 1
√ Applying other cells @ 1 (2 marks)
(d) √ Currency formats @ 1 Zero decimal formats @ O
√ Formats applied in the correct range @ O (2 marks)
(e ) (i) √ Copying the content of the current worksheet to sheet 2 (1 mark)
(ii)√ Rename sheet 1 as original @ 1
√ Rename sheet 2 as NEW @ 1 (2 marks)
(f) (i) √ Enabling filter feature @ 1
√ Filtering out correct records (displaying S values only) @ 1 (2 marks)
(ii) √ Creating bar chart @ 1
√ Selecting the correct X fields @ 2
√ Selecting the correct Y fields @ 1 (4 marks)
(iii) Insertion of chart elements
√ Chart title @ 1
√ X axis label H 1 Y axis label @ 1 (3 marks)
(iv)√ Renaming the chart worksheet as SREVENUE @ 1 (1 mark)
(g)√ Printing the following
(i)√ Original worksheet @ 1
(ii)√ NEW worksheet @ 1
(iii)√ SREVEN (iv)√ UE chart @ l (3 marks)
2. (a) Page settings
(i)√ Paper orientation @ l
(ii)√ Units set to centimetres @ l
(iii)√ Paper size set to A4 @ 1
(iv)√ Margins set to 2cm @ 1 (4 marks)
(b) Border lines
(i)√ Outer borders @ 1
(ii)√ Inner rectangles @1
(iii)√ Corner shapes @ O x4 =2
(iv)√ Position on the page II (5 marks)
“Certificate of Participation” Text
√ Typing text @ 1
√ Enlarging and italicizing of “of’ @ 2
√ Positioning of this element on the page @1 (4 marks)
Lines below and above the “Certificate of Participation”
√ Text Top lines A O x 2 =1
√ Below lines H O x 2 =1 Correct placement Al (3 marks)
“Awarded to:” Text
√ Typing text @ 1
√ Correct placement this element on the page @ 1 (2 marks)
Line below “Awarded to:”
√ Text Inserting of the line @1 Correct placement @1 (2 marks)
“For the phenomenal. ” text
√ Typing text @ 1
√ Correct placement @ 1 (2 marks)
“Fire Emergency Rescue” Text
√ Typing the text Al Text (font) size Al
√ Fill pattern (outline font) Al Insertion of text box @l
√ Applying a dotted background in the text box Al Correct positioning of this elements in the page @l (6 marks)
“Presented By:” Text
√ Typing text -H I ‘
√ Horizontal line below @ 1
√ Position on the page Al
“On This Day” Text
√ Typing text @ 1 √ Position on the page @ 1 √ Horizontal line below @ 1
(3 marks)
The Flame and Candle Graphic
√ 2 curved lines A D x 2 =1
√ Flame outline(Filling the inner curve) @ 2
Rectangular shape @ 1 √ Correct fill pattern on the rectangle @ ½
√ Correct position of all the elements in the page @ 1
(5 marks)
The Star Graphic
√ Outer shape (drawing) Al Fill pattern II
√ Star shape (drawing) @ 1 White fill colour @1
√ Correct positioning on page @ 1 Star shape in front @ 1 (6 marks)
Second Star graphic
√ Copying (duplicated) @l
√ Correct positioning of both graphic each 2 O 1=2 (3 marks)
Saving the certificate (1 mark)
(c) Printing the design (1 mark)
