~[wc:admin_header_css] ~[text:psx.html.admin_reports.runreports.start_page] > ~[text:psx.html.admin_reports.runreports.reports] >~[text:psx.html.admin_reports.runreports.reports_system] ~[wc:admin_navigation_css]

Grades Report

~[submitbutton]
Term: Grades: Minimum # of Matches: Students: Sort By:

~[x:GetDoThisForStudents] ~[tlist_sql; SELECT s.LastFirst, s.grade_level, pgf.Grade, pgf.Percent, c.Course_Name, sec.Expression, t.LastFirst, cc.LastGradeUpdate FROM (SELECT pgf.studentid id, count(*) FROM PGFinalGrades pgf INNER JOIN Students s ON pgf.StudentID = s.ID INNER JOIN Sections sec ON pgf.SectionID = sec.ID INNER JOIN CC cc ON pgf.SectionID = cc.SectionID AND pgf.StudentID = cc.StudentID WHERE ~[if.~[gpv:se]=cur]s.id in (~[f.table_info;table=students;dothisfor=currentsel;fn=value;field=id;delim=cma]-1) [else]s.enroll_status = 0 and s.schoolid = ~(curschoolid)[/if] and pgf.FinalGradeName = '~[gpv:tm]' and sec.Termid >= ~(curyearid)00 ~[if.~[gpv:gd]=DsAndFs]and pgf.Grade IN ('D+','D','D-','F')[/if] ~[if.~[gpv:gd]=Ds]and pgf.Grade LIKE 'D%'[/if] ~[if.~[gpv:gd]=Fs]and pgf.Grade LIKE 'F%'[/if] ~[if.~[gpv:gd]=Is]and pgf.Grade LIKE 'I%'[/if] GROUP BY pgf.studentid HAVING count(*) >= ~[gpv:mn]) lowgrades INNER JOIN Students s ON lowgrades.id = s.id INNER JOIN PGFinalGrades pgf ON s.ID = pgf.StudentID INNER JOIN Sections sec ON pgf.SectionID = sec.ID INNER JOIN Courses c ON upper(sec.Course_Number) = upper (c.Course_Number) INNER JOIN Teachers t ON sec.Teacher = t.ID INNER JOIN CC cc ON pgf.SectionID = cc.SectionID AND pgf.StudentID = cc.StudentID WHERE pgf.FinalGradeName = '~[gpv:tm]' and sec.Termid >= ~(curyearid)00 ~[if.~[gpv:gd]=DsAndFs]and pgf.Grade IN ('D+','D','D-','F')[/if] ~[if.~[gpv:gd]=Ds]and pgf.Grade LIKE 'D%'[/if] ~[if.~[gpv:gd]=Fs]and pgf.Grade LIKE 'F%'[/if] ~[if.~[gpv:gd]=Is]and pgf.Grade LIKE 'I%'[/if] ORDER BY ~[if.~[gpv:st]=S]lower(s.lastfirst), sec.expression[/if] ~[if.~[gpv:st]=t]lower(t.lastfirst), sec.expression, lower(s.lastfirst)[/if] ~[if.~[gpv:st]=c]lower(c.course_name), sec.expression, lower(s.lastfirst)[/if] ~[if.~[gpv:st]=e]sec.expression, lower(c.course_name, lower(s.lastfirst)[/if] ~[if.~[gpv:st]=p]pgf.percent, lower(s.lastfirst)[/if] ~[if.~[gpv:st]=G]s.grade_level, lower(s.lastfirst)[/if] ;alternatecolor] [/tlist_sql]
Student Class Grade Percent   Course Exp. Teacher Last Grade Update
~(s.LastFirst;t)    ~(s.grade_level;t) ~(pgf.Grade;t) ~(pgf.Percent;l) ~(c.Course_Name;t)    ~(sec.Expression;t)    ~(t.Teacher;t)    ~(cc.LastGradeUpdate;d)

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

~[wc:admin_footer_css] ~[wc:commonscripts]