interval graphing image, teacher and student working together

Interval Graphing for Student Success: A Step-by-Step Guide for Educators

Table of Contents

Introduction

Tracking and improving student behavior in school is essential for creating a positive learning environment. One effective method for doing so is through the use of interval graphing. Analyzing this type of data can help educators identify patterns in student behavior, whether you are collecting behavioral baseline data or working on completing a functional behavior assessment. It can also help to create targeted interventions to address problematic behavior. In this blog post, we will explore the basics of data and interval graphing and how it can be used in an educational setting.

 

Note: I am an Amazon Affiliate. If you purchase products through the links provided, I will earn a small commission at no extra cost to you, which helps support the blog.

When to Use Interval Count

Interval counting is a valuable tool for tracking student behavior, especially when it comes to behaviors that occur frequently over a period of time. These types of behaviors can be challenging to monitor continuously, as teachers often have other responsibilities and can’t be solely focused on one student. 

hand holding a phone with a timer on it in a classroom of elementary children

With interval counting, teachers can choose a time frame (e.g. every five minutes) and quickly record whether a student is engaged in the targeted behavior or not during that interval. This method can be particularly useful for behaviors such as off-task behavior or talking out of turn, which may occur frequently but not necessarily constantly. 

 

By taking data from the interval count and using it for interval graphing, teachers can get a more accurate picture of how often these behaviors are occurring and make more informed decisions about how to address them. For example, if a teacher notices that a student is off-task for a significant portion of the observation period, they may decide to provide more frequent check-ins or offer incentives for staying on task.

How is Interval Calculated?

When it comes to interval data collection, there are two methods to choose from: whole interval and partial interval.

Whole Interval Recording

What is Whole Interval Recording?

whole interval recording description on whiteboard

Whole interval recording is a method used to track behaviors that have a distinct beginning and end and occur over relatively long durations. This type of recording is particularly useful for behaviors that we aim to maintain and witness progress over time.

 

In the whole interval method, the behavior is recorded as present only if it is observed throughout the entire interval.

 

To illustrate, let’s consider a scenario where a student’s task is to sit quietly in their seat, and you decide to monitor this behavior in five-minute intervals for thirty minutes. You will do this multiple times per day for at least a week.

 

During each interval, the behavior would be marked as occurring only if the student maintains quiet sitting for the entire five-minute duration. If the student manages to sit quietly for four out of the five minutes, the behavior would not be marked as occurring because it was not sustained for the entire interval. At the end, you would be able to tell what percentage of five-minute intervals the student was able to successfully demonstrate the desired behavior.

Cautions When Using Whole Interval Recording

orange caution cones

It is important to be aware that whole interval data has what we might refer to as a bias toward underestimating behavior. To understand why, remember that whole interval data collection involves dividing the observation period into small intervals and recording whether the behavior occurred throughout each interval. Under this method, behavior is scored as present only if it occurs for the entire duration of the interval.

 

Whole interval data tends to underestimate behavior because it requires continuous engagement in the behavior throughout the entire interval. If the behavior is intermittent or sporadic, it may not be captured or scored as present because it did not occur for the full interval. This method is more suitable for measuring behaviors that are expected to occur continuously.

 

Whole interval data tends to underestimate behavior because it requires continuous engagement in the behavior throughout the entire interval. If the behavior is intermittent or sporadic, it may not be captured or scored as present because it did not occur for the full interval. This method is more suitable for measuring behaviors that are expected to occur continuously.

Partial Interval Recording

What Is Partial Interval Recording?

partial interval recording description on whiteboard

Partial interval recording is a suitable method for tracking behaviors that occur frequently in short bursts and do not have clearly defined beginnings and ends.

 

In partial interval recording, the behavior is recorded as present if it is observed at any point during the interval. Let’s take an example of a student who frequently calls out in class. In this case, whole interval recording wouldn’t be practical because the student’s behavior of calling out is unlikely to last for five minutes straight.

 

