PSCB - Custom Reports (Grading)

Nevermind! The condition is true when push out from School ONly.

But as soon as Teacher edits their weights - all Weights are showing with Category Names!!!!

I was looking too soon :)

Thanks

Any chance you guys are working on a report that shows the teacher pass rate for broken down by course or by section?

Is there a way to make this report run by final grade setup instead of the section term?

Hi,
I tried to run this but it is blank no matter how many days I select. All other reports are running. Any ideas? Still havent heard back on this. Thanks!!

I created an Assignment Flags Report page that fits into the Custom Report Grading system. You might consider adding it to this bundle - https://support.powerschool.com/exchange/view.action?download.id=1091.

I am finding that the missing grades report is not pulling all of the missing grades. We have a teacher who doesn't have grades in for an entire section and it's not pulling any of those students on the missing grades report. We are on version 2.1 of the plugin. This is a great report and we would love to use it, but want to be sure it's pulling accurately before sharing with my principal. We are on PS version 20.4.5 Any thoughts?

Assignments have been created, no scores have been entered.

This report used to run, but now is pulling as blank. Any troubleshooting? Thanks!

Morning,
Is there anything in the works to add a drop down for Department. We are a HS and it would be great for a department head to review all of the sections within that department at once. Thanks!

Hello. There are a few classes that do not show up in the drop-down list for us. They are all courses that are connected to pass/fail grade scales. Are these types of courses excluded from this report? If not, what would be another reason that an active course would not show up in the drop-down list?

Is there a way to get grades by categories?

What constitutes an update? If a teacher enters an assignment but not grades, is that an update? Thank you!

