FREEBIE: Student Data Tracker

I spend much of my time in my new role analyzing data. The collaborative teams in the department all use their own data tracker, and while most of them are similar, each team has their own way of keeping track of student growth. That’s fine. I adapt. But, I’ve spent some time thinking about what a student tracker would look like in my ideal world, and I think I’ve finally created it. 

And, I’m giving it to all of you FOR FREE!

In Teacher Jargon World, a data tracker would show both a micro and macro level of data. I want to easily see how students are performing by teacher and by class period. I want to track growth by standards, not necessarily assessment. But, I also want to see how students are doing from assessment to assessment. I want to see how the team is performing as a whole from unit to unit, especially because we have so many spiraling standards. Oh, I also want to know how many students have mastered the standards and how many need remediation. And, I want it to be populated with formulas so it updates automatically. I mean, I didn’t think I was asking for much. Did I mention I also want it to be color-coded? Why does no such thing exist? 

It does now. 

I need to clarify to anyone reading this: I, by no means, will require the teams in my department to use this specific data tracker. Honestly, I made it because I need to learn more about Google Sheets and Excel, and this gave me a good excuse to get my hands dirty in these programs. This data tracker is one of MANY ways to keep track of data. There are even programs like Eduphoria and SchoolCity that will do it for you, but this tracker is great for assignments that were completed on paper or projects that can’t necessarily be assessed by a computer program.

So, here it is in all its colorful glory. I hope you find this tool helpful in making data-driven decisions for your students. 

Be bold, and be brave!