@bsm45 ,
The Excused will make it be like it was never there. So will leaving it blank. If a student doesn't have a grade for the final exam, it will not be used in the calculations and the final will not be dropped since there is no grade to drop. However, there will still be some grade dropped because you have the rule in there. That does not sound like what you want.
In complicated situations, it's sometimes best to repeat back what you think you're hearing to make sure you understood it correctly. Let me run this past you and see if it's what you want.
Let's say there are three midterm quizzes eligible from dropping and a student has 50, 75, and 25 on them (they're all out of 100 points).
- If a student gets an 80 on the final, then the 25 should be replaced with the 80. The three grades would be 50, 75, and 80.
- If a student doesn't take the final, then you want to keep all three grades of 50, 75, and 25.
- If a student takes the final and gets a 10, then you want the grades to be 50, 75, and 10.
If those are all correct and the final grade is never a grade by itself, just a replacement for a dropped quiz, then I would do this.
- Have all four exams in the same assignment group.
- Create a rule to drop the lowest grade, but never drop the final.
- If the student takes the final, enter that grade they got on the final.
- If the student does not take the final, then enter the value of their lowest midterm for the final.
The last item works like this: Canvas is going to drop the lowest grade. What you're doing by entering the lowest grade for the final is putting it back in so that it gets counted. Canvas drops the midterm grade but reinserts it with the final and so things are the way they were before.
Now, if your final also counts as an additional grade or the point values are different, then it becomes trickier.
This discussion post is outdated and has been archived. Please use the Community question forums and official documentation for the most current and accurate information.