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

Share via Whatsapp
Download PDF for future reference Get on Whatsapp for 50/-

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.      
      • 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: ……………….
    1. 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  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  St. Timothy 
    2. 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)

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


Tap Here to Download for 50/-





Join our whatsapp group for latest updates
Read 3265 times Last modified on Thursday, 12 May 2022 13:53
Print PDF for future reference