PSCB - Custom Reports (Grading)

View PSCB Plugin Directory

Version 3.0

Description

This bundle includes 30 grading reports organized into two categories.

Grading - PT Pro Gradebook

    Class - Assignment Metrics
    Class - Category and Assignments Summary
    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 - Percent Change
    Gradebook - Section Metrics
    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 Earned Credits Summary By Credit Type
    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.
Adrian Carlson - Thank you for the primary development of the Gradebook - Percent Change and Gradebook - Section Metrics reports

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.

2.4 (2021-02-18)
- Added student grade level to Out of Sync Grade reports.
- Added Classes not updated in X days option to Gradebook - Update Status report.
- Added GPA Points, Potential Credits, Earned Credits and Credit Type to Stored Grades – Search report.

2.5 (2021-03-31)
- Added two new reports.
Class - Assignment Metrics
Class - Category and Assignments Summary

2.6 (2021-04-08)
- Added Department to the following reports.
Class - Assignment Metrics
Class - Category and Assignments Summary
- Added Category Weights to the Class - Category and Assignments Summary report.
- Added alternate row shading by selected report column to the Class - Grades and Comments report

2.7 (2021-04-10)
Fixed incorrect menu link for the Class - Grades and Assignments report.

2.8 (2021-04-25)
- Added Student Earned Credits Summary By Credit Type report.

2.9 (2021-05-23)
- Added an Out of Sync Grade/Percent validation feature to the following reports.
Gradebook - Manual Override Grades
Stored Grades - Search (Grade Modifications)

3.0 (2021-07-05)
- Added Year filter to Stored Grades - Honor Roll report.
- Special thanks is extended to Adrian Carlson as the primary developer of the following two new reports.
Gradebook - Percent Change
View a list of students who have a specified percent change between two terms.
Gradebook - Section Metrics
View section metrics for selected reporting term, teachers and departments.

Powerschool Compatible Versions

21.x, 20.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:

Report Type: 
Web Based Report
Compatible PS Versions: 
21.x, 20.x
Plugin: 
Y
CPM Import Friendly: 
Y

Comments

That report was redesigned in the last update. After running the report you can use the sorting/filtering options available for the Last Update column.

Sort: ascending/descending
Filter By Date: Type <1/2/2021 or >10/4 2020 in the Last Updated filter box.

--
Rob Staats
PSCB Development

The "Gradebook - Out of Sync Grades" is an amazing report that is used frequently in our district. The secondary counselors have requested the addition of the grade level to the report. I told them I would request it. Thank you for all of the wonderful reports and customizations you provide!!

The grade level will be included in the next release of the report.

--
Rob Staats
PSCB Development

The old Custom Reports "Last Gradebook Update Search for gradebooks that haven't been updated in X days. Custom Report Bundle 4.1" - allows you to enter a certain number of days for the last update and will return an accurate selection of classes that have not been updated since that last date.
The PSCB report of the same name and description - "Gradebook - Update Status Search for gradebooks that haven't been updated in X days." (Just updated with version 2.3) does not allow you to search by 'x' number of days at all. And will pull all sections regardless of when it was last updated. I don't mind the additional information provided in the PSCB report, however, the old Custom Report was more accurate and more useful.
We are attempting to remove the old CRB reports, however, this is the second grouping I've had to re-enable because the old report was better.
Please consider updating the PSCB report to provide the same report parameter and accurate results.
Thanks,
Lynne

Lynne

Thanks for you comment. The search for X days option will be in the next release of the report. What is other CRB customization that you continue to use?

--
Rob Staats
PSCB Development

Thank you so much for the quick response. The Scheduling Live Report in CRB is associated to a point in time (has a date reference) and when the date is entered, the results reflect teachers free in term for that date. In the PSCB report, there is no date association and the report pulls every free period regardless of term - so a teacher with year long classes meeting 1st period A, and another year long class 1st period B day, shows free for S1 and S2 - this doesn't happen on the CRB Teacher Free report.
Thanks for listening.
Lynne

Lynne

The next release of the PSCB Teacher Free report will include the date option from the previous CRB report.

--
Rob Staats
PSCB Development

It would be great to have this report also show GPA points and Earned Credit. When we modify grades, we also need to update the GPA value and if they earned credits. It will be helpful to see all of this to triple check we've done all 3. Thanks!

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

The GPA Value and Earned Credits will be included in the next release of this report.

--
Rob Staats
PSCB Development

It would be great to add credit type on this report. Or add a new report that has a break down of credits earned/potential by credit type. Thanks for everything you do!

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

Credit Type was added in the latest release of this report.

--
Rob Staats
PSCB Development

Hi, Thank you for the new updates. Very helpful! Is there a way we can add the department filter to those 2 reports? That way our department heads can run all of the teachers in their department at the same time.
Thank you!

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

I am getting this error - "The page you have requested could not be found on this server. (error 404)." when trying to run PSCB Custom Reports>Grading>Class-Grade Search.
I have the most recent version uploaded to PowerSchool (v2.5). All the other reports under Grading are working just fine.
Thank you.

