Lesson Plan Template

ttpictiny

This awesome template lets you enter, share, and publish your lesson plans using – yes, that’s right – a Google sheet!


Using the Template

  Lesson Plans Template

  1. Click the link above. You should be “asked” to make a copy.
    Note – If your computer skips this step and takes you directly into the spreadsheet, just pull down the File menu to Make a Copy.
  2. Click the “Add/Edit Lesson Plans” tab at the bottom of the page to enter your plans.
  3. Click the “View Week” tab and enter Monday’s data to view only the current week.

Overview

  1. Enter your entire year’s lesson plans on the “Add/Edit Lesson Plans” sheet.
    Optional – Collaborate with another teacher by sharing the spreadsheet.
  2. Enter Monday’s date on the “View Week” sheet to view only the current week’s lesson plans.
    Optional – Publish the “View Week” sheet as a webpage to be viewed by admin, parents, and students.

Detailed Lesson Plan Instructions

Getting Started:

  1. Click the “Enter/Edit Plans” tab at the bottom of the page.
  2. Change the subjects to your own.
  3. Enter the dates for the week.
    Important! Do NOT enter the Day of the Week. When you enter the date, the day will automatically appear!
    Tip! Start each week with Monday date, even if you don’t have school!
  4. Resize columns, change fonts, sizes, alignments, and colors, and add borders as desired.
    .

Collaborating with Another Teacher

Do you team-teach with someone else? Want to both enter lesson plans in this one document? Just use the sharing option to do that!

  1. Click the blue “Share” button at the upper right side of the page.
  2. Enter the other teacher’s email address and choose “Can edit.”.
    Note – the teacher must have a Google account.
  3. Click “Done.”
    .

Viewing  Current Week

  1. Click the “Week View” tab at the bottom of the page.
  2. Enter Monday’s date. This is ALL you need to enter!
  3.  The week’s will automatically fill in with the info from your “Add/Edit Plans” sheet!
  4. Change the colors, fonts, sizes, etc. as desired.

Publishing the Current Week
Want to make your lesson plans available to admin, parents, and/or students? You can turn your “Week View” sheet into a web page!

  1. Pull down the File menu to “Publish to the web.”
  2. Choose to publish the “Week View” as a web page.
  3. Click the “Publish” button.
    .
  4. Copy the provided URL.
    .
  5. Provide the URL to others.
    a. Link to it from you blog, wiki, or webpage.
    b. Shorten the URL using goog.gl, bit.ly, or tinyurl.com (my favorite!).
    .
    c. Use goqr.me to embed the link into a QR code.
     Note – it is best to use a URL shortener first!
  6. Whatever is showing on the “Week View” sheet will be published for others to see. As you change Monday’s date, the published web page will automatically re-publish and stay up-to-date!

Other Tips and Tricks

  • In the “Add/Edit Lesson Plans” sheet, hide rows to make the view more compact.
    Select the desired rows, right-click, and choose “Hide rows…”
    .
  • Use copy/paste/character to add fun characters to your lesson plans. ✿☆✄
  • Feel free to adapt the template to fit your own needs!

Please enter any questions or comments in the provided area below.


 

 

Comments

  1. Brad Nikunen says:

    Hi Tammy…..I adapted your old one that I got from you several years ago….love it. BUT….I want to use this one, and need to add subjects. They don’t appear on the week view when I add them. Is there a quick and easy way to add more subjects? Thanks for this great resource.

    • Hi Brad,

      You’ll need to “tweak” the formulas to make additional subjects appear:

      1. Go to the “Week View” sheet.
      2. Locate the header for column R. Click one of the triangles beside it to expand the hidden columns.
      3. Double-click cell U5 to reveal the formula: =if(E5=””,””, filter(‘Add/Edit Lesson Plans’!F:M,’Add/Edit Lesson Plans’!E:E=E5))
      4. In the middle of that formula, you’ll see “F:M”. Change the “M” to the desired column. If you need to show two additional subjects, the range would be F:O instead of F:M. If you need three more subjects, it would be F:P.
      5. Repeat step for for cells U6, U7, U8, and U9.

      Note – If you need to need more than 4 additional subjects, you will need to insert some more columns in the Week View sheet. Let me know if you need more help with this.

      I hope this helps!

      – Tammy

  2. ProfeSteiner says:

    Thank you so much Tammy for the great lesson plan template! I also saw that you were presenting at TCEA in Austin this Feburary and am VERY excited to hopefully attend some of your sessions!!!!
    Thanks again for sharing your knowledge and helping teachers become better!

  3. Hi Tammy,
    Thank you so much for sharing this template! I am excited to use it this year! On your example I like how you put Labor Day going across the whole row. Can you teach me how to do that?
    Thank you!

  4. Jaime Miller says:

    What a great idea! I’ve been looking for a way to do my lesson plans on the computer, but don’t have budget money to pay for a service. I will definitely try this. I love that I can share them with parents and only have to enter my plans once! Thanks, Tammy!

Leave a Reply to Brad Nikunen Cancel reply

*


3 + two =