Capture Quiz Results to a Excel spreadsheet

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
Gerry Wasiluk

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

Chat54 .

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

Gerry Wasiluk

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.

John Backewich

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