To Update Grade Formula

Question

Hello, I have three quizzes, and the current grade formula calculates the final grade as the average of Q1, Q2, and Q3. However, if a student has only attempted one quiz, the formula calculates the final grade by assuming the scores of Q2 and Q3 to 0, which is not desired. How can I update the formula so that the final grade is only calculated once all the grades for Q1, Q2, and Q3 are updated?

Avinashdeep.K.637 · Answer

Thanks Jennifer, it works if I put 0, but not for 0.0001

Jennifer.W.973 · Answer

@Avinashdeep.K.637 This worked for me: =IF{ (MIN{ [Ethics CS 1.Percent], [Ethics CS 2.Percent], [Ethics CS 3.Percent] } = 0), 0, AVG{ [Ethics CS 1.Percent], [Ethics CS 2.Percent], [Ethics CS 3.Percent] } } with the max points on the final grade item set to 100. However, any student who did get an actual 0 (rather than the system's treat ungraded as 0) would not have an updated final grade. It would remain at 0 for them too. You can type in 0.00001 instead of 0 just to get the calculation to work for those students.

Avinashdeep.K.637 · Answer

Thanks Andrea,

I understand your point, but I don't want the final score to be calculated until all three quizzes have been graded. In the screenshot taken from another course, you can see that the final score is zero for the student if all quizzes haven't been attempted or graded. However, this isn't the case for the course I'm currently setting up.