Which column is supposed to be the grade?
Re: Moodle SCORM/Quiz DB query
Number of replies: 5Re: Moodle SCORM/Quiz DB query
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.
Re: Moodle SCORM/Quiz DB query
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
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
Re: Moodle SCORM/Quiz DB query
Ok some update here, i see it now, thanks so much Benjamin!
Re: Moodle SCORM/Quiz DB query
one more thing Benjamin, for a given quiz or any grades, is it possible to view the pass/fail status on the DB?
Re: Moodle SCORM/Quiz DB query
Yes, the element cmi.core.lesson_status' value is the status (passed/completed/failed etc etc). This value is set by the SCORM object.