Counselor Up!
  • Blog
  • About
  • Speaker
  • Author
    • Book Summary
    • Book Discussion Guide
  • Things I Love
  • TPT Store

Making Data Manageable

10/22/2019

6 Comments

 
Many times when people hear “data” – they immediately think “no, not going to happen, I’m done.” I often hear “I care about people and not numbers. My response to that is – good! As you should. Numbers help us to make sure that our work and effort is creating impact and positive outcomes for the people/children that we work with every day. Here are step by step directions to help you create a Data Plan for School Counseling.
It's been one of those months. More on the to-do list than time to do it. Feeling overwhelmed and trying to stay afloat. I know you've been there. That's why I was thrilled to be hosting a webinar through my state association this past Friday on Making Data Manageable. I've talked before about managing your data without losing your mind and organizing your comprehensive counseling program. This is a continuation on those themes. In case you couldn't make it, here are some of my top tips.
Many times when people hear “data” – they immediately think “no, not going to happen, I’m done.” I often hear “I care about people and not numbers. My response to that is – good! As you should. Numbers help us to make sure that our work and effort is creating impact and positive outcomes for the people/children that we work with every day.

Imagine that you decide to take a walk outside. As you are walking, you pick up items that are interesting or beautiful to you. As you’re walking, your hands are full of interesting and beautiful items until they are so full that you can’t hold on to anything. You stop seeing the interesting items and start to feel bogged down by the amount you are trying to carry.
 
This is often what happens with data. We collect **ALL THE DATA** but then we don’t have time to make sense of it. This is a waste of time! If we start our walk saying, “I will only collect 5 beautiful leaves.” Then we will end our walk with what we wanted to have. We will feel more accomplished and less overwhelmed. So…

What's Your Data End Goal?

Many times when people hear “data” – they immediately think “no, not going to happen, I’m done.” I often hear “I care about people and not numbers. My response to that is – good! As you should. Numbers help us to make sure that our work and effort is creating impact and positive outcomes for the people/children that we work with every day. Here are step by step directions to help you create a Data Plan for School Counseling.
We can also begin with the end in mind for data too! Take a moment to jot down for yourself (or share in comments!) what you want to know about the work you do for students. For example, if I am doing an attendance program, I want to know that my students are increasing their attendance. What do you want others to know? Sometimes it might be as simple as "I'm busy and I have a plan!"

Data answers the questions you just identified. The trick is to collect the right data for the question that you asked! Let’s review the three types of data collected within the ASCA National Model. If you’re not implementing the national model fully, it’s still a great resource to help you to organize your program.
 
  • Process (or participation in 4.0) – describes the who/what/when/where. It helps you and your stakeholders know how you spend your time.
  • Perception (or mindsets and behaviors in 4.0) – describes what students learned. This is typically seen in a pre/post test. This data would answer questions about what students know or can do
  • Outcome data – describes discipline, achievement, or attendance. This is usually what our administrators and school improvement teams are looking at. 

Keep Data the Way You Use Data

Many times when people hear “data” – they immediately think “no, not going to happen, I’m done.” I often hear “I care about people and not numbers. My response to that is – good! As you should. Numbers help us to make sure that our work and effort is creating impact and positive outcomes for the people/children that we work with every day. Here are step by step directions to help you create a Data Plan for School Counseling.
Of course, the easiest way to keep data is by incorporating it into your work and organizational processes. If you have to create a whole separate system to use, you’re less likely to keep up with it. I’m going to give you a few examples that I have used. As you see the examples, think about your own systems and consider how you can incorporate data components there. Remember process is keeping track of what/when/where/how. 

How do you keep track of the lessons you teach? I usually use a spreadsheet with hyper links to the google doc lesson plans. (You can see my plans by clicking on the curriculum plans on the side bar.) I print the spreadsheet an put it in a notebook with all my handouts/copies/etc organized by grade level. Whatever system you use, keep track of it! 

If you’re not currently tracking the lessons that you teach, start this year and by the time you end the year, you’ll have a yearlong plan. You will thank yourself later. I like to share this on my website so that parents/teachers/staff can see the scope and sequence of the material that I am teaching students. This says to your stake holders loud and clear – I have a plan and I am implementing it.

I tend to run a high number of groups. I can’t ever remember which kids are coming on what day, so I create a little chart for the week with times, days, and students (with teachers) so I know who needs to be at group and when. I keep this paper on a clipboard in my office that I can grab and run out the door to collect the kids. After the groups are done, I file this piece of paper and by the end of the year, I know every group I ran and who was in it. Then, when someone says that Lizette needs to be in social skills group next year, I know she already was in one!

For individual counseling, I’ve created all kinds of complex systems for keeping track. I even had a form that I filled out that had gender, purpose of session, etc. but I never looked at the data for anything meaningful. It was busy work. I found that the best way to keep track of all those little things I do is to keep a detailed calendar. You can do this paper/pencil or use a google calendar but I can’t emphasize enough how using a calendar for productivity is a game changer. 

Data Informs Our Work

What is perception data in comprehensive school counseling? Perception data key words. How do I know if it's perception data or outcome data.
Let’s think now about perception data. Perception data tells us what people think they know, believe, or can do. It also informs our work. It might tell us the why of our outcome data. For example, if you are working to increase achievement levels, you might include a pre/post test on study skills. You look at your outcome data and see that achievement did not go up at the level you set in your goal. When you look at the perception data, you see that students’ responses on the question “getting good grades is important to me.” You might decide to increase the work you are doing with this group of students on relating academic achievement to achieving their goals.

