Computer Studies Paper 2 Questions and Answers - Joint Pre-Mock Exams 2021/2022

Share via Whatsapp

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 Compact Disk.
  • 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 Compact Disk.
  • All answers MUST BE saved in your CD.
  1. Xyz hospital intends to use a database to manage doctors and patients’ records.
    1. Open a database program and create a database named XYZ hospital. (1mk) 
    2.  
      1. Create three tables named tbldoctor, tblpatient and tblailment in the database file created in (a) using the following details. (8mks)
        tbldoctor
         Field Name    Data Type and Field properties 
         Doctor_ID  Text
         First Name  Text(size=10)
         Last Name  Text(size=10)
         Specialization   Text(size=1=20)

        tblpatient
         Field Name    Data Type and Field properties 
         S_No  Autonumber
         Patient_No  Text
         Patient Name   Text
         County  Text
         Age  Number
         Gender  Yes/No (yes for Female)
         S_No  Autonumber

        tblailment
         Field Name    Data Type and Field properties 
         Doctors_ID  Text
         Patient_NO  Text
         Ailment  Text
         Date of Visit   Date & time
         Charges  Currency
      2. Set primary key(s) and create relationships between the tables (5mks) 
      3. Enforce referential integrity between the tables (3mks)
      4. Create three input screens with navigation buttons for each table, give your forms appropriate titles (6mks)
      5. Enter the following data into their respective table in the database (10mks)
        tbldoctor
         Doctor_ID   First Name   Last Name   Specialization 
         D_001      Jim     Green     Nephrologist 
         D_002     Lucy    King   Pulmonologist 
         D_003      Bob   Smith    Dermatologist 
         D_004    Alexia    King    Endocrinologist 
         D_005   Nelly   Walk   Neurologist 
         D_006    Freda   Ford    Pulmonologist 

        tblpatient
         Patient_No   Patient Name   County   Age   Gender 
         P_101  Abigael Marie  Nairobi   41   F 
         P_102  Alexa Kate  Nakuru   32   M 
         P_103  Alexander William   Kericho   33   M
         P_104  Brianna Lynn  Kericho   40   M
         P_105  Aiden Lake  Kajiado  24   F
         P_106  Anelia Faith  Bungoma   20   F
         P_107  Alexis Jade  Busia  39   M
         P_108  Benjan Clay  Nairobi  30   M

        tblailment
         S_NO   Doctors_ID   Patient_No  Ailment   Date of visit   Charges 
           1   D_006   P_101  Cold & flu   12/7/2019   2,000
           2   D_005   P_102  Conjuctivitis   14/8/2019   15,000
           3   D_006   P_103  Headaches  15/8/2019   18,000
           4   D_004   P_104  Stomachaches   19/9/2019   5,000
           5   D_004   P_101  Diabetes  20/9/2019   20,000
           6   D_003   P_105  Cancer  28/10/2019   85,000
           7   D_003   P_106  Asthma  2/10/2019   13,000
           8   D_002   P_107  Arthritis  3/11/2019   14,000
           9   D_001   P_108  Tuberculosis  4/11/2019   10,000
           10   D_005   P_102  Cancer  4/11/2019   80,000
      6. Create a query to display the fields;
        1. Patient_ID, Patient Name, Doctor_ID for all patients treated by D_006. Save query as D_006patients. (2mks)
        2. Patient_No, Ailment, Date of Visit and the actual charges if 5% discount was offered to patients. Save query as patientpayments. (3mks)
        3. Doctor_ID, First name, Last Name and specialization; combine First name and Last name, Save query as DoctorName. (3mks)
        4. Doctor_ID, First name, Last Name and specialization; Sort specialization field in descending order, Save query as Sort. (2mks)
      7. Create a macro for D_006patients query, save query as D_006patients macro (2mks) 
      8. Create a report to display S-NO , Doctors_ID, Patients_No, Ailment and charges.
        The report should display sutotals for each patients charges and the grandtotal, save the report as grand total (5mks)
      9. Print grandtotal report (1mk)
  2.  
    1. Using a Word Processing package, type the congratulatory note below as it appears and save it as CONGRATURATIONS. (15mks)
      Comps Joint PM PP2 Q2 2122
    2. Create a data source with the following details and use it with the letter you have just typed to generate personal letters. Save the file as 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
      Ksh.30000

      Sharon Wangoi
      P.O. BOX 5678
      Nandi-Hills
      Accountant
      Shs.45000
    3. Insert data fields in main document and generate the letters for the employees. (10mks)
    4. Generate individualized envelops for each employee (8mks)
    5. Print the first two letters. (2mks)


MARKING SCHEME

   Q1   Maximum score   Students’ score 
 a  XYZ Hospital      1mk  
 b(i)   Field Names and field properties   8mks @ ½ mk  
 (ii)  Primary keys
Tbldoctor (Doctor ID)
Tblpatient (Patien_No)
Tblailment (S_No)

Two correct Links
    1mk
     1mk
     1mk
     2mks
 
 (iii) Tbldoctor - Tblailment (one to many)
Tblpatient -Tblailment (one to many)

     1mk

     1mk

 
 (iv)  - Input screen for each table.
- Command button(s)
 3mks @ 1mk
 3mks @ 1mk
 
 (v)  Correct data entry
    Tbldoctor
    Tblpatients
    tblailment
   2mks
   4mks
   4mks
 
 (vi)
 a) 
 Correct fields
 Patient treated by D006
    1mk
     1mk
 
 b) Correct fields
Charges after discount
    1mk
   2mks
 
 c)  Correct fields
Combined fields (using a formular)
    1 mk
   2mks
 
 d)  Correct fields
 Sorted field
   1 mk
   1 mk
 
 (vii)   Macro     2mks  
 (viii)  Correct fields
Subtotals
Grandtotals
 1mk
 2mks
 2mks
 
 (ix)  Printed report  1mk  
     50mks     
     Q2  Maximum score   Students’ score 
 (a) Letter
Address typing
Company logo
Letter typing
Letter formattings
Autoshape
Autoshape fill color
Autoshape behind text
 1mks
 3mks
 3mks
 3mks
 2mks
 1mk
 2mks
 
 
 (b) 6 contact information correctly typed.
Data source saved as
Personnel.
 12mks @ 2mks

       3mks
 
 (c)  6 personalized letters     10mks  
 (d)  6 personalized envelopes     8mks  
 (e)  Printing  2mks  @ 1mk  
Join our whatsapp group for latest updates

Download Computer Studies Paper 2 Questions and Answers - Joint Pre-Mock Exams 2021/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


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