2019 KCSE Computer Studies Paper 2 Past Paper-Free KCSE Past Papers with Answers.

2019 KCSE Computer Studies Paper 2 Past Paper

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 NameData Type and Properties
ClassIDClassID Text (size 2)
ClassNameClassID Text (size 25)
TeacherClassID Text (size 25)

StudDetails Table

Field NameData Type and Properties
   AdNoNumber
StudNameText (size 25)
GenderYes/No (yes for female)
ClassIDText (size = 2)
Look up values,IE,IN,IW

StudMarks Table

Field NameData Type and Properties
AdNoNumber
OpenerNumber
MidTermNumber
EndTermNumber

(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

ClassIDClassNameTeacher
                IEForm One East  Elvis Barongo
                INForm One North   Alice Nadiya
                IWForm One WestPaul Mkacharo

StudDetails Table

    AdNoStudNameGenderClassID
7984Mary KikotiFemale1E
7460Erica KamburiFemale1E
7800Axlam KhanMale      1E
       8083    Martin MkanjalaMale      1E
      8092    Esther Peresian        Female1N
8490    Micah Lokiyoto        Male1N
     8082    Mohamed AyanMale1N
    7896Mark Kwalima        Male    1W
    7892    Morgan Lema       Male1W
    8184    Emily MawasiFemale1W
    8047    Edward OmogeniMale1W
    AdNoOpenerMidTerm EndTerm
7984      85Female82
746073Female79
7800       78Male86
       8083        81Male87
      809273        Female83
849071        Male87
     808281Male90
789688        Male88
7892     85       Male89
8184    85Female83
8047        90Male86

(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)

2019 KCSE Computer Studies Paper 2 Past Paper-Marking Scheme/Answers

1 (a)(i) √ Creating the file @ 1

(b) (i) Creating class table @½

√ Creating the table @½ = 1½

√ Applying correct datatype for 3 fields

√ Applying correct field size 1@½

Creating studDdetails table

√ Creating the table @½

√ 4 fields @½ = 2

√ Applying correct data type = @½ = 2

√ Applying correct properties = ½

√ Look up values @1

Creating of StudMarks table

√ Creating the table @½ = 2

√ Data type 4 fields @½ = 2

√ properties = ½

(ii) Relationship (2 each @1_ = 2

(iii) Creating Forms

√ Insertion of a form object @½

√ Insertion of 3 text boxes @½ = 1½

√ Insertion of 3 labels @½ = 1½

√ Insertions of the subform @1

(v) Data entry (in the three tables)

√ 25 records each @½ = 12½

(c) (i) FIE Query

√ Insertion of query @½

√ Insertion of 6 fields @½ = 3

√ Applying constraints (form lE) @½

√ Saving @½

(ii) Overall query

√ Query insertion @½

√ Insertion of 6 fields @½ = 3

√ Inserting a calculated field @1

√ Performing calculations @1

√ Saving @½

(d) Report

√ Insertion of header @1

√ Dropping the correct fields @1

√ Applying formats (Arrangement of controls) @½

(e) Printing √ 3 tables @½ =1½

√ 2 queries @½ = 1½

√ 1 report @½

3 TOTAL 50

2 (a) Page Layout

each layout specification @l = 5 Saving @l

(b) Card Border line

√ Rectangle @l

√ Applying curved comers @l

√ Line thickness @/2

√ Arrangement of elements @l

Zenith printers (black section)

√ Rectangle @l & semicircle @l

√ Black filled @l

√ Text only @l

√ Text colour @l

√ White edge @l

√ Arrangement of elements @l

Ngele Kikomi

√ Text only @2

√ Applying underline

√ Applying bold @½

√ Arrangement of elements @l

University Drive

√ Text only @2

√ Text formatting @l

√ Arrangement of elements @l

Arrow head dots

√ Drawing of circle dot @l

√ Arrangement of dots @l

√ Relative position on the card

Printer Logo

√ 2 rectangles each @½ = 1

√ Round edge on the rectangle @l

√ Thick line @l

√ Thin lines @l

√ parallel thin lines @l

√ Applying white background (to hide sections of lines) @l

√ arrangement of elements @l

We create text √ Text only @2

√ Bullets @l

√ Applying white colour/background @l

√ Arrangement of elements @l

Tilted lines bars

√ Rectangular outline @l

√ Applying filled pattern @l

√ Positioning @l

√ Removing borders @l

NO MARKING POINTS

Quality service

√ Text only @l

√ Italics formats @1

√ Positioning

General Card layout

√ Coverage ≥ 80% of the page @l

√ Use of appropriate font sizes @l

√ Use of appropriate line weights @l

Printing

√ Print a card @l

√ Printing 10 cards per paper @l