What It Does
You asked for it, now you have it! 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 form. 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?
Place the widget on the first slide of your project. Create a Google Form with text entry fields that correspond to the number of variables that you want to send. Go to the live Google Form and copy/paste the Form Key in the form’s web address, into the widget’s properties. Fill in the rest of the widget’s properties as described in the VIDEO. The email service is a Google Apps Script that will send an email transcript every time a quiz is submitted to the spreadsheet.
Enhancements over the Captivate 5.x version:
- Allows you to send a customized email transcript automatically back to your students.
- Will automatically detect when quiz is completed and send the results without any user intervention. This typically occurs on the quiz score slide. If you don’t have a quiz in your project, the results will be sent on slide entry of the last slide.
- You have the option to submit every quiz attempt, or only send the results if the user passed the quiz.
- Now supports question pools and randomization of question answers.
- Records not only the answer (A, B, C), but also the answer text (A-Red, B-Blue, C-Purple) for all question types.
- Reports “Skipped” if the question was skipped over by the Learner.
- Will accurately report partial answers to matching questions. If the Learner only matched two items out of five, the remaining three will be marked “Skipped”.
- The cpQuizInfoPassFail variable will report “Pass” or “Fail” vs. true / false.
- Hot Spot answers now report “Incorrect” or “Correct” vs “-1” or “o”.
- Now uses the Google Form Key vs. the form action url which can be easily obtained from the web address of the live form.
- Allows debugging mode for troubleshooting.
- Adobe Captivate 6.x
- Publish for Flash Player 10+
- Watch the two screencasts below
- Does not work with HTML5 output
- 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.
Have a pre purchase question or need assistance? You can contact me directly using the contact form or drop a comment on this post.
Screencast Part 1: Setting Up The Google LMS Widget To Record Answers
Screencast Part 2: Installing & Configuring Email TranscriptsDownload Email 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 behind the form 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’m in the process of creating my Google Form and when I test it, the results are jumbled or some are just skipped.
A: The linkage between the Google Form and back end Spreadsheet can be jumbled if you re-order the fields in your form or columns in your spreadsheet. This is a common problem related to Google Forms. The fix is to delete the spreadsheet TAB in the workbook that the results are on. Then, make a submission using either the live Google form or the widget in your .cptx project. This will recreate the spreadsheet TAB with the proper column order based upon the order of the fields in your Google Form. However, if you inserted a field in the middle of other form fields, then you will have to recreate your form from scratch to get the proper order.
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.