Free Student Planner Excel Template

Free Student Planner Excel Template

By the time midterms hit, most students are running their semester out of four different places — a class schedule photographed on their phone, assignment due dates scattered across a notes app, a rough GPA estimate they did once in September, and a study log that never actually got started. Nothing talks to anything else, so a missed assignment doesn't show up anywhere until it's already overdue.

The Free Student Planner Excel Template puts all of it in one workbook instead. It isn't a single checklist — it's six connected sheets built around one Settings sheet, so the course codes you type once (ENG101, MAT120, or whatever your own courses are) show up automatically in your class schedule, your assignment log, your grade tracker, and your dashboard. Change your grade scale in Settings, and every weighted grade and GPA figure in the workbook recalculates with it.

It's built entirely in Excel, with no macros or VBA to enable, no linked accounts, and no software to install. You open the file, fill in the yellow input cells, and the formulas already in place handle the weighted GPA math, the assignment status counts, and the study-hour comparisons for you. The workbook ships with a full set of fictional sample data — a student named Taylor Morgan, six sample courses, thirty sample assignments — so you can see exactly how the sheets connect before you clear it out and enter your own semester.

The sections below walk through what's actually in the file, sheet by sheet, and how to set it up for your own classes.

What This Template Helps You Do

• Build one weekly class schedule — The Class Schedule sheet holds a full weekly class grid by time slot, plus a course details table with instructor names, room numbers, meeting days, start/end times, and credit hours.
• Log and prioritize every assignment — The Assignment Tracker gives you one running list for every assignment across every course, with due dates, assignment type, priority level, and status (Not Started, In Progress, Completed, Submitted, Overdue).
• Calculate a weighted grade and semester GPA — The Grade Tracker turns individual assessment scores — quizzes, assignments, midterms, projects, final exams — into a weighted current grade per course, then rolls those into a credit-weighted semester GPA using the editable grade scale from Settings.
• Compare planned study time against actual study time — The Study Planner tracks weekly planned hours against actual logged hours, plus a session-by-session log with focus ratings and completion percentages.
• Review one connected Semester Dashboard — Instead of checking four sheets separately, the Semester Dashboard summarizes assignment completion, current GPA, weekly study goal attainment, and overdue items in one place — filterable by course or by month.
• Keep dropdown lists and categories consistent — Days, study types, study locations, assignment types, and assignment statuses are all pre-built dropdown lists in Settings, so formulas on other sheets match records correctly.
• Follow a month-by-month semester calendar — The Semester Dashboard's calendar overview breaks assignments due, completions, average score, and study hours out by month, so you can spot the heaviest month before you're in the middle of it.
• Start from a guided setup instead of a blank grid — The Start Here sheet lays out a five-step setup order, a color legend explaining which cells are safe to edit, and a short list of who the workbook is designed for.

What's Included in the Workbook

The workbook contains nine sheets, in this order:

How to Use the Template

• Step 1: Open the workbook and read Start Here — Skim the five-step setup order and the color legend before entering anything. Light-yellow cells are for input; white cells hold formulas you shouldn't overwrite.
• Step 2: Fill in your details on the Settings sheet — Enter your name, school, program, semester name, and semester dates. Check the grade scale against your school's grading policy, then replace the sample courses in the Course Directory with your own.
• Step 3: Build your weekly Class Schedule — Using the course codes you just set up, fill in the weekly class grid and complete the course details table.
• Step 4: Log every assignment as it's assigned — Add each assignment the day it's given, not the day it's due. Choose a status from the dropdown list rather than typing it freehand — that's what keeps the status-count formulas accurate.
• Step 5: Record scores in the Grade Tracker as work is graded — Enter each assessment's weight percentage and score percentage as grades come in. The course grade and GPA summary table updates automatically.
• Step 6: Plan and log sessions in the Study Planner — Set a weekly study goal in Settings, then log individual study sessions as you complete them.
• Step 7: Review the Semester Dashboard weekly — Use the course and month filters to check one course or one month at a time, and glance at the insights panel and overdue count.
• Step 8: Clear out the fictional sample data — Replace or delete the sample student, courses, and assignments once you're ready to enter your own semester.

