Association for Behavior Analysis International

The Association for Behavior Analysis International® (ABAI) is a nonprofit membership organization with the mission to contribute to the well-being of society by developing, enhancing, and supporting the growth and vitality of the science of behavior analysis through research, education, and practice.


48th Annual Convention; Boston, MA; 2022

Workshop Details

Previous Page


Workshop #W63
CE Offered: BACB
Customizing Excel Templates to Save Time Graphing and Interpreting Behavioral Data
Friday, May 27, 2022
4:00 PM–7:00 PM
Meeting Level 2; Room 251
Area: DDA/AUT; Domain: Service Delivery
CE Instructor: Neil Deochand, Ph.D.
NEIL DEOCHAND (University of Cincinnati), MACK S. COSTELLO (Rider University), JAMES HAWKINS (University of Cincinnati)
Description: This workshop will cover the essential and desired features when graphing behavioral data. Discussion will focus on how these features facilitate visual analysis and how we can create visual aids and supplements to assist clinical decision-making when necessary. Participants will learn to create excel templates that contain these features while learning to use an exemplar template that automates phase lines, phase labels, goal lines, date changes, and graph titles so that users can edit their graphs at the click of a button within their spreadsheet, rather than having to move graph elements around in their graph. Using formative excel templates meets the needs of practitioners to automate many of the redundant steps in graph creation, and get back to service delivery.
Learning Objectives: (1) Participants will be able to identify essential elements of a behavioral graph and quality features of a putative "good" chart. (2) Participants will be able to create and use visual aids and supplements to avoid errors when reviewing our behavioral data. (3) Participants will learn how to automate phase change lines, phase labels, and goal levels. They will also learn to create their own templates to adhere to their agency or state requirements for graphing data. (4) Participants will learn when and how to include other visual aids like data points for tracking no data, conditional formatting to highlight weekends, presenting opportunities or duration of observation etc.
Activities: The presentation will contain exemplar recordings for graph creation, as well as live demonstrations of how to incorporate essential elements of graph creation, as well as best chart practices that facilitate visual analysis. Discussion will focus on the evolving standards and requirements for graphs from quality assurance agencies, and how new graphing conventions will likely emerge. Small breakout groups will be used so that participants can engage in guided rehearsal and practice after live graphing demonstrations. Participants will receive a graphing template that contains automated features for graphing behavioral data, and they will learn to manipulate the template to meet their ongoing needs when charting data for their respective clients.
Audience: Intermediate instruction BCaBAs BCBAs BCBA-Ds
Content Area: Practice
Instruction Level: Basic
Keyword(s): Chart Language, Decision-making, Graphing, Visual Analysis



Back to Top
Modifed by Eddie Soh