Hello,

How can i work out a final mark from these grades taking into account credits.

Each year has 120 credits, but only the top 100 count.
So if there are 6 modules in a year and 5 are marked at 75% and the other at 72% you would drop the full module grade.
However, if this module was still worth 30 you would have to keep 10 credits worth of the marks.

An example of the data can be seen below.

Capture.PNG

What would be the best way to approach this, with a formulae?
In the end i would want a grade for all 3 years.


Thank you,