Week 6 Is When Three Deadlines Land on the Same Day. You Can Spot It in Week 1

1. Transcribe every syllabus into one sheet, once

One row per graded item for the whole term, all courses mixed together. The columns, in order:

Due date, Course, Assignment, Weight %, Status, Grade %, Days left

Ninety minutes with the syllabi open and every other tab closed, in one sitting. Incremental entry is how the 20% midterm becomes an "I'll add it later" and later never arrives. Type the date off the syllabus even if the course also posts it in Canvas; that app is the school's system, not yours.

Status is a plain column you keep to four words: Not started, In progress, Submitted, Graded. Turning it into a dropdown list is a 20-second job in Excel or Sheets, and the file I ship leaves it as text. Anything more elaborate than those four values is a column you stop maintaining by week 3.

2. Weight % turns a list into a priority queue

Without the weight column every deadline looks equally urgent, which is why students burn a Saturday on a 2% discussion response and sleep through a 20% midterm. With it the order of operations decides itself: 20% and due Thursday beats 2% and due Friday, and you never argue with yourself about it. The column also prices a mistake: a zero on that midterm costs up to 20 points of the course grade, a zero on the response costs 2. Both are bad. Only one needs an email to the professor tonight.

3. Let days-left compute itself, and let it color

Do not type a countdown. One formula in a spare column, filled down: =IF(A4="","",A4-TODAY()), where column A holds the due date. The number stays current whether or not you open the file. Then two conditional formats on that column: red under 0, amber between 0 and 3.

Color beats sorting here. A sort shows you what you look for; color shows you what you flinched at. You cannot miss a red cell while scrolling for something else, and the "due yesterday" moment was never a memory problem.

If that column shows #### or a five-digit number like 46269, the sheet is formatting the result as a date instead of a number. Set the column format to Number. That answer covers most of my support mail.

4. Run the five-day scan before the term gets moving

This is the step that pays for the file. Sort by due date and walk the list one course at a time, looking for any five-day window holding three or more graded items. Write each collision date somewhere you will see it.

A term starting in early September usually stacks between the second week of October and the first of November, which is why the scan is worth doing now, while you still have options. Start the paper two weeks early and it stops competing with the midterm. Ask for the extension in week 8 instead of the night before. Drop the small item on the bad Thursday if the syllabus discards your lowest score. Sometimes the only move left is knowing, and a rough week you planned for is not the same animal as one that ambushes you.

5. Track the grade as a percentage, and do not pretend it is a GPA

The course sheet holds: Course code, Course name, Instructor, Credits, Current grade %, Letter (auto), Target grade. Type a score in the percentage column and the letter moves by itself on the common scale (93 A, 90 A-, 87 B+, 83 B, 80 B-, 77 C+, 73 C, 70 C-, 67 D+, below that D or F). If your school cuts the curve differently, edit the formula instead of typing letters by hand. Credits earn their column here as an on/off switch: the average counts only courses that have a credit value filled in, and treats each of them as equally heavy. A zero in a 3-credit course moves this sheet's number exactly as far as a zero in a 1-credit lab.

Now the part most product pages gloss. The sheet takes the plain average of the course percentages you have entered, across the courses that have credits filled in. That is a grade average percentage. It is not credit-weighted and it is not your GPA. Your registrar computes a 4.0-scale number, and schools differ on credit weighting, repeats and pass/fail courses. The average and the letter column also have a reach: they are wired for eight course rows (rows 9 to 16), so a course entered in row 17 is left out of both with no warning. Use the sheet average for one job: seeing which course is slipping while it is still fixable. Put the school's own number on applications. A tracker that hands you a GPA is guessing at your school's rules.

6. Log study minutes and let the neglect show itself

Four columns and one private rating: Date, Course, Minutes, What I did, Focus 1-5. One row per session, entered at the desk, not reconstructed on Sunday. The two summary cells sit to the right of the header row rather than above the list: this week's hours (Monday to Sunday) and all-time hours. Both have a reach, and it is worth knowing before you need it: the weekly figure reads rows 4 through 200, the all-time figure rows 4 through 500.

Then run the comparison nobody makes: hours per course against the weight still outstanding in that course. The course you are neglecting does not announce itself with a bad grade. It shows up three weeks earlier as a small number, and by the time the grade moves, the hours were already wrong. The focus rating stays private, and it is the difference between three hours as a feeling and three hours as a number.

7. One file per semester, and the archive builds itself

Duplicate the workbook on the first day of each term and name it after the term, so Fall2026-Planner.xlsx becomes Spring2027-Planner.xlsx. Last term's file then answers "how many hours did I actually put into organic chemistry" with real rows, and the current file never carries dead obligations into a new term.

Keep it boring on purpose: no macros, no add-ons, so the file can be opened in Excel, Google Sheets (File, Import, Upload, Replace spreadsheet) and LibreOffice Calc. Rows 4 through 43 come pre-wired on the assignment sheet; below that, copy an existing row instead of typing a fresh one so the formulas travel with it. The Semester sheet stops at row 16 the same way, so a ninth course is an edit to those ranges rather than a type into the next line.

The 30-second version

1. Every graded item on one sheet, entered once during syllabus week.
2. Weight % beside the deadline, so priority needs no argument.
3. Days left computed, red under zero, amber under three.
4. The five-day scan for windows holding three or more deadlines, in week 1.
5. Letter grades by formula; the average is a plain percentage over eight course rows, not credit-weighted and not a GPA.
6. Study minutes logged at the desk, compared against remaining weight.
7. One duplicated file per term, formulas kept by copying rows.