In school, it often feels like your teachers assume you are only taking their class and therefore, weekly essays are something you have time for. Unfortunately you rarely do have just one class, and that means multiple assignments each week. The assignment schedule template is a free download you can use right in Excel to expertly and easily record and track all of your school assignments.
How to use the Assignment Schedule Template
Download the pre-populated assignment schedule template and begin by erasing the old information and putting in your assignments. An easy way to do this is to have your syllabi from your classes that list the semester’s assignments, and use those to create the entire schedule. On the “Started On” field, you can enter the date you want to start the assignment, or today’s date if you’re unsure when you’ll begin.
The progress bar is not something you need to edit, instead change the percentage in the next column to the right to edit the progress bar. At the top, the template has a color code listed for the completion level of an assignment. Below this is a bar for you to select how you want the assignments ordered in terms of when they are due. Select the blue colored box and click the dropdown arrow that appears to adjust the number of days, weeks, or months you want assignments ordered by. You can also choose “no highlight” if you’d rather order your assignments another way. This can be done by selecting the course, instructor, date, or progress fields and choosing Ascending or Descending order.
After you’ve finished entering in your semester’s assignments, go to the bottom Excel tab and move to “Assignment Details”. Here, you’ll see all of the information you’ve entered ordered into a more comprehensive table format. You can view and order which courses have the most assignments, which need more progress, or what due dates overlap each other.
Since this page is filled in according to what you enter in the “Assignment Schedule” section, anytime you update with new assignments, you will need to right click and hit “refresh” on the black bar of this page to re-arrange it with the new data.
Once your assignments are entered, you can update this spreadsheet throughout the year with your progress on each essay, lab, and presentation without missing a deadline.
Download the Assignment Schedule Template
Template courtesy of Microsoft
Check this out while you wait!