How to gather data for the ACCSC Annual Report part 3 characteristics of Student Enrollment
ACCSC Annual Report Step-by-Step Guide for part 3 Characteristics of Student Enrollment
Student Enroll
Run Active report (Reports > Students > Active)
Choose School
Date: 7/1/20??
Total # of Matches = Student Enroll
Add’l Enroll
Run Program Action Report (Reports > Students > Program Actions)
Choose the school and check all programs.
Type in the date range in effective start and end date boxes (7/1/2023-6/30/2024)
Choose ‘Admitted’ as the action
Make sure to check the “Last Action Only” box.
Export to Excel.
Sort by first class date.
Remove those who did not report to the first class date. These are most likely canceled students (It will be blank in the first class date column) *These may require manual look-up
The students who are left = Add’l Enroll
Graduated Count
Run Program Action Report (Reports > Students > Program Actions)
Choose the school and check all programs.
Type in the date range in effective start and end date boxes (7/1/20??-6/30/20??)
Choose ‘graduated’ as the action
Make sure to check the “Last Action Only” box.
Total # of Matches = Graduated.
Withdrew Count
Run Program Action Report (Reports > Students > Program Actions)
Choose the school and check all programs.
Type in the date range in effective start and end date boxes (7/1/20??-6/30/20??)
Choose ‘withdrawn’ as the action
Make sure to check the “Last Action Only” box.
Total # of Matches = Withdrew.
T4Assist %
Run all Transactions Report (Accounting > Student Ledgers > All Transactions)
Choose all of your Title IV transaction types.
Enter date range into ‘posted’ start and end date (7/1/20??-6/30/20??)
Click the radial button for “actual only”
Leave status blank to pull all status types.
Download to Excel.
Sort by voids - ensuring that they are true voids.
Delete true voids.
Sort by student number. Investigate any TitleIV charges to see if they were a void or a partial refund.
Remove voids and leave partial refunds.
Remove duplicate student numbers
Total number of students remaining = total number of students receiving TitleIV funding.
Divide Total Title IV students from the Total number of students (Student Enroll + Add’l Enroll). This result = T4Assist %.
T4PellGrants %
Run all Transactions Report (Accounting > Student Ledgers > All Transactions)
Choose the Pell Grant Transaction Type.
Enter date range into ‘posted’ start and end date (7/1/20??-6/30/20??)
Click the radial button for “actual only”
Leave status blank to pull all status types.
Download to Excel.
Sort by voids - ensuring that they are true voids.
Delete true voids.
Sort by student number. Investigate any TitleIV charges to see if they were a void or a partial refund.
Remove voids and leave partial refunds.
Remove duplicate student numbers
Total number of students remaining = total number of students receiving TitleIV Pell grants.
Divide Total Title IV Pell Grants students from the Total number of students (Student Enroll + Add’l Enroll). This result = T4PellGrant %.
T4Loans %
Run all Transactions Report (Accounting > Student Ledgers > All Transactions)
Choose the Sub and Unsub Transaction Types.
Enter date range into ‘posted’ start and end date (7/1/20??-6/30/20??)
Click the radial button for “actual only”
Leave status blank to pull all status types.
Download to Excel.
Sort by voids - ensuring that they are true voids.
Delete true voids.
Sort by student number. Investigate any TitleIV charges to see if they were a void or a partial refund.
Remove voids and leave partial refunds.
Remove duplicate student numbers
Total number of students remaining = total number of students receiving Title IV Loans.
Divide Total Title IV Loans students from the Total number of students (Student Enroll + Add’l Enroll). This result = T4Loans %.
NonT4Assist %
Run all Transactions Report (Accounting > Student Ledgers > All Transactions)
Choose all Non Title IV Transaction Types.
Enter date range into ‘posted’ start and end date (7/1/20??-6/30/20??)
Click the radial button for “actual only”
Leave status blank to pull all status types.
Download to Excel.
Sort by voids - ensuring that they are true voids.
Delete true voids.
Sort by student number. Investigate any TitleIV charges to see if they were a void or a partial refund.
Remove voids and leave partial refunds.
Remove duplicate student numbers
Total number of students remaining = total number of students receiving Non TitleIV.
Divide Non Title IV students from the Total number of students (Student Enroll + Add’l Enroll). This result = NonT4Assist %.