OnLine Grade Calculators
by RL Hanna
The following calculation
spreadsheets require Microsoft Excel
to be available on the PC computer
that you are using
 Excel is available on school PC computers 
Macs may not be able to run these spreadsheets




For Geology 10 and
Oceanography (Geo 12)
How to calculate your grade:
Example 1:For course grades weighted as follows
(see your course syllabus for this info):
Exam 1  20 % 
Exam 2  25 % 
Exam 3  25 % 
Exam 4  30 % 
For student Calcite Karst, his grades are as follows:
Exam 1  85% 
Exam 2  85% 
Exam 3  75% 
Exam 4  88% 
Mr. Karst's grade is calculated as follows:
calculations  
Exam 1  20% (200 pts)  170 
85 x 2 = 170  
Exam 2  25% (250 pts)  85 x 2.5 = 212.5  
Exam 3  25% (250 pts)  75 x 2.5 = 187.5  
Exam 4  30% (300 pts)  88 x 3 = 264  
Total  100% (1000 pts)  834 
170+212.5+187.5+264=834 
Mr. Karst earned a total of 834 of 1000 points which is 83.4% = B.
Example 2: What score would Ms. Marianas have need on the Final (Exam 4) to get an A in the course?
To earn an A, Ms. Marianas must accumulate a minimum of 900 points (90% of 1000).
weight  calculations  
Exam 1  20% (200 pts)  93 x 2 = 186  
Exam 2  25% (250 pts)  207.5 
83 x 2.5 = 207.5  
Exam 3  25% (250 pts)  237.5 
88 x 2.5 = 220  
Exam 4  30% (300 pts)  
Total  100% (1000 pts)  186+207.5+220=613.5 
Before taking Exam 4, Ms. Marianas has 186+207.5+220=613.5 points
(900613.5)= 286.5 points needed to get to 900 for the term.
286.5/300 = 95.5% for Exam 4.
To earn an A in the course, Ms. Marianas must score above a
95.5% on Exam
4.
Return to the Top of This Page
Example:For a course with the grades weighted as follows:
(See course syllabus)
Lab Exercises, quizzes and field trip(s) 
30% 
Midterm  30% 
Final  30% 
Field Trip  10% 
For student Calcite Karst, whose grades are as follows:
Lab Exercises, quizzes and field trip(s) 

Midterm  
Final 
Mr. Karst's grade is calculated as follows:
calculations  
Lab Exercises, quizzes and field trip(s) 
92 x 3 = 276  
Midterm  83 x 3 = 249  
Final  85 x 3 = 255  
Field Trip 
10% (100 pts) 
100% 
100 
100 x 1 =100 
Total  276+249+255+100=880 points total 
Mr. Karst earned a total of 880 of 1000 points which is a B
Return to the Top of This Page
Example:For a course with the grades weighted as follows:
(see course syallabus)
Lab Exercises, quizzes and field trip(s) 
50% 
Midterm  35% 
Final  15% 
For student Calcite Karst, whose grades are as follows:
Lab Exercises, quizzes and field trip(s) 

Midterm  
Final 
Mr. Karst's grade is calculated as follows:
calculations  
Lab Exercises, quizzes and field trip(s) 
95 x 5 = 475  
Midterm  92 x 3.5 = 322  
Final  85 x 1.5 = 127.5  
Total  475+322+127.5 = 924.5 
Mr. Karst earned a total of 924.5 of 1000 points which is 92.4% = A.
Return to the Top of This Page
Geology 15  Environmental Geology
How to calculate your grade:
Example 1:For
course grades weighted as follows
(see your course syllabus for this info):
Exam 1  20 % 
Exam 2  20 % 
Exam 3  20 % 
Quizzes, attendance, assignments, etc 
40% 
For student Calcite Karst, his grades are as follows:
Exam 1  88% 
Exam 2  80% 
Exam 3  85% 
Quizzes, attendance, assignments, etc 
95% 
Mr. Karst's grade is calculated as follows:
caclualtions  
Exam 1  20% (200 pts)  88 x 2 = 176  
Exam 2  20% (200 pts)  80 x 2 = 160  
Exam 3  20% (200 pts)  85 x 2 = 170  
Quizzes, attendance, assignments, etc 
40% (400 pts)  95 x 4 = 380  
Total  100% (1000 pts)  176+160+170+380 = 886 
Mr. Karst earned a total of 886 of 1000 points which is 88.6% = B.
Example 2:What score would Mr. Tacoma have needed on the Final (Exam 3) to get an A in the course?
To earn an A, Mr. Tacoma must accumulate a minimum of 900 points (90% of 1000).
weight  caclualtions  
Exam 1  20% (200 pts)  88 x 2 = 176  
Exam 2  20% (200 pts)  80 x 2 = 160  
Exam 3  20% (200 pts)  
Quizzes, attendance, assignments, etc 
40% (400 pts)  95 x 4 = 380  
Total  100% (1000 pts)  176+160+380= 716 
Before taking Exam 4, Mr. Tacoma has 176+160+380 = 716 points.
(900716)= 184 points needed to get to 900 for the term.
184/200 = 92% for Exam 3.
To earn an A in the course, Mr. Tacoma must score above a 92% on Exam
3.
How to Use the Amazing Grade Calculator
Example: What score would Mr. Tacoma need on the Final (Exam 4) to get an A in the course?
A. Open the Amazing Grade Calculator website (you will now have 2 windows open)
B. If Mr. Tacoma is in the lecture course of Geology or Oceanography
(see course syllabus for weights)
His Scores
Weight
Exam 1 93%
20% (200 pts) Exam 2 83% 25% (250 pts) Exam 3 88% 25% (250 pts) Exam 4 ? 30% (300 pts) Total 100% (1000 pts)
STEP 1: On The Amazing Grade Calculator website:
Input the scores as shown below
STEP 2: Leave these numbers alone (they are the same for all of my Geology classes  see your course syllabus).
90%≤A 
80≤B<90% 
70≤C<80% 
60≤D<70% 
F<60% 
STEP 3: Press the "Calculate" button on the Amazing Calculator website and Mr. Tacoma will get these results:
What if you do
not take the Final Exam?
For all classes,
If you do not take the Final Exam, your
score is the sum of all exams and other work submitted out of the total 1000
term points possible.
Example: For student Mr.
Tacoma, in Geology lecture, what if Mr. Tacoma does not take the Final Exam 4?
EXAMPLE 
weight 
calculations  
Exam 1  20% (200 pts)  93 x 2 = 186  
Exam 2  25% (250 pts)  207.5 
83 x 2.5 = 207.5  
Exam 3  25% (250 pts)  237.5 
88 x 2.5 = 220  
Exam 4  30% (300 pts)  
Total 
100% (1000 pts)  Total: 186+207.5+220=613.5 
If Mr. Tacoma does not take the Final Exam 4, his total course grade is 613.5 points out of 1000 which is a course grade of D.
90%≤A 
80≤B<90% 
70≤C<80% 
60≤D<70% 
F<60% 
886
176+160+170+380 = 886
Mr. Barchan earned a total of 886 of 1000 points which is 88.6% = B.
Example 2:What score would Mr. Tacoma have needed on the Final (Exam 3) to get an A in the course?
To earn an A, Mr. Tacoma must accumulate a minimum of 900 points (90% of 1000).

