|
| Using Excel for Graphing Behavior and Academic Performance of Individuals in Applied Settings |
| Friday, May 27, 2005 |
| 6:00 PM–9:00 PM |
| Private Dining Room 1 (3rd floor) |
| Area: OBM; Domain: Applied Research |
| CE Instructor: Bryan J. Davey, M.Ed. |
| DONALD M. STENHOFF (Utah State University), BRYAN J. DAVEY (Utah State University) |
| Description: Visual display of data in single-subject research is imperative when communicating quantitative relationships and behavior patterns to consumers and fellow practitioners. Excel is an application that allows practitioners and consumers to create spreadsheets and graphical displays. Excel graphs convey effect across various single-subject designs (e.g., multiple-baseline, alternating treatment, reversal, cumulative record). While Excel can be difficult to navigate and master, this workshop will provide participants with hands on training promoting effective use. Workshop mini lessons include how to setup spreadsheets and input data sets, chart wizard navigation, graph construction of all data or select data sets within a spreadsheet, manipulation of graph components (e.g., axes, data labels, phase change lines), and updating data sets and graphs. Instructors will provide several models, followed by opportunities for participants to practice skills with feedback. Throughout the workshop instructors will explain and demonstrate the subtle nuances of Excel. These tips allow for easier Excel navigation and enhance the graphical presentation. Additionally, workshop instructors will provide an Excel CD tutorial that will continue to guide participants in future Excel projects. Participants are required to bring a laptop with the Excel application and strongly encouraged to bring their own data sets to graph during the workshop. |
| Learning Objectives: At the conclusion of the workshop, the participant will be able to: - Set up measurement specific spreadsheets, input data sets, and manipulate data sets within an Excel spreadsheet. - Create graphs for alternating treatment, reversal, multiple-baseline designs, 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 comprehensive case example that provides opportunities for participants to solve challenges inherent in the Excel application. The comprehensive case example will consolidate and increase fluency of the skills taught during the instructional phase of the workshop. Additionally, participants will be encouraged to bring questions in regard to previous Excel experiences. |
| Audience: 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 |