Formulas for Forms: Easy and Powerful Functions in Google Spreadsheets

Mark Wagner, Ph.D.


Combine powerful spreadsheet functions with Google Forms: Self-grading quizzes using Scripts, individual walk-through reports
using TRANSPOSE, multiple data sources combined with VLOOKUP, mail merge with Gmail, and much more!

Slides

Formulas for Forms: Easy and Powerful Functions in Google Spreads



Agenda and Resources

Welcome Activity
What's the geekiest thing you've done with a spreadsheet or with a Google Form?


Self Grading Forms

Individual Walk-Through Reports
Reports using TRANSPOSE (Search the Function List for official Syntax and Description)
Tip: Nest a FILTER in the TRANSPOSE function to create a template that a less-technical user can simply cut and paste into instead of writing their own formulas.

Combine Multiple Data Sources with VLOOKUP 
(Search the Function List for official Syntax and Description)

Mail Merge

Send Confirmation Email after Form Submission with the FormEmailer Script



More Spreadsheet Formulas (Select "Google" from the drop down for some amazing new formulas not in Excel!)

Reflection Activity
What's the geekiest thing you're going to do with spreadsheets or forms? 
Comments