| Session Title: Fewer Errors and Faster Results: How to Automate Production of Tables and Reports with Software You Already Own |
| Demonstration Session 715 to be held in TRAVIS B on Saturday, Nov 13, 8:00 AM to 9:30 AM |
| Sponsored by the Integrating Technology Into Evaluation |
| Presenter(s): |
| Humphrey Costello, University of Wyoming, humphrey.costello@uwyo.edu |
| Eric Canen, University of Wyoming, ecanen@uwyo.edu |
| Reese Jenniges, University of Wyoming, jenniges@uwyo.edu |
| Abstract: As evaluators, we frequently face the challenge of accurately and efficiently producing large numbers of data tables. Similarly, we often produce multiple near-identical versions of reports (for example, reports on county-level data for each county in a state). The Microsoft Office Suite contains underutilized tools that allow automated production of tables, graphs, and even whole reports. In the process, these tools can reduce errors and decrease the time and effort involved. This demonstration will cover three steps in the automation process: 1) exporting results from statistical packages so that they are friendly to automation within Microsoft Office, 2) using Excel as an automation tool to present the correct data in each table or graph automatically, and 3) linking the automated elements in Excel with a Word document to produce an automated report. Presenters will provide session participants with sample templates and automation scripts. |