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

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
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)
4. Draw a column chart based on The Vehicle Type subtotals and Total Charge ( 8 Marks)
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 instructedEmployee, Sales, Department @ 5 x 3Correct 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_KCorrect filtering K* 1 12 iv Saving the query as AGECorrect function to calculate no of years 1 12 v Creating Yote query Correct fields 1 vi Copying Yote and renaming to MPYACalculating SalesAmount correctlySorting salary in ascending order Display Department HR , SalesAmount>12000 1222 vii Creating form AberdareForm to:-Count no of employeesAdding title: “Aberdare bottles ltd-2018”Insert date and time using = now() function 222 viii Printing :-AgeSales tableAberdareForm 3 TOTAL 50

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