SMART Support Guide for COE Annual Report 2020

Reporting Opens: January 8th, 2021
Reporting Closes: February 19th, 2021

Location: Reports > Report Type: Standard > Annual > COE > 2020

General Details: OnlineSMART generates reports for the required COE Annual Report filing. New for 2020/2021 is COE's web portal to complete your filing digitally.

All reports exclude any student in a course with a CIP code of 0.00

COE Completion Placement and Licensure

SMART provides a COE List of Students report to make verifying your count easier. Run the report, export it to CSV or Excel, and you can follow the instructions below to verify the count of students.

DISPLAY:

Row 5	Beginning Enrollment	Display a count of all students active in the course that this report is being generated for on the first day of the reporting period that have a start date less than the first day of the reporting period. Filter Start Date (Column C) to only contain July 2019 through June 2020 Exclude any student following drop codes from the ‘Academics’ tab: ‘Transfer to another course (Within School)’, ‘Health Reasons’, ‘Permanently Disabled’, ‘Incarcerated’, ‘Deceased’, ‘Active Duty Armed Forces’, ‘Fed Govt Serv Foreign Aid’, ‘Military Transfer; Additionally, exclude any student who has a Drop Date equal to their Start Date
Row 6	New Enrollees	Display a count of all students with a start date in the reporting period for the course this report is being generated for. Filter Start Date (Column C) to exclude July 2019 through June 2020 Exclude any student following drop codes from the ‘Academics’ tab: ‘Transfer to another course (Within School)’, ‘Health Reasons’, ‘Permanently Disabled’, ‘Incarcerated’, ‘Deceased’, ‘Active Duty Armed Forces’, ‘Fed Govt Serv Foreign Aid’, ‘Military Transfer’. Additionally, exclude any student who has a Drop Date equal to their Start Date
Row 7	Cumulative Enrollment	Calculate and Display the Sum of rows 5 and 6.
Row 8	Students Still Enrolled	Display a count of all students active in the course the report is being generated for on the last day of the reporting period. Filter Student Status (Column D) for only Active
Row 9	Non-Graduate Completers	Calculate and display a count of all students in the reporting period that have the drop code “Employed in field”. Filter Drop Code (Column G) for code J
Row 10	Graduate Completers	Display a count of all students enrolled in the course during the period the report is being generated for that has an actual grad date in the reporting period. Filter Student Status (Column D) for only Graduate
Row 11	Total Completers	Display the sum of Row 9 and 10 here.
Row 12	Non-Graduate Completers Employed in Positions Related to Field of Instruction	Calculate and display a count of all students in the reporting period that have the drop code “Employed in field” (Same as Row 9). Filter Drop Code (Column G) for code J
Row 13	Graduate Completers Employed in Positions Related to Field of Instruction	Display a count of students enrolled in the course the report is being generated for that have an actual grad date in the reporting period and have a Graduate Status code of Employed in Field, Further Education, or Active Military Serv. Filter Student Status (Column D) for only Graduate, then filter GradStatus (Column F) for Employed in Field, Further Education, or Active Military Serv.
Row 14	Total Completers Employed in Positions Related to Field of Instruction	Sum Rows 12 and 13.
Row 15	Graduate Completers Employed in Positions Unrelated to Field of Instruction	Display a count of students enrolled in the course the report is being generated for that have an actual grad date in the reporting period and have a Graduate Status code of B Filter Student Status (d) for only Graduate, then filter GradStatus (Column F) for Employed in Unrelated Field
Row 16	Graduate Completers Waiting To Take Licensure Exam PLUS Graduate Completers Who Are Awaiting Results	Display a count of students enrolled in the course the report is being generated for that have an actual grad date in the reporting period and have a Pass Place code of Work Permit - Not Yet Tested or Graduated - Did Not Appear. Filter Student Status (d) for only Graduate, then filter PassCode (Column H) for Work Permit - Not Yet Tested or Graduated - Did Not Appear.
Row 17	Graduate Completers Who Took Licensure Exam	Display a count of students enrolled in the course the report is being generated for that have an actual grad date in the reporting period and have a Pass Place code with either passed or failed results. Filter Student Status (Column D) for only Graduate, then filter PassCode (Column H) for Failed Practical, Failed Written, Passed State Board/Not Placed, Passed/Other, Passed/Placed In Field, Passed. Placed NON-Related Field, Passed/Placed Related Field, Passed/Refused Placement, or Passed/Unavailable For Placement. (All codes except for Graduated-Did Not Appear or Work Permit – Not Yet Tested)
Row 18	Graduate Completers Who Passed Licensure Exam	Display a count of students enrolled in the course the report is being generated for that have an actual grad date in the reporting period and have a Pass Place code of passing results. Filter Student Status (Column D) for only Graduate, then filter PassCode (Column H) for Passed State Board/Not Placed, Passed/Other, Passed/Placed In Field, Passed. Placed NON-Related Field, Passed/Placed Related Field, Passed/Refused Placement, or Passed/Unavailable For Placement.
Row 19	Graduate Completers Unavailable for Employment	Display a count of students enrolled in the course the report is being generated for that have an actual grad date in the reporting period and have a Graduate Status code of Other Unavailable, Incarcertated, Active Military Serv, Death, Medical, or International Student. Filter Student Status (Column D) for only Graduate, then filter GradStatus (Column F) for Other Unavailable, Incarcertated, Active Military Serv, Death, Medical, or International Student.
Row 20	*Graduate Completers Who Refused Employment	Display a count of students enrolled in the course the report is being generated for that have an actual grad date in the reporting period and have a Pass Place code refusing Employment. Filter Student Status (Column D) for only Graduate, then filter PassCode (Column H) for Passed/Refused Placement.
Row 21	Graduate Completers Seeking Employment/Status Unknown	Display a count of students enrolled in the course the report is being generated for that have an actual grad date in the reporting period and have a Graduate Status code of Unemployed or Unknown. Filter Student Status (Column D) for only Graduate, then filter GradStatus (Column F) Unemployed or Unknown.
Row 22	Withdrawals	Display a count of students enrolled in the course the report is being generated for that have a drop date in the reporting period, if the student also has a subsequent reenroll date during the date range of the report remove from this count. Filter Student Status (Column D) for only Withdrawn
Row 23	Sum of Rows 16, 19, and 20	Calculate and display the sum of Rows 16, 19 and 20
Row 24	Difference – Row 10 Minus Row 23	Calculate and display Row 10 Minus Row 23
Row 25	*Difference – Row 11 Minus Row 23	Calculate and display Row 11 Minus Row 23
Row 26	*Graduation Rate	Calculate and display Row 10 / (Row 7 – Row 8)*100
Row 27	*Total Completion Rate	Calculate and display Row 11 / (Row 7 – Row 8) *100
Row 28	Graduate Placement Rate	Calculate and display (Row 13 / Row 24) *100
Row 29	*Total Placement Rate	Calculate and display (Row 14 / Row 25) *100
Row 30	Licensure Exam Pass Rate	Calculate and display (Row 18 / Row 17) *100

COE FTE Calculation Worksheet

This report pulls all scheduled hours within 7/1/2019-6/30/2020 and then divides that number by 900 to find the FTE (full time equivalent). If needed, the date range can be adjusted at the top of the report.

	2020 FTE Calculation Worksheet – Step 3
	Report Period: XX/XX/XXXX – XX/XX/XXXX
		CONTACT (Clock) HOURS	SEMESTER CREDIT HOURS	QUARTER CREDIT HOURS
1.	Enter total number of hours from STEP 2 in the appropriate column(s). THIS IS THE NUMBER THAT WILL BE ENTERED IN THE SOFTWARE UNDER THE FOLDER LABELED: COMBINED FTE	Calculate and display all scheduled hours in the date range that the report is being ran for.	Leave this blank	Leave this blank
2.	Divide the totals in line 1 above by these numbers.	900	30	45
3.	Enter results.	Take the total scheduled hours from Cell C4 and divide by 900. Display the result here.	Leave this blank	Leave this blank
	GRAND TOTAL FTE (Add numbers reported on line 3 above and enter result here.)	Leave this blank

Creation date: 12/31/2020 3:09 PM Updated: 12/31/2020 3:16 PM

Step-by-step guides for utilizing various functions, reports, and data verification in OnlineSMART.