How I Stay Organized All Semester: A Guest Post by Katy

As someone who has known Katy for a solid three semesters, take any advice on schoolwork because this girl knows her stuff. It's a lot of organization upfront, but it WILL pay off in the long run. Thanks so much Katy and have a great start to the weekend!

Hi everyone! I hope your New Year is starting out well! Many New Year's resolutions pop up around this time pertaining to organization and staying on top of assignments throughout the semester. So, I decided to write this guest post today and share a HUGE tip I learned to stay on top of all the work I have to do for my classes. Usually, each of your professors start out the semester by handing out a syllabus for each of their classes. If you are anything like me, I skip straight to the back to see what the assignments are throughout the semester to get a feel for the coursework demanded by the class. Well, I had a lot of trouble keeping up with what I needed to do for each class because I would have to carry around four different syllabi everyday and flip to the corresponding date to see what assignments were due. I thought to myself, there must be a better way to stay organized and tap into my SUPER OCD-ness.

Enter the Semester Assignment Spreadsheet! I really like to use Excel to create to do lists, so I thought, why not make a semester to do list. So, today I am going to walk y'all through how I make an Excel spreadsheet showing all of the assignments from all of my classes throughout the semester.

  1. Collect all of your syllabi that your professors either gave you or are online
  1. Open up Excel and label the columns like this:
Due Date
Book/Article Needed
  1. Next, input the information from one syllabus (from the beginning of the semester through to the end of the semester)
  2. Repeat with all of your other classes!
    1. P.S. I know this seems like a lot of work, and it is a bit tedious and time consuming, but the final product is so life-changing. It's worth it!
  3. After inputting all of your assignments from all of your classes, highlight the same sue dates and move them around until they are in chronological order.
  4. Your final product should look something like this but MUCH longer
After you are finished, print it out and jump for joy because now you have all the assignments for your semester in one place! I hope you guys find this as useful as I do. It really has helped me stay on top of all my assignments because now there is no way I can miss anything when it's all in one place.

Much love and shout out to Emma for letting me showcase my OCD tendencies :)

No comments