Lectora Inspire, Lectora Publisher, and Lectora Online include the option to submit your Test, Quiz, Survey, or Form Results to a Google Form that will create a Google Drive spreadsheet with all of the results listed. You can use a spreadsheet that you control on Google Drive to collect Lectora data instead of or in addition to using an LMS or custom server script.
This process will be updated in an upcoming release (currently planned for Fall 2018) of Lectora Inspire/Lectora Publisher/Lectora Online.
- The time results can take to show in the Google document can vary. It can range from almost instantaneous to a few hours, but if you follow the directions below, the results will submit correctly.
- Submitting your Lectora results to a Google Drive spreadsheet is currently only supported in Lectora v12 or greater and Lectora Online v2.0 or greater. Google has made changes to the process and it will no longer work in older versions of Lectora and Lectora Online.
- The learner completing the test needs to be using the latest version of Internet Explorer, Chrome, Firefox, or Safari. Google no longer supports Internet Explorer 8 & 9 when submitting results to a Google Drive spreadsheet.
- Each template includes 50 question placeholders that can be used to collect data from your learner. It’s not recommended that you add additional questions or form elements into your course if you plan on using Google Drive to collect your data.
- Unfortunately, Google changed their forms recently such that we can’t change or edit the templates (or even create new ones!), without breaking the form submission from Lectora. You cannot use a spreadsheet or template that you’ve created. But you can customize one of the approved templates.
- Each time you open one of these forms, Google will prompt you to upgrade to the new version of Google Forms. Always click “Not now”. Do not upgrade the form. Only the older version of Google Forms is compatible with Lectora. The new upgrade to Google Forms will not work.
- If your course is published to an LMS and you want the learner’s name to be submitted to the Google Drive document, even if you have the “Prompt for Student’s Name” checkbox selected in the Test Results ribbon, the course will automatically gather that data from the LMS and submit it to Google Drive upon test submission, without ever prompting the learner for their name.
- The submission works by sending a URL back to Google with all of the test data embedded in this URL. That being said, there is a 2048 character size limit for this URL. Please keep that in mind when developing your test. If you have a lengthy test with longer, or essay length answers, you may not be able to submit your results to Google Drive properly. We always advise that you test as you go, add a few questions, then preview and test to see if the results were submitted.
- Remeber that your browser has a 4KB data input limit for suspend data (cookies) that can be held during each instance. If the collective data stored for answers is more then the limit you may run into issues.
- You can test submitting your results to Google Drive with the Preview Mode in Lectora v12 or higher and Lectora Online v2.0 or higher, as well as in published content. But, due to a change in Google’s API, submission to Google Drive no longer works in Lectora v11.
- Issues of the form skipping the 16th or 25th field (sometimes fields in between these two fields). One alternative is that you can place a dummy question so that the system continues the numbering convention of data is not being transferred. This is accomplishable using an invisible question in the place of that 16th and 25th field so that all of the answers are in place. We are unable to make changes or fixes to our Google Form templates because of the changes Google has made, so this workaround is currently the only way to correct it.
We’re going to use Lectora Inspire and a Test as an example but the same steps would apply to Lectora Publisher or Lectora Online and a Survey or Form could be used in place of the Test.
Step 1 – Lectora Setup
- Select your Test Chapter in the Lectora Title Explorer to access it’s contextual properties.
- Go to the Results ribbon.
- In the Results Submission section of the ribbon, select the checkbox next to Custom Results Submission and change the Submit To drop-down box to Google Drive.
Note: You can also choose to prompt the learner for their name or to show a message to the learner after the results have been submitted if desired. You can see these options checked on the right in the above screenshot.
Step 2 – Choosing a Lectora Template in Google Drive
The next thing that you will want to do is download one of the provided templates. Three templates are provided to meet your needs. Choose from the following:
- Lectora Test/Survey Submission – This template passes over question responses while prompting the learner for their name.
- Lectora Test/Survey Submission – Anonymous – This template passes question responses anonymously.
- Lectora Form Submission – This template passes form element information (checkbox, radio button, entry field, etc).
Clicking one of the template links will prompt you to make a copy of the template. Click the “Make a copy” button. This file is now on your Google account, attached to your Google Drive.
For this example, we will be using the Lectora Test/Survey Submission template.
Note: Do not upgrade the form. When it opens it will prompt you to upgrade to the new version of Google Forms. Click “Not now”. Only the older version of Google Forms is compatible with Lectora. The new upgrade to Google Forms will not work.
Step 3 – Adding the Form URL to Lectora
The next step that we will want to do is grab the URL for the form. The URL is what will tell the course to send the test results to your specific form on your Google account. To do this:
- Select the Eye icon or View Live Form from the menu.
- A new window or tab will open in your web browser. The URL that you want to copy is now in the Address Bar/URL Bar of your browser when you are viewing the live form. Copy that URL.
- Next, go back to your Lectora title. If it is not already selected, please select your Test Chapter from the Title Explorer again and go to the Results ribbon at the top. In the Results Submission section of the ribbon, make sure that you still have Custom Results Submission checked and from the Submit To field, Google Drive selected. Click the Settings button just under that:
- A Submit to Google Drive popup window will appear where you need to paste in your copied URL into. Copy the URL into that window and click OK.
- Your Lectora title is now set up to submit results to your spreadsheet on Google Drive
- You can click the View responses button on the Google Form to view a spreadsheet containing the results from your title.
For more information about the settings and options within Google Forms, please reference Google’s help documentation: https://gsuite.google.com/learning-center/products/forms/get-started/#!/. Not all options may be supported when used in conjuncture with Lectora so you’ll always want to test the functionality before publishing and sharing with your audience.
Additional information can also be found in the Help for Lectora (LINK) and Lectora Online (LINK)