It can be tricky because when we are working with teachers, they stop at perception data. Once a student has learned the material, it is a success. For counselors, we want to see that students have learned the skills and then apply them to improve their behavior, attendance, and achievement. 

​These are called outcome data. A general rule is that this data is collected for you. If you are creating a tool to collect data, it’s probably not outcome data. You will see these types of data in your School Improvement Plan and hear others speaking about improving these data points. This is a great place to start when deciding what data to explore – your SIP Team spends a lot of time looking at data and determining priorities, use that work as your starting place.
 
Make sure that you are connecting the outcome data back to the purpose of the activity. Whether it’s a classroom lesson or a small group, you’ll want to think about what changes in behavior, attendance, or achievement relate to the skills that students will acquire. 

Make a data plan in comprehensive school counseling. How to determine what data to collect.
Let’s practice! Your SIP team has identified attendance as an area of focus for your school. Your principal asks you to work with students with 15 or more absences.
 
Your process data is the list of students with 15 or more absences. Is this a reasonable number of students for you to work with? I’ve worked with schools where that would be over 100 students. Other schools, the number would be much more reasonable. If it’s not a reasonable number for you – you can think of another level of data, like students who are below grade level. 

When you make a plan for how to work with this group of students, you are creating a hypothesis about the skills students are needing in order to make a change in the outcome data. Your perception data will relate to this skill acquisition. As always, we have data we want to know (maybe why students are absent/barriers) and what we want others to know (maybe what skills students learned in their work with you).
 
In this example, I decide to run a resiliency group that builds skills for taking care of yourself, setting goals, and connecting school to larger goals. I create a pre/post test for perception around these skills. When I write the goal (and this can be the same as your Professional Development or annual goal for your evaluation!) – I will use SMART goal language. This goal must be grounded in behavior/discipline, attendance, and achievement. ASCA has a smart goal template that can be very helpful in writing your smart goal. 

Imagine now your conversation with your principal about your role as a school counselor. If you are able to connect to their work and emphasis in the SIP plan and share quantifiable outcome data, how would that change your conversations? I encourage each of you to determine one goal for this year and select process, perception, and outcome data. Start with one and you can always add more next year. Start now.
Picture
Many times when people hear “data” – they immediately think “no, not going to happen, I’m done.” I often hear “I care about people and not numbers. My response to that is – good! As you should. Numbers help us to make sure that our work and effort is creating impact and positive outcomes for the people/children that we work with every day. Here are step by step directions to help you create a Data Plan for School Counseling.
6 Comments
Melek
11/13/2019 05:03:00 pm

Hi Rebecca, I have benefited so much from your informations, thank you for that. I struggle making the connection or showing the connection with process data to outcome data. Would you please share more examples from your work?

Reply
Rebecca Atkins
11/15/2019 08:44:16 am

Hi Melek - thanks for your kind words. Perception data is the information that students learned (ASCA mindsets and behaviors). Outcome data is how their behavior, attendance, or achievement has changed. You're not conducting a research study - you don't have to "prove" causal relationship!

An example would be that you teach 9th graders about study skills:
"Use time-management, organizational and study skills" (M&B). The perception data would relate to an increase in time management, organization or study skills (maybe a pre/post test), the outcome data might be increase in # of 9th graders passing all core classes.

Reply
Melek
11/17/2019 02:08:21 pm

Thanks a lot!

Matthew Pluta
8/13/2022 09:26:53 am

Dear Rebecca,

There was a TBT item mentioned in a different blog post. It was a data-driven counseling package with programs that display and organize data (I think). Would you be able to direct me to that resource on your TPT page? I am interested in purchasing it. Thank you for your help!

Sincerely,

Matthew

Reply
Rebecca Atkins
8/15/2022 06:01:42 am

Hi Matthew, I think you are looking for this: https://www.counselorup.com/blog/comprehensive-counseling-like-a-boss

Have a great week!

Reply
Matthew Pluta
8/17/2022 07:27:40 am

Thank you!

Reply



Leave a Reply.

    Picture
    Picture
    Picture
    Picture
    Picture
    Picture

    Rebecca Atkins

    Welcome to my blog where I talk about all things school counselor and encourage others to Counselor Up!

     Subscribe in a reader

    This website uses marketing and tracking technologies. Opting out of this will opt you out of all cookies, except for those needed to run the website. Note that some products may not work as well without tracking cookies.

    Opt Out of Cookies
    Picture

    Interrupting Racism: Equity and Social Justice in School Counseling

    Links may be affiliate links. If you link and purchase, I may receive compensation at no additional cost to you. Thanks for your support of Counselor Up.

    Categories

    All
    ASCA National Model
    Behavior
    Counseling Career
    Equity
    Freebies
    Groups
    IMO
    Individual Counseling
    Just A Little Thing
    Lessons
    Office
    Organization
    Parent Book Club
    Parent Communication
    Professional Development
    #tbt
    Technology

    Archives

    July 2021
    June 2021
    August 2020
    June 2020
    May 2020
    November 2019
    October 2019
    September 2019
    August 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    June 2018
    April 2018
    March 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014