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.


41st Annual Convention; San Antonio, TX; 2015

Workshop Details

Previous Page


Workshop #W21
CE Offered: BACB
Using Microsoft Excel to Track Behavior: "The B-Trak System"
Friday, May 22, 2015
8:00 AM–3:00 PM
205 (CC)
Area: TBA/PRA; Domain: Service Delivery
CE Instructor: Bruce Linder, Ph.D.
BRUCE LINDER (Safe Management Group Inc.)
Description: The purpose of this hands-on training workshop is to teach behavior analysts/therapists how to use Microsoft Excel versions 2007 to 2013 to record, analyze, and automate graphs of behavior including daily frequencies, antecedent-behavior-consequences, and multi-trial skill training. Participants must bring their own laptop computers with Microsoft for Window's Excel 2007 to 2013 installed with an attached mouse and have working knowledge of Excel. The presenter will demonstrate the step-by-step procedures for how to set up worksheets that contain daily frequency, ABC, or multi-trial training data, and data analysis tables and graphs that can automatically update new data added over time. The participant will learn how to use Excel to create data analysis cross-tabulation tables and graphs that are dynamically linked to the raw data to enable quick analyses of multiple independent variables, such as time (daily, weekly, monthly, quarterly, annually), different behavior program conditions (e.g., baseline vs. program conditions), medication conditions, special environmental contextual events (e.g., noise level, family contacts, etc.),and internal organic conditions (e.g., illnesses, menstrual cycle, psychiatric state), and their relationships to target behaviors. The presenter will perform each step on his computer and the learner will be prompted to match that step with corrective feedback.
Learning Objectives: At the conclusion of the workshop, participants should be able to: (1) demonstrate how to use Microsoft Excel 2007 to 2013 to record behavioral data such as daily frequencies, antecedent-behavior-consequences, and multi-trial training; (2) demonstrate how to record different independent variables that may impact behavior, such as behavior program conditions, medication conditions, environmental events, and internal organic conditions on the spreadsheets; (3) design data-analysis, cross-tabulation tables that analyze behavior data over time and independent variables using Excel; (5) dynamically link the data analysis in Excel's cross-tabulation tables to the raw behavioral data so that new data can be updated automatically; (6) design dynamically linked behavior graphs using Excel; (7) analyze the effect of interactions among independent variables on behavioral data using Excel; (8) automatically compute different behavior change statistics such as percent change compared to baseline/previous month/previous condition using features of Excel's cross-tabulation tables; and (9) acquire B-Trak macro programs that will automatically design data analysis and graphs without the need to program each client from scratch.
Activities: The presenter will perform each step in the above training on his computer, and learners will be prompted to match that step on their own computers with corrective feedback when needed.
Audience: BCaBAs, BCBAs, and BCBA-Ds, behavior analysts, and behavior therapists. Registrants should bring a laptop (or device containing access to Microsoft Excel) to this workshop.
Content Area: Practice
Instruction Level: Intermediate



Back to Top
Modifed by Eddie Soh