~[wc:commonscripts]
PowerSchool School:
Term:
Today is:
Click here for:
~[schoolname]
~[termname]
~[eaodate;dayabbr]
Daily Attendance
~[reports_batch_statusicon]
  Start Page > Reports > Custom School Reports > PowerTeacher Gradebook Assignment List for ~[if.~[gpv:s]=][else]~[tlist_sql;SELECT LastFirst FROM Students WHERE DCID = CASE WHEN '~[gpv:s]' IS NULL THEN -1 ELSE to_number('~[gpv:s]') END]~(student;t)[/tlist_sql][/if] ~[x:username]

PowerTeacher Gradebook Assignment List for ~[if.~[gpv:s]=][else]~[tlist_sql;SELECT LastFirst FROM Students WHERE DCID = CASE WHEN '~[gpv:s]' IS NULL THEN -1 ELSE to_number('~[gpv:s]') END]~(lastFIRST;t)[/tlist_sql][/if]


Student To View Time Frame
~[tlist_sql;SELECT DISTINCT PSM_SCHOOLCOURSE.SCHOOLCOURSETITLE, CASE WHEN PSMA.ISFINALSCORECALCULATED = 1 THEN '' ELSE '*' end notclac, CASE WHEN PSM_SECTIONASSIGNMETAATTRIBUTE.PUBLISHSCORES = 1 THEN '' ELSE '^' end publish, PSMSA.DATEASSIGNMENTDUE, PSMAC.NAME, PSMA.NAME, PSMAS.SCORE, PSMA.POINTSPOSSIBLE, CASE WHEN psma.pointspossible = 0 THEN null ELSE round((psmas.score / psma.pointspossible *100),2) END percent, CASE WHEN PSMAS.SCORE is null then null WHEN psma.pointspossible = 0 THEN null WHEN to_char(PSMAS.SCORE) != to_char(PSMAS.ACTUALSCOREENTERED) and to_char(PSMAS.ACTUALSCOREENTERED) in (SELECT to_char(gradelabel) FROM PSM_Grade WHERE GradeScaleID = (CASE WHEN PSMSE.GRADESCALEID IS NULL THEN PSMSGS.GRADESCALEID ELSE PSMSE.GRADESCALEID END) AND adminuseonly = 0) THEN PSMAS.ACTUALSCOREENTERED WHEN (SELECT MAX(CutOffPercent) FROM PSM_Grade WHERE CutOffPercent <= round((psmas.score / psma.pointspossible *100),2) AND cutoffpercent > 0 AND round((psmas.score / psma.pointspossible *100),2) > 0 AND GradeScaleID = (CASE WHEN PSMSE.GRADESCALEID IS NULL THEN PSMSGS.GRADESCALEID ELSE PSMSE.GRADESCALEID END) AND adminuseonly = 0) != 0 THEN (SELECT GRADELABEL FROM PSM_Grade WHERE GradeScaleID = (CASE WHEN PSMSE.GRADESCALEID IS NULL THEN PSMSGS.GRADESCALEID ELSE PSMSE.GRADESCALEID END) AND adminuseonly = 0 AND CutOffPercent = (SELECT MAX(CutOffPercent) FROM PSM_Grade WHERE CutOffPercent <= round((psmas.score / psma.pointspossible *100),2) AND cutoffpercent !=0 AND GradeScaleID = (CASE WHEN PSMSE.GRADESCALEID IS NULL THEN PSMSGS.GRADESCALEID ELSE PSMSE.GRADESCALEID END) AND adminuseonly = 0)) ELSE (SELECT gradelabel FROM PSM_Grade WHERE GradeScaleID = (CASE WHEN PSMSE.GRADESCALEID IS NULL THEN PSMSGS.GRADESCALEID ELSE PSMSE.GRADESCALEID END) AND adminuseonly = 0 AND defaultzerocutoff = 1) END ltrgrade, CASE WHEN (SELECT to_char(VALUE) FROM Prefs WHERE NAME = 'ppturnedin' || to_char(sec.schoolID)) is null THEN 'show' ELSE 'none' END displayturnedin, CASE WHEN PSMAS.TURNEDIN = 1 THEN 'green.png' ELSE 'clear.png' END turnedin, CASE WHEN (SELECT to_char(VALUE) FROM Prefs WHERE NAME = 'pplate' || to_char(sec.schoolID)) is null THEN 'show' ELSE 'none' END displaylate, CASE WHEN PSMAS.TURNEDINLATE = 1 THEN 'yellow.png' ELSE 'clear.png' END late, CASE WHEN (SELECT to_char(VALUE) FROM Prefs WHERE NAME = 'ppmissing' || to_char(sec.schoolID)) is null THEN 'show' ELSE 'none' END displaymissing, CASE WHEN PSMAS.ISMISSING = 1 THEN 'red.png' ELSE 'clear.png' END missing, CASE WHEN (SELECT to_char(VALUE) FROM Prefs WHERE NAME = 'ppexempt' || to_char(sec.schoolID)) is null THEN 'show' ELSE 'none' END displayexempt, CASE WHEN PSMAS.EXEMPT = 1 THEN 'btn_reports_cancel.gif' ELSE 'clear.png' END exempt FROM PSM_SECTION PSMS INNER JOIN PSM_SECTIONENROLLMENT PSMSE ON PSMS.ID = PSMSE.SECTIONID AND PSMSE.Dateenrolled <= SYSDATE AND PSMSE.Dateleft >= SYSDATE INNER JOIN PSM_STUDENT ON PSMSE.STUDENTID = PSM_STUDENT.ID INNER JOIN SYNC_STUDENTMAP ON PSM_STUDENT.ID = SYNC_STUDENTMAP.STUDENTID AND SYNC_STUDENTMAP.STUDENTSDCID = (CASE WHEN to_char('~[gpv:s]') is null THEN -1 ELSE to_number('~[gpv:s]') END) INNER JOIN PSM_FINALGRADESETUP PSMFGS ON PSMS.ID = PSMFGS.SECTIONID INNER JOIN PSM_REPORTINGTERM PSMRT ON PSMFGS.REPORTINGTERMID = PSMRT.ID INNER JOIN SYNC_SECTIONENROLLMENTMAP ON PSMSE.ID = SYNC_SECTIONENROLLMENTMAP.SECTIONENROLLMENTID INNER JOIN PSM_SECTIONASSIGNMENT PSMSA on PSMS.ID = PSMSA.SECTIONID AND PSMSA.DATEASSIGNMENTDUE >= PSMRT.STARTDATE AND PSMSA.DATEASSIGNMENTDUE <= PSMRT.ENDDATE AND PSMRT.NAME = '~(current.final.grade.name)' INNER JOIN PSM_SECTIONASSIGNMETAATTRIBUTE ON PSMSA.ID = PSM_SECTIONASSIGNMETAATTRIBUTE.SECTIONASSIGNMENTID AND PSM_SECTIONASSIGNMETAATTRIBUTE.PUBLISHSCORES=1 INNER JOIN PSM_ASSIGNMENT PSMA ON PSMA.ID = PSMSA.ASSIGNMENTID INNER JOIN PSM_ASSIGNMENTCATEGORY PSMAC ON PSMA.ASSIGNMENTCATEGORYID = PSMAC.ID LEFT OUTER JOIN PSM_ASSIGNMENTSCORE PSMAS ON PSMSA.ID = PSMAS.SECTIONASSIGNMENTID and PSMAS.sectionenrollmentid = PSMSE.id INNER JOIN PSM_SECTIONGRADESCALE PSMSGS ON PSMS.ID = PSMSGS.SECTIONID INNER JOIN PSM_SCHOOLCOURSE ON PSMS.SCHOOLCOURSEID = PSM_SCHOOLCOURSE.ID INNER JOIN CC ON SYNC_SECTIONENROLLMENTMAP.CCDCID = CC.DCID INNER JOIN Sections sec ON CC.sectionID = sec.ID INNER JOIN Courses crs ON sec.Course_Number = crs.Course_Number WHERE PSMSA.DATEASSIGNMENTDUE >= SYSDATE - (CASE WHEN to_char('~[gpv:timeframe]') is null THEN 0 ELSE to_number('~[gpv:timeframe]') END) AND (PSMAS.EXEMPT != 1 and PSMAS.SCORE is not null or PSMAS.ACTUALSCOREENTERED is not null) ORDER BY PSM_SCHOOLCOURSE.SCHOOLCOURSETITLE, PSMSA.DATEASSIGNMENTDUE;alternatecolor] [/tlist_sql]
Assignments for ~[if.~[gpv:s]=][else]~[tlist_sql;SELECT LastFirst FROM Students WHERE DCID = CASE WHEN '~[gpv:s]' IS NULL THEN -1 ELSE to_number('~[gpv:s]') END]~(lastFIRST;t)[/tlist_sql][/if]
  Course Due Date  Category  Assignment Name  Score  Percent Letter Grade Turned In Late Missing Exempt
~(count;-) ~(PSM_SCHOOLCOURSE.SCHOOLCOURSETITLE;t) ~(notcalc;t)~(publish;t)~(PSMSA.DATEASSIGNMENTDUE;d)   ~(PSMAC.DESCRIPTION;t)   ~(PSMA.DESCRIPTION;t)   ~(PSMAS.SCORE;l)/~(PSMA.POINTSPOSSIBLE;l)   ~(percent) ~(ltrgrade;t) Assignment Recieved Assignment Late Assignment Missing Exempt from Assignment




© 2009 PowerDataSolutions. All rights reserved. Version 1.0