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
|
Can't find what you are looking for? Don't worry, Use the Search Box Below.
Primary Resources
College Resources
|
Secondary Resources
|
Contact Us
Manyam Franchise
P.O Box 1189 - 40200 Kisii Tel: 0728 450 424 Tel: 0738 619 279 E-mail - sales@manyamfranchise.com |