Docs Part 2


    Attempt to build a functioning copy of one of the advanced spreadsheets demonstrated in this session.


Forms can be used for so many things such as pre-test, post-tests, data-collection, meeting minutes, simple answer keys for quick grading, sign-up, and more. 
  1. Create a form that you could use in your classroom/location in the near future.
  2. Send the "live form" link to colleagues so they can fill out your form.
  3. Share the results with colleagues or publish them as a web page. 
  4. Make sure you share the form with everyone on your team and also with
  5. One member of each small group will present the file to the large group in 2 min or less.

Overview (with Links to Help Pages)

Advanced Spreadsheets
  • Using Spreadsheet Lookups
  • Mail Merge
  • Auto Add Event: Form to Calendar

  • Google Apps Scripts