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.
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”