STRATEGIC ALLIANCE
451 - COMPUTER STUDIES – FORM 4
Paper 2
(PRACTICAL)
Year 2024 - 2 ½ hours
MARKING
SCHEME
Page 1
QUESTION ONE (50 MARKS)
The management of Kirinyaga East Drama festival intends to award certificates of merit to the
students who attended this year competition. Assuming that you have been tasked to design the
certificates:
a) Open a desktop publishing program and make the following page settings. [4 marks]
Orientation: landscape correct orientation 1 mk
Units: Centimeters correct units 1 mk
Paper size: A4 correct papersize 1 mk
Margins: 0.64 cm all round correct margin 1 mk
b) Create the certificate as it appears in the figure below. Save it as Cert. [45 marks]
Three- line border + correct colours: 6 mks
Top logo: 5 mks
Certificate header: 3 mks
Kirinyaga east subcounty: 1 mk
Certificate of merit: 2 mks
Being awarded to (text and line): 2 mks
School (text and line): 2 mks
Item (text and line): 2 mks
For outstanding performance(text): 1 mk
Held at on (text and line): 2 mks
Chairperson (text and line): 2 mks
Adjudicators (text and line): 4 mks
Left hand logo: 5 mks
Right hand trophy: 5 mks
The bottom right shape and text: 3 mks
c) Print out the certificate. [1 mark]
Page 2
NB:
while awarding marks consider:
Candidate’s creativity
Accuracy of symbols
Font sizes
Font colours
Proportionality of the certificate design
Proper use of the work space
Page 3
QUESTION TWO (50 MARKS)
a) Create a new workbook and name it as ExamData.
NAME CLASS ADM CAT1 CAT2 CAT3 TOTA AVERAGE CLASS REMARKS
NO L POSITION
Maina Joan E 7984 80 70 59
Ken Korir W 7896 75 55 72
Benard K E 8092 86 59 75
John Soi E 7460 80 79 70
Kipsang Bett W 7892 76 75 80
Mitei E E 7800 38 48 25
Mark J W 8490 37 51 29
Koech Ben W 8184 30 86 75
James W E 8082 25 27 20
Abuya Ken E 8033 30 25 25
Leonard B W 8047 39 24 25
b) Enter the following data in sheet 1. [20 marks]
c) Rename the sheet as term one results. [1 mark]
d) Find:
i) Totals [2 marks]
=SUM(D2:F2)
ii) Average. [2 marks]
=AVERAGE(D2:F2)
e) Use IF Function to award remarks as follows:
- An average above or equal to 65 gets ‘Excellent.’
- An average of 55 or above but less than 65 gets ‘Average’
- An average of less than 55 award ‘Below Average’ [3 marks]
=IF(H2>=65,"Excellent",IF(H2>=55,"Average","Below Average"))
Page 4
f) i) Award positions to students basing on the average score. [3 marks]
=RANK(H2,$H$2:$H$12,0)
ii) On the last rows enter formulas to count students from both classes. [2 marks]
=COUNTIF(B2:B12,"=E")
=COUNTIF(B2:B12,"=W")
g) Sort the students list by class position in ascending order. [2 marks]
Correct order: 2 mks
h) i) Copy the worksheet and rename it as filtered. [2 marks]
Correct naming: 2 mks
ii) Filter the data to display students from class ‘E’ with an average less than 50. [2 marks]
Correct filtering: 2 mks
i) i) Insert a bar graph to display the information below:
- The three CATS
- Names
- Title as ‘TERM ONE COMPUTER RESULTS’ [5 marks]
Correct type of graph: 2 mks
Correct range: 2 mks
Correct title: 1 mk
ii) Place the legend at the bottom of the graph. [2 marks]
Correct position of the legend: 2 mks
iii) Save the chart on a new sheet and name it as graphical analysis. [1 mark]
Correct saving: 1 mk
j) Print:
i) The filtered worksheet. [1 mark]
ii) The graphical analysis worksheet. [1 mark]
iii) Term one results worksheet. [1 mark]
Page 5
