Go to the U of M home page

December 17, 2010

Released: Financial Aid Reports - All Undergraduates

The Office of Institutional Research (OIR) has a new student financial aid report. This new report includes admission and financial aid data for all undergraduate students (degree seeking and non-degree seeking, full and part time) by campus. The reports are by aid year which includes three terms (fall, spring, and summer) and starts with data from Fall 1999. Currently, there are eleven aid years of data available.

Admissions related data includes the number of new student (freshmen and transfer) that have applied, been admitted, and enrolled for an entire aid year (fall, spring, and summer terms).

Financial aid related data includes the number of students receiving aid, PELL Grants, and University Scholarships. Average aid amounts for the year by category is also included. Federal cost of attendance information for new freshmen that are Minnesota residents is also available.

The new reports also include average loan debt amount broken down by Minnesota residents and Non-Minnesota residents. The amount is calculated for those students that graduated during the report aid year. The average loan debt amount is further broken out to include and exclude PLUS (parent) loans. The loan amounts are those processed and captured in the University of Minnesota student systems, and would not include personal loans made by the student or parent. Average Loan Debts are not available prior to Fall 2003.

Special thanks to all the folks in the Office of Student Finance for their help on this new report.

The report can be found here.


December 7, 2010

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/

December 1, 2010

Site Usage - Month of November

This marks the end of the third month live, and the second full month (we released in mid-September).

Visitors
We had 1,824 visits from 997 unique visitors during the month. Of these visitors, 7,210 pages were viewed, an average of 3.95 per visit. The average visitor spent 3 minutes and 36 seconds on the site. The most visitors in one day (98) occurred on Monday, Nov 8th, however, the most page views (509) occurred on Tuesday, Oct 9th. We received visitors 21 countries around the world, including the UK, Japan, UAE and Russia.

visits-november.png

Visitors by Browser: 52%, Firefox / 35%, Internet Explorer / 7.4%, Safari, 5.7% Chrome

Number of Visits by State: 1,376, Minnesota / 42, Illinois / 37, Texas / 36 Wisconsin

25 users visited the site via a mobile device (iPad, Cell Phone, etc).

Content
44% of users who visited the home page ended up looking some sort of Student data, 21% at the Official Enrollment Statistics.

Most Viewed Enrollment Reports: 27.6%, Academic Level / 7% FT/PT Status

Most Viewed Freshman Characteristics Report: 14%, ACT Composite / 9.6% High School Rank

Miscellanea: The Staff page was viewed 296 times. 320 visitors viewed at least five pages. 22% of visitors have browsed to the page over 50 times this month.

Traffic Sources
In October the traffic split was 66% direct / 18% site referral / 16% search engines. This month the traffic split was 59% direct / 21% site referral / 19% search engines, a 6% gain in discovered as opposed to direct.

