From the Tech Side

Information you need to know about technology at Wooster

Google Forms

As Bob takes a well-deserved breather, I thought I would give you some information on Google Forms. I have found them to be very useful ways to collect information over the years, and they have gotten more and more flexible and powerful since they were first introduced.


At its heart, a form is a web-based questionnaire that automatically puts respondents’ answers into a spreadsheet in your Google Drive. You have almost certainly interacted with Forms through the “G-Slips” that now serves as our way to give good/bad slips, and for seniors to input their job recs. Many of you submitted a form for the technology survey we sent out a month or so ago. What follows is a few ideas on how you can use them and a video tutorial for how to create them and access the results.


One of the most useful things I have done with a form is to use it to record daily assignments and class activities. I created a very simple form with fields for the date, what was assigned, and what we did in class that day. I then share (with view-only permission) the spreadsheet that collects those results with my students, so they can see what was assigned over the course of the year. And, of course, they can check it that evening when they forget what the homework was! With more responsible groups, I have given students the ability to fill out the form, then assigned the task of submitting it to one person per week.


I have also created a form to gather student feedback throughout the year. This was embedded on my class website, and it allowed students to anonymously submit comments and thoughts about my class and teaching whenever they wanted. It is easy to also collect each submitter’s username, and the form will tell them that their username is being submitted.


You could easily create quizzes using forms, and at the end of the video below, he begins to make something like an “exit ticket” for students to quickly fill out at the end of class. In fact, if you look at the related videos, you will see that someone has figured out a way for a quiz to be self-graded using Forms, Sheets, and a script! (If you get that to work, please share your knowledge!)


Here is the video explaining the basics of creating a form, choosing which kinds of questions they can have, and showing ways of looking at the results they generate: http://youtu.be/oGWeNUk2s9A


Good luck experimenting with Forms, and let me know if you want any help exploring their potential uses.


Tom