If you haven’t created a Google Form yet, I highly recommend it. It is a quick and simple way to gather feedback and yes, turn it into a spreadsheet! Through a lot of trial and error in learning this program, I have learned a few tricks that I want to share with you!
- Make the first question “What is your name?” This is most important if you want to know who filled out the surveys. Anonymous surveys would not need this.
- Make the second question “What is your email address?” This will make it really easy to generate an email list later to send to the participants.
- When possible, create questions that are multiple choice or checkboxes (click all that apply). Answers will be narrowed which makes it easier to gather comparable data. Think pie charts! (Melissa, this has nothing to do with eating pie) Just add an “other” category if you know there might be other answers.
- Before sharing, change the setting to make the form accessible to people not in the Mayfield network. This is so important! Even if it is to the Mayfield faculty, if people are not logged into their Mayfield gmail account, they won’t be able to access the form. The participants not in the network will each send you an email requesting that you invite them. Save yourself a headache and change this setting!!! (Click on the picture below for a video of how to share with a link and change this important setting)
- When you create a spreadsheet from the responses, change to wrap text so the spreadsheet is easy to view. This is helpful for paragraph responses. Believe me! (Click on the picture below for a video of how to create a spreadsheet and wrap text)
For any extra help, Adrienne and I are happy to help!