Kenya Certificate of Secondary Education
2019 Computer Studies – Paper 2
1.Form 1 Class Teachers of Mwango secondary school intend to use a data base to manage students o Secondary School intend to use a database to manage students performance in three examinations: opener,mid term and endterm examination.
(n) Open a database program and create a database named analysis.
(1 mark)
(b) (i) Create three tables named Class, StudDetails and StudMarks in the database file created in (a) using the following details: (14 marks)
Class Table
| Field Name | Data Type and Properties |
|---|---|
| ClassID | ClassID Text (size 2) |
| ClassName | ClassID Text (size 25) |
| Teacher | ClassID Text (size 25) |
StudDetails Table
| Field Name | Data Type and Properties |
|---|---|
| AdNo | Number |
| StudName | Text (size 25) |
| Gender | Yes/No (yes for female) |
| ClassID | Text (size = 2) Look up values,IE,IN,IW |
StudMarks Table
| Field Name | Data Type and Properties |
|---|---|
| AdNo | Number |
| Opener | Number |
| MidTerm | Number |
| EndTerm | Number |
(ii) Create the relationships between the tables. (2marks)
(iii) Create a form for the Class table and add a subform for the StudDetails table using the format in £gure 1. Save the form as dataentry.
ClassID
ClassName
Teacher
| AdNo | StudName | Gender | ClassID |
|---|---|---|---|
(iv) Enter the following data into their respective tables in the database (l2½ marks)
Class TabLe
| ClassID | ClassName | Teacher |
|---|---|---|
| IE | Form One East | Elvis Barongo |
| IN | Form One North | Alice Nadiya |
| IW | Form One West | Paul Mkacharo |
StudDetails Table
| AdNo | StudName | Gender | ClassID |
|---|---|---|---|
| 7984 | Mary Kikoti | Female | 1E |
| 7460 | Erica Kamburi | Female | 1E |
| 7800 | Axlam Khan | Male | 1E |
| 8083 | Martin Mkanjala | Male | 1E |
| 8092 | Esther Peresian | Female | 1N |
| 8490 | Micah Lokiyoto | Male | 1N |
| 8082 | Mohamed Ayan | Male | 1N |
| 7896 | Mark Kwalima | Male | 1W |
| 7892 | Morgan Lema | Male | 1W |
| 8184 | Emily Mawasi | Female | 1W |
| 8047 | Edward Omogeni | Male | 1W |
| AdNo | Opener | MidTerm | EndTerm |
|---|---|---|---|
| 7984 | 85 | Female | 82 |
| 7460 | 73 | Female | 79 |
| 7800 | 78 | Male | 86 |
| 8083 | 81 | Male | 87 |
| 8092 | 73 | Female | 83 |
| 8490 | 71 | Male | 87 |
| 8082 | 81 | Male | 90 |
| 7896 | 88 | Male | 88 |
| 7892 | 85 | Male | 89 |
| 8184 | 85 | Female | 83 |
| 8047 | 90 | Male | 86 |
(c) Create a query to display the fields:
(i) AdNO, StlldName, ClassID, Opener, MidTerm and EndTer m for all students in Form One East. Save the query as FIE. (4½ marks)
(ii) AdNo, StudName, ClassID, Opener, MidTerm and EndTerm arld a Calculated field named meanscore to display the average in the three examinations.
Save the query as overall. (6 marks)
(d) Create a report to display details of each student as it appears in Figure 2 (2 ½ marks)
(e) Print out each of the following: (3 marks)
(i) the three tables
(ii) the two queries
(iii) report for the first two students
2. The Chief Printer of Zenith Printers Company would like to have business cards. As a Desktop Publishing (DTP) expert, you have been tasked to design the card for the officer.
(a) (i) Open a Desktop Publishing program and set the page layout as follows:
• Paper size: 8.5 cm width by 5.5 cm height
• Layout type: multiple pages per sheet
• Target paper size: A4
• Orientation: Portrait
• Margin: 0.75cm all round (5 marks)
(ii) Save the publication as business card. ( 1 mark)
(b) Design the card as it appears in Figure 3 ensuring that the card covers all the space in the page. (42 marks)
(c) Print out 10 copies of the card on a single A4 pnge.(2 mark)
2020 KCPE Predictions
2020 KCSE Chemistry Prediction Questions
2020 KCSE Leakage
2020 KCSE Predictions
2020 KCSE Time Table
Biology KCSE 2020
Chemistry KCSE 2020
Cre KCSE 2020
English KCSE 2020
Geography KCSE 2020
History KCSE 2020
KCPE 2020 Predictions
KCPE Prediction Questions
KCPE Predictions 2020
KCSE 2020
KCSE 2020 Exam Timetable
KCSE 2020
KCSE 2020 Biology
KCSE 2020 Prediction
