Get the Latest Time Saving Resources


From the research to your classroom

Free Template and Tutorial for Graphing Data on Instruction

Data Collection & Analysis | October 4, 2013

Sharing is caring!

Did you know that graphing data for data-based decision making improves your students progress? That’s right, teachers who graph their data have students who make more progress. Yep, that’s what the research says. And of course I’ve said it before. But how and when do you fit this into the day with everything else you have to do?

Taming the data monster, setting up a data system free webinar picture with graph. Click to sign up for the free webinar.
Click the picture to register for the FREE Webinar!

Graphing Data Easily

Actually it doesn’t have to be hard, but it does need to be a system that is completed consistently. You can graph your data and analyze it weekly to see if students are making progress or if you need to make changes.

Yes, I hear the sighs now…but really, I’ve got some tools that can make it easier. I promise. On previous posts I shared a FREE naturalistic data sheet for taking regular data samples. You also got this data sheet if you have taken my FREE webinar on Setting Up a Data System for your classroom.

You can use that data sheet with the free Excel spreadsheet in this post to input your data and it will MAGICALLY (or as magical as I can get with excel which isn’t that magical) graph it FOR YOU! If you have used this tool before, I’ve since updated for the 2019-2020 school year!

And Even Easier

How to graph instructional data: free excel download

And to make it a bit easier, I’ve even made a tutorial to help you use it for graphing data regularly. This is a Quick Win I created for the Special Educator Academy, but I’m sharing it here to help you see how the Excel spreadsheet can help you with graphing data on instruction in order to analyze it.

The naturalistic or group data sheet shared above gives you weekly samples of the student’s performance. But you then do have to take the data off the data sheet and summarize it in some way. This tutorial can help with that.

To help you with graphing data for your classroom, I have created a spreadsheet on Excel (no I’m sorry I haven’t gotten it to work well in Google Sheets). It allows you to input data on correct / independent responses and total opportunities to graph the weekly progress in percentage of correct responding.  This allows you to look at the trend to see if the data is headed in the correct direction and whether it is aimed at meeting the goal.  

Data that is not summarized and graphed doesn't really help your students. Click to Tweet

Sign up for free tips each week in your inbox and grab the Free Excel Download from the Resource Library

Graphing Data Automatic Graphing Excel Template

I try to assure this gets updated every year. It will graph a year of data and the video below will walk you through exactly how to use it.

Grab it from the Free Resource Library. Click below to navigate or join the free library.

To help show how to use it, I’ve broken out this Quick Win from the Special Educator Academy to walk you through how to use it. And if you are a member of the Academy or trying it out in our free trial, there is a quick win on instructional data decision making with a tool you can use to analyze the graph and make sense of what to do or try.

I’ve also created a document you can download with screenshots and notes on how to use it.

And if you liked this quick win, you’ll love our courses and more quick wins in the Special Educator Academy.

This free, on-demand webinar will walk you through the initial steps I talked about in this episode. In an hour I will walk you through how to write data-friendly goals, share how the TIP can help you plan your data, and get you started with some initial steps in setting up a system for your classroom. It also includes free bonus tools at the end as well.

data webinar ad photo
How to graph instructional data: free excel download

5 thoughts on “Free Template and Tutorial for Graphing Data on Instruction”

  1. This is so cool. Is there a way to graph correct responses rather than independence? Many of my students still require a great deal of prompting and are working on fading the prompting. Also, do you have any posts or data sheets for tracking occurrences of behaviors? For example, I track the instances of flopping per day. I’m looking to make a graph to show the history of the behavior and when certain interventions were introduced.



    If you are not concerned about independence, which to me it’s not correct unless it’s independent, you could put that count in the column for independence. There isn’t a way with this to track prompt fading though. I haven’t been able to automate that effectively. It sounds like you are looking for a frequency data sheet for tracking behaviors. I do have several that are available through the Taming the Data Monster book (it has a link to a variety of data sheets used in the book). Hope that helps,

  3. Pingback: Don't Hope! TEACH! Analyze Your Data! | Autism Classroom Resources

  4. Pingback: How to Organize Special Ed Data for Easy Review | Autism Classroom Resources

Comments are closed.

Join our FREE Resource Library

Terms and Conditions checkbox is required.
Something went wrong. Please check your entries and try again.
Scroll to Top