Instead, you can opt for partial interval recording to monitor the student’s talking out of turn. For instance, you can use five-minute intervals to track the behavior. In this approach, the behavior would be recorded as occurring if the student talks out of turn even once during the five-minute interval. By the end of a thirty-minute observation period, you would have collected six intervals of data.

 

Analyzing the data would help you assess whether you need to adjust the length of the intervals. For example, if the data reveals that the student talked out of turn in all six intervals during the thirty-minute observation period and you feel that this does not provide a clear enough picture of the behavior’s frequency, you may consider using two-minute intervals instead. This would yield fifteen data points within the same thirty-minute timeframe and potentially offer a more precise representation of the observed behavior.

Cautions When Using Partial Interval Recording

orange caution cones

While whole interval data has a bias toward underestimating behavior, partial interval data has a bias in the opposite direction. Remember that partial interval data collection involves dividing the observation period into intervals and recording whether the behavior occurred at any point during each interval. In this method, behavior is scored as present as long as it occurs at any time during the interval, regardless of the duration.

 

Partial interval data collection tends to overestimate behavior because even brief occurrences of the behavior are counted as present. If the behavior happens frequently but for short durations, it may be counted multiple times within an interval, leading to an inflated estimate of the behavior’s occurrence.

 

Both whole interval and partial interval data collection have their limitations and potential biases. Educators should carefully consider the nature of the behavior being measured and choose the data collection method that aligns best with the characteristics of the behavior in order to minimize bias and obtain accurate results.

Examples of Behaviors That Work Well with Interval Count

Behaviors Best Suited for Whole Interval Data Collection and Interval Graphing

partial vs whole interval examples written on chalkboard in classroom
  • Sitting quietly for a specific duration (e.g., 10 minutes)
  • Engaging in sustained reading for a set period of time (e.g., 20 minutes)
  • Maintaining focus during a class discussion or lecture for a certain duration (e.g., 15 minutes)
  • Following instructions continuously during a task or activity (e.g., 30 minutes)
  • Staying on task and completing assignments without distractions for a specific time frame (e.g., 45 minutes)

Behaviors Best Suited for Partial Interval Data Collection and Interval Graphing

  • Calling out or interrupting during class discussions
  • Hand-raising to participate in class
  • Initiating conversations or interactions with peers
  • Engaging in off-task behaviors (e.g., doodling, daydreaming) during independent work time
  • Demonstrating specific verbal or physical behaviors (e.g., pencil tapping, foot tapping) intermittently throughout a period

 

Remember, the suitability of each method may vary depending on the specific context, behavior, and goals of data collection. It is important to consider the characteristics of the behavior in question when choosing between whole and partial interval data collection, or a different method such as frequency count.

How to Implement Interval Count and Interval Graphing

signpost at the corner of planning and implementation roads

Define the Behavior

Clearly define the behavior you want to observe and record. As always, it’s vital to clearly define the behavior you will be tracking to ensure consistency and accuracy in data collection. If you need help operationally defining target behaviors, see this post: How to Use Behavioral Baseline Data to Set Realistic Goals and Measure Success.

Choose Between Whole and Partial Interval Recording

The choice between whole interval and partial interval data collection depends on the behavior being observed and the goal of the observation. As mentioned above, whole interval recording may be more appropriate for behaviors that need to be sustained over time, while partial interval recording may be more appropriate for behaviors that occur intermittently. Educators should consider the advantages and disadvantages of each type of data collection method to ensure that the data collected is accurate and reliable.

Determine the Time Frame for Observation

woman setting appointments on calendar

When collecting interval data to track and improve student behavior in school, it is important to determine the appropriate time frame for observation and baseline data collection.

 

This time frame should be long enough to provide useful information on the baseline level of the behavior before moving on to the intervention. Depending on the behavior being observed, plan on observing the behavior for a week or more, divided into smaller intervals. 

 

