Google Sheets addon - "autoCrat" - New Visions Cloud Lab
Our EdTech team had the pleasure of attending a two-day action packed Google Apps For Education (GAFE) Summit 2015 in Phoenix, Arizona. This summit included two keynote presenters, 8 breakout sessions, a demo slam, and a closing session. The sessions were beginner through advanced levels based on the uses of Google Apps in the classroom.
I am proud to say that our EdTech team has a great wealth of knowledge based around Google Apps for Education, but I still found myself having quite a few "ah ha" moments in the sessions I attended. I wanted to share with you an amazing addon for Google Sheets that stuck out to me and that I have used multiple times already this year.
The first one I wanted to share is called "autoCrat". autoCrat is developed and maintained by New Visions Cloud Lab - http://cloudlab.newvisions.org/add-ons/autocrat
This is an addon for your form created response sheet or any Google spreadsheet that you may have. This addon is essentially an amazing multi mail merge tool that allows you to set your <<Cutsom Tags>> based on the columns/questions of your form. autoCrat allows you to create custom merge documents in Google Docs and either share them with rights to comment, edit, or send as a PDF file.
I have found many uses for autoCrat such as:
- Short Constructed Responses and Essays for Formal and Summative Assessments
- Communications to Parents and Form Letters
- Certificates of Completion for Units of Study or Professional Development
- Progress Reports
- Lesson Plans
- RTI Data Management
- Classroom Checkout of Materials
- Behavioral/Academic Referrals
- Personalized Assignments