Softwiro
Free Excel template

Weekly study routine in Excel (free): plan each day and compare with what you actually studied

Plan study blocks by subject and minutes, log what you studied, and see which subject fell short and how many hours you did this week.

4 min read

You want to know how many hours you really studied this week, and which subject got less time than you planned. The free weekly study routine sheet does that: you plan each day, log what you studied, and the gap between plan and reality comes out by itself.

The problem

Many students write a nice timetable and then cannot say where the week went. The timetable says "maths, an hour and a half", but nobody logged how much of it happened, so the shortfall shows up days before the exam.

How it works

  • In Subjects enter each subject and its weekly target in hours.
  • In Settings enter the first day of the week and the minimum completion rate, for example 0.8 for 80%.
  • In Schedule log each block: date, subject and planned minutes. The weekday appears automatically.
  • After studying enter the actual minutes and pick "yes" under done if you finished the block.
  • Weekly summary shows each subject's planned and actual hours, completion rate and gap to target, and each day's planned and actual minutes.

How the numbers are worked out

  • Hours = total minutes ÷ 60 for blocks that fall in the seven days from the start date.
  • Completion = actual hours ÷ planned hours.
  • Gap to target = actual hours − the subject's weekly target.
  • Status: "below plan" when actual is under the minimum share of planned, "below target" when you met the plan but not the target, otherwise "on track".

Open the sheet at /ar/templates/weekly-study-routine. It holds 15 subjects and 1,000 study blocks.

Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

Cheat sheet: weekly study routine (1/3)Cheat sheet: weekly study routine (2/3)Cheat sheet: weekly study routine (3/3)
0 downloads · 3 pages

Questions this raises

How do I make a weekly study routine in Excel?

Enter your subjects and a weekly target in hours, log each block with date, subject and planned minutes, and enter the actual minutes after studying. The sheet works out hours per subject and completion.

How is it different from the study planner sheet?

The study planner tracks lessons, their status and your scores before an exam. This sheet tracks the time you spend on each subject every week.

Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project