For example, if you want to track a student’s on-task behavior, you may observe the student for multiple five-minute intervals over the course of a week, across subjects and times of day. This allows for a more thorough understanding of the behavior and may reveal patterns that may not be apparent in shorter observations. However, it is important to balance the length of the observation period with the practicality of collecting and analyzing the data.

Choose the Right Tool for Data Collection

partial interval recording form on a desk

There are a variety of tools that can be used to track interval data in an educational setting. One simple method is to use a paper and pencil tally system, where the observer records each occurrence of the behavior during the designated time interval.

 

Another option is to use a digital data collection tool, such as an app or software program, which can simplify the data collection and analysis process. 

 

Some schools also use behavior-tracking software or programs specifically designed for interval counting, which can provide additional features such as automatic data aggregation and graphing. Ultimately, the choice of tool will depend on the specific needs and resources of the school or individual user.

Review and Analyze the Data

Analyzing data trends in student behavior interval data involves examining the patterns and changes in the occurrence of behaviors over time. Here are some steps to help you analyze the data:

woman analyzing interval of behavior data
  1. Data Compilation: Collect the interval data you have recorded, ensuring that it is organized and easily accessible for analysis.
  2. Calculate Occurrence Rates: Determine the occurrence rates for each behavior by dividing the number of intervals in which the behavior occurred by the total number of intervals recorded. This will give you a percentage or rate that represents the frequency of the behavior during the observation period.
  3. Graphical Representation: Create visual representations of the data (interval graphing) using graphs or charts. You can use line graphs, bar graphs, or other visual tools to display the occurrence rates of behaviors over time. The x-axis represents the time intervals (e.g., days, weeks), and the y-axis represents the occurrence rates.
  4. Identify Patterns: Examine the graphs to identify any patterns or trends in the occurrence rates of the behaviors. Look for increases, decreases, or stability in behavior over time. Note any notable peaks or valleys and consider the potential reasons behind these patterns.
  5. Compare Baseline and Intervention Data: If you have collected data during different phases (e.g., baseline phase, intervention phase), compare the occurrence rates before and after implementing an intervention or instructional strategy. Determine if there are any noticeable differences in behavior during these phases.
  6. Interpretation and Conclusion: Based on the data analysis, interpret the results and draw conclusions regarding the behavior trends. Identify any successes or areas for improvement. Consider the implications of the findings and whether adjustments to interventions or strategies are necessary.

 

It’s important to note that data analysis should be conducted in conjunction with a clear understanding of the behavior being measured, the context in which it occurs, and any specific goals or objectives you have set. The analysis process may vary depending on the specific research design, data collection methods, and desired outcomes.

Interval Graphing

When analyzing student behavior using interval data, graphing the data can help identify patterns and trends in the behavior’s occurrence. This approach can be particularly useful when analyzing both partial and whole interval data.

Steps to Partial Interval Graphing in Excel:

hand setting blocks in order
  1. Enter your raw data into an Excel spreadsheet, with each observation recorded in a separate row. Include column headings such as “Date,” “Number of Intervals,” and “Number of Partial Intervals” to keep track of the data.
  2. Add a new column next to the “Number of Partial Intervals” column and label it “Percentage of Partial Intervals.”
  3. In the first cell of the “Percentage of Partial Intervals” column, type in the formula for calculating the percentage of partial intervals: =C2/B2. This assumes that the “Number of Partial Intervals” column is in column C, and the “Number of Intervals” column is in column B. The cell references will adjust accordingly as you copy the formula down the column.
  4. Copy the formula down the “Percentage of Partial Intervals” column for each observation period.
  5. Highlight the columns containing the date and percentage of partial intervals data, including the column headings.
  6. Click on the “Insert” tab at the top of the screen and select the chart type that best represents your data, such as a line chart or bar graph.
  7. Customize the chart as desired, including adding a title, changing colors, and adjusting axis labels.
  8. Once the chart is complete, copy and paste it into a report or presentation.

