Project Management for Education Programs: The Google Sheets System That Replaced Our Crumbling LMS Workflow

A practical project management system for education programs using Google Sheets — track courses, certifications, student files, and deadlines without expensive software.

Last fall, our program coordinator quit mid-semester, and she took every mental map of our project management education courses with her. Which students had submitted their prerequisite documentation. Which adjuncts had signed contracts. Where the updated syllabus for our online project management classes lived. All of it — gone. Not literally deleted, of course. The files existed. They were scattered across a shared Drive with 1,400 items, a half-abandoned LMS, three people's email inboxes, and a single heroic binder labeled 'SPRING 2024 — DO NOT TOUCH.' We didn't have a file problem. We had a 'nobody-can-find-anything-when-the-one-person-who-knows-leaves' problem.

I run the continuing education arm of a mid-sized institution — the kind that offers project management certification prep courses, a handful of professional development tracks, and a growing catalog of online classes. We're not a massive university. We don't have a dedicated IT team. What we have is a four-person office, an overworked registrar, and about 340 active students who need syllabi, contracts, prerequisite verifications, and certificates tracked without things falling through the cracks. After the Great Coordinator Departure, I rebuilt our entire workflow in Google Sheets. Not because spreadsheets are sexy, but because they're the one tool every single person on my team already knows how to use.

Why Every Education Program's File System Breaks the Same Way

Here's the pattern I've seen at every institution I've worked at, and I've worked at four. Somebody sets up a Drive folder structure: one folder per semester, subfolders per course, sub-subfolders for student documents. For the first three months it works. Then an instructor saves a contract to the wrong folder. Then someone creates a duplicate because they can't find the original. Then a new hire just starts saving everything to their personal Drive. Within a year, you have a digital landfill.

The fundamental issue is that folders are containers, not trackers. A folder doesn't tell you which students have submitted their prerequisite documents for PMP certification prep and which haven't. A folder doesn't flag that an instructor contract expired two weeks ago. A folder just... holds things. Silently. What education programs actually need is a tracker that also holds files — a single view where you can see the status of every course, every student deliverable, and every administrative document, with the actual files attached right there in the row.

That's the system I built, and it's been running for three semesters now without anyone quitting and taking the institutional knowledge with them. Because the knowledge lives in the sheet, not in someone's head.

The Core Tracker: One Sheet Per Program, Not Per Semester

The first mistake I made — and I see other program directors make this constantly — was creating a new spreadsheet every semester. Spring 2024 Course Tracker. Fall 2024 Course Tracker. It feels organized, but it means you can never see the full picture. When an accreditor asks 'show me how this course has evolved over the last three years,' you're opening seven different files and praying the column structures match.

Instead, I built one master tracker per program. Our project management certification track has one spreadsheet. Our healthcare admin program has one. Each row is a course section — not a course title, a specific section (e.g., 'PM-301, Fall 2024, Section B, Tues/Thurs 6pm, Instructor: Dr. Kahale'). The columns track everything that matters:

• Course code and section number
• Semester and year
• Instructor name and contract status (Draft / Sent / Signed / Expired)
• Enrollment count vs. capacity
• Syllabus status (Draft / Approved / Published)
• Prerequisite verification status (how many students have cleared prerequisites)
• Key files: signed instructor contract, approved syllabus, course evaluation summary
• Notes column for anything that doesn't fit elsewhere

The key files column is where things used to fall apart. We'd put a Google Drive link in the cell, but links break, permissions change, and nobody can tell at a glance whether the file is actually there or if the link is dead. This is where I started using FileFox — it lets us drag the actual PDF (signed contract, approved syllabus, whatever) directly into the cell. No link rot. No permissions issues. The file lives in the row, right next to the data it belongs to. When Dr. Kahale's contract is in the same row as her course details and enrollment numbers, my registrar doesn't have to go on a scavenger hunt.

