You are currently viewing ABA Data Analysis Using Google Sheets™

ABA Data Analysis Using Google Sheets™

As behavior analysts, autism therapists, or other professionals in the field of Applied Behavior Analysis, we understand the critical role that ABA data analysis plays in shaping our teaching strategies and driving positive outcomes for our learners. While data entry is a fundamental aspect of our practice, it’s essential to recognize that the real power lies in the insights we get from analyzing that data. In this post, we’ll explore advanced data analysis techniques using Google Sheets™, allowing us to uncover trends and patterns within IEP goal data and make informed decisions that benefit our students.

What is ABA Data Analysis?

Beyond collecting individualized goal data, analyzing program-wide data is essential for BCBA®s or autism or ABA classroom teachers. By examining patterns within students’ skill acquisition data, we can gain valuable insights into the effectiveness of our teaching strategies and programmatic approaches. This ABA data analysis allows us to identify overarching trends, strengths, and areas for improvement within our programs. By regularly reviewing program data, we can make informed data-based decisions about changing our teaching strategies, prompt levels, and/ or materials to better meet the needs of our students. Ultimately, this approach to data analysis enables us to continuously optimize our programs and interventions, to maximize learning outcomes.

Why Google Sheets™?

Google Sheets™ is a versatile and accessible tool for ABA data that many of us are already familiar with, making it an ideal platform for conducting data analysis. Its collaborative features allow for seamless sharing and collaboration among team members. This makes it easier than ever to facilitate communication and coordination in our teaching interventions.

Exploring ABA Data Analysis Techniques

To streamline the ABA data analysis process, I’ve created a low-cost, comprehensive Google Sheets™ template specifically designed for this purpose. This template automates many of the steps involved in data analysis, allowing us to easily identify trends and patterns.

Here are some tips to using this data analysis tool effectively:

  1. Enter in the student’s annual review date, the quarter that their IEP is currently in, and how many goals are achieved, versus in progress or not yet initiated. An immediate visual (in the form of a pie graph) populates, representing the status of all current IEP goals. This gives you an idea of whether or not the student is on track to achieve all or most of their goals by the next annual review date.
  2. Enter in each student’s individual goals (e.g., Imitates Gross Motor Actions), along with the target the student is currently working on (e.g., clap hands), any prompts utilized (if applicable), and the current average of recent data points collected (I typically use the most recent 3-5 data points).
  3. Select from the drop-down menu to choose an actionable ‘next step’ for each teaching program. For example, if recent data is between 70-100% correct, you might choose “Looks great- no change!”. However, if recent data was between 0-35% correct, you might choose “Consider moving back in prompt.” If there is not much recent data, you could select, “This skill needs more practice opportunities.”
  4. Depending on the structure of your classroom, you have either created an actionable to-do list for yourself (begin making those program revisions!) or for your head teacher or other classroom staff member. Completing these reviews for each student on a monthly or bi-monthly basis can ensure that the data collected is not in vain, and that data-based decisions are truly being made.


In conclusion, going beyond data entry to utilize advanced ABA data analysis techniques can provide us with valuable insights into student progress, and inform instructional programming techniques. Harnessing the power of Google Sheets™ can maximize the impact of our interventions and allow us to make data-based decisions.


Caitlin Signature

Leave a Reply