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 = ####


List of Student Term Scores and the Teacher's Last Update.

Provides a list of students with School, ID, Grade, Status, Gradebook #, Term, Course Name, Teacher, Period, Section, Course #, Mark, Percent and Teacher Timestamp


LIST STU GBV GBU GBK GBE MST TCH STU.SC STU.ID STU.NM STU.GR STU.TG? GBK.GN GBV.CD GBK.NM TCH.TE MST.PD GBE.SE MST.CN GBV.MK GBV.PC (( CAST(GBV.DTS AS DATETIME) )) IF GBK.GN = GBV.GN AND GBK.SC = TCH.SC


List of Student Term Scores for a Specific Date.

Provides a list of students with School, ID, Grade, Status, Gradebook #, Term, Course Name, Teacher, Period, Section, Course #, Mark and Percent for a specific date


LIST STU CAR GBV GBU GBK GBE MST TCH STU.SC STU.ID STU.NM STU.GR STU.TG? GBK.GN GBV.CD GBK.NM TCH.TE MST.PD GBE.SE MST.CN GBV.MK GBV.PC BY STU.ID GBV.CD MST.PD IF GBK.GN = GBV.GN AND GBK.SC = TCH.SC AND CAR.SE = GBE.SE AND CAR.DS <= "##/##/20##" AND CAR.DE >= "##/##/20##"

(Use the same date in both date fields)


List of Added Assignment Comments 

Provides a list with School, Teacher, Course Name, Assignment Name, Student ID, Student Name, Assignment Mark and Assignment Comment


LIST TCH GBK GBA GBS STU TCH.SC TCH.TE GBK.NM GBA.AD STU.ID STU.NM GBS.MK GBS.CO IF GBS.CO > " "


List of Student Term Scores  and Assignment Mark for any Assignment that is Identified with"Final" in the Assignment Name

Provides a list of students with School, ID, Grade, Status, Gradebook #, Term, Course Name, Teacher, Period, Section, Course #, Mark, Percent, Due Date, Assignment Name and Percent Value on the assignment


LIST STU GBS GBA GBV GBU GBK GBE MST TCH STU.SC STU.ID STU.NM STU.GR STU.TG? GBK.GN GBV.CD GBK.NM TCH.TE MST.PD GBE.SE MST.CN GBV.MK GBV.PC GBA.DD GBA.AD GBS.PC IF GBK.GN = GBV.GN AND GBK.SC = TCH.SC AND GBA.AD : "FINAL"


Total Queries

Gradebook Assignment Tallies

Provides a count of total assignments by Teacher, Course Name, Term and Period


TOTAL TCH GBK GBA GBR TCH.TE GBK.NM GBR.CD GBK.PD BY TCH.TE GBR.CD GBK.NM GBK.PD IF GBK.SC = TCH.SC AND GBA.DD >= GBR.SD AND GBA.DD <= GBR.ED