{"id":137,"date":"2025-01-15T14:02:57","date_gmt":"2025-01-15T14:02:57","guid":{"rendered":"https:\/\/blog.admissions.uiowa.edu\/simran\/?p=137"},"modified":"2025-01-15T14:02:57","modified_gmt":"2025-01-15T14:02:57","slug":"college-assignment-tracker","status":"publish","type":"post","link":"https:\/\/blog.admissions.uiowa.edu\/simran\/2025\/01\/15\/college-assignment-tracker\/","title":{"rendered":"College Assignment Tracker"},"content":{"rendered":"

In college, there are tons of assignments from multiple classes that all use a different format to set up their course planner for the semester. It’s because of this that I like to make a spreadsheet with all my assignments for the semester. Making an assignment tracker sounds like a daunting task, but I promise it’s a lot easier than it sounds.\u00a0<\/p>\r\n

    \r\n
  1. Create a Google spreadsheet (I’m sure there’s a way to do this in Excel too but I unfortunately lack those skills)<\/li>\r\n
  2. Create two headers: “Assignments” and “Due Dates”<\/li>\r\n
  3. Go through each course and write down all the assignments for the semester as well as their due dates.\u00a0<\/li>\r\n
  4. Assign a color to each class (this makes it aesthetically pleasing)<\/li>\r\n
  5. Select all the assignments and due dates (don’t forget to select the header row too)<\/li>\r\n
  6. Click “Data” (it should be right below the title of the sheet)<\/li>\r\n
  7. Click “Sort range” and then “Advanced range sorting options”<\/li>\r\n
  8. In the pop-up box, click “Data has header row” and then under “Sort by” click “Due Date”\u00a0<\/li>\r\n
  9. Click “Sort” and voila, you have your semester assignment tracker!<\/li>\r\n
  10. You can make a note of when you complete assignments by either using the strike-through or check box feature<\/li>\r\n<\/ol>\r\n

    \"Screenshot<\/a>These are just the basic steps to do it, but I like to organize mine even more by adding in my tests\/quizzes, too, and bolding them with red text so they stand out. I also like to make a box around the week I am currently on so I don’t get overwhelmed by future assignments. I still check the course planners once a week to make sure due dates haven’t changed and update accordingly but I have found this spreadsheet so helpful in mapping out my week and even getting ahead on assignments.\u00a0<\/p>\r\n

    I hope this helps!<\/p>\r\n

    -Simran\u00a0<\/p>\r\n","protected":false},"excerpt":{"rendered":"

    In college, there are tons of assignments from multiple classes that all use a different format to set up their course planner for the semester. It’s because of this that I like to make a spreadsheet with all my assignments for the semester. Making an assignment tracker sounds like a daunting task, but I promise it’s a lot easier than it sounds.\u00a0 Create a Google spreadsheet (I’m sure there’s a way to do this in …<\/p>\n","protected":false},"author":162,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-137","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/posts\/137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/users\/162"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/comments?post=137"}],"version-history":[{"count":5,"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/posts\/137\/revisions"}],"predecessor-version":[{"id":154,"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/posts\/137\/revisions\/154"}],"wp:attachment":[{"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/media?parent=137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/categories?post=137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.admissions.uiowa.edu\/simran\/wp-json\/wp\/v2\/tags?post=137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}