|
Using Excel for Displaying and Analyzing Treatment Outcomes in Applied Settings |
Saturday, May 23, 2009 |
8:00 AM–11:00 AM |
North 130 |
Domain: Applied Behavior Analysis |
CE Instructor: Timothy Vollmer, Ph.D. |
DONALD M. STENHOFF (University of Kentucky), Bryan J. Davey (ACCEL), Eleazar Vasquez, III (University of Central Florida) |
Description: 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, graphs (e.g., alternating treatment designs, reversal designs, cumulative record), manipulate graph components (e.g., axes, phase change lines). Instructors will provide several models, followed by opportunities for participants to practice with feedback. Additionally, workshop instructors will provide an Excel CD tutorial that will assist participants in future Excel projects. Participants are required to bring a laptop with the Excel application. |
Learning Objectives: At the conclusion of this workshop participants will be able to
1. Setup specific spreadsheets, input and manipulate data within an Excel 2003 and 2007 spreadsheet
2. Create graphs for alternating treatment, reversal, multiple-baseline designs, standard celeration, and cumulative records
3. 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
4. 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 case example that provides opportunities for participants to solve challenges inherent in the Excel 2003 and 2007 applications. The case examples will consolidate and increase fluency of the skills taught during the instructional phase of the workshop. |
Audience: Behavior analysts, practitioners, students, researchers, educational service providers, and others interested in visual display of data in single-subject research and program progress. |
Content Area: Practice |
Instruction Level: Basic |