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 page.(2 mark)