This query can be used to get a report of student Gradebook Averages by Term.

A Term Average value is available to get students in the range you are interested in. The default value is <= 65. Changing this to <= 100 will give you all students.

The Query report will include Student ID, Last Name, First Name, Course ID, Course Section, Teacher, Average.