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 - see what your grade is Lab Courses - see what your grade is How To Do It Yourself: how to run the calculations yourself What if You Do Not Take the Final Exam? Amazing Grade Calculator:   this is an outside website - it's not on my website;  does not account for extra credit or missed exams; does not require Microsoft Excel How To Use the Calculator

 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?   Input your scores into the yellow boxes Use the scroll bars to scroll down or sideways if necessary Open Spreadsheet If you missed one of the first 3 exams..click here

 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

 How to Do-It -Yourself Lectures: Labs: What if you do not take the final?

For Geology 10 and Oceanography (Geo 12)
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. 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 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. Geology 15 - Environmental Geology

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.

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 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 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, 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.

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

 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 80≤B<90% 70≤C<80% 60≤D<70% F<60%