Created by:

Amanda C. Dykes

@amandacdykes

Use a Google Form to fill in your plans each week. This cuts back on time it takes to copy and paste standards and other changing information.

Setting Up You Google Form

Get Form Publisher & Set Up Your Template with Tags

Creating the Merge and Email/Share Your Completed Plans

Link to share this document is

http://bit.ly/formtolessonplan

Only share using this link.

Link to tagged example.

http://bit.ly/lessonwithtags

Link to forced copy sample form. http://bit.ly/formforlessonplan

Note: This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Step 1:

In Drive click the “new”

button then “Forms”

Created by:

Amanda C. Dykes

@amandacdykes

Step 2:

Name the Form and copy/paste the questions from the already created template.

Step 3:

Make the standards, materials,

and/or other sections that

have the same answers each

week checklist so you can

choose the ones you need. If

you have a PDF of these, they

will copy/paste.

Step 5:

Send the responses to a Google Sheet. Click the green Sheet icon. Click create in the new window.

Created by:

Amanda C. Dykes

@amandacdykes

Step 4:

If you have checkboxes on the

Template, make a checkbox with

an “X” as the answer.

Step 1:

Get add on by going to the menu

(three dots) and choose

Add-ons. Search for Form

Publisher. Click “+ Free”

Created by:

Amanda C. Dykes

@amandacdykes

Step 2:

Now click the “Add-On” icon then click “Form Publisher.”

Step 3:

Click “Get Started”

Step 4: Choose to

turn submission

to a Doc

Step 5:

It will generate you a Doc. Click

Edit My Template

Created by:

Amanda C. Dykes

@amandacdykes

Step 6:

This will open a Google Doc with all the questions and “tags.” Tags or markers are the words inside of << >>.

Step 7:

Copy the first tag that is for a section of lesson plan template.

Step 8:

Paste it where you want

the answer from the form

to go. You can add to it or

change the font. **Note the area may expand but will go back when merge runs.**

Step 5:

It will

generate

you a Doc.

Click Edit

My Template

Created by:

Amanda C. Dykes

@amandacdykes

Step 6:

This will open a Google Doc with all the questions and “tags.” Tags or markers are the words inside of << >>. Copy the first tag that is for a section of lesson plan template.

Step 8:

Paste tags where you want the answer from the

form to go. You can add to it or change the font.

**Note the area may expand but will go back when merge runs.**

Step 1:

Go back to the Form and Form Publisher. Click the edit icon (pencil) above the link to the template.

Created by:

Amanda C. Dykes

@amandacdykes

Step 2:

Choose the doc template you completed from the tags in your Google Drive.

Step 3:

The name of the template should now be your created one. Click next.

Step 4:

Create a folder in Google Drive for

your lessons to go. Find it like you

did above for template.

Step 5:

Choose how your lessons will be named. You can use tags. I always put the date tag.

Created by:

Amanda C. Dykes

@amandacdykes

Step 6:

Click you want to save the URL in the spreadsheet.

Step 7:

Add email address of whoever you

need to send a copy to. Choose

pencil icon if they can edit, eye icon

if you want to only give viewing

rights. Click ADD.

Step 8:

Set up your email that will be sent when

you submit the form. Click “email settings”

then “edit email.”

Created by:

Amanda C. Dykes

@amandacdykes

Step 9:

Write the email that you want sent with the lessons and give it a subject. You can use tags from the form. Save and Close.

Step 10:

Click

“done”

Create a Form that Feeds into a Lesson Plan Template - Google Slides