Computer Studies Paper 2 Questions and Answers - Momaliche Joint Mock Exams 2021/2022

Instructions to Candidates

• Indicate your name and index number at the top right hand corner of each printout
• Write your name and index number on the storage medium provided.
• Write the name and version of the software hased for each question attempted in the answer sheet.
• Passwords should not be used while saving in the storage medium
• Answer all the questions. All questions carry equal marks.
• All answers must be saved in your storage medium.
• Make a printout of the answers on the answer sheets provided.
• Hand in all the printouts and the storage medium.

1. Mr. Chirchir Mungai owns houses for rent. The Table 1 below is a record of his tenants’ rent payments.
   

   Tenant ID	Tenant Name	House Number	Month	Amount (Ksh)
   2019	Akinyi	A1	January	3,000
   2022	Maloi	A2	January	4,000
   2038	Nduta	B1	January	4,500
   2059	Rop	B2	January	4,500
   2070	Mutua	C1	January	4,000
   2019	Akinyi	A1	February	3,000
   2022	Maloi	A2	February	4,000
   2038	Nduta	B1	February	4,500
   2070	Mutua	C1	February	4,000
   3050	Kagu	C2	February	3,500
   2022	Maloi	A2	March	4,000
   3050	Kagu	C2	March	3,500

   1. Create a database file that can be used to store the above data. Name the file ‘Rent’. (2 Marks)
   2. Create two tables, one to store tenant details and another to store tenant rent payment.
      Name the tables ‘Tenants’ and ‘Payments’ respectively. (9 Marks)
   3. Create a relationship between the two tables. (3 Marks)
   4. Design a form to be used to enter data into each of the two tables. (7 Marks)
   5. Enter the information given into the two tables. (9 Marks)
   6. Create a report showing the amount Mr. Chirchir Mungai received from each tenant, the total for each month and the total amount he received over the three months. The report should be titled ‘Rent Income’. Save the report as ‘Income’. (8 Marks)
   7.        
      1. Create a query named ‘statement’ to extract Maloi’s records of rent payment. (4 Marks)
      2. Create a report named ‘Tenant Statement’ showing Maloi’s rent payment history. The report should be titled ‘Tenant Statement’. (4 Marks)
   8. Print the two tables and the two reports. (4 Marks)
2. Green Company 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 SNO	Name	Green leaves delivere d in (Kg)	Gross Pay	Transport Cost	Co-op Deductions	Net Pay
   A	142	William Kiyapi	1253
   B	143	Festus Gichui	2563
   B	144	Mirui Muye	4523
   B	145	Kirwa Keter	1023
   A	146	Benjamin Sego	8563
   C	148	Sheila Bungei	4123
   C	149	Nancy Maru	5236
   A	150	Kariuki Thige	8963
   C	151	Polycap Onyango	12356

   1. Enter the data shown above into a spreadsheet giving it an appropriate title (centered) and save the Workbook as Mock 1. And rename the worksheet as Entries (l0mks)
   2. Copy the data to a new worksheet and enter details of farmer Mike Rua of Zone A No 147 with green Leaf 4, 5632 Kg was left out insert the details in the appropriate row. (lmk)
   3. Insert borders after every cell and every row. (2mks)
   4. Use a function to calculate the gross pay for Farmer No 142 given that the price of green leaves is
      Sh.14.00 per kg (3mks)
   5. Copy the formula for gross pay across the column to calculate the gross pay for all the farmers (2mks)
   6. Use if function to Calculate transport cost for all farmers given that transport is charged
      Per Kg as follows (5mks)
      

      Zone	Transport Cost per Kg
      A	1.00
      B	1.50
      C	2.00

   7. Insert the value 20% in cell E14. Using absolute cell referencing calculate co-op Deductions given that the co-op deduction is 20% of the cost. (4mks)
   8. Using a function calculate the net pay given that Net pay is Gross pay minus Transport cost plus co-op deductions. (4msk)
   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 Mock 2 (3mks)
   10. Use subtotals function to calculate subtotals for green leaves delivered, gross pay and net Pay from each zone. (5mks)
   11. Create an embedded pie chart showing the total Green leaf for each zone the chart should Have the following details save it as Mock 3 (5mks)
       
       1. Chart title Zone Total Gran leaf
       2. Legend Position Right
   12. Print Mock 1, Mock 2, and Mock 3 in landscape orientation. (6mks)

MARKING SCHEME

1.    
   1. Creating a database 
      Correct name
   2. Two tables 
      Each table ½ marks
      
      • Primary key(1 table) 3 fields 
      • Fields (2nd Table) 
   3. Relationship
      
      • Correct relationship 
      • Choosing correct table 
      • Enforcing the relationship 
   4. Creating two forms 
      Each table 1 mark
      
      • Existence of fields
        Table 1 - 3 fields each ½ 11/2
        Table 2 - 3 fields each ½ 11/2
      • Naming each form 1 mark 2
   5. Each tenant record (Form) ½ x 6 records 
      Each tenant record (Form) ½ x 12 records 
   6. Presence of report
      Appearance correct (Fields)
      Name
      Month
      Amount
      Sum January, February, March
      Grant total
      Report name (saving)
      Title name
   7.      
      1. Presence of correct query
         Presence of fields (name, amount, month) In a query
         Correct criteria 
         Saving query 
      2. Report
         Data source (query)
         Name of the report (saving)
         Title of the report 
   8. Printing 2 tables 
      2 reports 
2.      
   1. Saving the work book with the correct name 
      
      • Using a different name
      • Using default name book, no mark)
      • All data entered correctly -2
      • Every wrong entry -½
      • More than 6 wrong entries -4
      • Renaming the sheet to “Entries”
      • Default name sheet, No mark 
   2.    
      • Copy to new worksheet ½
      • Enter details of Rua ½
   3. any borders 
   4. Correct function 
   5. copying 
   6.      
      • correct if function 
      • Other functions 
      • No function with correct entries 
   7. Using absolute cell referencing 
      Without absolute cell references 
   8. Correct net pay function 
   9.      
      • Currency values 
      • Rename worksheet 
      • Save as Mock2 
   10. Using subtotals function 
   11.      
       • Correct selected entries 
       • Legend 1
       • Chart title 1
       • Embedded 1
   12. Printing 6