Tracking Prerequisites and Student Documentation Without Losing Your Mind

If you run any kind of certification prep program — PMP, teaching credentials, healthcare certifications — you know the prerequisite verification nightmare. Every student needs to prove they've completed certain coursework or logged certain hours before they can enroll in the next level. Multiply that by 80 students and four prerequisite categories, and you've got 320 individual verification checkpoints per cohort.

I track this with a separate tab called 'Student Prerequisites.' Each row is a student. The columns are the prerequisite categories (e.g., 'Undergraduate degree verified,' '35 contact hours documented,' 'Application fee paid,' 'Supervisor reference received'). Each cell is a dropdown: Not Started → Submitted → Under Review → Verified → Issue. The conditional formatting does the heavy lifting — green for Verified, yellow for Under Review, red for Issue, gray for Not Started.

That formula gives me a quick summary in column F: '3 of 4 prerequisites complete.' I can scan 80 rows in ten seconds and know exactly who's stuck. But the real time-saver is attaching the actual documentation to the row. When a student emails their transcript, I used to save it to a Drive folder, then update the spreadsheet, then try to remember to name the file something findable. Now I just drag the PDF into the cell in the Prerequisites tab. Transcript, reference letter, proof of contact hours — all attached to the student's row. When an auditor asks to see Maria Chen's prerequisite documentation, I don't dig through folders. I click the cell.

The Instructor Contract Pipeline (and Why 'Sent' Is Not a Status)

Every semester I have to get 12-15 adjunct contracts signed, and every semester at least two fall through the cracks. The old system was an email chain with the subject line 'RE: RE: FW: Contract — please sign' that eventually died in someone's spam folder. I had no single view of which contracts were out, which were signed, and which were about to expire.

Now I have an 'Instructor Contracts' tab with these statuses: Drafting → Sent to Instructor → Instructor Questions → Signed → Active → Expiring Soon → Expired. The key insight — and this took me embarrassingly long to figure out — is that 'Sent' is not a terminal status. 'Sent' means 'I did my part and now I'm hoping.' Hope is not a workflow. So I added a 'Follow-up Date' column with a formula that flags anything that's been in 'Sent to Instructor' status for more than five business days.

Column C is the status, column D is the date I sent it. If it's been more than five days, I get a little warning emoji. Simple, but it's caught three dropped contracts in the last two semesters — contracts that would have otherwise surfaced two weeks before the course started, when it's too late to find a replacement instructor.

Each row also has a cell for the signed contract file. When an instructor sends back the signed PDF, I drop it right into the row. No more digging through email attachments in January trying to find something Dr. Reeves signed in August.

Building a Project Timeline for Accreditation and Program Reviews

Accreditation reviews are the project management stress test that no one in education talks about until it's six months away and everyone is panicking. Our last review required us to produce documentation across 14 standards, with evidence files for each. The review body wanted everything organized, cross-referenced, and submitted in a specific format. It was, essentially, a massive project with milestones, deliverables, and a hard deadline.

I set up a dedicated accreditation timeline sheet with one row per standard. Each row tracked: the standard number, a description, who was responsible for gathering evidence, the evidence files themselves, the status (Not Started → Gathering Evidence → Draft Narrative Written → Internal Review → Final), and the deadline. I color-coded the timeline using conditional formatting tied to the deadline column — green if more than 30 days out, yellow if 15-30, red if under 15.

The evidence files were the real game-changer. Instead of maintaining a parallel folder structure in Drive ('Standard 1 → Evidence → Sub-evidence → Version 3 Final FINAL'), I attached every evidence file directly to the row for its standard. Meeting minutes, curriculum maps, assessment rubrics, student outcome data — all living in the cell next to the standard they supported. When the review team asked for 'evidence supporting Standard 7.2,' my coordinator didn't have to navigate six folders deep. She opened the sheet, scrolled to row 7.2, and clicked.

Online Project Management Classes: Tracking Async Students Who Disappear

