How I Track 120 Students Across 6 Projects Without a Single Spreadsheet
After years of color-coded rows and manual updates, I built something better. Here’s what changed — and what it’s done for my classroom.
Let me describe a scene that every project-based teacher will recognize. It’s Wednesday. A multi-week project is due Friday. You’re walking the room doing a progress check and you ask a student where they are. They say “almost done.” You write it down. You ask the next student. Same answer. By the time you’ve checked in with 30 students, you have a page of notes that are already out of date, three students who definitely aren’t “almost done,” and no way to see the full picture without spending your prep period rebuilding a spreadsheet you’ll have to update again tomorrow.
I did this for years. I got pretty good at it. My spreadsheets were color-coded, formula-driven, and honestly kind of beautiful. And they still couldn’t tell me in real time where my students actually were.
The Spreadsheet Problem
The issue with tracking student progress in a spreadsheet isn’t the spreadsheet — it’s the update cycle. The spreadsheet only knows what you tell it. Which means every data point requires a teacher action: a check-in conversation, a visual sweep of the room, a submitted checkpoint, a status update collected somehow and entered manually.
With 120 students across six class periods, and projects that span two or three weeks, that update cycle is a full-time job on top of the full-time job of actually teaching.
Something had to change. The question was what.
What I Actually Needed
I spent a lot of time looking at existing tools. Google Classroom handles assignment distribution well but it’s not designed for multi-step project tracking. It tells you whether a student submitted something — not where they are in the process. Trello and Asana are built for software teams, not 9th graders. Most EdTech project management tools I found were either too complex, too expensive, or designed for a corporate workflow that had nothing to do with a high school CTE class.
What I needed was simple: a board for each student that showed their tasks, let them update their own status, and surfaced that information to me in real time without any manual data entry on my end.
“I didn’t want another tool to manage. I wanted the students to update their own status — and I wanted to see it the moment they did.”
That’s it. That’s the whole problem. Students update their own progress. Teacher sees it in real time. No spreadsheet in the middle.
Building the Solution
Since nothing I found did exactly this, I built it. I’m a CTE teacher — building things is kind of the point. Learning Wake started as a side project and turned into the tool I now use with every class I teach.
Here’s how it works in practice. I create a project board with the task list for a given assignment. I import my Google Classroom roster with one click — it pulls the student list and sends each student a welcome email with a link to set their password. Students log in, see their board, and start marking tasks as they complete them.
On my end, I have a Student Progress table that shows every student in every class. I can filter by period, by project, by completion status. I can see at 8am on a Wednesday exactly where all 120 students stand without asking a single one of them.
What Changed in My Classroom
The obvious change is time. I’m not spending prep periods updating spreadsheets anymore. But the less obvious change is what I do with the information now that I have it in real time.
Before, I’d find out a student was behind when they turned in an incomplete project. Now I find out on day three of a two-week project — when there’s still time to do something about it. I can pull that student aside during class, ask what’s going on, and actually help. That intervention window is everything in project-based learning.
Students have also changed how they approach projects. When they know their teacher can see their progress in real time, “I’ll do it later” becomes a less comfortable strategy. Not because they’re being monitored in a punitive way — but because the accountability is visible and immediate. Progress is a conversation now, not a mystery revealed at submission time.
The Numbers After a Full Semester
After a full semester using Learning Wake across all my classes, here’s what I noticed. Late or incomplete project submissions dropped significantly. My time spent on manual progress tracking dropped to near zero. And the conversations I had with students about their projects shifted from “where are you?” to “I see you’re stuck on the outline — what do you need?”
120 students. 6 projects running simultaneously. Zero spreadsheets. That’s where I am now, and I’m not going back.
See It in Your Classroom
Free 30-day trial. Import from Google Classroom in one click. No credit card required.
Start Free Trial
Leave a Reply