• Blog
  • About
  • Digital Portfolio
  • Presentations
    • Ontario Summit 2019
    • Petaluma iOS Summit >
      • You Can Explain Everything and Your Students Can, Too!
      • Getting Going with Google Classroom
      • Capturing Student Ideas with Visual Apps
    • ISTE15 >
      • Connecting the Next Digital Leaders
      • Hacking the Daily 5
      • Passion-Based Learning: Genius Hour, 20% Time, and Innovation Day
    • DENapalooza Vancouver 2015
    • PITA15 Whistler >
      • Passion-Based Learning: Genius Hour & 20% Time
      • Screencasting for Visible Thinking & Learning
    • CUE15 >
      • Hacking the Daily 5 - Rockstar Jam Session
      • Digital Citizenship for the 21st-Century Citizen
    • Odyssey15
    • iOS Summit Vancouver 2015
    • 2014 Presentations >
      • ERAC IL4K12
      • CUEBC14 >
        • Learn How To Drive: Storage & Collaboration in the Cloud
        • SAMR: A Technology Integration Model for Educators
      • SFU14
      • Union SD Tech Innovation Summit
      • CUE Rockstar Manhattan Beach 2014 >
        • Learn How To Drive
        • Screencasting for Visible Thinking and Learning
        • Hacking the Daily 5
      • CA GAFESummit 2014 >
        • Learn How To Drive
        • SAMR: A Technology Integration Model for Educators
        • Passion-Based Learning
      • JET14
      • MERITCon14
      • ISTE 2014
      • CanFlip14 >
        • Screencasting for Visible Thinking & Learning
        • Passion-Based Learning
      • Vancouver GAFESummit 2014 >
        • Learn How to Drive
        • Passion-Based Learning
      • Walnut Grove - Genius Hour in Elementary
      • Odyssey 2014 >
        • SAMR: A Technology Integration Model for Educators
        • Explain Everything! Practical Uses and How-Tos for Screencasting on Your iPad
        • So You Want to Mystery Skype?
      • Roseville GAFESummit - Passion-Based Learning
  • Contact
A Tech Teacher on a Mission

Automating Edcamp with Google Add-ons, Part 3: Autocrat

5/25/2015

23 Comments

 
Picture


This is the final part to a three part post (and the coolest of them all, IMHO) detailing how we used Google Add-ons to make organizing easier for Edcamp35. The first post outlined how to use FormMule for confirmation emails and email updates and the second post gave an overview for using DocAppender to filter specific information from those who were willing to facilitate a session.

Add-on #3: Autocrat

Picture
Basic Add-On Description: Autocrat takes the data from a Google Sheet and renders it into an easier-to-read Google Doc or .pdf format. Additionally, you have the ability to customize the file name, type, destination folder in Drive, and you can even customize a mail merge with the documents attached! Again, this add-on for Sheets is written by the still-ever-amazing-and-awesome Andrew Stillman. (Fangirl, much? Yes. Just, yes.)


Add-on’s Function for EdCamp35: This particular workflow is my favourite use of edcamp add-on awesomeness, mainly because it allows for collaboration of your edcamp attendees. The purpose of this add-on is to automatically create collaborative session documents as the session board schedule is being finalized. Each document would be automatically created and filtered into a publicly shared folder (all documents inside would automatically inherit the folder’s sharing permissions). This way, all attendees can use the folder link to locate their session and the corresponding collaborative Google Doc to take notes on. Even better, you have a window into sessions that you were unable to attend, and to share with others later on, too!

Basic How-To:

Step 1: Create a template for what you would like your session documents would look like. This year’s version looked the one below (and you can snag your own copy on Drive if you click on the image):
Picture
Step 2: Create a publicly editable folder in Drive where you’d like to keep the collaborative edcamp Docs. You can also create sub-folders inside of it for each session time slot that would run within your edcamp. If you make a folder for each session, it makes for easier for attendees to find the session title that they may be looking for.
Picture
Step 3: In a different folder (for us, it was our Edcamp35 organizing folder) create a new Google Form with questions just like the ones pictured below. Add any other fields you think you might need… remember to collect everything you'll require to fill in your template doc’s fields. Here is a link to our form or take a look by clicking below.

Picture
Step 4: Backing up now.... on our template document, you may have noticed these strange tags: <<Room Number>>, <<Session Name>>, etc. These are called merge tags. Wherever you add them in your template, Autocrat allow you to merge specific responses from the form into each doc that is created. For example, if I input “Genius Hour” into the form under Session Title, then I have made it so “Genius Hour” will now replace <<Session Name>> on the template document.

Now, it’s your turn! Go back to your template document and add merge tags that will correspond the data you input from your form. It’s nice to have the form and the template doc side by side (pictured below) to make it easier to correspond with one another before launching the add-on.
Picture
Step 5: On the Sheet that receives the form responses, I installed Autocrat in the “Add-ons” menu. Click on the “Launch” button in the menu and a sidebar will pop up for you to begin the use of the add-on. When the sidebar pops up, click "New Merge Job".
Picture

