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

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

av Valerio Ferri -
Antall svar: 6

Hi there,

first time for me on this forum.

My problem is that I need a report on time spent on SCORM activity in Moodle report.

I know it's possible to export it at single and specific user level, but what if I need a global report? It's something very similar to what I uploaded in attachment file. I need one more variable in column which gave me time spent or at least the moment in which users exit from the activity.

Thanks in advance for your precious advice.

Valerio

(Edited by Helen Foster to remove attached file - original submission Thursday, 12 July 2018, 10:39 AM)

Gjennomsnittlig vurdering: -
Som svar til Valerio Ferri

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

av Matteo Scaramuccia -
Bilde av Core developers Bilde av Peer reviewers Bilde av Plugin 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

Gjennomsnittlig vurdering:Useful (1)
Som svar til Matteo Scaramuccia

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

av Valerio Ferri -

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!


Som svar til Valerio Ferri

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

av Rachel Martin -

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.

Som svar til Rachel Martin

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

av Matteo Scaramuccia -
Bilde av Core developers Bilde av Peer reviewers Bilde av Plugin 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 blunker - is that the latter is more "active" in terms of latest commits (Jul 3, 2017 vs May 9, 2018).

HTH,
Matteo

Som svar til Matteo Scaramuccia

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

av Melanie Scott -
Bilde av 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...

Som svar til Valerio Ferri

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

av Matteo Scaramuccia -
Bilde av Core developers Bilde av Peer reviewers Bilde av Plugin developers

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

HTH,
Matteo