A. There are several queries that need to be built so that they can be used as filters on a Class Report.

  1. In the query module, create a new Student query.
  2. On the Criteria tab, expand Enrollments and select Class of.
  3. Use the Operator of equals and enter the year of the students needed.
  4. Save and close the query.
  1. In the query module, create a new Faculty/Staff query.
  2. On the Criteria tab, expand Schedule and select Academic Year.
  3. Use the Operator of equals and the Value of the Academic Year that the students included in the previous query would have taken the course.
  4. Also under Schedule, expand Course and Course type/department and select Department.
  5. Use the Operator of equals and the Value of the Department that you want to report on.
  6. Save and close the query.

B. Now that both queries are created and saved, they can be used as filters on the Class Report.

  1. In the Reports module, select Course/Class Reports and create a new Class Report.
  2. On the General tab choose the Academic Year used in the queries above, as well as the appropriate Session and Terms.
  3. On the Filters tab, choose Selected for the Course Grade Levels row and choose the grade level that the students would be in during the academic year chosen on the General tab.
  4. On the Filters tab, choose Selected for the Teachers row and choose the Faculty/Staff query created above.
  5. On the Filters tab, choose Selected for the Students row and choose the Student query created above.
  6. On the Columns tab, select the following: Course ID, Section ID, Course Name, Department, and Teacher.
  7. On the Format tab, select Detail and Mark the checkbox labeled Include students enrolled. Include Student Name, Student ID, Grade Level, Current Status.
  8. On the Format tab, select Sort/Break. Add each of the following to a new line: Teacher, Course ID, Class ID, and Section ID.
  9. Preview and print the report. This will be a list of students who have a specific Class of and only their teachers from a specific department for a previous academic year.