Why I Allowed My Status as a Google for Education Certified Trainer to Lapse

I want to preface this with the fact that the Google for Education Certified Trainer program is really great! It required me to learn about G Suite in a way I had not prior to earning the certification, and taught me some thing about teaching an adult audience. It also connected me with a community of amazing educators who also held the credential, people who were generous in sharing materials and advice, and asked questions that would move their own practice forward.

If it’s so amazing, why did I let my certification lapse?

I’m a classroom teacher, and halfway through the year I was certified, I changed districts. Part of the deal is that you have to offer 12 training sessions in a year, which doesn’t sound difficult, but for me it was. While you are able to count that one-on-one coaching session with your teammate, one of the things you have to include as evidence is the training materials you used. I don’t blame Google for asking for this. What else would stop someone who was a little short on their training session quota from fibbing a little about who they met with and what they taught? for me thought, probably 90% of my “coaching sessions” were on-the-fly questions colleagues had about how to do a specific task or fix a particular problem. To create a training tool after the fact felt like busy work that I didn’t have time for, or to tell that colleague they would have to wait until I had time to create a training tool to teach them something that they could learn in two minutes felt self-serving, and as though such a short “training” shouldn’t count anyway.

Had I pushed more to offer training sessions to the staff in my building, particularly before leaving a district I had worked in for several years, I may have met my quota. Being a classroom teacher in a different grade, school, district, and state this school year didn’t exactly put me into a position to feel like I should be leading others, nor did it put me into a position where others knew enough about me to seek out help if they needed it.

If you’re in a role that you’ll be offering a lot of training on G Suite for Education, I highly recommend the program. If you’re the Google Admin for your school or district, I recommend it even more! If you teach your class and sometimes help your colleagues figure out how to do something new in G Suite, the Google Certified Educator program may be a better fit for you instead. The re-certification is every 3 years instead of every year, and you’re not required to offer any training sessions during that time.


Learn to Code With Google Sheets Macros

Last week, G Suite made an update to Sheets that made their product a little more efficient: macros. Perhaps you’ve noticed them in Microsoft Excel, and now they’re available in G Suite.

What IS a macro, anyway? It’s a way to automate tasks you have to do repeatedly, without writing code. To use them, go to Tools>Macros, record yourself completing the series of tasks you want to automate, save and name the recording, and then you can use it over and over again. If you’re not into coding, this can be a game-changer to save you some time later on repetitive tasks. Macros can be recorded so that they are performed over the exact area recorded on (think cells B2 through B7), or on a relative location (the active selection), so think about how you plan to use the macro before you start recording. (If Macros aren’t showing up in your Tools menu yet, check back in a few days. The nice people at Google told me that it could take up to 15 days from their new features roll out on 4/11/18 for everyone to have access to the shiny new features.)

But I AM a (novice) coder, and I’m excited about what this can do to expand my knowledge base. You see, G Suite Macros automatically transform the macro into code in Google Apps Scripts. Once you save the macro, click “Edit Script” to see what your actions look like in Google Apps Scripts code, which is a variation of JavaScript. You can access the script later by choosing “Manage Macros” and clicking the three dots to show the “Edit Script” option.

So, if there’s a task I know how do to manually, but haven’t the faintest idea how to code, theoretically, I can work backwards! I can create a macro for the task, and look at the code the macro created, instead of writing the code, hoping it will do what I want, and banging my head against the desk when it doesn’t for the 934th time. Once the script is created, I can analyze it to learn to write the code for the task I know how to do manually. Since I’ll know the end result of the code, I can use it to learn the commands and formatting that  created the desired result.

Typically, I put lines of code that I’ve found tricky to remember, but I know I’m likely to use again as notes into Google Keep. I make all of my coding notes the same color and give them the label “Code” to easily find what I’m looking for when I need it.


Using AutoCrat in the Classroom

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?