PSCB - Custom Reports (Grading) 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: 
Y
19.4: 
Y
Plugin: 
Y
CPM Import Friendly: 
Y
Report Type: 
Web Based Report

Comments

We are not able to recreate the issue you described and the issue has not been reported by any of 30+ school districts that test our reports.

If the issue is occurring in only a few classes, then the problem is most likely with the traditional grade calculations set for the those classes.

Have the teachers manually reentered the calculation they want to use and submit. Rerun the report and see the proper calculation is displayed.

--
Rob Staats
PSCB Development

What determines how a Teacher ends up on this report. We have Teachers that have not updated thiers grades for over 30 days but do not show up.

Thank you

Terry Morrow

1. Are your teachers using the PT Pro Gradebook?

2. What value are you entering in the "Check for Classes that haven't been updated in x day(s)" box?

--
Rob Staats
PSCB Development

When I try to run the honor roll report my data comes out really strange...goes way across that page and it not lined up. I also have to hit submit twice to even get any data. I have tried FireFox and Chrome. I also tried to generate the report as a PDF and it just sits there.

What version of Powerschool is currently installed on your server?

--
Rob Staats
PSCB Development

Hi, We were running this report and noticed that students who are no longer enrolled in the class are pulling into this report. It makes it difficult to see if the grade is missing or if they are just no longer in that section. Can we add something so those student do not pull into the report? Thanks!

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

This will be addressed in the next release of the PSCB - Custom Reports (Grading) plugin.

--
Rob Staats
PSCB Development

Thanks Rob,
It would also be really helpful to add a department column to this report. It would more easily allow our staff to filter out the teachers they manage and get a clearer sense of how many grades are actually missing. Also we see that Advisory and a few other classes are pulling in that dont receive a grade. Any suggestions on how we can get those classes out? Thanks!

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

Request will be added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

Hi Again,
It would be great to add more filtering ability to this report. All of subject areas are providing comments, so the file is very big and actually slows down PowerSchool. Can we maybe add the ability to select by department before clicking submit to run the report? Thanks!

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

Request will be added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

Hi,
I am curious, which GPA is being calculated in the Honor Roll report. I want to make sure what is being pulled is accurate. Thanks!

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

The report uses the GPA Calculation assigned to the Honor Roll Method selected.

--
Rob Staats
PSCB Development

Hi Thank you again for all of your work on these, it is so helpful!

For the Class - Grades Verification report, students who are no longer enrolled in the class are on the report. Can you add in active/inactive so we can filter them out? It makes it hard to review grade completion.

Thanks!

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

This request will be added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

Is there any enhancements in the works to get a report with more detailed GPA data? Thanks!

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

Not at this time.

--
Rob Staats
PSCB Development

Hi,
Just wanted to check if there would be a new release of these reports soon? We are launching these reports and want to be able to show the most up to date version if there is a new one soon. Thanks!

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

The next update of the PSCB - Custom Reports (Grading bundle is scheduled for early March.

--
Rob Staats
PSCB Development

Thank you!

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

This report displays the Gradebook Grade and Percentage for one student in one section different from the actual Gradebook Grade and Percentage that are entered in the teacher's PowerTeacher Pro gradebook. Is there an explanation for why this happens? (The Stored Grade and Percentage match the Teacher's Gradebook.) The Teacher's Gradebook was not changed after grades were stored.

This could related to a rounding issue. Check both the stored grade percent and the gradebook percent to see if they are displayed with a decimal.

You can also download and install the Out-of-Sync Grades Alert plugin available on the PowerSource Exchange. Check to see if you get the same out of sync result.

https://support.powerschool.com/exchange/view.action?download.id=597&fro...

--
Rob Staats
PSCB Development

Hi,
I just ran the honor roll report for Q2 and about half way through the report, no student names or student numbers appear, all other columns are filled with level and GPA. Please let me know how to troubleshoot, we need this data for an Award ceremony this week. Thanks!

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

PSCB can not duplicate the error you described. Try running the report using a different web browser.

--
Rob Staats
PSCB Development

Hi,
When I am running this report for reviewing all quarters for students who have more than 1 F, the Term ID does not pull in so I cannot tell what quarter/term the F is from. Can we add that to the report? It has storecode, but because its current grades, I dont think a store code exists. Thanks!

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

This request will included in the next release of the plugin in late February.

--
Rob Staats
PSCB Development

THANK YOU!

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

I'm having a problem running the "List Class Detail" report. If I choose "all students" I get data back as expected, but if I choose "current selection" it never works (even if my current selection is all students). I get a message that says "no data in table".

Not sure which report you are referring to. PSCB does not have a List Class Detail report.

--
Rob Staats
PSCB Development

Good Morning,

I wanted to see how I changed the term display to pull in store codes for our midterm stored grades. The term display does not have the option right now for me to select M2 stored grades. How to I add that term into the term display drop down selections?

The Term dropdown menu is auto generated from your Final Grade/Reporting Term Setup. Confirm that you have created the M2 reporting term on the setup page.

--
Rob Staats
PSCB Development

RE: Grading / Stored Grades - By Course/Teacher
I notice that this is pulling from the gradebook and not Stored Grades. Is it meant to be like that?
For instance, I ran it will all store codes and we do not have any "Stored Grades" for "F1's" (Final Grades) for full year courses, yet but this report shows the F1's for most classes.
Another example using your "Out of Sync Grades" report verifies that the grades for the Stored Grades report are pulling from the gradebook and not Stored Grades.
Thank you.

The Grading / Stored Grades - By Course/Teacher issue you described will be addressed in the next release of the plugin.

--
Rob Staats
PSCB Development

The issue you described with Grading / Stored Grades - By Course/Teacher report has been fixed in version 2.1. The updated plugin was published today.

--
Rob Staats
PSCB Development

The Gradebook - Out of Sync Grades report compares Gradebook grades and the corresponding stored grades that have been stored to date. The sql retrieves grades from both the Gradebook and Stored Grades.

--
Rob Staats
PSCB Development

Hi,
We store a progress report grade in the middle of each quarter. But I am not seeing it pull in the grading reports, current or stored. Any ideas on how to fix that? Thanks!

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

Updating fixed it, thank you!

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

I've added new grade options to grade scales for remote learning but these are not showing as options on the Class-Grades Search. I've tried deleting and reinstalling the plugin with no luck. Any suggestions? Thank you.

The grades drop-down menu is generated from term grades that currently exist in the teacher's gradebook.

If you do not see grade in the menu, it indicates that the grade has not yet been used in a teacher gradebook for the current year.

--
Rob Staats
PSCB Development

This plugin is awesome! Thank you.

I have a principal who is pulling the Student Assignment Status report every week to see how many incomplete assignments there are. As the marking period progresses he would love to be able to choose a date range as some assignments become ..." less relevant".

Thanks so much for your amazing work!
Aaron

Aaron M Noll

You can filter due date by typing in the column filter box.

Example 1: >11/1/2019

Example 2: <12/3/2019

--
Rob Staats
PSCB Development

The department filter doesn't include departments for courses that are created at the district level. In the query the filter c.schoolid = ~(curschoolid) is excluding district courses because those courses have the schoolid 0.

Thanks for bringing this issue to our attention. It will be addressed in the next release of the plugin.

--
Rob Staats
PSCB Development

Pages

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