google sheets lesson plan template free

Lesson Planning with Google Sheets

Share this post:

Pinterest Hidden ImagePinterest Hidden ImagePinterest Hidden ImagePinterest Hidden Image

Waitโ€ฆ is this the best lesson plan template Iโ€™ve ever usedโ€ฆ? Maybe! Today, Iโ€™m sharing how I used Google Sheets to create a lesson plan template that rivals even my most beloved Planbook.com lesson plans! Best part? At the end of this post, you can grab a free template to try it for yourself!

google sheets lesson plan template

Google Sheets Lesson Plan Template

Okโ€ฆ so letโ€™s back up a second and first talk about how this genius idea even started.

Last spring, I had the opportunity to step back into the classroom as a long-term substitute in a 2nd-grade Dual Language classroom. Before starting her maternity leave, the teacher shared her lesson plans with me so I could easily just pick up right where she left off.

And the lesson plans she shared with me?

Google Sheets formatted!

At first, I was likeโ€ฆ whoaโ€ฆ Iโ€™m not into thisโ€ฆ Then, I started playing around with the template. I added a few extra columns and filled them with some color. As my time progressed, I started to really LOVE using them!

I knew it was something I HAD to share with you guysโ€ฆ so here we are!

Letโ€™s dive in!

Using Google Sheets as a Lesson Plan Template Video

More of a visual learner? Check out the video!

Oh, and be sure to subscribe to my channel while youโ€™re there!

Getting Started with Google Sheets Lesson Plans

Okโ€ฆ so letโ€™s get started with using Google Sheets as your lesson plan template.

First, youโ€™ll navigate to your Google Sheets app and create a new sheet. This will be the template youโ€™ll use to build your lesson plans.

To streamline things, Iโ€™ve made a FREE template that you can 100% customize to fit your needs! You can grab that at the end of this post!

But, if you want to start from scratchโ€ฆ hereโ€™s what youโ€™d do:

  1. Adjust the number of columns and rows youโ€™d like to include in your template. I like my days of the week across the top, plus one extra section for notes, so I have 6 columns. Then, create enough rows for your different sections of the day. You can do this by highlighting the cells youโ€™d like to delete, then right-click and select delete cells.
  2. From there, you can adjust the sizing of the rows and columns to fit the information that will be given. For example, in my sample, the header rows are pretty small, but the different sections vary.
  3. Now, highlight the given area and add grid lines if you like. This will give each box an outline on the online view as well as the printed view.
adding rows and columns in google sheets lesson plan template

Customizing Your Lesson Plan Template

Okโ€ฆ now that you have the base (or have downloaded the copy at the bottom of this post!), itโ€™s time to make it look cute!

Change the Font

Add some fun fonts to your template! Do this by finding the font section on the toolbar. Select the box or boxes youโ€™d like to have that font, then select the font from the choices.

adding custom fonts to Google Sheets Lesson plans

Donโ€™t like the font choices in your dropdown? Select โ€œmore fontsโ€ from the dropdown menu to explore even more Google (TM) font options, like Delius used in the template I created.

Add Color

Want to add your own colors to your lesson plans to make โ€œseeingโ€ the different sections a little easier on the eyes? Use the color selector tool (the paint can tipping over icon) to fill the box you select.

adding custom color to google sheets lesson plans
In the template, youโ€™ll see there are already some color options โ€œpreloadedโ€ loaded for you.

Fill with options there, or use the โ€œcustom colorsโ€ section to create new colors. You can even add your own preferred colors by typing in the hex code. (Just do a quick search of hex code colors and a ton of options to help you with this part will appear!)

Add More Tabs

Now that youโ€™ve got your template EXACTLY how youโ€™d like to use itโ€ฆ you can make copies of the sheet for each week/month that youโ€™re planning.

By selecting the down arrow on the sheet, youโ€™ll see more options, like duplicating or changing the name.

To do this, navigate to the bottom of the sheet where the tab is. Select the arrow icon to show more options. Select โ€œduplicate.โ€ This will duplicate the tab EXACTLY how it is set up. Perfect for keeping your original template looking nice! Use the same section to rename your tab to include what week or month is stored in the tab.

Typing in Your Lesson Plans

Now that youโ€™ve gotten your base set up exactly how you like itโ€ฆ itโ€™s time to start adding information. Google Sheets functions just like Excel sheets or a word document that has been gridded. You can add text to each box, and align the text to the center, left, or right.

One *little* annoyance I had when I first started using Google Sheets for lesson planning was the fact that when you press the enter key, it takes you to another cell instead of just the next line in the same cell.

You can sidestep this quirk by using holding down the โ€œshiftโ€ key while pressing enter. This will allow you to move to the next line within a cell. YEAH!

Searching Within Your Lesson Plans

A nice thing about using a word processing program like Word or PowerPoint to create lesson plans is the fact that you could search terms if you were looking for a specific theme or concept but couldnโ€™t remember which week you have placed it under.

You can do a search of terms within Google Sheets, too! Think of this as a quick way to look back at what you taught and when you did it, without always having to remember the exact week it was done.

To Search for Terms within Google Sheets

To search for a term, navigate to the top of your spreadsheet and find the โ€œeditโ€ part in the menu bar. Then, scroll to โ€œfind and replace.โ€ Type in the word you are searching for (for example, triple-digit addition). This function will search your entire sheet looking for this phrase. Once it is found, it will highlight the term, and youโ€™ll have an option to replace it with something else, but really now you know which week you taught it! YEAH!

Sharing Your Google Sheets Lesson Plans

One of the best parts of using Google Sheets as your lesson plan template is how easy it is to share. You can share just like you would a Google Doc or Google Slide; navigate to the left corner of the sheet and find the green โ€œshareโ€ button.

Select the button and adjust the share settings to fit your needs. I like to use โ€œaccess with linkโ€ and set them as a viewer. This will allow anyone I share the link with to see my lesson plans, but they wonโ€™t be able to edit them accidentally.

I know some principals require you to upload your file to a shared drive or database. You can do that easily with Google Sheets too!

Here are three ways you can share:

  1. Upload a word document to your folder and add your sharing link to the document. (Perfect if your school uses an onsight network drive-like โ€œi-drive.โ€)
  2. Download and save the week as a PDF and upload it to your sharing area.
  3. If your school uses Google Drive for sharing, you can just place your lesson plan spreadsheet into your folder.

Grab the Free Google Sheets Lesson Plan Template!

So thereโ€™s a quick crash course on how to use Google Sheets for your lesson plans. I know you are low on time and will def appreciate a leg up, so I created a simple template you can copy right to your Google Drive! This template is available in my Applicious Resource Library. Just sign up below to gain access!

More Great Ideas

Be sure to check out these other amazing ideas!

Hi, I'm Leigh.

The Applicious Teacher is all about creating hands-on and engaging lessons that align with the standards while still having time for your life. This is your place for ideas, tips, and resources for the REAL teacher!

Categories

Recent Posts

Popular in the Store