10 tabsGoogle Sheets + Excel
Project Management Spreadsheet
Tasks, Kanban board, Gantt chart and dashboard in one sheet that keeps itself up to date.
$7.00$14.0050% off
Overview
Copy each syllabus into the Assignments tab one time, and the spreadsheet does the planning: a color-coded week, a monthly calendar with exams starred, and a dashboard showing what's due today, what's late and which exams are in the next 14 days.
As grades come back, your weighted current grade in each class updates too. It works for college and high school, plus grad school, nursing school, online classes and homeschool, with a filled-in example to learn from.
Due today at a glance
Today, this week, overdue and your next 10 deadlines with countdowns.
Exam countdown
Every exam in the next 14 days shown on the dashboard.
Grades that update
A weighted current grade for each class as marks come in.
Color-coded classes
Each class has its own color across the week and month views.
What's inside
Dashboard
Due today, due this week, overdue, exams in 14 days, next 10 deadlines, current grade per class
Assignments
Homework, quizzes, exams, essays and projects with class color, due date, priority, status, grade and weight
This Week
A color-coded weekly planner with one column per day, filled from your assignments
Month
A monthly calendar of due dates with exams starred
Classes
Teacher, days, time, room, credits, target grade, weighted current grade, next due date
Example file
A filled-in sample with 5 classes and 26 assignments, plus a Start Here guide
How it works
- 1
Buy on Etsy, then download the START-HERE PDF and the Excel files from your Etsy Purchases page.
- 2
For Google Sheets, open the link in the PDF and choose Make a copy. For Excel, open the .xlsx file.
- 3
Add your classes, then each syllabus's assignments. The week and dashboard fill in on their own.
Good to know
- Digital download: nothing is shipped
- Personal use license: please don't share or resell the template
Questions
How do I keep track of assignments in Google Sheets?
List each assignment once with its class and due date. This template then builds your weekly planner, monthly calendar and dashboard from that list.
Does it calculate my grade?
Yes. Enter each assignment's grade and weight, and the Classes tab shows your weighted current grade for every class.
Will it last the whole school year?
Yes. It holds up to 12 classes and 300 assignments.
Do I need Excel?
No. It works in Google Sheets with a free Google account, on a computer, tablet or phone. It also opens in Microsoft Excel, and Apple Numbers can open the Excel file.
How it's made: designed by Sorted Templates. We use AI tools to help draft text and lay out pages, and every page is reviewed and edited by us before it's listed. Lifestyle and mockup images may be AI-generated or AI-edited; the page previews show the actual files.
You might also like
9 tabsGoogle Sheets + Excel
Book Tracker Spreadsheet
A cozy digital reading journal: every finished book becomes a colored spine on your shelf.
$6.00$12.0050% off
7 tabsGoogle Sheets + Excel
Job Application Tracker Spreadsheet
Your whole job search in one sheet, with follow-up reminders so no lead goes quiet.
$4.00$8.0050% off
12 monthly tabsGoogle Sheets + Excel
Habit Tracker Spreadsheet for Google Sheets
Tick off each day, keep your streaks alive and watch a whole year of habits fill in.
$2.50$4.9950% off