Capture Quiz Results to a Excel spreadsheet
Jul 19, 2012
By
Chat54 .
Dear Community I have a storyline project that I would like to capture the results and text variables from a Results slide into an excel spread sheet that will be on the C Drive of a laptop. The reason for this is that the users who will be using the module do not have access to a PC in the workplace. The plan is put the module onto a laptop , drop the laptop, at the site in the morning and pick up in the afternoon and then download the spread sheet after they have taken the module. Do you think this is possible? Thanks in advance for any help or suggustions.
Chat54
9 Replies
Hi!
Here's another option, one that's pretty easy, assuming the laptop will have connection to the Internet: Put your quiz into a Google doc form or survey and then embed it in your Storyline course as a web object.
The results will be collected in Google docs online and you can export that out as a spreadsheet.
See Tom's Screenr in this thread: community.articulate.com/forums/p/12250/73837.aspx
Thanks Gerry I had looked at the google docs soloution,but this would not work as these laptops will have no connection to the internet! Hence my issue of capturing the information,I guess I could set up a print the slide to pdf and have the user save it somewhere? This would be far from ideal. Thanks anyway. Chat54
you could use javascript to write the results to a text file, this could be formatted as a csv file
an example can be seen here, I have tried this and it works http://www.articulate.com/support/kb_article.php?product=st1&id=llwes8cn32vg
Phil excellent thanks for signposting me! Chat54
Great solution, Phil!
Works when you want the spreadsheet on one PC.
@Chat54: As a side topic, I'm assuming you'll have resume turned off in your Storyline course? Otherwise, if you have a common login for everyone, a new user launching the course may get prompted to resume where the last person left off.
Gerry I am going to be building a test shortly so will take note of what you have said. Thanks very much! Chat54
I want to ask the question again. . . can you export quiz results in Articulate to an excel document?
This is the reply I received from Articulate support this morning.
There is currently no built in function in Storyline for this, but you may check out this post in our community forums for some options that might work for you:
https://community.articulate.com/discussions/articulate-storyline/capture-quiz-results-to-a-excel-spreadsheet
Thanks for popping in to share with the community John :)
This discussion is closed. You can start a new discussion or contact Articulate Support.