Ed Tech

The Magic Automatic Lesson Planner with Google Forms

Take the hassle out of lesson planning. Go digital. Make your plans searchable and shareable. Use Google Forms!

Take the hassle out of lesson planning. Go digital. Make your plans searchable and shareable. Use Google Forms!

Traditional lesson plan books have their limitations. Being paper-based, they’re not searchable and they’re not easily shareable.

Wouldn’t it be great to be able to search quickly for a specific lesson plan instead of flipping back page by page?

How about being able to share lesson plans with others without making photocopies?

You can use Google Forms to create a lesson planner that creates documents — automatically! — with all your plans in a format nicely designed by you!

Invest a bit of time now (I’m guessing +/- 30 minutes … just my best guess) and you’ll have a system that saves your lesson plans to your Drive that you can find easily later.

You’ll create a Google Form like this one (click here) where you’ll type up your lesson plans.

With the steps in this post, you’ll automatically create documents with all of your data like this (click here)!`

I published a post called “20 practical ways to use Google Forms in class, school”. My readers — by far! — clicked most often on the “lesson plans” option. This made me think, “Why not create specific instructions so everyone knows EXACTLY how to do this?”

Here it is … step-by-step instructions to add automation to your Googlized lesson plans:

1. Create a new Google Form (on a computer/Chromebook, go to Google Drive and use the “NEW” button … hover over “More” and choose Google Forms). Change the title/filename to whatever you’d like. (Something like “Lesson plan template”.)

add-questions2. Add questions using the circle “+” button to create places to add information to your form. This is how you’ll build your lesson planner. Some suggestions (and the type of question to use):

  • Date (date)
  • Class/period (dropdown)
  • Topic of lesson (short answer)
  • Lesson objectives (short answer or paragraph)
  • Standards addressed (checkboxes to select multiple, dropdown to select one) (You might include number and VERY short summaries of what each standard is for each one.)
  • Activities for the day (paragraph)
  • Assessment (short answer or paragraph)

3. Click the preview button (looks like an eye on computer/Chromebook) to make sure everything looks good. If so, fill your lesson plan template out once with some practice text (so you’ll have some data to work with) and submit it.

create-spreadsheet4. Go back to your Google Form. Click the “Responses” tab (it’s next to the “Questions” tab at the top). Click the green spreadsheet button to create a spreadsheet. In the window that pops up, choose to create a new spreadsheet. (If it doesn’t have a file name yet, you might want to create one so you can find it later!)

5. It will open the new spreadsheet for you, where you’ll see any lesson plan responses you’ve created. (Whenever you type up new lesson plans and click “submit,” they’ll come to this spreadsheet automatically too.)

6. Now that our lesson plan spreadsheet is set, let’s set up what the document will look like with all of your lesson plan information! Go back to Google Drive and create a new document. Design that document just like you’d like it to be. (Here’s an example … click here to see it … and don’t worry about all the <<>> stuff in the document yet.)

  • NOTE: If you’d like to be able to edit that document, please, please, PLEASE don’t click “Share” and ask for access to it. Instead, make your own copy of that document. Click File > Make a copy … and make changes to your own. To make life easier for everyone, I don’t grant access to these example files. (And you wouldn’t want to make changes to my copies of them anyway, right? 🙂 )

data-tags7. Now, let’s set the document up to have information inserted into it. In the example document above, you’ll see data tags that have << and >> around them. (If the term “data tags” scares you a little bit, don’t worry … be brave and keep going. They aren’t as scary as they sound. I promise! 🙂 )

For us to be able to bring in all of your lesson plan data, we have to know where to put all of that data. These data tags do it for us. The nice thing about them — you can make them whatever you want (I’d stick to regular alphabet letters to be safe, though). They just need to have << and >> around them.

8. Once your data tags are in place, it’s time to set this whole thing up so it will generate those awesome lesson plan documents for you! Go back to your results spreadsheet and click the “Add-ons” menu. Then click “Get add-ons …”. Search for “autoCrat” and click the blue “+ FREE” button next to it. You’ll need to grant it permissions to do its thing. (Don’t worry … it’s safe.)

9. When the autoCrat add-on is installed, do one of two things (they both do the same thing):

  • Click the red “New job” button on the window that pops up.
  • Click Add-ons > autoCrat > Open. Then click “New job”.

mapping-data-tagsGo through the step-by-step directions for autoCrat:

  • Step 1: Give it a name … something poetic like “lesson plan template”. Then click “Next.”
  • Step 2: Choose that document we created earlier as your template. Click the blue “From Drive” button and go find it. (Search for the file name if you have to.) Then click “Next.”
  • Step 3: autoCrat will identify all of your data tags from before. (Isn’t it smart???) Click all of the little drop-down menus next to “maps to column” to choose where it should get its data. (See image.) Then click “Next.”
  • Step 4: This is how autoCrat will name all of those lesson plan documents you want it to create. Two options here (see below). When done, click “Next”.
    • Make it the same every time (something like “My lesson plans”). BUT … you’ll have to go back and change them every time or you’ll end up with a million documents called “My lesson plans”. Not good.
    • Use your fancy data tags from your document to personalize each file name. My suggestion: use the data tags for the date and the class. Find the data tags by clicking the tall light-blue arrow bar on the left. It might look something like this: Lesson plans for <> for <> (Much better idea, right?)
  • Step 5: Choose a folder where your sparkly new lesson plan documents will go. Click “+ Choose Folder” and create a folder with a memorable name. “Lesson plans” will work! When you find it, just click it once and click the blue “Select” button. Then click “Next”.
  • Step 6 (OPTIONAL): This step is for dropping new lesson plan documents into different folders depending on the condition. If you really want to do this, check out this part of the autoCrat help document. Just click “Next.”
  • Step 7 (OPTIONAL): This step is also geekier than I’ll cover in this post. If you want to try it, check out this part of the autoCrat help document. Just click “Next.”
  • Step 8 (OPTIONAL): This step lets you share docs automatically as soon as they’re created. If you’d like to do that, click “Yes” and work through the next steps. You’ll determine who to share with by including their email addresses in the email template at the bottom. Whether you choose to do this or not, click “Next” at the bottom to move on.
  • Step 9: You’ll want to use this to create a new document every time you submit data through your lesson plan form. Click “Yes” for “Run on form trigger”. It will ask you to enable triggers … just say “Yes.” When you’re done, click “Save.”
  • Once you’re done, you can hover over your new job you just created and click the “play” button (triangle) to create documents for any data you’ve already submitted through the Google Form.

If you clicked that “play” button in autoCrat … Quick! Run to Google Drive and check your lesson plan folder. There will be a new lesson plan document in it!

Pretty snazzy, huh?

Now, every time you enter lesson plan data into your Google Form, autoCrat will create a document with all that information, sorted and presented neatly in that document you created.

(Note: autoCrat will automatically create those documents about every three hours or so by itself. If you want them immediately, you can go click that “play” button at the end of the autoCrat instructions above.)

Want to share specific lesson plans with colleagues or supervisors? Use the blue “Share” button in the top right of the document and share it with them … or share the whole folder with them!

Want to find lesson plans for a specific date or with a specific activity in them? Just search Google Drive for the document!

All lesson plans in one document

Autocrat creates separate documents for each lesson plan you create with the Google Form. I’ve had questions about putting all of those lesson plans together in one document.

After doing some digging, here’s what I’ve got …

  • There’s no easy way to merge multiple Google Docs into one single Google Doc (as of publication of this post). I found this article that says it can do it through Google Apps Script, but I wasn’t smart enough to figure out how to make it work.
  • autoCrat has two choices for creating documents — multiple documents and single document. The single document option doesn’t do what we’re trying to do. (At least as far as I could tell.)
  • There’s a really good tool called PDF Mergy that could help. It will take your PDFs and other files from Google Drive (or your computer) and merge them all together in a PDF file. It’s really easy to use and quick. The downside — merged PDF files can’t be edited. This could be good if you needed to turn your lesson plans in or if you wanted a permanent, finished file. (But what lesson plan is ever really permanent and finished?!?)
  • Another option is to reconsider whether you really need them all in one document. If your lesson plans are all in one folder, they’re grouped together that way. If you want others to be able to view or edit them, share the folder with them. Finding them in the folder is easy with the search box … just search for the lesson plan you’re looking for. (Which is faster than waiting for a big document to load and then scrolling through it.)
  • If you have multiple classes and want to keep them separate, create a different Google Form/Sheet/Doc for each class and dump the docs into different folders, keeping them separated.


[reminder]Having trouble? I’ll do my best to help you troubleshoot in the comments below. Have suggestions or changes? Let us know below![/reminder]

For notifications of new Ditch That Textbook content and helpful links:

Interested in having Matt present at your event or school? Contact him by e-mail!

Matt is scheduled to present at the following upcoming events:

[getnoticed-event-table scope=”upcoming” max=”15″ expanding=”false”]

A foolproof solution to tech breakdowns in class

Previous article

10 life hacking tips for educators

Next article

You may also like

Leave a reply

Your email address will not be published. Required fields are marked *