Tips

• Questions

  • Keep question titles brief, rely on descriptions for more details

  • Organize (alpha sort) in Sheets, then copy-n-paste into Google Forms

  • Pre-fill forms with data for different audiences

• Adjust Settings ->

  • Responses to NOT collect email addresses if you want to allow people anonymity

  • Defaults -> Form Defaults -> Collect email addresses by default (off switch)

• Modify Responses ->

  • You can link to an existing Sheets spreadsheet with multiple Form Responses, great if you want to gather data from multiple Form sources into one place for aggregation.

• Create a tracking Sheets spreadsheet with Forms and Responses via =hyperlink formula

• Put Forms and Responses Sheets together for easier tracking

Tips

• Break your data up into discrete sets

• Use Named Ranges when appropriate

• Group Rows as needed

• Set up a Statistics/Stats or Summary page to capture aggregate information from

  • Multiple Sheets tabs in one Sheets document

    • (=CountA and =CountIF and =Average are my favorite functions) and

  • Sheets (=ImportRange) from different Sheets documents

  • =Query function is fun to use

Hack #2 – PowerTools

This free add-on to Google Sheets makes it easy to create and update Google Classroom. With RosterSync Teacher Edition, you can sync a copy of a Google Classroom course roster. Student names and email addresses get saved to Sheets. Why is this important? It makes getting at data saved in Classrooms easier to use elsewhere. Once you have that class roster of students, you can use other add-ons (like Flippity) to do more.