Computer Studies Paper 2 Questions and Answers - Form 3 Mid Term 3 Exams 2023

         QUESTION 1 (50 Marks)

1. 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	KAJ001	Matatu	Nissan	1200000	B001	800000
   John	678	Eldoret	KAJ002	Bus	Mazda	2400000	B002	2000000
   Ken	963	Nairobi	KAJ003	Saloon	Toyota	800000	B003	600000
   Peter	147	Nakuru	KAJ004	Pick-up	Peugot	1000000	B004	700000
   Roy	456	Bungoma	KAJ005	Lorry	Isuzu	3000000	B005	2000000
   Glen	789	Webuye	KAJ006	Pick up	Toyota	1800000	B006	1600000
   John	678	Eldoret	KAJ007	Bus	Scania	7500000	B002	7500000
   Ken	963	Nairobi	KAJ008	Matatu	Toyota	1300000	B003	1300000
   Philip	159	Kisumu	KAJ009	Saloon	Nissan	900000	B007	90000
   Peter	254	Nakuru	KAJ010	Pick-up	Isuzu	1500000	B001	1200000
   Ken	357	Kisumu	KAJ011	Saloon	Peugeot	700000	B008	700000
   Glen	789	Webuye	KAJ012	Bus	Isuzu	1000000	B006	9500000
   Peter	147	Nakuru	KAJ013	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).
      QUESTION 2 (50 Marks)
2. Use a spreadsheet to manipulate data in the table below.
   

   Adm No	Name	Stream	Comp	Art	Bus	Eng	Mat	Student mean	Rank
   C001	Barasa	H	56	45	36	56	26
   C002	Wangila	K	58	57	90	54	23
   C003	Wafula	H	48	56	54	45	25
   C004	Wanjala	K	78	95	78	46	24
   C005	Kerubo	H	49	86	68	35	52
   C006	Akinyi	K	56	45	25	63	54
   C007	Odhiambo	H	75	78	45	65	56
   C008	Okunyuku	K	89	69	65	53	51
   C009	Nekesa	H	69	58	45	54	52
   C00010	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 mark 3 (7 mks)
   8. Print mark1, mark2, and the chart (3 mks)

                                                                                MARKING SCHEME

             QUESTION 1 (50 Marks)

1.  
   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
   9.  
      • Presence of print outs @ % *4 1 mks
      • landscape @l/4*4 1 mks
        TOTAL
        50MKS
        QUESTION 2 (50 Marks)
2.  
   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 MARK