Find students who received certain grades for their classes.

You need to identify students with poor grades so you can initiate intervention, you need to report on grade frequencies or distributions or you want to find classes where grades weren’t submitted.

Considerations

• Are all grades for the semester recorded?

• How do you handle incomplete grades?

• Do you have access to all students?

Start with a pre-built filter

Use this as a starting point. You can add fields to further narrow students returned.

The student finder will show students who received the selected grade(s) but won’t show which classes the student received the grade for. To which class(es) the student received the grade use an SSRS base report instead.

1. Go to Filters > Students.

2. In All Users select ZCC STUDENTS WITH CLASS GRADE.
   
   

   Open

   

3. Click Filters.
   
   

   Open

   

4. Next to Course Semester click the three horizontal lines, select the semester(s) when the courses ran and click Apply.
   
   

5. By default, the filter searches for grades of D and F. In Final Grade enter the grades you’re looking for separated by commas. Alternatively, you can click the three horizontal lines and select the grades.
   
   

6. Click Submit.

Add criteria

You can further narrow your results by selecting Add Fields, searching for the field name and selecting it.

Consider adding these fields if you need to further constrain your results.

• Site Code to narrow the results to only grades given to students in a specific site. Your sites may be physical such as different campuses or program-based such as a day program and a night program.

• Degree Majors to narrow the results to students enrolled in certain major(s).

Build results

You can show additional information alongside the results by selecting Column Visibility, searching for the field name and selecting it.

• Advisor 1, Advisor 2, Advisor 3 or Advisor 4 to show the student’s advisor(s).

• Class level to narrow the results to students only at a certain class standing such as freshman or sophomore.

• Email to show the student’s email.

SSRS base report for additional data

The student finder shows all students who received the grade you entered, which can be helpful if you want to quickly identify students with a failing or incomplete grade or you want to communicate with students with a specific grade. If you need further details, such as which class they were awarded the grade, use a base report.

1. Go to Faculty/Staff > Base Reports > Registrar Reports > Enrollments with Final Grade Filter.

2. In Select Enrollment Semester(s) select the semester(s) when the courses ran.

3. In Final Grade(s) to Include select the grades.

4. Select Student Site(s) and Comment Codes. Comment codes can be helpful if you use comments to note if a grade was excused or repeated under a grade forgiveness policy.

5. Click View Report.