Choice and Voice With Google Forms / Sheets
Hello, I'm Matthew Winters!
Matthew Winters
UEN Instructor
Google Educator Group Utah Leader
Email - mwinters@uen.org
Twitter - @TeacherWinters
Hello, I'm Kelli Cannon!
Kelli Cannon
Upper Grade Elementary Teacher
Google Educator Group Utah Leader
Email - kelli.cannon@jordandistrict.org
Twitter - @MsKelCan
Join Utah Education Network as we explore how to become a Google Certified Educator Level One & Two with our free, self-paced courses. Each course following the Google Teacher Center training materials. The course comes with an option to get a free voucher for the exam!
Google Forms / Sheets Nearpod Training
Google Sheets Open Training Video
Sort your columns
Calculate averages using formulas
Create a labeled chart from data
Add ALT text to your chart
Share your sheet
Set up sheet one as protected and can only be edited by you
Use conditional formatting
Use conditional formatting to highlight specific cells
Create a drop down list in a cell
Use data validation
Use Criteria to select options from a range
List items in a sheet
Google Forms GCE 1
Essential Tasks
Create a new Form
Create three different questions (Multiple Choice, Drop down, and date)
Create new sections
Mark questions as optional
Set up a Form with the following
Limit to one response
Can't edit responses
See summary charts and text responses
Do not collect emails
Change the confirmation message
Share the Form
Complete your own Form
Create a Sheet of responses
Google Forms GCE 2
Essential Tasks
Use settings to allow outside domains
Create two different sections
Send users to different sections based on their answers
Enable quiz features on a Form
Restrict the Form to your domain
Send the Form via email
Google Sheets
Helpful Tips
Using Freeze to keep a fixed view
Quick copy using drag on cells
Insert a Google Drawing
Text wrapping
Connecting a Form
Google Forms
Helpful Tips
Use response validation on short answer and paragraph answers
Use Import questions to add questions from other forms
Add pictures to questions
Use send to get embed code for other learning management systems / sites (Canvas, Google Sites, etc.)
Customize your theme to match your school (including gif headers)