PSCB - Custom Reports (Grading)

View PSCB Plugin Directory

Version 2.1

Description

This bundle includes 23 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 - Section Readiness
    Gradebook - Teacher Preferences
    Gradebook - Traditional Grade Calculations
    Gradebook - Out of Sync Grades
    Gradebook - Update Status

Grading - Stored Grades

    Stored Grades - By Course/Teacher
    Stored Grades - Honor Roll
    Stored Grades - Missing 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.

Powerschool Compatible Versions

12.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

Pages

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