Question 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 |
|
|
|
|
- Insert a:
- new column with the heading ”Name” between the first and second columns;
- title “Students’ Scores in Computer Studies” above the table.
- 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.
- If “W/Score” stands for weighted score, calculate:
- weighted score for each term given that weighted scores comprises 20%, 30% and 50% of raw scores for first, second and third terms respectively;
- total weighted score for the three terms.
- Insert your full name and index number as a footer.
- Save with your index number in the folder created.
- Print and submit to the supervisor.
Observation
Candidates were required to use MS Excel to perform tasks.