School Counseling Monthly Data Reports

screen-shot-2017-01-22-at-6-17-11-pm

 

Every May, I create a data report that includes all the things I have done during the school year, and I use this data to create goals and to drive my program forward. If you missed my 3 part data series, you can check out those posts here:

Needs Assessments, Evaluation Methods, and Data, Oh My! Part I: Data Collection

Needs Assessments, Evaluation Methods, and Data, Oh My! Part II: Data Interpretation

Needs Assessments, Evaluation Methods, and Data, Oh My! Part III: Setting & Evaluating Goals

This year, I decided not to wait until the last month of school to collect and examine my data. I’ve been keeping monthly reports on my school counseling duties, which keeps me accountable, gives my principal information on what I’m doing, and offers direction for my program goals. {I also keep a weekly log of my duties, which I will share in a future post.}

My monthly spreadsheet {which I am happy to share with anyone who wants it} contains information on my individual sessions, small group sessions, classroom lessons, and parent contact. As you can see below, October was a busy month!

screen-shot-2017-01-23-at-4-52-20-pmscreen-shot-2017-01-23-at-4-32-48-pm

To create this report, I go back through my case notes and appointment log {see my post on how I schedule sessions for more info on how I keep track of it all}, then I transfer that data to the spreadsheet. This gives me and my principal a clear view of how my time was spent during each month. This will be particularly helpful in the months I am assigned non-counseling duties, such as my role in testing, because the reports will show that my time with students and parents was limited.

To take this information to another level, I created monthly infographics as well. I used Piktochart to create these {which is free!}. In addition to the information in my spreadsheet, I also included a breakdown of direct versus indirect services. Yes, I know that according to ASCA, parent contact would be considered an indirect service because I am not interacting with the students, but I think this way of dividing things would be easier for an administrator to understand {since they typically think of “direct contact” as interactions with students and/or parents}. This is just what worked for me in my particular school, so feel free to adjust your way of presenting data to tailor your specific situation 🙂

Here are my infographics for the month of October:

screen-shot-2017-01-23-at-4-47-08-pm

screen-shot-2017-01-23-at-4-47-25-pm

I will still be creating my more detailed yearly report, but having monthly data on what I am doing {even if it is limited} has been very helpful this year. Again, this is just what works for me, but feel free to reach out to me if you want my spreadsheet or any other information on how I created these reports!

screen-shot-2016-09-15-at-8-11-59-pm

90 thoughts on “School Counseling Monthly Data Reports”

  2. KAVITA SARVESH says:
    Reply

    hey Laura…I am Kavita, an elementary school counselor. Must say, your blog is a storehouse of info….i am impressed and keep consulting yr blog page…consider me as a fan of yours. Look forward to more of your posts

    Like

  14. Deirdre Keane says:
    Reply

    I found this article very useful as I am the first Counselor in our school and I want to be able to demonstrate what my work involves. I would very much appreciate it if you would share your spreadsheets with me! 🙂

    Like

  16. Chrissy Elwell says:
    Reply

    Are you still sharing your data collection spreadsheet? If so can you share with me please!! I’m trying to find a way to gather data more efficiently.

    Like

Leave a comment