PSCB - Custom Reports (Grading)

View PSCB Plugin Directory

Version 2.3

Description

This bundle includes 25 grading reports organized into two categories.

Grading - PT Pro Gradebook

    Class - Grades and Assignment Scores
    Class - Grades and Comments
    Class - Grades Search
    Class - Grades Verification
    Class - Percent Grades Range
    Class - Student Assignments Status
    Gradebook - Categories
    Gradebook - Class Descriptions
    Gradebook - Manual Override Grades
    Gradebook - Missing Grades
    Gradebook - Out of Sync Grades
    Gradebook - Out of Sync Numeric Grades
    Gradebook - Section Readiness
    Gradebook - Teacher Preferences
    Gradebook - Traditional Grade Calculations
    Gradebook - Update Status

Grading - Stored Grades

    Stored Grades - By Course/Teacher
    Stored Grades - By Student
    Stored Grades - Duplicate Grades
    Stored Grades - Honor Roll
    Stored Grades - Missing / Blank Grades
    Stored Grades - Search
    Stored Grades - Search (Grade Modifications)
    Stored Grades - Summary
    Student Potential/Earned Credits Summary

Acknowledgements

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

PowerData Solutions Contributors
Jason Treadwell
Brent Johnson
Brian Andle
Tim Scoff
Matt Freund
Roger Sprik
Dean Dahlvang

Other Contributors
Jason Springel - Thank you for your assistance and guidance on the Traditional Grades Calculations report.

Version Info

1.0 (2018-05-23)
- Initial Release

1.1 (2018-06-19)
- Updated Manual Override Grades report to work with PT Pro gradebook.

1.2 (2018-08-10)
- The following reports have been updated.

Class - Low Grades
Users can multi-select the grades to be included in the report.

Class - Student Assignments Status
Report lists all YTD assignments for a selected student.

Stored Grades - Missing Grades
The report contains an All Terms filter option.

Stored Grades - Low Grades
User can now multi-select the grades to be included in the report.

1.3 (2018-10-28)
- The following reports have been added to the bundle.

Gradebook - Categories
View a list of teacher gradebook categories.

Gradebook - Class Descriptions
View a list of teacher class descriptions and custom names.

Gradebook - Section Readiness
View a list of verified/unverified gradebook sections for a selected store code.

Gradebook - Teacher Preferences
View a list of teacher gradebook preferences.

Gradebook - Traditional Grade Calculations
View a list of traditional grade calculation setups for each class.

1.4 (2018-11-07)
- The following reports have been updated.

Gradebook - Traditional Grade Calculations
Added Filter to include/exclude courses that not store grades.

Stored Grades - Search (w/ Log Info)
Added Filter to view only modify stored grades.

1.5 (2019-05-09)
- The update includes the following:

• Class - Grades and Assignment Scores
Added Current Grade & Percent for selected store code.
Assignment Status Codes ( Missing, Late, etc) has been added for each assignment.

• Class - Student Assignments Status
Added report filters for Store Code and Assignment Status Code.
Added Student Number, Student Name, Student Grade Level and Store Code to the report results.

• Class - Grade Verification
Added Course Name to report results.

• Class - Grades Search
The Class - Low Grades report has been renamed to reflect the multi-select grades functionality.

• Stored Grades - Honor Roll
Added option for viewing Honor Status for all store codes.

• Gradebook - Out of Sync Numeric Grades
New Report - Shows all out of sync grade book numeric grades.

1.6 (2019-06-10)
- The Gradebook - Out of Sync Grades report now includes an edit link for the stored grade.

1.7 (2019-07-12)
- An ~[cust.insertion_point:pscb.grading] was added to the Grading Reports menu (PSCB_grading.html)
- This provides users with a method to add links for their own custom grading reports to the Grading Menu.

1.8 (2019-11-05)
- Updated the Gradebook - Traditional Grade Calculations report. The report is now compatible with PowerSchool versions 12.x - 19.x.

2.0 (2020-04-07)
- Sql coding updated for all reports.
- Added auto generated drop-down menu options to the column filters in all reports.
- This updated bundle includes 15 PSCB user enhancement requests.

2.1 (2020-04-11)
- Fixed a display issue with the Stored Grades - By Course/Teacher report.
- Added additional report filter to several reports.

2.2 (2020-11-16)
- Fixed a display issue with the Stored Grades - Honor Roll report.
- Added additional report filters to the Gradebook - Update Status report.

2.3 (2021-01-27)
- Updated the Stored Grades - Missing / Blank Grades report.
- Added new report: Stored Grades - Duplicate Grades.

Powerschool Compatible Versions

20.x, 19.x

Additional Plugin Requirement

The following PSCB plugins should be installed prior to the installation of this reports bundle.

PSCB - Base Resources
PSCB - Custom Reports (_Home Page)

Installation

Install in System > System Settings > Plugin Management Configuration

