This functionality has been available on Google Documents for awhile, but this evening I finally took some time to try it for myself. Like commercial survey services like SurveyMonkey, Google Forms (a feature of Google Spreadsheets on Google Docs) now supports branching, or conditional survey questions!
This means you can ask a question, and route survey participants to different survey pages and questions based on their answers. This is VERY powerful and useful for many purposes. I remember around 2002 helping a doctoral student in our college setup a survey for her dissertation using Dragon Web Surveys and Filemaker Pro. Commercial survey options have been available now for a few years, but those all cost money. A single user license for Dragon Web Surveys with Filemaker lists for $1899 US, and a copy of Filemaker Pro 9 is also required. Web-based survey companies charge far less, usually for a monthly subscription, but the dollars can still add up for these costs.
The price of branching surveys in Google Forms / Google Docs? FREE. 🙂
Among many other things tomorrow at the Google Workshop for Teachers in Austin, I’ll be helping participants learn how to create a self-grading quiz using Google Forms. Lisa Thumann is the lead leader for this workshop, and I’m thrilled to be assisting. This 5 minute YouTube video provides a tutorial on how to create a quiz as a Google Form.
This screencast, which is just under 10 minutes long, not only explains how to create a quiz but also how to make it SELF GRADING. This may sound a little misleading: With this method, students will NOT immediately be able to view the specific questions they got right and wrong. YOU, as the teacher, will be able to make the spreadsheet “grade” (evaluate) all the multiple choice questions in the quiz with this method. To do this, you will be able to copy / fill down simple formulas you create with the IF and AVG functions (just as you would in Excel or another spreadsheet application) once students have submitted their answers so the spreadsheet can grade responses for you. These steps are explained in the screencast!
If you enjoyed this post and found it useful, subscribe to Wes' free newsletter. Check out Wes' video tutorial library, "Playing with Media." Information about more ways to learn with Dr. Wesley Fryer are available on wesfryer.com/after.
On this day..
- Reasons to Invest in Education - 2011
- 3 External Microphone Options for iPads (Nov 2011) - 2011
- Captions and Cross-References for Automatic Page Numbers in MS Word - 2011
- Pennsylvania Newspaper Article / School Tech Director Misrepresents CIPA - 2011
- Ready for the Creativity World Forum #cwf2010 - 2010
- Learning about the amazing iOS Square Credit Card solution - 2010
- Remembering the amazing Grape iMac: 266 mHz with a 6 GB Hard Drive - 2010
- Accessing the web where URL shorteners don't work? Problem solved with Untiny - 2009
- Ustream chat moderation lessons and Coursecasting opinions - 2008
- Negotiations with Siteground for alleged shared hosting account "abuse" continue - 2008