How I use Google Sheets & Forms for my IEP Goal Data Collection

One of the hardest things to do as a Special Education teacher is to group like need IEP goals into a small group, work on IEP goals within that group, and have a way to collect the data without losing your mind at the same time.

Differentiating instruction is easy, targeting everyone's IEP goal but I have found a data collection method that works! No more looking for papers or stickies. I talked last about how (you can check it out here) I use Google to simplify my IEP data collection and progress monitoring.

At the beginning of the year, I group like IEP goals together and create one group to start my data collection. This way I'm collecting the same information on one Google sheet and form instead of seven or twenty. Google has become my go-to data collection method when I'm doing the collection. don't get me wrong it will morph into my students doing the work before too long but even then I can keep updating my information to ensure that no matter what happens when my students do their own data collection--I have accurate information.




Why is using Google Drive such a huge thing for me as my go-to data collection method?

I am paperless.

I do the vast majority of my teacher work in some way online. That means I use my Google Drive for my lesson plans, data collection, observation notes, and behavior tracking. It doesn't hurt that it's free and super simple to use.  Plus I love how easy it is to share with students and teachers. I can also make intervention changes without having to do any data collection by hand.





Chat soon, 







PS: Coming soon--how to use your data collection to make decisions about interventions


IEP Data Collection

Data collection is part of a special education teachers job description. We love it. We hate it. But its important.

WHY???



Data collection helps with determining if students are making progress on SMART Goals. Data helps with determining programming needs and informs you if the intervention is working before its time for benchmarks.

In my short video, I'll walk through why data collection is important, what it is, how you can get it done, and a real-life example of how I collect IEP data in m program. From SMART Goal to the data collection form I use to how I graph the data to finishing a SMART goal deadline with student reflection.

Chat soon,




Organizing Student IEP Data

I'm not sure how much-colored paper I go through but all I do KNOW is that when it comes to students taking ownership of their data and it NOT being part of my mess--is a HUGE deal.

Ever been buried in IEP goal paperwork and wonder where daylight is??? Well...this was me after my first year of teaching. I was spending more time wading through data trying to figure out what was what and who needed what and yeah. '

This was the last time I was going to let the paperwork of the job kill me! So what did I do!!

Out of the flames of burning data rose my student data binders! My Student Data Binders organized all my IEP needs. Need I say more! Let me take you back to the beginning of my teaching career. I kept ALL my IEP data in one huge binder on my desk.

The problem--I couldn’t find anything. It would take forever to plan and write an IEP and taking the data to meeting--don’t even get me started.

My Student Data Binders began with my must haves--IEP data. I did the progress monitoring--UGG! As I simplified how I was collecting data, I made my students do it! This solved like 2 problems--student motivation and giving me back time.

Over the years, I added more for the students to do like attendance, goal setting, and feedback. Soon, that big binder I keep was no longer needed. (Yeah, to getting my desk back!)

One of the special education teachers shared she also used individual binders for everything related to the student's IEP. She kept the current IEP, notes from meets with the classroom teacher and conversations with the student's parents.

As my student data binders started, started to take form I went from black & white to color. (HINT HINT for all your language kiddos, ADHD kiddos, yourself)  But before I went with color paper, I had to get my students to do their own data collection, reflection, and have a voice in their IEPs. This was WAY easier said than done. It’s always a work in progress.



As my student data binders started, started to take form I went from black & white to color. (HINT HINT for all your language kiddos, ADHD kiddos, yourself)  But before I went with color paper, I had to get my students to do their own data collection, reflection, and have a voice in their IEPs. This was WAY easier said than done. It’s always a work in progress.


I started with reading fluency with graphing with just coloring to the correct number. Then came reflection and voice. I slowly added to student responsibles as the year went on. One at a time. First the colors. The colors were chosen as they matched the dividers and the order I wanted to put things in.

Then came SLO. My Student Data Binders make SLO data collection a breeze! (a huge deal in Colorado)


Teaching students to graph is like learning to walk on water! It's not easy but graphing reading fluency or something like that makes it easier. Once students can work the basics they can graph anything but IT TAKES TIME!

I LOVE these graphs--there is enough space to create trend lines and a line for grade level benchmark. (Which in my district is how we look at adequate progress.)

All these lines lend themselves beautifully to student conferences. Goal setting is KEY to not only giving students voice and choice but it is also how you MOVE students and help them to take ownership of their learning.
It's equally as tough to teach and guide students to do anything that resembles self-assessment and reflection. I'm very lucky I get to keep my students for a couple of years before sending them on--this gives me the chance to get them to master self-assessment and reflection.

