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?

Thanks,

Ron

There's a MUCH simpler way in Learn!

1. Create a Category, call it Exams 1-3. Make each of the first three exams a member of that category (easiest to do in Manage > Column Organization)

2. Create Presentation, Exam 4, and Extra Credit columns (Extra Credit has zero points possible)

3. Set up the Total column to include:

Done! It works a treat; I've done it scores of times.