Steps to Whole Interval Graphing in Excel

  1. Enter your raw data into an Excel spreadsheet. Each observation should be recorded in a separate row. Include column headings such as “Date,” “Behavior,” and “Interval Length” to keep track of the data.
  2. Add a new column next to the “Interval Length” column and label it “Score.”
  3. In the first cell of the “Score” column, type in the formula for calculating scores: =IF(B2>=C2,1,0). This assumes that the “Behavior” column is in column B, and the “Interval Length” column is in column C. The formula checks whether the behavior occurred for the entire interval (score of 1) or not (score of 0).
  4. Copy the formula down the “Score” column for each observation period.
  5. Add a new column next to the “Score” column and label it “Cumulative Score.”
  6. In the first cell of the “Cumulative Score” column, type in the formula for calculating cumulative scores: =SUM(D$2:D2). This assumes that the “Score” column is in column D. The formula adds up all the scores from the beginning of the data set up to the current row.
  7. Copy the formula down the “Cumulative Score” column for each observation period.
  8. Highlight the columns containing the date and cumulative score data, including the column headings.
  9. Click on the “Insert” tab at the top of the screen and select the chart type that best represents your data, such as a line chart or bar graph.
  10. Customize the chart as desired, including adding a title, changing colors, and adjusting axis labels.
  11. Once the chart is complete, copy and paste it into a report or presentation.
  12. That’s it! By following these steps, you can easily graph your whole interval data in Excel.

To Create an Effective and Visually Appealing Graph

effective written in blocks
  • Choose a chart type that accurately represents your data.
  • Label the chart clearly with axis labels, a title, and a legend if necessary.
  • Use colors and design elements purposefully, avoiding overwhelming the viewer.
  • Consider the audience who will be viewing the graph and adjust the design accordingly.

 

Graphing interval data in Excel can help identify patterns and trends in the occurrence of student behavior. For example, you might notice that a student’s off-task behavior decreases over time, or that there are certain times of day when disruptive behavior is more likely to occur. This information can be used to make data-driven decisions to support students and improve outcomes in the classroom.

What are Phase Lines/Condition Change Lines, and Why Should I Use Them In Interval Graphing?

When tracking behavioral data for a student, it is important to consider significant changes that occur either at home or at school. To better understand the impact of these changes on student behavior, it can be helpful to mark a line on your graph to indicate when the change took place. This allows you to identify the variables that may be influencing the behavior in a positive or negative way.

 

Examples of changes could include a new teacher or class assignment, as well as personal life events like relocation, parental divorce, or the initiation or discontinuation of medication. By acknowledging and tracking these changes, you can gain insights into the factors that contribute to shifts in student behavior over time.

line graph with phase line and trend line

How Do I Draw Phase Lines Onto My Graph?

  1. Click within your graph
  2. Click Insert (top left of the page)
  3. Click Shape
  4. Click the line
  5. Draw your line and place it at the date where the change occurred
  6. To make your line dashed, right-click on it and choose Format Shape, then change the dash type. Your line can be solid or dashed. It is mostly a matter of preference. I personally tend to use solid lines for holiday breaks and dashed lines for other changes.

What is a Trendline, and How Do I Include One?

