I've written a lot lately (here and here) about WHY tracking your school or organization's data is so critical right now.
As schools begin to reopen, I've heard from educators of so many different configurations for what school is going to look like: some totally virtual, some in person, some in a hybrid model...
That's a lot to keep track of!
It's hard enough to make sure that no child falls through the cracks when school is operating as usual -- now that task seems herculean.
So how can we be sure that we know where each student stands, even if we don't see them every day?
How can we know that we're doing our best to meet their needs (and that we even know what those needs are)?
That, my friends, is where some simple data tracking strategies come in.
Here is one trick to help you assess, at a glance, which students or families need a little more support: conditional formatting in Excel.
Conditional formatting allows you to set criteria to automatically color-code or highlight values that you need to take action on.
You'll see that my (totally fictitious) dataset below is just a typical spreadsheet -- nothing stands out at a glance, and it's hard to see which of these students really needs the most attention.
We can use conditional formatting to visually highlight some of the students who need some support. We can find it by clicking selecting the text we want to format, and then clicking on the circled icon below.
Once you click on the icon, you'll see a drop-down menu pop up with all of the options you have for automatically color-coding your data. I think the easiest way to start is by selecting "New Rule."
In the menu that pops up to manage your rules, you'll set the criteria that will determine what gets color-coded and how you want to code it.
This is where things get fun.
The simplest option is "Classic." I always choose "Format cells that contain" and set either a text or numerical value that I want to highlight. Below is how I highlighted the students whose Quarter 3 grades were below a 70.
And voila! Now you can see, at a glance, the students who were struggling in Quarter 3. No fancy statistical skills needed!
I could also create other rules for my high-performing students or those ones that fell in the middle of the class.
There are TONS of other ways to conditionally format your data -- here are two other examples for the same data that address the whole range of grades.
On the left, you'll see that instead of the Classic mode, I used an Icon Set to do a little traffic light system for the student grades. On the right, I used Data Bars to help me see students' grades on a scale from the lowest to highest score.
With these formatting options, I can see the students that might need some extra support... and it only took a few clicks and a decision about the point at which I'd be concerned about a student.
This is just one strategy of many that can help you quickly and easily to make sure no students are falling through the cracks.
Want to learn more?
None of these work for you? Schedule a free 30-minute consultation with me so we can figure out how to best get your data tracking system started!
When I started my doctoral program at Vanderbilt, I certainly didn't expect to get into a ... heated discussion, shall we say? ... with the professor of my first course.
We were discussing characteristics of effective leaders, and our professor mentioned that the Myers-Briggs Type Indicator, one of the most well-known personality tests, was essentially worthless.
You see, despite its incredible popularity, there is actually no data to show that Myers-Briggs is a valid and reliable assessment -- that it measures what it intends to, and that you'd consistently get the same outcomes if you took it again and again.
Now, I've always been a pretty introspective person, and I (still) love personality tests as a fun way to reflect on how I think, feel, and interact with others. I'd never taken them as a scientific assessment of my psyche, but Myers-Briggs especially had stood out to me as a somewhat revelatory framework for why people interact and act the way they do.
I had always gotten the exact same result when I'd taken the Myers-Briggs (ENFJ, if you're curious), so when my professor started talking about how most people get quite different results each time they take it, and that there was no research to support its utility, part of me was bummed, and part of me was fired up.
I argued (civilly, of course) that I didn't use it as a formal diagnostic tool, but instead as a helpful resource or an interesting way of looking at things. So why should it matter? (Newsflash: It does matter.)
For fun, I recently read The Personality Brokers: The Strange History of Myers-Briggs and the Birth of Personality Testing by Merve Emre. Of course, she confirmed what my professor had said many years ago. However, it reminded me of something I see often in education.
People who are passionate about helping children and families often feel that they KNOW that what they're doing is helping the communities they serve, even without any real data to back it up.
We KNOW that our Family Science Night was a success because there were lots of families there, and everyone enjoyed themselves. We BELIEVE that a teacher is effective because the children love them. We FEEL the impact of an after-school program because, well, it's been in the community forever.
Unfortunately, we can't rely on gut instincts, feelings, and beliefs alone to tell us if something is effective... just like I couldn't make decisions based on only an affinity for Myers-Briggs.
Let me be clear: education, and family engagement in particular, tends to get kind of fuzzy. While we can't rely on intuition, it's also true that we can't rigorously test everything that happens in schools. We need to find a middle ground.
But this isn't just my random interest in personality theory.
When it comes to children and families, we need to make sure that what we're doing to try to help them actually works.
Luckily, it's not that hard to get started. We can begin tracking data, analyzing trends, and ultimately, measuring our impact so that we know we aren't just THINKING that we're changing lives. We actually are.
Ready to start your evidence journey?
Sign up below to get the Evidence for Engagement mini-course sent to your inbox.
You have successfully joined our subscriber list.
The goal of this blog is to highlight relevant issues that impact students, families, and communities and spark engaging discussions about how to address those issues through evaluation.