Google Sheets Teacher Planbook

Create a Teacher Planbook using Sheets

Digital planbooks have gained popularity throughout the years as they allow educators to access, share and collaborate on their lesson plans from any device or location. Over the years, I have created my digital lesson plans using a variety of different Google Workspace applications including Slides, Calendar, and Docs. But, once I started using Google Sheets to organize my plans I have been incredibly satisfied with the results.

Why Google Sheets?

While most people primarily use Sheets to manipulate and share data, I have found a variety of innovative uses for the application including digital planbooks!

Sheets allows your to create and customize a template that may be duplicated each week as you complete your plans. You may color code Sheet tabs and also add dates, links, text, Emojis, and images to your planner. Educators may share and collaborate with colleagues, substitute teachers, or administrators while assigning editing permissions.

If you understand the basic functionalities of Sheets including how to add, hide and merge cells then it is easy to create a nice template for your lesson plans! Or, just try playing around with the one I created. Simply click here to make your own copy of my Google Sheets Planbook Template. Pro Tip: I use the Crop Sheet Addon to remove extra columns and rows.

Screenshot of Template (Click to Access)

Example Template created in Sheets (Click to access)

Video Tutorial

What application do you use to create your digital planbook?

Passionate about all things edtech.


Leave a Reply

%d bloggers like this: