Study Planner Template for Excel and Google Sheets: Assignments, Weekly Study Hours and the Score You Need on the Final

A study planner template is a spreadsheet with four connected parts: an assignment tracker (course, task, due date, weight, status), a weekly plan that splits your available study hours across courses, a spaced-review schedule for each topic, and a grade calculator that shows where you stand and what you need on the final exam. Built in Excel or Google Sheets, it replaces sticky notes and memory with a single view of what is due next and how much each task actually matters.

This guide lives in Study & Student Planners. For everything outside school — work shifts, workouts, errands — pair it with the weekly planner template.

Part 1: Assignment tracker

The trick is to enter the whole semester on day one: copy every deadline and its weight from each syllabus. Sort by column C and the tracker becomes a timeline; sort by D and you see which tasks deserve the most effort.

Example, checked on November 6, 2026

The lab report is due soonest, but the history essay is worth almost seven times as much. Weight and days left together tell you where tonight’s hours should go.

Part 2: Weekly study hours by course

List your courses with a difficulty score from 1 (comfortable) to 3 (hard), put the hours you can realistically study each week in a cell (say H1), and split them:

=$H$1*B2/SUM($B$2:$B$6)

Many colleges quote a guideline of roughly two to three hours of study outside class for each credit hour. Treat that as a reference point, not a rule: your actual number depends on the course, your background and your schedule outside school. Then block those hours into specific days and times in a grid (days across, 30-minute slots down) and check the totals with =COUNTIF(Week!$B$2:$H$30,A2)*0.5.

Part 3: Spaced review dates

Reviewing material at increasing intervals helps it stick far better than one long session the night before. Log the date you first study each topic in column B of a “Topics” sheet and generate the reviews:

• Review 1: =B2+1
• Review 2: =B2+3
• Review 3: =B2+7
• Review 4: =B2+14

A conditional formatting rule =C2=TODAY() highlights what to review each morning. If a review date lands after the exam, pull it forward.

Part 4: Grade calculator — the score you need on the final

Enter each graded category with its weight and your average so far. Your current standing is the weighted average of what has been graded:

=SUMPRODUCT(Weights,Scores)/SUMIF(Scores,"<>",Weights)

The score you need on the remaining work to hit a target grade:

=(Target-SUMPRODUCT(Weights,Scores))/Final_weight

Worked example: Biology

• Current standing: 55.0 ÷ 0.65 = 84.6%.
• To finish with 87%: (87 − 55) ÷ 0.35 = 91.4 needed on the final.
• To finish with 83%: (83 − 55) ÷ 0.35 = 80.0 needed.
• To finish with 90%: (90 − 55) ÷ 0.35 = 100 — only a perfect final gets there.

The numbers make the trade-off concrete: an A is out of reach without a perfect exam, but a solid B+ is realistic with focused preparation. Letter-grade cutoffs and rounding rules vary by course, so use the scale in your own syllabus.

Common mistakes

• Planning hours you don’t have: a 40-hour study plan alongside a 25-hour job lasts about a week.
• Treating every task as equally important: weight should drive effort.
• Only tracking deadlines, not progress: mark tasks “In progress” so big projects don’t start the night before.
• Averaging percentages without weights: a 95 on homework worth 10% does not offset a 70 on an exam worth 40%.
• Skipping sleep — rest is part of how memory consolidates.

FAQ

Does this work in Google Sheets?

Yes. TODAY, SUMPRODUCT, SUMIF, COUNTIF and conditional formatting behave the same, and the sheet is easy to check on your phone.

Can I use it for high school?

Yes. Replace credit hours with class periods and use the grading weights your teacher publishes.

How do I track habits like reading every day?

Add them to the habit tracker template, and keep one-off errands such as “email professor” or “buy lab goggles” on a to-do list.

Next step: open every syllabus, enter all deadlines with their weights, set your weekly hours in H1 and block them into next week’s grid. More planners in Home, Family & Study Planners.