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.
|ID||Last Name||First Name||Course ID||Course Section||Teacher||Average|