Forum Discussion
HOW to report individual responses to each quiz question in a Storyline project
Hi --
I need to track in my LMS the responses that people provide to individual quiz questions (I'm up to speed on how to use a results slide to track the overall results as passed/failed, complete/incomplete). For example:
Question 1: True
Question 2: False
Question 3: D. All of the Above
Several moderators on the board point anyone who asks this type of question to this article: http://www.articulate.com/support/storyline/quiz-data-sent-to-an-lms-in-articulate-storyline
My question is this: The link above simply says WHAT is reported. My question is HOW do I do this within Storyline? Or, is it a matter of working with my LMS team to see where this data is stored within the LMS (and how to extract)?
Thanks in advance for your help.
Mike
30 Replies
Hi Dominique,
We are on SumTotal 8.9.3 and we capture our Storyline quiz data and use it for reporting purposes, but we do it mostly on the back end. There are certain tables in the database that keep this information. You should be able to access them using Report Manager and the Assessment dataset. If you use BIDS to do your reports it's easier to get to the data. Accessing it via SQL Server Management Studio is even easier. Below is an example of a query I use to retrieve the data.
SELECT [AssessmentQuestionID], emp.PrimaryJobName, emp.EmpNo, emp.EmpFName, emp.EmpLName, act.ActivityName, [QuestionID], QuestionIdentifier, ques.QuestionText, [QuestionResult], [UserResponse], [AttemptCount], [TimeSpent], [ElapsedSeconds], [AttemptStartDate], [AttemptEndDate]
FROM [S0PLRCDW].[dbo].[factAssessment] fact
INNER JOIN [S0PLRCDW].dbo.dimActivity act on fact.ActivityID=act.ID
INNER JOIN [S0PLRCDW].dbo.dimUser emp on fact.UserID=emp.ID
INNER JOIN [S0PLRCDW].dbo.dimQuestion ques on fact.QuestionID=ques.ID
WHERE (act.Code='nnnnnnnn')
ORDER BY AttemptStartDate,QuestionIdentifier
This gets me all the information I need for our business areas. You just have to make sure that whatever quiz or survey you want captured shows up on the results slide. We've done a pre-test and post survey in the same course along with the course content and built a custom results slide with them all on there and they all showed up in the data. I've attached an example of the data we can pull.
Hope this helps.
Have a great day!
James
Hi All,
This is exactly what I am looking for. We use Netdimensions as our LMS.
Anyone of you have tested in this LMS how to capture individual responses?
Thanks
Carlos
Hi Carlos!
This article describes the quiz data that Articulate Storyline communicates to learning management systems (LMSs) for SCORM and AICC content.
Hopefully some users will chime in if they have experience with that particular LMS and I wanted to share another forum thread with you, although dated, but has some conversation around this LMS.
Hi everyone! I've read through a few different threads and while helpful, I have a different situation. I am using an essay question and need to get the user's response out of the LMS (Cornerstone). I can get responses to other types of questions, but not the actual words someone has entered in the essay question. Does anyone have any suggestions or know how to do this?
Thanks!
Hi Kristin! First, make sure the essay question is tracked by a results slide that the learner visits. SCORM 2004 does a really good job of sending question and answer text to the LMS. I don't have experience with Cornerstone, but I know that I can get essay responses in SCORM Cloud using that publishing protocol.
Let me know if that works for you!
I saw this quiz data before and I'm pulling the "student response", which is where the other answers populate. I also tried on SCORM Cloud and I DO get results there. I would call this confirmation of my suspicion that Cornerstone is the issue and begin working on a workaround. I will also look through their enhancement suggestions to see if I can add or upvote something. Thank you for the response!
Hi Kristin,
When you pulled the data in the report, were you using reporting 2.0 or custom reporting?
Hey folks, does anyone know how to do this in articulate online? I really need to get individual level reporting and can't figure out how to do this.
We're even asking for the person's name within the questions used for the tracking quiz. So really, being able to see data by submit would work.
Thanks!
Astha
Hello, Astha!
From your Articulate Online account, click the Reports tab. Then, select the Attempt Detail report. This report will show you how your learners answered each survey question.
For more details on Articulate Online reports, click here!
Hi James!
Just in case Kristin is no longer subscribed to this thread, feel free to use the Contact Me button on her profile page to reach out and reference her comment!
Hello everyone! This is a really important discussion and I have a similar question. I have been trying to find reports in my SuccessFactors LMS for the quiz data but I am not getting anything. The report on SCORM details continues to be empty. Could you please help me asap because we are in a process of uploading an entire course soon. Also, could you kindly let me know is it possible to report whether the learner went through all the content AND the quiz results?
Regards,
Ankita
Ankita did you get a resolution to this?
Hi Andrew!
It looks like the fix for Ankita was adjusting the publishing settings to:
LMS: SCORM 2004 4th Edition
LMS Reporting: Passed/Incomplete
Tracking: Track using quiz resultLet us know if that works for you too!
Hi Ankita,
Thanks for reaching out and working with us in a support case! I see that Ronaziel is trying to see if we can sort why the quiz data isn't passing to SuccessFactors.
Look out for some next steps shortly!
In the meantime, here's more insight into what gets communicated to an LMS:
Hello everyone. Please tell me which api method transmits data for a report with correct and incorrect answers in SCORM 2004 4th Edition?
