GE Student Submittal Support Guide

This report is generated to meet the Transactional Reporting requirements for GE for the 2024 reporting period.

OnlineSMART generates data for both the Total Amount (TA) and Annual Amount (AA) records for the 2024 GE Reporting Requirements

Location: Reports (Standard) > Annual > Gainful Employment/Program Disclosure > 2024 > NSLDS GE Student Submittal

Reporting Deadline: Jan. 15th, 2025

Generating the report for Submitting to GE

The report must be exported as an Excel file because the Reporting Service generates Microsoft Excel exports in a specific format. Exporting as CSV would not retain the correct format, as header information would be mismatched with the detail records.

1. Export the report from the OnlineSMART system as an Excel 2003 file.
2. Open the exported Excel file in Microsoft Excel.
3. Save the opened Excel file in a convenient location on your computer (.xls or .xlsx format).
   • It is also recommended that the spreadsheet have a unique name so that it can be easily identified during the upload process
     • Note:This file will also be useful when following the steps further down in this article for data verification.

For convenience, an attached spreadsheet (2024 GE Student Submittal Data Verification Workbook.xlsx) details the data values for each column so that you may more easily verify your data prior to submitting. Please click this file above or at the bottom of this article to download it to your computer.

Student Submittal Report Data Verification/Review

Following the instructions in the preceding section for exporting this report, when you open the file in Excel the first row will be the "Header Record" and not necessarily something that needs to be reviewed as part of your data. Regardless, the below table explains what each of these cells in the first row represent:

Student Data (the data you need to review) begins in Cell A2 of the exported Excel file.

To use the attached spreadsheet to more efficiently review and verify the data you are submitting, please follow along with the steps below:

1. Open the attached spreadsheet in Excel, click "Enable Content" if that appears under the Home Ribbon in Excel the first time you open it.
   • Minimize this Excel window for now.
2. Follow the steps above in this article for generating and exporting your 2024 GE Student Submittal Report
3. Click Cell A2 in the exported Student Submittal report, then hit ctrl+shift+end on your keyboard to highlight everything other than the Header Record.
   • Right click to copy this data
4. Minimize the exported Student Submittal report and then bring the previously minimized spreadsheet back up from the taskbar
5. Paste the copied data into Cell A2 of the 'Master Sheet' tab of this workbook.
6. Once the data is pasted into this sheet, select cell A1 and hit Ctrl+Shift+L on your keyboard.
   • This should display dropdown menus for each cell in the first row allowing you to sort and filter each column.
7. Filter Column A for 'AA' only.
8. Click Cell A2, then hit ctrl+shift+end on your keyboard to highlight everything
   • Right click to copy this data
9. Go to the 'AA Records' sheet using the tabs at the bottom and paste the previously copied data into cell A2.
10. Repeat steps 7-9 for TA Records (using the TA Records sheet instead of the AA Records sheet).

You now have two spreadsheets that offer a bit more description of what each field represents, allowing you to more efficiently review your data.

• Please Note: This spreadsheet was built so that you could hover over certain Column Headers to gain a bit more insight into what to expect in specific fields. This information was pulled directly from the NSLDS website linked at the top of this article.