A trendline shows whether the data is trending upward or downward (in other words, is a behavior increasing or decreasing. 

 

To include a trendline on your graph, click on the graph. Then click on the + that will appear in the upper right hand side of the graph and click the box for trendline.

Example of How to Use Interval Graphing to Develop Targeted Interventions

Interval count data can be a powerful tool for educators and behavior specialists to identify problem behaviors and develop targeted interventions. By analyzing the data collected and comparing it to behavior baseline data, you can gain insights into when and where specific behaviors are occurring and determine the appropriate strategies to address them.

On-Task Behavior

class of elementary students raising their hands

Suppose you are tracking a student’s on-task behavior throughout the school day using interval count data. By dividing the day into smaller intervals, such as 15-minute increments, you can record whether the student is on-task or off-task during each interval.

 

  1. Collect Interval Count Data: Document whether the student is on-task or off-task during each interval throughout the day. This data collection establishes a baseline for the student’s on-task behavior.
  2. Create an Interval Graph: Represent the interval count data on a graph, with the x-axis representing time intervals (e.g., 15-minute intervals) and the y-axis indicating whether the student was on-task or off-task during each interval. The graph visually displays the student’s patterns of on-task behavior over time.
  3. Identify Patterns and Triggers: Analyze the interval graph to identify patterns and triggers that may be influencing the student’s off-task behavior. Look for consistent periods or activities where the student tends to be off-task. For example, you may notice a trend of decreased on-task behavior after lunch.
  4. Develop Targeted Interventions: Based on the data analysis, design interventions to address the identified patterns and triggers. In the case of decreased on-task behavior after lunch, you could implement interventions such as providing a short break or incorporating engaging activities immediately after lunch to help the student transition back to an on-task state.
  5. Monitor Intervention Effectiveness: Continuously collect interval count data and update the interval graph to monitor the effectiveness of the interventions. Observe whether the student’s on-task behavior improves during the targeted periods or activities. If the interventions prove effective, consider implementing them consistently. If not, reassess the strategies and make necessary adjustments.
 

Interval graphing enables educators and behavior specialists to visually identify patterns, determine the effectiveness of interventions, and make data-driven decisions. By using interval count data, you can develop targeted interventions to support and improve student on-task behavior throughout the school day.

When Interval Count May Not Be the Best Option

Interval counting is a behavior-tracking method that involves dividing an observation period into smaller time intervals and recording whether a specific behavior occurred or not within each interval. While interval counting can be a useful tool for tracking many behaviors, it may not be the most appropriate option in all situations.

anxious child

One scenario where interval counting may not be suitable is when tracking behaviors that occur infrequently. For example, if the behavior of interest only occurs once or twice during a long observation period, using interval counting may not provide an accurate representation of the behavior. This is because the intervals may not coincide with the occurrences of the behavior, leading to underestimation or overestimation of the frequency of the behavior.

 

Another situation where interval counting may not be the best option is for behaviors that are difficult to define or quantify. For instance, it may be challenging to apply interval counting to behaviors such as fidgeting, restlessness, or anxiety, which do not have clearly defined start and end points.

 

Behaviors such as the ones listed above may require different tracking methods, such as duration recording or event recording, which allow for more detailed and nuanced observation of the behavior.

 

Keep in mind that, while interval counting is a valuable behavior-tracking method, it may not be the most appropriate option in all circumstances. When deciding on a tracking method, it is essential to consider the specific behavior being tracked and choose a method that is most accurate and informative for that behavior. If you would like an overview of the most common types of behavior data collection used in schools, take a look at my FREE resource, Data Collection for Behavior.

Conclusion

Interval graphing is a powerful tool that can help educators track and improve student behavior in school. The benefits of this method are clear: it provides objective, quantitative data that can help educators identify problematic behavior, track progress, and develop targeted interventions. 

 

By using the step-by-step guide provided in this post, you can successfully implement interval counting in your classroom and develop interventions that address specific behavior issues. By continuing to use this method and making data-driven decisions, you can start to create a more positive and effective learning environment for all students.

Ready-to-Use Interval Graphing

Do you struggle with creating accurate and informative interval graphs in Excel? Look no further than Interval in Excel – the ultimate hassle-free solution for educators who want to track and graph student behavior data with ease.

 

With Interval in Excel, you can easily input behavior data and generate customizable interval graphs that help you track progress toward IEP goals and identify behavior patterns. Say goodbye to the time-consuming task of creating Excel graphs and hello to a product that simplifies behavior data collection and progress monitoring.

 

This product is incredibly user-friendly and comes with detailed instructions to help you get started. Plus, it’s fully customizable to fit your specific needs. With Interval in Excel, you can focus on what really matters – your students’ progress and success.

 

Don’t waste any more time struggling with creating interval graphs in Excel. Try Interval in Excel today and experience the difference it can make in your behavior data collection and progress monitoring. Click here to find it now!

Share This Post
Facebook
Pinterest
Email
Print