Computer Studies Paper 3, May/June 2014
 Questions: 1 2 3 Main
Weakness/Remedies
Strength

Question 2

The Table shows the scores of ten(10) candidates in five(5) subjects.

(a)    Using a spreadsheet program, insert a heading:
‘‘CANDIDATES’ SCORES IN FIVE SUBJECTS’’ and centre it.
(b)    Create the table.
(c)    Using the appropriate formula, determine the:
(i)   total score for each candidate in column 8;
(ii)  average score for each candidate in column 9.
(d)    In the row following the tenth candidate, type the name of the best candidate and
his/her average score.
(e)    Save your work in a suitable storage device. Print out the hard copy of your work
and submit.

_____________________________________________________________________________________________________
Observation

The candidates were expected to use a spreadsheet program in creating a table with the title, ‘ CANDIDATES’ SCORES IN FIVE SUBJECTS’, use the appropriate formula of the program to do some calculations, determine the best candidate and his/her score, save their work and print out a hard copy.

The expected answers were:

As reported, many of the candidates made brilliant attempts while others had difficulties in creating the table/columns, centering and inserting the heading, calculating the total and average scores.