Student Lesson Plan Template


Student Lesson Plan Template will organize your lesson plans and guide you to achieve your objectives with effective planning!

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:

Lesson Schedule
Study Plan
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.
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