Scorm reports

Scorm reports

by Paweł Nogal -
Number of replies: 10

Hi All,

My question is related to preparing reports from scorm format courses.

I have received such a package recently. It contains 3 separate parts/lessons of a one course and two tests (in lesson 2 and 3). I wanted to prepare a report that would contain basic data like:

- time spent in test,

- grade,

- number of attempts,

The data should have been presented in an separate view for each of a two tests from package.

Unfortunately, it was impossible for me to create such a report. I could only download *.xls file with one grade (could be visible in different ways: percentage view, normal, etc) even if a user had completed each of the two tests from the package. Moreover, the grade in this report was not even an average and, what upsets me most, it was impossible to create a full report with a separate view for each of the two tests from the package.

But, such data are available to be seen when I check user account > reports of activity > full report. I can see how long the user was in each lesson, what is the score he received.

So my question is as follows: Is there any way to upload data like:

- time spent in a test,

- grade,

- number of attempts,

to scorm report? It should be visible separately for each test from one package.

You might say, if you want to have your data check it for each user separately, then write it down and make a report manually. Yes, but it is too time consuming. And it is not the thing how it should look like...

Thanks & regards,

Pawel

Average of ratings: -
In reply to Paweł Nogal

Re: Scorm reports

by Ron Meske -
Picture of Particularly helpful Moodlers
Hi Pawel,

The reporting for SCORM activities is definitely lacking. We have started and stopped a few times on creating a report plug-in for Moodle that would give a much more flexible report interface and would include the ability of displaying all the information SCORM activities store.

If there is any interest in partnering to create this type of report, please let me know.
Average of ratings: -
In reply to Ron Meske

Odp: Re: Scorm reports

by Paweł Nogal -
Hi,


Indeed I am interested in creation of such a plug-in... just like many other Moodle users.

My question is about what kind of partnering you are thinking of? If it is about jobs directly connected with IT works the thing is I am not an IT guy and I do not have any knowledge in this matter.

I do would like to contribute but I can offer my help in conducting tests of such a plug-in.

What about the other users? Who can spread the message, who who may help?
Average of ratings: -
In reply to Ron Meske

Re: Scorm reports

by Marco Loche -
Hi Ron,

we actually use multiple SQL queries to report to customers student's SCORM activities. I've posted some of those queries in this discussion and other on my site.

As main manager at Capturator.com I'm absolutely interested on developing such module, colaborating with you. But should-we also involve the quys in charge of the SCORM module (if their are inteested in!!) or you was thinking about an indipendent module?

read you

ciao

Marco
Average of ratings: -
In reply to Marco Loche

Re: Scorm reports

by Piers Harding -
I am interested in this. I think a first step would be to provide a configurable export tool, as part of mod/scorm, that dumped out grade book information, aligned to track data (SCORM elements). this would atleast allow people to import into a spreadsheet, database, or reporting tool of their choice.

As an aside - I am also interested in marrying this to Pentaho -> http://www.pentaho.org.

Cheers,
Piers Harding.
Average of ratings: -
In reply to Piers Harding

Re: Scorm reports

by Ron Meske -
Picture of Particularly helpful Moodlers
As part of our effort to create a SCORM report that contained the data we need to report on, we also were looking at how to design a more flexible reporting interface.

I posted the suggestion here: http://moodle.org/mod/forum/discuss.php?d=111347#p498889

Any thoughts?



Average of ratings: -
In reply to Ron Meske

Re: Scorm reports

by Piers Harding -
[after reading the suggestions]

I like the idea of flexible reporting, in particular the idea of flexible criteria, but, I think that it is generally better to leave complex/sophisticated reporting up to tools that specialise in it - this is why I suggested Pentaho, something that I would envisage creating a reference implementation for (Moodle specific reporting metadata files, and sample reports). Basically, if we come up with a flexible way of extracting data from Moodle that consentrates of allowing the user to select columns based on SCORM data elements, and to apply custom selection criteria (and possibly to store these extract rules/formats for later use), then I think that will go a long way to satisfying user requirements, without second guessing their reporting requirements, or creating lock in.

Cheers,
Piers Harding.
Average of ratings: -
In reply to Piers Harding

Re: Scorm reports

by Marco Loche -
The ideas and examples from the Ron's discussion "Proposal - Flexible reporting" look great. Should we merge the two discussions?

A point I want to mention is the possibility to choose the way data is consolidated.
In our course we import complex scorm packages corresponding to learning modules usually made of 10 LOs. In our reports, for certain data we need to count the values (for example completed los), for some we need to know the average (score) and for others we prefer to have the sum of the values (time spent on each lo). Should the interface consider the consolidation method for each scorm column?

Marco
Average of ratings: -
In reply to Marco Loche

Re: Scorm reports

by Piers Harding -
Hmm - If I understand correctly, you use a different grading method for different SCOs within the same SCORM package?

I think I would need to see this, to understand correctly.

Cheers,
Piers Harding.

Average of ratings: -
In reply to Piers Harding

Re: Scorm reports

by Ron Meske -
Picture of Particularly helpful Moodlers
I believe what compicates reportin on SCORM is that a SCORM course consists of 1 or more SCOs and each SCO can have its own completion state, time, score, etc.

This is similar to a Moodle course with Multiple activites. So it would seem that in the case of a SCORM activity the same type of Gradebook options for the consolidation of multiple activities is needed to consolide multiple SCOs.

The type of information clients of ours typically ask for are:
  • Status of a Course as well as SCOs
  • Time spent in a Course and each SCO
  • Course Score and each SCO score
On occasion a SCO may be optional so there needs to be a way of determing the overall course status and score based on all required SCOs and any optional SCOs that were completed.

Marco, is this what you are looking for?




Average of ratings: -
In reply to Ron Meske

Re: Scorm reports

by Marco Loche -
I'm sorry if my post was not very clear, the idea was to have a simple interface for user to define the groupping operation (AVG, SUM, etc etc) on the SQL related to the filter

The answer to Ron's question is yes! we have the same type of request from customer, but we don't have to manage optional SCOs. Typicaaly we have :

- time spent on all SCOs
- Number of SCO browsed/passed/failed
- SCO's score average
- average time spent on completed(passed and failed) SCO

For example to retrieve total number of scoes by a user we use :

SELECT mu.id, mu.firstname, mu.lastname, COUNT(DISTINCT(msst.scoid))
FROM mdl_user mu
LEFT JOIN mdl_scorm_scoes_track msst ON mu.id= msst.userid
WHERE
mu.id IN (
SELECT DISTINCT(ra.userid)
FROM `mdl_course` cr
JOIN `mdl_context` ct ON ( ct.instanceid = cr.id )
LEFT JOIN `mdl_role_assignments` ra ON ( ra.contextid = ct.id )
WHERE ct.contextlevel =50
AND
cr.id IN ( 86, 88, 89, 90,91) #course you are looking for
AND
ra.userid <> 61 AND #we may not be intrested in some user
ra.userid <> 135
)


Today we use to query directly the db, export raw data and format them on excell file.

Average of ratings: -