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.


38th Annual Convention; Seattle, WA; 2012

Workshop Details

Previous Page


Workshop #W86
CE Offered: BACB
CANCELED: Using Excel for Analyzing Treatment Outcomes in Applied Settings
Saturday, May 26, 2012
8:00 AM–11:00 AM
307 (Convention Center)
Area: PRA; Domain: Basic Research
CE Instructor: Christina Barosky, M.A.
Description: Participants are required to bring a laptop with the Excel application. Visual display of data is imperative when communicating functional relationships and intervention outcomes with consumers and fellow practitioners. BCBAs are expected to be skillful in using graphs to convey results. However, simply possessing knowledge of graphical displays may not transfer to effective or efficient software use. Excel is an efficient way for behavior analysts to create graphs. Excel graphs convey effect across multiple-baseline, alternating treatment, and reversal designs. In addition, Standard Celeration Charts and cumulative review graphs are often used to display client progress. These graph types are often used to display interview results (e.g., FAST, MAS), preference assessment, structural and functional analyses, treatment (i.e., DRA, DRNO, FCT, etc.), and discrete trial program outcomes. While Microsoft Excel 2003 and 2007 can be difficult to use, this workshop will provide participants with hands on training promoting effective use. At the completion of the workshop attendees will be able to create spreadsheets and data sets, as well as graphs (e.g., alternating treatment designs, reversal designs, cumulative record), and manipulate graph components (e.g., axes, phase change lines). Instructors will provide several models, followed by opportunities for participants to practice with feedback.
Learning Objectives: At the conclusion of this workshop, participants should be able to:

Set up specific spreadsheets and input and manipulate data within an Excel 2003 and 2007 spreadsheet

Create graphs for alternating treatment, reversal, multiple-baseline designs, standard celeration, and cumulative records

Use the chart wizard, construct graphs of all data or select data sets within a spreadsheet, and update databases and graphs as data collection continues

Manipulate graph components (e.g., axes, data points, data paths, secondary axis) and use drawing tools to insert additional components (e.g., arrows, data labels, phase change lines, boxes)

Activities: Participants will be provided concise instruction and several models, followed by two case examples completed with instructor support to ensure skill acquisition. Finally, participants will complete a case example that provides opportunities to solve challenges inherent in the Excel 2003 and 2007 and Mac 2011 applications. The case examples will consolidate and increase fluency of the skills taught during the instructional phase of the workshop.
Audience: This workshop is appropriate for behavior analysts, practitioners, students, researchers, educational service providers, and others interested in visual displays of data in single-subject research and program progress.
Content Area: Practice
Instruction Level: Basic
Keyword(s): Excel, graphing



Back to Top
Modifed by Eddie Soh