1(a) The table below shows the scores of six students in computer studies at Top Hill High School. Use the font Times New Roman with 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 b:
(i) new column with the heading “Name” between the first and second columns;
(ii) title “Students’ Scores in Computer Studies” above the table.
(c) Beginning from the first cell under column heading “Name” to the sixth cell, type the following: Adedigba Eze, Balango Ngozi, Agbelero Cynthia, Okeowo Sulkite, Okonia Ifedola, and Umaru Edonk.
(d) If “W/score” stands for weighted score, calculate:
(i) weighted score for each term given that weighted score comprises 20%, 30%, and 50% of raw scores for first, second, and third terms respectively;
(ii) total weighted score for the three terms.
(e) Insert your full name and index number as a footer.
(f) Save with your index number in the folder created.
(g) Print and submit to the supervisor
Explanation
..