Client Support Guide for ACCET - 2018
| Report Locations Key Points Summary Display Course Header Report Data |
Report Locations
Annual > ACCET > ACCET Scheduled Hours and FTE Estimate by Date Range
Standard/Query > Student > Scheduled Hours and FTE Estimate by Date Range
Key Points
- Courses must be assigned a CIP Code in order to be included
- FTE is calculated by dividing scheduled hours by 900
- Data must be entered correctly in Student profiles and Course setup to obtain accurate results
- Start Dates
- Contract Hours
- Student Schedules
- CIP Codes
Summary Display
- Total Students – Total number of students in ALL courses with a CIP Code, who were active between 7/1/2017 – 6/30/2018.
- To verify total students, query the following report:
- Reports > Student > Student Demographics (Simple)
- Query > Flags > Is Active On 7/1/2017 – 6/30/2018
- Total Student Count is on the last page
- Total Scheduled Days – The count of all days scheduled from 7/1/2017 – 6/30/2018 for ALL students active within that date range, for ALL courses with a CIP Code.
- To verify total scheduled days, query the following report:
- Student > Attendance > Scheduled vs Actual Hours Attendance Date Range
- Start Date is 7/1/2017 and End Date is 6/30/2018
- The last page will have the Days Scheduled Total
- Total Contract Hours – This is the grand total of all Contract Hours taken from the Financial tab of ALL students active from 7/1/2017 – 6/30/2018.
- To verify total contract hours, query the following report:
- Student > Attendance > Scheduled vs Actual Hours Attendance Date Range
- Start Date is 7/1/2017 and End Date is 6/30/2018
- Export to CSV and run a Sum Total of the Contract Hours column
- How to Run a Sum Total in Excel
- Total Scheduled Hours In Range – The grand total of scheduled hours from 7/1/2017 – 6/30/2018 for ALL students active during that same date range.
- To verify total scheduled hours in range, query the following report:
- Reports > Student > Attendance > Scheduled vs Actual Hours Attendance Date Range
- Start Date is 7/1/2017 and End Date is 6/30/2018
- The last page will have the Hours Scheduled Total
- Full Time Equivalent (FTE) Estimate – This is calculated by dividing ALL Total Scheduled Hours In Range (from 7/1/2017 – 6/30/2018) by 900.
- To verify FTE Estimate:
- Divide the above “Total Scheduled Hours In Range” by 900
- Total Scheduled Hours Total – The grand total of ALL hours (included) students are scheduled for. Included students are those active from 7/1/2017 – 6/30/2018. Only applies to scheduling for courses assigned a CIP Code.
- To verify the total scheduled hours total, query the following reports:
- Student > Scheduled Hours vs Actual Hours Attendance Date Range
- Flags > Is Active On > 7/1/2017 – 6/30/2018
- Enter very wide date range to encompass all possible scheduling
- Final page of report has Scheduled Hours Totals
Course Header
- Taken verbatim from the Course Name as set in the Administrative Course setup
- Lists Full Time Equivalent (FTE) Estimate for that specific course
Report Data
- Column 1 – Permit Number: Displays the Permit Number pulled from the student profile Academics tab.
- Column 2 – Student: Displays a list of students in all courses with a CIP Code, who were Active between 7/1/2017 – 6/30/2018.
- Column 3 – Start Date: The Start Date pulled from the student profile Academics tab. Note this is not the Original Start.
- Column 4 – Contract Hours: Displays the hours from the ContractHours field of the student profile Financial tab.
- Column 5 – Scheduled Days: The total number of days the student is scheduled for from 7/1/2017 – 6/30/2018.
- Column 6 – Scheduled Hours: The total number of hours the student is scheduled for from 7/1/2017 – 6/30/2018.
- Column 7 – Total Scheduled Hours: The grand total of hours the student is scheduled for, not just during the date range.
DataImage9.png
DataImage52.png
| Files | ||
|---|---|---|
|
|
DataImage9.png
9 KB
|
|
|
|
DataImage52.png
8 KB
|