KCSE 2019 Computer Studies Paper 2 Questions With Marking Scheme

1. Form 1 Class Teachers of Mwango Secondary School intend to use a datab students performance in three examinations: opener, mid term and end
   1. Open a database program and create a database named analysis. (1 mark)
   2.  
      1. Create three tables named Class StudDetails and Stud Marks in the database file created in (a) using the following details: (14 marks)
         
         Class Table
         

         Field Name	Data type and Properties
         ClassID	Text (size 2)
         ClassName	Text (size 25)
         Teacher	Text (size 25)

         
         StudDetails Table
         

         Field Name	Data Type and Properties
         Ad No	Number
         StudName	Text (size 25)
         Gender	Yes/No(Yes for Female)
         ClassID	Text (size 12)  Look up values, 1E, 1N, 1W

         
         StudMarks Table
         

         Field Name	Data Type and Properties
         AdNo	Number
         Opener	Number
         MidTerm	Number
         EndTerm	Number

      2. Create the relationships between the tables. (2 marks)
      3. create a form for the Class table and add a subform for the StudDetails tahle using the format in figure 1. Save the form as dataentry. (4½ marks)
         
      4. Enter the following data into their respective tables in the database (12½ marks)
         
         Class Table
         

         ClassID	ClassName	Teacher
         1E	Form One East	Elvis Barongo
         1N	Form One North	Alice Nadiya
         1W	Form One West	Paul Mkacharo

         
         StudDetailsTable
         

         AdNo	StudName	Gender	ClassID
         7984	Mary Kikoti	Female	1E
         7460	Erica kamburi	Female	1E
         7800	Axlam Khan	Male	1E
         8083	Martin Mkanjala	Male	1E
         8092	Esther Peresian	Female	1N
         8490	Micah Likoyoto	Male	1N
         8082	Mohamed Ayan	Male	1N
         7896	Mark Kwalima	Male	1W
         7892	Morgan Lema	Male	1W
         8184	Emily Mawasi	Female	1W
         8047	Edward Omogeni	Male	1W

         
         StudMarks Table
         

         AdNo	Opener	MidTerm	EndTerm
         7984	85	76	82
         7460	73	84	79
         7800	78	79	86
         8083	81	75	87
         8092	73	76	83
         8490	71	71	87
         8082	81	70	90
         7896	88	85	88
         7892	85	84	89
         8184	85	81	83
         8047	90	75	86

   3. Create a query to display the fields:
      1. AdNo, StudName, ClassID. Opener. Mid Term and End Term for all students in Form One East. Save the query as FIE. (4 ½marks)
      2. AUNO, StudName, ClassID. Opener. Mid Term and End Term and a calculated neld named meanscore to display the average in the three examinations. Save the query as overall. (6 marks)
   4. Create a report to display details of each student as it appears in Figure 2. (2½ marks)
      
   5. Print out each of the following
      1. the three tables
      2. the two queries
      3. report for the first two students
2. The Chief Printer of Zenith Printers Company would like to have business cards. As a Desktop Publishing (DTP) expert, you have been tasked to design the card for the officer.
   1.  
      1. Open a Desktop Publishing program and set the page layout as follows:
         • Paper size: 8.5 cm width by 5.5 cm height
         • Layout type: multiple pages per sheet
         • Target paper size: A4
         • Orientation: Portrait
         • Margin: 0.75 cm all round (5 marks)
      2. Save the publication as business card. (1 mark)
   2. Design the card as it appears in Figure 3 ensuring that the card covers all the space in the page. (42 marks)
      
   3. Print out 10 copies of the card on a single A4 page. (2 marks) 

MARKING SCHEME

1.      
   1.        
      1. = Creating the file @ 1
   2.          
      1.     
         • Creating class table
           • Creating the table as @½
           • Applying correct datatype for 3 fields @½= 1½
           • Applying correct field size(@1½
         • Creating studDdetails table
           • Creating the table @½
           • 4 fields @½=2
           • Applying correct data type @½=2
           • Applying correct properties = ½
           • Look up values @=1
         • Creating of StudMarks table
           • Creating the table @½=2
           • Data type 4 fields (@y=2
           • properties="4
      2. Relationship (two each (al) = 2 (111)
      3. Creating Forms
         • Insertion of a form object @½
         • Insertion of 3 text boxes @½=1½
         • Insertion of 3 labels @½ = 1½
         • Insertions of the subform @1
      4. Data entry (in the three tables)
         • 25 records each @½ = 12½
   3.         
      1. FIE Query
         • Insertion of query @½
         • Insertion of 6 fields @½ = 3
         • Applying constraints (form 1E) @½
         • Saving @½
      2. Overall query
         • Query insertion @½
         • Insertion of 6 fields @½=3
         • Inserting a calculated field @1
         • Performing calculations @1
         • Saving @½
      3. Report
         • Insertion of header @1
         • Dropping the correct fields @1
         • Applying formats (Arrangement of controls) @½
      4. Printing
         • 3 tables @½ = 1½
         • 2 queries @½ =1
         • 1 report @½
2.            
   1. Page layout
      • Each layout specification @1 = 5
      • Saving @1
   2.         
      • Card Border line
        • Rectangle @1
        • Applying curved corners @1
        • Line thickness @½
        • Arrangement of elements @ 1
      • Zenith printers (black section)
        • Rectangle @1 & semicircle @1
        • Black filled @1
        • Text only @1
        • Text colour @1
        • White edge @1
        • Arrangement of elements @1
      • Ngele Kikomi ...
        • Text only @ 2
        • Applying underline @½
        • Applying bold @½
        • Arrangement of elements @1
      • University Drive ...
        • Text only @2
        • Text formatting @½
        • Arrangement of elements @½
      • Arrow head dots
        • Drawing of circle dot @1
        • Arrangement of dots @ 1
        • Relative position on the card @½
      • Printer Logo
        • 2 rectangles each @½ = 1
        • Round edge on the rectangle @1
        • Thick line @1
        • Thin lines @1
        • parallel thin lines @1
        • Applying white background (to hide sections of lines) @1
        • arrangement of elements @1
      • We create text
        • Text only @2
        • Bullets @1
        • Applying white colour/background @ 1
        • Arrangement of elements @1
      • Tilted lines bars
        • Rectangular outline @1
        • Applying filled pattern @1
        • Positioning @1
        • Removing borders (@1
      • Quality service
        • Text only @1
        • Italics formats @½
        • Positioning @½
      • General Card layout
        • Coverage > 80% of the page @1
        • Use of appropriate font sizes @1
        • Use of appropriate line weights @1
      • Printing
        • Print a card @ 1
        • Printing 10 cards per paper @l