How to Use Rate on Excel for Behavior Tracking

If you need to measure behaviors that are difficult to count throughout the day, Rate on Excel is the perfect tool for you. This product provides an estimate of how often a behavior occurs per minute, hour, or day. By tracking the behavior for a short period across several days, you can easily determine the rate of behavior.

Calculating the Rate of Behavior with Rate on Excel

To calculate the rate of behavior, use the provided rate forms to tally how many times the behavior is observed within a given time frame. At the end of the week, enter the total observation time and the number of times the behavior occurred into the dated weekly spreadsheet.

A graph will automatically be created for up to three problem behaviors, which you can use to monitor student behavior and share with parents, students, and administrators, or include as part of your IEP progress report.

Using Phase Lines to Enhance Your Graph

Increase the utility of your graph by adding phase lines, which indicate changes such as medication, class, or living situation. Over time, you can use this information to determine potential causes of behavioral difficulties or improvement.

Graphs with phase lines are especially useful when working with students who have a Behavior Intervention Plan since they can help you determine the effectiveness of your interventions. Instructions on how to use phase lines are included with your purchase.

What’s Included in Your Purchase

Your purchase of Rate on Excel includes three different Behavior Rate Recording Forms, one Rate of Positive Interactions to Corrections Form for self-reflection, and weekly Behavior Rate Excel Graphs through the 2025-2026 school year.

You will also receive a quick overview of common data collection methods, quick Excel tips, an example behavior graph with phase line and trend line, and instructions on how to use phase lines.

Note: The graph is compatible with both Excel and Google Sheets, but phase lines can only be entered in Excel.

If you like Rate on Excel, you might also be interested in my other behavior graphing resources, which can be found here.

If you are looking for just forms but aren't interested in graphing, I have a resource for that, too!

Forms:

• Behavior Data Collection Sheet (s) - 38 Individual Data Sheets
• Classroom Data Collection Sheet (s) For Academics, Digital and Printable
• Progress Monitoring for IEP Goals - Behavior and Academics - Featured

Blog Posts to Learn More About Behavior Data Collection

• How to Use Behavioral Baseline Data to Promote and Measure Student Growth
• How to Use Frequency Count in Excel to Progress Monitor Classroom Behavior
• Duration of Behavior: How to Use Duration Count to Effectively Track Student Behavior
• Interval Graphing for Student Success: A Step-by-Step Guide for Educators
• Behavioral Progress Tracking: The Power of Rate Graphs in Education

Connect with Me!

Please follow me on TeachShare for more exceptional data collection and SEL resources. And remember, your feedback matters! If you decide to make a purchase, kindly leave a review, and TPT will reward you with credits to explore more fabulous resources. Together, let's create a positive and data-informed learning environment for our students.