I have a client who has elearning but no Learning Management System (LMS). This article shows a solution I found in the Elearning Heroes support forum. This is just an overview – if you want to actually do it, go straight there: https://community.articulate.com/discussions/articulate-storyline/exporting-variables-into-a-google-spreadsheet
The task was to build a quiz in Storyline that would test users’ knowledge of two topics and provide a recommendation of elearning to do based on the gaps in their knowledge. The client wanted those results recorded but doesn’t have an LMS and isn’t in the market to get one (before the salespeople hit on me!).
They use Storyline and wanted to record the user’s name and a pass or fail status for each of the two topics.
Outline of the solution
The details of the solution are at the link above but here’s an outline.
- set up a spreadsheet in Google Sheets with a column for each piece of info you want to track – first name, surname, score for one topic, score for the other topic. Each column will have a corresponding variable in Storyline
- run a script (provided in the original article) that will feed the spreadsheet with the data received from Storyline
- set up your Storyline quiz, passing user names and scores to variables that exactly match the column headings in your spreadsheet
- publish, make a small alteration to the story.html page (there is a suggestion in the forum for how to bypass this) and deploy the course!
The spreadsheet updates instantly when a user enters the right slide or clicks the ‘send’ button. You don’t have to use a quiz results slide or any SCORM calls, and the course can sit anywhere on the web or even locally on a PC connected to the web.
Although the spreadsheet receives data anonymously from any user running the quiz, it’s only viewable by the person who creates it and anyone they give permission to. Permission can be view-only or edit.
Doing more with the method
And that’s the basics. Also on the forum you’ll see how others have developed it further – removing the need to edit the HTML page on publishing, capturing results for multiple courses, sending emails to administrators and even returning the variable values to users who restart the course later.
It didn’t work first time for me, but nothing usually does! There’s lots of advice and help available there. As usual with scripting, it’s a comma or quote mark in the wrong place that scuppers it.
It brought home to me what a great resource Elearning Heroes is, and how smart and helpful people can be.
So if you don’t have an LMS and need some tracking – here’s one way to do it!