Google Forms is a great tool for surveying others and collecting data from them. By using Forms in that way, it can save us tons of time.
It can save us even more time when we survey ourselves.
I can hear your response to that one …
Wait, Matt … survey ourselves? Have you gone crazy?
Let me explain with an example.
There was a time when I wanted to input grades in my gradebook quickly as I walked around the room checking student work. Our gradebook program just didn’t have a good option for that.
So I created my own with Google Forms. Instead of using a Google Form for others to fill out, I used it for myself. I made a form with the following data fields:
- Assignment name
- Student 1 name
- Student 2 name
- Student 3 name
- Student 4 name
… and on and on and on. I bookmarked the form on my iPad. When it was time to grade, I clicked on that bookmark, filled in the date and the assignment, and started logging grades.
The grades were saved automatically in a spreadsheet. It was easy to transfer them over to my gradebook afterward.
Afterward, I started thinking, “How else can I collect data from myself using Google Forms?”
And the logical follow-up question was, “How can my students use Google Forms to collect data from themselves?”
In this post, I’ll show you …
- The simple steps to create a form for collecting data from yourself
- Tips to create them quickly and make them efficient
- Ideas of how you can use Forms to collect data from yourself
How to create a new form in 2 seconds
Creating a new Google Form isn’t hard. But I’ve recently learned of a faster way to do it …
Enter this URL in a web browser and it automatically creates a fresh, new Google Form for you. No going to Drive and clicking the “New” button. No hassle. Just gets you started.
PS: This works with most Google file types. Some examples:
- Docs: http://docs.google.com/create
- Slides: http://slides.google.com/create
- Sheets: http://sheets.google.com/create
- Drawings: http://drawings.google.com/create
If you use your bookmarks bar in Google Chrome or create home screen shortcuts on an iPad or a tablet, you can add these URLs as bookmarks or shortcuts. That means one-click creation of a new Google file. Time and effort saved instantly.
Creating a form for yourself
If you aren’t super familiar with creating Google Forms, they’re not too hard to figure out. Start a new Google Form (see above). Then, use the circle “+” button in the top right of your screen to add new fields to the form. (If you’re using an iPad, tablet or mobile device, that button may be at the bottom.)
A field could be a place to fill in a short answer, choose from multiple choices, choose the date, etc. You’ll see all of the options when you click on the circle “+” button.
Just create the form out of the fields you’d like to include. It can be more advanced than that, but that’s the gist of it.
The data is saved in the Google Form (“Responses” tab), but it can also be saved in a spreadsheet. (Click the “Responses” tab, then the little green spreadsheet icon.)
An example Google Form
I recently created a workout log. As a sort of New Year’s resolution, I’m getting in the habit of working out several days a week. (I started typing that sentence by saying, “I’m trying to get in the habit …” and changed it. The power of stating your goals as fact!)
I figured it would be really easy to do if I just had to click an icon on my phone, enter a couple items and click submit. I wouldn’t need a paper log, so I could access it anywhere. And I’d be done in a matter of seconds.
Here’s what my form looks like:
I used the “+” button (#4 in the image above) to add new fields. Some notes from this screenshot:
1. The date field makes it easy (and fast) to select from a calendar instead of typing it in.
2. This is a short answer field so I can type in an answer. (Pro tip: I used data validation to make sure that what I typed in was a number. Click the three dots in the bottom right corner of the text field, then choose data validation. In the dropdown box, I used: “number is a number.” Sounds silly and redundant, but it works!)
3. This is a dropdown answer field. I just added all the possible options. (Note: Another way to save time in Google Forms: When you’re done typing an option and want to skip down to a new line, just hit enter.)
4. This is where it all happens. The “+” button adds new questions and data fields to the form.
5. When you’re done — or want to see what it looks like — click the eyeball icon to preview.
6. The settings button. There are lots of options here, but for our purposes (making forms to gather data from yourself), the two most useful are:
- “edit after submit” to let you change your answer right after you submitted it (if you made a mistake)
- “see summary charts and text responses” to see a chart of all of your responses after you’ve submitted something new
- (Note: Depending on what you’re trying to do, some of these options might not be that useful … but in some instances, they’re really nice!)
Google Forms creation tips
These are some ideas that will help if you’re making forms to gather data from yourself. (Really, in any type of Google Form, these tips can be useful!)
1. Choose wisely. The dropdown menu, the multiple choice and the checkbox options are similar, but you’ll want to use them in unique situations:
- The dropdown menu is nice if you have LOTS of options and you don’t want to take up lots of space on your form displaying them all. I used dropdowns in my workout log above to save space.
- The multiple choice saves you clicks and time if you only have a few options. Instead of clicking on the dropdown and choosing an option, you can just choose your option. (One click instead of two.)
- The checkbox option lets you choose multiple choices for one question (i.e. select three or four from a list of eight).
2. Required is your friend. There’s an option at the bottom of a question/data field to make that question required. If an answer is crucial to have and you want to make sure that you don’t accidentally forget to add it, make that question/data field required.
3. Get the right data with data validation. When you create a new question/data field, use the three dots in the bottom right corner of that field and choose data validation. This sets up a rule for data typed into that field. If the rule is broken (i.e. it must be an email address, it must be a number greater than zero), the form gives an error and you can’t submit. This is an easy to way to prevent typos.
4. Shortcuts/bookmarks = game changers. When you create a button or bookmark to a form, you save yourself time exponentially over digging it out of your Drive. A few easy ways to create a button on your phone or a bookmark in your browser:
When you have the form open …
- Google Chrome: Click the star button on the right side of the address bar. Make sure you have your bookmarks bar turned on (laptop/Chromebook/desktop) and add it to your bookmarks bar. That puts a clickable button on your browser.
- iPhone/iPad (Safari): Click the share button (looks like a box with an arrow coming out the top) and click “Add to Home Screen.”
- Android smartphone/tablet: In Chrome, click the three dots in the top right and click “Add to Home screen.”
You can also create a bookmark/home screen button for the spreadsheet with all of the results if you want to pull that up quickly as well.
5. (PRO TIP) Prefilled links save you even more time!: What’s faster than filling in a quick form to gather data? Having some of the questions/data fields already filled in for you.
These are called “prefilled links.” Click on the three dots in the top right of the screen. Choose “Get prefilled link”. Fill in the form the way you’d like to load it up every time. (i.e. If most students get a 10/10 on an assignment, you can prefill the form with all 10’s and change any that aren’t 10’s.) When you’re done, click submit. The form gives you a link you can use to load up that prefilled survey.
And yes, you can create a bookmark or home screen button to that prefilled link, too.
How to use forms to gather your own data in the classroom
Instead of giving you 20+ ways to use these forms in class, just ask yourself this question:
When do I write down data I need to hold onto? (Especially on a regular basis.)
Then create a form that gathers that very data. Pretty simple.
Here are some examples to help generate some ideas. Click the links above the screenshots to see the forms in action.
If you have ideas of your own — either theoretical you just thought of OR something you or students have actually tried — PLEASE let us know in the comments!
Other ways this could be used include a textbook log (if you haven’t ditched your textbooks yet!), saving random ideas that come to mind (like using sticky notes … although Google Keep is a GREAT digital sticky note tool) or student reading logs, exercise logs or nutrition logs.
The blog post below has lots of other ways to use Google Forms in the classroom. They could inspire you with new ways to use Forms yourself:
Question: How else could you use Google Forms to gather data from yourself? How could students use it in that way, too? You can leave a comment by clicking here.
For notifications of new Ditch That Textbook content and helpful links:
- like Ditch That Textbook on Facebook
- follow @jmattmiller on Twitter
- check out the #DitchBook community on Twitter
- follow Ditch That Textbook on Pinterest
- follow +MattMiller16 on Google+!
Interested in having Matt present at your event or school? Contact him by e-mail!
Matt is scheduled to present at the following upcoming events:
|Date||Event / Event Details||City / More Info|
|Crystal Hills Elementary|
|Bishop Dwenger High School||Fort Wayne, IN|
|Fox Valley Reading Council||Peoria, IL|
|Ecorse Public Schools||Ecorse, MI|
|Venue:||Burton Valley Elementary School |
561 Merriewood Dr,
Lafayette, CA 94549
|Summer Technology Institute||Norfolk, NE|
|PowerED UP Conference||Leopold, IN|
|Sponsor:||Indiana Department of Education Office of eLearning|
|Venue:||Perry Central Jr/Sr HS |
18677 Old State Road 37
Leopold, IN 47551
|Innovation Institute||Springdale, Arkansas|
|Region 6 Digital Learning Conference||Huntsville, TX|
|Whatever It Takes Conference||Galesburg, IL|
|East Porter County Summer of eLearning||Kouts, IN|
07/25/2017—07/26/2017||Roughrider Education Services Program||Dickinson, ND|