Assignment Tracker Google Sheets Excel, Student Planner Spreadsheet, Homework Tracker, Exam Calendar, Grade GPA Tracker, Study Planner
Category: Planners / Homework Tracke
Stop forgetting assignments. Type each one in once, and this tracker counts down to every deadline, colours what is urgent, drops it onto a monthly calendar and keeps your grades and GPA up to date for you.
Stop forgetting assignments. Type each one in once, and this tracker counts down to every deadline, colours what is urgent, drops it onto a monthly calendar and keeps your grades and GPA up to date for you.
WHAT'S INCLUDED
• Google Sheets version: Blank + Example (make-a-copy links inside the PDF guide)
• Excel version (.xlsx): Blank + Example
• Quick Start Guide (PDF): setup in 2 minutes, a tab-by-tab walkthrough and FAQ
You download 3 files: the Quick Start Guide PDF and the two Excel files. The Google Sheets links are on page 2 of the guide.
8 CONNECTED TABS
• DASHBOARD: total, completed, pending, due this week, overdue and upcoming exams at a glance, a completion bar, a "Next Up" list sorted by deadline, workload by subject, study time this week, estimated GPA and a status chart
• ASSIGNMENTS: assignment, subject, teacher, type, assigned date, due date, priority, status, grade and notes. Days Left fills in by itself: Due in 3 days, Due Tomorrow, Due Today, Overdue by 2 days, Done
• CALENDAR: choose any month and year. Homework, projects and exams appear on their day with a colour key. Today is highlighted, and busy days show "+2 more"
• EXAMS & QUIZZES: date, time, location, topics and study status (Not Started, Reviewing, Almost Ready, Ready) with an automatic countdown
• SUBJECTS: your classes, teachers, rooms and credits, plus automatic counts of assignments, completed, pending and overdue, average grade, letter grade and study hours per subject
• STUDY TRACKER: log date, subject, minutes, topic, pages or questions and focus. See hours this week, this month and all time
• GRADES: score and out-of turn into a percentage and letter grade. Overall average and estimated GPA (weighted by credits) calculate instantly
• SETTINGS: your name, school, school year, week start (Monday or Sunday), your own grade scale and every dropdown list
WHY STUDENTS LIKE IT
• Automatic: countdowns, overdue alerts, averages and GPA update on their own
• Simple: 8 focused tabs instead of a 40-page planner
• Colour-coded status and priority, so urgent work stands out
• Dropdowns everywhere, so data entry is fast
• Reusable every semester: keep the blank copy
PERFECT FOR
• High school students
• College and university students
• Homeschool families and parents who help with homework
• Online and part-time learners
• Back-to-school, new semester or graduation gifts for students
HOW TO USE
1. Download the files from your Etsy Purchases page.
2. Open the Quick Start Guide PDF and click "Make a copy" (Google Sheets), or open the Excel file.
3. In Settings, add your name, school year and week start.
4. In Subjects, list your classes and teachers.
5. Add your assignments and exams. The dashboard and calendar fill in automatically.
REQUIREMENTS
• Google Sheets: a free Google account. Works in any web browser and in the Google Sheets app on phone and tablet.
• Excel: Excel 2010 or newer, Microsoft 365, Excel for Mac or Excel on the web.
• English language, US date format (you can change the date format in your own copy).
PLEASE NOTE
• This is a digital download. No physical item will be shipped.
• Colours may look slightly different on different screens.
• For personal use only. Please do not resell, share or redistribute the files or the copy links.
• Because this is a digital product, returns and exchanges are not accepted, but if anything is not working, message me and I will help.
• Google Sheets is a trademark of Google LLC and Excel is a trademark of Microsoft. This product is not affiliated with or endorsed by either company.
Questions before you buy? Send me a message. I am happy to help.