For SLPs

Google Sheets for SLPs – Caseload Management, Lesson Planning, Data and More!

Google Classroom and Google tools are becoming more and more popular in classrooms, but what about SLP usage? In this post I share how to take advantage of Google Sheets for SLPs and how to manage everything in one place!

For the past three years, I’ve relied on Google Sheets for much of my caseload management. Recently, I’ve expanded to using it for more and more including data collection, lesson planning, IEP dates, evaluation timelines and more!

I’m going to share with you how I use it and why I love it! For the most visual example of how I use it, check out the video below.

Click on the link below.

***Please do not “Request Access” to the documents. I get an email each time! The method below is much easier on all of us!***

{ACCESS THE GOOGLE SHEETS TEMPLATES HERE}

—-This will show in view only so you’ll need to save it to your drive first. To do this, go to File –> Make a Copy –> then save it to your drive! This will allow you to edit the file as you need for your own caseload.—-


Not a video person? Check out the pictures below. I’ll quickly explain how I use each and if you want more information, feel free to check out the video at any time!

Google Classroom and Google tools are becoming more and more popular in classrooms, but what about SLP usage? In this post I share how to take advantage of Google Sheets for SLPs and how to manage everything in one place!

1) Student Information Sheet

This is how I keep track of who is on my caseload. Write the students’ names, their teacher/grade, special education teacher, weekly minutes, and important dates. The important dates section has conditional formatting so it automatically changes the color of the box based on several variables.

Google Classroom and Google tools are becoming more and more popular in classrooms, but what about SLP usage? In this post I share how to take advantage of Google Sheets for SLPs and how to manage everything in one place!

The IEP Due column changes to yellow when the IEP is due in the next 3 months.

The Previous Evaluation box turns red when the evaluation is due this school year.

The birthday box turns green when the birthday is in the next 15 days.

I got some of these numbers wrong in the video but the text above is accurate. Sorry about that! 🙂

Google Classroom and Google tools are becoming more and more popular in classrooms, but what about SLP usage? In this post I share how to take advantage of Google Sheets for SLPs and how to manage everything in one place!

2) Schedule

This doesn’t need any explanation. Just a simple schedule but it is how I keep track of my schedule with the changes that naturally happen each week 🙂

Google Classroom and Google tools are becoming more and more popular in classrooms, but what about SLP usage? In this post I share how to take advantage of Google Sheets for SLPs and how to manage everything in one place!

3) Daily Plans/Data

This is my most recent addition to my Google Sheets lineup. I use this sheet to plan session and take data. It does take a bit of set up initially but it’s been lifesaving. I make a sheet for each day of the week, Monday through Friday. To set these sheets up, I make a copy of it for each day of the week. Then I write the time in the leftmost column, then the students that I see next to that. In the goals column I write a brief description of their goals. Each week, I print the sheets for each day and keep them in my binder. As I plan what we are going to do, I can write it in the “Plan” column. I also take data in that same box. Why do I love this system? It helps me stay on track with my students goals (they are right there) and it also makes billing easier. After I’ve billed for a student, I cross their name off. Once all of the names are crossed off, I move the sheet to my “SLP Data Binder” that stays on my desk. This binder is just used for old data sheets. This means if I’m carrying the sheet around with me each day, it needs to be billed. I try to bill after school every day so that I don’t get behind. Watch the video on this if you have any questions!

Google Classroom and Google tools are becoming more and more popular in classrooms, but what about SLP usage? In this post I share how to take advantage of Google Sheets for SLPs and how to manage everything in one place!

4) Evaluations

This is a very simple form. Just add in student names and check off when you’re finished with each component of an evaluation. I know many of you follow a different protocol for evaluation so edit this sheet as needed.

Google Classroom and Google tools are becoming more and more popular in classrooms, but what about SLP usage? In this post I share how to take advantage of Google Sheets for SLPs and how to manage everything in one place!

5) Data Sheet

This is a pretty self-explanatory sheet that I used to use. Now I’ve replaced it with the daily data/planning sheets, but for those that like to keep individual student data on their own sheet. I love pairing this with my SLP Reference Sheet freebie so that I can quickly calculate percentages and identify what supports I provided.

Are you interested in using these templates for yourself?

Click on the link below.

***Please do not “Request Access” to the documents. I get an email each time! The above method is much easier on all of us!***

{ACCESS THE GOOGLE SHEETS TEMPLATES HERE}

—-This will show in view only so you’ll need to save it to your drive first. To do this, go to File –> Make a Copy –> then save it to your drive! This will allow you to edit the file as you need for your own caseload.—-

If you have any questions about this, please don’t hesitate to leave a comment or email me.

Interested in other products that will help keep you organized?! Click on any below:

Phonological Cycles resource created by Speechy Musings. This Cycles for Phonology pack includes setting up, progress monitoring, intervention, and assessment!Sentence strips are great. Visuals are great. But sentence strips WITH visuals? The best! Find these in the Speechy Musings Teachers Pay Teachers store.

{thanks for reading}

Do you love all things SLP?

Enter your email below to get the Speechy Musings newsletter. Once you sign up, you'll get instant access to a folder of freebies! Woo!

I respect your privacy. You can unsubscribe at any time.
Shannon

You Might Also Like

Previous Story
Next Story

4 Comment

  1. Reply
    sreip817
    October 19, 2016 at 8:38 PM

    This is great! Thank you for sharing. I just recently switched to the schools after working with adults for two years. For your data plans/data template do you use it to add information for 4-5 students? Most of my groups are 4-5. I love that template but feel like there would be A LOT of information in there

    1. Reply
      Shannon
      October 19, 2016 at 8:42 PM

      Yes I do! It is quite full but I really shorten goal areas for groups of 4-5. I might even write things as succinct as “vocabulary, comprehension, describing” or something. I try to write as much as I can in as small of a font as I can if possible! Hope that helps 🙂

  2. Reply
    Julie Strate
    January 19, 2017 at 4:36 PM

    This is incredible! I am not tech savvy and haven’t used spreadsheets AND then they were sent from heaven!! Thank you Shannon. I use this every day and every time I look at it I send my appreciation your way!!

  3. Reply
    Karen
    February 17, 2017 at 4:20 PM

    Love your ideas and will use in a workshop with full credit given to you. Thanks for sharing.

I'd love to hear your thoughts! Leave a comment below.