Free College Assignment Tracker Template With Master and Weekly Views
Download a college assignment tracker with master and weekly views, source/TBD handling, changed-date tracking, and a realistic multi-course example.
This is a practical .xlsx assignment tracker for college or university students who want one master list plus a weekly action view.
It includes:
- Master Assignments
- Weekly View
- Lists & Settings
- Worked Example
- Printable Week
- source and verification fields
- explicit TBD handling
- changed-deadline tracking
- optional weight, effort, priority, start date, completion date, and recurring fields
There is no signup requirement in the resource itself.
What to do first
- Open Lists & Settings and replace the sample course names with your courses.
- Go to Master Assignments.
- Add one row per assignment, quiz, lab, project, midterm, final, or other academic task.
- Record the source of the information.
- Leave the due date blank and mark the due time/date field
TBDwhen the date is not confirmed. - Pick a Monday in Weekly View to see that week, overdue incomplete work, and undated/TBD items.
The Master Assignments sheet is the workbook's source of truth. Weekly View is a filtered action layer.
The essential fields
| Field | Purpose |
|---|---|
| Course | Separates work across classes |
| Assignment / Task | Names the obligation |
| Type / Category | Assignment, quiz, project, exam, etc. |
| Due Date | Current confirmed date |
| Due Time / TBD | Keeps time and uncertainty explicit |
| Status | Not Started, In Progress, Completed, or Cancelled |
| Official Source / Link | Lets you re-check the information |
| Verification Status | Verified, Unverified, or Needs Check |
| Notes | Clarification or context |
Those fields are enough to run the core tracker.
The workbook also includes optional planning fields:
- Weight / Grade Impact
- Estimated Effort
- Priority
- Start Date
- Completion Date
- Recurring?
- Previous Due Date
These are optional because students do not always know the weight or effort in advance.
Master Assignments vs. Weekly View
Master Assignments
Use this for the complete cross-course record.
The formula columns calculate:
- Changed? — compares Current Due Date with Previous Due Date.
- Days Remaining — current due date minus today's date.
- Week Start — the Monday of the due-date week.
- Overdue? — marks a dated incomplete task after its due date.
Weekly View
Choose a Monday.
The view pulls:
- tasks due during that week;
- overdue incomplete tasks;
- tasks with no confirmed due date.
That last part matters.
A TBD task should not disappear simply because it cannot yet be placed on the calendar.
How changed dates work
Suppose ECON Problem Set 3 was originally due October 8.
The instructor moves it to October 9.
Enter:
- Current Due Date: Oct. 9
- Previous Due Date: Oct. 8
The Changed? field marks the task as CHANGED.
This does not claim to sync automatically with your course sources. You still maintain the workbook from the official course information.
Worked example included
The workbook contains an example using five courses:
- CSCI 4140
- CSCI 4177
- ECON 1101
- HIST 2200
- MATH 2030
The example includes:
- a changed deadline;
- a recurring assignment;
- a TBD research proposal;
- major and minor assessments;
- optional weights and effort estimates;
- two different courses with similarly named quizzes.
Use the example to understand the structure, then enter your own coursework in Master Assignments.
What about priority?
The template deliberately does not calculate an objectively correct next task.
Priority is a student-entered field.
Weight and estimated effort are available because they can be useful planning inputs, but the workbook does not claim that a formula can determine the scientifically optimal order of your assignments.
For a broader method for keeping the tracker accurate over time, see How to Keep Track of Every College Assignment in One Reliable System.
Can I use it outside Excel?
The provided resource is an .xlsx workbook.
You can try importing it into another spreadsheet application, but formulas, dropdowns, filtering, and print behavior should be rechecked after conversion. The QA for this release applies to the .xlsx file provided here.
Why the template includes source and verification fields
University planning resources commonly recommend centralizing important academic dates and moving between semester and weekly planning views.[1][2] The source and verification fields are Qumely's additional planning layer: they make it easier to re-check a task when course information changes.
Download
Start with your course list, add your assignments, and keep the Master Assignments sheet current.
Sources
1. Cornell University Learning Strategies Center, Semester and Weekly Calendars.
2. University of British Columbia Learning Commons, Learning at Home: Setting up a Study Space and Study-Pace.