Streamlining with Google Forms and Sheets

Participate and share : Poster

Friday, December 4, 1:30–2:30 pm PST (Pacific Standard Time)

Stacey King
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
Skill level:	Beginner
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
Grade level:	6-12
ISTE Standards:	For Educators: Designer Explore and apply instructional design principles to create innovative digital learning environments that engage and support learning. Analyst Use technology to design and implement a variety of formative and summative assessments that accommodate learner needs, provide timely feedback to students and inform instruction. Use assessment data to guide progress and communicate with students, parents and education stakeholders to build student self-direction.

Proposal summary

Purpose & objective

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.

Outline

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.

Supporting research

Hattie, J. A. C. (2009). Visible learning: a synthesis of over 800 meta-analyses relating to achievement. New York: Routledge.

More [+]

Presenters