COMPUTER STUDIES PAPER 2 - 2019 KCSE KASSU JOINT MOCK EXAMS (QUESTIONS AND ANSWERS)

Share via Whatsapp

Instructions to candidates

  • Write the name and version of the software used for each question
  • Answer all the questions
  • All questions carry equal marks.
  • Passwords should not be used while saving in the CD-RW provided.
  • All answers must be saved in your CD-RW
  • Make a printout of the answers on the answer sheet.
  • Arrange your printouts and staple them together.
  • Hand in all the printouts and the CD-RW
  1. Table 1, Table 2 and Table 3 are extracts of records kept in Excellent Services Car Hire Ltd for Vehicles, Drivers and Trips respectively.

    Reg. Number

    Make

    Model

    Colour

    Engine

    Date of Reg.

    KCE837X

    Toyota

    Isis

    White

    1800cc

    2016

    KCU001A

    Mazda

    Demio

    Black

    1300cc

    2018

    KCF886P

    Nissan

    Note

    Gray

    1500cc

    2017

    KCP900S

    Toyota

    Hiace

    Silver

    3000cc

    2018

    KCF674W

    Nissan

    Murano

    Black

    2500cc

    2017


    Table 1

    Driver Number

    Driver Name

    Phone Number

    0001

    Thomas

    0730 455 998

    0002

    Grace

    0731 745 890

    0003

    Hannah

    0730 722 227

    0004

    Odhiambo

    0730 234 234

    0005

    Njambi

    0731 745 745

    Table 2

    Trip Number

    Reg Number

    Destination

    Distance

    Driver No.

    Date of Trip

    228

    KCE837X

    Mombasa

    1000

    0002

    10/04/2019

    220

    KCU001A

    Isiolo

    860

    0003

    10/04/2019

    190

    KCE837X

    Meru

    550

    0001

    12/04/2019

    262

    KCU001A

    Lamu

    1300

    0002

    13/04/2019

    239

    KCE837X

    Kisumu

    1050

    0004

    30/04/2019

    112

    KCU001A

    Nyeri

    300

    0001

    30/04/2019

    116

    KCF886P

    Muranga

    180

    0003

    02/05/2019

    100

    KCP900S

    Mwea

    230

    0005

    02/05/2019

    423

    KCF674W

    Kiriaini

    250

    0002

    03/05/2019

    123

    KCF674W

    Bungoma

    950

    0005

    07/05/2019

    345

    KCP900S

    Kangema

    240

    0004

    09/05/2019

    230

    KCF674W

    Othaya

    260

    0002

    09/05/2019

    157

    KCF886P

    Machakos

    230

    0001

    14/05/2019

    304

    KCF886P

    Nyahururu

    390

    0003

    16/05/2019

    300

    KCP900S

    Isiolo

    860

    0004

    17/05/2019

    Table 3
    1.  
      1. Using a database application package, create a database file named CARHIREINFO.      (1 mark)
      2. Create three tables named VEHICLES, DRIVERS and TRIPS that will be used to store the data in table 1, table 2 and table 3 respectively.     (14 marks)
      3. Set the primary key for each table.  (3 marks)
      4. Create enforced relationships among the tables.   (2 marks)
    2.  
      1. Create a data entry form for each table.          (3 marks)
      2. Enter the data in table 1, table 2 and table 3 into the Vehicles, Drivers and Trips tables respectively.          (9 marks)
    3.  
      1. Create a query named VehicleAge to display Vehicle Registration Number, Make, Model and Age of vehicle based on the current year.     (4 marks)
      2. Create a query named GraceDetails to display Driver Name, Phone Number, Vehicle Reg.Number, Make, Destination and Trip Dates for all trips by Grace. (3 marks)
    4.  
      1. Create a report to display the Vehicle Reg. Number, Trip Dates, Destination, Distance and the Driver’s Name. The records in the report should be grouped by Vehicles Reg. Numbers and the number of trips done by each vehicle should be displayed.          (5 marks)
      2. Title the report as “Trips Per Vehicle” and save it as Trips .  (2 marks)
    5. Print the following:
      1. Tables: Vehicles, Drivers and Trips;
      2. Queries: VehicleAge and GraceDetails;
      3. Report: Trips;
      4. Form: Trips.
  1. Mathioya Tea Farmers Ltd. is a company dealing with the collection and payment of tea farmers. Assuming you are working for the Company and you have been given the following data

    Zone

    Farmer S.No

    Name

    Green Leaves Delivered (Kg)

    Gross Pay

    Transport

    Co-op Deductions

    Net Pay

    Kiriaini

    585

    Crispin Kimondo

    5820

           

    Gikoe

    586

    Frashia Wambui

    9010

           

    Gikoe

    588

    Scola Waruguru

    4560

           

    Gikoe

    589

    David Maina

    5844

           

    Kiriaini

    590

    Dominic Ngunjiri

    7500

           

    Gitugi

    591

    Clifford Wekesa

    8610

           

    Gitugi

    592

    Sheila Mutai

    10241

           

    Kiriaini

    593

    Salyvia Wacu

    5971

           

    Gitugi

    594

    Brian Onyango

    16010

           

    1. Enter the data shown above into a spreadsheet giving it an appropriate title (centered) and save the Workbook as Exam 1. And rename the worksheet as Production                       (l0 marks)
    2. Copy the data to a new worksheet and enter details of farmer Dominic Githua of Kiriaini zone No 587 with green leaf 5632 Kg was left out insert the details in the appropriate row. (l mark)
    3. Add appropriate borders to the table.                                                                   (2 marks)
    4. Use a function to calculate the gross pay for Farmer No 585 given that the price of green leaves is Sh.14.00 per kg (3 marks)
    5. Copy the formula for gross pay across the column to calculate the gross pay for all the farmers                    (2 marks)
    6. Enter the following table from cell A15. Use IF function to Calculate transport cost for all farmers given that transport is charged per Kg as follows   (5 marks)

      Zone

      Price per Kg

      Kiriaini

      1.00

      Gikoe

      1.50

      Gitugi

      2.00

    7. Insert the value 20% in cell A20. Using absolute cell referencing calculate co-op deductions given that the co-op deduction is 20% of the cost. (4 marks)
    8. Using a function calculate the net pay given that Net pay is Gross pay - Transport cost and co-op deductions.  (4 marks)
    9. Format the columns containing currency values to currency with 2 decimal places and prefix Ksh. Rename the worksheet net pay and save it as Exam 2     (3 marks)
    10. Arrange the records are ascending order of the zone  (2 marks)
    11. Use subtotals function to calculate subtotals for green leaves delivered, gross pay and net pay for each zone.   (3 marks)
    12. Create an embedded pie chart showing the total Green leaf for each zone the chart should have the following details save it as Exam 3  (5 marks)
      1. Chart title Zone - Total Green Leaves
      2. Legend Position - Right
    13. Print Exam 1, Exam 2, and Exam 3 in landscape orientation.                             (6 marks)

Download COMPUTER STUDIES PAPER 2 - 2019 KCSE KASSU JOINT MOCK EXAMS (QUESTIONS AND ANSWERS).


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Join our whatsapp group for latest updates
Get on WhatsApp Download as PDF
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest