I have 2 different users that show certificate grades of 77% and 92% even though their gradebook shows 100% for ALL quizzes.
Any ideas on where I should start when troubleshooting this issue?
Hi Micky,
First which version of Moodle and flavor of Certificate are you using.
I assume that grades says the same thing as a quiz report of grades.
I would be looking at the certificate settings to see if it was placing a course average instead of a quiz grade. I would also check the quiz to see if it allowed more than one attempt. While I don't know much about it, I would look to see if scales in grading had something to do with it (ie a pass 100% or fail 0%) that got passed along to gradebook. Those would be the startering points on the UI side reguardless of version of Moodle. The 77 and 92 came from somewhere.
Then I would check the logs for the students and the quiz activities. Look at the certificate date on their certificate. Could be they took a quiz, scored 77, got their certificate. And then someone said, "you can do better than that", and they did because multiple attempts, highest score was allowed on the quiz. However, they already received their certificate and certificate does not update.
Then you could go to the MySQL site and do some digging. This gets a little bit more exciting. I will let someone else tell you how to delete a certificate, so it can be reissued with the current information.
Chris
Hi Micky,
The certificate plugin simply uses the Moodle API to obtain grades.
The code is simply this (assuming you are simply after the course grade) -
$course_item = grade_item::fetch_course_item($course->id);
$grade = new grade_grade(array('itemid'=>$course_item->id, 'userid'=>$USER->id));
There is no custom code that has been written to obtain the grade value, so the grade displayed on the certificate should be identical to what is displayed in the grade book. Are you sure that the quizzes are the only graded items for the course?
Regards,
Mark
Thank you both for your responses. My technician noticed that the certificate was pulling the grade from a certificate table. We believe that the first time the certificate is awarded, it populates the certificate table by reading from the from the gradebook.
After that, i just looks at the certificate table. So if a user's grades change after the certificate is issued, it doesn't update the certificate.
We are going to try to change the certificate code so it always looks at the gradebook, so that it doesn't ever look at the certificate table.
Let us know if we are moving down the wrong path!
Hi Micky,
This is something I will need to consider. Whether the grade should be static, or dynamic. Maybe there should be an option in the certificate settings as to whether the grade should be generated each time or not.
Regards,
Mark
Hi Micky,
Please view http://tracker.moodle.org/browse/CONTRIB-3287 for any ongoing updates on this issue.
Regards,
Mark
I can see how our requirements are unique.
We learned one more thing - we had some certificates whose settings had to be changed (such as adding or removing quiz activities). If we change the certificate settings, we have to delete the existing certificate PDFs in the Moodledata directory.
Only when we delete the PDFs, does the certificate know to look at the gradebook and reissue the certificate under the modified settings.
This is what was causing the error that started this thread.
Again, I can understand that the certificate module was not created for organizations who change the requirements to get the certificate. This would be similar to changing an assessment after half the employees have taken it. With other LMSs, it's encouraged to just archive the existing assessment and reissue the new assessment to the remaining employees....
Mickey,
Outstanding. So when the PDF is deleted, the Certificate module sort of forgets SOME of it's data that is with the issued certificate when it creates a new certificate.
That is something people using 1.9 can handled via "files" in the course. In 2.x I don't think we have a way of deleting the certificate and trying to find the PDF in MoodleData is not for the faint of heart
I just played with things a bit in 1.9.9. Not everything refreshes. The User Name and code stay the same. I edited the user name, it did not pick it the change. The format of the certificate changes. The Credit Hours change. Notice these things are not on the issued certificate report. For some reason I can not get either the course or quiz grade to work (old issue/bug) so I could not check that.
Chris
For Moodle fans, I edited my post after it was sent out.