Victims of Our Success: How OIR Survived the Flood of Ad-Hoc Requests for Faculty/Staff Satisfaction Survey Data

Loading...

View/Download File

Victims_of_Our_Success.pdf (2.57 MB)

Persistent link to this item

https://hdl.handle.net/11299/159724

Statistics

View Statistics

Journal Title

Journal ISSN

Volume Title

Title

Victims of Our Success: How OIR Survived the Flood of Ad-Hoc Requests for Faculty/Staff Satisfaction Survey Data

Authors

Goldfine, Leonard S.

Published Date

2011-10

Publisher

Type

Presentation

Abstract

In 2009, the University of Minnesota Office of Institutional research, in partnership with a steering team of select faculty and the Of- fice of Communications launched a massive effort to redesign its biennial HR survey, whose results in past years had been largely ignored by Uni- versity policy makers. In addition to a substantial paring down of the sur- vey instrument, the standard University-, Campus- and College-level re- ports were redesigned to provide more and immediate and actionable in- formation. This sparked a greater demand for more detailed drill- downs. To encourage greater use of this wealth of data, OIR developed an Excel-based ad-hoc report generator to quickly provide results for the seemingly infinite variations on the most commonly asked-for types of reports. To date, since its development less than a year ago, OIR has re- leased over 250 reports to administrators at all levels. This presentation is a demonstration of how a combination of project plan- ning and some clever Excel tools allowed us to quickly and easily prepare customized reports for campus clients. Items that will be discussed in- clude our template/design model, our possibility matrix for determining whether or not a request for drill-down data meets minimum privacy standards, and Excel tools such as pivot tables, lookup tables, and macros that saved OIR from being buried by the fruits of its success.

Keywords

Association for Institutional Research Upper Midwest (AIRUM)

Description

Presented at the Association for Institutional Research Upper Midwest (AIRUM) meeting, Bloomington, MN, October 27-28, 2011.

Related to

Replaces

License

Collections

OIR Presentations

Series/Report Number

Funding information

Isbn identifier

Doi identifier

Previously Published Citation

Suggested citation

Goldfine, Leonard S.. (2011). Victims of Our Success: How OIR Survived the Flood of Ad-Hoc Requests for Faculty/Staff Satisfaction Survey Data. Retrieved from the University Digital Conservancy, https://hdl.handle.net/11299/159724.

Content distributed via the University Digital Conservancy may be subject to additional license and use restrictions applied by the depositor. By using these files, users agree to the Terms of Use. Materials in the UDC may contain content that is disturbing and/or harmful. For more information, please see our statement on harmful content in digital repositories.