IEBPROJECT CASE STUDY
10 / 47
CT 00:00:00 T+00:00
A spreadsheet dashboard headed SPMP 10.0 Overall Summary, listing goals such as Congressional Award, Coding, Science Fair, SAT slash ACT and Website, each with a percent complete

Planning systemDrawing 10 of 47

SPMP

SPMP is two Excel workbooks I built for myself, and they ran my whole high school plan. Every goal and deadline rolls up into one number on the front page. It's written in third person, though, like it was meant for other students too.

Sheet 02 of 04/Why

Why a spreadsheet

In high school you're dealing with grades, tests, deadlines and volunteer hours all at once, so I built one sheet that could hold all of it, from that day's work to the whole plan.

A wide spreadsheet calendar covering 2021 to 2023 month by month, with scattered days highlighted in orange and a few in blue and magenta
PL 04Three school years laid out day by day, with the deadline days marked in orange.
A spreadsheet calendar of the college application year with orange bars across deadline weeks and short handwritten style notes such as email kathy beside certain dates
PL 05The application year in the other workbook. Deadlines are blocked out in orange, and the small errands that move an application along are written in the margin.

Sheet 03 of 04/Parts

Issued as separate drawings

I split this project into parts. Each part below has its own page, with its own sections and pictures.

Sheet 04 of 04/Next time

What I'd do differently

If I did this again, I'd use a lot fewer sheets. Forty across two files was more than the plan ever needed.