M-5
Summer Institute | Session DescriptionAutocrat is an add-on for Google Sheets that is similar to an old-fashioned mail merge. This time-saving tool can help you personalize your classroom and streamline communications. Learn about what it can do for you, and how to set it up! Learner OutcomesBy the end of the sessions participants will know / be able to:
Activity 1: Fill out the Digital SurveyFill out the survey below. When you are done, we are going to show you how Autocrat works. It will be fast, but you'll get step by step directions ASAP. Autocrat Information SessionAutocrat Information Session Activity 2: Create digital student surveyThis activity will walk participants on how to digitize their beginning of the year survey so they can collect contact information directly from your students. Feel free to take this one and modify it for your own needs: https://docs.google.com/a/mgsd.k12.nc.us/forms/d/1TG4m38BD8Okj5rdhYTGgQi80SEt4YufQsqsfApRScB4/copy Activity 3: Create sample master google doc for autocratParticipants will copy and create a document that better suits their needs as teachers. Teachers will be able to understand how tags work and how to make them work with forms and spreadsheets. You can create a new one or modify one this one Activity 4: Walk through a step by step instruction on doing an autocrat mergeFacilitators will walk participants through step-by-step directions to create their own mail-merge document. We will do this twice and monitor so participants are following along. Acceleration Activity: Other templates and e-mailing reportsFacilitators will showcase other uses for Autocrat in the classroom. They will also discuss other Add-ons if the participants have mastered Autocrat. Using Autocrat to persona...sentations, images, etc.) Recommended LinksUsing Autocrat to persona...Links to Share on Website |