|
| Using Excel for Analyzing Treatment Outcomes in Applied Settings |
| Friday, May 28, 2010 |
| 2:00 PM–5:00 PM |
| Travis C/D (Grand Hyatt) |
| Domain: Applied Behavior Analysis |
| CE Instructor: Linda Heitzman-Powell, Ph.D. |
| BRYAN J. DAVEY (ACCEL), DONALD M. STENHOFF (BISTÅ Autism Center), ELEAZAR VASQUEZ, III (University of Central Florida), REBECCA RENEE WISKIRCHEN (ACCEL), CHRISTINA BAROSKY (BISTÅ Autism Center), STEPHANIE A. JOHNSON (STAR, Inc.) |
| 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 (e.g., 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 to promote effective use. At the completion of the workshop attendees will be able to create spreadsheets, data sets and graphs (e.g., alternating treatment designs, reversal designs, cumulative record) and 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 do the following:
1. setup, 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, 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 examples that provide opportunities 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 the visual display of data in single-subject research and program progress. |
| Content Area: Practice |
| Instruction Level: Basic |