Moodle SCORM/Quiz DB query

Re: Moodle SCORM/Quiz DB query

by Benjamin Ellis -
Number of replies: 6
Picture of Particularly helpful Moodlers

Moodle SCORM completion status/scores are stored in the scorm_scoes_track table - there are several records for each SCORM sco/scoe.  The SCORM package needs to report the completion and scores for the data to appear in Moodle.  I have always assumed that if the SCORM reported a score - it was automatically stored in the gradebook but you may need to check your grading settings for the SCORMs you want to track.

Hope that helps.

Average of ratings: Useful (1)
In reply to Benjamin Ellis

Re: Moodle SCORM/Quiz DB query

by T K -
Which column is supposed to be the grade?

scoes
In reply to T K

Re: Moodle SCORM/Quiz DB query

by Benjamin Ellis -
Picture of Particularly helpful Moodlers

It is not the table column that has the data, it is the record's element and the value fields that are relevant.

The element cmi.core.score.raw's value is the score/grade and the element cmi.core.lesson_status' value is the status (passed/completed/failed etc etc) see https://scorm.com/scorm-explained/technical-scorm/run-time/run-time-reference/#section-2 for SCORM 1.2 elements details.

However, your table does not appear to be standard - my 3.5 table does not have the fields after the timemodified field.





Average of ratings: Useful (1)
In reply to Benjamin Ellis

Re: Moodle SCORM/Quiz DB query

by T K -
Hi Benjamin,
Thanks for your reply. Yes there seems to be some custom fields added by previous administrators but not in use now.

I dont see the cmi.core.score.raw rows, I only see cmi.core.lesson_status as either complete or incomplete
In reply to Benjamin Ellis

Re: Moodle SCORM/Quiz DB query

by T K -
Ok some update here, i see it now, thanks so much Benjamin!
In reply to Benjamin Ellis

Re: Moodle SCORM/Quiz DB query

by T K -
one more thing Benjamin, for a given quiz or any grades, is it possible to view the pass/fail status on the DB?
In reply to T K

Re: Moodle SCORM/Quiz DB query

by Benjamin Ellis -
Picture of Particularly helpful Moodlers
Yes, the element cmi.core.lesson_status' value is the status (passed/completed/failed etc etc).  This value is set by the SCORM object.