Streamlining with Google Forms and Sheets
Participate and share : Poster
Friday, December 4, 1:30–2:30 pm PST (Pacific Standard Time)
Google Forms and Sheets can be used for many different purposes. Learn how to create Google Forms and Response Spreadsheets and how to take the data you've gathered and put it to use. Easily grade quizzes, quickly gather class data, send personalized "mass emails" all from the responses sheet!
|Audience:||Coaches, Teachers, Professional developers|
|Attendee devices:||Devices required|
|Attendee device specification:||Smartphone: Windows, Android, iOS
Laptop: Chromebook, Mac, PC
Tablet: Android, iOS, Windows
|Participant accounts, software and other materials:||It will be helpful for participants to have a Google account. If using a mobile device, participants should download the Google Sheets app before attending the session.|
|Topic:||Online tools, apps & resources|
|ISTE Standards:||For Educators:
Participants will learn how to create Google Forms and Responses Sheets to gather data from students and/or parents.
Participants will learn how to analyze the data gathered from the Google Form using formulas and charts in Google Sheets.
Participants will learn how to provide individualized feedback to students quickly using a mail merge add-on.
Introduction (5 minutes): Welcome, introduction of presenters, brief explanation of what the presentation is about. Have students complete a Google Form to gather their data for later in the presentation.
Google Forms (15 minutes): Go over the basics of creating a Google Form, adding content, types of content and questions, options for different question types.
Responses Sheet (15 minutes): Show how to create a responses sheet from a Google Form and give some ideas on how to use the sheet to quickly see the desired data. Discuss some tricks and some basic data analysis formulas.
Providing Feedback (15 minutes): Discuss the Quizzes option in Google Forms. Discuss mail merges using Google Sheets that allow for quick, individualized feedback to students.
Wrap Up (10 minutes): All participants that submitted the Google Form at the beginning of the presentation will be emailed via a mail merge. Participant Q&A, idea sharing.
Hattie, J. A. C. (2009). Visible learning: a synthesis of over 800 meta-analyses relating to achievement. New York: Routledge.