Kenya Certificate Of Secondary Education(KCSE 2013) Computer Studies Paper 2 with Marking Scheme

1. Table 1, table 2 and table 3 are extracts of records kept in a health centre for patients, doctors and consultations respectively.
   

   Patients numbers	Names	Year of Birth	Gender
   0120 0121 0122 0123	Jean Paul  Alice Allan	1970 1982 1976 1998	Female Male Female Male

   Table 1
   

   Doctors numbers 520 521 522 523

   Names Charles Beatrice James Isaac

   Table 2
   

   Consultation Number	Consultation Date	Patient Number	Doctor Number	Ailment
   101 202 303 405 507 608 704 808 901 1021	07/09/2012 09/09/2012 13/09/2012 14/09/2012 15/09/2012 16/09/2012 16/09/2012 17/09/2012 30/09/2012 01/09/2012	0120 0123 0121 0120 0121 0122 0123 0121 0122 0123	520 521 522 520 522 521 523 522 521 523	flu malaria cough flu cough malaria measles cough malaria measles

   Table 3
   1.    
      1. Using a database application package, create a database file named PATIENTSINFO
      2. Create three tables named PATIENTS, DOCTORS and CONSULTATIONS that will be used to store the data in table 1, table 2 and 3 respectively (14 marks)
      3. Set the primary key for each table. (3 marks)
      4. Create the relationships among the tables. (2 marks)
   2.    
      1. Create a data entry form for each table. (3 marks)
      2. Enter the data in table 1, table 2 and table 3 into the Patients, Doctors and Consultations tables respectively. (9 marks)
   3.    
      1. Create a query named PatientAge to display Patients’ Names, Gender and Age on the year of visit. (4 marks)
      2. Create a query named Beatricedetails to display Patients’ Names, Ailment and Consultation Dates for patients treated by Doctor Beatrice. (3 marks)
   4.    
      1. Create a report to display the Patients’ Names, Consultation Dates, Ailments and the Names of the Doctors consulted. The records in the report should be grouped by Patients’ Names and the number of consultations by each patient should be displayed. (5 marks)
      2. Title the report as “Consultations Per Patient” and save it as Consultations. (2 marks)
   5. Print the following:
      
      1. Tables: Patients, doctors and consultations; (1 mark)
      2. Queries: PatientAge and Beatricedetails; (1 mark)
      3. Report: Consultations; (1 mark)
      4. Form: Consultations. (1 mark)
2. The Figure on page 5 shows the design of the cover page of a book. It comprises of the front, the back and space in between where book pages will be attached. Use a desktop publishing package to design the cover page as follows:
   
   1. Create a new publication named book cover with the following page layout.
      
      1. paper size: A4,
      2. orientation: landscape,
      3. margins: 3 cm or 1.18 inches all round. (4 marks)
   2. Enter the text and objects and format them as they appear in the Figure. The front and back sections of the book cover, each measures 18 cm (7.1 inches) by 12.5 cm (4.9 inches) and the space between them measures 1.7 cm (0.7 inches). (45 marks)
   3. Save and print the publication. (1 mark)
      

MARKING SCHEME

1.    
   1.    
      1. Creating a database named PATIENTSINFO Caps ½ mark, lower ½ mark or none 
      2. Table 1
         Creating and naming the table (Patients) ½ mark
         Creating and naming fields (underscored or joined or spaced)
         4 fields @ mark each
         Correct field data types
         Table 2
         Creating and naming the table (Doctors)
         Creating and nami ng fields
         Correct data types: 2 @ mark each 
         Table 3
         Creating and naming the table (Consultations) 
         Creating and naming fields
         5 @ ½ mark each
         Correct data types 
      3. Primary keys
         Table 1: Patients number 1 mark
         Table 2: Doctors number 1 mark
         Table 3: Consultation number 1 mark 
      4. Two relationships (correct fields)
         2 @ 1 mark each 2
         20 marks
   2.    
      1. Creating data entry forms (forms with all fields)
         3 @ 1 mark 
      2. Data entry - 18 records 
         (all correct fields) 
         12 marks
   3.    
      1. Display of patient names and gender
         Naming query - Patient Age 
         Computation age column
         Age(Year[consultation date]-[year of birth])
      2. Selecting correct fields - Name Ailment mark,
         Consultation date mark, Criteria - Beatrice
         Doctor name = “Beatrice” 1 mark 
         Saving the query - Beatricedetails 
         7 marks
      3. Selection of tables patients and doctors 
   4.    
      1. Selection of fields 4 (Names, Consultation date, ailment, names of doctors) 
         Grouping (patient name) 1 mark
         Grouping total (count of number of consultations) 1 mark
      2. Saving the report - Consultations 1 mark
         Report title - Consultations per patient 1 mark 
         7 marks
   5.    
      1. Printing 3 tables 
      2. Printing 2 queries 
      3. Printing 1 report 
      4. Printing 1 form (consultation)
         4 marks
2.    
   1. Margin - page layout 4 
      Orientation (order/arrangement of back/spine/front)
      Paper size 
      Saving (Book Cover) 
      Fit of the three parts - back, spine and front 
      5 marks
      FRONT COVER
   2. Authors / Rectangle
      Text typing text either case 
      Text box positioning/text position at centre 
      Insertion of Rectangle/text-box 
      Fill type (gradient shading)/gradient centre 
      Positioning the rectangle 
      Size 
      Inserting textbox/thick outline border 
      4 marks
      Book title
      text typing (capital) text + title case 1 mark
      positioning in relation to the front cover 
      Computer 
      Position of the computer 
      Drawing four polygons 
      Filling polygons 4 penalise mark for wrong shading
      Stars
      Six sided star / 5 sided and 8 sided 
      No outline 
      Fill pattern 
      Positioning star 1 and star 2
      Copying and pasting star 
      Lower rectangle 
      Positioning 
      Sizing 
      Outline (bigger)
      Filling (fill) different from the border
      2 marks
      Revised edition triangle
      Right angled triangle 
      Positioning 
      Fill (white) - no shade 
      Text typing (award mark is test is in one line)
      Textbox rotation 
      2 marks
      Quick revision guide
      Typing text (text & caps + initial) 
      Background colour of the text box 
      Positioning of textbox 
      2 marks
      Nyota Publishing Press 
      Typing Text Text case 
      Positioning of textbox 
      2 marks
      Spine
      Typing of text (text & case) 1 mark
      Rotating 1 mark
      Positioning of text box mark
      Background (fill pattern) ma rk
      Fitting in between mark 1
      2 marks
      Star
      Spine star
      Resizing/ 1 star fitting inside the spine mark
      Shading mark
      Copying star/existence of the star mark
      Positioning mark
      Positioning star 2 mark 
      2 marks
      2 marks
      BACK PAGE
      Big rectangle 
      Outline (thick border) 
      Fitting 
      Filling/any fill 
      Positioning 
      2 marks
      Rounded rectangle 
      Outline (none) 
      Filling (no fill)/ white 
      Positioning/placement 
      Sizing/fitting proportional to the rectangle 
      Correct shape mark 2 marks
      Text in rounded rectangle
      Typing text 4 paragraphs (existence and completeness 
      Bullets (style & character) 
      Paragraphing (spacing) 
      title case -last paragraph 
      6 marks
      ISBN rectangle
      Text ISBN 214s
      Bars varying thickness 
      Position of ISBN and Bars 
      No fill ISBN and bars 
      3 marks
      Text at bottom 
      Copyright symbol 
      Text and case 
      Positioning 
      2 marks
      Printing