Student Total %: Maths 4S1
Student Total %: Maths 4S1
Student Total %: Maths 4S1
Student Total %
1 Ben Sean 39 39 39%
2 Chadamoyo Antony 70 70 70%
3 Chapungu Lincoln 68 68 68%
4 Chawira Lenon T 63 63 63%
5 Chiduku Divine A 26 26 26%
6 Chikuvire Tafadzwa (Twin II) 26 26 26%
7 Chimunya Willie N 62 62 62%
8 Chimutashu Tanatswanashe C 49 49 49%
9 Chirisa Taropafadzwa D 68 68 68%
10 Chishamba Anopanyasha 29 29 29%
11 Chitakunye Roland A 54 54 54%
12 Chitsatse Hasten 37 37 37%
13 Chitsiga Golden 45 45 45%
14 Chivhunze Tafadzwa N 54 54 54%
15 Dandajena Prominence D 20 20 20%
16 Dhliwayo Nigel S 59 59 59%
17 Govere Kudzai 60 60 60%
18 Gwarimbo Kudakwashe E 31 31 31%
19 Hudu Michael 51 51 51%
20 Kabeki Lindsay Z 45 45 45%
21 Kagodo Munashe S 59 59 59%
22 Karadzangare Takunda N
23 Katsenga Ryan Kupakwashe 92 92 92%
24 Kuvengurwa Anotisaishe K 46 46 46%
25 Machuwe Takudzwa R 60 60 60%
26 Manyika Courage T 62 62 62%
27 Masiye Frank T 50 50 50%
28 Matibiri Tamuka A 50 50 50%
29 Mudisy Shemaah
30 Mudzonga Tapiwanashe E 65 65 65%
31 Mugona Chris−Jay 53 53 53%
32 Mukandi Herbert B 60 60 60%
33 Munyaka Carlton T 54 54 54%
34 Musadavira Raymond 49 49 49%
35 Mutsambi Anotidashe 45 45 45%
36 Nota Darryl T 44 44 44%
37 Paskwavaviri Shannon T 38 38 38%
38 Rutanhira Adolph F
Shone Munashe 17 17 17%
Sibanda Munashe T 22 22 22%
Takaendesa Ryan T 49 49 49%
Ziwakayi Tatenda P 43 43 43%
Master List of Names
The purpose of this worksheet is to allow you to assign an ID to each student so that
when the grades are displayed, only the ID is shown. This provides some degree of privacy
but is not a perfect method. The order that you place the names in the table below will be
the order they appear in the Gradebook. To randomize the names, you can assign random
IDs and then sort by ID. Do not change the order of the names after you have started
started entering grades into the Gradebook.
Name ID
1 Bob 102
2 Sally 104
3 Sue 106
4 Jill 108
5 Jon 110
6 Ted 112
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Grading Scale
This worksheet is for assigning letter grades based on a percentage scale. A typical percentage scale
is A>=90, 80<=B<90, 70<=C<80, 60<=D<70, F<60, with plus (+) and minus (-) used for the upper
or lower end of the range. For convenience, the table is set up to calculate the plus and minus grade
minimums, but you can manually enter these values instead. For the Gradebook to work correctly, the
Grading Scale below must remain ordered from lowest to highest.
Grading Scale
Minimums Grade Frequency 30 Histogram
0.0% F 28 77.8%
60.0% D- 5 13.9% 25
63.0% D 2 5.6%
66.0% D+ 2 5.6% 20
70.0% C- 1 2.8%
Frequency
15
73.0% C 0 0.0% [42]
76.0% C+ 0 0.0%
10
80.0% B- 0 0.0%
83.0% B 0 0.0% 5
86.0% B+ 0 0.0%
90.0% A- 1 2.8% 0
93.0% A 0 0.0% F D- D D+ C- C C+ B- B B+ A- A A+
96.0% A+ -3 -8.3% -5
Students: 36
Percentiles [42]
p Percentile
90.0% 65.60% "90% of the students scored less than …"
65.0% 54.00%
35.0% 45.00%
10.0% 26.00%
Gradebook Template
By Vertex42.com
https://www.vertex42.com/ExcelTemplates/gradebook.html
Please review the following license agreement to learn how you may or may
not use this template. Thank you.
https://www.vertex42.com/licensing/EULA_privateuse.html