Practical Example

The workbook's own sample data is a useful walkthrough on its own. It's set up for a student named Taylor Morgan at Riverside College, Summer 2026 semester, with a target GPA of 3.50 and a weekly study goal of 15 hours.

In the Grade Tracker, ENG101 (Academic Writing) has five graded categories: a quiz worth 10% of the grade, a written assignment worth 20%, a midterm worth 25%, a course project worth 20%, and a final exam worth 25%. With a quiz score of 82% and an assignment score of 82%, the sheet calculates a running weighted grade for the categories graded so far — it doesn't wait for every category to be filled in before showing a number.

Across all six sample courses, the Grade Tracker rolls those individual course grades into a credit-weighted semester GPA of 2.49 against the 3.50 target, visible on both the Grade Tracker and the Semester Dashboard without a second calculation.

Meanwhile, the Assignment Tracker shows 30 total assignments, 17 completed or submitted, and 7 overdue — a 56.7% completion rate. The Semester Dashboard's automated insights panel turns that into a plain-language note: current GPA is below target by 1.02 points, and 7 assignments need attention.

This example is only meant to show how the sheets work together. It isn't academic or admissions advice, and the numbers are the workbook's own sample data, not a real student's.

Understanding the Dashboard and Key Reports

Who This Template Is Best For

Who This Template May Not Be For

• Students who want automatic syncing with their school's LMS or grade portal — There's no connection to Canvas, Blackboard, or a school's grade system; every score and due date is entered manually.
• Students who need a mobile app or real-time cloud sync — This is a single Excel file, without a built-in cloud sync layer.
• Students who need their official GPA for admissions or transcripts — GPA and grade outputs are estimates based on the editable grade scale you enter, not an official institutional calculation. Confirm real GPA and grades with your school's registrar.
• Users who want VBA macros or advanced automation — The workbook is intentionally built without macros, so there's no auto-import or one-click automation beyond the built-in formulas.
• Anyone managing multiple students or multiple semesters in one file — The Settings sheet is built around one student and one semester at a time; tracking a second semester means saving a new copy.
• Students who need investment, tax, or financial planning tools — This is an academic planner; it doesn't include budgeting or financial tracking features.

Why This Template Is Different

A blank spreadsheet doesn't know what a course code is until you build the logic yourself. This workbook already has that logic in place: the Course Directory in Settings feeds the same course list into the Class Schedule, the Assignment Tracker, and the Grade Tracker, so you enter a course once and reference it everywhere else with a dropdown instead of retyping it.

The grade scale is editable rather than hardcoded — change the minimum-score thresholds in Settings and every weighted grade and GPA figure downstream recalculates against your school's actual scale instead of a generic one.

The Semester Dashboard doesn't hold its own separate data entry — every number on it is pulled from the Assignment Tracker, Grade Tracker, and Study Planner, so there's one place to update information and multiple places to review it.

And because the whole workbook is a plain .xlsx file with no VBA or macros, it opens without Excel's macro security warning and without needing anything enabled first.

What You Get in the Download

The download is a single ZIP folder with everything you need to get started right away:

• A ready-to-use Student Planner workbook (.xlsx) — pre-filled with the full sample semester (Taylor Morgan, six courses, thirty assignments) so you can see every sheet working together before you enter your own data.
• A blank starter template (.xltx) — the same nine sheets with the sample data cleared out, ready for you to fill in your own semester from a clean workbook.
• A short note file — a quick summary of what is in the download and where to go if you need something beyond the free version.

Practical Tips Before You Start

