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

Google Sheets GC1

Essential Tasks

Copy of Google's Official Practice Sheet

  • 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

Google Sheets GC2

Essential Tasks

Copy of Google's Official Practice Sheet

  • 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)