--Gradebook Grade that is greater than a "C"
LIST STU GBU GBK STU.ID STU.LN STU.FN GBK.NM GBK.TM GBK.PD GBU.CSC GBU.CMK IF GBU.CMK > "C"
--Gradebook term scores and percent (right column contains DTS of last term specific recalculation most likely caused by teacher intervention and will suffice as a rudimentary last teacher modification 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 GBE.SE MST.CN GBV.MK GBV.PC (( CAST(GBV.DTS AS DATETIME) )) IF GBK.GN = GBV.GN AND GBK.SC = TCH.SC
--Gradebook term scores and percent if you wish to focus in on a specific day
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 <= "3/27/2018" AND CAR.DE >= "3/27/2018"
--Gradebook term scores and percent including assignment percentage when title is like “Final”
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 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"
--Gradebook Assignment tallies
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
--Gradebook Missing Assignment
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
--Gradebook Comments Made on Scores
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 > " "