Computer Studies Paper 3, May/June 2015

Question 2

The Table A1 below shows the performance of students in an end-of-term examination in a certain secondary school.
TABLE A1

Index Number	Name	Physics	Chemistry	Biology	English Language	Total	Average
S001	Aminu	65	78	56	45
S142	Olabode	53	85	88	78
S024	Onuka	45	96	43	98
S114	Goddey	78	76	76	65
S115	Jang	23	54	74	36
S056	Dan-Sokoto	78	32	64	52

Using a spreadsheet program, insert the heading “MARK SHEET FOR SSI SCIENCE” and centre it.
Create Table A1 with gridlines.
Insert a row between index number S024 and S114, then add the following data:

S007 Badamosi 23 45 72 40

Using the appropriate formula, determine:

each

Copy Table A1, paste it three rows below on the same worksheet and name it Table A2
Arrange Table A2 in descending order using the average column.
Save your work on a suitable storage medium. Print out your work and submit.

Observation

The expected answers were:
(a) Inserting the heading “MARK SHEET FOR SSI SCIENCE”

(b) Creating TABLE A1 with gridlines.

(d)       (i)         Total mark for each student;
(ii)        Average mark for each student;
(iii)       Average for the class.

(e) Copy TABLE A1 and pasting it three rows below. Naming it TABLE A2

(f) Arrange TABLE A2 in descending order, using the average column

(g) Print-out

TABLE A1

MARK SHEET FOR SS1 SCIENCE
Index Number	Name	Physics	Chemistry		Biology		English Language		Total		Average
S001	Aminu	65	78		56		45		244		61
S142	Olabode	53	85		88		78		304		76
S024	Onuka	45	96		43		98		282		70.5
S007	Badamosi	23	45		72		40		180		45
S114	Goddey	78	76		76		68		298		74.5
S115	Jang	23	54		74		36		187		46.75
S056	Dan-Sokoto	78	64		64		52		258		64.5
	CLASS AVERAGE=		62.6071429



TABLE A2
MARK SHEET FOR SS1 SCIENCE
Index Number	Name	Physics		Chemistry		Biology		English Language		Total		Average
S142	Olabode	53		85		88		78		304		76
S114	Goddey	78		76		76		68		298		74.5
S024	Onuke	45		96		43		98		282		70.5
S056	Dan-Sokoto	78		64		64		52		258		64.5
S001	Amin	65		78		56		45		244		61
S115	Jang	23		54		74		36		187		46.75
S007	Badomasi	23		45		72		40		180		45
	CLASS AVERAGE=			62.6071429

Candidates were required to use a Spreadsheet package to answer the question. Most of the candidates used the application but majority of them lacked the knowledge of using the appropriate formula to calculate in MS Excel.