Computer Studies Paper 2 Questions and Answers - 2021 KCSE Eldoret Diocese Mock Exams

Questions

INSTRUCTIONS TO CANDIDATES

• Write your name and index number at the top right hand corner of each of the papers provided
  for printing.
• Write your name and index number on the CD/Removable storage medium provided.
• Write the name and version of the software used for each question attempted in the printouts used
• Answer all questions
• All questions carry equal marks
• Passwords must not be used while saving files
•  All files must be transferred to the CD/Removable storage medium
• Make printouts of your answers on the papers provided for printing
• Arrange your printouts and tie/staple them together
• Hand in all the printouts and the CD/Removable storage medium used
• Candidates should answer the questions in English.

Task 1 (50 marks)

CaSPA Eldoret diocese has organized a triathlon event for its school that will involve three events: Swimming, Biking and Running. You are required to create a database that will assist in keeping records of the event.

1. Using a suitable database package. Create a database named analysis. (1 mark)
2.      
   1. Create four tables named Schools, Athletes, Events, and Results. (8 marks)
      
      Athletes Table
      

      Field	Data type
      Last_Name	Text
      First_Name	Text
      Athlete_ID	Number
      School_ID	Text
      YOB	Number
      Gender	Text

      
      Events Table
      

      Field	Data type	Format
      Event_ID	Text
      Location	Text
      Ward	Text
      Date	Date/Time	dd/mm/yyyy
      Swim(M)	Number
      Bike(KM)	Number
      Run(KM)	Number
      Water_Temp	Number
      Air_Temp	Number
      Wetsuit	Boolean/Logical	To display as Yes/No
      Race_Director	Text
      IOC_Code Text

      
        Results Table
      

      Field	data type	Format
      Event_ID	Text
      Athlete_ID	Number
      Start_No	Number
      Swim	Date/Time	hh:m:ss
      T1	Date/Time	hh:m:ss
      Bike	Date/Time	hh:m:ss
      T2	Date/Time	hh:m:ss
      Run	Date/Time	hh:m:ss
      Outcome	Text
      Posiiton	Number
      Tital_time	Date/Time	hh:m:ss

      
      Schools Table
      

      Field	Data type	Format
      School_ID	Text
      School_Name	Text

   2. Create the relationship between the tables. ( 2 marks)
   3. Create a form for keying in data into the results table. Save the form as dataentry (7 marks)
   4. Enter the following data into their respective tables in the database. ( 8 Marks)
      

      Last Name	First Name	Athlete	School ID	YOB	Gender	Address
      Moja	Wan	109	STM	2001	Female	45 Moi's Bridge
      Mbili	Too	101	STZ	2002	Female	32 Burnt forest
      Tatu	Nzuri	102	STJ	2002	Female	67 Jua Kali
      Four	Ene	103	STJ	2003	Male	90 Turbo
      Five	Tanui	104	STW	2000	Female	2 Matunda
      Six	Sita	105	STC	2000	Female	56 Eldoret
      Sabha	Singh	106	STV	1999	Male	12 Ainabkoi
      Nane	Heit	107	STZ	2007	Male	14 Kapseret
      Kumi	Tene	108	STT	2006	Male	56 Moiben

      
      Events Table
      

      Event ID	Location	Date	Swim (M)	Bike (KM)	Run (KM)	Water Temp	Air Temp	Wetsuit	Race Director
      AE32	Kapseret	14/03/2020	750	20.6	5.1	22.7	19.4	0	Olivia Keymoney
      MX32	Kesses	11/04/2020	1500	40	10	26.8	27.8	0	Haruto Keepsang
      JP32	Ainabkoi	09/05/2020	1500	40.05	10	18.7	22.7	-1	Otto Omondi
      GB32	Moiben	11/07/2020	1500	38.6	10	18.3	17.4	-1	Miguel Wanjala

      
      Results Table
      

      Event ID	Athlete ID	Start No	Swim	T1	Bike	T2	Run	Outcome	Position	Total Time
      AE32	01	17	0:09:26	0:00:56	0:32:40	0:00:22	0:17:03	Complete	14	1:00:27
      JP32	01	9	0:19:05	0:01:10	1:00:31	0:00:23	0:34:39	Complete	7	1:55:48
      AE32	02	14	0:09:45	0:01:07	0:32:47	0:00:21	0:16:36	Complete	15	1:00:36
      GB32	02	21	0:19:27	0:01:00	0:00:00	0:00:00	0:00:00	LAP	0	0:00:00
      MX32	02	10	0:21:25	0:00:38	1:11:09	0:00:23	0:37:03	Complete	21	2:10:38
      JP32	03	47	0:17:49	0:00:57	0:57:04	0:00:27	0:33:22	Complete	40	1:49:39
      AE32	04	49	0:09:41	0:00:57	0:00:00	0:00:00	0:00:00	DNF	0	0:00:00
      GB32	06	39	0:18:00	0:01:06	0:00:00	0:00:00	0:00:00	DNF	0	0:00:00

      
      Schools Table
      

      School_ID	School_Name
      STM	St. Martin
      STZ	St. Zacharias
      STJ	St. Joseph
      STW	St. William
      STC	St. Christopher
      STV	St. Vincent
      STT	St. Timothy

