COMPUTER STUDIES PAPER 2 Marking Scheme - 2017 KITUI MOCK EXAMINATION

1.  
   
   1. KIRUI’S MILLING COMPANY LIMITED
      P.O BOX 625 NAKURU
      

      	First quarter			Second quarter
      	January	February	March	April	May	June
      Production cost	15642	14687	18741	19457	15412	15441
      Transport	1564	1469	18784	1946	1541	1544
      Warehousing	1125	1056	1347	1369	1107	1109
      Promotion	2564	2407	3071	3188	2525	2530
      Salary	4525	4248	5420	5626	4456	4465

      • Bold + centered + underlined        @ l mark = 3marks      Bold + centered + underlined each 1mark = 3marks
      • Boarders                                       = 2marks
      • Correct alignment                          = 2marks
      • All entries correct                           = 7marks
      •  One wrong entries                         = 5marks
      • Two wrong entries                           = 3marks
      •  Three wrong entries                        = 3marks
      • Wrong entries                                  = 0
   2.  
      1. Worksheet correctly copied to sheet = 2  = 2marks
      2. = 2marks for tithe “Total”
         = 2marks for correct formula for total production cost.
         KIRUI’S MILLING COMPANY LIMITED
         P.O BOX 625 NAKURU
         

         	First quarter			Second quarter
         	January	February	March	April	May	June	Total	2mks
         Production cost	15642	14687	18741	19457	15412	15441	9938	2mks
         Transportation	1564	1469	18784	1946	1541	1544	99380	1mk
         Warehousing	1125	1056	1347	1369	1107	1109	7142	1mk
         Promotion	2564	2407	3071	3188	2525	2530	16285	1mk
         Salary	4525	4248	5420	5626	4456	4465	28740	4mk

         
         

         Total expenses any 4 correct 4 marks	25420	23867	30453	31615	25041	25089	161485
         Percentage of total expenses 4 marks	15.7414	14.7797	18.8581	19.5777	15.5067	15.53364

         
         
      3.  4 marks (any 4 correct)
   3.   
      

QUESTION 2 - DATA BASES

EMPLOYER 1

• Data base file created                                                                = 1 mark         
• Emp No set as primary key                                                        = 1 mark
• Correct table structure with all fields                                           = 4 marks
• Correct Record Entry                                                                  = 6 marks

EMPLOYER 2

• Profession field inserted                                                               = 2 marks
• Deduction field inserted                                                               = 2 marks
• Profession data correctly entered                                                  = 3 marks
• Reduction data correctly entered                                                   = 3 marks
• Records sorted in ascending order based on the name field             = 3 marks

LIST 1

• A well-constructed query showing all fields                                = 4 marks
• Date criteria set i.e. > = 1/1/1960 # and #31/12/1972 #           = 2 marks
• Profession criteria set i.e. ‘accountant’ ‘nurse’ ‘doctors’ = 2 marks

LIST 2

• Removal of date and profession criteria                                   = 2 marks
• Formula for calculated field i.e. net pay (Gross Pay) (deduction) = 2 marks
• Correct values for Net Pay                                                      = 3 marks

REPORT

• Report set to columnar                                                           = 2 marks
• Correct fields i.e. Emp No, Name, profession, Net pay               = 4 marks
• Printed employee 1, employee 2, List 1, and report                   = 3 marks