×

Google Sheets eLearning Widget

This widget allows to export and save data entered by the learner or generated in the learning course. The data can be both imported and exported to/from Google Sheets.

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.

eLearning Widgets 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

idea 1

Save the learner’s score without using a learning management system

idea 2

Keep track of learner’s progress in the course

idea 3

Save the responses a learner provides in knowledge checks

idea 4

Store a list of learner’s actions taken within the course

idea 5

Monitor how the course is being utilized by the learners

idea 6

Supported authoring tools

Articulate Storyline

Adobe Captivate

Cost to use the Sheets widget in
Articulate Storyline or Adobe Captivate

API pricing: 100 free credits each month, $1 per 1,000 API calls after that.