Use Google Forms to generate a survey or take a quiz. There are times when the results of a survey or quiz need to be collected across multiple Canvas courses or multiple sections of a course. Create a survey across all sections of a Canvas course to collect data and gather feedback from a broad student base. If there are several Canvas courses that require students to take the same quiz, create the quiz using Google Forms to collect all the submissions in a single location. It is a tedious process to manually collect Canvas quiz results into a single Excel spreadsheet for further analysis. Some features available in forms include:
- Survey questions can be asked in a variety of formats, responses collected from multiple Canvas courses, and data charted to get a big-picture view of all responses. Surveys are often used for collecting student feedback, conducting data-based research studies, and building quick polls (Misuraca et al., 2021).
- Quizzes created with Google Forms can be automatically graded. Scoring can be used for more than just multiple choice questions and dropdowns. Short-answer questions can also be auto-graded by setting a number range (e.g., answer should be between 1 and 10) or setting text rules (e.g., answer must contain the word "oxygen") (Yang et al., 2021).
- Forms supports logic branching for multiple choice and dropdown questions. You can send students to another section or question based on their previous answer, or you can choose to end the survey or quiz.
- Forms display different types of graphs based on what type of questions in the survey or quiz. Analysis is limited, unless you use Google Forms in tandem with Google Sheets.
Even though all student responses can be accessed within the form, Google Forms gives you the ability to store and organize your results in a spreadsheet with Google Sheets. Each row features the responses from each respondent, and each column features a question from your form. If your form has a large number of responses, pivot tables in Sheets can help you summarize the data and make it easier to manipulate. Basic logic options are available for simple reporting but more complex needs will require the Google Sheet to be downloaded as a Microsoft Excel spreadsheet and accessed by a statistical software platform (e.g., SPSS) for research purposes.
The remainder of this article will describe the individual use cases the instructor will need to be able to successfully complete to use Forms to create surveys and quizzes:
- Manage Multiple-Course Surveys and Quizzes with Forms
- Create, Manage, and Display Content from Drive into Canvas
- Analyze Survey and Quiz Results
Manage Multiple-Course Surveys and Quizzes Using Forms
Create Surveys and Quizzes with Forms
Use Google Forms to generate a survey or take a quiz. There are times when the results of a survey or quiz need to be collected across multiple Canvas courses or multiple sections of a course. Forms collects all of the survey and quiz results in a single Sheet. This is beneficial for additional analysis and research.
Step-by-Step How To
Students take a Canvas survey or quiz (created in Google Forms). Student responses can be sent to Google Sheets to compile the submissions. Instructors can add additional information to the same spreadsheet for notes, feedback, or grading. Follow these steps to get started with Forms:
- Learn about Google Forms training and help
- Sign into your TWU Google Account
- Click on the App Launcher
- Click Forms
- Get started with Surveys
- Get started with Quizzes
Create, Manage, and Display Content from Drive into Canvas
Hyperlink or Embed Files from My Drive into Canvas
Once the survey or quiz has been created you can link to the form anywhere you can use the Rich Content Editor in Canvas. Several features in Canvas support the Rich Content Editor, for surveys and quizzes the recommendation is to add the link to a Page. Canvas manages all of the share permissions required for students to complete the survey or quiz.
Step-by-Step How To
Follow these steps to create a hyperlink from Google Forms on a Canvas Page:
- Sign into your TWU Google Account
- Log into Canvas
- Open your Canvas course
- How do I create hyperlinks to external URLs in the Rich Content Editor as an instructor?
Note: For graded quizzes the grades have to be entered manually into Canvas or imported into the gradebook. Review How do I import grades in the Gradebook?
Analyze Survey and Quiz Results
Survey and Quiz Results are Available in Forms and Sheets
There are two ways to review survey and quiz results:
- You can see a summary of all responses or look at individual responses on the Response tab of the form. There are views for all responses and individual responses.
- To analyze your responses further, you can send them to a spreadsheet. The spreadsheet is a Google Sheet linked to your form, so responses appear in real time. If you download the Sheet to an Excel spreadsheet, the Excel spreadsheet is NOT linked to your form.
Step-by-Step How To
To review survey and quiz results begin in your form:
- Sign into your TWU Google Account
- Click on the App Launcher
- Click Forms
- Open your survey or quiz (Google Form)
- Follow the steps to Analyze form responses
If you selected the option to see responses in Sheets:
- Sign into your TWU Google Account
- Click on the App Launcher
- Click Forms
- Learn about the Differences between Sheets and Excel
- Learn more about Sheets and Excel best practices
- Follow the steps to Manage data in Sheets
- Follow the steps to Analyze data in Sheets
- Learn more about 10 Google Workspace tips to analyze data
To download the Google Sheet to Microsoft Excel for further analysis:
- From Google Drive, right click on the name of the sheet, and choose the Download option. Sheets will automatically convert this on the fly and output an xlsx (Excel spreadsheet) format file.
References
- Misuraca, M., Scepi, G., & Spano, M. (2021). Using Opinion Mining as an educational analytic: An integrated strategy for the analysis of students’ feedback. Studies in Educational Evaluation, 68, 100979.
- Yang, C., Luo, L., Vadillo, M. A., Yu, R., & Shanks, D. R. (2021). Testing (quizzing) boosts classroom learning: A systematic and meta-analytic review. Psychological Bulletin.
Support Options
- Reference the Google Forms Training and Help for step-by-step instructions to use Forms and the Differences between Sheets and Excel for step-by-step instructions to use Sheets.
- Contact an Instructional Design Partner to learn more about using Google Forms and Google Sheets to manage multiple-course surveys and quizzes.
- To request technical support, submit a Technology Service Desk email to start a ticket.