When a student misses a midterm test or an assignment due to illness, I would like to shift the weight to the final exam. For example, say the midterm test weight is 10% of the course and the final exam weight is 40%. Were a student to miss the midterm due to illness, then their new final exam weight should be 50% of the course. Same for assignments.
I do not want to make everything else in the course worth proportionally more, which I believe is the behavior when setting an assignment mark to "Excused". I only want to increase the weight of the final exam, and only for that particular student, and only for that particular piece of work. How can I effect that?