Computer Studies Paper 2 Questions and Answers - Kangundo Subcounty Pre Mock Exams 2021/2022

Share via Whatsapp

QUESTIONS.

  1.    
    1.    
      1. The extract below shows a spreadsheet used to compute the toll charges for a highway based on the type of vehicle, tonnage and charge per kilometer for usage.
          HIGHWAY TOLL CHARGES
        Registration Vehicle Type Weight   Distance NormalCharge Penalty Charge Total 
        KCY 789 M  PickUp  6 12      
        KCR 769 L Car 4 40      
        KCF 724 C PickUp 6 32      
        KCM 737 N Truck 12 25      
        KCA 745 W Lorry 20 28      
        KCP 756 H Truck 10 12      
        KCU 778 J Car 4 8      
        KCZ 701 A PickUp 8 25      
        KCB 781 E Car 6 4      
        KCV 743 H  PickUp 4 20      
        KCQ 735 X  Truck  8 32      
        KCT 721 K Lorry  10 25      
        KCD 792 V Truck 12 28      
        KCZ 784 P  Car  6 12      
        KCB 756 C Truck 10 8      
        KCE 734 D Car 4 25      
        KCF779 E PickUp 6 32      
        KCG 700 F Lorry 12 25      
        KCH 723 K Truck 20 28      
        KCJ 711 W PickUp 10 12      
        KCR 712 D Car 4 8      
        KCD 774 B PickUp 8 25      
        KCS 756 M Truck 6 4      
        KCA 745 W Car 4 20      
              Total      
      2. Create a workbook and save the workbook as toll. ( 2 Marks)
      3. Fill the data in the worksheet1 and rename the worksheet as tollOriginal. ( 14 Marks)
    2.    
      1. The NormalCharge column is calculated based on the table below.
        Vehicle Type Max AllowedWeight(Tns)
        PickUp  6
        Car  4
        Truck  8
        Lorry  10
      2. The PenaltyCharge column is calculated based on the table below. The penalty is based on any weight above Maximum allowed weight for a vehicle type for every kilometer of the the usage. ( 8 Marks)
        Vehicle Type Penalty Charge (Ksh)per Km
        PickUp  10
        Car  5
        Truck  15
        Lorry  20
      3. The TotalCharge is based on summation of NormalCharge and PenultyCharge . Create a column TotalCharge and use a function to Calculate the Total Charge ( 2 Marks)
      4. Create the Running Totals for Normal Charge,Penulty Charge And Totalcharge ( 4 Marks)
    3.    
      1. Copy The data in the OriginalToll to another worksheet rename the workshhet as Sorted( 1 Mark)
      2. Sort the Data is ascending order of Vehicle type Sorted worksheet. ( 4 Marks)
      3. Create subtotals based on the vehicle Type ( 4 Marks)
      4. Draw a column chart based on The Vehicle Type subtotals and Total Charge ( 8 Marks)
  2.    
    1. Create a database called Aberdare bottles ltd and create the following tables (15 marks)
      Table 1: Employee
      Employee_ID  EmployeeName Department YearOfEmployment 
      101 Kibet Arap Kamau  Human resource  1985
      102 Janet Atieno  Procurement  1990
      450 Kimani Koigu  Accounts   2000
      891 Moraa Kerubo  Human resource  2010
      Table 2: Sales
      ProductName Employee_ID ProductID SalesAmount Salary
      Tea leaves 101  Xc101  5000  
      cocoa  102 Xp105 15500  
      coffee  450 Xvb11  9500  
      Chocolate  891 X56po  30000  
      Table 3: Department
      Employee_ID Department_Name HeadOfDepartment NoOfEmployees
      101 Human resource  B.N. Komu  52
      102 Procurement  J.K. Wanjiru  12
      450 Accounts P.G. Otindo  20
      891 Human resource  M.M. Jerotich  10
      1. Create relationship among the tables (2 marks)
      2. Create three input screens (forms) and use them to enter the data into the tables above(6 marks)
      3. Create a query called Start_K and use it to display EmployeeName that start with letter K (3 marks)
      4. Display the no of years an employee has worked given that the current year is 2018. Save the report as AGE. (3 marks)
      5. Create a query called Yote to display the following fields (2 marks)
        • Employee_ID
        • EmployeeName
        • Department_Name
        • ProductName
        • Salary
        • HeadOfDepartment
      6. Copy Yote query (in v above) and save the new query as MPYA:- (1 marks)
        Use MPYA query to
        • Calculate the salary given that: salary is 10% of the SalesAmount (2 marks)
        • Display salary in ascending order (2 marks)
        • Display employees from human resource department whose SalesAmount is greater than 12000. (2 marks)
      7. Create a form called AberdareForm using Yote query (in v above) and use it to answer the questions below:-
        • Count no of employees (2 marks).
        • Add a title of the form as “Aberdare bottles ltd-2018” (2 marks)
        • Insert date and time on the form header use ( =NOW( ) ) (2 marks)
      8. Print Age, Sales table, and AberdareForm (3 marks)


