I have an instructor that wants to do the following with his grades:
Separate columns to record 4 Unit exams, a column for their in-class presentation score, and a column for extra credit.
The formula should be calculated like this: Drop the lowest score of the first 3 exams (in other words, don’t drop the 4th-last exam) to get the exam average, then add the presentation score and extra credit points on top of the Exam Average to calculate the course grade. Hope that all makes sense.
I can figure out most of that, I think, but the bolded part has me a bit stymied. Has anyone done something similar?