I need help with my formula for my gradebook category.
Here is my problem. I have a faculty member who has 6 quizzes. 5 quizzes are worth 110 pts and 1 quiz (Q4) worth 100 pts. He is dropping the lowest quiz grade. So using the Mean of Grades aggregation his category total for Quizzes is not correct. If the lowest quiz to be dropped was the the quiz worth 100 pts then the course total is correct. BUT if the lowest is any other quiz (110pts) then the course total is not correct. BTW changing the 100pt quiz to 110pts solves it but this quiz has already been distributed. The extra 10pts was extra credit.
Ex. Q1 = 102, Q2 = 75, Q3 = 70, Q4 = 60, Q5 = 100, Q6 = 0. Moodle total is 82.6 but correct total should be 81.4.
So I have following formula =average(Q1, Q2, Q3, Q4, Q5, Q6) which averages the quizzes grades but I need the rest of the formula that drops the lowest number. Also, I understand we can drop the lowest grade in the category settings but when a formula is entered in the calculations it trumps that setting. Without the formula in the calculations it correctly drops the lowest.