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

 AdmNo StudentName Class Male DOB 1021 AMOS WOKO 4E Y 10/08/2005 1023 JUNE KENDI 4N N 23/01/2002 1025 WINNIE OMOKE 4N N 02/07/2003 1027 CHARLES  OPIYO 4E Y 10/04/2001

EXAMS

 Term AdmNo Opener MidTerm EndTerm T1/2021 1021 56 65 45 T2/2021 1021 78 76 67 T1/2021 1023 77 78 78 T2/2021 1023 45 67 70 T1/2021 1025 87 56 85 T2/2021 1025 67 74 69 T1/2021 1027 68 69 58 T2/2021 1027 83 89 56

LIBRARY TABLE

 AdmNo BookNo BookTitle DateIssued 1021 COMP 2/002 LOG ON COMPUTER BOOK 2 10/2/2020 1023 COMP 2/004 LOG ON COMPUTER BOOK 2 10/2/2020 1025 COMP 2/001 LOG ON COMPUTER BOOK 2 20/2/2020 1027 COMP 3/007 LOG ON COMPUTER BOOK 3 11/2/2020 1027 COMP 4/004 LOG ON COMPUTER BOOK 4 10/2/2020 1023 COMP 4/006 LOG ON COMPUTER BOOK 4 11/2/2020 1025 COMP 3/002 LOG ON COMPUTER BOOK 3 6/2/2020 1023 COMP 1/004 LOG ON COMPUTER BOOK 1 6/2/2020
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
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
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

• ✔ To read offline at any time.
• ✔ To Print at your convenience
• ✔ Share Easily with Friends / Students