At a training I attended a couple of months ago, I was shown how to use the add-on autoCrat for Google Sheets. It takes information from a Google Sheet and disseminates it into specified places on a Google Doc based on a template that includes <<merge tags>>. Once in the Doc, it can be emailed automatically to specific email addresses as a Doc or PDF, shared with specific people, or just kept in your Google Drive.
The possibilities are endless for how to use this, but here are a few ideas. Feel free to check out my AutoCrat Ideas folder in Google Drive. All of the files there are set up for you to have viewing access, but File>Make a copy will add a copy of it to your drive to edit for your own use.
- At Meet the Teacher night, instead of trying to read information scrawled on the papers you left around the room, have parents completed a Google Form. From there, use an autocrat job to: send a personalized welcome email, and populate a student information sheet that you can print for your sub folder and teacher planner.
- Alice Keeler had the brilliant idea to use AutoCrat to create personalized newsletters for each student. I have a sample in my folder. My sample was made very lazily, so there are options such as, “Student is doing social studies,” but it’s enough to give you the idea of how it works. For the newsletter, I have mine set up to not run the AutoCrat job until I manually go to the spreadsheet and push the run button. That way, no one gets their newsletter until I’m ready to send it to everyone. I made a Google Form for it, but some sections will be the same for every student (although, not for every newsletter), such as general information and important dates. I plan on completing that part of the form for the first student, then copying and pasting for the rest of the class in the spreadsheet. Another alternative would be to update the template before running the AutoCrat job for each edition of the newsletter, and just eliminating that question from the Form.
- Filling out award certificates.
- Sending emails to parents to inform them about an event regarding their child (positive message, missing work, etc.)
- Sharing the questions and a student’s answers to a Google Forms quiz with their family in a neat document.
- Awarding badges or certificates for completing specific tasks.
Do you already use autoCrat in your classroom? What are some other ideas you have for how to use it to make your life easier?