skip to Main Content

Student Study Plan Excel Template

4.89 (9 reviews)

Well-organized study planner for students. Easily track your homework, exams, and much more. Printable lesson schedule included. All 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 with numerous homework. So you can not complete your lessons’ objectives properly. For that purpose, developing a routine and using a Student Study Plan Excel Template will make your learning journey clear with a well-organized study calendar template!

Student Study Excel Plan Template Features

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.


Study Plan 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 the Calendar column of study plan, you can input all your exam dates, projects, assignments, or other events. This handy tool reminds you how many days you have left until an exam, project, or any other study-related deadline.

Warning!: White cells on the study plan template 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 planner will help you to schedule your daily study sessions. You will simply select your lessons, write their study descriptions and then change their 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 on your study plan template, 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 the “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 in Study Plan Excel Template

The last section of the Student Study Plan Template is a homework planner. Similar to the previous 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
  • Informational notes included
  • No installation needed, ready-to-use
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions
  • Does not include any VBA code or macros

Student Study Plan is a 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.


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



9 reviews for Student Study Plan Excel 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.