Grade Tracker and What-do-I-need-to-get Calculator
Comments
 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. Step 2: Enter your current overall average in the orange cell below. Your overall average can be found in the Cancas gradebook, or you can calculate your overall average by entering your exam and lab practicum percent scores in the purple cells to the left; your overall 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, then only the orange cell will be used in the calculation; the green cell will be ignored.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 entered automatically in the red cell along with your overall average in the green cell. If there are numbers in both the yellow and red cells, then only the yellow cell will be used in the calculation; the red cell will be ignored.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.
5
You can download this file ("File => Download as") if you want to open the spreadsheet in a program like Excel and save it on your computer. if you have a Google account you can save this spreadsheet online for your own private use ("File => Make a copy...").
6
Midterm Exam 1
7
Midterm Exam 2Enter overall average in orange cell or enter scores in purple cells to calculate.Enter % completed in yellow cell or enter scores in purple cells (left) to calculate.
8
Midterm Exam 3Values of exams and practicums.Relative value of practicum points to exam pointsTotal % value of lecture & lab exams
9
Practicum 1Number of practicums:5Each practicum is worth8
percent of the course grade.
Lab Practicums-40
10
Practicum 2
Number of Midterm Exams:
3
Each midterm exam is worth
14
percent of the course grade.
Midterm Exams1.842
11
Practicum 3 The final exam is worth18
percent of the course grade.
Final2.318
12
Practicum 4A = 90 - 100%; B = 80 - 89; C = 70 - 79; D = 55 - 69; F = < 55100
13
Practicum 5†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.
20
Final Exam
Loading...
 
 
 
Sheet1