Question about the results reports and possible expansions. We need to track students as they complete courses so that we can enter their information in another system and also to give them a certificate. So it would be it could be very useful to see a complete list of students and their results for all courses and/or for one course so that we could track students as they complete courses.

I might be able to join your result table with the user record and profile fields in order to get what I need myself using mysql tools outside of Drupal. However, is there any plan to expose your result table to 'Views'? Then I could do it all within Drupal.

Also I noted that when a user takes a course a second time that the results tab displays both his results and the dates completed, however, the global highscores by all users isn't updated if he got a better score.

Thanks for any help,

Jeff

Comments

webservant316’s picture

webservant316 commented

Also I would like to be able to create a View that lists the course/node title and the results of the current user. That view then would be very useful to the student because it would have a list of all available courses and their results for all the courses they have taken. If the CCK SCORM Field user results were exposed to views then this view/report would be quite easily made.

Is that possible?

pgerling’s picture

pgerling commented
Assigned: Unassigned » pgerling
Category: support » feature
webservant316’s picture

webservant316 commented

The fields I would like to see exposed to Views would be

1. date course started
2. last accessed
3. percentage completed (if available)
4. last score
5. best score

Maybe there is more information available or other ideas you can think of.

Many thanks for considering this.

webservant316’s picture

webservant316 commented

Here are the docs that explain how to do the integration to views, http://views-help.doc.logrus.com/help/views/api. Again thanks for any help with this.

webservant316’s picture

webservant316 commented

Some additional thoughts. Exposing the scores to Views is important to us because we are hoping to build a view that lists courses of various types including your CCK SCORM, the Quiz module, and a new module that we are developing that links to a hosted course player. Your module is attractive because it plays SCORM courses for free. It would be great if courses of various types could easily be listed in one View with similar result data available.

After further reflection and working with the other course types we are hoping to have this information available from each course type...

1. Time spent by user
2. Completion status (not started, started, finished)
3. Score as a percentage
4. Satisfaction (unknown, pass, fail)

Also very useful would be a flag for the course creator that indicates whether to store multiple scores per user per course or only the best or only the latest score.

Does this feature request seem doable? Perhaps we could help.

Jeff

pgerling’s picture

pgerling commented

Hi Jeff,

I have currently no time to spent on cck_scorm, but I think I can point you to the right spot. Have a look at the 'scorm_scoes_track' table - that's where you find all information tracked by the module. The information itself depends on the SCORM course you played - I once tried to integrate a highscore list - but since almost every course returns different information, its pretty difficult to track point 2, 3 and 4 from your list.
Point 1 is also difficult to track, since you get no information when the user closes the browser etc.pp. (Yeahr, there is window.onClose() etc, but you do not want to use this to call a page that starts a database query..).

Philipp

webservant316’s picture

webservant316 commented

Thanks. We may consider paying someone to look into this. If you are able to offer some counsel at that time it would be greatly appreciated.

dirk.westrup’s picture

dirk.westrup commented
Status: Active » Closed (fixed)

Of course, you can contact us everytime.

Closed, because issue is fixed. Can be reopened, if there are specific questions.