IT should be notified now!

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.

Donate to SABA Capital Campaign
Portal Access Behavior Analysis Training Directory Contact the Hotline View Frequently Asked Question
ABAI Facebook Page Follow us on Twitter LinkedIn LinkedIn

42nd Annual Convention; Downtown Chicago, IL; 2016

Workshop Details

Previous Page


Workshop #W61
CE Offered: BACB
CANCELED: Using Microsoft Excel to Track Behaviour: The B-Trak System
Saturday, May 28, 2016
8:00 AM–3:00 PM
Roosevelt, Hyatt Regency, Bronze East
Area: TBA/PRA; Domain: Service Delivery
CE Instructor: Jacklyn Nobre Peres, M.S.
JACKLYN NOBRE PERES (Safe Management Group Inc.)
Description: The purpose of this hands-on training workshop is to teach behaviour analysts/therapists how to use Microsoft Excel versions 2007 to 2013 to record, analyze, and automate graphs of behaviour including daily frequencies, antecedent-behaviour-consequences, and multi-trial skill training. Participants must come with their own laptop computers with an attached mouse, with Microsoft for Windows Excel 2007 to 2013 installed, and have working knowledge of Excel. The presenter will demonstrate the step-by-step procedures for how to set up worksheets that contains daily frequency, ABC, or multi-trial training data, and data analysis tables and graphs that can automatically update new data added over time. Participants 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, monthly), different behaviour program conditions (e.g., baseline vs. program conditions), medication conditions, special environmental contextual events (e.g., noise level, family contacts),and internal organic conditions (e.g., illnesses, menstrual cycle, psychiatric state), and their relationships to target behaviours. 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, the participant will be able to: (1) use Excel 2007 and 2010 to record behavioural data such as daily frequencies, antecedent-behaviour-consequences, and multi-trial training; (2) record different independent variables that may impact on behaviour, such as behaviour program conditions, medication conditions, environmental events, and internal organic conditions on the spreadsheets; (3) design data analysis cross-tabulation tables that analyzes behaviour data over time and independent variables using Excel; (4) dynamically link the data analysis Excel’s cross-tabulation tables to the raw behavioural data so that new data can be updated automatically; (5) design dynamically linked behaviour graphs using Excel; (6) analyze the effect of interactions among independent variables on behavioural data using Excel; (7) automatically compute different behaviour change statistics (e.g., percent change compared to baseline/previous month/previous condition) using features of Excel’s cross-tabulation tables; (8) acquire B-Trak macro programs that will automatically design data analysis and graphs without the need to program each client from scratch.
Activities: Workshop objectives will be met by the presenter performing step-by-step instructions with participants copying the steps on their own laptop computers with coaches also available in the audience to assist.
Audience: Target audience should have some knowledge of using Excel spreadsheets, but all intermediate and advanced techniques will be taught in the workshop.
Content Area: Practice
Instruction Level: Intermediate
Keyword(s): Hands-On Training, Microsoft Excel, Tracking Behavior



Back to Top
Modifed by Eddie Soh