11-14: 2017-2018 Financial Aid Shopping Sheet

Posted Date: November 14, 2016

Author:  Lynn B. Mahaffie, Deputy Assistant Secretary for Policy, Planning, and Innovation, Delegated the Duties of Assistant Secretary for Postsecondary Education


Subject: 2017-2018 Financial Aid Shopping Sheet

Summary: This letter provides updates, HTML specifications, and the Institutional Metric Data file for the 2017-2018 Financial Aid Shopping Sheet.

In July 2012, the U.S. Department of Education (ED) released the Financial Aid Shopping Sheet format and asked institutions to voluntarily commit to supplying the Shopping Sheet to students. As of September 2016, more than 3,000 postsecondary institutions have reported their commitment to adopt the Shopping Sheet. A list of those institutions can be found at: www.ed.gov/financial-aid-shopping-sheet.

Since the release of the Shopping Sheet, our process for updating it has included meeting with stakeholders and reviewing comments submitted to the ShoppingSheet@ed.gov mailbox. The feedback received over the years has indicated that financial aid administrators are becoming more familiar with the Shopping Sheet template and more comfortable providing a Shopping Sheet to students.

As we have done in the past, attached to this Electronic Announcement are all components needed by institutions to complete institutional Shopping Sheets (i.e., HTML specifications and the institutional metric data file, as well as the technical guide and a set of Frequently Asked Questions - FAQs).

HTML Specifications:

Institutions and their software providers may use the attached HTML specifications to produce and populate the Shopping Sheet, using the applicable fields from their existing data systems. The HTML specifications include a “download” button on the Shopping Sheet to allow students to download their student aid offer information into a machine readable format (XML). This XML layout is also attached. We encourage institutions providing students their Shopping Sheet in electronic format to include this feature. Institutions that are delivering the Shopping Sheet in print form may want to remove the “download” button.

For convenience, a PDF version of the Shopping Sheet is also attached. This year, we updated the template to display the Loan Repayment rate instead of the Default Loan rate. This change is reflected on the right side of the template. The Technical Guide includes instructions for adjusting the chart.

Institutional Metric Data File:

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 repayment rate, and the median borrowing figures — are provided in the attached files. The institutional metrics data file is updated on an annual basis. Data used to populate the metrics on the Shopping Sheet comes from ED’s Integrated Postsecondary Education Data System (IPEDS) and National Student Loan Data System (NSLDS), through the College Scorecard. Therefore, accurate institutional reporting to IPEDS and to NSLDS is necessary to ensure that correct information is populated within the Shopping Sheet metric data file and, ultimately, made available to students.

We thank you for your consideration in adopting the Shopping Sheet. If you plan to adopt the Shopping Sheet for the 2017-2018 academic year or wish to provide feedback, please contact us at ShoppingSheet@ed.gov.

Attachments/Enclosures:

2017-2018 Shopping Sheet Template in PDF Format, 116KB, 2 Pages

2017-2018 Annotated Shopping Sheet Template in PDF Format, 928KB, 1 Page

HTML Specifications Package in ZIP Format, 105KB

File Layout in XML Format, 1 KB

Institutional Metrics Data in Excel Format, 561KB

Data File Schema in Excel Format, 11KB

Technical Guide in PDF Format, 2.46MB, 15 Pages

Frequently Asked Questions in PDF Format, 630KB, 5 Pages

 

Publication Date: 11/14/2016

View Desktop Version