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. |
Use this as a starting point. You can add fields to further narrow students returned. Display columns to show additional information like student’s address, gender, GPA or balance due..
| Info |
|---|
If you don’t see this filter your institution may have renamed or modified it. You can build it from the example below or open a Campus Cafe support ticket and request it. |
...
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 zero-credit courses if you have them.
In the second Single Semester Credits Taken enter the student needs to have attempted.
Click Submit.
Other fields to consider
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 it.
...
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.
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.
...
different campuses or program-based such as a day program and a night program.
Build results
You can show additional information alongside the results 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.
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.