~[wc:commonscripts] ~[wc:admin_header]Start Page > Reports > Custom School Reports > Last Gradebook Update~[wc:admin_navigation]
Gradebook Updates Older than ~[prefschool:gradesnotupdatedin] Day(s)

Check for Classes that haven't been updated in day(s).

The above number of days is the current school prefernce.

~[tlist_sql; SELECT DISTINCT Teachers.LastFirst Teacher, Sections.Course_Number, Courses.Course_Name, Sections.Section_Number, Sections.DCID Sections_DCID, Teachers.DCID Teachers_DCID, CC.LastGradeUpdate, Sections.Expression FROM Sections INNER JOIN Teachers ON Sections.Teacher = Teachers.ID INNER JOIN Courses ON Sections.Course_Number = Courses.Course_Number INNER JOIN CC ON CC.SectionID = Sections.ID INNER JOIN Terms ON Sections.TermID = Terms.ID AND Sections.SchoolID = Terms.SchoolID WHERE Sections.SchoolID = ~(curschoolid) AND Terms.FirstDay <= SYSDATE AND Terms.LastDay >= SYSDATE AND Sections.ExcludeFromStoredGrades = 0 AND CC.LastGradeUpdate + ~[prefschool:gradesnotupdatedin] < SYSDATE ORDER BY CASE WHEN '~[gpv:sort]' = '1' THEN upper(Teachers.LastFirst)||'_'||Sections.Course_Number WHEN '~[gpv:sort]' = '2' THEN Sections.Course_Number||'_'||upper(Teachers.LastFirst) WHEN '~[gpv:sort]' = '3' THEN upper(courses.Course_Name)||'_'||upper(Teachers.LastFirst) WHEN '~[gpv:sort]' = '4' THEN to_char(CC.LastGradeUpdate, 'YYYYMMDD') ELSE to_char(CC.LastGradeUpdate, 'YYYYMMDD') END, Sections.Section_Number ;alternatecolor] [/tlist_sql]
Teacher  Course Number  Course Name  Section Number  Last Updated  Expression
~(Teacher;t) ~(Course_Number;t) ~(Course_Name;t) ~(Section_Number;l) ~(LastGradeUpdate;d) ~(Expression;t)

~[tlist_sql; SELECT count(distinct Sections.ID) cnt FROM Sections INNER JOIN Teachers ON Sections.Teacher = Teachers.ID INNER JOIN Courses ON Sections.Course_Number = Courses.Course_Number INNER JOIN CC ON CC.SectionID = Sections.ID INNER JOIN Terms ON Sections.TermID = Terms.ID AND Sections.SchoolID = Terms.SchoolID WHERE Sections.SchoolID = ~(curschoolid) AND Terms.FirstDay <= SYSDATE AND Terms.LastDay >= SYSDATE AND Sections.ExcludeFromStoredGrades = 0 AND CC.LastGradeUpdate + ~[prefschool:gradesnotupdatedin]< SYSDATE ] [/tlist_sql]
Total Sections not updated in ~[prefschool:gradesnotupdatedin] day(s).~(cnt;l)

Report generated at ~[time] on ~[date]



© 2008 PowerDataSolutions. All rights reserved.