Student Reports - Data Generated

Some reports will have recommendations in parenthesis including: the suggested frequency they should be run, departments/roles that utilize them, and those that often support Annual reports. When applicable, common queries and by-student formatting are noted as well.

Academic Transcript Exam Date Order Prior Month (Monthly)
Used by most schools as a report card. If the student's Attendance History and Ledger Statement for the month are attached they have access to grades, attendance, and payment.
Common Queries: Course, Name | Format: 2 pages per student
Standard/Query > Student > Academic Transcript

Prior Month
Scheduled Hours
Payments Made
Test Score Average
Number of Tests Taken
Major Tests/Labs Score Average
Number of Major Tests/Labs Taken
Lab Score Average
Number of Labs Taken
GPA

Cumulative
GPA
Test Score Value
Lab Score Value
Major Test
Score Value
SAP
End Date
Course
Course Hours
Total Hours
Transfer Hours
% Complete
Hours Remaining
Grand Total Hours
Attended
Date Started
Drop Date
ReEnroll Date
Scheduled
Leave of Absence
Contract Grad Date
Max Time Frame
Actual Grad Date
Loan Entrance Date
Loan Exit Date
Determined
Scheduled vs Actual %



Academic Transcript with Credits
Format: 2 pages per student
Standard/Query > Student > Academic Transcript

Date Range
Credits earned
Payments Made
Test Score Average
Number of Tests Taken
Major Test Score Average
Number of Major Tests Taken
Lab Score Average
Number of Labs taken
GPA

Cumulative
GPA
Test Score Value
Lab Score Value
Major test
Score Value
SAP
Course
Course Credits
Credit Earned
CR Remaining
% Complete
Date Started
Drop Date
reEnroll Date
Leave of Absence
Contract Grad Date
Max Time Frame
Actual Grad Date
Loan Entry date
Loan Exit date
Determined
SCH vs ACT%



Alumni Demographics (NACCAS)
This report helps determine how many graduates passed/placed.
Common Queries: Course, Grad Date
Query > Alumni

Start Date
Actual Grad Date
Graduate Status
License Exam Date
Course
Contract Grad Date
Pass Place Code



Contract Graduation Approaching (Weekly)
Helps determine who has a contract graduation date within 30 days of selected date. Helps identify those requiring extended enrollment, preparing over contract fees, and illustrates attendance issues.
Common Queries: Course
Standard/Query > Student

Course
Total Hours
Start Date
Contract Grad
Grad
Number Days Until Contract Graduation



Course Start Date Profile
Standard/Query > Student

Grad Date
Drop Date
Drop Code
Determined
Pass Place Code
Hours Attend
% Completed
GPA
AMA
Received Title IV
Employer Name



Days Absent Exceptions (Weekly)
Helps determine who has missed time within the given date range.
Common Queries: Course
Standard/Query > Student > Attendance

Date
Hours
Days
Cumulative Total Hours
Cumulative Total Days



Enrollment Status (Directors)
A one page overview providing totals for the categories listed below.
Standard/Query > Student

Current - Blank
Current - Full Time
Re-Entry - Full Time
New Starts - Full Time
Current - 3/4 Time
Non-Veteran
Veteran



Evaluation Report (Monthly)
May be used to evaluate your student and set goals for upcoming months.
Common Queries: Course, Name | Format: 1 student per page
Query > Student > Academic Transcript

GPA
Min GPA
Test Score Value
Lab Score
Major Test Score
SAP
Course
Course Hours
Total Hours
Transfer Hours
% Complete
Hours Remaining
Grand Total Hours
Scheduled Hours
Date Started
Drop Date
ReEnroll Date
Scheduled
Actual vs Scheduled Hours %
Leave of Absence
Contract Grad Date
Max Time Frame
Actual Grad Date
Loan Entrance Date
Loan Exit Date
Determined



General Prospect Report with Comments
Standard/Query > Prospect

Recontact Date
Initial Contact
Referral
Course
Enroll Date
Previous School
Class (day/night)
Recruiter
Financial Aid



General Report (NACCAS, IPEDS)
Standard/Query > Student

Personal
Course
Contract
Schedule Length
Transfer Hours
Transfer Credits
Hours
Smart Hours
Grand Total
Ledger Closed Y/N

Demographics
SAP
Scholastic Level
Enroll (Contract Type)
Race
Education Level Code
Dependency
TFI
Referral Code
Previous School
Tracking Code
Grade Level

Dates
Original Start
Drop
Drop Code
ReEnroll
Housing Plan
Start Date
Contract Grad
Max Time Frame
Actual Grad
Determined
Last Attended Date (Last Date of Attendance)
Loan Entrance
Loan Exit
Pass Place
Graduate Status Y/N



Lab Services Totals
Format: 1 student per page
Standard/Query > Students

Lab Date
Lab #
Description
Total Labs
Grand Total Labs
Required # Labs
Remaining Labs
Cumulative Total



Leave of Absence Status (Daily | NACCAS)
Sorted by Beginning LOA Date - Cumulative. Helps check if students have come back from LOA on time or if an extension is needed.
Common Queries: Active
Standard/Query > Student > Leave

Start Date
Course
Hours Attended
% Completed
GPA
Active Y/N
Begin Leave
End Leave
# School Days Between Begin/End Date



