Search
Free School Management System
Free School Management System for Kenya

Free School Management System

Learn More

KCSE CLUSTER TESTS 26

Computer Studies Paper 2

QUESTION 1 (50 Marks)

1.
  1. Presence of database Use of the correct name
  1. Presence of the two tables @l/2 =
    Correct naming @l/2
    Correct decomposition @1
  2. Presence of relation = Enforced integrity
  3. Presence of two forms @1 =
    Use of correct form names @1 =
    Complete data entry in each table @4 =
    Presence of errors up to 4 errors (deduct 2 mks per table)
    Incomplete data entry award ⅟2 marks per table
  1. Query to retrieve who cleared (calculate balance) 2 mks

(With the correct criteria) 2 mks
Presence of report 1 mks

Correct name of report 1 mks

Correct title 1 mks

Correct records 1 mks

All buyer details 2 mks

  1. Report presence = 2 mk

Well named 1 mks

Correct title 1 mks

Outlined = 2 mks

Summary 2 mks

  1. Presence of the query 2 mks
    Correct query name 1 mks
    Correct criteria (2 mks for each part) 4 mks
  2. Presence of the report 1 mks
    Vehicle type summary 1 mk
    Grand total 1 mks

i. Presence of print outs @ % *4 1 mks
landscape @l/4*4 1 mks

TOTAL

1 mark 1 mark 1 Mk

  1. mk
  2. mks 1 mk
  1. mks
  2. mks 2 mks 8 mks

10 mks

8 mks

7 mks

3 mks

2 mks

50 marks

QUESTION 2 (50 Marks)

2.

Presence of workbook 1 mks

Correctly saved (correct name) 1 mks

10 records correctly entered (5)1/2*10 5 mks

Auto fit columns @l/2 *10 5 mks

Presence of borders 3 mks

  1. Subject totals using a function/formula⅟2*5
  2. Total marks per stream ⅟2 *10
  3. Mean mark for each student ⅟2 *10
  4. Ranking for every student ⅟2 *10
  5. Presence of a column chart 1 mks
    Correct content 1 mks
    Labeling x-axis 1 mks

Y-axis 1 mks

Legend 1 mks

Title 1 mks

Different sheet 1 mks

  1. Sorting of records 2 mks
    Average using subtotals Yz*10 5 mks
  2. Printing the three sheets
  3. TOTAL

GRAND TOTAL

15 mks 3 mks 5 mks 5 mks 5 mks

7 mks

7 mks 3 mks

50 MARKS

100 MARK

50 marks

Back Top