1. Create a new Student query.
  2. On the Criteria tab choose the following:
Student , Bio 1, Current Status - equals [status of current students]
Schedule, Academic Year - equals [Year]
Schedule, Class Term Enrolled - equals [desired term]
Schedule, Class, Class ID – One Of [Desired classes]
  1. On the output tab, choose the following:
Schedule, Course, Course, Course Name
Student , Bio 1, Last Name
Student, Bio 1, First Name.
  1.  Remove any other output fields.
  2. On the Sort tab, open the Query Fields section. 
  3. Choose Course name, then add Last Name.
  4. Run the Query.