Computer Studies Paper 2 Questions and Answers - Bondo Joint Mocks Exams 2022

Questions

Instructions to Candidates

• Write your name and index number on the CD/removable storage medium provided
• Write the name and version of the software used for each question attempted in the answer sheet provided
• Answer all the questions, All questions carry equal marks
• Passwords should not be used while saving in the CD/removable storage Medium
• Marked printout of the answers on the sheet
• Hand in all the printouts and the CD/removable storage medium used.

1. Matrix Enterprise invited schools for an annual software development contest. The following is a standard letter inviting schools for the contest.
   
   
   1. Using word processor prepare the document as it appears and saves it as Matrix 1 (22 marks)
   2. Set the working area as follows:
      1. Page margins as follows: (4 marks)
         • Top : 0.5” (1.27) cm
         • Bottom: 0.5” (1.27) cm
         • Gutter: 0.2” (0.51) cm
      2. Paper Size : A4 (1 mark)
   3. Format the heading “MATRIX ENTERPRISE” as follows: (3 marks)
      • Alignment: Centre
      • Font size: 36
      • Font type: Algerian
   4. Insert header “Your name and Index number” (2 marks)
   5. Apply the following to the paragraph starting with “The contest will involve the....”
      • First line indent By 1.2 (4.7”). (2 marks)
      • Line spacing to 1.2 (1 mark)
   6. Format the text “interschool annual software development contest” as follows: (3 marks)
      • Apply shadow
      • Font type: Calibri
      • Shade the text with any color
   7. Spell check your work (1 mark)
   8. Save the document as Matrix II (1 mark)
   9. Insert page numbering at the bottom center of each page. (1 mark)
   10. Compute the total cost for each area and the total amount in the table. (2 marks)
   11. Apply bullets to the list in the table. (2 marks)
   12. Convert all the text from the paragraph starting with “Schools are encouraged to participate
       ….” into two columns of the same width and height, with a line between the columns. (3 marks)
   13. Print the following: (2 marks)
       • Matrix I
       • Matrix II
2. Due to the government directive on registration of all inhabitants of a country. County school directors were deployed to various schools within the Country. The worksheet below is a sample of the NEMIS registration data across the schools in Uasin Gishu County.
   

   SCHOOL	REGISTERED POPULATION		TARGET POPULATION	NON- REGISTERED	REG. FEES (shs)
   	MALE	FEMALE
   Jamboni	200 000	150 000	600 000		500
   Sacho	230 000	312 000	457 000		700
   Moi	450 000	352 252	1 320 254		800
   Kokwet	258 368	122 356	658 870		790
   Rabai	325 620	104 520	700 658		450
   Chepkube	123 863	80 588	325 789		700
   Kabarak	136 222	150 520	356 102		450
   Mbooni	253 666	210 000	492 250		250
   Karo	253 666	213 650	700 000		400
   TOTAL
   AVERAGE

   1. Create a workbook to store information and save it as NEMIS in worksheet 1. (10 marks)
   2. Create a duplicate copy of Sheet1 and Paste it in sheet 2 ,rename worksheet 2 as NEMIS 1 (1 mark)
   3. Use a formulae/function to compute:
      1. Non registered students per school (3 marks)
      2. Introduce a new column called percentage ‘(%) REGISTERED’ and use it to calculate percentage of registered students per school to 2 decimal places. (5 marks)
   4. Insert a new column after the registration fee and name it as REMARKS. Use the IF function to declare the following remarks about the % registered per school. (6 marks)
      “Above expectation” Above 90%
      “Met Expectations” 70% - 89%
      “Below Expectations” 20 % - 79%
      “ Report to The Office” < 20%
   5. Use a function count the number of schools whose % REGISTERED is:
      1. Below expectations in cell G18 (2 marks)
      2. Use the function to fill the totals and averages in the table (2 marks)
   6. Format the workbook as follows
      1. Bold the titles and center it across the page in a merged cell and Times New Roman. (2 marks)
      2. Apply border to a blank cell in the worksheet as follows
         • Double line for the outer border,
         • Dotted lines for the horizontal inside border
         • Dashed lines for the vertical inside border. (3 marks)
      3. Format the registration fees to Kshs. and give the sum of the registration fees (2 marks)
   7. Copy the entire NEMIS 1 worksheet to a blank sheet and rename the new sheet as NATIONAL NEMIS. (2 marks)
   8. Design a bar graph of showing a comparison of both genders in all schools. Label the chart appropriately. Save it as CHART. (5 marks)
   9. Insert your name, date and index number as a header in each worksheet. Insert your class as a footer. (4 marks)
   10. Print NEMIS 1, NATIONAL NEMIS and CHART (3 marks)

Marking Scheme