|
University of Colorado at Boulder Display and Uses of NRC Data and Datasets, Calculations, and Issues for Time to Degree and Completion Rates Lou McClelland October 2007
Displays and uses related to faculty lists and faculty questionnaires
· Diagram of our implementation of NRC rules for including a faculty member on a program list (associate, core, new). · Used with chairs, grad program assistants, steering committee, and programmers. Fastest way to explain the rules.
· Faculty and student lists from committees and dissertation-section enrollments – Interactive search by faculty or student name with click-through for all names listed. Really cool. · Departments the main users; useful in explaining why we categorized faculty as we did. · Has no info on faculty department/program; does have for students. · We never got the search by program finished. · Has not been updated. We entered committee data from paper records in the grad school.
· We gathered info on faculty publications, degrees, research funding, students mentored, etc., and uploaded to NRC to pre-populate the faculty questionnaire. All the data were public, so we created a PDF for each faculty member and posted them all. Still available at http://pba.colorado.edu/sasweb/guidegr/NRC/fqifind.htm · Use: Some faculty looked at these to see what they’d be seeing when they opened the NRC questionnaire. A few departments checked accuracy.
· Response rates to the faculty questionnaire, by program - http://www.colorado.edu/pba/nrc/RespRates.xls · Use: ID departments to badger. But the “listed in only one program” caused immense confusion even though we tried to explain and even matched the calcs.
Displays and uses related to the program questionnaire
· Completion grids (questions C16 and C17) and time to degree – requires login/password. · Excel designed for programs and other users with tabs for · List of the students in the population, with names and all data relevant to completion tables and to time to degree. · Short definitions of all fields in the list of students. · The NRC program questionnaire - how questions C16 & C17 appear. · A pivot table with “exact” completion counts – the ones reported to NRC. Can select by program, broad field, gender, ethnic. Can drill down from a cell to see, e.g., who were those 2 students who entered chemistry in 98-99 and took exactly 8 years to graduate. · A pivot table with the cumulative number and percentage receiving degrees within X years – completion rates the way we’re used to looking at them. · Use: We calculated time to degree and completion rates centrally. A few departments looked at their data via this Excel. That led to a minor change in rules/calc method, and to a few corrected records on the student info system. · Use: Made great sense to grad school and was great fun. Let’s look at chemistry, oh we know linguistics is different, yes, this verifies that. · Future: Should update. Should mask or hide individual-student data.
· Collaborative activities of UCB NRC programs - For the NRC program questionnaire, items D13 and D14 combined. We assembled this info centrally working with associate deans. Excel shows all activities of a program, and all programs of a research institute or other entity. · Use: We used heavily in interacting with associate deans. Has been used by some on campus exploring interdisciplinary activity. Has not been updated. Creation was very time-consuming.
· We asked departments/programs a few PQ questions not available to us from publications or steering committee knowledge -- mostly policy questions. We did this with a web questionnaire. See a PDF of the UCB web questionnaire. · Summary Excel of program responses to the UCB web questionnaire of policy questions. Use: To check, to show; a few departments reviewed.
Dataset structures and calculation for time to degree and completion matrices: Issues: Dimensions on which programs vary, affecting TTD and cohort formation (Excel worksheet)
|