Inaccurate reporting in my moodle quizzes...and how i corrected it

I had this email from a teacher this.

Hey,

It looks like the grade calculator for Global 9 is off.

A student can miss a question or 2 and still score %100.

It seems like it is set for 10 points and yet each question is valued at more.

Please advise.

Thanks,

Tom

  

 Upon investigation, I did confirm the issue.  The quiz was not reporting the grade correctly.  A student was taking the quiz and getting a 100, even after missing questions.

The quiz was saying "the student got 8 points from a poss. 4 - that's a 200!", correct calculation, but wrong calculation.  One that the student probably was not going to report either.

The thing I noticed was the Marks row.  What the heck?  That was new.  And, why did it say 8/4?  After a little more thought, I realized the 8 was the points earned by the student on the quiz and the 4 was the total points avail. on the quiz, which was the problem.  The rest of the settings all said 10 points for the quiz.  But, that Mark number said 4.  Why?  The hell if I know, nor could I find anything in the moodle GUI/forms that showed the number 4.  How then could I correct the problem?

Thankfully, I decided to check the quiz records in the DB.  Maybe I would get lucky and find something there, correct it and problem solved.  Using MySQL workbench, I opened the DB and drilled down into the mdl_quiz table and found the quiz records for the course, using the course id to filter the records.  I noticed the value 4 in the sumgrades column for the quiz records.  I changed one of the records value from 4 to 10, saved the result then refreshed the moodle quiz review and the problem was corrected, thank God.  I then updated the value in the sumgrades column for the rest of the records for the quiz.

One final step after correcting the data in the table, I have to regrade each quiz where there was an attempt - then the User Report updated too.

I am not sure how this value was set to a lower number to begin with.  The course is a 3rd party vendor Florida Virtual, and perhaps the wrong value was created upon course setup, stranger things have happened.  The important thing is that i was able to solve this issue for the teacher without causing too much intrusion into their course.