Need! Link to calculate weighted grades

[sheryl]

I don't know how to do this.  Can someone here suggest a good and reputable link to learn "HOW" to calculate weighted grades?

TIA! 

[EKS]

Here is how to do it.  Say you want to have the grade 60% tests, 25% for homework, and 15% for the final, and the student has a 92% average on tests, a 100% average on the homework, and an 85% on the final.

 

Do this:

 

92 x 0.6 = 55.2

 

100 x 0.25 = 25

 

85 x 0.15 = 12.75

 

Then add them up: 55.2 + 25 + 12.75 = 92.95

 

ETA: I just realized that maybe you're talking about calculating a weighted GPA.  That isn't quite so straightforward since the amount of credit given for honors, AP, DE etc can vary depending on the school.

Edited November 29, 2017 by EKS

[MarkT]

weighted GPA;

AP = 5 for A 

Honors = 4.5 for A

Reg = 4.0 for A

and so forth

these are pretty standard at most B&M schools

DE would be AP or Honors pick one

 

[RegGuheert]

If you are talking about doing this in a spreadsheet, here are some equations you can use to calculate weighted GPA:

 

First, add column A called "Class Name" (which is not used, but important).

 

Second, add column B called "Class type" which contains "REG", "AP", "IB", or "HON".

 

Third, add column C called "Weight" to calculate the class weight:

=IF(EQ($B6,OR("AP","IB")),1.0,IF(EQ($B6,"HON"),0.5,0))

 

Fourth, add column D called "Grade" which contains "A", "B", "C", "D", "F", or "P".

 

Fifth, add a column E called "Points" to convert the "Grade" and "Weight" to a weighted number for that course:

=(IF(EQ($D6,"A"),4,IF(EQ($D6,"B"),3,IF(EQ($D6,"C"),2,IF(EQ($D6,"D"),1,0))))+$C6)*$E6

 

Sixth, add column F called "Hours" which contains the number of hours the course meets.

 

Seventh, add column G which calculates the number of "GPA hours" to consider for the calculation with each class (this allows handling of Pass/Fail classes):

=IF(OR(EQ($D6,"A"),EQ($D6,"B"),EQ($D6,"C"),EQ($D6,"D"),EQ($D6,"F")),$F6,0)

 

Finally, add column H which divides the total number of points by the total number of hours:

=IF(SUM($G$2:$G6)=0,0,SUM($E$2:$E6)/SUM($G$2:$G6))

 

All of the above equations would be for calculations in row 6 and would the result in H6 would be the GPA for all classes in rows 2 through 6 (five classes).  Column headings would be in row 1.  You can then simply copy these equations into more rows to add more classes.  (In other words, you can copy the above equations directly into the appropriate cells in row 6 of your spreadsheet and then copy that row into rows 2 through 5 (and 7 up, if desired) to complete the spreadsheet.)

[RegGuheert]

If you just want a link to a web page which makes the calculation for you, here's one: Weighted High School GPA Calculator.

[historymatters]

I found this page useful:

 

https://m.wikihow.com/Calculate-Your-Grade?amp=1

[Murrayshire]

Here is one from Janice Campbell’s website:

https://everyday-education.com/free-gpa-calculator/