free stuff, organization

Free! College Assignment Sheet Template

February 12, 2015

orphan survival guide - social media - free college assignment sheet template

Last month I shared my new planner, which is part of a larger accountability binder system that I use to keep track of things I need to work on and places I need to be.

One of the pages was my assignment and project sheet where I wanted to keep all of due dates. I have pretty small handwriting so I crammed in two 40-line tables on the page: one for classwork and one for writing projects.

I greatly underestimated how many things I would have due this semester. Not counting the surprise projects that have sprung up since the semester started (thanks a lot, j-school), I have over 150 items in my class assignment list.

By comparison, I have about 10 anthology deadlines listed in my project sheet for the entire year.

I obviously need something a little more heavy duty for tracking classwork.

Inspired by this post on Organized Charm, I made a Google Sheet specifically for class assignments.

The Spreadsheet

The spreadsheet has columns for the semester week, the specific due date, the class it’s for, the assignment name, and the four potential statuses I may be stuck on: reading, taking notes, writing an initial draft, and completion.

The grey and white backgrounds really help me keep track of what’s upcoming that specific week, and on my printed sheet I use a yellow highlighter in between each specific day so I can prioritize.

Orphan Survival Guide - How To Make A College Assignment Tracking Sheet

Status Columns

The status columns help me to isolate and organize things within the spreadsheet, usually by ordering an entire column.

I use the status columns as a checklist to keep track of what I’ve done and what still needs work.

If you want to track things just with the spreadsheet, you can use drop-down menus in the status columns to check off items when you’re done.

I like using a paper system, so I manually check off when I’m done with a step–and when I’m totally finished, I use a highlighter to strike through the whole line.

The downside to using a paper version rather than an electronic version is that my professors have changed due dates several times so far, so I have to re-write them in the printed copy or re-print it if I’m feeling particularly fussy over it. Having a shortcut on a tablet or laptop may end up being a better option, even though I like having physical tracking sheets.

Orphan Survival Guide - Free! College Assignment Tracking Spreadsheet


Click here to use the template!

[One day I’ll figure out how to make the embed code work. Today is not that day.]

You Might Also Like


  • Reply Savanna Brewton August 5, 2016 at 11:04 AM

    Thank you so much for this! This master syllabus is exactly what I was looking for!

  • Reply Nora August 30, 2016 at 3:46 PM

    Hello, I am very interested in utilizing your free master syllabus and assignment semester tracker, but when I attempt to download the files, they download empty. I was wondering if you could email me the templates? I would appreciate it so much! By the way, I love your blog! It’s the only thing helping me get through life. Thanks a bunch.

  • Leave a Reply