Gainful Employment Program Disclosure, Completion and Debt Report

https://youtu.be/0bi1RKmj7NA


Informational video on how to use the OnlineSMART Gainful Employment Program Disclosure Completion and Debt report for gathering information for reporting to Gainful Employment.

PLEASE NOTE: WHEN USING THE ATTACHED MACRO, YOU WILL NEED TO RUN YOUR PROGRAM DISCLOSURE REPORT IN ONLINESMART USING THE IS ACTIVE ON FILTER; YOU WILL RECEIVE INACCURATE MEDIAN DATA IF YOU USE THE START DATE FILTER.

IF YOU RECEIVE THIS ERROR MESSAGE "No Qualifying Students", THIS MEANS THAT NO STUDENTS WERE FOUND THAT COMPLETED IN NORMAL TIME ON OR BEFORE THE END DATE THAT WAS ENTERED THAT ALSO RECEIVED TITLE IV FUNDS
Link to Department of Education:
https://www2.ed.gov/about/offices/list/ope/ge-template.html

Link to Quick Start Guide PDF:
https://ope.ed.gov/GainfulEmployment/GEDT_Quick_Start_Guide.pdf

Subtotal formula for Excel: =SUBTOTAL(103,range)

Median formula for Excel: =MEDIAN(range)