We offer several project management classes online, and the biggest operational headache isn't the content delivery — it's tracking engagement for students who are asynchronous. In a face-to-face class, you notice when someone stops showing up. Online, a student can quietly vanish for three weeks before anyone realizes they haven't submitted anything.

I built an 'Engagement Monitor' tab that pulls from our LMS export (most LMS platforms let you export a CSV of student activity). I paste the export into a hidden tab, then use VLOOKUP to pull each student's last activity date into the monitor tab. A simple formula flags anyone whose last activity is more than seven days ago.

Column A is the student ID. The formula checks their last activity date from the LMS export and flags how many days they've been inactive. My advisors check this tab every Monday morning. If someone's been inactive for 10+ days, they send a check-in email. If it's 21+ days, we escalate to a phone call. We've improved our course completion rate by about 18% since we started doing this — not because the sheet is magic, but because it made the invisible visible.

What to Do First (and What to Stop Doing Immediately)

If you're reading this from a program office that's drowning in Drive folders and email-based workflows, here's my honest advice: don't try to build this whole system in a weekend. Start with the one thing that causes you the most pain right now. For us, it was instructor contracts. For you, it might be prerequisite tracking or accreditation evidence. Pick that one thing, build a single tab for it, and use it for one full cycle (one semester, one cohort, one review) before expanding.

And stop doing this immediately: stop using folder names as your tracking system. 'Contracts — Signed' is not a status tracker. It's a folder. You will never open that folder proactively. You will only open it when someone asks you to prove that a contract exists, and by then you'll discover that three of the files are mislabeled and one is missing entirely. The tracker is the source of truth. The files attach to the tracker. That's the whole philosophy.

Three semesters in, our four-person office runs a 22-course catalog, 340 students, and 15 adjuncts from a set of Google Sheets that anyone on the team can pick up and understand without a walkthrough. When our next coordinator quits — and someone always eventually quits — the system stays. That's the point. Not a prettier spreadsheet. A system that survives turnover.

Frequently Asked Questions

What are the prerequisites for PMP certification?

PMP certification requires either a four-year degree with 36 months of project management experience and 35 hours of project management education, or a high school diploma with 60 months of experience and 35 hours of education. The 35 contact hours can come from online project management classes, university courses, or approved training providers. Track each prerequisite category in a spreadsheet with status dropdowns so nothing gets missed during the application process.

How do I track project management classes online in a spreadsheet?

Create a master tracker with one row per course section, including columns for instructor, enrollment, syllabus status, and key file attachments. Use a separate tab for student engagement monitoring — paste your LMS activity export weekly and use VLOOKUP to flag students who have been inactive for more than seven days. This gives you a single view of every online class without logging into three different platforms.

What is the best way to organize files for an education program in Google Sheets?

Attach files directly to the spreadsheet row they relate to instead of maintaining a separate folder structure. When a signed contract lives in the same row as the instructor's name and course assignment, anyone on your team can find it without navigating Drive folders. Tools like FileFox let you drag and drop files into cells, eliminating the broken-link problem that plagues shared Drive setups.

How do I prepare for an accreditation review using Google Sheets?

Build a timeline sheet with one row per accreditation standard. Track the responsible person, evidence status, narrative draft status, and deadline for each standard. Attach all evidence files — meeting minutes, curriculum maps, assessment data — directly to the row for the standard they support. Use conditional formatting on deadline columns to flag standards that are falling behind.

Can Google Sheets replace project management software for education programs?

For small to mid-sized programs (under 500 students, under 30 courses), Google Sheets handles course tracking, contract management, prerequisite verification, and accreditation prep without the cost or learning curve of dedicated project management software. The key is building the right structure — status dropdowns, conditional formatting, file attachments — rather than using the sheet as a blank canvas. Dedicated PM software becomes worth it when you need automated notifications, complex dependency tracking, or multi-department permissions.