I work for a school district and we are having a slight problem coming up with a calculation to average our GPA's. The problem is we have some classes that are weighted at .5 and others that are weighted at 1. So how do I come with a calculation that will give one student the average of all those classes together taking their weights into consideration? For example:

Class1 4.0 (1.0 weight)

Class2 3.0 (1.0 weight)

Class3 3.67 (1.0 weight)

Class4 3.67 (1.0 weight)

Class5 3.0 (1.0 weight)

Class6 3.67 (1.0 weight)

Class7 3.67 (.5 weight)

Class8 4.0 (.5 weight)

Class9 3.67 (.5 weight)

Class10 4.0 (.5 weight)

Together, with the weights included the final gpa should be 3.585

You need another field which some institutions call "quality points." This is essentially the GPE * Weight to arrive at the Qpt value. You then sum the total QPts and divide by the sum of the weights to arrive at your weighted average.

If you're using a summary field for this, you have the option to weight an average by a weight field.