Friday, December 21, 2012

Google Scripts!

For those of you who have begun using Google Forms in your classrooms and schools, you have probably found that they are a great way to collect data. From room reservations to formative assessments, forms offer a plethora of supports as an educator. Want to take it up a notch? Enter Scripts. Scripts are amazing add-ons that you can install into a spreadsheet to automate your life. From auto-scheduling in your calendar via a form to auto-grading an assessment to auto-handing out and sharing a document, scripts can make your life oh-so-much easier.

Recently I had the pleasure of doing a Google Hangout on the Air with Liz Castillo from Hawaii, Angie Kalthoff from Minnesota and Jay Atwood from Singapore. We shared about four of our favorite scripts:

  • FormEmailer: Send email from a form
  • Autocrat: Create PDFs and Google Docs from a form
  • FormMule: Send out emails, voice messages, texts and calendar invites through a form
  • Doctopus: Create copies of Google Docs, Presentations and Spreadsheets - then share them out with students/teachers
Andrew Stillman - the author of many of these scripts - has a great site to learn more about how to use these (and more) scripts in case our Hangout video wasn't detailed enough: youpd.org.

If that's not enough Script love for you, here's an early holiday gift: Jay has an amazing site chock full of script info, graphics and tips. I highly encourage you to check it out: sandbox.atwoodphoto.com.

No comments:

Post a Comment