skip to Main Content

Teacher Lesson Plan Template

5.0 (4 reviews)

Excel Teacher Lesson Plan Template is a free lesson planner that allows you to organize your students and lessons with nice visuals!

Buy Modifiable Version

TEMPLATE DETAILS
License: Personal Use
Works on: Windows / Mac
Requirements: Min. Excel 2007

Watch Video:
PRODUCT DESCRIPTION

This Excel Lesson Plan Template is designed to help the ultimate helpers: the teachers around the world. Gone are the days where you had to write everything down on a notebook, or even worse on pieces of paper! Gone are the days when you had to browse through your entire notebook or a number of notebooks to find data about a specific student! And gone are the days when you had different registers for different purposes!

Teacher Lesson Plan Template will help teachers plan their work, keep records and track the progress of each student. This solution will make it easier to focus on lesson content rather than writing a lot of paperwork or trying to find data.

Teacher Lesson Plan Template Features:

The template has 6 main sections in it:

  • Dashboard
  • Attendance
  • Daily Lesson Plan
  • Weekly Lesson Plan
  • Homework
  • Exam Results

Now, we will dive into each of them:

Dashboard

In the dashboard, you can insert the names of students and a list of subjects/lessons/classes taught.

This is the first step for successful use of this tool, and you only need to update this info in this page. The other pages will then get student names and lessons from the dashboard. Besides that, exam results or averages are dynamically connected and will update when other pages are updated with information.

Teacher-Lesson-Plan-Template-S01-Dashboard

With a dropdown menu below the lesson list, you will switch between students and see their exam details.

Teacher-Lesson-Plan-Template-S02-Dropdown

If you want to see detailed information about a student again in the dashboard, you can visit individual student pages with a “GO” link appear next to it. Because, this button will take you to the individual page, where you can see detailed stats, graphs, and can also keep notes for the student.

Teacher-Lesson-Plan-Template-S03-Student Page

Attendance

In the attendance menu, you can choose the current month and update the attendance daily, with four options possible. As the attendance is updated, important statistics will show up on the right side as well as on the main menu for each student.

Attendance-Sheet-S04

You can also use this template to create daily and weekly teaching plans.

Daily Lesson Plan 

In the daily lesson plan, you can choose the subjects, and then insert topics that you have to teach on that specific day. Furthermore, you can later update the status of each topic to see the completion rate for the day and get a visual representation.

Daily-S05

Weekly Lesson Plan

Weekly lesson plan template provides 1-5 topics to write for each subject on each of the days of the week. You will see an overview of the total number of topics you have to teach during the week.

Weekly-Plan-S06

Homework / Exam Results:

In the exams sheet, you have three columns for each subject/lesson, where you can insert the results of 3 different exams or quizzes.  This information will appear in all other related pages.

Exam-Results-S07

The homework sheet is similar to the exams one. You can insert 3 different homework results for each subject or lesson.

Teacher Lesson Plan Template Features Summary:

  • Well-organized plan for each lesson
  • Daily and Weekly Lesson Plan Template
  • Visualized student tracking for teachers
  • Clear on-sheet instructions
  • Easy to use and nice design
  • Works on both Windows and Mac
  • Compatible with Excel 2007 and later versions.
  • No installation needed. Ready to use

This Teacher Lesson Planner is ready-to-use Excel Template and provided as is. If you need customization on your reports or need more complex templates, please refer to our custom services.

USER REVIEWS

4 reviews for Teacher Lesson Plan Template

  1. rachellee

    Doing great! it is very helpful for the teacher with little or just basic understanding of Excel!!

  2. greg

    I love everything about this template!

  3. 1suncorey

    EXCELLENT TOOL!!!! EXCELLENT SUPPORT THX!!!!!!!!!!!!!!!!

  4. Qian

    Wonderful & professional study plan, and it shows how much hard work these guys have put into it

Leave a customer review

Your email address will not be published. Required fields are marked *