Sheryl Blosel

Confirm that you installed and enabled version 1.5 of the Grading Reports plugin.

--
Rob Staats
PSCB Development

I am getting this error too. I have version 2.5 installed and enabled. Is there any way I can revert back to 2.4? Our athletics dept needs this report for eligibility. It looks like the file name for ClassGradesSearch has an underscore at the end. I cannot rename the file

Nancy L Van Volkenburg

File name was corrected and v2.5 has been re-published on PDS.

--
Rob Staats
PSCB Development

Thank you!

Nancy L Van Volkenburg

Hi Rob, with the new version when I try to run the Class - Grade Search report I get an error message. Error 404 The page you requested could not be found on this server.
I've uninstalled and reinstalled the plugin. Still no luck. I uninstalled and installed PSCB Grading 2.4 and it works.
This is happening for each of the school districts I have checked.
Any ideas?
Thanks

This issue was fixed in an update to version 2.6 which was republished on 4/8/20.

--
Rob Staats
PSCB Development

Hello,

We updated the version on this to version 2.6 and still getting a 404 error
Do we need to go back to an older updated?

Delete the currently installed plugin.
Navigate to PowerData Solutions and re-download version 2.6
Install and enable the plugin.

--
Rob Staats
PSCB Development

Hi Rob,

We are still getting that error when I try and open up class grades and assignments. I deleted the old plugin and reinstalled the v2.6 as instructed no changes

This issue was corrected in v2.7 which was published today.

--
Rob Staats
PSCB Development

Hi Rob, we are currently on version 2.7 for the PSCB Custom Reports (Grading) and prior to 2.7 when we ran the Update Status report, it only pulled currently running sections. When we run the report now in the version 2.7, it is pulling all sections with the >10 days - even sections that are no longer active, they were only Semester 1 or a past quarter class. Is there a way that it only could view currently active sections based on their term?

This issue has been corrected in version 2.8, scheduled for release on 5/14/21.
The update will also include several new grading reports.

--
Rob Staats
PSCB Development

Hi guys, was just wondering what happened to the Assignment Flags report that I saw in here earlier?
Thanks

The Class - Grades and Assignment Scores report displays the assignment flag for each student score.

--
Rob Staats
PSCB Development

The Class - Grades and Assignment Scores report displays the assignment flag for each student score.
The Class - Student Assignments Status also displays the assignment flag.

--
Rob Staats
PSCB Development

Thanks Rob, just saw the report in my test site and couldn't see it in any of my lives ones and was wondering what was up. All sites had version 2.8 so I was a little confused.

Have you ever seen the report pull the wrong info? For instance, there is a teacher calc (editable by teacher) showing Term Weighting for the course final grade but instead of showing the actual weighting of the terms (such as Q1 - 25%, Q2 - 25%) it is showing Y1 term weighting but lists category weighting. In the PT Pro gradebook everything looks good but the report is showing different information.

We are currently on version 2.8 and when Gradebook - Out of Sync Numeric Grades is run, all grades seem to display and they are not out of sync. I'm wondering if I am missing something. Thank you.

If you would like to setup a Zoom session to review this issue, please send your contact info to pscb.development@gmail.com. I will then contact you to schedule a session.

Rob Staats

Project Director
PSCB Development

--
Rob Staats
PSCB Development

Sent Zoom Request

Thank you,

I am using reg gradebook. When teacher changes grade could be manual override or adjusted an assignment the new grade does not show on the report

This report compares teacher gradebook grades versus stored grades. If a teacher changes a grade in a term that has not yet been stored, that change will not appear as out of sync on the report.

--
Rob Staats
PSCB Development

This report works fine for my HS but not my MS. In the MS it only pulls the specials classes and not the core classes. I compared all settings that I can think of but I cannot seem to figure out what's missing.

The report excludes courses that have the Course preference "Exclude From Stored Grades" checked. Check this preference for all courses.

--
Rob Staats
PSCB Development

This report works only if you choose an individual teacher. If you choose ALL TEACHERS it fails. Is this something that can be fixed or should the option to choose all be removed?

Thanks for all you do.

Sharon

Hi,
Is there anyway in the manual override report, to also pull in what the calculated grade is? We are noticing teachers are overriding grades to a number that is LOWER than the actual calculated grade and we would love to be able to flag that and have them remove their override.

Thank you!

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

Manually overriding a grade replaces the calculated grade and percent. As a result the original calculation it is no longer available for display.

--
Rob Staats
PSCB Development

Ah got it. I see in the PowerTeacher Pro, so I figured you would be able to pull it out somehow. Thank you!

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

I use these grading reports a ton, and only now noticed that when I export to CSV and open the file in excel any course.section that ends in zero has the zero dropped.. so course.10 and course.1 both end up as course.1 and it is wrecking havoc when I merge with other data. Is this something that can be corrected? Or am I doing something wrong? Please let me know. I basically just add the TERM to the report so we know if a course was S1 or S2 or FY.. If that was added to the Stored Grades - By Course/Teacher report - I wouldn't even need those zeros.

Pages

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