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!

91 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
  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
  36. The rundown beneath shows those improvements and can be utilized as a guide for picking the best home improvements to go with. Roofing

    ReplyDelete
  37. Do you feel like your home needs a makeover? If you want to add to the beauty of your home, you must consider renovating it. clorox bleach for covid-19

    ReplyDelete
  38. Will I need to acquire my appliance for repair Water dispenser not working at your shop or will somebody go to my living arrangement to finish the repair?

    ReplyDelete
  39. Regardless of whether you are a do-it-without anyone else's help home renovator or you are recruiting an expert, you will need to dodge these regular home remodel botches. roof repair vaughan

    ReplyDelete
  40. The travel packages that i have seen on the internet are sometimes oversold, they are cheap yet the inclusions sucks.. my porn webcams

    ReplyDelete
  41. Great Article! nice post and detail work done by the article and it shows how good you are in writing good stuff .Everything is very open and very clear clarification.Thanks For share thisinformation. cam girls

    ReplyDelete
  42. Together with Visit Article content Page Syndication Provider, it is possible to move deeper together with faster rather than you might have truly dreamed with regards to your alternatives on-line. Jolie cam

    ReplyDelete
  43. This is such a great resource that you are providing and you give it away for free. I love seeing websites that understand the value of providing a quality resource for free. It is the old what goes around comes around routine. akıllı sehpa modelleri

    ReplyDelete
  44. Running any business alone can be self-fulfilling for every entrepreneur but equally as tough and impossible to successfully manage. With this in mind, hiring a business coach is always a smart move because the opinion of an expert enables and facilitates businesses to reach their full potential. The business coaching industry in the US has grown in recent decades to a worth of over $12 billion highlighting its impact and the need to find the best business coach for your business so as to unlock maximum potential. https://www.ballaratconcreters.com/

    ReplyDelete
  45. My partner and i appeared to be aware of this particular currently, however there seemed to be several useful bits which finished the picture to me, thanks a lot! امنیت سایبری

    ReplyDelete
  46. Your new home has many frameworks and more than 10,000 sections - from warming and cooling to ventilation and machines. At the point when these frameworks and apparatuses cooperate, you experience solace, energy investment funds, and solidness. definitely check it out

    ReplyDelete
  47. In actuality, it is hard to keep that "new home" look. Organizing will help reestablish and resuscitate your home to it's "new home " creativity. how to get paint out of clothes

    ReplyDelete
  48. Organizing makes central focuses that cause to notice extraordinary highlights in the home. coastal chandelier

    ReplyDelete
  49. or both. I was additionally perusing that there have been instances of youngsters passing on from utilizing a few prescriptions for bed-wetting. best silk sheets

    ReplyDelete
  50. It presents a home in a "model home" request a lot of the very that the developers use in their model homes. moroccan tile

    ReplyDelete
  51. To discover qualified and trustworthy home improvement trained professionals, check with companions, business partners, and neighbors for proposals. Continuously get somewhere around three references, and look at them altogether. Additionally check with the neighborhood part of the Better Business Bureau or Chamber of Commerce. carpet cleaner Huntington Beach

    ReplyDelete
  52. The dealer can make fixes relaxed rather being in a hurry after the agreement is agreed upon. wall decor

    ReplyDelete
  53. Your auditor will encourage you about what to do about these issues. He/she might suggest assessment - and on major issues assuredly will - by authorized or confirmed experts who are experts in the imperfection regions. puce de lit paris

    ReplyDelete
  54. They pick road artwork due to the fact it's far toward the humans. Some artists try and explicit their political opinion of their paintings. canvas

    ReplyDelete
  55. Indeed and No. Albeit not legally necessary in many states, we feel that any purchaser not getting a home assessment is giving themselves an extraordinary raw deal. Mulberry silk bedding

    ReplyDelete
  56. Such changes could be; supplanting your tub with a shower save space, contain a glass block reflect about your shower, use divider hung latrine and sink to save space.
    real silk sheets

    ReplyDelete
  57. Dolls house furniture arrives in an assortment of shapes and sizes and it is made so as to take after genuine furniture however on a more limited sizemélybölcsős fuvarozás Europa-Road Kft.

    ReplyDelete
  58. These kinds of bed sheets are accessible from modest rates to costly assortments that will give extreme extravagance.real silk sheets

    ReplyDelete
  59. Out of those thirty just one of them was amateurish and surprisingly indeed inconsiderate to me on the telephone. windsor glendale galleria

    ReplyDelete
  60. Land organizing is fundamental in a wide open market. There are an excessive number of homes available to browse. Silk Beddings

    ReplyDelete
  61. After everybody consents to the agreement and it is acknowledged, there is still a great deal of work to do. Your representative keeps on aiding you through this interaction. The real estate professional ensures the fundamental advances are taken, for example, finishing the credit, evaluations, home investigations, dampness assessments, termite examinations, playing out a title search, last stroll through, deed planning, shutting, and so forth. reformas integrales zaragoza

    ReplyDelete
  62. Property Staging gives a strategic advantage over different homes available. pintor en zaragoza

    ReplyDelete
  63. A quality stager keeps on remaining instructed with the most recent plan patterns and land showcasing methods and will execute these strategies when organizing. arquitectos en zaragoza

    ReplyDelete
  64. From vehicle sales reps, to protection deals, to the woman behind the scent counter in a retail chain.aire acondicionado en zaragoza

    ReplyDelete
  65. It depersonalizes a home which will eliminate the current home proprietor's character and cause the expected purchaser to feel more comfortable. driveway replacement richmond va

    ReplyDelete
  66. It gives the section or hall a "Amazing" factor when purchasers get through the entryway. empresa limpieza zaragoza

    ReplyDelete
  67. Property Staging gives an upper hand over different homes available.
    Victorian chandelier

    ReplyDelete
  68. Utilizing a home stager preceding starting a home flip can be extremely valuable since a home stager is prepared to search for the restorative subtleties in a property that need the most consideration. online furniture deals near me

    ReplyDelete
  69. It draws the eye away from the little imperfections in a home and cause to notice the positive elements of a home. против кърлежи

    ReplyDelete
  70. Lamps - To complement the urban and rural touch, a lamp is all you need to add to your list of decor pieces for your home. Buy traditional lamps and bring them in symphony with the contemporary look of the home. https://shuttlesky.in/

    ReplyDelete
  71. Because home arranging prescribes to the vender to take care of mementos and assets for arranging purposes, they are remained careful from anybody visiting the home.pintores zaragoza

    ReplyDelete
  72. A home stager can give a fair-minded assessment of the home that the homeowner can not give since he can become halfway thus recognizable to his own home.pintores en zaragoza

    ReplyDelete
  73. Homeowners your hands one of the main reports you can have before you buy a home! What each homeowner or potential homeowner totally has to know and comprehend is this, you as a homeowner have ALL the obligation to ensure your new home will work and be an energy effective home. Realtor Lynchburg VA

    ReplyDelete
  74. Remarkable blog! I have no words to praise, it has really allured me.
    UI agency

    ReplyDelete
  75. What's more teach on the best way to fit the bill for buying a home. long silk robe

    ReplyDelete
  76. It is a sandy grand shading that achieves a loose or nonpartisan mind-set. It is best matched with other heavenly shadings like dark or green.Silk bed sheets

    ReplyDelete
  77. Virtual house tours are additionally all around appreciated in light of connecting with additional items which the maker can consolidate on them.Captions, ambient sound, and even voice overs can be inserted for added data and to make the virtual tour really captivating. Silk bedding

    ReplyDelete
  78. Measurably, property organizing has brought about a higher selling cost on the grounds that the home sold quicker.Brisbane Plaster Pro

    ReplyDelete
  79. By keeping the fundamental components of the room straightforward it gives the valuable chance to zest the room up with vivid frill. For instance, your material, sheets, pillowcases and shades can have red or orange tones in their plan to brighten up the room.
    mens silk pajamas

    ReplyDelete
  80. Silkbedding4u.com offers top caliber, reasonable silk bedding items, for example, silk blankets, Silk bed sheets [http://www.silkbedding4u.com], and then some.
    Silk bedding

    ReplyDelete

  81. How about we investigate only a couple of the advantages of silk bedding and why it will transform you. mens silk pajamas

    ReplyDelete
  82. Things that could prompt significant deformities - a rooftop blazing release that could get greater, harmed downspouts that could cause reinforcement and water interruption, or a help pillar that was not tied in to the construction appropriately. residential roofing in duluth ga

    ReplyDelete
  83. It gives the section or anteroom a "Amazing" factor when purchasers get through the entryway. https://www.westseattlewindowcleaner.com/window-cleaning-faq-10-most-commonly-asked-questions

    ReplyDelete
  84. Autocrat is an excellent piece of software. We use it all the time at our interior and exterior painting company.

    ReplyDelete
  85. As a construction spotter, we observe Board Directors, Chairman, Presidents, CEOs, COOs, CFOs and the senior officials who report to them. Roofing Contractor near me

    ReplyDelete
  86. Ejaculation is the expulsion of semen from the body. Premature ejaculation (PE) is when a man or his partner ejaculates as soon as possible during intercourse. PE is also known as rapid ejaculation, premature climax or early ejaculation. PE may not be a cause for concern. It can be frustrating if it makes sex less enjoyable and affects the relationship. If this happens often and causes problems, your healthcare provider can help. Here's information about the 조루증치료, more info read on to know.

    ReplyDelete
  87. These holders are of changing sizes for utilization for various purposes.
    The taste and kind of wines will improve to a fantastic degree whenever put away for a very long time, and Wine Racks render you extraordinary assistance in doing as such. antibacterial chopping boards

    ReplyDelete
  88. It is important that the designer of the process system be completely familiar with the action of each pump offered for a service in order that such items as control instruments and valves may be properly evaluated in the full knowledge of the system. plumbing services

    ReplyDelete
  89. If you want to be an emergency care physician, you need to take some steps first. First, you must choose which specialization you want to do. There are many types of physicians, but interns are the most common. They have completed a three-year residency program in internal medicine and have received extensive training in adult disease. Other specialty options include pediatricians, allergists / immunologists and general practitioners. Once you have chosen the specialty, you will usually seek board certification in that case. Read the full info here urgent care physician.

    ReplyDelete
  90. Though a lot of packaging companies are building high quality of Candle Packaging Boxes but the remarkable features and outstanding maAfter study a handful of the blog posts with your internet site now, we truly like your technique for blogging. I bookmarked it to my bookmark internet site list and are checking back soon.
    출장샵
    출장샵
    출장샵
    출장샵
    출장샵
    출장샵

    ReplyDelete