Free webinar: Two Ways to Export Course Data and Variables. Join us and learn a new skill!
bulb
bulb
bulb
bulb
bulb
bulb
bulb
bulb
bulb
bulb
bulb
bulb
bulb
bulb

Sheets eLearning Widget

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.

Google Sheets eLearning widget for Articulate Storyline and Adobe Captivate

Use case example

  • 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

  • Articulate Storyline

  • Adobe Captivate

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.