KCSE Computer Studies Paper 2 and 3: Questions and Answers
1. (a) Create a database called SCHOOL. (2 Marks) (b) Create three tables Examination, DOS and BOARDING with the fields as shown below. (10 Marks) (c). Create a relationship between the three tables and enforce integrity. (6 Marks) (d). Enter the data items in the given tables three tables. (15 Marks)
(e) Design a query that would display the following fields as shown below and write down the formulae for getting the total score and criteria for extracting the records below (10 Marks)
(f) Design a report that would sort the following in ascending order in the order of the following fields, Total score, KCPE Score, SName the Admission Number and the report should display all the fields. Save the report as administration (5 Marks) (g) Print, administration and admin (2Marks)
0 Comments
HOW TO START A KCSE PROJECT IN COMPUTER1. Read the question paper thoroughly
Download the question paper here and read it vigorously. Take note of the key points necessary to get you through.
You must have an exercise book where you write progress in every advancing stage.
Take note of the following:
2. Consult your teacher on necessary guidelines
Your teacher should be the touch bearer in your project. He/She is in charge of the project and is required by the KNEC body to guide you in every step you make.
3. follow the sdlc stages in order
Follow all system development life cycle stages in order of their precedent to pursue the project. But remember, to document every step you make because this will be essential when writing your report.
![]()
![]()
![]()
![]()
![]()
![]()
COMPUTER STUDIES PP2 QUESTION PAPER ON SPREADSHEETS AND DATABASE MODEL05122022003![]()
COMPUTER STUDIES PAPER 2 DTP AND SPREADSHEETS MODEL25112022001![]()
![]()
COMPUTER STUDIES REVISION KITS 2022 TERM 2 PAPER 2 SPREADSHEETS AND DATABASE MODEL1709202200417/9/2022 ![]()
![]()
![]()
DESKTOP PUBLISHING 8 QUESTIONS MODEL DTP30112021008![]()
DESKTOP PUBLISHING 7 QUESTIONS MODEL DTP30112021007![]()
DESKTOP PUBLISHING 9 QUESTIONS MODEL DTP30112021009![]()
DESKTOP PUBLISHING 10 QUESTIONS MODEL DTP30112021010![]()
DESKTOP PUBLISHING 11 QUESTIONS MODEL DTP30112021011![]()
DESKTOP PUBLISHING 12 QUESTIONS MODEL DTP18112021012![]()
DESKTOP PUBLISHING 4 QUESTIONS MODEL DTP30112021004![]()
DESKTOP PUBLISHING 5 QUESTIONS MODEL DTP30112021005![]()
DESKTOP PUBLISHING 6 QUESTIONS MODEL DTP30112021006![]()
DESKTOP PUBLISHING 3 QUESTIONS MODEL DTP30112021003![]()
DESKTOP PUBLISHING 2 QUESTIONS MODEL DTP30112021002![]()
DESKTOP PUBLISHING 1 QUESTIONS MODEL DTP30112021001![]()
DESKTOP PUBLISHING 1 QUESTIONS MODEL DTP30112021001![]()
SPREADSHEETS 37 PRACTICAL QUESTIONS MODEL SP02112021037![]()
SPREADSHEETS 36 PRACTICAL QUESTIONS MODEL SP02112021036![]()
![]()
|
We Would Love to Have You Visit Soon! |
Hours24 HR Service
|
Telephone0728 450425
|
|
8-4-4 materialsLevels
Subjects
|
cbc materialsE.C.D.E
Lower Primary
Upper Primary
Lower Secondary
Upper Secondary
|
teacher support
Other Blogs
|