Computer Studies Paper 2 Questions and Answers - Momaliche Post Mock 2020 Exam

Share via Whatsapp

INSTRUCTIONS TO CANDIDATES

  • 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.
  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.125,000
        
      Henry Odongo
      P. O. BOX 5678
      Kisumu 
      ICT Officer
      Ksh.125,000

      Wilberforce Kenya
      P. O. BOX 5678
      Kilgoris
      Database Admin
      Ksh.125000 

      Grace Akinyi
      P.O. BOX 5678
      Nakuru
      System Admin
      Ksh.120,000

      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  
      3 89 90 9  
      4 78 9 89  
      5 67 89 90  
      6 67 90 78  
      7 34 78 50  
      8 23 50    
      9 23 15    

      DOS
      Admission Number   S/Name    Other Names   KCPE Mark    Year of KCPE 
      1 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 300 2001 

      BOARDING
      Admission Number   UNIFORM   TOOLS  TOOL NAME 
      1 No 12 JEMBE
      10 Yes 20 JEMBE
      2 No 11 PANGA
      3 Yes 1 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)
      ADMIN
      Admission Number  UNIFORM   S/Name  KCPE Mark   Mathematics   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  7  164
    6. Design a report that would sort the following in ascending order in the order of the following fields, Total score, KCPE Score, S/Name 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   S/Name   Other Names   KCPE Mark   Year of KCPE 

                                            BOARDING
       Admission Number   Uniform   Tool   Tool Name   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
      Criteria yes 2 marks, mathematics > 50 2 marks and formulae TOTAL SCORE
      [Mathematics]+[English]+[Kiswahili] 5 marks , 2 marks for saving.
      Admission Number  UNIFORM   S/Name  KCPE Mark   Mathematics   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  7  164
    5. Designing a report that would sort the following in ascending order in the order of the following fields.
      Total score, KCPE Score, S/Name the Admission Number and the report should displaying all the fields 3 marks . Saving 2 marks
    6. Printing 1 mark for each document.

Download Computer Studies Paper 2 Questions and Answers - Momaliche Post Mock 2020 Exam.


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?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest