I Blew Up My School Counseling Data: What I Learned

Transcript

WEBVTT

00:00:00.080 --> 00:00:03.951
Hey school counselor, welcome back to the School for School Counselors podcast.

00:00:03.951 --> 00:00:33.393
I'm Steph Johnson, a full-time school counselor just like you, who is here trying to break down the barriers of unsustainable school counseling practices, to make our jobs more rewarding, more effective and definitely more fun, and I'm so glad you're here with me for this episode this week where we're talking about how I blew up my data collection efforts in the worst way possible and what happened after that.

00:00:33.393 --> 00:00:37.749
I think this is going to be a super fun conversation for you.

00:00:37.749 --> 00:00:39.981
As we walk through data collection.

00:00:39.981 --> 00:00:45.552
It exasperates so many school counselors, and understandably so.

00:00:45.552 --> 00:00:52.554
We work a lot with data in our School for School Counselors Mastermind and it never fails.

00:00:52.554 --> 00:00:56.530
Our masterminders sort of gnash their teeth over this whole thing.

00:00:56.530 --> 00:01:07.581
They have a really hard time implementing school counseling data practices, and it's not because they're not super smart, because they are very, very intelligent.

00:01:07.581 --> 00:01:24.846
It's just something about the data that makes it really hard to implement, and I was reminded of all that this year when I blew up my systems, blew up my collection efforts and learned a ton from it.

00:01:24.846 --> 00:01:39.653
So if you've known me for any length of time or if you followed School for School Counselors for a little bit, you know that I am all about the school counseling data and not for the reasons that most other people give you.

00:01:39.653 --> 00:01:49.129
I've learned a lot along the way, but perhaps I've not learned as much as I did this year when again completely blew it up.

00:01:49.129 --> 00:01:58.948
I started doing all kinds of things I'd never done before, and so I want to give you a glimpse into that this week of my data efforts.

00:01:58.948 --> 00:02:09.395
What went well there wasn't a whole lot what went really really wrong, and how I'm approaching that in the coming school year to try to correct all of it.

00:02:10.520 --> 00:02:15.860
Now, the idea for this conversation came from our data discussions session.

00:02:15.860 --> 00:02:19.852
We just had it a little bit ago, right before I started recording this episode.

00:02:19.852 --> 00:02:27.504
We hold it monthly in our School for School Counselors, mastermind, where we workshop our school counseling data.

00:02:27.504 --> 00:02:33.532
Sometimes I teach masterclasses with tips and tricks, talk about collection.

00:02:33.532 --> 00:02:36.024
What do you do once you have the data?

00:02:36.024 --> 00:02:37.968
How do you implement your systems?

00:02:37.968 --> 00:02:39.980
Where do you go from there?

00:02:39.980 --> 00:02:42.971
All of the minutiae of working with the numbers.

00:02:42.971 --> 00:02:56.643
But we also love to troubleshoot data and we talk a lot about our best intentions versus our real-world outcomes in practice, and it gets really, really interesting.

00:02:56.643 --> 00:03:02.554
So this week we had our final data discussions of the school year.

00:03:02.554 --> 00:03:05.930
It was kind of bittersweet, but we look back on our year.

00:03:05.930 --> 00:03:17.907
We talked about what went well, what didn't go so well, and then we planned and prioritized proactively for 2024 into 2025.

00:03:17.907 --> 00:03:22.115
And as we planned, we talked through all the data pieces.

00:03:22.115 --> 00:03:39.793
All of these things kind of started flooding back to me in a different way from the past school year and I thought you know this is an important conversation to have on the podcast as we talk about data-driven efforts in our field and what's needed to truly sustain them.

00:03:39.879 --> 00:03:43.570
Now a lot of people bark at you about collecting data, right.

00:03:43.570 --> 00:03:46.849
They bark at you about using it for advocacy efforts.

00:03:46.849 --> 00:03:48.645
I don't think that's the right reason.

00:03:48.645 --> 00:04:00.492
Or, you know, they just endlessly give you these systems or forms or all kinds of things for school counseling data, but they never actually get in deep with you about it.

00:04:00.492 --> 00:04:02.759
I think that's for a couple of reasons.

00:04:02.759 --> 00:04:04.826
I think number one maybe they themselves aren't quite sure what to do with it.

00:04:04.826 --> 00:04:05.259
I think that's for a couple of reasons.

00:04:05.259 --> 00:04:07.401
I think number one maybe they themselves aren't quite sure what to do with it.

00:04:07.401 --> 00:04:17.490
But number two sustainability is a big part of this conversation and I think it's hard to get your thumb on sustainability, so let's jump into it.

00:04:17.490 --> 00:04:19.603
Let me tell you all about it.

00:04:19.603 --> 00:04:40.211
In my work in the School for School Counselors, mastermind and our data discussions initiative inside of that, I've learned one very powerful thing, and that's the majority of the school counselors that I've had the pleasure of speaking with are really invested in the idea of school counseling data.

00:04:40.211 --> 00:04:47.622
They know it's important, they know they want to do it, they know that it can help their program in so many ways.

00:04:48.685 --> 00:04:55.321
But the real speed bump of it all is that it's really difficult to implement.

00:04:55.321 --> 00:04:58.387
It's kind of like weight loss.

00:04:58.387 --> 00:05:03.721
Have you ever tried to lose a few pounds or try to eat healthier?

00:05:03.721 --> 00:05:07.411
We know we can talk all day long about that stuff.

00:05:07.411 --> 00:05:20.466
We can talk about counting calories, exercising, making healthy choices, but at the end of the day, the change doesn't come from the knowledge of weight loss or healthy eating.

00:05:20.466 --> 00:05:38.862
What makes you successful is implementing a good plan, having a way of approaching all your triggers that make you want to do the wrong things, how to avoid the temptations and how to keep your goal in mind for the long term.

00:05:38.862 --> 00:05:43.050
And that is really really hard for us as humans.

00:05:43.050 --> 00:05:46.194
Our brains seek satisfaction.

00:05:46.194 --> 00:05:48.747
They are trained to seek comfort.

00:05:48.747 --> 00:06:02.452
We don't like pattern interrupters and so it's really really difficult to set these priorities and follow through, especially when we're talking about something as dry as school counseling data.

00:06:03.781 --> 00:06:10.726
This year, for me in particular, was pretty interesting because within my state of Texas, we had some new initiatives.

00:06:10.726 --> 00:06:11.788
I say new.

00:06:11.788 --> 00:06:20.300
They've been in place for a couple of years, but it wasn't until this year that school districts really got intentional about implementing these things.

00:06:20.300 --> 00:06:46.067
I talked about it in a previous podcast episode, where now we have our 80-20 mandate and our legislature has mandated that school counselors spend no more than 20 percent of their time on non-school counseling duties and as part of that, districts were tasked with selecting their data collection processes.

00:06:46.067 --> 00:06:55.262
They gave us all a lot of spreadsheets and trackers and things like that, and we were expected to use those to track data uniformly within our districts.

00:06:55.262 --> 00:06:58.588
Theoretically, that sounds like a great idea.

00:06:59.170 --> 00:07:02.062
The problem was with the implementation.

00:07:02.062 --> 00:07:04.146
For some folks it was great.

00:07:04.146 --> 00:07:06.293
It got them started collecting the data.

00:07:06.293 --> 00:07:10.627
It really got them on the bandwagon of making sure they were doing what they needed to do.

00:07:10.627 --> 00:07:20.997
But for folks like me, who already had systems in place, to completely abandon those systems and start with something new was really, really hard.

00:07:20.997 --> 00:07:27.853
I was using a pretty well-known piece of software to collect data beforehand.

00:07:27.853 --> 00:07:35.009
Then my district opted to discontinue that software and I can't say I was completely sad about it.

00:07:35.009 --> 00:07:46.089
There are some pieces of that business model that I don't feel are in alignment with my school counseling ethos, but nevertheless I thought this would be a great time for a fresh start.

00:07:46.089 --> 00:07:49.560
But nevertheless, I thought this would be a great time for a fresh start.

00:07:49.560 --> 00:08:00.367
But that was the first step in blowing up my data collection efforts, because I didn't really feel comfortable tracking not only in a different modality but with different categories than I was used to.

00:08:01.201 --> 00:08:02.747
Change is hard right.

00:08:02.747 --> 00:08:04.146
We don't love change.

00:08:04.146 --> 00:08:06.108
We avoid it really at all costs.

00:08:06.108 --> 00:08:09.141
Hard right, we don't love change.

00:08:09.141 --> 00:08:09.822
We avoid it really at all costs.

00:08:09.822 --> 00:08:12.629
And so as I had difficulty transitioning to this new spreadsheet, I sort of just chalked it up to.

00:08:12.629 --> 00:08:17.916
I haven't developed the habits yet, I haven't really gotten it down yet, but I'll get there right.

00:08:17.916 --> 00:08:22.855
Just give me a little bit of time, give me more of an opportunity to implement and I should be fine.

00:08:23.959 --> 00:08:25.583
Unfortunately, that's not what happened.

00:08:25.583 --> 00:08:35.933
As I worked through the year and I labored over this spreadsheet, I realized that there was so much more to my difficulties.

00:08:35.933 --> 00:08:51.187
So I suppose my first point and excuse me for speaking a little extemporaneously today, I'm just kind of giving you a brain dump of data collection insights Make sure that you have the right method for you Now.

00:08:51.187 --> 00:08:59.149
You can find no shortage of people on the internet and in the online world who claim to have the perfect solution for you.

00:08:59.149 --> 00:09:00.712
Right, they have the perfect setup.

00:09:00.712 --> 00:09:05.851
All you have to do is this and this, and it'll be rainbows and unicorns from here on out.

00:09:05.851 --> 00:09:08.682
But data's a little bit trickier than that.

00:09:08.682 --> 00:09:12.192
It's not always that easy, and I think we need to keep that in mind.

00:09:12.919 --> 00:09:17.711
As I told my Mastermind members this afternoon, I was working with this spreadsheet.

00:09:17.711 --> 00:09:20.162
It just was not jiving for me.

00:09:20.162 --> 00:09:29.135
For whatever reason, I could not figure it out and, bit by bit, the more I worked through it, the more I began to feel like a failure.

00:09:29.135 --> 00:09:40.889
I took it really personally and I thought, oh my goodness, I am someone who trains school counselors on using data and I can't even get a handle on this.

00:09:40.889 --> 00:09:42.044
What is wrong with me?

00:09:42.044 --> 00:09:44.186
And I felt really bad.

00:09:44.186 --> 00:09:50.232
The upshot of all that was, though, it wasn't me, it was my system.

00:09:50.232 --> 00:09:53.346
My system had me feeling out of control.

00:09:53.346 --> 00:10:02.724
It had me feeling like there were gaps that I couldn't close and it wasn't allowing me to do some of the things with the data that I had been accustomed to being able to do.

00:10:02.724 --> 00:10:11.748
I think, had I had the right system, I would have felt much more competent and much more confident in my data pursuits.

00:10:11.748 --> 00:10:14.634
I would have felt like I had a handle on it.

00:10:15.701 --> 00:10:19.347
So sometimes you have to experiment with different approaches.

00:10:19.347 --> 00:10:25.988
You have to decide how do you like to capture and manipulate your data.

00:10:25.988 --> 00:10:28.212
Is it electronic?

00:10:28.212 --> 00:10:30.888
If so, what way is the best way?

00:10:30.888 --> 00:10:32.447
Is it a software platform?

00:10:32.447 --> 00:10:34.365
Is it a Google Sheet?

00:10:34.365 --> 00:10:35.629
Is it a spreadsheet?

00:10:35.629 --> 00:10:37.525
Is it a time tracking app?

00:10:37.525 --> 00:10:39.110
What do you need to do?

00:10:39.110 --> 00:10:44.413
Do you need to keep that spreadsheet up on a second monitor all day long at your desktop?

00:10:44.413 --> 00:10:50.044
Do you do better when you can enter it on the fly on an iPad or something like that?

00:10:50.044 --> 00:10:54.053
Or do you work better with paper and pencil in hand?

00:10:55.160 --> 00:11:04.788
Lots and lots of variables to this, and what makes it interesting is our brains all work differently, and so there's not really one good prescriptive answer.

00:11:04.788 --> 00:11:14.570
We just kind of have to play and experiment and find out what works best for us, remembering that it takes time and it takes patience.

00:11:14.570 --> 00:11:27.773
That's one of the things that our data discussions cohort is designed to do is to support school counselors in that journey, to give them ideas and help sustain them as they experiment.

00:11:27.773 --> 00:11:34.601
But the number one thing I want you to take away from this is that you have to have a method that works for you.

00:11:34.601 --> 00:11:39.961
If you don't carry your cell phone with you all day, then an app probably isn't the right solution.

00:11:39.961 --> 00:11:48.803
If a spreadsheet makes your eyes cross and makes you feel like you want to stab yourself in the eye, it's probably not the right choice for you.

00:11:48.803 --> 00:11:58.471
Maybe you need old school paper and pencil Lots of options here and everything's okay but we really just have to find what we like and what works for us.

00:12:00.081 --> 00:12:22.943
The second problem that I had with my data collection and this was pretty powerful, it wasn't something I really even thought about until I was in the middle of it was that my systems for data did not feel cohesive, and what I mean by that is when I was collecting information previously, I felt like the story was being generated for me.

00:12:22.943 --> 00:12:28.861
As I went, I had lots of night scraps and charts and all kinds of things populating for me.

00:12:28.861 --> 00:12:41.201
As I entered numbers and I could start to follow my data story graphically, I could see where my time was going and what my days were looking like and where my efforts were mostly directed.

00:12:41.201 --> 00:12:47.913
But when I started with my district spreadsheet, I wasn't getting that same kind of immediate feedback.

00:12:47.913 --> 00:12:55.883
The spreadsheet I was given was pretty much designed to log generic categories and that's pretty much where it stopped.

00:12:55.883 --> 00:13:09.322
It didn't give me any more insight into it, it didn't give me any subcategories, and so I really kind of lost a lot of my excitement for the process because it wasn't painting a vivid enough picture.

00:13:09.322 --> 00:13:19.010
It was kind of like the difference between looking at a photograph in black and white versus a really crisp color photograph.

00:13:19.010 --> 00:13:23.342
Right, there's just a marked difference between those two experiences.

00:13:23.342 --> 00:13:34.528
And for me just tracking the information in the spreadsheet with limited variables and limited output was kind of depressing and I didn't enjoy it at all.

00:13:34.528 --> 00:13:41.889
It wasn't giving me back what I wanted and I really felt like I just couldn't pick that information up and run with it like I had in the past.

00:13:41.980 --> 00:13:53.384
So that's another consideration to make Is your data collection practice sustaining your efforts and is it fulfilling you To go along with that.

00:13:53.384 --> 00:14:02.370
You really need a reason to be collecting that data, not just collecting it because you heard that you should or you think that you should.

00:14:02.370 --> 00:14:07.307
You have to have an intention for your data, otherwise you're not going to get very far.

00:14:07.307 --> 00:14:09.465
Back to the weight loss analogy, right?

00:14:09.465 --> 00:14:22.048
If you don't have a reason to lose weight, if there's not something purposeful and time limited that's driving your efforts right there's that sense of urgency to it You're probably not going to do it.

00:14:22.048 --> 00:14:26.808
That's why so many people try to lose weight for vacations and weddings and major events.

00:14:26.808 --> 00:14:29.168
There is a time constraint to that.

00:14:29.168 --> 00:14:31.044
There's a goal.

00:14:31.044 --> 00:14:34.188
There's a defined endpoint for our efforts.

00:14:34.188 --> 00:14:39.912
That was a big topic of discussion in our data discussions today.

00:14:39.912 --> 00:14:44.486
You know we can teach you all the things, we can show you all the systems.

00:14:44.486 --> 00:14:46.267
We can give you all the tools.

00:14:46.267 --> 00:14:47.961
You all the things.

00:14:47.961 --> 00:14:48.741
We can show you all the systems.

00:14:48.741 --> 00:14:49.443
We can give you all the tools.

00:14:49.464 --> 00:15:09.966
But at the end of the day, if you don't have a true purpose for your data collection, if you don't feel some sense of urgency, if you haven't created defined goals that you're working toward with your data, it's going to feel like just another thing to do on top of the huge mountain of things that you already have that you have to do right and that feels overwhelming.

00:15:09.966 --> 00:15:16.322
So often in our days we feel like I cannot get to one more thing right.

00:15:16.322 --> 00:15:17.024
Bless it.

00:15:17.024 --> 00:15:24.003
So please don't add any more of that feeling when we start trying these data collection efforts.

00:15:24.003 --> 00:15:28.643
It's going to feel like too much, like adding the last straw to the camel's back.

00:15:28.643 --> 00:15:36.669
If we don't have an intention for it, if it does not feel purposeful and useful, we're going to quit, we're going to forget about it.

00:15:40.100 --> 00:15:51.285
Third, which goes along with the idea of having a purpose for your data, for having motivation and continuing, is having the right cues in place.

00:15:51.285 --> 00:15:58.484
This is something that you never hear people talk about, but it is so stinking powerful when we talk about it.

00:15:58.484 --> 00:16:07.110
In the context of school counseling, data Learning, how to track use of time, data is really building a habit.

00:16:07.110 --> 00:16:14.073
So we have to have the right triggers in place to compel us to continue building the habit.

00:16:14.073 --> 00:16:33.852
Whether that is a scheduled alert on your phone calendar reminder, a visual reminder, there's all kinds of things that we talk our masterminders through that they can put in place to jog their memories, to help them develop the data collection habit so that it gets done.

00:16:33.852 --> 00:16:52.432
In my opinion, probably 90% of the success or failure of our data collection efforts on our school campuses boils down to having the right systems, the right motivation and the right cues in place.

00:16:52.432 --> 00:16:57.125
That's why our data discussion sessions are so powerful.

00:16:57.125 --> 00:17:14.959
Our data discussion sessions are so powerful because we come together, we talk about these things in a real-world context, we bounce ideas off each other and then we give ideas to each other so that we're really working collaboratively to create the best outcomes for our members, and that's a really powerful experience.

00:17:16.422 --> 00:17:21.655
No, the point of this podcast is not to get you to join the mastermind, although I would love that.

00:17:21.655 --> 00:17:35.628
The point is you've got to set up a data collection system with the right motivation, the right tools and the right cues that are going to work for you, because y'all this is important.

00:17:35.628 --> 00:17:38.723
Data can really cover the basis for you.

00:17:38.723 --> 00:17:43.059
It can be a great catch-all for you to show you what you're doing.

00:17:43.059 --> 00:17:47.957
You can use it for advocacy, but you have to have the right systems in place.

00:17:47.957 --> 00:17:59.402
You have to have the motivation and the goals to sustain your intensity and your desire, and you've got to put the signals and cues into your day to remind you to do the dang thing, signals and cues into your day to remind you to do the dang thing.

00:17:59.402 --> 00:18:18.804
And then, once you have that, you collect your data, you bring it back to our Mastermind Data Discussions cohort and we walk through that data with you, step by step, to show you the next steps, to help you interpret your data and to create a plan of attack for the next phase.

