# KCSE Past Papers 2017 Computer Studies Paper 2 (451/3)

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)

(Visited 140 times, 1 visits today)