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

 

 

  1. Using a spreadsheet program, insert the heading “MARK SHEET FOR SSI SCIENCE” and centre it.
  2. Create Table A1 with gridlines.
  3. Insert a row between index number S024 and S114, then add the following data:
  4. S007   Badamosi        23        45        72        40

  5. Using the appropriate formula, determine:
  6. (i) Total mark for each student; (ii) Average mark for each student; (iii) Average for the class.
  7. Copy Table A1, paste it three rows below on the same worksheet and name it Table A2
  8. Arrange Table A2 in descending order using the average column.
  9. 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.                                                                         

(c)        Insert a row between index number S024 and S114, then add the following data:
S007    Badamosi        23        45        72        40                                                       

(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.