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

Share via Whatsapp

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.
    cOMPp2q01
    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

   QUESTION 1     QUESTION 2   
 Item  Description  Max
Score
Score    Item  Description  Max
Score
Score 
 (a)  Create Matrix I     (a)   Workbook NEMIS 1    
   Correct case  1        Case 0.5   
   WordArt  1        Worksheet1   
   Correct style  1        All Headings 7 @ ½   3.5  
   Double underline4 @ ½  2        All Border  1  
   Title- Italic and Centre Alignment  1        Merge Cell   1  
  Zigzag/Single underline 2 @ ½ 1       Bolding Heading any 4@ ½  2  
  Drop cap 1     (b) Renaming Sheet to NEMIS I  1  
  Table creation ,Shading and strikethrough @ 1 ½ each 4.5     (c) Non registered = Target population-(male+female) 3  
  Correct table content 7 rows@ ½ 3.5       Create column Registered  1  
  Page Border 1 1       Compute Registered % 3  
  All bold (Atleast five lines of text) 2.5       % in 2 decimal 1  
  Superscript 3@ ½ 1.5     (d) Insert Remark Column   1  
(b) Portrait , Gutter ,Page size 3@1 3       Correct Function Name  1  
  Top and Bottom Margin 2@ 1 2       Correct 4 conditions @1   4  
(c) Changing Matrix Enterprise 3 @1  3     (e) Function to Count  2  
(d)  Header and correct content 2@1 2        Function to Average   1  
(e)  First line indent 2        Function to Total  1  
  Line Spacing 1.2  1     (f) Bold titles   1  
(f) Applying Shading  1       Font times Romans  1  
  Font type Calibri  1       Double line outer border 1  
  Shade the text with any color  1       Dotted line horizontal Inside  1  
(g) Spelling Checking 1       Dashed Vertical Inside  1  
(h) Saving Matrix II Name and Case 1       Format Registration (Ksh)  2  
(i) Page Number Bottom Centre 1     (g) Copy NEMIS I  1  
(j) Computer Total  2       NATIONAL NEMIS  1  
(k) Apply Bullets to Table list 2     (h) Chart and Chart title  2  
(l)  Two columns and line 3@1 3       Axis X and Y , Legend @1  3  
(m) Print Matrix I and Matrix 2@1   2     (i) Footer Class   1  
            Header Name, Index and Date 1   3  
          (j) Print NEMIS I  1  
            Print NATIONAL NEMIS  1  
            Print CHART  1  
  TOTAL 50         50  

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


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Join our whatsapp group for latest updates
Get on WhatsApp Download as PDF
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?