3. Using fields from all tables, create a query named qryResults1 that: ( 10 marks)
   • selects the records where:
     • Location includes the text e
     • school ID is STZ or STW
     • Outcome is Complete
   • shows only the fields:
     • First_Name, Last_Name, YOB, School_Name, Location, Outcome and Position in this order.
     •  sorts the data into ascending order of School_Name and ascending order of Position
4.              
   1. Prepare a tabular report that: (4 marks)
      shows only the fields:
      • First_Name, Last_Name, YOB, School_Name, Location, Outcome and Position in this order, with data and labels displayed in full. Do not group the data
      • sorts the data into ascending order of School_Name and ascending order of Position
      • has a page orientation of portrait
      • fits on a single page
      • includes only the text Oceania Results as a title at the top of the pag
      • has your name, index number on the footer of the report.
      • Name this report as rptResults1
   2. produce labels which: (4 marks)
      • are arranged in 2 columns and 4 rows with 8 labels to the page, for example, each label can be size 21 mm high × 15 mm wide (2.1 cm × 1.5 cm).
      • display the fields in the positions shown in the following sample label:
        

        Athlete_ID First_Name Last_Name SChool_Name Adress

      • Name this label lblResults
   3. Print out each of the following: ( 6 marks)
      • The structures of all the tables
      • The tables showing their contents/records
      • the query in design mode
      • the output of the query
      • the repor
      • the lables

Task 2    

1.      
   1. • Using a suitable word processing package. Create a document named CaSPA_Triathlon_Cert_1. Reproduce the following in the document then print it. You will use this document as the master document in mail merge. Place your name and index number in the footer of the document: (24 marks)
        

        CaSPA TRIATHLON Certificate of Achievement   Congratulations to: <COMP>, representing <SCH> who completed the CaSPA Triathlon on <DATE>, finishing the distance in a total time of: <TIME> Overall placement: <POS> out of 9 competitors <GEN> placement: <G_POS>

        
        

        VERIFIED TIMING SPLITS
        SWIM	<SW>
        Transition 1	<TRANS1>
        BIKE	<BK>
        Transition 2	<TRANS2>
        RUN	<RN>

        
        Race Director: ……………………………………….. Awarded on: ……………….
   2. Prepare then print the following table in a word processed secondary document and name it as CaSPA_Triathlon_Data. ( 6 marks)
       2​St. William​

      Name	Gender	Swim	T1	Bike	T2	Run	Total_Time	Overall_Pos	Gender_Pos	School
      Ole Gunnar	Male	00:17:13	00:01:02	00:56:18	00:00:23	00:31:30	01:46:26	4	3	St. Martin
      Aling Nyako	Female	00:17:26	00:01:09	00:55:59	00:00:27	00:32:06	01:47:07	6	2	St. Zacharia
      Chep Chikoni	Female	00:18:01	00:01:04	00:55:35	00:00:25	00:32:11	01:47:16	8	3	St. Joseph
      Wanyama Wote	Male	00:17:25	00:01:01	00:56:06	00:00:24	00:31:04	01:46:00	2	2	St. William
      Keep Ngeno	Male	00:18:03	00:01:01	00:55:27	00:00:24	00:30:57	01:45:52	1	1	St. Timothy

   3. Replace the text and chevrons in the master document with the merge fields from the data source file as follows: (9 marks)
      

      Text and cherons to replace	Replace with merge field
      <COMP>	Name
      <SCH>	School
      <TIME>	Total_Time
      <POS>	Overall_Pos
      <GEN>	Gender
      <G_POS>	Gender_Pos
      <SW>	Swim
      <TRANS1>	T1
      <RN>	Run

      
      
      • Replace <DATE> with a field to display today’s date in the format dddd, dd MMMM yyyy (1 mark)
      • Make sure the spacing, punctuation, alignment and enhancements in the original master document are maintained. (1 mark)
      • Enter your details (index number, name) in the footer of the master document. (1 mark)
      • Save the document as CaSPA_Triathlon_Cert_2 and print your master document showing the merge field codes (Print with the merge field code revealed). (2 marks)
2. Set an automated filter to select competitors where:
   • Gender is Female
   • Gender_Pos is 2 or less
   • Overall_Pos is 6 or more (3 marks)
   • Merge, save the document as CaSPA_Triathlon_Cert_3 and print the certificates for the selected competitors only. (3 marks)