KCSE Past Papers 2019 Computer Studies Paper 2 (451/2)

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)

(Visited 301 times, 1 visits today)
Share this:

Written by