Saturday, May 6, 2017

"Send Home Sheets" with GSuite and Autocrat

Due to being a 1:1 Chromebook classroom and my general feelings on the importance of technology integration, my students take many of their assessments (or "opportunities [to show our learning]" as we call them in class) with Google Forms. This is great because it cuts down on the amount of paper I need to print (and the time spent copying, handing out, collecting, etc etc.)

However, with students completing their assessments completely on their Chromebooks (including receiving their score, feedback, and some immediate remediation), parents and families don't get to see their child's results like if they had a paper/pencil assessment and thus can't work with their students to help them improve. I do check and send home their written work for math assessments, but many history and language arts assessments are completely digital. If we truly want parents working with their students at home, we need to be sure that they can see where the students have made mistakes, along with the questions and correct answers.

One of my favorite Google Sheets Add-ons is Autocrat. It's a powerful tool that essentially allows you to create a mail merged Doc from a Form/Sheet.

For a brief bit of background knowledge on Autocrat, it operates with tags that appear like this: <<response>>. (I sometimes call the tag arrows "carrots.") You create a Doc template with <<tags>> in place of things you want inserted from the Form/Sheet. For example, if I wanted to ask a question about what a student thought the capital of Virginia was, I would put <<Virginia capital>> or something similar on the template Doc, and when I run Autocrat, it would fill it in with their response (which would hopefully be Richmond!) This can be set up to run automatically, and once you get the hang of it, it's incredibly easy to use. I'll admit that Autocrat isn't the easiest thing to explain in a blog post, but the video tutorial will make more sense.

Using Autocrat, you can make a Google Doc that inputs each student's responses from a Google Form assessment, along with the question and correct response, which I call a "Send Home Sheet." You can then print them or have them automatically emailed to parents for them to review and help begin remediating. Watch this video to see exactly how to do it.


When all is said and done, it takes roughly 5 minutes to set that all up. Copying and pasting from the response sheet saves lots of time in the "mapping tags" step, and keeps the formatting in nice and even columns.

Part of the benefit of doing assessments on Google Forms is the elimination of paper. This method seems to directly conflict with that, but in the long run, it's still less paper. My students recently completed an assessment that was 23 questions. If each question (and all four to five answer choices) were printed, it would have been 7 pages.

However, but using some clever formatting on the "Send Home Sheet," it ended up being 1 page front-to-back (lots of the saved room came from not having to print all the answer choices and the fact that a three column format is more efficient than one question per row). For my class of 29 students, I was able to print all of their "Send Home Sheets" in less than 30 pages versus the over 200 pages it would have required to print paper-based assessments. If you opted to send the results directly to email, no paper would have been used at all. (Personally, I use a Drive app called PDF Mergy to combine all 29 "Send Home Sheets" into one PDF and print that.)

Furthermore, by using the Quiz feature on Google Forms or Flubaroo, I didn't have to do any of the grading by hand. I'm a big fan of letting technology do as much of my rote tasks as possible so I can focus on using the assessment results to work on remediation.

Finally, and possibly most importantly, some parents aren't ready to accept that they might not see their student's work. This is a valid feeling, because if they want to help (and we need them to play a vital role in their child's education), they need to see where the gaps are. "Send Home Sheets" allow the best of all worlds - less paper waste, more time for the teacher to work on more important tasks, and gives the parents something tangible to review.

Give it a whirl in your class and let me know in the comments below how it works out for you!

24 comments:

  1. I never knew the proper way to send sheets. I always had problems while sending them. But I'm glad to know that these things exist. I'm sure this will make things much easier.

    ReplyDelete
  2. Possibly a good thing to complete would be to seek advice from several concrete introducing companies and obtain their own views, as well as (often free) estimations. This short article may provide you with a common concept of what are you doing, exactly what to consider within an concrete introducing service provider, as well as exactly what to incorporate in your own agreement. asphalt driveway

    ReplyDelete
  3. I like this post,And I guess that they having fun to read this post,they shall take a good site to make a information,thanks for sharing it to me.
    plumbing southend

    ReplyDelete
  4. A sumptuous blog, honestly. Valued each and every piece of it.
    southend builders

    ReplyDelete
  5. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. Best Spray on Gun Finish

    ReplyDelete
  6. I think about it is most required for making more on this get engaged kitchen backsplash

    ReplyDelete
  7. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work backsplash tile

    ReplyDelete
  8. Make repairs to anything that obviously needs it. This means dripping faucets, loose banisters, cracked windows - anything that a buyer will notice. These little things make it appear that the home hasn't been maintained - something no buyer wants to take on.RANGE REPAIR in Rancho Cucamonga

    ReplyDelete
  9. I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. electric leaf blower

    ReplyDelete
  10. Your home is always so warm and relaxing Alicia, and your Spring touches are perfect! Just lovely! As always so honored to share this home tour with you dear! Cheers! new windows in fort worth


    ReplyDelete
  11. Thanks for the blog filled with so many information. Stopping by your blog helped me to get what I was looking for. Now my task has become as easy as ABC. SEO

    ReplyDelete
  12. Such a strikingly basic article.I basically wish to offer a creature proceed for the standard data you have perfect here on this post. Joshua Houston

    ReplyDelete
  13. Paint the outside and the inside of your home. A new layer of paint is a basic home improvement venture that will give your home another spotless look. The outside intrigue will look welcoming to guests and the crisp new inside will make them happy they entered.Repair Appliance in Riverside, Moreno Valley, Corona, Murrieta, Temecula, Hemet, Indio, Palm Springs, Palm Desert, Indian Springs, Rancho Mirage, Lake Elsinore, Jurupa Valley, Norco, La Quinta, San Bernardino and Ontario.

    ReplyDelete
  14. You there, this is really good post here. Thanks for taking the time to post such valuable information. Quality content is what always gets the visitors coming. pinze per vetro

    ReplyDelete
  15. The author has done a fine job of converting the feelings into words.
    dining room chairs toronto

    ReplyDelete
  16. Wow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also unique logo for your brand, business

    ReplyDelete
  17. It's grievous that some home improvement ventures are attempted on the grounds that something has broken.lucht warmtepomp

    ReplyDelete
  18. Wow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also Royal CBD

    ReplyDelete
  19. There are too many things which could go wrong with a house - not having knowledge of these things can cost you dearly in the long-run.Land for sale near Clinton Missouri

    ReplyDelete
  20. Great article Lot's of information to Read...Great Man Keep Posting and update to People..Thanks DCondo Sign for sale

    ReplyDelete
  21. What a sensational blog! This blog is too much amazing in all aspects. Especially, it looks awesome and the content available on it is utmost qualitative. niche related

    ReplyDelete

  22. See what appears in a Google search and a Yahoo search. Having a LinkedIn profile and profiles on other expert interpersonal interaction locales can assist with making a constructive computerized impression. 3 Quick Tips For Remote Work From Home

    ReplyDelete
  23. What more would you be able to request, for your well deserved cash? Zenit ramen en deuren

    ReplyDelete