SCORM

Reporting Time spent on SCORM (built using Articulate Storyline) with complete lists of users in excel

 
Picture of Matteo Scaramuccia
Re: Reporting Time spent on SCORM (built using Articulate Storyline) with complete lists of users in excel
Core developersParticularly helpful MoodlersPlugin developers

Hi Valerio,
there are two options here to extract your/a report, aside from doing it manually via cut&paste from the SCORM Basic Report:

  • Work with raw data (mdl_scorm_scoes_track, for the tracking, and mdl_scorm_scoes and mdl_scorm for respectively SCORM course SCOes and SCORM activity) via a plug-in to facilitate data extraction given a plain SQL query like https://moodle.org/plugins/report_customsql which is able to provide a view of the data gathered by the SQL query and give you the facility to download that data via CSV too, which is easily importable by Excel-like programs
  • Create your own report with new code (https://docs.moodle.org/dev/SCORM_reports), which requires the comprehension of the issues above, so my suggestion is to play with the first proposal

How to play with a raw SQL query?
You should be familiar with SQL first and the way Moodle stores the SCORM data then you can easily play with the tables above e.g. you can start playing with https://docs.moodle.org/35/en/ad-hoc_contributed_reports#Lists_All_completed_SCORM_activites_by_Course_name or https://docs.moodle.org/35/en/ad-hoc_contributed_reports#Lists_SCORM_status_for_all_enrolled_users_by_Course_name since they should do most of the work unless some missing fields and different logic, the first limited to those who have completed the SCO and the second giving you the full list of users including those having never attempted to a SCO.

You cannot find in Moodle a report like yours since it requires to define some strong constraints e.g. the whole of my SCORM packages are single-SCO based or I do not require an overall status of the SCORM course in case of multi-SCO based but SCO by SCO and so on which cannot be defined unless in a specific Moodle instance (!).
To tell the truth, Moodle could have more SCORM reports which the administrator could activate based on site wide constraints or automagically defined on a SCORM activity basis: it requires funding and no one 'till now looks like have ever funded those site-wide reports within the core code but the ones already there and the wonderful plug-in above, including those queries shared by the Community in the WIki above.

For the convenience of other English readers the columns in the wanted report are more or less the ones of the Basic Report, here extended for the enrolled users to any SCORM activity:

  • Full name (First name / Surname)
  • Email address
  • Attempt
  • Started on
  • Last accessed on
  • Score
  • SCO Title

HTH,
Matteo

 
Average of ratings: Useful (1)
Picture of Valerio Ferri
Re: Reporting Time spent on SCORM (built using Articulate Storyline) with complete lists of users in excel
 

Thanks Matteo for your detailed reply!

I'd like to know just one more thing.

According to you is it possible to get this result through a new plug-in (or editing a an existing one), or is it necessary to edit default database code?

Do you know a SQL expert who can face our need, even creating a plug-in for us?

Many thanks!


 
Average of ratings: -
Picture of Rachel Martin
Re: Reporting Time spent on SCORM (built using Articulate Storyline) with complete lists of users in excel
 

If you can sort it out to a SQL query, you can set it up as a report using the configurable reports block plugin.

https://moodle.org/plugins/block_configurable_reports

We use it for several custom reports and you can setup permissions so that it is only shown to certain access levels.

 
Average of ratings: -
Picture of Matteo Scaramuccia
Re: Reporting Time spent on SCORM (built using Articulate Storyline) with complete lists of users in excel
Core developersParticularly helpful MoodlersPlugin developers

Hi Rachel,
https://moodle.org/plugins/block_configurable_reports is almost the same as https://moodle.org/plugins/report_customsql with some differences: IMHO the most relevant - but techie wink - is that the latter is more "active" in terms of latest commits (Jul 3, 2017 vs May 9, 2018).

HTH,
Matteo

 
Average of ratings: -
Picture of Melanie Scott
Re: Reporting Time spent on SCORM (built using Articulate Storyline) with complete lists of users in excel
Particularly helpful Moodlers

Also, the Configurable reports plugin has not been updated since 3.1 and is currently unsupported...since the php version has changed in recent Moodle versions, this makes Configurable reports less reliable (I wish someone would support it!)--but Ad-Hoc reports can do the sql reports to...

 
Average of ratings: -
Picture of Matteo Scaramuccia
Re: Reporting Time spent on SCORM (built using Articulate Storyline) with complete lists of users in excel
Core developersParticularly helpful MoodlersPlugin developers

Hi Valerio,
if you click on each of the links of my post above, you'll find most of the answers wink.

HTH,
Matteo

 
Average of ratings: -