Posted Date: January 18, 2013

Author:  David A. Bergeron, Acting Assistant Secretary for Postsecondary Education

Subject: Institutional Metric Data File for the Financial Aid Shopping Sheet

Note: Attachments to this announcement were updated in February 2013.

This Electronic Announcement provides the institutional data necessary to implement the Financial Aid Shopping Sheet (Shopping Sheet) for the 2013-14 award year. The Secretary of Education first shared details about the Shopping Sheet on July 24, 2012 (http://www2.ed.gov/policy/highered/guid/secletter/120724.html).

Institutions and their software providers produce the Shopping Sheet using the HTML specifications provided in an Electronic Announcement posted on September 28, 2012 (http://ifap.ed.gov/eannouncements/092812ImplementoftheFinancialAidShopSheet.html). The student information on the Shopping Sheet is populated using the applicable fields from institutions’ existing data systems. The data and information necessary to populate the institutional metrics section of the Shopping Sheet — the graduation rate, the loan default rate, and the median borrowing figures — are provided in the attached files. In addition, this announcement includes the image files necessary for when there is no graduation rate data or cohort default rate data available for a particular institution.

As described in Dear Colleague Letters GEN-12-12 and GEN 12-17, all institutions are encouraged to use the Shopping Sheet format as part of their financial aid awarding process beginning with the 2013-14 award year.  In addition, the Shopping Sheet will help institutions that have agreed to comply with the Principles of Excellence Executive Order 13607 meet the requirement in section 2 (a) by providing prospective students who are eligible to receive Federal military and veterans educational benefits with a personalized and standardized form displaying financial aid information.

Background information on the Shopping Sheet and other resources are available on the Financial Aid Shopping Sheet Web page at: http://www2.ed.gov/policy/highered/guid/aid-offer/index.html.

We appreciate your continued efforts to provide clear information to inform students' educational choices.  Please direct any questions about the Shopping Sheet to ShoppingSheet@ed.gov.

Attachments/Enclosures:

Implementation Overview in Word Format, 171KB, 4 Pages

Data File Schema in Excel Format, 28KB

Institutional Metrics Data in Excel Format, 1.52MB

Image for No Graduation Rate Data in GIF Format, 3KB

Image for No Cohort Default Rate Data in GIF Format, 4KB

   

End of Page