I've run into a strange issue with activity completions in Moodle's database. Our quiz activities are set on a 1-30 scale, anything at 18 and above is a passing grade. We also set the activities to complete automatically with the requirements of viewing the activity, receiving a grade and receiving a passing grade. Grading method is set to highest grade out of two attempts.
We use the Configurable Reports plugin to see how our students are progressing on each course and so far everything's working smoothly. Our only problem is that when a student fails a quiz, both attempts, it's not marked as having failed the activity, Moodle simply interprets it as not having finished the activity. As we know, completionstate, the attribute in the Course Modules Completion table that keeps the activity completion records in four ways: 0 = Not viewed, 1 = viewed, 2 = viewed and pass and 3 = viewed and failed, the last two used in activities with grades. In our case, students who fail a quiz should have a completionstate of 3, yet when I go to see their records on out database, it shows as 0. Not only that, but timemodified also shows 0. It's bizarrre.
I've double-checked their data on out platform, everything looks fine. These are also students that have finished the quiz as opposed to letting time run out and having Moodle automatically record whatever progress they've made. Some of our students access the platform on their phones, could it be that?
Any ideas what's going on? Any input is appreciated. Moodle version 3.5.7.