1. Create a new student query.
  2. In the Query type field, select Student.
  3. In the Query format field, select Dynamic.
  4. Click OK.
  5. On the Criteria tab, expand the Student category and the Student progression subcategory, and double-click Academic year.
  6. In the Operator field, select equals (to query on one academic year) or one of (to query on multiple academic years).
  7. Under the Student progression subcategory, double-click Grade level.
  8. In the Operator field, select equals (to query on one grade level) or one of (to query on multiple grade levels)
  9. Select the Output tab and select Grades, Grades, Total Credits Awarded.
  10. Select the filters for academic years and click OK.
  11. On the Sort tab, select the applicable fields to sort the query results.
  12. Select Results tab to run the query.