|
| CANCELED: Using Excel for Analyzing Treatment Outcomes in Applied Settings |
| Saturday, May 26, 2012 |
| 8:00 AM–11:00 AM |
| 307 (Convention Center) |
| Area: PRA; Domain: Basic Research |
| CE Instructor: Christina Barosky, M.A. |
| CHRISTINA BAROSKY (The BISTA Center), REBECCA RENEE WISKIRCHEN (ACCEL), LISA M. STEWART (The BISTA Center), LYDIA MACKAY (The BISTA Center) |
| Description: Participants are required to bring a laptop with the Excel application. 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, as well as 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. |
| Learning Objectives: At the conclusion of this workshop, participants should be able to:
Set up specific spreadsheets and input and manipulate data within an Excel 2003 and 2007 spreadsheet
Create graphs for alternating treatment, reversal, multiple-baseline designs, standard celeration, and cumulative records
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
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 a case example that provides opportunities to solve challenges inherent in the Excel 2003 and 2007 and Mac 2011 applications. The case examples will consolidate and increase fluency of the skills taught during the instructional phase of the workshop. |
| Audience: This workshop is appropriate for behavior analysts, practitioners, students, researchers, educational service providers, and others interested in visual displays of data in single-subject research and program progress. |
| Content Area: Practice |
| Instruction Level: Basic |
| Keyword(s): Excel, graphing |