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

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	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
   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