Let me start by presenting you with a few scenarios:
Here in the LHS library, we just kicked off a new event called "Blind Date With a Book". Students and staff fill out a form to share their interests, and the library staff uses that information to match them with a book to read. Each time someone submits a form, I want the library staff to receive an email with all of the information nicely formatted on a printable document so we can choose a book and place the paper inside until someone comes to pick it up.
As a Digital Learning Specialist, I run training events for teachers to receive professional development hours. After the training is complete, I want to send each person an email with a certificate of completion featuring their name and the number of hours they receive.
As a former video production teacher, I wanted a quick way to assess and provide feedback to my students as I watched their projects. I wanted to fill out a form while I watched and have the feedback sent to the student automatically.
The solution to all of these scenarios? A free Google Sheets Add-On called Autocrat. Basically, Autocrat combines the data from a spreadsheet (which can be the responses from a Form) with a document template that you create in Docs or Slides. Let's see it in action with a feedback form.
Step 1: Create a Google Form with all of the information you want to collect:
Step 2: Create a template using tags (just words housed inside of << >>):
Step 3: Install and set-up Autocrat (this is a tutorial)
Step 4: Test it out! Here's an example of what the student would receive:
This is just one example of how to use Autocrat - there are plenty of other uses. The key is to think about how you could use a template to view or share data individually. Be creative!
Comments