Simplify your life - Get more things done - No more overwhelm 

School Counselor Tracker | Google Sheets & Excel Caseload Tracker for School Counselors with Sessions, Small Groups & Lessons

4.9 (408 shop reviews)
<p>A school counselor tracker for Excel and Google Sheets: students with check-in alerts, a session log, small groups with pre/post results, classroom lessons, 504 and IEP deadlines, recommendation letters, referrals, use of time and CEUs, with a dashboard that shows what is due. Includes bonus printable counselor sheets.</p>
Original price was: $14.99.Current price is: $11.99.
View Cart
  • Instant Download: Get your planner now!
  • Google Sheets & Excel: Works in both
  • Become more organized and productive
Secure payment:
Secure payment

Planner description

Check-ins on sticky notes, small group attendance in a notebook, recommendation letter deadlines in your inbox and a use-of-time log you fill in from memory on Friday afternoon? This school counselor tracker puts your whole counseling program in one spreadsheet. You can see who is due for a check-in, which deadlines and letters are close, how your groups are going and how much of your time went to direct and indirect services this month. Works in Excel and Google Sheets, and comes with bonus printable counselor sheets.

What's inside the spreadsheet

  • Dashboard: students on your caseload, check-ins overdue and due soon, sessions this month, tasks overdue and due soon, letters and forms due, referral follow-ups, groups running, lessons and students reached this year, your direct + indirect %, and what is coming up next
  • Students: grade, teacher, focus area, who referred them, 504 / IEP, how often you want to check in, last seen and next check-in, with countdowns and color alerts
  • Sessions: individual, small group, check-in, crisis, parent contact, teacher consult and team meeting, with minutes, topic, follow-up and parent contact
  • Groups: focus, grade, members, sessions planned and held (counted from your session log), progress, and the change between pre and post survey scores
  • Classroom Lessons: grade, teacher, topic, domain (academic, college & career, social/emotional), students, minutes and pre/post scores, with totals for the school year
  • Tasks & Deadlines: 504 and IEP meetings, MTSS / SST meetings, schedule changes, testing and reports, with due dates and countdowns
  • Letters & Forms: recommendation letters, school reports, mid-year reports and scholarship forms, with due dates and sent dates
  • Referrals: outside counseling, school psychologist, community programs and more, with parent consent, follow-up date and outcome
  • Use of Time: log duties and indirect work; your direct, indirect, program planning and other duty minutes for the month, compared with an 80% target you can change
  • CEUs: courses and hours for your renewal cycle, including ethics and required topics
  • A Start Here tab with simple setup steps, plus example rows to show how it works

Bonus printables (PDF, US Letter & A4)

Session notes, a counselor referral form for teachers, small group plan with attendance, classroom lesson log, parent contact log, student info sheet for recommendation letters, monthly session log and a use of time log.

How it works

  • Works in Microsoft Excel and Google Sheets (upload to Google Drive and open with Google Sheets)
  • White cells are for typing; blue-tinted cells calculate automatically
  • Red = overdue, orange = due soon, green = done, sent or finished
  • Dropdowns for students, grades, focus areas, session types, groups and outcomes

Privacy

Designed for student IDs or initials, not names. Keep identifying details out of the notes and follow your district's privacy and FERPA policies. Use-of-time targets, meeting timelines and CEU requirements depend on your district and state, so always check your own.

You will receive

  • School-Counselor-Tracker.xlsx
  • School-Counselor-Sheets-US-Letter.pdf
  • School-Counselor-Sheets-A4.pdf

This is a digital download: download your files from the link in your order email or under My Account > Downloads. No physical item will be shipped. For personal use only; please don't share or resell the files.

Read more
4.9 Great
Average rating based on 408 shop reviews

Reviews

Show more reviews
About Maya
Hey, I’m Maya, I’m Obsessed with notebooks!
Living with my ADHD has its ups and downs, But it taught me the importance of staying organised. Sure, focusing can be tough, but i’m all about finding tricks to make it easier.
Our ADHD cleaning app

Can’t get started on the mess?

Take one photo of the mess. Swish turns it into tiny steps and picks the first one for you.

Download on the App Store Get it on Google Play

Free to start on iPhone and Android