Picture
Note: This is the sheet that accepted our responses for the Edcamp35 2015. Your sheet should be empty - no data!
Step 6: A pop-up window will appear in your Sheet to set up the Autocrat add-on. Start by adding your template doc from Drive or by choosing a template in the document list below.
Picture

Picture
Step 7: Ensure that your merge tags correspond with the appropriate fields from your document. Some of your merge tags will automatically choose the corresponding entry from the form if they have the exact same name. Others, you will have to select from a drop-down menu.
Picture
Picture
Step 8: The merge settings step has a lot of little sub-steps. First, what will your merged documents be named? You can customize this using the naming tags listed on the next step of the add-on. All documents were titled a very specific way so that they would be easy to for attendees to see and for organizers to sort (see image below). Our nomenclature for merged docs was $sessionTitle - $Rm - $sessionNumber. So, for example, a session document would come out titled as the following:

Genius Hour for Beginners - Rm208 - 3

And it would also have matching information inside of the doc where the <<merge tags>> sit.

Why did we do this? The name of the sessions is the most important aspect for attendees, so that came first. The room number is secondary. The session number was for the organizers so that we put each document in the correct collaborative docs subfolder. Remember, we had Edcamp35 Session Docs named as a parent folder and subfolders for session 1, 2, or 3. The session number in the name makes it so we don’t have to open the documents one by one to see where they should live, or continually reference the session board to figure it out.
Picture
Step 9: Next, select “Email and/or share merged documents” and input your own email address (you need one; I just delete these notifications in my email later). I also ensure that it's shared as a publicly editable Google Doc, but… Google Nerd Note Reminder (as if all of this wasn’t enough already): If the destination folder is publicly editable, so will all the Docs be that are created within it. Secondary note: if you’re using Autocrat for a different purpose, you can also customize the email subject, address, and message, too!
Picture
Step 10: Click to expand the Advanced Options menu. This is where you can ensure that the Docs being created would land in your appropriate parent folder. Make sure that “Run autoCrat when new forms are submitted” is checked off before pressing “Save".
Picture

Picture
Step 11: Test out the magic by filling out your form. Check the merge folder you chose to see if the document merged. You should also see the evidence of a merge on the response spreadsheet - clickable links and a merge confirmation field.
Step 12: Delete any test documents you created and double check that your parent folder is shared to be publicly editable. Share the folder link on the morning of edcamp or before so that people can access it. For Edcamp35, we created shortened URLs for this as well as QR codes for participants to scan around the building to get connected with our collaborative documents.
Picture
Step 13: We repeatedly filled out the form with session titles and rooms on the day of the edcamp in a frenzy as the session board was being built. After the documents were merged into the parent folder, we had to drag and drop each session into its corresponding session subfolder. Note that this is best done in “List View” in Drive, not "Grid View”.
Picture
Each of these documents would get dragged and dropped into the appropriate session folder.
If you’re curious what the final structure might look like, check out our final merged products from Edcamp35 here. Some documents got edited by attendees during the conversations, others didn’t. But what we created was a shareable source of evidence of professional conversations that others could learn from. The coolest part? I learned from sessions I didn’t even attend, and so did many others! And it didn't really take that long to set up, either.

I really hope you enjoyed learning about Google Add-ons for Automating Edcamp from this series of blog posts. Thank you for planning amazing educational events (or being curious about it!) and being a part of growing professional practice through sharing and collaboration!
Picture
23 Comments
http://awriter.org/ link
8/12/2015 05:01:31 am

You always can publish something absorbing that does not waste minutes of your life like what you see on countless other sites. This is very interesting and I will be back for more. Thanks for sharing

Reply
vickya4n link
9/3/2016 12:48:53 am

Automating Edcamp with Google Add-ons, Part 3: Autocrat ... gave an overview for using DocAppender to filter specific information from those

Reply
top 3 best paper writing services link
7/25/2017 06:49:30 am

Stop doing magic you evil witches!

Reply
bosch top load washing machine link
8/9/2020 11:43:14 pm

Hurrah, that is the thing that I was searching for, what a material! present here at this site, thanks administrator of this site.

Reply
Bobby link
2/8/2021 07:46:14 pm

I enjoyed this post thanks for sharing

Reply
Here You Can Find 5-Star Umrah Packages link
7/15/2021 04:27:19 am

Hello, by utilizing Google I discovered your site even as chasing down a practically identical subject, your site came up, it looks truly intriguing. I bookmarked it.

Reply
THC free CBD oil link
7/29/2021 05:02:30 pm

Thank you for this very beneficial post. all the matters which you have referred to inside the article has thoroughly defined.

