Computer Studies Paper 2 Questions and Answers - Form 3 End Term 1 Exams 2022

Share via Whatsapp
  1. QUESTION 1 (50 Marks)
    The information below was extracted from CMC vehicle selling business
    Buyer Name Buyer Address Buyer Town Vehicle Reg No. Vehicle Type Vehicle Make Vehicle Price Buyer Number Amount Paid
    peter 254 Nakuru  KAJ 001 Matatu  Nissan  1200000  B001 2400000
    john 678 Eldoret  KAJ 002 Bus  Mazda  2400000  B002  2000000 
    ken  963 Nairobi KAJ 003 Saloon Toyota  800000 B003 600000
    peter 147 Nakuru  KAJ 004 Pick up  Peugeot 1000000 B004  700000 
    roy  456 Bungoma KAJ 005 Lorry Isuzu  3000000  B005  2000000 
    glen  789  Webuye  KAJ 006 Pick up Toyota  1800000 B006  1600000 
    john  678 Eldoret  KAJ 007 Bus  Scania 7500000  B002  7500000 
    ken 963 Nairobi KAJ 008 Matatu Toyota  1300000 B003  1300000
    phillip 159 Kisumu KAJ 009 Saloon  Nissan  900000 B007  900000
    peter 254 Nakuru KAJ 010 Pick up  Isuzu 1500000  B001  1200000
    ken 357 Kisumu KAJ 011 Saloon  Peugeot  700000 B008 700000
    glen 789 Webuye KAJ 012 Bus  Isuzu  10000000  B006  9500000
    peter 147 Nakuru KAJ 013 Matatu  Nissan  2700000  B004 2700000
    1. Create a database file named CMC (2 marks)
    2. Using the information in the table, create a table to hold vehicle detail and another to hold buyer details. Name them tbl vehicle and tbl buyer respectively (4 marks)
    3. Enforce referential integrity between two tables. (2 marks)
    4. Create different input screen for each table, giving them appropriate title. Name them frm vehicle and frm buyer. Use them to enter data into the tables. (12 marks)
    5. Display a report only showing the details of the buyers who have cleared paying for the vehicle.
      Name the report rpt cleared with ‘’CLEARED BUYERS’’ as the title of the report. (10 marks)
    6. Using the two tables create an outlined report showing the customer details, the total amount paid by each customer and the total amount received by CMC during this time. Name the report rptnilbal and the title as ‘SUMMARY REPORT PER BUYER.’’ (8 marks)
    7. Create a query to display the vehicle details with balances of less than 500,000 but not less than 300,000. Name the query as qrymidbal. (7marks)
    8. Create a report showing the vehicle type, the total sales for each type and the grand total. (3marks)
    9. Print tblvehicle, tblbuyer, rptcleared, and rptnilbal and qrymidbal landscape orientation with footers being your last name and index number at the centre of the page. (2 marks).
  2. QUESTION 2 (50 Marks)
    Use a spreadsheet to manipulate data in the table below.
    Adm. No Name Stream Comp Art Bus Eng Mat STUDENT MEAN RANK
    C001 Barasa  56  45 36 56 26    
    C002  Wangila K 58  57 90 54 23    
    C003  Wafula  48  56 54 45 25     
    C004  Wanjala 78  95  78 46  24     
    C005  Kerubo  49  86  68  35  52    
    C006  Akinyi  56  45  25 63  54     
    C007  Odhiambo 75  78  45 65  56    
    C008 Okunyuku K 89 69 65 53 51    
    C009 Nekesa H 69 58 45 54 52    
    C010 Simiyu H 85 46 78 52 53    
      TOTAL                
      TOTAL FOR H              
      TOTAL FOR K              
    1. Enter the data in all bordered worksheet and auto fit all columns. Save the workbook as mark1 (15 mks)
    2. Find the total marks for each subject (3 mks)
    3. Find total for each subject per stream using a function. (5 mks)
    4. Find mean mark for each student using a function (5 mks)
    5. Rank every student in descending order using the mean (5 mks)
    6. Create a well labeled colum chart on a different sheet to show the mean mark of every student.
      Save the workbook as mark2. (7 mks)
    7. Using mark1, use subtotals to find the average mark for each subject per stream. Save the workbook as mark3 (7 mks)
    8. Print mark1, mark2, and the chart (3 mks)


MARKING SCHEME

  1. QUESTION 1 (50 Marks)
    1. Presence of database Use of the correct name
    2. Presence of the two tables @l/2 =
      Correct naming @l/2
      Correct decomposition @1
    3. Presence of relation = Enforced integrity
    4. Presence of two forms @1 =
      Use of correct form names @1 =
      Complete data entry in each table @4 =
      Presence of errors up to 4 errors (deduct 2 mks per table)
      Incomplete data entry award ⅟2 marks per table
    5. Query to retrieve who cleared (calculate balance) 2 mks
      (With the correct criteria) 2 mks
      Presence of report 1 mks
      Correct name of report 1 mks
      Correct title 1 mks
      Correct records 1 mks
      All buyer details 2 mks
    6. Report presence = 2 mk
      Well named 1 mks
      Correct title 1 mks
      Outlined = 2 mks
      Summary 2 mks
    7. Presence of the query 2 mks
      Correct query name 1 mks
      Correct criteria (2 mks for each part) 4 mks
    8. Presence of the report 1 mks
      Vehicle type summary 1 mk
      Grand total 1 mks
      1. Presence of print outs @ % *4 1 mks
        landscape @l/4*4 1 mks
        TOTAL:50MKS
  2. QUESTION 2 (50 Marks)
    1. Presence of workbook 1 mks
      Correctly saved (correct name) 1 mks
      10 records correctly entered (5)1/2*10 5 mks
      Auto fit columns @l/2 *10 5 mks
      Presence of borders 3 mks
    2. Subject totals using a function/formula⅟2*5
    3. Total marks per stream ⅟2 *10
    4. Mean mark for each student ⅟2 *10
    5. Ranking for every student ⅟2 *10
    6. Presence of a column chart 1 mks
      Correct content 1 mks
      Labeling x-axis 1 mks
      Y-axis 1 mks
      Legend 1 mks
      Title 1 mks
      Different sheet 1 mks
    7. Sorting of records 2 mks
      Average using subtotals Yz*10 (5 mks)
    8. Printing the three sheets
      15 mks 3 mks 5 mks 5 mks 5 mks
      7 mks
      7 mks 3 mks
      TOTAL:50 MARKS
      GRAND TOTAL:100 MARKS

Download Computer Studies Paper 2 Questions and Answers - Form 3 End Term 1 Exams 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


Join our whatsapp group for latest updates
.
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