weight 
his score 
points earned 
caclualtions 
Exam 1 
20% (200 pts) 
88% 
176 
88 x 2 = 176 
Exam 2 
20% (200 pts) 
80% 
160 
80 x 2 = 160 
Exam 3 
20% (200 pts) 
? 
? 

Quizzes, attendance, 
40% (400 pts) 
95% 
380 
95 x 4 = 380 
Total 
100% (1000 pts) 

900 for an A 
176+160+380= 716 
Before taking Exam 4, Mr. Tacoma has 176+160+380 = 716 points.
(900716)= 184 points needed to get to 900 for the term.
184/200 = 92% for Exam 3.
To earn an A in the course, Mr. Tacoma must score above a 92% on Exam
3.
How to Use the Amazing Grade Calculator
Example: What score would Mr. Tacoma need on the Final (Exam 4) to get an A in the course?
A. Open the Amazing Grade Calculator website (you will now have 2 windows open)
B. If Mr. Tacoma is in the lecture course of Geology or Oceanography
(see course syllabus for weights)
His Scores
Weight
Vocab 1
92%
5% (50pts)
Vocab 2
100%
5% (50pts)
Vocab 3
88%
5% (50pts)
Vocab 4
91%
5% (50pts)
Exam 1
93%
15% (150 pts)
Exam 2
83%
20% (200 pts)
Exam 3
88%
20% (200 pts)
Exam 4
?
25% (250 pts)
Total
100% (1000 pts)
STEP 1: On The Amazing Grade Calculator website:
Input the scores as shown below
STEP 2: Leave these numbers alone (they are the same for all of my Geology classes  see your course syllabus).
90%≤A 
80≤B<90% 
70≤C<80% 
60≤D<70% 
F<60% 
STEP 3: Press the "Calculate" button on the Amazing Calculator website and Mr. Tacoma will get these results:
What if you do
not take the Final Exam?
For all classes,
If you do not take the Final Exam, your
score is the sum of all exams and other work submitted out of the total 1000
term points possible.
Example:
For Ms. Marianas with the following scores


Ms. Marianas' grade is calculated as follows:
Vocab Quiz 1 
90% 
90% x 50 points possible = 45.0 points earned 
Vocab Quiz 2 
85% 
85% x 50 points possible = 42.5 points earned 
Vocab Quiz 3 
88% 
88% x 50 points possible = 44.0 points earned 
Vocab Quiz 4 
92% 
92% x 50 points possible = 46.0 points earned 
TOTAL 
45+42.5+44+46 = 177.5 points earned 
NEXT:

weight 
her score 
points earned 
calculations 
Exam 1 
15% (150 pts) 
91% 
136.5 
91 x 1.5 = 136.5 
Exam 2 
20% (200 pts) 
80% 
160.0 
80 x 2 = 160.0 
Exam 3 
20% (200 pts) 
95% 
190.0 
95 x 2 = 190.0 
Exam 4 
25% (250 pts) 
0 
0 

Vocab Quizzes 
20% (200 pts) 

177.5 

Total 
100% (1000 pts) 

664 
136.5+160+190+177.5=664 
Ms. Marianas earned a total of 664 of 1000 points
before taking the Final Exam.
If Ms. Marianas does not take the final exam,
then her score is 664/1000= 66.4% = D
90%≤A 
80≤B<90% 
70≤C<80% 
60≤D<70% 
F<60% 