|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