Data Collection and Management System
Click on the image above to navigate to a Demo of the Data Management System
*Please note, this is a “living” resource and I am continuing to add repairs and refinements
This project is a Google Sheets and Apps Script data tracking system built for our school's K–3 self-contained Communication Program. It automates IEP goal tracking, calculates cumulative performance in real time, and generates printable summary reports per student. I stepped into this project not knowing how to help or what was possible. I have an automated system in my own classroom, a digital economy, where student bank accounts, jobs, salaries, and transactions all ran through Google Sheets. I knew what the technology could do, and that's what helped me here. What started as a small ask about organizing academic data, became a full redesign of the program's data infrastructure, and is now in active daily use for both academic and behavioral data.TSPC Standards Alignment
Each project in this portfolio is intentionally connected to Oregon's Principal License Standards, demonstrating how my practicum experiences built real leadership readiness across multiple domains.
By clicking the link below, you’ll be directed to the government website for a full description of each standard of practice.
-
I kept watching a teacher drown in a system that was never going to work, no matter how hard she tried. When data collection is designed around what is actually sustainable for one human being to do consistently, it stops being a compliance task. It becomes something a team can build a program around.
-
Students in self-contained special education programs can be among the most underserved in any building, and inconsistent data is part of how they stay that way. The equity problem doesn't stop at data collection. It shows up in IEP meetings too, where families receive a firehose of information in language they didn't train for and are expected to be partners in decisions they can barely follow. Most caregivers won't ask for clarification a third time. Many leave without truly understanding where their child stands. The automated summary tab changes what a teacher can bring into that room. A color-coded progress report with charts and goal-by-goal breakdowns, generated in one click, gives families something they can actually read, reference, and return to. Accessible communication should not require extra hours from a teacher to make it happen.
-
A teacher who can walk into an IEP meeting with clean data, clear trends, and a visual summary of every goal is a different kind of advocate for their students. That is what this system makes possible. Getting the data infrastructure right changed what this teacher is able to say and do on behalf of kids.
-
Special education has one of the highest teacher turnover rates in the profession, and unsustainable systems are a meaningful part of why. Giving this teacher her time back, and watching her staff go from dreading data collection to owning it, is what keeping good people in hard jobs actually looks like.