MARKING SCHEME

QUESTION 1.

  1.    
    1.   
      1. The extract below shows a spreadsheet used to compute the toll charges for a highway based on the type of vehicle, tonnage and charge per kilometer for usage.
          HIGHWAY TOLL CHARGES
        Registration Vehicle Type Weight   Distance NormalCharge Penalty Charge Total 
        KCY 789 M  PickUp  6 12      
        KCR 769 L Car 4 40      
        KCF 724 C PickUp 6 32      
        KCM 737 N Truck 12 25      
        KCA 745 W Lorry 20 28      
        KCP 756 H Truck 10 12      
        KCU 778 J Car 4 8      
        KCZ 701 A PickUp 8 25      
        KCB 781 E Car 6 4      
        KCV 743 H  PickUp 4 20      
        KCQ 735 X  Truck  8 32      
        KCT 721 K Lorry  10 25      
        KCD 792 V Truck 12 28      
        KCZ 784 P  Car  6 12      
        KCB 756 C Truck 10 8      
        KCE 734 D Car 4 25      
        KCF779 E PickUp 6 32      
        KCG 700 F Lorry 12 25      
        KCH 723 K Truck 20 28      
        KCJ 711 W PickUp 10 12      
        KCR 712 D Car 4 8      
        KCD 774 B PickUp 8 25      
        KCS 756 M Truck 6 4      
        KCA 745 W Car 4 20      
              Total      
      2. Create a workbook and save the workbook as toll. ( 2 Marks)
      3. Fill the data in the worksheet1 and rename the worksheet as tollOriginal. ( 14 Marks)
    2.    
      1. The NormalCharge column is calculated based on the table below.
        Vehicle Type Max AllowedWeight(Tns)
        PickUp  6
        Car  4
        Truck  8
        Lorry  10
        Use a Formula to calculate the Normal charge in the worksheet ( 4 Marks)
        =IF(C3<=5,2.5*D3,IF(C3<=10,3.5*D3, IF(C3<=15,4.5*D3,IF(C3<=20,5.5*D3,IF(C3<=25,6.5*D3,IF(C3<=30,7.5*D3, 10*D3))))))
      2. The PenaltyCharge column is calculated based on the table below. The penalty is based on any weight above Maximum allowed weight for a vehicle type for every kilometer of the the usage. ( 8 Marks)
        Vehicle Type Penalty Charge (Ksh)per Km
        PickUp  10
        Car  5
        Truck  15
        Lorry  20
      3. The TotalCharge is based on summation of NormalCharge and PenultyCharge . Create a column TotalCharge and use a function to Calculate the Total Charge ( 2 Marks)
      4. Create the Running Totals for Normal Charge,Penulty Charge And Totalcharge ( 4 Marks)
    3.    
      1. Copy The data in the OriginalToll to another worksheet rename the workshhet as Sorted( 1 Mark)
      2. Sort the Data is ascending order of Vehicle type Sorted worksheet. ( 4 Marks)
      3. Create subtotals based on the vehicle Type ( 4 Marks)1.png
      4. Draw a column chart based on The Vehicle Type subtotals and Total Charge ( 8 Marks)
        2
  2. QUESTION 2
    NO AREA DATABASES MAX MARKS MARKS AWARDED
    a Creating and saving the database as Aberdare bottles ltd  2  
      Creating 3 tables and saving as instructed
    Employee, Sales, Department @ 5 x 3
    Correct fields and data types  
    15  
    i Creating relationship among tables 2  
    ii Creating three forms with correct fields @2x 3 6  
    iii Creating a query Start_K
    Correct filtering K* 1 
    1
    2
     
    iv Saving the query as AGE
    Correct function to calculate no of years 1
    1
    2
     
    v Creating Yote query
    Correct fields 1
       
    vi Copying Yote and renaming to MPYA
    Calculating SalesAmount correctly
    Sorting salary in ascending order
    Display Department HR , SalesAmount>12000
    1
    2
    2
    2
     
    vii Creating form AberdareForm to:-
    Count no of employees
    Adding title: “Aberdare bottles ltd-2018”
    Insert date and time using = now() function

    2
    2
    2
     
    viii Printing :-
    Age
    Sales table
    AberdareForm
    3  
      TOTAL 50  
     
Join our whatsapp group for latest updates

Download Computer Studies Paper 2 Questions and Answers - Kangundo Subcounty Pre Mock Exams 2021/2022.


Tap Here to Download for 50/-




Why download?

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


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