I noticed when you run the honor roll report for one Store code it returns records without student names. I found when I added this ~[if#sc1.~(gpv.sc;sqlText)#] AND HR.storecode = '~(gpv.sc;sqlText)' [/if#sc1] in the th tags for the method, level and gpa AND added it to the scList AS Select it resolved the issue.

Example:
<th class="left filter-select">~[tlist_sql; WITH scList AS (SELECT DISTINCT storecode FROM Honorroll hr WHERE HR.Yearid = ~(curyearid) AND HR.SchoolID = ~(curschoolID) ~[if#sc1.~(gpv.sc;sqlText)#] AND HR.storecode = '~(gpv.sc;sqlText)' [/if#sc1]) SELECT DISTINCT LISTAGG('Method - ' || hr.storecode, CHR(60) || '/th' || CHR(62) || CHR(60) || 'th class="left filter-select"' || CHR(62)) WITHIN GROUP (ORDER BY hr.storecode) OVER (PARTITION BY null) FROM scList hr]~(1;t)[/tlist_sql]</th>
<th class="left filter-select">~[tlist_sql; WITH scList AS (SELECT DISTINCT storecode FROM Honorroll hr WHERE HR.Yearid = ~(curyearid) AND HR.SchoolID = ~(curschoolID) ~[if#sc1.~(gpv.sc;sqlText)#] AND HR.storecode = '~(gpv.sc;sqlText)' [/if#sc1]) SELECT DISTINCT LISTAGG('Level - ' || hr.storecode, CHR(60) || '/th' || CHR(62) || CHR(60) || 'th class="left filter-select"' || CHR(62)) WITHIN GROUP (ORDER BY hr.storecode) OVER (PARTITION BY null) FROM scList hr]~(1;t)[/tlist_sql]</th>
<th class="left">~[tlist_sql; WITH scList AS (SELECT DISTINCT storecode FROM Honorroll hr WHERE HR.Yearid = ~(curyearid) AND HR.SchoolID = ~(curschoolID) ~[if#sc1.~(gpv.sc;sqlText)#] AND HR.storecode = '~(gpv.sc;sqlText)' [/if#sc1]) SELECT DISTINCT LISTAGG('GPA - ' || hr.storecode, CHR(60) || '/th' || CHR(62) || CHR(60) || 'th' || CHR(62)) WITHIN GROUP (ORDER BY hr.storecode) OVER (PARTITION BY null) FROM scList hr]~(1;t)[/tlist_sql] </th>
</tr>
</thead>
<tbody>
~[tlist_sql; WITH scList AS (SELECT DISTINCT storecode FROM Honorroll hr WHERE HR.Yearid = ~(curyearid) AND HR.SchoolID = ~(curschoolID) ~[if#sc1.~(gpv.sc;sqlText)#] AND HR.storecode = '~(gpv.sc;sqlText)' [/if#sc1])

Is there away we can add Teacher as a drop down for Class - Student Assignments Status. This report isnt actually about class, but about the specific student you select. Although we do want to review by student, we really need to manage top down, so department head to teacher. Can we have a drop down for teacher so department heads can review all grades for a specific teacher?

Additionally, is there anything in the works for category calculations. Its super frustrating that we can no longer pull category averages for teachers' sections like we could with the old gradebook. Would love to see something around that. Thanks for all that you do!

We are noticing this report only shows the last time grades were stored by the Permanent Stored Grades function. We have a lot of grades schools have updated by hand in Historical and it's still showing them out of sync. Is this how it should function? Or should it be showing the last time the historical was updated in general? Our schools are loving this report!

FYI:
When we run the Gradebook - Traditional Grade Calculations report, it shows records that are not correct. It shows three sections that are Total Points, but if you look in the teachers' Gradebook it shows it is the formula pushed out by the district. The school has a district Traditional Grade Calculation of category weights, that is pushed out and it is set to not allow teachers to change. I deleted and installed the plugin- which is the current version 2.1 and the problem still exists.

Hi,
It would be great to have a report that would total the amount if assignments a teacher has entered for a class. I was thinking it makes sense to have in the Class - Grades and Comments report since you can run by term. Or in the Update status report, but that cant be run by term, unless we can add that. That would be amazing! So helpful to quickly see who is or who has not added enough assignments. Thank you!

Report no longer gives choice to set dates. Only Teacher, Department, Stored Grade drop downs. No date. I have a screen shot. We deleted the plugin and reloaded it with no success. Most Last updated dates report as 0/0/0.

We installed the update for grading, and now we cannot select the grades we want to filter. Also the option to export is no longer there. Any Suggestions?

Good Afternoon,
Was reported that no results are appearing for sections where assignments are tied to more then one section. BASE Version is 3.0 and Grading plugin is 2.2

Report works for other sections where assignments are only for that specific section.

Here is the error in the PSJ-Runtime log

(User Type: Admin UID: 10A755) DALX ATTENTION! Critical Error generated from MWCP_ParseResponse Referer=https://greentechhigh.powerschool.com/admin/reports_pscb/grading/ClassGr... URL=admin/reports_pscb/grading/ClassGradesAssignments.html Description=java.sql.SQLException: Exception executing WITH adata AS ( SELECT sec.dcid sectionsdcid, sec.id, sec.course_number, sec.termid, asec.assignmentid, asec.name aname, asec.duedate, ascore.StudentsDCID, ascore.ACTUALSCOREENTERED, ascore.SCOREPERCENT, ascore.SCOREPOINTS, ascore.SCORELETTERGRADE ,CASE WHEN cc.sectionid < 0 THEN 'Inactive' ELSE 'Active' END status, cc.dateenrolled, cc.dateleft ,(CASE WHEN NVL(ascore.iscollected,0) = 1 THEN 'inline' ELSE 'none' END) collected ,(CASE WHEN NVL(ascore.islate,0) = 1 THEN 'inline' ELSE 'none' END) late ,(CASE WHEN NVL(ascore.ismissing,0) = 1 THEN 'inline' ELSE 'none' END) missing ,(CASE WHEN NVL(ascore.isexempt,0) = 1 THEN 'inline' ELSE 'none' END) exempt ,(CASE WHEN NVL(ascore.isabsent,0) = 1 THEN 'inline' ELSE 'none' END) absent ,(CASE WHEN NVL(ascore.isincomplete,0) = 1 THEN 'inline' ELSE 'none' END) incomplete ,(CASE WHEN tcat.isinfinalgrades = 0 THEN 'inline' ELSE 'none' END) notcalc FROM sections sec INNER JOIN assignmentsection asec ON (sec.DCID = asec.SectionsDCID) INNER JOIN assignmentscore ascore ON (asec.assignmentsectionid = ascore.assignmentsectionid) JOIN assignmentcategoryassoc acat ON (asec.assignmentsectionid = acat.assignmentsectionid) JOIN teachercategory tcat ON (tcat.teachercategoryid = acat.teachercategoryid) JOIN students s ON (ascore.StudentsDCID = s.dcid) JOIN cc ON (sec.id = ABS(cc.sectionid) AND sec.schoolid = cc.schoolid AND cc.StudentID = s.id) WHERE sec.id = 6144 AND CASE WHEN Upper(asec.publishoption) = 'ONSPECIFICDATE' THEN asec.publishonspecificdate WHEN Upper(asec.publishoption) = 'DAYSBEFOREDUE' THEN (asec.duedate - asec.publishdaysbeforedue) WHEN Upper(asec.publishoption) = 'ONDUEDATE' THEN asec.duedate ELSE asec.duedate END BETWEEN (SELECT date1 FROM termbins WHERE schoolid = 200 AND termid = sec.termid AND storecode = 'Q1') AND (SELECT date2 FROM termbins WHERE schoolid = 200 AND termid = sec.termid AND storecode = 'Q1') ) , StuGrid AS ( SELECT b.id sectionID, b.sectionsdcid, b.studentsdcid, a.assignmentid, a.aname, b.status, a.duedate FROM (SELECT DISTINCT assignmentid, aname, duedate FROM adata) a CROSS JOIN (SELECT DISTINCT id, sectionsdcid, studentsdcid, status FROM adata) b) SELECT DISTINCT 'Student Number' student_number, ' Student' lastfirst, 'Status' status, 'Grade Level' Grade_Level, 'GR Term' StoreCode, 'Grade' Grade, 'Percent' Percent, listagg(st.aname || ' (' || TO_CHAR(st.duedate,'MM/DD/YYYY') || ')',' ') WITHIN GROUP (ORDER BY st.duedate desc, st.assignmentID) Ascore FROM (SELECT DISTINCT assignmentid, aname, duedate FROM adata) st UNION SELECT DISTINCT to_char(s.student_number) student_number, s.lastfirst, st.status, to_char(s.grade_level) grade_level, pg.FinalGradeName storeCode, pg.Grade, TO_CHAR(pg.percent) Percent, listagg(NVL(ad.ActualScoreEntered || Decode(ad.collected, 'inline', 'c', '') || Decode(ad.late, 'inline', 'l', '') || Decode(ad.missing, 'inline', 'm', '') || Decode(ad.exempt, 'inline', 'e', '') || Decode(ad.absent, 'inline', 'a', '') || Decode(ad.incomplete, 'inline', 'i', '') || Decode(ad.notcalc, 'inline', 'x', ''), ' ') ,'') WITHIN GROUP (ORDER BY st.SectionsDCID, st.StudentsDCID, st.duedate desc, st.assignmentID) OVER (partition by st.SectionsDCID, st.StudentsDCID, st.status) Ascore FROM stugrid st LEFT OUTER JOIN adata ad ON (st.SectionsDCID = ad.SectionsDCID AND st.StudentsDCID = ad.StudentsDCID AND st.AssignmentID = ad.AssignmentID AND st.status = ad.status AND st.duedate BETWEEN ad.dateenrolled AND ad.dateleft) INNER JOIN students s on (st.studentsDCID = s.dcid) LEFT OUTER JOIN pgFinalGrades pg ON (st.sectionID = pg.SectionID AND s.id = pg.StudentID AND pg.FinalGradeName = 'Q1') ORDER BY 2 with 0 parameters: ORA-01489: result of string concatenation is too long

After updating to 2.2 I am finding that this report is not working as expected. I have over 500 class enrollments that are missing grades for all terms, yet when I run the report I get only 18 students and some of them do show a grade.

Hi,
We ran the out of sync report around November for our Q1. Then ran again to see if anymore were still out there and we got a whole bunch more. It is saying a bunch of changes were made yesterday and today for Q1. I used DDE to pull out the records to see transaction date vs score date and it looks like the date is not reflective of Q1 changes. I think something is off with the coding. Its pulling just the general last gradebook update. Its confusing to see and help to troubleshoot. Any help would be greatly appreciated!