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!
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!
More of a visual learner? Check out the video!
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!
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.
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.
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.
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!)
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.
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.
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!
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 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!
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:
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!
Be sure to check out these other amazing ideas!
