Business area
Registrar
Business need
Find all currently enrolled students and return information such as student demographics, credits and GPA.
...
You need to communicate with students, report numbers of enrolled students and their demographics or anticipate revenue or class seats.
Considerations
Does “current” mean as of today or a future semester?
Does “enrolled” mean registered in a class or just active?
Permissions to consider
Do you have access to all students?
...
Start with a pre-built filter
| Note |
|---|
This filter updates overnight or when you launch the GPA processor. |
...
Go to Filters > Students.
In All Users select ZCC Enrolled Students.
Click Filters.
Next to Single Semester click the three horizontal lines, select a semester and click Apply.
In the first Single Semester Credits Taken enter the minimum number of credits a student must be enrolled in. Entering 0 means students your results will include students in only zero-credit courses will be returnedif you have them.
In the second Single Semester Credits Taken enter the maximum number of credits a student can be enrolled in. If you want all students, you can enter a high number like 9999.
Click Submit.
...
Add criteria
You can further narrow your results by selecting Add Fields, searching for the field name and selecting a field. Consider adding these fields if you need to further constrain your resultsit.
...
Class level to narrow the results to students only at a certain class standing such as freshman or sophomore.
Degree majors to narrow the results to students enrolled in certain major(s).
Class level Site Code to narrow the results to only students only at a certain class standing specific site. Your sites may be physical such as freshman or sophomore.
...
different campuses or program-based such as a day program and a night program.
Build results
You can show additional information alongside the results . Click Column Visibility to select additional fields.by selecting Column Visibility, searching for the field name and selecting it.
...
Single Sem Credits Taken shows the total number of credits the student attempted this semester.
Single Sem Credits Earned shows the total number of credits the student passed this semester.
Single Sem GPA shows the student’s semester GPA.
Advisor 1, Advisor 2, Advisor 3, Advisor 4 shows student advisors.
Degree Major shows the student’s first major.
Gender, Home State, Racial Background Decoded to show demographic information.
Base reports
Use this base report to show all enrolled students along with their individual class enrollments and demographic data. Unlike a filter, you can’t add additional information to this report. However, this shows all classes each student is in, unlike the saved filter.
...
SSRS base report for additional data
Students with past academic programs (majors) and class enrollments (registrations)
While the filter will show enrolled students, it shows their current / most recent major. If you need enrolled students and their major at a specific time, use this base report.
Go to Faculty/Staff > Base Reports > Students Enrolled on a Given Date.
In Enrollment Determination Date select the date that students needed to be enrolled on.
By selecting Show Detail as Yes the report will display individual class enrollments (registrations) for each student.
Set which Sites to include and which Current Degree Statuses to include. If you’re looking for historical data, we recommended you include all statuses as a student who was enrolled in the past may have since graduated or withdrawn.
Click View Report.