Assignment Tracker Google Sheets | Student Planner Spreadsheet

Assignment Tracker Google Sheets for students who want one organized place to manage assignments, exams, grades and deadlines. Automatic priority scoring helps you see what needs attention next, while the student dashboard keeps upcoming coursework, exams, course progress and grades easy to understand.

Instead of checking several planners or trying to remember every deadline, use one organized student planner spreadsheet to track your semester from one place.

Perfect for college students, university students, high school students, online students and anyone looking for a practical homework tracker, exam planner, grade calculator, deadline tracker or academic planner.

WHAT YOU’LL RECEIVE

• Google Sheets Assignment Tracker template
• Filled example Google Sheets template
• Optional XLSX backup files
• Clickable Access & Setup PDF
• US Letter printable study planner PDF
• A4 printable study planner PDF
• Exam Planning printable
• Weekly Study Planning printable
• 6 organized spreadsheet tabs
• 200 prepared assignment rows
• 60 prepared exam rows
• Space for up to 8 courses

YOUR 6 GOOGLE SHEETS TABS

• Dashboard
• Setup
• Assignments
• Exams
• Grades
• Start Here

SMART ASSIGNMENT & EXAM TRACKING

Enter your assignments, exams and deadlines and let the spreadsheet help organize what needs your attention.

Features include:

• Automatic assignment and exam priority scoring
• Days-until-due calculations
• Overdue warnings
• Upcoming exam tracking
• Assignment status tracking
• Course filtering
• 7-day and 14-day focus views
• Top priority task list
• Next-action prompt
• Clickable spreadsheet navigation

Instead of only storing deadlines, the tracker helps answer an important question:

What should I work on next?

STUDENT DASHBOARD

Your academic dashboard gives you a clear overview of your semester so you can quickly see upcoming work and identify your priorities.

You can:

• See your top 8 current priorities
• View your next 8 upcoming exams
• Monitor course completion
• Compare current grades with target grades
• View course progress cards
• Track semester progress
• Compare remaining workload by week
• Compare workload with your available study hours

GRADE CALCULATOR & COURSE TRACKER

Keep your grades and academic progress organized inside the same Google Sheets student planner.

Features include:

• Track current course grades
• Set target grades for each course
• Calculate points-based grades
• Calculate category-weighted grades
• View course completion progress
• Compare current grades with your targets
• Ungraded assignments excluded from current-grade calculations
• Actual zero scores counted correctly

Weighted grading supports five preset categories and requires category weights totaling 100%.

WORKLOAD & STUDY PLANNING

See how much schoolwork is coming before deadlines start piling up.

The tracker organizes remaining coursework by due week and lets you compare upcoming workload with your available study-hour budget.

This can help you:

• Spot busy weeks earlier
• See upcoming deadlines clearly
• Identify high-priority assignments
• Plan study time around your workload
• Keep multiple courses organized in one place

PRINTABLE STUDY PLANNER BONUS

You’ll also receive coordinating printable study pages in both US Letter and A4 sizes:

• Exam Planning Page
• Weekly Study Planning Page

That gives you four printable PDF pages in total.

No Canva subscription is required.

HOW TO DOWNLOAD AFTER PURCHASE

This is an instant digital download.

1. Purchase the listing on Etsy.
2. Sign in to Etsy.com using a web browser or computer.
3. Go to Your Account → Purchases.
4. Find your order and select “Download Files.”
5. Download the included files.
6. If your download is provided as a ZIP folder, extract/unzip the folder.
7. Open the Access & Setup PDF.
8. Click the link for the Google Sheets template.
9. Sign in to your Google account.
10. Select File → Make a copy.
11. Save the editable copy to your own Google Drive.
12. Enter your semester dates, courses, assignments and exams.

Please note: Etsy digital purchases may need to be downloaded through Etsy.com in a web browser rather than through the Etsy app.

HOW THE GOOGLE SHEETS TEMPLATE WORKS

After opening your template:

1. Start with the Start Here tab.
2. Enter your semester dates and course information in Setup.
3. Add assignments and deadlines to the Assignments tab.
4. Add tests and exams to the Exams tab.
5. Enter grades in the Grades tab.
6. Open the Dashboard to see priorities, upcoming deadlines, course progress and grade information.

The spreadsheet performs its built-in calculations automatically.

No scripts or paid Google Sheets add-ons are required.

A free Google account is required to create your own editable Google Sheets copy.

Desktop setup is recommended for the easiest experience. After setup, Google Sheets can also be accessed on compatible devices.

WHO THIS STUDENT PLANNER IS FOR

This academic planner spreadsheet is designed for:

• College students
• University students
• High school students
• Online students
• Homeschool students
• Assignment planning
• Homework organization
• Exam planning
• Deadline tracking
• Grade tracking
• Study planning
• Semester organization
• Academic workload planning

WHY USE A PRIORITY-BASED ASSIGNMENT TRACKER?

Many student planners simply store tasks and due dates.

This Google Sheets assignment tracker goes further by helping organize assignments and exams using priority information, due dates and task status.

That means you can open your dashboard and quickly see which coursework needs attention instead of manually scanning every assignment.

It combines:

Assignment Tracker + Exam Planner + Grade Calculator + Student Dashboard + Study Planner

inside one organized system.

PLEASE READ BEFORE PURCHASING

• DIGITAL PRODUCT ONLY — no physical item will be shipped.

• A free Google account is required to make your own editable Google Sheets copy.

• The linked Google Sheets master templates are view-only. Select File → Make a copy before entering your information.

• Example information is included for demonstration purposes only.

• The Dashboard displays the top 8 priorities and next 8 exams.

• Weighted-grade calculations use five preset categories and require weights totaling 100%.

• Current-grade calculations exclude ungraded items. Actual zero scores are included.

• This version does not automatically calculate GPA, grade curves or dropped-lowest-grade rules.

• The spreadsheet does not send automatic email, text or calendar reminders.

• No scripts or paid Google Sheets add-ons are required.

• Canva is not required to use the printable study pages.

PERSONAL USE

Your purchase is for personal study use.

You may reuse your private copy for future semesters.

Redistribution, sharing, reselling, copying or reproducing the digital files or templates for resale is not permitted.