Computer Studies Paper 2 Questions and Answers - Kapsabet Highschool Mock Exams 2022

Share via Whatsapp

Questions

INSTRUCTIONS TO CANDIDATES

  • Write your name and index number at the top right hand corner of each print out.
  • Write your name and index number on the diskette.
  • Write the name and the 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 diskette.
  • All answers MUST BE saved in your diskette.
  • Make a print out of the answers on the answer sheets provided.
  • Arrange your printouts and tie/staple them together and use the best fit i.e. landscape or portrait for your printouts.
  • Hand in a folder with your name.

 

  1.    
    1. Using a Word Processing package, type the congratulatory note below as it appears and save it as CONGRATS. (15mks)

       MAGS Software Co. Ltd
      P.O. Box 5678
      Kericho
      (Insert today’s date)

       

      <<First Name>><<Last Name>>
      <<Address>>
      Dear<<First Name>>

       

      RE: CONGRATULATIONS

      Due to your hard work and sacrifices you made this year, the company wishes to congratulate you for emerging the best in our internal interview that you applied for. Your new position will be <<Position>> and your new salary scale will be<<Amount>>.

      Yours faithfully,

      Gregory Bruce
      PERSONNEL

    2. Create a data source with the following details and use it with the note you have just typed to generate personal notes to the company’s named personnel. Save it as Details. (15mks)
       George Kinoti 
      P. O. BOX 5678 
      Kericho 
      Software Developer 
      Ksh.125000
       Wilberforce Kenya
      P. O. BOX 5678 
      Kisumu 
      ICT Officer 
      Ksh.125000 
       Henry Odongo
      P. O. BOX 5678
      Kilgoris
      Database Admin
      Ksh.125000
       Grace Akinyi
      P.O. BOX 5678 
      Nakuru
      System Admin 
      Ksh.120000 
       Beth Mugo
      P. O. BOX 5678 
      Migori 
      Secretary 
      Shs.30000 
       SharonWangoi
      P. O. BOX 5678
      Nandi-Hills|
      Accountant
      Shs.45000
    3. Insert data fields in main document and generate the notes for the employees.(14mks)
    4. Print the notes. (6mks)
  2.  
    1. Create a database called SCHOOL. (2 Marks)
    2. Create three tables EXAMINATION, DOS and BOARDINGwith the fields as shown below. (10Marks)
    3. Create a relationship between the three tables and enforce integrity. (6Marks)
    4. Enter the data items in the given tables three tables. (15Marks)
           EXAMINATIONS
       Admission Number Mathematics  English  Kiswahili  Biology 
       1 45  67  90  23 
       10 45  89  90  20 
       2 45  70  80  45 
       3 89  90  90  20 
       4 78  90  50 
       5 67  89  60  90 
      6 67 90 7 80
      7 34 78 70 90
      8 23 50 38 90
      9 23 15 67 20


      DOS     
      Admission Number  SName  Other Names  KCPEMark   Year of KCPE
      PETER  BARASA  327  2007 
       10 JOHNSON SUK  250  2001 
       2 ALEX  OJWANG’  340  1998 
       3 BELINDA  ESTHER  250  2008 
       4 BRAMWEL  RAYMOND  450  2007 
       5 ALEX  WAMWANA  410  2003 
      6 JANET KILONZO 400 2000
      7 MATHEW KARIUKI 450 1999
      8 NASIMIYU CATHEEN 290 2003
      9 KIMATHI JOHN 3000 2001



      BOARDING    
      Admission Number  UNIFORM  TOOL  TOOL NAME 
       1 No  12  JEMBE 
       10 Yes  20  JEMBE 
       2 No  11  PANGA 
       3 Yes   SLASHER
       4 Yes  111   JEMBE
       5 No  15  RAKE 
      6 Yes 22 BASIN
      7 Yes 11 BROOMS
      8 Yes 90 RAKE
      9 Yes 23 BUCKET
    5. Design a query that would display the following fields as shown below and write down the formulae for getting the total score and criteria for extracting the records below (10 Marks)
       Admission Number  UNIFORM  SName   KCPEMark  Mathematics English  Kiswahili  TOTAL SCORE 
       1 Yes   BELINDA 250  89  90  90  269 
       10 Yes   BRAMWEL 450  78  90  177 
       2 Yes    JANET 400  67  90  164 
    6. Design a report that would sort the following in ascending order in the order of the following fields, Total score, KCPE Score, SName the Admission Number and the report should display all the fields. Save the report as administration (5Marks)
    7. Print, administration and admin (2Marks)

Marking Scheme

  1.        
    1. Correct creation of a database. (10mks)
    2.      
      1. Using appropriate foreign primary key. (2mks)
      2. Using appropriate foreign key. (2mks)
    3. Proper validation. (4mks)
    4. Each form with proper data entry. (4mks)
    5. Proper date entry. (5mks)
    6. Query well created. (4mks)
    7. Proper report with all details. (4mks)
    8.        
      1. Correct query. (4mks)
      2. Appropriate pie chart report. (5mks)
    9. Each correct print out 1 mark each.
  2.  
    1. Creating a database called SCHOOL. (2mrks)
    2. Create three tables Examination, DOS and BOARDING with the fields as show below. Every table one mark and each field a half a mark each (10mrks)
           Examinations
       Admission Number  Mathematics  English   Kiswahili   Biology 



           DOS
       Admission Number  SNAME   OtherNames   KCPEMark   Year of KCPE 



      BOARDING
       Admission Number  Uniform  Tool   ToolName  Biology 
    3. Creating a relationship between the three tables 4 marks and enforcing integrity.2 marks
    4. Entering the data items in the given tables three tables as shown below a half a mark for each well filled row. To a maximum of 15 marks.

      EXAMINATIONS,DOS,BOARDING
    5. Criteria yes 2 marks, mathematic > 50 2 marks and formulae TOTAL SCORE:
      [Mathematics]+[English]+[Kiswahili] 5 marks , 2 marks for saving.
       Admission Number  Uniform  SName  KCPE Mark   Mathemtics   English   Kiswahili  TOTAL SCORE 
       1  Yes   BELINDA  250    89   90  90  269 
       10  Yes   BRAMWEL  450   78   9   90   177 
       2  Yes   JANET  400   67  90  164 
    6. Designing a report that would sort the following in ascending order in the order of the following fields.
      Total score, KCPE Score, SName the Admission Number and the report should displaying all the fields 3 marks . Saving 2 marks
    7. Printing 1 mark for each document. 

Download Computer Studies Paper 2 Questions and Answers - Kapsabet Highschool Mock 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
.
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?