I received the following query via email, so am posting here in case others are coming across a similar issue.
Quiz results and responses are not recorded for any of the CHAs from whom data was collected. I can see based on their activity tracker and points that these users completed the course, but no results show in the quiz_quizattempt and quiz_quizattemptresponse tables. As well for these users, on the cmedata dashboard, it will show quizzes completed “1/1” on the recent activity page, but then when you click “CHA Basics” for details, it shows “0 attempted, 0 passed quizzes” and no scores or attempts.
When I look at data from other users, I can see quiz results and response data is being recorded on the tables and is reflected in the dashboard. Why would the CHAs quiz scores and responses not be captured in the database? I thought given that other user quiz data is shown that maybe quizzes taken off-line are not being stored on the device, and so maybe only users who were connected to a network at the time they took the quiz have their results stored in the db?
First reply from me…
I’m not exactly sure what is going on here, until we’ve done some more investigation. However one possibility comes to mind…
The course installed on the device is different to the one that has been published on the Oppia server. For example, if the course is exported from Moodle and the course zip file is downloaded to ‘side-load’/pre-install on the device, but then the course (esp the quiz) has been edited in any way and then this version has been uploaded to the Oppia server.
Then the course quiz on the device will be different to the one on the server. The server won’t have any reference to the particular quiz and so can’t load in the quiz responses when the activity tracker log is uploaded.
The reason it may then show quizzes completed as 1/1 in one place and 0/0 in others is that it’s reading some information from the tracker table - so the tracker knows that the quiz has been completed (so shows 1/1), but when drilling down into the course activity it’s reading from the quiz attempt table, but of course there’s nothing there to read from.
Another option of course is that there is a bug in the activity log file upload.
We’ll look more into this and post any results or ideas up here,