Frequency Tables (Excel)

Item description

These Frequency Tables (Excel)
are perfect for tracking behaviors that are easy to count and have a clear
beginning and end. They are great for:

• collecting data for RTI
• tracking IEP behavior goals
• progress monitoring a BIP

Your purchase of Frequency Tables Excel includes:

• 2 different
  Frequency Recording Forms
• 2022-2023 Daily and Weekly Behavior Frequency
  Graphs
• 2023-2024 Daily and Weekly Behavior Frequency
  Graphs
• 2024-2025 Daily and Weekly Behavior Frequency
  Graphs
• 2025-2026 Daily and Weekly Behavior Frequency
  Graphs

PLUS

• Common Data Collection Methods Quick Overview
• Quick Excel Tips
• Example Behavior Graph with Phase Line and Trend
  Line

How to Use Frequency Tables
Excel

First, choose your preferred
frequency behavior data collection sheet to track your students’ high-frequency
problem behaviors. Use one of the behavior tracking forms included with your
purchase or any other form that you prefer. Then, enter the data from the
frequency recording sheet into the Daily or Weekly frequency graph in Excel.

As your data is entered into the spreadsheet, your graph
will automatically be created or continued, leaving you with
professional-looking graphs to help you monitor the student’s behavior and
response to interventions.

Add Phase Lines to Your Graph

To increase the usefulness of your graph, consider using
phase lines. Add a phase line to the graph when changes occur (medication,
class, living situation, etc.). Over time you will be able to use this
information to help determine the potential causes of behavioral difficulties
or potential reasons for behavior improvement.

Graphs with phase lines can be especially helpful when
working with students who have a Behavior Intervention Plan, as they help you
determine the effectiveness of your interventions. You will find instructions
on how to use phase lines included in your purchase.

*If the behavior occurs so often that getting an accurate
count is impractical, consider using interval recording instead.*

Note

The graph would work in Excel or Google Sheets, but you
must use Excel if you want to enter phase lines, as Google Sheets does not have
this feature.