I would like to ask if the case I'm experiencing is a bug. I accessed a course's contents that contains listing of SCORM, quiz, feedback activities that are sequential and requires completion of the previous activity.
I tried taking a quiz as a student and got a perfect score as a result. However, when I checked the listing of activities (that has checkboxes), it says that my quiz 'Did not achieve pass grade' and has an X mark on the checkbox. I tried checking/verifying the feedback messages and it is consistent that my score was really perfect.
Is there a way to verify (in the database), where I can find the value of this checkmark? How? I'm assuming that this would be of boolean value but I'm not sure which table on the database. The closest that I got in troubleshooting was the line course/view.php line containing the code "$displaysection = $section". I'm having a hard time figuring out the API.
Thanks in advance!
Thanks for replying. I already checked the passing grade details but everything's just normal.
I tried checking the mdl_course_modules_completion table and looked on the completionstate and viewed columns of that particular activity. The completionstate value is 3 and the viewed value is 0.
I'm not sure what the value of 3 means regarding quiz completion states but is it normal that the viewed value is 0?
I would like to know how the X mark for an activity is being displayed via the database so I can work backwards.
I'll try to check it again. However, I tried manually changing the value of completionstate from 3 to 1 (to see what's the effect on the checkbox). The X mark became a checkmark. But when I tried reverting it from 1 to 3, it stayed as a checkmark. Probably there are interconnected database tables to it.