Computer Studies Paper 2 Questions and Answers - Wahundura Boys Mock Examination 2023

Instructions

• Indicate you name and index number at the top right hand corner of each printout.
• Write your name and index number on the CD/Removable provided.
• Write the name and version of the software used for each question attempted in the answer sheet.
• Answer all the questions
• All questions carry equal marks.
• Passwords should not be used while saving in the CD/Removable provided.
• All answers must be saved in your CD/Removable provided.
• Make a printout of the answers on the answer sheet.
•  Arrange your printouts and staple them together.
•  Hand in all the printouts and the CD/Removable used.
• This paper consists of 5 printed pages.
• Candidates should check the question papers to ascertain that all the pages are printed as indicated and that no questions are missing.
• Candidates should answer the questions in English.

QUESTIONS

1. The table in Figure 1 below was captured from a Nia Safi Investments spreadsheet.
   
   
   1. In a new Spreadsheet, enter the information exactly as it appears and save your work as NSI-Task1. (11 marks)
   2. Enter the table in Figure 2 below from cell A23 in the same spreadsheet. (3 marks)
      

      Rates Of Pay
      Day of the Week	Rate (Ksh)
      Saturday	150.00
      Sunday	200.00
      Any other Day	100.00

      
      Figure 2
   3. Using the information in Figure 2 and appropriate cell addresses, type a formula in E4 which you will copy downwards to obtain all the rates of pay in respective cells. (6 marks)
   4. Copy the formula in part (c) above to obtain all rates of pay. (2 marks)
   5. Using an appropriate Function, work out the Amounts considering that
      Amount = Hours Worked × Rate. (4 marks)
   6. Rename the used spreadsheet as ‘Calculations’. (1 mark)
   7. Save the work done so far as NSI-Task2. (1 mark)
   8. Create a duplicate copy of Calculations sheet, hence rename the copy as ‘Subtotals’. (2 marks)
   9. Using the data Subtotaling feature, work out the totals paid to every worker within the period. (3 marks)
   10. Create another copy of Calculations Sheet as rename it as ‘Attendance’. (2 marks)
   11. Replace the information in table from A23 to appear as follows: (2 marks)
       

       Attendance Register
       Employee	Times Attended
       Albert
       Bernard
       Caroline
       Carl
       Lewis

       
       Figure 3
   12. Using an appropriate function count the Times Attended by each of the employees into the table in Figure 3 above. (3 marks)
   13. Use a 3-D pie chart to represent the data in Figure 3 above. Apply the following settings: (5 marks)
       • Title: Times Attended Chart
       • Legend: Placed at the bottom
       • Labels: Both Percentages & Values
       • Location: As a New Sheet named Pie-Chart.
   14. Save the final work as NSI-Task3. (1 mark)
   15. In NSI-Task3, ensure that every worksheet has a header bearing your name, admission number and class. (2 marks)
   16. From NSI-Task3, print the Calculations, Attendance, Subtotals and Pie-Chart (2 marks)
2.  
   1. Use a DTP software to design the following publication as it is with the following settings:
      1. paper size = A4
      2. orientation = Landscape
      3. page margins = 0.25 inches all around
         1. Guides: Column 1 Width = 5.2”
            Space between Columns = 0.75”
            Column 2 Width = 5.2”
         2. File name = ExcellenceBook (6 marks)
   2. Design the publication as it appears on the following page on the page you have created and fit all the items within the page. (38 marks)
   3. Insert your name and admission number as header, then your class and page number as footer. (4 marks)
   4. Print the publication. (2 marks)
       

CONFIDENTIAL INSTRUCTIONS

The information contained in this document is to enable the headteacher of the school and the teacher in charge of Computer Studies (451/2) to make adequate preparation for this year’s examination.

Each school offering Computer Studies should ensure that:

1. Each candidate is provided with a computer which has:
   •  a new blank CD-RW (i.e. compact disk re-writable)
   •  a DVD writing drive
     The following software installed:
     1. DTP - MS publisher or PageMaker
     2. Word processor - MS Word
     3. Spreadsheet - MS Excel
     4. Database - MS Access
2. Enough computers and fast printers. Two shifts of candidates are recommended.
3. Provide IBM compatible computers
4. Computer teacher should disable the network and computer related examination in the beginning of each session.

MARKING SCHEME

Question One

QUESTION TWO