Teaching in Hindsight | Excel Planning Tool

This Geeky Tangent Teaching in Hindsight

If you’ve been reading for a while, you’ll know that I’m no longer teaching in Korea. If you haven’t, you’ll be finding out the in’s and out’s soon enough. That said, teaching is absolutely going to remain a part of TGT. There was so much I didn’t get to create, and I have so many more ideas tucked away that deserve to be given some sort of life, starting with today’s post.

I like to be organised, but find that paper doesn’t always suit as the material of choice. I dabbled with creating an excel planning tool a few years back, and then didn’t really make much use of it. I’ve now simplified it down, tweaked it a bit, and I’m providing you guys with the bones that will, I hope, allow for all sorts of customisation.

I’ve included a “How to…” in the excel file (find the download below):

Screen Shot 2019-05-13 at 9.00.45 PM

This will take you through how I would have used the planning tool.

You’ll notice there are only four tabs for specific grades. I dabbled with creating more, and auto-populating cells, but as everyone plans differently – never mind the “Korean surprises” that used to come out of nowhere and knock the schedule completely off balance. I figured it was best to stick with the basics – all you have to do is duplicate the tabs!

Let’s take a closer look. First, we have the six-week overview. 6 weeks, 4 classes a day, populate as necessary so you can see, at a glance, what your weeks are going to look like.

Screen Shot 2019-05-13 at 9.01.38 PM

Next up, we have the individual lesson plans, colour coded for grades 3-6. As I’ve said, I’ve only done one for each. This was the lesson plan layout I used for all my open classes and remains my favourite.

I didn’t have to make lesson plans all the time, and so would have predominantly used the overview, however if you take the time to fill out and maintain the six-week overview, then it will be easy to create a lesson plan from that whenever required.

Screen Shot 2019-05-13 at 9.02.09 PM

Lastly, the neatest bit of all, I set the print area of the lesson plan tabs so that when you press print, it fits your plan onto a sheet of A4 paper!

Screen Shot 2019-05-13 at 9.02.21 PM

I hope this makes the act of lesson planning easier for you, and I really wish I’d got my act together sooner and had this to hand when I was still teaching – it would have made life a breeze!


Elementary School Planning Tool


If you would like to support TGT, head over to my Kofi:

 Buy Me a Coffee at ko-fi.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.