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

Dawn.B.857 Posts: 5 🔍
edited October 2023 in Higher Ed / Postsecondary

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".