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!

37 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
    Replies
    1. I was cured of CANCER with the used of natural herbs. My name is Mella Ken and am from US. I love herbs so much. Most times, injection and drugs are just a waste of time. I was cured 8 months ago, i suffered from CANCER for 3 yrs but with the help of Dr.Sayo herbal medicine, i was cured within few weeks of drinking the herbs he sent to me through courier delivery service. This same doctor also cured my Aunty from FIBROID, as soon as i heard she had FIBROID, i quickly refer her to Dr.Sayo and she was cured too after drinking his herbs.I have referred more than 15 persons to Dr.Sayo and they were all cured from their various illness. Have you taken herbs before?. You have spent so much money on drugs,injections,surgeries etc and yet you have no good result to show for it. Contact Dr. Sayo now, he is a herbalist doctor, i assured you of a cure if you drink his natural herbs. Dr.Sayo have herbs that cures Hiv, Herpes, diabetics, asthma, hepatitis, HBP, STD, cancer, chronic, etc. Contact Dr Sayo through his Email address on: sayoherbalhealer@gmail.com or WHATSAPP/CALL him on+2349012175679 Visit his FB page: https://www.facebook.com/Sayo-Herbal-Healer-100145798345000/    
      also visit website: http://sayoherbalhealinghome.com/ or check blogs: https://naturerootandherbscures.blogspot.com/ Please share the good news to other people once you are cured    

      Delete
  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
  24. You have done a great job. I will definitely dig it and personally recommend to my friends. I am confident they will be benefited from this site. massage tools for back

    ReplyDelete
  25. Make a list of your valuable goods and use it. With the help of you or your service provider can pack your valuable goods rightly.

    House Removals Birmingham

    ReplyDelete
  26. Closed-circuit television or CCTV has been the original security essential as far as home automation is concerned. With the combination of security cameras and smart home automation, waterloo homes for sale they have become all the more indispensable and sophisticated.

    ReplyDelete
  27. Inspiration can be a part of fun but bringing this inspiration to practicality would need a lot of homework to be done, Flatmate finder so that your home turns to be just the way you want it.

    ReplyDelete
  28. meaning that a person looking for it doesn't have too hard a time looking for it. This is important, because products that are easily available, and about which there is adequate public awareness, almost inevitably go on to become very popular and successful in the markets. bryer paving reviews

    ReplyDelete
  29. Once, solving these varieties of issues has been the hardest assignment for each person but now it isn't always because of this extraordinary website!e-gim

    ReplyDelete
  30. The reason being, when your kids are old enough and have their individual rooms, you can dismantle them and put them in their rooms. l shaped triple bunk bed

    ReplyDelete
  31. House building even the least complex develop takes more than the normal extent of a construction article in a distribution; in any case, there remain are general rules and regular straightforward advances that involve house building. Construction company

    ReplyDelete
  32. A typical sort of window is a vertical sliding window. Consider introducing an enemy of lift gadget which acts like a deadbolt as this will keep the glass from being lifted up and out. Windows and doors

    ReplyDelete
  33. Thank you for this post. I found it helpful. I will check back later for more great content. I also found some good information here https://conservationconstructionofdallas.com/financing/ Anyway, keep up the good work and I'll check back later to read more amazing material.

    ReplyDelete
  34. In case you're rebuilding since you need fridge repair to remain in your home, you should even now try not to over-improve it.

    ReplyDelete
  35. David H. Allen is the President of Caledonia Development a home improvement organization he established in 2002. roof installation

    ReplyDelete