This widget provides a non-LMS option to use Google Sheets for exporting and saving data entered by the learner or generated in the learning course. You can save and access all learning records from Google Sheets as well as pull data back into the course if needed. The ability to save records to Google Sheets provides a great way to have the data at your fingertips in a clean and easy-to-read format. You will connect your Sheets document first, and will then use triggers in Articulate Storyline or actions in Adobe Captivate to pass the data from the course to the spreadsheet.
Marla is an instructional designer building a compliance elearning course. She wants to know whether the learners click on the optional “Learn More” button on one of the slides, and how this action correlates with the final quiz scores.
Marla sets up a spreadsheet with two columns:
“Clicked” – a column that will indicate whether the learner clicked on the button, and,
“Score” – a column that will store the learner’s final score.
She then adds a trigger in Storyline to set the value of “Clicked” to True whenever the button is clicked. She also adds a trigger to set the value of “Score” to the number of points the learner scored in the quiz.
Marla deploys her course, and as learners complete it, she keeps an eye on the records populating in the spreadsheet to find out whether clicking the button results in higher quiz scores.
Ideas for using Google Sheets in elearning
Export variables and view their values in Google Sheets
Save the learner’s score without using a learning management system
Keep track of learner’s progress in the course
Save the responses a learner provides in knowledge checks
Store a list of learner’s actions taken within the course
Monitor how the course is being utilized by the learners
Supported authoring tools
Cost to use the Sheets widget in Articulate Storyline or Adobe Captivate
Reading/writing: 100 free credits each month, $1 per 1,000 API calls after that.