COMPUTER STUDIES PAPER 2 - 2019 KCSE TAP TRIAL MOCK EXAMS (QUESTIONS AND ANSWERS)

INSTRUCTIONS TO CANDIDATES

• 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 CD/removable storage medium provided.
• All answers must be saved in your CD/Removable storage provided.
• Make a printout of the answers on the answer sheets provided.
• Hand in all the printouts and CD/Removable storage medium

1.  
   1. Using the information below, design an appropriate spreadsheet and enter the following data, Give the table an appropriate Title. Save as D: ACTIVITY 1       (12mks)
      Khadija scored 89 in English. 76 in Biology, 56 in Computer, 90 in Kiswahili and 48 in Math's. Peter scored 78 in English, 89 in Biology, 67 in Computer, 90 in Kiswahili and 34 in Math's. Jane scored 70 in English, 93 in Biology, 34 in Computer, 23 in Kiswahili and 69 in Math's.   Tasneem scored 72 in English, 36 in Biology, 79 in Computer, 85 in Kiswahili and 56 in Math's   Rashid scored 90 in English, 98 in biology, 89 in Computer, 100 in Kiswahili and 35 in Math's.
   2. Calculate the total marks for each student   Label it appropriately. Write on the paper provided the formula used for Tasneem.    (6mks)
   3. Calculate the average for English, Biology, Computer, Kiswahili and Math's and Total score for the class. Label this average appropriately and write on the paper provided the formula for obtaining these average marks for Computer. Save as D:' Activity 2      (8mks)
   4. Arrange the records in a descending order by total score.                                                           (4mks)
   5. Count all students whose total score is above 60% and place your result in an empty cell. Label the result appropriately   Write on the paper provided the formula used. Save as D: Activity 3. (6mks)
   6. The school would like the remark PASS for students whose total score is 50% and above and FAIL otherwise. Generate an appropriate cell. Label the row/column as REMARK, Write down the formula used for Peter. Save as D: Activity 4.       (6mks)
   7. Plot a bar graph for the following averages. English, Biology, Computer, Kiswahili and Math's Add a title and label the X and Y axes appropriately. Save your graph as D: Activity G. (6 Marks)
   8. Print Activity1, Activity 3, Activity 4 and Activity (2mks)
2.  
   1. Create a database file named D:HOTELS to store the following data. Make the passport Id unique record identifier (the primary key)           (20marks)
      

      NAMES	PASSPORT	AGE	MALE	HOTEL	HOTEL CHARGE	DATE OF VISIT
      Bank Moon	UN017/98	42	YES	SERENA	$3’000.00	3.02.98
      Barbara Bush	US009/98	58	NO	INTER-CONTINENTAL	$6,000.00	2.12.98
      Hilary Clinton	USO15	38	NO	WINDSAR	$7,000.00	1.02.98
      Nana Anan	UNO16/98	42	NO	HILTON	$8,000.00	1.10.98
      Akata Mary	UG013/98	68	YES	HILTON	$4,500.00	1.02.98
      Jakaya Kikwete	TZ001/98	68	YES	HILTON	$6,300.00	1.05.98
      Desmond Tutu	SA007/98	79	YES	WINDSAR	$7,000.00	3.04.98
      Mashell Graca	MG011/98	51	NO	INTER-CONTINETAL	$10,000.00	3.05.98
      Kennedy Njoroge	KE001/98	45	YES	LAICO	$6,000.00	1.06.98
      Margaret Thatcher	GB010/98	72	NO	SERENA	$9,200.00	1.02.98
      Museveni Kaguta	UG00/98	52	YES	WINDSAR	$8,000.00	1.11.98
      Jalal Talabani	IQ005/98	64	YES	LAICO	$3,200.00	3.05.98
      Al Bashir	LB006/98	48	YES	WINDSAR	$11,000.00	3.12.98
      Salva Kilr	SD014/98	50	YES	HILTON	$8,000.00	1.12.98
      Jacob Zuma	SA012/98	67	YES	SERENA	$11,000.00	2.11.98

      
      
   2.  
      1. Sort the table in ascending order of age.
      2. Save the table as D Hotels 2          (3 Marks)
   3. Insert a field that will accommodate the continents of their origin. Note that passport ID UNO 17/98, UN016 98, USOI5/98, US009/98 are from America. UG013/98, TZ001/98, SA007/98, MQ011/98, KE001/98, UG003/98, LB006/98, SDOI4/98, SDO14/98 AND SAO 12/98 from Africa 1Q005/98 Asia and GB010/98 Europe. Save as D: Hotels 3  (6marks)
   4.  
      1. Create a query that contains the field passport ID, Names, Date of Visit, Hotel Charge and age for all members who visited Kenya hotels after 2/12/98 and are above 60 years of age or their Hotel charge paid is less than $ 7,000.00 Write down the query expression used. Save as D: QueryH (6 Marks)
      2. Create a total query that will give total hotel charges .Save as D:QueryT             (4marks)
   5.  
      1. Excluding the male field, create a report and give it a title " President Visit"                     (6marks)
      2. Save the report as D: Report P  (2Marks)
      3. Print Hotels, Hotels 2, Hotels 3, Query H, Query T, Report P                                                         (3mks)

MARKING SCHEME

DISTRIBUTION OF MARKS

1.  
   1.  
      • 2mks for correctly labelled column. Penalise ½ mk for each any incorrectly labelled column.
      • 2mks for correctly labelled row. Penalise ½ mk for each any incorrectly labelled row.
      • 8mks for accurately entered data. Penalise ½ mk for each incorrect ly entered data.
   2.  
      • ½ mk for correct label “total”
      • ½ mk for each correct total                                             ½ x5= 2 ½ mks
      • 2mks for correct formula.
      • 1mk for the correct reference of Tasneem in the formula.
   3.  
      • 1mk for each correct average marks                               1x6=6mks
      • 1mk for correct formula
      • 1mk for the correct reference of computer in the formula.
   4. 4mks for the correct arranging of the records in the correct order and details.
   5.  
      • 3mks for correct figures.
      • 3mks for the correct formula.
   6. 1mk for correct labelling of the row/column as REMARKS.
      ½ mk for each correct remarks.                             ½ x5=2 ½ mks
      1mk for the correct reference of Peter in the formula.
   7. 1mk for the correct title
      1mk for x axis label
      1mk for y axis label
      ½ mk for each correct bar .  ½ x5=2 ½ mks
   8. ½ mk for legend
   9. ½ mk for each print out             ½ x 4= 2mks
2.  
   1. 4 mks for well designed table with the appropriate field types.
      1mk penalty for each incorrect datatype.
      1mk for the correct primary key.
      1mk for each correct record.                                       1x15=15mks
   2. 2mks for correct sorting using age.
      1mk for correct saving .1mk penalty for wrong filename
   3. 5mks for all correct entries. penalize ½ mk for each incorrectly entered data.
      1mk for correct saving.
      1mk penalty for wrong filename
   4.  
      1. 5mks for correct query. 1mk penalty for any field that was not to be included. Penalize 1mk for each record that doesn’t meet required conditions of date and age.
         1mk for correct saving .1mk penalty for wrong filename
      2. 2 mks for the query.
         2mks for the correct total.
   5.  
      1. 5mks for correct report. Penalise 3 mks for including the male field
      2. 2mks for correct saving. 1mk penalty for wrong filename
      3. ½ mk for each correct print out       ½ x6=3mks