Google Forms gives educators a powerful data collection tool. Check out these 20 ways to harness its power in school. (Google Forms logo used under fair use)
Everyone wants data. Schools want it to track student performance. Companies want it to learn about their customers.
We track data in our own personal lives (fitness data, banking data, even social media data).
Teachers and students have their own data gathering and tracking tool that’s free and easy to learn — Google Forms.
Google Forms lets you create a survey with lots of different kinds of questions:
- Short answer
- Long answer
- Multiple choice
- Check boxes
- Drop-down menu
… and more. You can distribute these surveys to anyone — students, parents, even yourself — and track the data in the Google Forms app itself or in a spreadsheet.
Teachers have used Google Forms to do quizzes and assessments for a while. But that’s not the only way it can make our lives easier and better!
Here are 20 ways to use Google Forms in the classroom and in schools:
1. Opinion surveys — Want to get to know your students better or learn about their preferences? How about parents? Create a simple survey. Add a short answer question for the name, or if you want to keep it anonymous, leave it out.
2. Quick poll — A simple one-question Google Form makes getting the pulse of the classroom quick and easy. Closed-ended questions can be displayed as graphs immediately in with the “Responses” tab in the form.
3. Late work submission (with email notifications!) — When students use this form, they can provide assignment details and a link to any digital work to turn in. You can receive an email when they submit the late work form. In Forms, use the “Responses” tab and click the three dots menu button. Select “Get email notifications for new responses”. It will automatically send an email to the account you used to create the form. Here’s an example of a late work submission form you can use.
4. Sign-up sheets — Need students or parents to sign up to bring something to class, work the concession stand, etc.? Have them sign up in a Google Form! Want to eliminate a choice once someone has taken it (i.e. remove a time slot when it’s been claimed)? Use the Choice Eliminator add-on to remove that choice after someone makes it (so nothing gets claimed twice!). Check out the Choice Eliminator page to see how it works.
5. Sign-out sheets — Ditch the sign-out sheet when students leave and return from the room (or when they check equipment in and out). Use a Google Form instead! Use the CheckItOut add-on. It uses multiple choice, list or check boxes questions. When something is signed out, it moves to another question — the signed-out group. When it’s signed back in, it’s moved to the signed-in question. Create a “Name” short-answer question and you can see the paper trail of who checked equipment in and out and at what time in the spreadsheet of results. This YouTube video (less than two minutes!) makes using the CheckItOut add-on crystal clear.Click to view what the form would look like, or click to make a copy you can edit yourself.
6. Lesson plans — Want to quickly create detailed lesson plans with standards, learning objectives, activity descriptions and more? Add all the parts you want included in those lesson plans in a Google Form. (Add all of the individual standards as check boxes.) Then view your own form and start filling in information. Use the Autocrat add-on to turn your responses in the Google Form into custom-created documents. You’ll have a document with all of your lesson plan information for each day! These are great for turning in to administration, leaving for substitute teachers or filing away for next year. See the blog post I wrote with detailed step-by-step directions here!
7. Autograded quizzes — If you create a quiz or other assessment with closed-ended questions, Google Forms will autograde it for you. Create your quiz and click the gear (settings) button. Choose the “Quizzes” tab and turn on “Make this a quiz”. You have some options in that window. Then, go through your questions and select the correct answer (your answer key).
8. Quizzes with Flubaroo — Flubaroo is an add-on to Google Sheets that can create a detailed grading summary with student results from an assessment. When students complete a quiz/assessment in Google Forms, click the “Responses” tab and click the little green Sheets button. This will create a spreadsheet of results from the quiz/assessment. Open that sheet. Flubaroo’s official user guide walks you through the steps of setting Flubaroo up to autograde your assessment. It creates a summary that shows average student grade, individual student grades (plus which questions each student got right or wrong), questions students struggled on, and more.
9. Exit ticket/bell ringer — Have students answer questions at the beginning or end of class with a Google Form. Add images, links, videos and more to the form to make it a richer multimedia experience. Then gather all of the student responses in a spreadsheet.
10. Quick grade log — To quickly mark a grade for simple assignments, create a Google Form with every student’s name. When I did this, I walked around the room and had the form loaded on my iPad. I put each student’s scores into that form. Later, I pulled up the responses and transferred them to the grade book. Here’s an example form of what that might look like that you can copy into your Drive!
11. Flipped classroom assessment — The flipped classroom comes in many different shapes and sizes, but many teachers have students watch a video and then answer some comprehension questions afterward. This is easily done in Google Forms. Create a form with a YouTube video (created by you or found on YouTube) and questions. Here’s what a form like that would look like when students loaded it.
12. Rubrics — Create your rubric in a Google Form to make an easy place for you to assign grades and provide feedback to students. When you’re done grading and writing feedback, use the Autocrat add-on to turn all that feedback into a document. Share that document with students (or parents too!). Here’s what a rubric form could look like when you load it (click here). Here’s the document generated with the feedback for students (click here).
Learning and creating
13. Logs (for exercise, nutrition, reading, etc.) — If students need to submit information in logs to track progress over time, Google Forms can capture that information easily. Create a form with the student’s name and all the information he/she needs to submit. Each time he/she submits, it’s logged into a spreadsheet where students can review that data and submit it to you.
14. Choose Your Own Adventure stories — By using branching (the “go to section based on answer” choice in the three-dots menu in a multiple-choice question), you can create fun Choose Your Own Adventure Story-type activities. Create them for your students or let students create their own! Here’s a math example from Mandi Tolen’s class.
15. Sharing examples in professional development — Teachers can use Google Forms to share their learning, too! During professional development, direct teachers to a Google Form where they can share their ideas, reflections or experiences from the classroom. Provide a link to the spreadsheet of results to everyone in the group. That way, when everyone’s done, each teacher can see everyone else’s ideas all in one place!
16. Answer with an image — With younger students, the old version of Google Forms was tricky because almost everything used text. Now, you can ask questions AND provide answers with images! Teachers can cue students verbally and they can answer by choosing the correct picture. When creating the form, just click on the answer to edit it and click the image button at the right. Here’s a VERY simple example of how to use images as an answer (click here).
17. Brainstorming with a word cloud — Provide a simple Google Form where students can reflect on what they’ve been learning, either with a sentence or a few individual words. When they finish, copy all of their responses from the spreadsheet and paste them into a word cloud generator like Wordle or Tagxedo. It will show the most common words larger in size than others, sorting the reflections of the class in a fun, visual form.
18. Personalized guidance via e-mail — Do your students (or teacher participants in professional development) need answers fine-tuned to their unique needs? Create a Google Form to let them choose the type of feedback they need, collecting their answers in a Google Sheet. Then, the Form Mule add-on can send them a custom e-mail response based on their answers. Basically, you write an email for every possible answer, and Form Mule sends it to them automatically when they submit the form. See more about Form Mule here.
19. Writer’s conference schedule — If your students need to schedule a time to meet with you to discuss their writing, the Form Limiter add-on can help. Create a form in Google Forms and it will gather the data you’ll need (name, class, time, etc.) in a Google Sheet. Form Limiter will stop accepting responses when specific Google Sheet spots are filled. No double-booking! Marek Beck explains how it works in this presentation at Google’s Education on Air conference.
20. The Amazing Race, Google Style. This game is an intense mashup of Google Slides/Documents, Google Forms and Google Maps (optional). Students must complete several challenges provided by the instructor using Google Slides or Documents. Once the complete the first challenge in the slide presentation or document, they submit the link to the presentation/document in a Google Form. Once submitted, the link to the next challenge in the game is in a link on the confirmation page for the form. Clear as crystal, right? No? Check out this outstanding example by Michelle Green. Once you get it, this activity is super engaging.
For notifications of new Ditch That Textbook content and helpful links:
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|
|+||03/16/2018||Lake Shore Central School||Angola, NY|
|+||03/30/2018||Taylorville CUSD||Taylorville, IL|
|+||04/11/2018||Switzerland County School Corp||Vevay, IN|
|+||04/21/2018||Great Expectations||Edmond, OK|
|+||04/25/2018||Connect Conference||Niagra Falls, CA|
|+||06/01/2018||MSD of Martinsville||Martinsville, IN|
|+||06/04/2018||Granbury ISD||Granbury, TX|
|+||06/05/2018||Columbus City Schools||Columbus OH|
|+||06/06/2018||School City of Mishawaka||Mishawaka, IL|
|+||06/12/2018||2nd Annual Learn, Explore, Adopt and Deliver (LEAD) Conference||Cleveland, OH|
|+||06/19/2018||Tyler ISD||Tyler, TX|
|+||06/21/2018||Barr-Reeve Jr/Sr High School- Washington Community Schools||Washington, IN|
|+||08/09/2018||St. Joseph Grade School||South Bend, IN|
|+||08/14/2018||Tech Camp||Portage, Michigan|
A Classroom Banking System
Each student has been provided with a bank book so that he or she can tally his/her money. All transactions must be recorded in the student’s bankbook or it will not be recognized by the bank (me).
The register is just a chart with the headings of date, memo, debit, credit and balance. I have students make them as needed.
First day of each month:
Rent for desk: $150
Rent for chair: $150
Purchase of Desk/Chair: $500 (Once you own your desk/chair in the classroom you can buy other desk/chairs in the classroom and collect rent from others. Landlords can raise the rent 6% for the following month, once they own a desk/chair to rent out. They must declare this in a letter to the bank.
All owners will owe property tax each month (2% of the current value of the desk/chair).
The price of buying a desk/chair will be reassessed in January. Market value may be reduced or increased at that time.
Other expenses will accrue for misbehavior, missed homework, lack of cooperation, etc. You can avoid paying these fines by correcting your behaviour.
Tardy - $25
Cheating - $100
Gum - $100
Messy Area – $25
Dirty Desk - $25
Destruction of Property - $500
Talking while teacher talking - $20
No agenda signing - $25
Homework not completed - $25
Yelling Out - $25
Not Listening - $25
Off-Task - $25
Arguing - $50
Foul Language - $100
Running in the hallway or on the stairs – $25
D - $25
F - $50
Teacher Discretion – Any amount
How can I earn money?
You can earn money by following school rules and completing your work.
Completed weekly reading log and word study assignments will earn up to $100/week. (This means that to get the $100 the work must be well done and complete.)
Projects research assignments in any class will earn $100.
Daily homework that is completed will earn $20/day. This means that you have to complete all your homework in all classes.
Any student who has behaved well all day will earn $5/day.
How else can I earn money?
If you help a teacher, you can earn $20. You are not allowed to ask for money.
The class as a whole can earn a prize (each student receives $30) if a compliment is received from a teacher. You may not ask for compliments.
If you receive a “good news note”, commended for outstanding behaviour at an assembly, for a good deed that you have done, or any other commendation, you will earn $20.
If you improve your grades by 5% from the last quiz/test/assignment, you earn $50.
Classroom jobs pay $150/month. Each month students can apply for various jobs. Applications will be accepted about a week before the end of the month. Each month a student will receive the “Employee of the Month” which will earn an additional $150.
If you make an error in your bank book, we can forgive this once. Repeated errors will be fined $10 per incident.
We offer interest at 3% per month for positive balances.
We offer overdraft at 8% per month for students who fall into negative bank balances.
Each student will be charged $20 per month in bank fees.
Second Term, we will offer classroom investing options for students.
*Talk to a financial advisor (me or your parents) to help you work towards your classroom financial goals.