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

Share via Whatsapp

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

 


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


Tap Here to Download for 50/-




Why download?

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


Join our whatsapp group for latest updates
Get on WhatsApp Download as PDF
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?