# KCSE Past Papers 2017 Computer Studies Paper 2

### Click Here - Free KCSE Past Papers » KCSE Past Papers 2017 Computer Studies Paper 2 » Free Downloads » KCSE Papers & Marking Schemes

KKCSE Past Papers 2017 Computer Studies Paper 2

2017 Computer Studies - Paper 2

1. Mavuno Group of hotels offer accommodation services to clients.

The accommodation rooms are categorised as single, double or VIP; each attracting different rates.

The rooms with fridges stocked with drinks attract an extra cost.

The management of the hotel intends to use a spreadsheet program to compute the revenue from the rooms.

Open the spreadsheet program and create a worksheet to appear as shown in Figure 1.

Save the workbook as room charges. (15 marks)

(b) Name the cell containing the value; 1500 as SR, the cell containing 2800 as DR, the cell with 3200 as VP and the cell with 300 as FR. (4 marks)

In the column with title Room Charges, enter a formula that can be copied down the column to multiply the value in days by SR if the room status value is S or multiply the value in days by DR if the room status value is D or multiply the value in days by VP if the room status value is V. (8 marks)

(ii) In the column with the title Fridge Charges enter a formula that can be copied down the column to compute Fridge Charges. (3 marks)

(iii) In the column with the title Total Charges, enter a formula that computes the total of the Room Charges and Fridge Charges for each guest. (2 marks)

(d) Format the Room Charges, Fridge Charges and Total Charges values as currency with zero number of decimal places. (2 marks)

(e) (i) Copy all the contents of the current work sheet to a new worksheet (1 mark)

(ii) Name the initial worksheet as ORIGINAL and the copied worksheet as NEW (2 marks)

(I) (i) In the sheet named NEW, extract only the records whose ROOM STATUS is S. (2 marks)

(ii) Create a column bar chart that compares the Room Charges and Fridge Charges for guests whose Guest Id are RM003, RM006 and RM0I2. (4 marks)

(iii) Insert the following labels in the chart created in (ii)

Chart Title X—axis Y—axis Single Room Revenue Guest ID

Revenue in Ksh.

(iv) Rename the chart sheet as SREVENUE.

(g) Printout later each of the following:

(i) ORIGINAL Worksheet

(ii) NEW Worksheet

(iii) SREVENUE Chart

2. The management of a county scout movement intends to award certificates of participation to the scouts who attended a fire rescue seminar.

Assuming that you have been tasked to design the certificates.

(a) Open a Desktop Publishing program and make the following page settings. (4 marks)

(i) Orientation

(ii) Units

(iii) Paper size

(iv) Margins

landscape centimetres A 4 2 cm all round

(b) Create the certificate as it appears in Figure 2. Save the design as Certificate.(45 marks)

(c) Printout the certificate later. (1 mark)

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)

KCSE Results » KCSE Results Top 100 Schools - Kenya Certificate of Secondary Education – KCSE » KCSE Top 100 Candidates » Kenya Certificate of Secondary Education – KCSE » KNEC - Kenya National Examinations Council » Secondary Schools in Kenya » KNEC - Kenya National Examinations Council » Free KNEC KCSE Past Papers

## KCSE Past Papers 2017 Computer Studies Paper 2

#### Scholarship 2021/22

Current Scholarships 2021/2022 - Fully Funded

• ✅Over 4500 Current Fully Funded Scholarships for International Students