I presented at the American School Counselor Association in 2016 (New Orleans) and 2017 (Denver). I love sharing out my favorite tech tools and sanity savers to connect with my students, collaborate with colleagues, and be more efficient and effective.
Here is the link to my presentations.
Without fail, anytime I share out about my favorite organizational tools, several school counselors ask me about the best way to manage a counseling log. How do you keep track of students, collect data, and not have it consume all of your time?
There are many resources available for achieving this goal. What works for one counselor may not work for another.
I'm thrilled to share out that after over a decade of being a school counselor, I found a great resource on The Counselor's Cabinet website.
The site offers a free template as a spreadsheet, which I downloaded a couple of years ago and have been using ever since.
Click here to download the free template as a spreadsheet (check your downloads folder for spreadsheet).
Click here to view spreadsheet as a google sheet.
I've tweaked it to meet my needs:
* I used data validation to list the teams (5A, 6D, etc...) I work with as a drop down menu.
* I used data validation to add staff members' names.
* I don't keep track of when I see students (adding it to notes) and instead keep track of the amount of time on task.
* I didn't put groups or lessons on a separate sheet (I combined it into one sheet).
* I used pivot tables to review my time on tasks.
* So that I don't have to scroll down on the sheet, I regularly hid rows.
* I took me some time to distinguish my categories. Some felt repetitive, so I adjusted them to meet my needs.
Here's all the data from my entire school year collected from pivot tables.