ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Student NameTestsHomeworkParticipation
Weighted Average
Letter Grade
2
Category Weight40%30%30%
3
Alvarez, Mia85.0%92.0%100.0%91.6%A
4
Brooks, Daniel78.0%88.0%95.0%86.1%B
5
Chen, Sofia94.0%97.0%100.0%96.7%A
6
Doyle, Aiden61.0%74.0%85.0%72.1%C
7
Emeka, Grace88.0%80.0%90.0%86.2%B
8
9
10
How to use this template
11
1. Replace the category names in row 1 and the weights in row 2. The weights should add up to 100%.
12
2. Replace the sample student names in column A, then enter each student's percentage in each category.
13
3. Weighted Average and Letter Grade calculate themselves. Do not type in those two columns.
14
4. The second tab shows how to drop a student's lowest homework score.
15
Letter cutoffs are A 90%, B 80%, C 70%, D 60%. Edit the Letter Grade formula to match your school's scale.
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