Lesson Plan Map

Every July when I was a teacher, anticipation would begin to bubble up inside me with the start of the new school year just weeks away. This usually was invoked by the sights and sounds of back-to-school sales. Nothing got me more excited than the dollar deals at Target and Walmart, not to mention the penny deals at Staples. Oh how Staples misses my business.

In addition to my fetish for new school supplies each year, I was also addicted to meticulously planning out the next school year. This interest was usually sparked by summer workshops/trainings I was fortunate enough to attend. These activities always got my brain spinning on ideas of new activities, instructional techniques and the sequence of the curriculum. You would think not much would change from the year before; however, in all of my 10 years of teaching, I only once experienced back-to-back years where the courses I taught and the curriculum I used remained constant. All other years, I basically had to recalibrate my brain and my resources based around the grade and course I was going to teach. This included a curriculum map for the entire year. I would start with a blank printed copy of each month, and I would then pencil in the mathematics standard, objective, and even the chapters/sections in the textbook, along with all known activities I could use to teach that objective. This was not something I completed in a few days. This usually took me the better part of 2 weeks per course that I taught to complete, keeping a separate file per course.

Keep in mind, this regimen was largely due to my OCD tendencies, but in the end, it sure did make for an easy year. With that said, I won’t lie. I was never able to stick to it exactly, but it served as a road map for the year and kept me focus on what needed to be accomplished. After about year 7, I began to construct this file using Word, strictly for the purpose of sharing with fellow teachers. When I taught in South Carolina, it was a requirement to submit typed lesson plans each week, and post these to our website each week for parents and students to access. Looking back now, and after becoming an avid user of google docs, I really wish I had created a “one-stop-shop” for anything dealing with my lessons. This would include notes, activities, and assignments. Of course, it’s not until I stop teaching that I thought of this and have the time to create an excel file, in conjunction with google docs, to accomplish this task. Funny how things happen.

The file Excel Lesson Link is a template to use to map out your curriculum for the year. This file is actually accessed via my google docs page, as a shared file, hyperlinked within this file. In the Excel Lesson Link file are two other files that are linked to my google docs page that illustrate the capabilities of the file. One is a lesson plan and the other is an activity I used with my algebra students, already link to this blog. When you create your weekly lesson plans, all you have to do is upload them to your google docs page, as a shared document (anyone who has the link can view), and copy the link into the excel file as a hyperlink. In the excel file, clicking on “Insert” and then “Hyperlink” will allow for you to choose the text that displays in the file for the link you are sharing. You can attach all the files you need for each week, or per day, in the colored portion of each day on the calendar. The white section for each day can be used as the descriptors and content information, like the standard and objective and the textbook information. This document can be used in any capacity you so desire. Keep in mind, the goal of this file is to have it act as your one-stop-shop file. You could access it from any computer and pull up the files you need for your lesson. In addition, files and information is so much easier to share with fellow teachers, parents and students.

A few notes about goggle documents:

Google documents is a tool within gmail. If you do not have gmail, you would need to create an account. There may be another functionality out there similar to google docs that I’m not aware of. I will only speak of what I know for this post’s purpose.

I would create a structure of file categories and names per your class structure before uploading any files. This may consist of a main file of let’s say, “8th Grade Math”. Then I might break it up into chapters or content areas, class periods, or maybe even semesters or 9 weeks categories. The number of files uploaded may be very high, so creating subcategories will be very helpful for when you need to find a file. Creating the shell of an outline will prove to be very helpful in the end. Be sure that you “share” each file, requiring the link in order for a person to access the file. I would not make any of your files public. Lastly, it is in your best interest to pdf you’re the file before you post it. Otherwise, your files may be altered without your permission. That’s just not a situation you want to find yourself in.

I hope this resource helps you get organized for the year, if not for anyone but for yourself. If you’re unfamiliar with google documents, please play around with this before trying to utilize the excel file. It IS a great resource and DOES make your life easier. Like always, please feel free to contact me if you have any questions shannon.m.richards@gmail.com .I truly want to help make your teaching-life easier.

It’s always my pleasure!

Files for this post:

Lesson Plan Map Word File

Lesson_Plan_Map Pdf

Excel Lesson Link Excel 2007

Lesson Plan Map 97-2003  Excel 97-2003

Trackbacks are closed, but you can post a comment.


  • Brian Crawford  On July 4, 2011 at 3:52 am

    Great post and template! I agree that planning makes a huge difference… and if you can create repeatable plans, you can carry them out through multiple years, and tweak them every year to suit possible changes or improvements. I also agree that it adds pressure if you try to stick to the plan exactly… as you move through the year there will undoubtedly be places where you’ll want to veer off, or spend a little more time on some subjects and less on other subject.

    If you have any other thoughts about project management for education, be sure to post them – you have some good insight!

    All the best –

  • shannonrichards  On July 4, 2011 at 11:04 am

    Thank you Brian! You’re so kind!
    You’re right that it is impossible to stay perfectly on target, down to the day, with the plan that has been created. Every year is different; every group of students is different. The dynamics of the class is simply a variable in this plan that cannot be taken into account during the planning stages of the lesson plan map. In some cases, it was planned to use x number of days on a particular concept, but this group of students showed mastery of this concept in x-3 days. I recommend adding to and adjusting this plan throughout the year, and use the lesson plan map as a working document, not as a stagnant reference.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: