Computer Studies Paper 3, WASSCE (SC), 2018

Question 1

 

  1. The table below shows scores of six students in Computer Studies at Top Hill High School. Use the font Times New Roman with font size 12 pt in spreadsheet application to prepare the information given in the table.

Student I.D.

1st Term

2nd Term

3rd Term

1st Term W/Score

2nd Term W/Score

3rd Term W/Score

Total W/Score

  THHS2015040

69

56

74

 

 

 

 

  THHS2015032

77

82

90

 

 

 

 

  THHS2015025

67

55

48

 

 

 

 

  THHS2015067

56

87

68

 

 

 

 

  THHS2015055

54

59

70

 

 

 

 

  THHS2015043

63

48

64

 

 

 

 

  1. Insert a:
  2. new column with the heading ”Name” between the first and second columns;
  3. title “Students’ Scores in Computer Studies” above the table.
  4. Beginning from the first cell under column heading “Name” to the sixth cell, type the following:

Adedigba Eze, Balango Ngozi, Agbeloro Cynthia, Okeowo Sulkite, Okonia Ifedola and Umaru Edonk.

  1. If “W/Score” stands for weighted score, calculate:
  2. weighted score for each term given that weighted scores comprises 20%, 30% and 50% of raw scores for first, second and third terms respectively;
  3. total weighted score for the three terms.
  4. Insert your full name and index number as a footer.
  5. Save with your index number in the folder created.
  6. Print and submit to the supervisor.

Observation

 

Candidates were required to use MS Excel to perform tasks.

Most of the candidates as reported, showed good skill in the area tested but a good number of the candidates could not use footers correctly.