Spreadsheet: 844415d1696194312-calculating-percentage-and-grading-test-score-template
Sheet: Sheet1

SCHOOL |  |  |  |  |  |  |  |  |  |  | TOTAL POPULATION |  |  | Term Bigins
 |  | CLASS |  |  | TERM |  | NO. IN CLASS |  | GENDER |  | GENDER POPULATION |  |  | Term Ends
 |  |  |  |  | [NAME] |  |  | ENGLISH LANGUAGE |  |  |  |  | MATHEMATICS |  |  |  |  | Basic Science & Technology |  |  |  |  | Pre-Vocational Studies |  |  |  |  | National Values |  |  |  |  | Religious Studies |  |  |  |  | French |  |  |  |  | History |  |  |  |  | Business Studies |  |  |  |  | Cultural & Creative Art |  |  |  |  | Yoruba/Igbo |  |  |  |  | …...........
S/N | NAME | GENDER | Date of Birth | CLASS | PRESENT | ABSENT | NO OF TIMES SCHOOL OPENED | 40% [NAME] | 60% [NAME] | 100% [NAME] | [NAME] | Teachers Comment English Language | 40% Maths | 60% Maths | 100% Maths | [NAME] | Teachers Comment Mathematics | 40% BST | 60% BST | 100% BST | Grade Basic Science & Technology | Teachers Comment Basic Science & Technology | 40% PVS | 60% PVS | 100% PVS | [NAME] | Teachers Comment Pre-Vocational Studies | 40% NV | 60% NV | 100% NV | Grade National Values | Teachers Comment National Values | 40% Rel. [NAME]. | 60% Rel. [NAME]. | 100% Rel. [NAME]. | Grade Religious Studies | Teachers Comment Religious Studies | 40% French | 60% French | 100% French | Grade French | Teachers Comment Fench | 40% History | 60% History | 100% History | [NAME] | Teachers Comment History | 40% Bus. [NAME]. | 60% Bus. [NAME]. | 100% Bus. [NAME]. | Grade Business Studies | Teachers Comment Business Studies | 40% CCA | 60% CCA | 100% CCA | Grade Cultural & Creative Art | Teachers Comment Cultural & Creative Art | 40% Lang. | 60% Lang. | 100% Lang. | Grade Yoruba/Igbo | Teachers Comment Yoruba/Igbo | 0.4 | 0.6 | 1 | Grade | Teachers Comment | TOTAL | PERCENTAGE (%) | POSITION | GRADE | REMARK | Form Masters Comment | Principals Comment
1 | Abdulafeez Zainab Tomilola |  |  |  |  |  |  | 27 | 26 |  |  |  | 30 | 29 |  |  |  | 20 | 32 |  |  |  | 19 | 35 |  |  |  | 18 | 32 |  |  |  | 30 | 40 |  |  |  | 22 | 43 |  |  |  | 35 | 43 |  |  |  | 24 | 30 |  |  |  | 34 | 30 |  |  |  | 23 | 27
2 | Abideen Tawakalitu |  |  |  |  |  |  | 13 | 13 |  |  |  | 20 | 15 |  |  |  | 20 | 31 |  |  |  | 29 | 21 |  |  |  | 15 | 20 |  |  |  | 26 | 33 |  |  |  | 14 | 36 |  |  |  | 15 | 11 |  |  |  | 23 | 27 |  |  |  | 33 | 27 |  |  |  | 23 | 29
3 | [NAME] |  |  |  |  |  |  | 26 | 29 |  |  |  | 32 | 30 |  |  |  | 20 | 33 |  |  |  | 27 | 38 |  |  |  | 16 | 34 |  |  |  | 23 | 33 |  |  |  | 29 | 32 |  |  |  | 30 | 14 |  |  |  | 23 | 29 |  |  |  | 32 | 18 |  |  |  | 25 | 33
4 | [NAME] |  |  |  |  |  |  | 24 | 30 |  |  |  | 32 | 18 |  |  |  | 21 | 35 |  |  |  | 28 | 36 |  |  |  | 19 | 32 |  |  |  | 33 | 48 |  |  |  | 23 | 46 |  |  |  | 31 | 26 |  |  |  | 25 | 33 |  |  |  | 32 | 24 |  |  |  | 19 | 55
5 | Afeez Mojeed |  |  |  |  |  |  | 21 | 19 |  |  |  | 20 | 21 |  |  |  | 28 | 30 |  |  |  | 23 | 38 |  |  |  | 11 | 30 |  |  |  | 23 | 33 |  |  |  | 22 | 45 |  |  |  | 12 | 24 |  |  |  | 19 | 55 |  |  |  | 35 | 26 |  |  |  | 19 | 47
6 | [NAME] |  |  |  |  |  |  | 26 | 16 |  |  |  | 25 | 16 |  |  |  | 28 | 30 |  |  |  | 27 | 23 |  |  |  | 12 | 32 |  |  |  |  |  |  |  |  | 19 | 45 |  |  |  | 28 | 23 |  |  |  | 19 | 47 |  |  |  | 36 | 29 |  |  |  | 16 | 19
7 | Akinsola Eniola Success |  |  |  |  |  |  | 30 | 20 |  |  |  | 35 | 26 |  |  |  | 20 | 30 |  |  |  | 21 | 30 |  |  |  | 14 | 24 |  |  |  |  |  |  |  |  | 34 | 39 |  |  |  |  |  |  |  |  | 16 | 19 |  |  |  | 34 | 21 |  |  |  | 26 | 26
8 | Akoshile Yunus Olarewaju |  |  |  |  |  |  | 32 | 26 |  |  |  | 20 | 30 |  |  |  | 20 | 31 |  |  |  | 25 | 25 |  |  |  | 16 | 36 |  |  |  | 24 | 38 |  |  |  | 14 | 43 |  |  |  | 14 | 17 |  |  |  | 26 | 26 |  |  |  | 34 | 37
9 | [NAME] |  |  |  |  |  |  | 27 | 23 |  |  |  | 20 | 30 |  |  |  | 20 | 32 |  |  |  | 23 | 34 |  |  |  | 12 | 39 |  |  |  | 33 | 30 |  |  |  | 23 | 41 |  |  |  | 27 | 30 |  |  |  |  |  |  |  |  | 32 | 27 |  |  |  | 21 | 31
10 | [NAME] |  |  |  |  |  |  | 24 | 26 |  |  |  | 23 | 27 |  |  |  | 26 | 30 |  |  |  | 22 | 20 |  |  |  | 11 | 16 |  |  |  | 27 | 25 |  |  |  | 11 | 39 |  |  |  |  |  |  |  |  | 21 | 31 |  |  |  | 32 | 19 |  |  |  | 24 | 33
11 | Babatunde Yusuf Ayinde |  |  |  |  |  |  | 5 | 20 |  |  |  | 20 | 15 |  |  |  | 20 | 31 |  |  |  | 21 | 18 |  |  |  | 10 | 22 |  |  |  | 24 | 26 |  |  |  | 12 | 39 |  |  |  | 11 | 24 |  |  |  | 24 | 33 |  |  |  | 34 | 37 |  |  |  | 23 | 32
12 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 32
13 | Ekeogu Daniel |  |  |  |  |  |  | 30 | 25 |  |  |  | 29 | 25 |  |  |  | 26 | 30 |  |  |  | 26 | 27 |  |  |  | 14 | 22 |  |  |  | 26 | 38 |  |  |  | 16 | 44 |  |  |  | 13 | 23 |  |  |  |  |  |  |  |  | 31 | 37 |  |  |  | 22 | 40
14 | [NAME] |  |  |  |  |  |  | 23 | 17 |  |  |  | 20 | 19 |  |  |  | 20 | 30 |  |  |  | 21 | 34 |  |  |  | 16 | 23 |  |  |  |  |  |  |  |  | 30 | 40 |  |  |  |  |  |  |  |  | 22 | 40 |  |  |  | 33 | 24 |  |  |  | 25 | 33
15 | [NAME] |  |  |  |  |  |  | 26 | 24 |  |  |  | 22 | 28 |  |  |  | 20 | 32 |  |  |  | 24 | 26 |  |  |  | 16 | 37 |  |  |  | 24 | 43 |  |  |  | 25 | 45 |  |  |  | 12 | 24 |  |  |  | 25 | 33 |  |  |  | 32 | 39 |  |  |  | 21 | 46
16 | Igboekwusi Ikechukwu |  |  |  |  |  |  | 31 | 30 |  |  |  | 32 | 21 |  |  |  | 20 | 38 |  |  |  | 28 | 46 |  |  |  | 12 | 47 |  |  |  | 34 | 47 |  |  |  | 32 | 41 |  |  |  | 23 | 28 |  |  |  | 21 | 46 |  |  |  | 32 | 38 |  |  |  | 25 | 30
17 | Ikechukwu [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 30 |  |  |  |  |  |  |  |  | 25 | 32
18 | Ilemoboye Emmanuel Felix |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 32 |  |  |  |  |  |  |  |  | 27 | 47
19 | [NAME] |  |  |  |  |  |  | 29 | 29 |  |  |  | 32 | 19 |  |  |  | 24 | 26 |  |  |  | 28 | 33 |  |  |  | 14 | 40 |  |  |  | 32 | 33 |  |  |  | 37 | 46 |  |  |  | 29 | 34 |  |  |  | 27 | 47 |  |  |  | 34 | 30 |  |  |  | 23 | 35
20 | [NAME] |  |  |  |  |  |  | 24 | 26 |  |  |  | 35 | 19 |  |  |  | 24 | 30 |  |  |  | 23 | 31 |  |  |  | 17 | 25 |  |  |  |  |  |  |  |  | 23 | 40 |  |  |  |  |  |  |  |  | 23 | 35 |  |  |  | 30 | 25 |  |  |  | 24 | 27
21 | [NAME] |  |  |  |  |  |  | 4 | 21 |  |  |  | 32 | 19 |  |  |  | 23 | 27 |  |  |  | 22 | 30 |  |  |  | 5 | 31 |  |  |  | 26 | 33 |  |  |  | 19 | 39 |  |  |  | 11 | 19 |  |  |  | 24 | 27 |  |  |  | 34 | 41 |  |  |  | 23 | 35
22 | [NAME] |  |  |  |  |  |  | 21 | 23 |  |  |  | 20 | 17 |  |  |  | 23 | 27 |  |  |  | 18 | 23 |  |  |  | 21 | 29 |  |  |  | 24 | 39 |  |  |  | 19 | 48 |  |  |  |  |  |  |  |  | 23 | 35 |  |  |  | 33 | 30 |  |  |  | 19 | 31
23 | [NAME] Kolade |  |  |  |  |  |  | 26 | 16 |  |  |  | 20 | 19 |  |  |  | 20 | 30 |  |  |  | 26 | 24 |  |  |  | 12 | 22 |  |  |  | 25 | 25 |  |  |  | 18 | 42 |  |  |  |  |  |  |  |  | 19 | 31 |  |  |  | 33 | 26 |  |  |  | 20 | 38
24 | [NAME] |  |  |  |  |  |  | 25 | 25 |  |  |  | 32 | 19 |  |  |  | 21 | 29 |  |  |  | 20 | 30 |  |  |  | 15 | 29 |  |  |  | 26 | 24 |  |  |  | 29 | 44 |  |  |  | 27 | 26 |  |  |  | 20 | 38 |  |  |  | 35 | 21 |  |  |  | 17 | 33
25 | [NAME] |  |  |  |  |  |  | 30 | 24 |  |  |  | 20 | 30 |  |  |  | 20 | 32 |  |  |  | 20 | 31 |  |  |  | 14 | 36 |  |  |  | 24 | 29 |  |  |  | 18 | 38 |  |  |  | 11 | 18 |  |  |  | 17 | 33 |  |  |  | 35 | 38 |  |  |  | 28 | 36
26 | Oladele [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 36 |  |  |  |  |  |  |  |  | 29 | 29
27 | [NAME] |  |  |  |  |  |  | 17 | 18 |  |  |  | 31 | 19 |  |  |  | 19 | 31 |  |  |  | 23 | 37 |  |  |  | 15 | 35 |  |  |  | 24 | 26 |  |  |  | 18 | 37 |  |  |  |  |  |  |  |  | 29 | 29 |  |  |  | 34 | 35 |  |  |  | 19 | 31
28 | Olarewaju Quadri |  |  |  |  |  |  | 19 | 12 |  |  |  | 20 | 15 |  |  |  | 19 | 31 |  |  |  | 29 | 23 |  |  |  | 18 | 24 |  |  |  | 30 | 47 |  |  |  | 13 | 37 |  |  |  | 12 | 11 |  |  |  | 19 | 31 |  |  |  | 32 | 36 |  |  |  | 22 | 28
29 | Olorode Muslimot |  |  |  |  |  |  | 25 | 25 |  |  |  | 32 | 28 |  |  |  | 20 | 31 |  |  |  | 27 | 23 |  |  |  | 20 | 36 |  |  |  | 28 | 40 |  |  |  | 24 | 38 |  |  |  | 29 | 22 |  |  |  | 22 | 28 |  |  |  | 32 | 24 |  |  |  | 23 | 29
30 | Oloyede Zainab |  |  |  |  |  |  | 31 | 20 |  |  |  | 31 | 25 |  |  |  | 23 | 30 |  |  |  | 28 | 36 |  |  |  | 15 | 35 |  |  |  | 30 | 39 |  |  |  | 29 | 41 |  |  |  | 27 | 25 |  |  |  | 23 | 29 |  |  |  | 34 | 20
31 | Onyekachi Prisca Nkechi
32 | [NAME] |  |  |  |  |  |  | 28 | 24 |  |  |  | 34 | 28 |  |  |  | 22 | 30 |  |  |  | 23 | 37 |  |  |  | 10 | 33 |  |  |  | 24 | 28 |  |  |  | 31 | 42 |  |  |  | 28 | 23 |  |  |  |  |  |  |  |  | 32 | 28
33 | [NAME] |  |  |  |  |  |  | 30 | 21 |  |  |  | 32 | 28 |  |  |  | 23 | 30 |  |  |  | 21 | 34 |  |  |  | 14 | 36 |  |  |  | 28 | 23 |  |  |  | 17 | 42 |  |  |  | 11 | 17 |  |  |  |  |  |  |  |  | 35 | 35
34 | [NAME] |  |  |  |  |  |  | 28 | 13 |  |  |  | 32 | 26 |  |  |  | 18 | 22 |  |  |  | 19 | 37 |  |  |  | 16 | 34 |  |  |  | 22 | 36 |  |  |  | 24 | 43 |  |  |  | 12 | 21 |  |  |  |  |  |  |  |  | 35 | 34
35 | Ucha [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 32
36 | [NAME] |  |  |  |  |  |  | 29 | 31 |  |  |  | 30 | 22 |  |  |  | 20 | 30 |  |  |  | 26 | 33 |  |  |  | 15 | 24 |  |  |  |  |  |  |  |  | 30 | 45 |  |  |  | 11 | 22 |  |  |  | 25 | 32 |  |  |  | 35 | 33
37 | Umeoha Zeal |  |  |  |  |  |  | 26 | 26 |  |  |  | 33 | 18 |  |  |  | 20 | 32 |  |  |  | 24 | 36 |  |  |  | 20 | 30 |  |  |  | 24 | 49 |  |  |  | 28 | 42 |  |  |  | 11 | 19 |  |  |  |  |  |  |  |  | 32 | 36 |  |  |  | 24 | 30
38 | [NAME] |  |  |  |  |  |  | 24 | 30 |  |  |  | 25 | 32 |  |  |  | 20 | 20 |  |  |  | 25 | 25 |  |  |  | 15 | 25 |  |  |  |  |  |  |  |  | 26 | 38 |  |  |  |  |  |  |  |  | 24 | 30 |  |  |  | 31 | 30
39 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | 41