Do not unzip the plugin. Install the entire zip file. Be sure to enable the plugin once it's installed.

If you are updating, you can now click on the Plugin name and then use the Update button, and then browse to the new file and click Submit and it will then load the update and then ask you to enable it.

Instructions

Select a school and go to the Powerschool start page.
Click on the PSCB Custom Reports link on the left navigation menu.
Click on the Grading link to access the Grading Reports menu.

Tags:

PS Verions

12.x: 
N
19.4: 
Y
Plugin: 
Y
CPM Import Friendly: 
Y
Report Type: 
Web Based Report
19.11: 
Y
20.4: 
Y

Comments

Is it possible to get help to troubleshoot why this is only showing 2 of the Weights instead of the 3 that are in there?
It is showing the correct values. Most everything displaying is correct. Just missing a few things.

Melissa A Dubbs

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

Melissa A Dubbs

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

Sorry - not at this time. I will add the request to the PSCB Enhancement list.

--
Rob Staats
PSCB Development

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

You need to update to PSCB - Custom Reports (Grading) v2.1.

This version uses the final grade setup term bins.

--
Rob Staats
PSCB Development

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!!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

Reinstall the latest PSCB Grading plugin.

--
Rob Staats
PSCB Development

This is still not working. Any ideas?

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

How have you determined that the Gradebook - Update Status report is not working correctly?

--
Rob Staats
PSCB Development

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?

Has the teacher created any assignments and entered scores for the section.

--
Rob Staats
PSCB Development

Assignments have been created, no scores have been entered.

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

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

You need to click on the Select Student(s) menu and choose:
Current Selection or an Individual Student.

--
Rob Staats
PSCB Development

WOW, sorry about that. Thank you!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

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!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

PSCB has no plans to add a Department filter option at this time. After running the report, you can use the column filter to select a department.

--
Rob Staats
PSCB Development

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?

The report excludes any course that has the course "Exclude From Storing Final Grades" preference setting box checked.

--
Rob Staats
PSCB Development

Is there a way to get grades by categories?

The Class - Student Assignments Status report includes the category assigned to each assignment and score.

After running the report you can use the Category column options to filter or sort the results.

--
Rob Staats
PSCB Development

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

The Gradebook update status reflects the most recent date that the teacher used the grade book to enter information (assignments, grades, etc.)

--
Rob Staats
PSCB Development

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])

Thanks for bringing this issue to our attention. We will review the report and make changes where necessary.

--
Rob Staats
PSCB Development

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!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

These requests have been added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

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.

If you want to explore this issue via a conference call or Zoom meeting, please send your contact info to:

pscb.development@gmail.com

--
Rob Staats
PSCB Development

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!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

PSCB is developing a class assignments/category summary report. It will be included in the next release of the Grading report plugin. No release date has been determined.

--
Rob Staats
PSCB Development

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.

The report was updated to include additional filters. A column filter was added for the date.

To select your date range type >xx/xx/xxx in the box under the date heading. The report will automatically refresh to to display the filtered results.

--
Rob Staats
PSCB Development

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?

Please confirm that you have the following plugins installed and enabled.

PSCB - Custom Reports (Grading) v2.2
PSCB - Base Resources v3.0
PSCB - Custom Reports (_Home Page) v2.0

Also confirm that the Final Grade/Reporting Term Setup has been completed.

The PSCB Grading bundle contains the following reports.

Grading - PT Pro Gradebook
Class - Grades Search
View all Gradebook Letter Grades for selected low grades(s) and term.

Grading - Stored Grades
Stored Grades - Search
Search all Stored Grades for a selected term and letter grade.

Which of these reports is not working properly.

--
Rob Staats
PSCB Development

Rob,
Thank you so much, I missed the Base Resources. works great.
Gail

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

Thanks for bringing this issue to our attention. It be corrected in the next release of the PSCB Grading bundle.

--
Rob Staats
PSCB Development

I was able to run the report on several of our production servers. In each case an assignment was created and assigned to two or more sections. The report generated correct results when executed on all of the servers.

The Oracle error message ORA-01489: result of string concatenation is too long would indicate the problem is related to the number of assignments and length of the assignment names.

Oracle has a limit of 4000 characters on concatenation. I would suggest that you review the PowerTeacher Pro assignments list.

--
Rob Staats
PSCB Development

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.

Cheryl Ulsh
KRESA/EFE

If you would like to schedule a Zoom conference call to review this issue, please send your contact information to:

pscb.development@gmail.com

--
Rob Staats
PSCB Development

Could this be due to a teacher never having opened the gradebook? If there was never any activity in the gradebook would it prevent these missing grades from showing up?

Cheryl Ulsh
KRESA/EFE

Yes. The teacher needs have opened the PT Pro gradebook and create at least one assignment for the class.

--
Rob Staats
PSCB Development

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!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

Pages

Subscribe to Comments for "PSCB - Custom Reports (Grading)"