1. Create a new Student Query
  2. On the Criteria tab select the following:
    Student, Student Progression Entry, Academic year  equals [academic year]
    AND  Grades, Grade/Skills equals [academic year]
    AND  Schedules, Academic year equals [academic year] (This criteria is optional and will limit the results to students that are scheduled in the selected Academic Year.)
  3. On the Output tab select the following:
    Student, Student Progression Entry, Grade level equals, Academic Year
    Student, Bio1, First Name, Last Name, Student Id
    Grades, Grades/Skills, Course ID
    Grades, Grades/Skills, Grades, Marking Column
    Grades, Grades/Skills, Grades, Awarded Credit, Grade
  4. Select Results.
Note: If duplicate marking column grades for the same course show in the results, suppress the duplicate rows.