This is a collection of queries related to Gradebook that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


List Queries

List of Student Missing Assignments

List of students who are missing assignments - includes Student class status and Gradebook information


LIST STU GBU GBS GBA GBK GBR TCH STU.ID STU.NM GBK.GN GBR.CD GBK.NM TCH.TE GBU.CSC GBU.CMK GBA.AN GBA.AD GBA.DD GBA.GC GBS.MK IF GBA.GC = 1 AND GBS.MK = " " AND GBA.DD >= GBR.SD AND GBA.DD <= GBR.ED AND GBK.SC = TCH.SC


List of Students with an Overall Mark of 'D' or 'F'

List of students and Course information if Overall Mark in class is a 'D' or 'F'


LIST STU GBU GBK GBR STU.NM GBK.PD GBK.NM GBR.CD GBU.CMK GBU.CSC IF ( GBU.CMK : D OR GBU.CMK : F ) AND ( GBR.CD : F )


List of Student with an Overall Mark is Below a 'C' in a Gradebook Ending on a Specific Date

Lists of students and Course information if Overall Mark in class is below a 'C' and the Gradebook is current (prior to the Gradebook End Date)


LIST STU GBU GBK GBE MST CRS TCH STU.ID STU.LN STU.FN STU.GR GBK.PD CRS.CN GBE.SE CRS.CO GBK.TN TCH.TE GBU.CSC GBU.CMK GBU.D2 IF GBU.D2 > ##/##/20## AND ( GBU.CMK = "C-" OR GBU.CMK : "D" OR GBU.CMK : "F" )


List of Students with Less Than 70% in Class

List of students and Course information if Overall Grade Percent is less that 70%


LIST STU GBU GBK GBE MST CRS STU.ID STU.NM GBE.SE CRS.CN GBU.GN GBK.NM GBK.PD GBK.TN GBU.CSC GBU.CMK IF GBU.CSC < 70


List of Students with Less Than 70% in Class for a Specific Course

List of students and Course information if Overall Grade Percent is less that 70% for a specific Course


LIST STU GBU GBK GBE MST CRS STU.ID STU.NM GBE.SE CRS.CN GBU.GN GBK.NM GBK.PD GBK.TN GBU.CSC GBU.CMK IF GBU.CSC < 70 AND CRS.CN = ####