skip to Main Content

Student Lesson Plan Template

4.89 (9 reviews)

Student Lesson Plan Template organizes your lesson plans and guides you to achieve objectives. Schedule lessons in study calendar – in Excel!

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



Lesson schedule, assignments, exams – you always need to know what should be done in a whole week and never miss important tasks. Sometimes planning may become really overwhelming in the midst of numerous homework. So you can not complete your lessons’ objectives properly. For that purpose, developing a routine and using a Student Lesson Plan will make your learning journey clear with well-organized study calendar template!


You will find 5 different sections in this template:

  • Dashboard
  • Lesson Schedule
  • Study Plan
  • Exams
  • Homework Projects

Now, let’s dive into each of them in detail.


Dashboard consists of your lessons, calendar, and your general score. This step is essential for the template to work smoothly in other sections.

Firstly you will input lesson names under the Subjects column. You can write up to 20 lesson names.


In Calendar column, you can input all your exam dates, projects, assignments or other events. This handy tool reminds you how many days you have left until exam, project or any other study related deadline.

Warning!: White cells are for your input. Gray cells are automatically calculated with formulas, so do not overwrite them!

Lesson Schedule

In this section, you can simply write your weekly class schedule with up to 8 subjects each day. The subjects can be chosen in a drop-down menu because you’ve already inserted the lessons on the dashboard/main menu.

Lesson-Plan-Template-Someka-02-Lesson Schedule

Furthermore, you can write notes about them if you need to.

Study Plan

A study plan will help you to schedule your daily study sessions. You will simply select your lessons, write their study descriptions and then change its status accordingly. So, you can decide on which day you are going to study a certain topic in this study calendar template. (Be sure that there is still time for social or physical activities in your schedule!)


After that, the lesson plan template will automatically calculate the daily study rate and the lesson study rate. For example, if your study rate is 50% or less, you will see the rate marked in red.


Your exam results are important indicators of your education life that you should never ignore. Here you can write the scores for your exams and/or projects for each lesson. If the exams and projects have a different weight on the final grade, you should also insert the weight of each. But if all scores are equally important for you, leave the weight column empty.


On the right side, there is a visualization of the scores for each lesson so you can select your lessons from “Choose Subject” drop-down above the chart.

The second chart shows you a comparison of the average score for each subject. It will dynamically update as you add or remove data in the exam table.

Homework & Projects

The last section of the Student Lesson Plan Template is a homework plan. Similar to the “Study Plan” section, you can choose a lesson, write the homework description, write the deadline and then change its status accordingly. After that, the tool brings you your completion rate for each subject.


You will see the red marked completion rate if you’ve done only 50% of your homework!


  • Well-organized study plan for each lesson
  • Lesson Study Calendar Template
  • Visualized performance tracking
  • 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 excel template is ready-to-use and provided as is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



9 reviews for Student Lesson Plan Template

  1. Jay

    Great help for an upcoming licensure exam. Thank you!

  2. Saraswati college

    GRATEFULL TO READ THIS ARTICLE I HOPE IT WILL WORK FOR ME TOO.I WILL EXECUTE THIS.this is very useful tips.thank you so much for your suggestions.Very good content for students, keep sharing and to know more click engineering college in navi mumbai

  3. NaRin

    This is the first time I’ve known your site and I really surprise, this site is very good!

  4. Hvdwht

    A complete geat resource!!

  5. ana

    What a great template. Very impressive

  6. alamgir

    such a great template customer support

  7. Davenport

    A complete wonderful resource!!

  8. zheng

    Such a great template
    Customer support is fantastic and quick
    Very versatile

  9. Bircan

    This template is impressive

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.