Computer Studies Paper 2 Questions and Answers - Cekenas Mock Exams 2022

UESTIONS

Question 1

1. The following table was extracted from a form four class. Create a workbook named performance .Enter it as it is and save it as grades.  Use it to answer the questions that follow. (12mks)
2. Add the following two students before victor and enter the following information: (3mks)
   Name:            Thomas, Washington.
   Exam 1:            82                    65
   Exam 2:            75                    79
   Exam 3:            81                    84
   Paper:               87                    92
   Participation:     94                   65
3. Copy the data in the worksheet grade and paste it in worksheet 2 and save as Rank. (2mks)
4. Calculate the final average for each student.  The three exams should each count 25% of the final average, the paper should count for 15%, and participation should count for the remaining 10%. Using Absolute cell referencing. (5mks)
5. Calculate the class average for each exam. (3mks)
6. Apply one decimal point to the average point  (2mks)
7. Rank the students based on average points (3mks)
8. Sort the students based on rank after average in ascending order (2mks)
9. Create a column after rank and name it Grade. Using IF function, grade the students based on the following criteria. (A=90-100; B=80-89; C=70-79; D=60-69; F=below 60)  (6mks)
10. Below the average for each exam get the highest score and lowest score for exam1, exam2, and exam3 (4mks)
11. Create a chart that shows the grade distribution for the final average and insert in a new worksheet. (5mks)
12. Print the following GRADE, RANK and CHART (3mks)

Question 2
The following tables were extracted from king secondary school.
STUDENTS TABLE

EXAMS

LIBRARY TABLE

1. Create a database file and name it as KingsSchool (2 mks)
2. Design the tables listed above and set the most appropriate primary key and data types. (9mks)
3. Create appropriate relationships among the table and enforce referential integrity (3mks)
4. Create appropriate form to enter the records above. (9mks)
5. Design the query that shows list of students who have borrowed books in the Library. Save the query as borrowed books (3mks)
6. Using a query, Calculate the total scores for each student. Save the query as totals.(4mks)    
7. Create a query called Age to display Adm No, Book No, Student name, D.O.B and Age of the student by the year 2021. (5mks)
8. Design a query to extract the list of students whose name has letter A. Save the query as THE A     (4 mks)
9. Create a report to display student name, subject score, total scores per subject and the average score per subject grouped by classes’ performance. Save the report as performance.   (6 mks)
10. Create a report of all students and save it as students.   (2 mks)
11. Print the following;  (3 mks)
    1. Library table
    2. Totals query
    3. Performance report. 

MARKING SCHEME

Question 1

1. saving workbook 
   heading
   Merging cells 
   records12 @0.5
   Borders 
   Centre alignment 
2. Names correctly entered  2@1.5
3. Correctly saved work 
   naming worksheet Rank 
4. Correct  average 
   Absolute cell referencing @1
   correct calculation @1 
5. apply one decima point to average 
6. Class average 3*1 
7. Rank function 
   correct calculation 
8. sorting using average 
   ascending order 
9. inserting column @1
   Naming   @1 
   If Function 
   Displaying  the correct results 
10. MAX (3*0.5) 1.5
    MIN(3*0.5) 1.5
11. Title of the chart 
    axis 
    Legend 
    inserting the chart in a new sheet 
    correct  chart
12. Printing
    GRADE 1
    RANK 1
    CHART 1
    Total - 50

Question 2

Required Mark(s) Award
Database Named KingsSchool

1. correct Database Saving@1, other 0.5 
2. Table Students 2.5
   p.k 
   Table Exams 2.5
   Table library 2
   p.k 1
3. Relationship
   Approppriate Relationship 2 @ 0.5 
   Enforcng Referentoial Integrity 
4. Forms
   Create forms 2@3<span< a=""> style="white-space:pre"> 6 </span<>
   Correct records entered @ 0.5 10
5. Borrowed borrowed books query
   saving 
   Books borrowed 
6. Totals calculation Query
   Correct saving 
   correct Result 
7. Age Query
   Correct saving 
   Correct fields selected 
   correct Result 
8. THE A query
   correct saving 
   Correct query 
9. Performance report
   correct  report saving 
   correct field selected 
   correct grouping 
   correct result
10. students report
    saving 
    correct report 
11. printing 
    Total - 50