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

1. The following are the KCSE results for a certain school.
   
   1.  
      1. Enter the data using the given values above in excel and save your work as KCSEXCEL (15marks)
      2. Two rows below the table above determine point scored by each student per subject. given that (7marks)
         

         Grade	A	A−	B+	B	B−	C+	C	C−	D+
         Value	12	11	10	9	8	7	6	5	4

      3. Rename sheet1 to “Broadsheet” (1mark)
   2. Perform the following calculations.
      1. Get the average point (4marks)
      2. Determine each student overall grade (5marks)
      3. Determine each students rank using the Ave. Point Mark. (4marks)
   3. Calculate Subject Mean (4marks)
   4. Draw a Column Chart to display Subject performance           (4marks)
      • Title as “SUBJECT ANALYSIS”
      • Place the legend at the bottom of the graph                                                        (2marks)
      • Save the chart on a new sheet and name it Subject Analysis                              (2marks)
   5. Print
      1. Broadsheet with formulae displayed (3marks)
      2. Subject Analysis (1marks)
2. The tables below, STUDENT, SUPERVISOR and SUPERVISIONS are extracts of records kept in a certain university for project supervisions.
   

   Student Number	Name	Gender	Project Fee Paid
   C001	Ken	M	32000
   C002	Joy	F	27800
   C003	Lero	M	18900
   C004	Moth	F	42700
   C005	Ben	M	45000

   
   Table 1 STUDENTS TABLE
   

   Supervisor Number	Name	Department
   L220	Alex	Mechanical
   L230	Sakaja	ICT
   L240	Roy	Electronics
   L250	Mati	Education
   L260	Joy	Human Resource

   
   Table 2 SUPERVISORS' TABLE
   

   Supervision Number	Supervision Date	Student  Number	Supervisor Number	Project Title
   100	12/03/2015	C001	L220	Java
   200	22/03/2015	C003	L230	Website
   300	17/03/2015	C004	L240	Robotics
   400	02/03/2015	C001	L220	Java
   500	18/03/2015	C002	L240	Robotics
   600	12/03/2015	C004	L230	Java
   700	11/03/2015	C002	L250	Database
   800	12/03/2015	C003	L220	Java
   900	12/04/2015	C005	L250	Database
   1100	12/04/2015	C002	L250	Database

   
   Table 3 SUPERVISIONS TABLE
   1. Using a database application software, create a database file named PROJECT   (1mk)
   2. Create three tables named STUDENT, SUPERVISOR nad SUPERVISIONS as shown above.   (9mks)
   3. Set the primary key for each table.     (3mks)
   4. Create relationships among the tables.      (2mks)
   5. Enter the data in the table STUDENT, SUPERVISOR and SUPERVISIONS as shown above.      (9mks)
   6. Create a form for each table above       (3mks)
   7. Create a query named BALANCE to display student name, Gender, project fee balance per student, given that the total project fee is Ksh 50,000.     94mks)
   8. Create a query named BALANACE 2 to display students' Names, project title whose fee balance is above Ksh. 20,000,.   (4mks)
   9. Create a bar chart based on question (h) to display students Name and balance. Save as BALANCE CHART.
   10. Create a report named SUPERVISION to display Students names, Project Title, names of supervisor and supervision Dates . The records in the report should be grouped by students' Name and the number of supervisions by each student should be displayed.   (5mks)
   11. Title the report as supervision per lecturer.
   12. Print the following:
       
       • Tables: STUDENT, SUPERVISOR and SUPERVISIONS.   (2mks)
       • Queries: BALANCE and BALANCE 2     (2mks)
       • Report: SUPERVISIONS       (1mk)

MARKING SCHEME