Grade Tracker and What-do-I-need-to-get Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
DEIJKLMNOPQ
3
4
Don't include percent signs when entering scores. For example, enter 80% as 80. Step 1: In the blue cell below enter the overall percent score you want at the end of the term. (90 for an A, 80 for a B, etc.)Step 2: Enter your current overall average in the orange cell below. (You can also calculate your current overall average by entering your exam and lab practicum percent scores in the purple cells to the left; your average will then be automatically entered in the green cell and the percent of the course completed will be entered in the red cell. If there are numbers in both the orange and green cells, only the number in the orange cell will be used in the calculation.) Step 3: Enter the percent of the course completed in the yellow cell below. (If you enter your exam and lab practicum percent scores in the purple cells to the left, the percent of the course completed will be calculated.) Step 4: After compleing steps 1-3, the white cell below shows the minimum overall weighted average score† needed on the remaining exams and practicums to get the overall percent score you entered in the blue cell. When you are finished please delete all numbers entered.
5
You can download this spreadsheet ("File => Download as") and open it in a program like Excel. If you have a Google account, you can save this spreadsheet online to your Google Drive for your personal use ("File => Make a copy..."). [Choose "File" from the document menu and not the browser menu.]
6
Midterm Exam 161.6890100To calculate, remove at least one score from column E or put a number less than 100 in the yellow cell.
7
Midterm Exam 291.9485.6100
8
Midterm Exam 381Values of exams and practicums.Relative value of exam points to practicum pointsTotal % value of lecture & lab exams
9
Practicum 198# of practicums:5Each practicum is worth8
percent of the course grade.
Lab practicums-40
10
Practicum 286.11# of midterm exams:3
Each midterm exam is worth
14
percent of the course grade.
Midterm exams1.842
11
Practicum 3101.15 The final exam is worth18
percent of the course grade.
Final exam2.318
12
Practicum 4101.76A = 90 - 100%; B = 80 - 89; C = 70 - 79; D = 55 - 69; F = < 55100
13
Practicum 597†A weighted average calculation takes into consideration that midterm exams and lab practicums have different relative values. To calculate a weighted average, the values for the exams are considered relative to the value of a single lab practicum. For example, since each midterm exam is worth 1.8 lab pracicums, a weighted average of the scores on one midterm exam and one lab practicum would treat the midterm exam as if it were equivalent to 1.8 practicums. The relative values for the midterm & final exams and lab practicums can be seen in column P in the table above.
14
Final Exam78
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
101
102
103
104
105
Loading...
 
 
 
Sheet1
Sheet7
Sheet6
 
 
Main menu