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”

  1. Ashley Wyckoff says:
    Reply
    Ashley Wyckoff's avatar

    I LOVE the information that you posted here on this page. I would really like to have the monthly spreadsheet that you use to generate this report. I am an elementary school counselor in Tulsa, OK and I think that your blog is EXTREMELY helpful.

    Like

  2. Lauren Joyner says:
    Reply
    Lauren Joyner's avatar

    I would also love a copy of your spreadsheet when you have time. This looks like a tool that would be really helpful. Thank you so much!

    Lauren

    Like

  3. Andrea Cseh says:
    Reply
    Andrea Cseh's avatar

    I would love a copy of your spreadsheet and monthly reports to use. I am the only school counselor for a PK-8th grade school and I serve all 645 students. I find I struggle greatly to keep on top of it all and I’ve wanted to find a way to show my productivity. This sounds perfect! I love the pie chart too!
    Thanks – Andrea

    Like

  7. Marla Hatch says:
    Reply
    Marla Hatch's avatar

    I would love this spreadsheet as well. I will be at two different schools and feel like this would be helpful. Thanks

    Like

  8. Melissa Ferguson says:
    Reply
    Melissa Ferguson's avatar

    Just found your blog today! Love it! I would love a copy of your spreadsheet! I can tell you are going to be a great resource for me :). I just finished my first year as a school counselor and am looking forward to some major prep work this summer!

    Like

  9. Paige says:
    Reply
    Paige's avatar

    Thank you so much for all of this helpful information. I am headed into my second year and am accessing any helpful resources. And wow! This is wonderful! Would you mind sharing this spreadsheet with me? Thank you!

    Like

  12. Myra Brann says:
    Reply
    Myra Brann's avatar

    I just came across this right now. Love it! Awesome way to show data. I am a fairly new counselor at a very needy campus, with 600+ students. This year I will be the only one there. Would you please share your documents with me? myelibrann@gmail.com
    Thanks in advance!

    Like

  17. Pingback: Weekly Data Report Log
  18. Ashley says:
    Reply
    Ashley's avatar

    Hi! I love the information you posted and how you keep track of your monthly data! I would love a copy of your spreadsheet if it is still available. I have to turn in monthly reports to one of my building principals, and I would love the ability to be more descriptive in the reports.

    Like

  23. evangeline says:
    Reply
    evangeline's avatar

    hey i am a new counselor at school for primary section…. i would lik your help too… can i have a copy of your spread sheet too

    Like

  24. Suzanne says:
    Reply
    Suzanne's avatar

    This is a great resource! I’m new to elementary counseling and would love to have this spreadsheet if you don’t mind!

    Like

  26. Sara says:
    Reply
    Sara's avatar

    Hi! Would you be willing to share these? I’m new to middle school counseling, up from elementary, and these look like they’d be super helpful to keep my head on straight! Thanks!

    Like

  27. Melanie Batie says:
    Reply
    Melanie Batie's avatar

    Hi, Can you forward me the template for the monthly use of time. I would love to have the data for my check-in meetings with my principal.

    Like

  28. Dani Hyland says:
    Reply
    Dani Hyland's avatar

    Hey,

    I would love a copy of your data spreadsheet if possible.I am in a school where having a counsellor is new so having to set it all up independently.
    Your blog is an amazing help.

    Like

  30. Makia says:
    Reply
    Makia's avatar

    Hi! I love your blog. I just started at a middle school and our principal is very data driven. Can I receive the template for this? Also for your daily excel sheet which was in another post. I don’t remember which one, but you keep track of each interaction. This would be so helpful!

    Thanks so much!

    Like

  36. Beth says:
    Reply
    Beth's avatar

    Hi , I wonder if I could get a copy of your spread sheet. You have made it look so easy while keeping it really informative.
    Thank you for sharing your ideas

    Like

  45. Hadi says:
    Reply
    Hadi's avatar

    Dear Laura,

    I found your website really helpful and inspiring to school counselor new comers like me.
    If you don’t mind, I would like to request a copy of this monthly report template.

    my email is hadi.tandriawan@gmail.com.

    Thanks in advance.

    Like

  46. Sheryl Smith says:
    Reply
    Sheryl Smith's avatar

    Very thorough. Thank you for such an easy to flow blog.
    I am interested in modeling your
    Although I am at the secondary level, I can use much of your insight and tools. I am very interested in your
    SCHOOL COUNSELING MONTHLY DATA REPORT template.

    Like

  47. Arlene Barangan says:
    Reply
    Arlene Barangan's avatar

    Hi Laura,
    I am amazed by the way you share everything related to the school counselor pieces of stuff. This is so great. I felt so helped by your blog and resources.
    I am a school counselor from Indonesia, Jakarta. I wonder if I could get a copy of your spreadsheet. I found it helpful.
    I also would like to ask about the lesson plan, where I could possibly get the resources for teaching in the class if I’m not a member of ASCA?

    Thanks so much for your help!

    Like

Leave a reply to Rebecca Self (@RebeccaPSelf) Cancel reply