Table of Contents
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 Gradebook and Mark values for a Specific Mark Period and Specific Student
Lists Studnent ID, Student Name, Grade Level, Course, Mark, Class Period, Gradebook Name, Overall Gradebook Mark by a specific marking period and a specific Student ID
LIST STU GRD CRES GBU GBK GBE STU.ID STU.NM STU.GR CRS.CO GRD.M# GBK.PD GBK.NM GBU.CMK BY STU.NM GBK.PD IF GBE.SE = GRD.SE AND GRD.M# # " " AND STU.ID = ######
(populate Mark period and Student ID)
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