I am trying to calculate a Yearly GPA and have the formula but have hit a wall. I work at a therapeutic day school and we have special electives and classrooms that are weighted differently than other classrooms.
I need to be able to calculate several different ways and make sure that the correct number gets put it. I have found out it is not as simple as formula ( A + B + C + D ) / R
Here is an example formula for one of the GPA totals:
(Earned GPA + Earned GPA Copy + Earned GPA Copy2 + Earned GPA Copy3 + Earned GPA Copy4 + Earned GPA Copy5) / 6
Any help is appreciated!