Makeup Hours Summary
Standard/Query > Student > Attendance

Start Date
Course
Contract Hours
Transfer Hours
Actual Hours
Makeup Hours
Total Hours
Scheduled Hours
Actual/Scheduled



Monthly Attendance Hours (Monthly)
This report will show the student hours for each day of the selected month and give cumulative percentage on attendance.
Common Queries: Course, Name
Standard/Query > Student > Attendance

Course
Original Start Date
Grad/Drop Date
ReEntry Date
Mon. Days Pres.
Month End Hours
Total Previous Hours
Grand Total
Current GPA



Monthly Prospect Tally (Admissions)
A single-page breakdown of the categories listed below.
Standard/Query > Prospect

Month
Monthly Count
Average by Month
Total Prospect Count
Referral Code



Progress Report (Monthly)
Can be utilized as a report card when meeting with a student.
Common Queries: Course, Name | Format: 1 student per page
Query > Student > Progress Report

Start Date
Last Date of Attendance
Contract Grad Date
Total Hours Scheduled
Max Time Frame Date
Total Hours Attended
Actual Grad Date
% Attended
Course
Cumulative Hours
GPA
Lab Services
Tests



Prospect Conversion Statistics (Admissions)
Standard > Prospect

Date Became Student
Date Became Prospect
Number Days to Convert
Recruiter
Course



SAP / Scheduled vs Actual (Daily | NACCAS)
Helps determine SAP on a daily basis, helps stay aware of payment periods.
Common Queries: Active
Query > Student

Start Date
SAP
Course
Course Length
Test Score Value
Major Test Score
Lab Score
GPA
Hours
Scheduled
Actual
Difference
%



Scheduled vs. Actual Hours Prior Month (Monthly)
Shows how many hours students were scheduled and how many hours they attended. Helps determine students missing time from tardiness or absences, as well as who is exceeding the program.
Common Queries: Course, Name
Standard/Query > Student > Attendance

Start Date
SAP
Course
Course Length
Days
Scheduled
Actual
Diff
%
Hours
Scheduled
Actual
Diff
%



Scheduled vs Actual Start Date Range (Weekly)
Pulls from the schedule tab and the attendance tab. Displays the percentage for days, as well as hours on prior month, cumulatively or for a date range that you specify.
Common Queries: Course, Name
Standard/Query > Student > Attendance

Start Date
SAP
Course
Course Length
Days
Scheduled
Actual
Diff
%
Hours
Scheduled
Actual
Diff
%



Status Report
A single page overview listing how all school courses are populated by the demographic data listed below.
Standard/Query > Student

Scholastic Level Entry
Scholastic Level Int/Advanced
Contract Type Full/3Q
Contract Type Part/Half
Class (day/night)
Veteran
White
Black
Hispanic
Asian
Other
Blank



Student Attendance History (Instructors, Financial Aid Reps)
Format: 1 student per page
Standard/Query > Student > Attendance

Hours
Days
Average Hours/Day
Cumulative Total Hours
Course
Course Hours
Total Hours
Transfer Hours
Grand Total Hours
Remaining Hours
% Complete
Lowest Hours/Month
Highest Hours/Month
Active
SAP
GPA
Start
Drop
ReEnroll
Determined
Contract Grad
Max Time Frame
Graduate
LOA
Loan Entrance
Loan Exit



Student Attendance History by Student (Instructors)
Format: 1 student per page
Student Profile > Attendance > Print

Date
Hours
Days
Average Hours/Day
Cumulative Totals
Hours
Days



Student Category Breakdown (Admissions)
A single page breakdown of the statistics listed below.
Standard/Query > Student

Ethnicity
Age
Education
Class (day/night)
Account Closed
Referral
Pass Place
Scholastic Level
Financial Aid
Marital
Gender
Enrollment (Contract Type)
Title IV Eligible
SAP
NSLDS
CTP
Drop Code(s)



Student Demographics (Directors, Financial Aid Reps | NACCAS)
A simple one-line report that shows totals and current enrollees.
Common Queries: Course, Start Date, Grad/Drop Date
Standard/Query > Student

Start Date
Grad-Drop Date
Course
Hours Attended
% Complete
Active
SAP
Dependency
Verification Status
NSLDS
Financial Aid
GPA



Students Enrolled As Of
A simple report that shows enrolled students and their contract dates, delineated by Course.
Standard/Query > Student

Start Date
Contract Graduation
Estimated Anticipated Grad
Max Time Frame
Grad
Drop
ReEnroll
Total Hours



Student Schedule and Attendance Date Range
This report shows a running total of attendance hours and the scheduled hours. Useful for determining pay period thresholds.
Format: 1 student per page
Student Profile > Attendance > Print

Attendance
Date
Hours
Total Hours
Count of Days
Schedule
Hours
Total Hours
Count of Days
Attendance %



Total Hours Summary (Weekly)
Provides total hours for each student. Can be queried by certain days to give total hours cumulatively and hours obtained by the selected date.
Common Queries: Course, Name
Query > Student > Attendance

Start Date
Course
Course Hours
Hours Attended
Transfer Hours
Total Hours
% Complete


Creation date: 10/19/2018 9:10 AM      Updated: 3/26/2020 7:53 AM