• Complete the Settings sheet fully before touching any other sheet — the course directory and grade scale are what make everything downstream work correctly.
• Use the same course code everywhere (ENG101, not "Eng 101" on one sheet and "ENG-101" on another) — formulas match on exact text.
• Only type into the light-yellow input cells. White cells hold formulas and will show incorrect results if overwritten.
• Clear or replace the fictional sample data before your first real week of use.
• Update assignment status as things happen, not in a batch at month-end — the overdue and completion-rate figures are only as current as your last update.
• Check your school's actual grading scale against the one in Settings before you rely on the GPA figure for anything important.
• Save a backup copy of the file before making large structural changes.
• Use the Semester Dashboard's course and month filters to review one thing at a time instead of scanning every table at once.
• Log study sessions right after they happen — hours estimated from memory later in the week tend to drift from what actually happened.
• Save a new copy of the workbook for each new semester rather than clearing and reusing the same file.

Common Mistakes to Avoid

• Typing dates as plain text instead of real dates — the due-date, days-remaining, and urgency formulas depend on actual date values.
• Overwriting formula cells — it's easy to type a number over a white output cell by accident. If a total or GPA figure suddenly looks static or wrong, check whether the formula is still there.
• "MAT120" on one sheet and "Math 120" on another will not match in lookups — using inconsistent course codes quietly breaks the connection between that course's data across sheets.
• Leaving fictional sample rows mixed in with real data — half-sample, half-real assignment logs throw off the completion-rate and average-score KPIs.
• Not updating the grade scale to match your school — the default scale is a reasonable general-purpose scale, not necessarily your institution's.
• Adding categories that aren't in the dropdown lists — typing a study type or status that isn't in the Settings dropdown can break the status-count formulas.
• Entering assessment weights that don't add up to 100% per course — the Grade Tracker's weighted grade calculation assumes the category weights sum to 100%.
• Waiting until an assignment is already overdue to log it — the Assignment Tracker is most useful as a running list you update as work is assigned.

Need a Custom or Premium Version?

This free download is the standard website version of the Student Planner. If you'd like a Premium version with additional features, or a professionally designed custom Excel or Google Sheets template built specifically around your own semester, course structure, or grading policy, we're happy to help.

Custom templates can be developed for personal, educational, business, financial, productivity, and other specialized needs. Share your query and details at quote@dothecalculation.com and we'll send you a quote for that work.

Limitations and Honest Notes

• This workbook is for planning and organization purposes only — it is not academic, admissions, or professional advice.
• GPA, grade, and study figures are estimates based on the information you enter and the editable grade scale in Settings. Official grading rules vary by school, course, and instructor — confirm real grades and GPA with your institution.
• The file is a plain Excel workbook with no VBA or macros.
• It's built primarily for Microsoft Excel. The workbook notes describe reasonable Google Sheets compatibility, but formulas, dropdown lists, and conditional formatting are not guaranteed to render identically in Sheets.
• Manual data entry is required throughout — there is no automatic import from a school portal, LMS, or calendar app.
• Every sheet has a defined print area, but exact print appearance can still vary by printer, paper size, and margin settings.
• Save a backup copy of the file before making large edits — formulas can break if a white output cell is overwritten with typed text or numbers.
• Unauthorized resale or redistribution of the template file itself is not permitted.

Related Calculators and Guides

To help you get the most out of semester planning, consider these related tools and guides on our platform:

• Quick GPA check — Get a fast, one-off GPA estimate without opening the full workbook using the online GPA Calculator, or read How to Calculate Weighted GPA by Hand for the full worked example behind that math.
• Build a schedule that holds up — See the study-hour math and the planned-vs-actual tracking method behind the Class Schedule and Study Planner sheets in How to Build a Weekly Class Schedule That Does Not Fall Apart by Week 3.
• Fix a tracker that keeps dying — Understand the 4-status system and completion-rate tracking behind the Assignment Tracker and Semester Dashboard sheets in Why Your Assignment Tracker Keeps Failing.
• Budgeting alongside your semester — Plan monthly income and expenses with the Monthly Budget Planner Excel Template.
• More spreadsheet templates — Browse the full Excel Template Library for other free, downloadable workbooks.