Want to know which questions learners got right/wrong in their eLearning?

Have you ever wondered if UniversitySite records answers to individual questions in an eLearning piece such as an assessment?

 

Guess what?  It does.  This data is not however exposed through the reports in UniversitySite so you have to dig them out of the database using a SQL query such as the one below.

 

/*
0 Undefined       – The value has not been specified.
1 Correct         – The learner responded to the interaction correctly
2 Incorrect       – The learner responded to the interaction incorrectly
3 Unanticipated   – The learner responded to the interaction in an unanticipated manner
4 Neutral         – The learner responded to the interaction in a way that was neither correct or incorrect
5 Real            – The learner responded to the interaction in a way that is best represented by a number (of type Real)
*/

SELECT Learner=u.lastname + ‘, ‘ + u.FirstName, r.[registration_date], Course=dbo.[fnStringTrainingCourseFullName](c.Prefix, c.Number, c.Title), o.[item_identifier], i.[interaction_id],
      Result=CASE result
            WHEN 0 THEN ‘Undefined’
            WHEN 1 THEN ‘Correct’
            WHEN 2 THEN ‘Incorrect’
            WHEN 3 THEN ‘Unanticipated’
            WHEN 4 THEN ‘Neutral’
            WHEN 5 THEN ‘Real’
            ELSE ” END
      FROM [ScormRegistration] r   
      inner join ScormActivity a on a.scorm_registration_id=r.scorm_registration_id
      inner join [ScormActivityRTInteraction] i on i.scorm_activity_id=a.scorm_activity_id
      INNER JOIN [ScormObjectIdentifiers] o ON o.[scorm_object_id]=a.[scorm_object_id]
      inner join users u on u.id=r.USER_ID
      INNER JOIN [TrainingCourses] c ON c.[ID] = r.[training_course_id]
      order by u.lastname, u.firstname, r.[registration_date] desc, c.[Prefix], c.[Number], o.[item_identifier]

 

Tags: eLearning, SCORM