Top Search Terms (Search Engine(Total Vists): # of visits, search term)
UMN Search (206): 84, institutional research, 44 NSSE
Google (122): 8, nsse university minnesota, 10 university of minnesota enrollment 2010

Top Referring Site (Non-UMN)
en.wikipedia.org: 58 visits

These links were coming from the U of M wikipedia page, for the cited enrollment numbers.

November 30, 2010

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.

November 24, 2010

Tracking File Downloads w/Google Analytics

The November 19th, 2010 Web Standards Meeting featured a presentation on utilizing Analytics, specifically Google Analytics, to enhance your user experience and website usage. This presentation was provided by Nuria Sheehan, CEHD, and Liz Turchin, CCE. Nuria had specifically mentioned something about capturing click events to track PDF file downloads. This is a segment of usage data that we had previously missed, as I have not used Apache log analysis, so I decided to investigate further...

Some Google searching revealed a snippet of JavaScript which would in effect, simulate a standard click via an onclick action. The snippet follows:


onClick="javascript: pageTracker._trackPageview('/downloads/map');



There is an obvious limitation to implementing this solution: you have to manually add an onClick attribute to your links. [More details to this regard on Google Help](http://www.google.com/support/analytics/bin/answer.py?hl=en&answer=55529)

I wanted a solution that would automatically register and track these clicks, without me having to maintain all of the links to these PDFs, Excel documents, etc. Luckily for me, I utilize the [Prototype](http://www.prototypejs.org/) JavaScript framework, which provides many shortcuts to make something like this quite easy.

The end product needed to search the DOM to identify links to PDF and Excel documents and register a click event listener, which would then use the built-in callback function from Google, shown above. Code follows:

*This code should be in an application wide JavaScript file, or in the page's HTML header, after the Prototype file is included.*

// Finds all of the PDF/XLS document links on a page, and enables
// tracking for Google analytics. Known issue, will fail to match
// PDF links utilizing hash to jump to page (eg file.pdf#page=35).
// Also, not compatible with IE6 because of CSS 3.
// More info on the page tracking API:
// http://www.google.com/support/analytics/bin/answer.py?hl=en&answer=55529
function trackFileClicks(){
// Modify file_extensions to include any additional types you
// would like to track (eg .xlsx)
var file_exentions = ['.pdf', '.xls', '.doc'];
file_exentions.each(function(file_extension){
// CSS 3 selector, a[href$='.pdf'], $= implies file ends with '.pdf'
var css_selector = "a[href$='" + file_extension + "']";
// select all of the links w/the current file extension
$$(css_selector).each(function(link){
// Add a click listener to the link, which will send an
// Asynch request to google
link.observe('click', function(e){
var pageTracker = _gat._getTracker('UA-XXXXXX'); //Change to your ID
pageTracker._trackPageview(cleanHref(link.href, file_extension));
});
});
});
}

// Takes the full URL and reduces to only path, and file name sans extension.
function cleanHref(href, extension){
// Found RE on StackOverflow:
// http://stackoverflow.com/questions/27745/getting-parts-of-a-url-regex)
var uri_regex = /^((http[s]?|ftp):\/)?\/?([^:\/\s]+)(:([^\/]*))?((\/\w+)*\/)
([\w\-\.]+[^#?\s]+)(\?([^#]*))?(#(.*))?$/;
var clean_href = href.toString();
//Regex returns array with indexes as follows:
var SCHEMA = 2, DOMAIN = 3, PORT = 5, PATH = 6,
FILE = 8, QUERYSTRING = 9, HASH = 12;
var match_container = clean_href.match(uri_regex)

return match_container[PATH] + match_container[FILE].replace(extension, '');
}


*This code must be on the Header of your page and wrapped with script tags*

document.observe("dom:loaded", function() {
trackFileClicks();
}


If you are using another library like jQuery, it should be quite easy to port this code over. It is important to note that since this utilizes CSS3, a browser which does not support this, eg IE6, will fail. The code could be extended, but you would lose some speed, as you would be required to manually check all of the links via Regex.

**UPDATE**: var pageTracker = _gat._getTracker('UA-XXXXXX'); //Change to your ID This line must be included, intial blog post was missing this, and therefore if the code was used, clicks would not be tracked.

This has been implemented on our site, and has been proven successful! The fix above was required to make it work.



November 19, 2010

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.

system-totals.jpg

"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".

all-above.jpg

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).

more-data.jpg

November 12, 2010

2010 HR Reports, Presentations and HEOA released

2010 HR Data
The HR Employee Counts PDF report has been updated with 2010 data and the Employee and Student Head Counts/Credit Hours for Fall 2010 has been posted. We have also posted an Excel version of this file, available on the HR page.

Fall 2010 Presentations
The presentations from AIRUM 2010 have been posted. The University had six presentations at the event, four of which came from our office. A presentation from NASPA 2010 has also been posted.

Higher Education Opportunity Act
In accordance with the Higher Education Opportunity Act, created in 2008, the University of Minnesota is providing graduation rates by certain federal aid group.

November 2, 2010

Site Usage - Month of October

This marks the end of the second month live. The big releases that occurred in October were the release of the Fall 2010 Enrollment and Freshman Characteristics data, the Enrollment maps Google mash-up, and the Degrees and Certificates Awarded 2010 data. For who are wondering, the usage data is collected and analyzed via Google Analytics.

Visitors
We had 1,994 visits from 1,094 unique visitors during the month. Of these visitors, 9,926 pages were viewed, an average of 4.98 per visit. The average visitor spent 4 minutes and 22 seconds on the site. The most visitors in one day (127) occurred on Monday, Oct 18th, however, the most page views (1,064) occurred on Thursday, Oct 14th. We received visitors from 40 of the 50 states in the United States.

October-US-usage.jpg

Visitors by Browser: 49.6%, Firefox / 36.3%, Internet Explorer / 7.2%, Safari, 6.5% Chrome

Number of Visits by State: 1,567, Minnesota / 43, California / 33, Illinois / 29 Wisconsin

26 users visited the site via a mobile device (iPad, Cell Phone, etc).

Content
50% of users who visited the home page ended up looking some sort of Student data, 28% at the Official Enrollment Statistics. The Fall 2010 Enrollment statistics were viewed 969 times, and 85% of those visits resulted in the viewing of at least one report.

Most Viewed Enrollment Reports: 18.8%, Academic Level / 11.6% Registration Status

Most Viewed Freshman Characteristics Report: 14%, ACT Composite / 11% High School Rank

The Fall Enrollment Map was viewed 118 times.

Traffic Sources
Last month, 85% of people browsed directly to www.oir.umn.edu. As anticipated, this number was reduced, and the number of referrals and searches increased. This month the traffic split was 66% direct / 18% site referral / 16% search engines.

Top Search Terms (Search Engine(Total Vists): # of visits, search term)
UMN Search (174): 39, institutional research, 32 oir
Google (119): 11, nsse university minnesota, 10 university of minnesota tuition history

October 27, 2010

Degrees & Certificates Awarded: 2009-10 Data Released

Degrees & Certificates Awarded: 2009-10

The data for the 2009-10 academic year has been loaded for the Degrees & Certificates Awarded reports. This includes reports by College, Major and CIP Code as well as trend data by degree level, gender, and Student of Color groups.

http://www.oir.umn.edu/student/degrees

October 25, 2010

New Freshman Characteristics: Totals

The data for the New Freshman Characteristics has been updated to include a total row on the percentiles and statistics report for the Twin Cities and Duluth campuses.

Kudos to the users who informed us regarding the missing row.

October 10, 2010

Enrollment Data: Fall 2010 Released

Fall 2010 Data
The Fall 2010 Official Enrollment Statistics and New Freshman Characteristics data has been loaded.

Race/Ethnicity (Multi) Data re-loaded
The Official Enrollment Report for Race/Ethnicity (Multi), the report which also breaks out students who report more than one Race/Ethnicity group, was reloaded. The data counting the international students was incorrect, though the number of affected students was quite low. It should now match the numbers found on the Data Warehouse.

Historical Student Headcounts
The Historical Student Headcounts page was also updated, and corrected. The graph shows only Twin Cities campus, previously the 2009-10 value had 57 extra students from the Rochester campus.


Fall Enrollment Map
We have released a new tool to coincide with the Fall 2010 data, the Enrollment Map. This tool maps the Official Enrollment Home Location Code (HLC) to a latitude and longitude, then using the Google Maps API, places a marker based upon the number of students at the corresponding HLC. Data can be viewed by Term, Campus, Level and College. It is a neat way to visualize the enrollment.

http://www.oir.umn.edu/student/enrollment_map

October 1, 2010

Site Usage - Month of September

Our first "month" live has ended. Since the site launched on September 16th, we have a slightly small data set, but we still have enough data to have some fun with numbers! Enjoy a glance into our site usage...

Visitors
We had exactly 1,000 visits from 579 unique visitors during the month. Of these visitors, 4,279 pages were viewed, an average of 4.29 per visit. The average visitor spent 2 minutes and 55 seconds on the site. The most visitors in one day (92) occurred on Monday, Sept 20th, however, the most page views (544) occurred on Tuesday, Sept 21st. 20% of our visitors have visited the site at least 9 times.

Visitors by Browser: 50.8%, Firefox / 34.9%, Internet Explorer / 7.9%, Safari

Number of Visits by State: 773, Minnesota / 25, Illinois / 15, Texas, Indiana

17 users visited the site via a mobile device (iPad, Cell Phone, etc).

Content
52% of users who visited the home page ended up looking some sort of Student data, 24% at the Official Enrollment Statistics.

Most Viewed Enrollment Reports: 20.3%, Academic Level / 7%, Race/Ethnicity

Most Viewed Freshman Characteristics Report: 14%, ACT Composite / 11% High School Rank

Most Viewed Degrees Awarded Report: 36%, Degrees by College/Major

Traffic Sources
85% of people browsed directly to www.oir.umn.edu. This will likely drop as our site becomes indexed and (hopefully) more highly ranked in search engine results. We have received a small number of hits from Google and Bing, but expect more based on past data.

September 22, 2010

Changes After A Week In...

Our site has been live for one week. While no major changes have occurred, a few minor patches have rolled out. There are two specific changes I would like to mention:

First, the search box in the upper right-hand corner of the screen will yield a search for our site, as well as a UMN-wide search. The default search results will be the OIR site results. Give it a try.

Second, we add the instant feedback poll on the home page. If you scroll down to the bottom of the home page, you should see the question "Was this site useful?" We would appreciate any feedback you have to offer.

Expect to see a post regarding the site usage in the near future. As always, feel free to contact our department with feedback, or suggestions.

September 14, 2010

Site Released - Welcome!

Today marks the first iteration and public release of the redesigned web presence - for the Office of Institutional Research. The redesign has three primary goals in mind: make our data easier to find; increase the web presence of our analysis; meet the eCommunication branding and web standards requirements. We feel that these goals have been met and significantly improve the experience of users have on our site.

The biggest changes to the site are the new dynamic reports. So far, we have converted the Official Enrollment Statistics (aka STIX), New Freshman Characteristics (formerly New Student Characteristics) and the Degrees & Certificates Awarded (formerly Degrees Awarded) from the old PDF static formats to a user driven dynamic format. This new format features two ways to view the data. First, the 5-year trend format where the data are graphically represented, which will enable staff to quickly identify changes over time. Second, the data can be viewed in a 1-year table based format, which allows for easy college by college comparisons. The data can also be exported to Microsoft Excel.

We are also trying to make our survey data more accessible to appropriate University staff. We collect data from national survey sources such as the Student Experience in the Research University (SERU) and National Survey of Student Engagement (NSSE) as well as System-wide surveys administered by us (e.g. PULSE). Up until now, this data has remained available largely for OIR's own internal analyses, but we now hope to provide tools allowing other appropriate University staff to access this data through our site. We plan to release new reports and additional iterations of the site on a regular basis. One of the proposed new features is an online data request system. A few other student data reports are already in development, including Student Performance which would include information on grade point averages and percentages of credits completed. We also plan to add our Human Resource, Financial Aid data and other sources. Please contact our office if you have any suggestions on any data or features you would like to see.

Another change with this project is the web address of the site. If you visit our previous address (www.irr.umn.edu) you will be redirected to the new address, which is www.oir.umn.edu. Please update your bookmarks to reflect this change.

Finally, we would like to thank those throughout the University who helped up in the development of this project - specifically the State of the Student committee, the Usability Services in the Digital Media Lab, the Office of Information Technology - OIA Linux Team and Oracle DBA Team, and the UThink Blog team at the Library. The valuable insight and direction provided by these groups helped guide our project during the development cycle.

This blog will continue to be a source of information about what's happening, works we have published, and general information about the Office of Institutional Research. If you would like to give us feedback, or comments or questions feel free to post a comment on the this blog (U of M users only) or email me, David Peterson: pete2786 at umn dot edu.