00:18:18.804 --> 00:18:31.526
We love geeking out on that stuff and we love hanging out with school counselors who love the same thing, and we also love indoctrinating those of you that don't love school counseling data very much.

00:18:31.526 --> 00:18:33.156
Yet we're going to get you there.

00:18:33.156 --> 00:18:37.557
We're going to show you the light and we're going to show you how you can learn to love it too.

00:18:37.557 --> 00:18:46.684
All right, so sustainable systems that work with the way your brain works, maintaining your motivation for what you're doing.

00:18:46.684 --> 00:18:50.165
Have clear-cut goals for what your data is going to do.

00:18:50.165 --> 00:19:02.625
That's something that I lost because I was using predetermined categories instead of chasing my program goals that I had always done and make sure you have those good signals and cues in place.

00:19:02.625 --> 00:19:16.227
I was reminded of that as I revamped my systems, tried to teach myself a new way of doing things and it just hit me like a ton of bricks how super important those cues and signals can be.

00:19:18.497 --> 00:19:29.798
All right, as we're wrapping up this podcast episode, the majority of you probably only have a few weeks left of the school year and there are lots of things going on as we wrap up the semester.

00:19:29.798 --> 00:19:41.208
Before we did our data discussions cohort today, we also had our wrapping up the school year session, where we walked very intentionally through the past year.

00:19:41.208 --> 00:19:43.502
We looked at what worked and what didn't.

00:19:43.502 --> 00:19:46.855
We identified goals and initiatives for the next year.

00:19:46.855 --> 00:19:50.502
We planned them out and we have them on paper.

00:19:50.502 --> 00:19:55.376
Each of us has our individualized goals ready to go.

00:19:56.338 --> 00:20:11.810
When we dismiss for summer, we can go sit by the pool, have some margaritas and not worry about what's going to happen when we get back to campus, and then we can return going full steam ahead without panicking and saying, oh my gosh, what was that thing?

00:20:11.810 --> 00:20:14.201
I'm trying to remember, what was it that I wanted to do?

00:20:14.201 --> 00:20:22.807
Or, worse yet, waiting until later in the year and then having it come punch us in the face and we go dang man, another year went by and I forgot to do that.

00:20:22.807 --> 00:20:24.442
We don't want that to happen to you.

00:20:24.442 --> 00:20:31.002
We're not gonna worry about it because we've got it all planned out and ready to go for 24-25.

00:20:31.002 --> 00:20:35.184
And we would love for you to be able to reap the rewards of that as well.

00:20:35.895 --> 00:20:58.685
The replay is available and in your Mastermind library right now, in addition to the printables that we use to plan and collaborate, as well as a new assessment that's only available to our School for School Counselors Mastermind members our Smart School Counseling Assessment, which is going to be a huge game changer in the school counseling world.

00:20:58.685 --> 00:21:01.416
Our masterminders are getting first peek at that.

00:21:01.416 --> 00:21:10.647
They're already working with it and implementing the suggestions, and it is absolutely astounding the kind of information you can get out of this assessment.

00:21:10.647 --> 00:21:18.762
It's waiting there for you and all you have to do is join us in the School for School Counselors mastermind schoolforschoolcounselorscom.

00:21:18.762 --> 00:21:20.047
Slash mastermind.

00:21:20.047 --> 00:21:26.023
All right, I'll be back soon with another episode of the School for School Counselors podcast.

00:21:26.023 --> 00:21:32.545
In the meantime, I hope you have the best week and a stellar wrap up to your school year.

00:21:32.545 --> 00:21:35.804
Be mindful in your approaches at the end of the year.

00:21:35.804 --> 00:21:39.740
Start planning ahead to 2024-25.

00:21:39.740 --> 00:21:45.269
Think about those data collection efforts and I'll be back soon.

00:21:45.269 --> 00:21:46.451
Take care.

I Blew Up My School Counseling Data: What I Learned

Listen On

Featured Episodes

Recent Episodes