Evan OBranovic
  • Home
  • Edtech thoughts, tips, and tricks
  • Showcase/Presentations
  • About Me
    • Teaching Philosophy
  • Resume
  • Essays
    • Goal Statement Reflection
    • Future as a Learner
    • Synthesis Essay
  • Annotated Transcript
  • Home
  • Edtech thoughts, tips, and tricks
  • Showcase/Presentations
  • About Me
    • Teaching Philosophy
  • Resume
  • Essays
    • Goal Statement Reflection
    • Future as a Learner
    • Synthesis Essay
  • Annotated Transcript
Search

autoCrat your life!

9/1/2016

2 Comments

 
Picture
Find the autoCrat add-on in the Chrome web store or the add-on market directly in a Google Sheet.

I have written about the autoCrat add-on before in my "What Google Sheets and add-ons can do for you..." post, but I really wanted to spend some time diving into the great ways myself and my district are using this versatile add-on to help automate, streamline, and uniform how we format and share information from our Google Apps for Education (GAFE) with our staff. The process of autoCrat is really just a version of a mail-merge tool, but with the added power of GAFE, (specifically Forms, Sheets, and Classroom) you are really able to create and maintain a workflow that better helps the transfer of information between everyone.

I have used it many times with my co-integrator, Anita Moose (@amooseIT), in order to create and share certificates of completion for our technology-based professional development with our staff. This process has allowed us to use an existing roster of participants collected from a Google Form registration and create custom certificates that serve as record of participation, completion, and in-district credit. We also then have a spreadsheet containing all the relevant data and links to the certificates to share with HR in order to qualify staff for salary advancement and keep their records digital and searchable.


Picture
Collecting information via a Google Form is a great way to get all the important details in a spreadsheet that you can run autoCrat on to send form letters or certificates.

Picture
Using the response sheet from a Google Form, you can run autoCrat to pull the specific information you want and insert it on a Google doc template.

Picture
Here is an example of a Google Doc template created to insert Form/Sheet info on. Using carets (<<>>) to tag the text you want to replace cues autoCrat to pull that info from the Sheet and insert it into the Doc.
Picture
This is a completed autoCrat document filled in with information from a registration form. These can then be individually emailed to the recipient with their custom information.

Picture
Here is an example of a Google Doc template created to serve as a certificate of completion for our in-district workshops
Picture
This is the completed autoCrat certificate with the participants registration from a registration Form/Sheet. That Sheet can then be shared with HR to provide a easily searched record.

Anita has used autoCrat to create progress reports for middle school students as they self-evaluate on a rubric designed to evaluate character using Google forms. Grades 5th-8th are enrolled in a Google Classroom per grade-level and expected to complete the self-evaluation each quarter The results are then pushed to a running progress report that is printed and included in report card envelopes sent home at the end of each quarter to help students see their progression throughout the year.

Picture
AMS students fill out this Form each quarter to evaluate themselves on a character rubric promoting positive school culture.
Picture
This Google Doc template is used four times a year with the response sheet to the Culture of Character Form. Each quarter autoCrat is run and fills out the next column of the template providing a running record of each students self-evaluation.

Our district has started to move several of their processes to a digital/GAFE format and we again found great use for autoCrat. With the large amount of professional development opportunities our staff take advantage of during the school year and summer, we wanted to streamline the process of approving relevant PD and keeping track of completion. All approvals are now done through Google forms as well as completion certificate submissions. This makes record keeping for our District office much easier and a quicker turn-around for teachers and staff to have the information they need.

Picture
This is a district-wide template of a PD approval confirmation that teachers receive once administration has given the "ok".
Picture
Here is a completed autoCrat PD approval form that includes important information from the teacher submission about the course and additional approval info from building and district administration. This greatly improves the workflow from traditional paper forms.

Picture
When a staff member runs an in-district PD, they are given a copy of this sheet to customize for their own attendance and record keeping. They can then run autoCrat to personalize completion certificates and turn in a copy of the Sheet to HR for district records.

So now you can see how much autoCrat can improve your workflow. If you are a Google school you need to start taking advantage of this FREE add-on and become far more efficient with how you can collect, format, and share information. There are lots of great tutorials out there, but below you will find one that walks through the latest version of autoCrat by Brent Coley that is well done. Please don't hesitate to contact me for help getting started with autoCrat and feel free to comment below on great ways you have found to use this amazing tool!

2 Comments

    About Evan

    Tech Integration Specialist at the Aspen School District. Level 2 Google Certified Educator. Former 4th grade teacher and Spartan for life! Go Green!

    Picture

    Categories

    All
    App Building
    Apps
    Coding/CS
    Edtech
    Future Ready
    GAFE
    GIFS
    Gmail
    Google Calendar
    Google Chrome
    Google Classroom
    Google Docs
    Google Drawings
    Google Forms
    Google Maps/Earth
    Google Sheets
    Google Sites
    Google Slides
    ISTE
    PD
    SAMR
    TPACK
    Web 2.0

    Archives

    January 2019
    December 2018
    October 2018
    September 2018
    August 2018
    July 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015

    RSS Feed

Proudly powered by Weebly
Photo used under Creative Commons from ByttDualModem
  • Home
  • Edtech thoughts, tips, and tricks
  • Showcase/Presentations
  • About Me
    • Teaching Philosophy
  • Resume
  • Essays
    • Goal Statement Reflection
    • Future as a Learner
    • Synthesis Essay
  • Annotated Transcript