Computer Studies Paper 2 Marking Scheme
KCSE CLUSTER TESTS 26
Computer Studies Paper 2
QUESTION 1 (50 Marks)
1.
- Presence of database Use of the correct name
- Presence of the two tables @l/2 =
Correct naming @l/2
Correct decomposition @1 - Presence of relation = Enforced integrity
- 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
- 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
- Report presence = 2 mk
Well named 1 mks
Correct title 1 mks
Outlined = 2 mks
Summary 2 mks
- Presence of the query 2 mks
Correct query name 1 mks
Correct criteria (2 mks for each part) 4 mks - 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
- mk
- mks 1 mk
- mks
- 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
- Subject totals using a function/formulaâ…Ÿ2*5
- Total marks per stream â…Ÿ2 *10
- Mean mark for each student â…Ÿ2 *10
- Ranking for every student â…Ÿ2 *10
- 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
- Sorting of records 2 mks
Average using subtotals Yz*10 5 mks - Printing the three sheets
- 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