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

 


 

LECTURE COURSES

  • Before the Final Exam 4: After Exam 3, and after all extra credit 
    has been submitted, what do you need to score on the final exam?         
  • From All Scores: If you have all of your scores, 
    including your final exam score and all of your submitted extra credit

 

From All Scores
If you have all of your scores, 
including your final exam score and all of your submitted extra credit

  • Input your scores into the yellow boxes

  • Use the scroll bars to scroll down or sideways if necessary

  • If you missed one of the first 3 exams, input a 0 for the missed exam - the spreadsheet will count your final exam for the missed exam in the calculations.

  • Open Spreadsheet

 

Before the Final Exam 4
After Exam 3, and after all extra credit 
has been submitted, what do you need to score on the final exam?  

If You Missed An Exam

  • Input your scores into the yellow boxes

  • input a zero for the missed exam

  • if you missed more than one exam, 
    the calculator will not replace any missed exams with your final exam score

  • Use the scroll bars to scroll down or sideways if necessary

  • Open Spreadsheet

 


 

LAB COURSES

  • Before the Lab Final: After all the weekly labs are finished, and after all 
    extra credit has been submitted, what do you need to score on the final exam?         
  • From All Scores: If you have all of your scores, 
    including your final exam score and all of your submitted extra credit

 

Before the Lab Final
After all the weekly labs are finished, and after all extra credit 
has been submitted, what do you need to score on the final exam?  

  • Input your scores into the yellow boxes

  • Use the scroll bars to scroll down or sideways if necessary

  • Open Spreadsheet

 

From All Scores
If you have all of your scores, 
including your final exam score and all of your submitted extra credit

  • Input your scores into the yellow boxes

  • Use the scroll bars to scroll down or sideways if necessary

  • Open Spreadsheet

 

 


 

CALCULATING YOUR COURSE GRADE

 

 


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:

 

weight

 his score

 points earned
 calculations
 Exam 1  20% (200 pts)

 85%

170

 85 x 2 = 170
 Exam 2  25% (250 pts)

 85%

 212.5
 85 x 2.5 = 212.5
 Exam 3  25% (250 pts)

 75%

 187.5
 75 x 2.5 = 187.5
 Exam 4  30% (300 pts)

 88%

 264
 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

 her score

 points earned
 calculations
 Exam 1  20% (200 pts)

 93%

 170
 93 x 2 = 186
 Exam 2  25% (250 pts)

 83%

207.5

 83 x 2.5 = 207.5
 Exam 3  25% (250 pts)

 88%

237.5

 88 x 2.5 = 220
 Exam 4  30% (300 pts)

 ?

 ?
 
 Total  100% (1000 pts)  

900 for an A
 186+207.5+220=613.5

Before taking Exam 4, Ms. Marianas has 186+207.5+220=613.5 points
(900-613.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.

Amazing Grade Calculator

Return to the Top of This Page

Geology 10 Lab

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)

 92%
 Midterm

 91%
 Final

 85%

Mr. Karst's grade is calculated as follows:

 

weight

his score

 points earned
 calculations
 Lab Exercises, quizzes
and field trip(s)

 30% (300 pts)

 92%

 276
 92 x 3 = 276
 Midterm

 30% (300 pts)

 83%

 249
 83 x 3 = 249
 Final

 30% (300 pts)

 85%

 255
 85 x 3 = 255
 Field Trip

10% (100 pts)

100%

100

 100 x 1 =100
 Total

 100% (1000 pts)
 

 880
 276+249+255+100=880 points total

Mr. Karst earned a total of 880 of 1000 points which is a B

Amazing Grade Calculator

Return to the Top of This Page

Geology 12 Lab

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)

 95%
 Midterm

 92%
 Final

 85%

Mr. Karst's grade is calculated as follows:

 

weight

his score 

 points earned
 calculations
 Lab Exercises, quizzes
and field trip(s)

 50% (500 pts)

 95%

 475
 95 x 5 = 475
 Midterm

 35% (350 pts)

 92%

 322
 92 x 3.5 = 322
 Final

 15% (150 pts)

 85%

 127.5
 85 x 1.5 = 127.5
 Total

 100% (1000 pts)
 

 924.5
 475+322+127.5 = 924.5

Mr. Karst earned a total of 924.5 of 1000 points which is 92.4% = A.

Amazing Grade Calculator

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:

 

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)

 85%

 170
 85 x 2 = 170
 Quizzes, attendance,
assignments, etc
 40% (400 pts)

 95%

 380
 95 x 4 = 380
 Total  100% (1000 pts)  

886
 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

 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,
assignments, etc
 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.
(900-716)= 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.

Amazing Grade Calculator


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

80B<90%

70C<80%

60D<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

 his score

 points earned
 calculations
 Exam 1  20% (200 pts)

 93%

 170
 93 x 2 = 186
 Exam 2  25% (250 pts)

 83%

207.5

 83 x 2.5 = 207.5
 Exam 3  25% (250 pts)

 88%

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

80B<90%

70C<80%

60D<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,
assignments, etc

 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.
(900-716)= 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.

Amazing Grade Calculator


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

example of grade calculator

STEP 2: Leave these numbers alone (they are the same for all of my Geology classes - see your course syllabus).

90%A

80B<90%

70C<80%

60D<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

 Exam 1

 91%

 Exam 2

 80%

 Exam 3

 95%

 Exam 4

 0

 Vocab Quiz 1

 90%

 Vocab Quiz 2

 85%

 Vocab Quiz 3

 88%

 Vocab Quiz 4

 92%

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

80B<90%

70C<80%

60D<70%

F<60%