Then when I turn the assignment in I cross it out with a black pen. When I finish an assignment I highlight over the yellow highlight in orange. When I start an assignment I highlight it in yellow. I have mine taped up right next to my desk. Now that you’ve made the spreadsheet, how do you use it? Go on and select the rest of the months and do it again one at a time. Then your month should be all sorted out by due date! Nice and easy 🙂 Simply select to sort column A (your due date column) by smallest to largest and press ok! When you click on the custom sort button, this box should pop up. If it does not, then click on the custom sort button. If it already says to sort smallest to largest, just click that and you’re done. The most common is that it will say sort it A-Z (alphabetically) but that is not what you want to do. There should then be a menu telling you a variety of different things. 2) Click the A-Z ButtonĬlick on the button on your toolbar that says A-Z. 1) Highlight the AreaĬlick on the cell in the top right corner of the month (the first due date) and drag until you have selected all the assignments, classes, and due dates for that month. If you’re not computer or spreadsheet savvy, this one might get a little confusing for you so I’ve laid it out in small steps below. Once you’ve entered in all the assignments, arrange them by due date. Go class by class so that you don’t get overwhelmed with having to go day by day. In the assignment section I made sure that I was short and sweet, so that it didn’t grow too big. I started with one class and added in each assignment under the month that it was due. Then I began to write in the dates for each class.

and repeated until all the months for the term were on there.

Then I skipped about 10 rows and wrote the next month. I opened up Microsoft Excel (this can also be done in Google Drive Spreadsheets if you do not have Microsoft Excel) and made a spreadsheet with 3 columns.ġ for the due date, 1 for the class, and 1 for the assignment.īelow that I merged the row together and wrote the first month. I changed it a tiny bit to fit me, but not much.įirst, I gathered all of my class syllabus’ ( syllabi?) together and highlighted all the important dates: due dates, exams, field trips, whatever I had to remember. I have to admit, it was a little intimidating at first… but then I found this idea for an assignment planner by Kirsten at Organized Charm. No reminders the day before it’s due, no mentioning it in class, nothing. Some professors put some assignments on the syllabus and then never speak of them again. It always stated the same grading scale, the same attendance policy, and the same general information about every class.

I don’t know about you, but my syllabus in high school was always pointless. The major thing different in college classes from high school classes is the syllabus.

Free excel student planner