|
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 |
|
|