Data-informed Faculty Staffing and Budgeting
(Return to Workshop Listing)
Presenter(s):
Ti Yan, University of Delaware
Tom Eleuterio, University of Delaware
Requirements:
Laptop required
Software required: Excel 2016; we will also have R and Python codes to share for those who would like them (not required).
Prerequisites:
To participate in this workshop, an attendee will need to:
1. Have Excel 2016 on their laptop.
2. Have work experience gathering, reporting or analyzing personnel and financial data in support of decision making in faculty hiring and budgeting.
3. Have work experience in program evaluation, particularly academic program review, accreditation, budget model assessment, etc.
4. Understand common statistical concepts (i.e., descriptive statistics, frequencies, standard deviation, outliers, box-and-whisker plots).
5. Have experience producing or using data analytic results such as annual reports, data visualizations, dashboards, etc.
6. Have basic to intermediate skills in Excel and experience in at least one statistical analytic tool such as SPSS, SAS or R.
*Please note: in order for the workshop to begin on time and cover all material as described, participants are expected to arrive at the workshop with all software and supplemental materials pre-loaded on to their laptops.
Description:
Institutions' success hinges on effective allocation of faculty and financial resources for instructions, services and research. The utilization of those resources needs to be evaluated at different levels by department chairs, deans, provosts and regional system offices, supported by data with different granularities. This workshop aims to familiarize IR professionals with the usage of CIP-level information to supplement IPEDS data in support of faculty staffing and budgeting. Attendees will learn how to remedy common data quality issues and generate key performance indicators in a pivot table dashboard, using data samples from Delaware Cost Study, Oklahoma Faculty Salary Study, and the Kansas Study of Community College Costs and Productivity.
Intended Learning Outcomes:
Participants in this workshop will:
1. Be led to re-evaluate their current efforts in support of faculty staffing and budgeting decision making, gaining in-depth knowledge to ensure data quality and improve the validity of KPIs in use.
2. Be able to refer to well-established data dictionaries to derive KPIs and make their in-unit data analytic results more compatible with national reports and benchmarks.
3. Learn practices to build their own dashboard to present selected KPIs of interest to different end-users including department chairs, college deans and system offices.