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)
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)
Client Support Guide for GE Program Disclosure 2019.pdf
2019 Program Disclosure Normal Time Macro.xlsm
| Files | ||
|---|---|---|
|
|
||
|
|