What It Does
The new Google LMS Widget with Email Reporting lets you keep track of quiz scores, quiz answers, and survey data by reporting it to a Google spreadsheet. No Google sign-in required for students. Send individual email transcripts back to your students or/and an administrator(s). The creativity is up to you. If you can capture the info in a Captivate variable, this widget will send it to the spreadsheet and email the results.
How Does It Work?
No Google Form necessary! Place the widget on the first slide of your .cptx project. Create a Google Spreadsheet. Paste the Google Apps Script Code into the Spreadsheet’s code editor. Authorize the script and publish it as a web application. Google will give you a URL that you will paste into the properties of the widget. Fill in the rest of the widget’s properties as described in the VIDEO.
Live DemoHTML5 Live Demo SWF Live Demo
Enhancements over the previous version:
- Supports HTML5 Captivate output
- Supports the “Submit All” quiz feature
- No longer need to set up a Google Form
- No longer uses an Amazon web service to broker the submission (Uses 100% client side POST directly to the Google Spreadsheet)
- Adobe Captivate 6 or 7
- Publish for Flash Player 9 or 10
- Published output needs to be swf/htm or HTML5
- Watch the screencasts below
- Quota of 500 emails a day per the standard free Google email account. If you have an educational or business account, that number can be as high as 1000 emails a day. Check your Google Dashboard to view service levels and quotas. Remember that the quota is based on how many recipients you have in the email including the CC and BCC fields. So if you send one email with 3 recipients, you’ve used 3 of your daily quota. If you need more than 500/day, consider upgrading to a Google business or educational account.
- The “Also store the user’s quiz answers” feature is not supported with random question pools.
Have a pre purchase question or need assistance? You can contact me directly using the contact form or drop a comment on this post.
Try Before You Buy:
You can download a fully functional trial version to test in your own projects. It will display the CaptivateDev.com logo and a red “Trial Version” in your project. If you purchase the premium version, it will remove the logo and trial version message.Download Trial
Setting Up The Google LMS Widget
Setting Up The Email Transcription Service
Download Google Apps Script
Q: Could you password protect the spreadsheet containing the answers so that only a person, such as a teacher could ever get access to the results?
A: Yes. The spreadsheet containing the quiz results can be secured so only those who need to see the results have access. You can secure it by going to “File” –> “Share” in the spreadsheet and give access to certain individuals.
Q: Can a learner resume a course from where they left off using this widget?
A: Unfortunately not. It only reports variables to the Google spreadsheet and does not handle suspend or resume data.
Q: I’ve added, removed, and rearranged questions in my Captivate file and now my spreadsheet’s header columns are out of whack. Do I have to fix them manually?
A: No. Simply delete the “Timestamp” header (cell A1), and make another submission with your Captivate project. Your headers will automatically be recreated. How cool is that!
Q: It seems from the demo that the student can click a button to view all the answers from all the other students. Is there a way of preventing the student from seeing the results that are submitted?
A: Only the demo contains a button to view the final results in the Google spreadsheet. If you want to include a button like that, it’s up to you. The widget does not do that automatically.
Q: Is the email text entry box in the demo being used as way of identifying the student? If so would it be possible to use a variable that has already been recorded elsewhere in the project eg. the student id?
A: Yes. The email Text Entry Box is not part of the widget and it is simply my way of identifying the learner in the demo. You could use your own studentID variable just as well.
- v. 6.1 (July 25, 2012) – fixed Windows 7 64 bit widget insertion issue
- v. 6.2 (October 24, 2012) – now supports the “Submit All” feature and now works with the Captivate patch to v. 22.214.171.124
- v. 6.3 (December 9, 2012) – now supports HTML5, No longer requires A Google Form, No longer uses an Amazon Web Service.
- v.6.3.1 (December 13, 2012) - No longer requires a question slide in your project. Now has the ability to translate Cp variables that are embedded in question text, and answer text of questions. Fixed the bug where the “Also Store the User’s Quiz Answers in the Spreadsheet” check box had to be checked for the widget to report to the spreadsheet.
- v.6.3.2 (December 17, 2012 )
- Using a backslash character “\”, percent “%” character, or using a hard RETURN character in the text of a quiz question or quiz answer, or in a Cp variable, no longer prevents the results from being processed by Google.
- Typing a double quote character when a student answers a Fill-In-The-Blank question no longer prevents the results from being submitted to Google.
- Hiding slides in your project no longer prevents results from being submitted to Google.
- Un-checking “Also store the users Quiz answers in the Spreadsheet”, and checking “Store the data in the Spreadsheet Only if the User Passed the Quiz”, and having a real quiz in your project no longer prevents the data from being submitted to Google and correctly submits the data only if the user passed the quiz.
- v.6.3.3 (December 18, 2012) – Fixed issue where having a % character in an image URL no longer prevents the email transcript from being sent. This can happen if you have spaces in your URL such as http://myserver/My%20Image.jpg where “My Image.jpg” is the file to be used for the logo, header or footer image. You can either replace the “%20″ with a space, or use v6.3.3 which fixes this issue.
- v.6.3.4 (February 28, 2013) – Now works with v. 6.1 of Adobe Captivate. Note that v. 6.1 is for subscription licenses only. That 6.1 “update” had broken the widget, but v. 6.3.4 of the widget fixes this. Fill-in, short answer, and matching are not supported in HTML5 output.
- v.6.3.5 (April 6, 2013) – The widget now supports fil-in, short answer, and matching questions in HTML5 output. So all questions are supported except Likert (which is a Captivate limitation).
- Publishing for Flash Player 11 can cause the project to freeze. You should be publishing for the lowest common denominator (Flash Player 9 or 10) so users are not forced to upgrade their Flash Player just to view your course.
- When copying/pasting settings into the widget, double pasting can occur when using a Mac.
- Drag and drop questions prevent results being sent to the spreadsheet.