Everyone starts the year off with the assessment graphs they need (sometimes I put the teacher assessment in there as well) but as the year progresses each student's binder really become theirs.

Student Voice & Choice (Personalized learning) becomes more prominent. Students decide on what IEP goals they wish to focus on as well as set a SMART goal for that goal. This plus the progress monitoring makes the portfolio to share at their IEP meetings. The information in their binders informs present levels of performance and next steps. While providing my students with a critical life skill.

My Teacher Data Binder holds all the assessments I need to progress monitor IEP goals and extra graphs. Gone are the days my IEP assessments are in 3 different places and they are nowhere to be seen. All in one place and ready for me. I love I can grab and go. I don't have to bring a student back to my office to progress monitor.


I love that my student data is all in one place and I can manage it with a 5-minute conversation with the student about what they are working on. Teachers appreciate that I can bring a student binder to a meeting to talk about the whole child. This makes RTI and classroom intervention planning a breeze.



Until Next Time,


National Boards Professional Learning a Summer Blog Challenge

This post is week 2 of 8 in the 8 Weeks of Summer Blog Challenge for educators presented by Hot Lunch Tray. The most important and impactful professional learning I have participated, so far has been achieving National Boards for Professional Teaching. Don’t get me wrong it was three years of videotaping, rewriting, ending late nights or early morning to squeeze in time to write, edit, or cry. I’m really not sure WHY I decided to put myself through that nightmare.

See the source imageAs a Special Education teacher in Colorado, you spend much of your planning on how to be a general education teacher. Which is what NBPT is looking for--four portfolios, two videos, and one three hour test--I learned a lot about myself, my practice and how to move my students. It was hard--really hard but I’m better for it.

The thing is in Colorado achieving National Boards means I’m part of an exclusive club--today there are 45 teachers with National Boards in Exceptional Needs. It’s hard but so worth the time.

Achieving National Boards changed how I looked at my teaching practice. I make time at the end of a week to reflect on my practice. Sometimes even after a lesson didn’t hit a target or if I’m trying something new.

I also encourage my students to reflect on their work--actively. I mean I have built in ways for my students to think about what they did, what needs to change, and how they are doing. It has become more than just check-ins and Marzano. I have added a video or drawing with notes for students to share their how they are doing. They have gotten used to exit tickets and open-ended questions and knowing they have a strong voice in how there group time in structured.

Giving 1st or 2nd graders a voice in how things are run may seem like a crazy thing to do but by giving them a voice in what is read or how they want to demonstrate what they learned means I have student buy-in without having to build in extrinsic motivation system. They know that the “fun stuff” is part of their week and the really fun stuff is earned. Those days are built in and have a purpose such as using “Where’s My Water?” to build perseverance and giving feedback to peers. Or STEM days to work on “soft skills” and higher order thinking without stressing anyone out (including myself!).  (These are the things that mean more to my IEP goals and to my teacher rubric.)

Data is the vain of any special education provider. We love it. We hate it. We can’t live without. After boards-data has taken on a new meaning. I look beyond the number of progress monitoring like the numbers you get from DIBELS or AIMSweb. I look at those soft skills and the feedback students give themselves. I make a point to have students reflect on and set goals based on that data. They see it as a challenge and make it if not exceed the goal they set.

Boards helped me focus my time. If my students can do it than I give them that job. I don’t hold on to student data or student goal sheets or IEP pieces anymore. My students keep all their stuff--reading material, data sheets, IEP pieces, writing and even attendance is kept in their binder.  They LOVE taking care of the anything and everything. Plus, it’s all in one place for me to grab run to a meeting or to write reports or for them to bring when they meet with me.

Boards has challenged me to make the most of my daily practice with students. To help them grow and challenge them to better themselves as they grow up. Even though I thought about giving up as I was in the thick of it I’m beyond thrilled about what National Boards has done for my special education practice. If your thinking about it--DO IT. You’ll grow and your practice will thank you.

Until next time,





About Me

Welcome to my all thing special education blog. I empower busy elementary special education teachers to use best practice strategies to achieve a data and evidence driven classroom community by sharing easy to use, engaging, unique approaches to small group reading and math. Thanks for Hopping By.
Follow on Bloglovin
Special Ed. Blogger

I contribute to:

Search This Blog