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)
(iii) Paper size
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)