Reply
SSC CGL Free Test series link
9/26/2021 01:56:03 am

“Nice post. I learn something totally new and challenging on blogs I stumbleupon every day. It’s always helpful to read articles from other writers and use a little something from their web sites.

Reply
dog beds dubai link
10/20/2021 03:47:33 am

I really appreciate this post. I have been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thank you again! .

Reply
Empathy in Your Marketing Strategy link
12/22/2021 12:34:36 am

Very elegantly composed. This blog has every one of the necessary parts that I was searching for. The focuses are all around featured, expressing the genuine importance. Straightforward and read.

Reply
new technology in hotels link
12/22/2021 02:37:08 am

Posing inquiries are truly critical thing in case you are not understanding something totally, with the exception of this post offers great agreement yet.

Reply
Types of online shopping link
4/26/2022 02:27:24 am

I read this post your post so nice and very informative post thanks for sharing this post.

Reply
Buy Chipotle Sauce link
5/3/2022 04:50:40 am

This is very interesting, good job and thanks for sharing such a good blog.

Reply
Surface Pro 8 link
10/11/2022 05:23:16 am

I was intrigued accepting that you at whatever point imagined of changing the plan of your site? Its very much made I genuinely like what you've got to say. However, no doubt you might somewhat more in the technique for material at some point so individuals could get along with it better.

Reply
kitchen cabinet store link
10/17/2022 08:39:34 am

We improve our clients’ lives by enhancing their houses, giving them a place to relax, reconnect, and revitalize while feeling proud of their achievements and home. Stones and Cabinets City delights our customers and makes them proud of their houses by making the complex simple.

Reply
trucking transportation link
10/17/2022 08:41:49 am

We are keen on improving the quality of life for our drivers and their families by providing the best technology, higher pay, premium benefits, and ensuring efficient operations and load planning that lets them maximize their home life without sacrificing safety or income.

Reply
icell station link
10/17/2022 08:43:34 am

Knowledgeable and expert technicians at I-Cell Station identify your cell phone issues for free so that we can offer you the best possible solutions. We have expert-level solutions for all damaged cell phone devices, from screen replacements to charging ports and batteries, cameras speakers, back glass to motherboard level repairs.

Reply
shape reclaimed link
10/17/2022 08:45:27 am

Blogging refers to writing, photography, and other media that's self-published online. Blogging started as an opportunity for individuals to write diary-style entries, but it has since been incorporated into websites for many businesses.

Reply
pizza online order link
10/17/2022 08:47:13 am

At HFC Pizza & Subs we serve Pizza & Italian cuisine using only the freshest ingredients. You can also choose from our selection appetizers, salads, cheesesteaks, heros and much much more!!!!!

Reply
ecommerce SEO company houston link
11/16/2022 12:48:00 pm

eCommerce SEO Company Houston: Informatics Commerce is a trusted ecommerce SEO company houston helps businesses to provide quality ecommerce services to their customers.

Reply
What is Instagram Dark Mode link
11/18/2022 12:05:07 am

You should partake in a challenge for one of the greatest quality destinations on the web. I will suggest this site!

Reply
free seo analysis chicago link
12/20/2022 04:38:11 pm

Free SEO Analysis Chicago: Informatics IMS is a trsuted SEO firm helps many businesses by providing free seo analysis chicago in the USA.

Reply
hexun link
2/21/2023 12:06:06 pm

I simply need to say I'm all new to web journals and truly appreciated you're site page. Possible I'm probably going to bookmark your blog . You really have sublime elegantly composed articles. Credit for offering to us your site page.

Reply



Leave a Reply.

    Author

    Victoria Olson
    A curious and passionate educator in Langley, BC

    Picture

    Picture

    Picture

    Picture

    Picture

    Picture

    Tweets by @MsVictoriaOlson

    Picture

    Picture

    RSS Feed


    Archives

    April 2020
    March 2020
    February 2016
    January 2016
    August 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    October 2014
    September 2014
    July 2014
    May 2014
    April 2014
    March 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013


    Categories

    All
    Assessment
    Augmented Reality
    Balance
    Blogging
    Camtasia
    Collaboration
    Communication
    Community
    Creativity
    Design
    Edcamp
    #EdFailFwd
    Education
    Efficiency
    Elementary
    Google Teacher Academy
    Guided Math
    Intermediate
    Ipads
    Multi Age
    Multi-age
    Pln
    Primary
    Pro D
    Pro D
    Pro-D
    Reflection
    Resource
    Screencasting
    Self Regulation
    Sharing
    Tech
    Things That Suck
    Think35
    Twitter
    Video
    #YourEduStory


    Want to subscribe to this blog? Enter your email address below for automatic email updates:

    Enter your email address:

    Delivered by FeedBurner

Powered by Create your own unique website with customizable templates.