Gradebook auto-setting with weighting. Is this scenario possible?

Question

In my course, students earn their grade by submitting their homework (75 points), I give 4 tests, each one worth 100 points (400 points total), and a final exam (125 points).

When I calculate their final grade, the final exam grade replaces the lowest test score, if it improves their grade. Is there a way to tell D2L to do that? Also, this grade substitution should be "weighted". Example:

Let's say that the lowest test score is 60/100=60% and the final exam score is 100/125. Since 100/125=80%, the lowest test score should be replaced with an 80%, instead of "100".

Dawn.B.857 · Answer

Dawn.B.857 · Answer

Thank you, Andrea.  I will pass this along to the instructor that I am trying to help.  I appreciate you getting back to me.  Have a nice evening.

Andrea.M.553 · Answer

Hi Dawn,

Yes, this can be accomplished by making the final grade calculate with a formula versus points or weighted.

I do not know if this is the most efficient formula, but it does appear to work.

Result:

Best,

Andrea