Released: 2011-2012 Common Data Set

The 2011-2012 Common Data Set file is now available for download. Staff member Andrea Galliger has provided a short description of the file:

The Common Data Set (CDS) is a set of information whose content and definitons are agreed upon by data providers in the higher education community as well as publishers represented by the College Board, Peterson's, and U.S. News & World Report. These efforts are aimed at reducing the reporting burden on data providers while improving the accuracy of the information provided. An updated Common Data Set is produced once each academic year.

For more details, visit the Common Data Set Initiative web site:

http://www.commondataset.org/

Students Studying Abroad: Summer 2011 Term Loaded

The Students Studying Abroad: Summer 2011 Term data has been loaded. This added all of the May Session 2011 and Summer Session 2011 enrollment, which is about 50% of the study abroad enrollment for the University of Minnesota.

Dimensional Enrollment Data

We have recently release a tool that allows one to create a custom pivot table for our enrollment data. This allows each of the nine dimensions, Term, Campus, College, Level, Class, Ethnic Group, Gender, FT/PT Status and Registration Status to be shown in many different ways, at the same time, on a table. This can answer common multi-dimensional questions our Official Enrollment reports cannot, for example, viewing the enrollment Gender by Ethnicity.

How this works
Under our student data page, you will see the link to the Fall Student Enrollment Pivot Reports. That link will bring you to the index page. We have provided two commonly asked reports, Gender over Ethnicity by Term, Campus, College and Ethnicity over Registration Status by Term, Campus, College, Level. On the right, you see a link to Build your own table..., this will bring you to the tool. Once there, you are able to drag and drop the dimensions to appear as a filter, column header or appear per row.

The first release of this tool used an older JavaScript library, so the drag and drop functionality was inconsistent and quirky. The old library has been replaced by the latest industry standard and should behave consistently across browsers and platforms. Mobile users will have to use the pre-build reports as the drag and drop functionality does not work on a non-traditional browser.

How do I see "All Campuses" or "All College" for a campus?
In this case, you would simply exclude the Dimension for which you want to see "All". For example, to see All Campuses enrollment by Gender and Ethnicity, pick "Term" for a filter, "Gender" for the column and "Ethnic Group" for the rows.

How does the drag and drop interface work?
A demonstration video is provided on the report page. The demo is based on the non-upgraded drag and drop framework for the HR Headcount reports, but the remains mostly relevant.

Site Update 5/11/2011

This morning we have released two new reports and enhanced the functionality of two reports.

New Reports
Fall Student Enrollment Pivot Reports: This tool brings the drag and drop functionality and ability to cross variables to the enrollment data. We have released the past three Fall terms, but for the next term, we will release the previous five Fall enrollment numbers on the tool, Fall 2007-Fall 2011. This release is coupled with an improvement to the drag and drop interface.

Students Studying Abroad: This report using the DW Education Abroad system to show the number of University students participating in study programs in each country for a given Academic Year and Campus.

Enhanced Reports
Fall Enrollment Map: The Enrollment data is now split into county, state and country level intensity maps, as well as normalized by the population of the counties.

HR Employee Count: The improvements made to the drag and drop interface for the Fall Enrollment also applies to the HR Employee count reports.

A detailed explanation of each of the reports will be released in the coming weeks.

Enrollment Data: Fall 2010 Registration Status Error

An error was found in the Fall 2010 enrollment Registration Status. Due to an logical error in the loading of the University's Data Warehouse table, 552 students were counted as Re-admit when in reality they were Continuing. The data on our Enrollment Reports and the Data Ware house ps_dwsa_stix_1109_pr table will be corrected in the near future.

Released: 2010-2011 Common Data Set

The 2010-2011 Common Data Set file is now available for download. Staff member Andrea Galliger has provided a short description of the file:

The Common Data Set (CDS) is a set of information whose content and definitons are agreed upon by data providers in the higher education community as well as publishers represented by the College Board, Peterson's, and U.S. News & World Report. These efforts are aimed at reducing the reporting burden on data providers while improving the accuracy of the information provided. An updated Common Data Set is produced once each academic year.

For more details, visit the Common Data Set Initiative web site:

http://www.commondataset.org/

Released: HR Employee Count Tool and Student Aid Profile

HR Headcount Tool
The next iteration of our web-based reports has been released. This time the Human Resource Employee Headcount PDF was the subject of the conversion. These reports offer more flexibility than the student data in terms of presentation. We have three pre-built reports, one of which is based on the PDF as well as a tool which allows users to drag and drop dimensions to view that data to their liking, based on the concept of an Excel pivot table.

View the web-based HR Employee Headcount reports.

Student Aid Profile
We have released a new report regarding student financial aid. Some of the data included: PELL grants, work study, and loans. This data can be found on the Student Data page, under Student Aid Profile, and is available for the past two years.

More details on both of these will be coming in the next few weeks.

Student Data Enhancements

System-wide Totals
The enrollment reports now show a University of Minnesota System-wide total when viewing the Headcount Data (the reports on the left-hand column which show one term of data). This had been requested for those who work on a system level. Previously, one would have been required to add up each of the Campus totals to get the system total.



"All on one page" report
One change a few people had requested was the ability to see all of the dimensions we made available in the Headcount reports available on one page, so it could be printed. We have added the ability to do just this. If you would like to utilize this, find the link on the bottom of the left-hand column which says "All of the above on one page".



Data to Fall 2000/Fall 2001
The Official Student Enrollment data and the New Freshman Characteristics data had been limited to Fall 2005 due to limits of our trend data. We have now opened up the one-term reports for all the available terms (Fall 2000 for Enrollment, Fall 2001 for Freshman Characteristics).