PSCB - Custom Reports (Grading)

Submitted by PSCB on Thu, 05/31/2018 - 3:59pm

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 Verification
    Class - Low Grades (D, F and I)
    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 - Low Grades (D, F, and I)
    Stored Grades - Search
    Stored Grades - Search (w/ Log Info)
    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.

Powerschool Compatible Versions

10.x, 11.x, 12.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.

Customization:

Tags:

PS Verions

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

Comments

LSC0106

Fri, 12/14/2018 - 10:09am

The Class - Student Assignments Status allows you to run for a current selection of students. I do not see a student name column so you don't know which assignment belongs to which student in your selection.

Thank you!

PSCB

Fri, 12/14/2018 - 1:07pm

Thanks for bring this item to our attention.

This was an obvious oversight on our part. The student name will be include in the next release of the report in January.

--
Rob Staats
PSCB Development

shuffman

Fri, 01/25/2019 - 10:19am

Thank you for all of your hard work creating these reports. They are wonderful!!!
I have a question regarding this report. It doesn't give the overall grade for the class, it has the grade level of the student. I love how it shows all the assignments with scores, but it would be awesome if we could see the overall current grade as well. Is that something that could be added?

Shauna Huffman

PSCB

Fri, 01/25/2019 - 12:19pm

Thank you for your suggestion. The request has been added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

spoarch@caldwel...

Tue, 02/12/2019 - 10:49am

Teacher's Gradebook report says not turned on by Administration. How do I turn it on?

S. Poarch

ablazey

Wed, 02/13/2019 - 1:43pm

It would be great to add the ability to select which quarter you want to view assignments for. This could be a drop down at the top or the term can be included in the column so it can be filtered. Thanks!

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

PSCB

Wed, 02/13/2019 - 5:30pm

Thank you for your suggestion. This request has been added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

sross

Thu, 02/14/2019 - 8:24am

For this report, would it possible to add a Homeroom selection to this report to be able to see which homeroom students in each section belong to?

PSCB

Thu, 02/14/2019 - 9:29am

Thank you for your suggestion. This request has been added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

tony.duritsch

Thu, 02/28/2019 - 6:57am

Good Morning,

When trying to pull up the honor roll report I am not able to see any of the store codes we have set up in the drop down menus and I also cannot see any of our honor roll methods in the report drop down list. How can I get our store codes and honor roll methods to show up as selections on the report? Thanks for the help.

PSCB

Thu, 02/28/2019 - 9:09am

To use this report you need to store the grades and calculate the honor roll first.

Navigate to: System/Grades/Calculate Honor Roll.

After the calculation is completed, you will see the available menu options.

--
Rob Staats
PSCB Development

LSC0106

Thu, 02/28/2019 - 11:37am

Thank you for all these awesome reports! As we move users away from running reports in the the old custom reports area, will this bundle include Gradebook Percent vs. Letter Grade report?

Thank you!

PSCB

Thu, 02/28/2019 - 11:45am

I need more information on what you want included in Gradebook Percent vs. Letter Grade report. The existing Gradebook - Out of Sync Grades report may be what you are looking for.

--
Rob Staats
PSCB Development

LSC0106

Thu, 02/28/2019 - 2:07pm

The Gradebook Percent vs. Letter Grade report will show current gradebook grades that do not match the percent before they are stored. Thank you!

PSCB

Thu, 02/28/2019 - 2:13pm

I now understand what you are requesting. I will add this request to PSCB Enhancement List.

--
Rob Staats
PSCB Development

LSC0106

Thu, 02/28/2019 - 2:27pm

Thank you!

sross

Wed, 03/06/2019 - 6:03am

If a teacher marks a student as exempt from an assignment, the report shows a blank. It would be helpful to be able to distinguish exempt grades from missing grades in the report.

PSCB

Wed, 03/06/2019 - 2:22pm

Thank you for the suggestion. This will be added to the PSCB enhancement request list.

--
Rob Staats
PSCB Development

pdnethercott

Fri, 05/17/2019 - 7:23am

After looking into the code, found that the ExcludeFromStoredGrades condition is including only those with 0, but 2 is also a valid value.

In order to get them to work I changed the conditions from "= 0" to "!= 1".

I suspect that other reports may have this same issue.

PSCB

Fri, 05/17/2019 - 10:25am

Peter,

Thanks for bringing this issue to our attention. I will update the 5 associated grading reports with the code change you provided.

Rob Staats

--
Rob Staats
PSCB Development

godsbrat1

Wed, 05/29/2019 - 12:08pm

When running the Honor Roll Report if we run it for a large number of students the entire report runs but it doesn't list the student names after listing 170 students. The remainder of the report is listed but student names are left out. We are running it for all store codes, all methods, and all levels using a current selection of 243 students.

PSCB

Wed, 05/29/2019 - 3:16pm

This report has been tested in numerous districts of 1500+ students. No issues were encountered when running the report for all store codes, all methods, and all levels using all students.

You should check the log files on your server to see if you are encountering memory allocation issues.

--
Rob Staats
PSCB Development

D29_PSA

Tue, 07/09/2019 - 1:20pm

Class - Grades Search does not show "F" as an option. Base Resources was updated and installed v.1.7 of grading. Any suggestions?

PSCB

Thu, 07/11/2019 - 7:29am

The values for the the multi-select grades menu are auto generated from the grades that currently exist in the teacher grade book.

If the "F" grade does not appear on the menu it would indicate that no "F" grades currently exist in the grade books/year you are searching.

--
Rob Staats
PSCB Development

cgraham

Thu, 08/01/2019 - 11:52am

Student Potential/Earned Credit Summary
I have a couple of questions - is there a way to add a term to the drop down. We assign credit based on the F1 grade and it is not showing in the drop down. Also the grade level is only 9-12 could that be expanded to include 7 & 8. We have some middle school students that earn credit and they would like to be able to use this report also.
Thank you

PSCB

Mon, 08/05/2019 - 7:56am

The Student Potential/Earned Credit Summary report is school based only. It will only display credits for grades 9-12 in the current school.

The Store Code dropdown menu is auto generated by the store codes found in Historical grades. If a store code does not appear on the menu, it indicates that the store does not exist in historical grades.

PSCB has no plans to add additional grade levels at this time. You can customized the report if you want to include grades 7-8 from another school.

--
Rob Staats
PSCB Development

wstevens

Mon, 08/05/2019 - 11:53am

I don't believe I have actually used this particular report previously, but I was wondering if additional setup was needed somewhere that I'm unaware of. I would love to be able to run the report by specific teacher, but there is no drop-down available. It simply says All Teachers and that is the only option. We split courses at the semester so for example S13 is Biology Semester 1 and S14 is Semester 2. instead of running the report twice per course, ideally we would run it by each Science teacher individually and look at the info that way. Is anyone else having a similar issue where teachers aren't selectable?

PSCB

Mon, 08/05/2019 - 1:53pm

Check you plugin version number. Version 1.7 has a Select Teacher filter.

--
Rob Staats
PSCB Development

CarolinaSC77

Mon, 09/09/2019 - 9:25am

Normally a great report, but we are finding some bad data returns on just a few teachers...it will report a calc type as term weights, but the cacl items are coming back as Category item. We asked teachers to touch on the calc type, turn it off and back on again. it appears that we need a data refresh and can not get it to happen.
I just installed version 1.7 and that did not correct problem

PSCB

Mon, 09/09/2019 - 10:19am

The Gradebook - Traditional Grade Calculations report needs to be updated to be compatible with PowerSchool 19.x.

A new report should be ready by the end of September.

--
Rob Staats
PSCB Development

AmandaK-Reg1

Wed, 09/11/2019 - 11:26am

I am having an issue with this report as well. I set up a new traditional grade calculation formula this year. In PowerSchool, I marked the new formula as the default and removed the default status from the old formula as well as disabling the checkbox for that school. When I run this report it gives me two sets of calculation types per section - (1) category weighting and (1) total points. When I look at a teachers grade book setups I only see the category weighting. IS this report related or do I have something wrong in my set up?

Amanda Kilian
Region One District Application Coordinator

PSCB

Wed, 09/11/2019 - 5:31pm

Thank you for the feedback on this report.

The Gradebook - Traditional Grade Calculations report needs to be updated to be compatible with PowerSchool 19.x.

A new report should be ready by the end of September.

--
Rob Staats
RAS Technology / PSCB Development

--
Rob Staats
PSCB Development

janderson1139

Tue, 09/17/2019 - 1:24am

It appears that the Gradebook Update Status does not include sections that have not created any assignments yet at all. I have several sections that have 0 grades or assignments (after 3 weeks of school...) but they are not listed in the report.

Looks like the SQL in the report that would be causing that inconsistency is:
"INNER JOIN (SELECT MAX(LastGradeUpdate) Lastupdate, SECTIONID FROM PGFinalGrades GROUP BY SECTIONID) PGFG ON PGFG.SectionID = Sections.ID"
I think there is nothing in the PGFinalGrades table until a teacher creates an assignment, so that section doesn't get joined to anything and isn't listed. Any way to change the SQL so that the lastupdate day is the start of term if there is nothing in the PGFinalGrades table for a section?

PSCB

Tue, 09/17/2019 - 8:37am

Thanks for your suggested revision. We will try to incorporate the change in the next release of the grading reports plugin.

--
Rob Staats
PSCB Development

kristiehayes

Wed, 09/18/2019 - 12:26pm

The last update column for grades shows 01/01/1900 as the teacher last update of grades? Is there a way to fix that?

PSCB

Thu, 09/19/2019 - 6:52pm

Does the 01/01/1900 date show for all teachers?

If date show 01/01/1900, has that teacher created any assignments for the current year?

--
Rob Staats
PSCB Development

kristiehayes

Thu, 09/19/2019 - 6:59pm

Yes we have been in school for 5 1/2 weeks. In the DDE table I can see when grades were last updated with the field LastGradeUpdate. I have updated to the latest version.

kristiehayes

Thu, 09/19/2019 - 7:00pm

My principal loves this report! He used it all last year.

kristiehayes

Thu, 09/19/2019 - 7:03pm

01/01/1900 is the last update date that is used for all teachers! All my teachers have had a lot of assignments this quarter. We started school 8/15/2019. We have are past the midterm already/

nkowalchik

Tue, 10/22/2019 - 8:27am

This report returns ALL the possible grade calculations setup at the district level for this school.

Q1 Category_Weighting (85)(30)(60)(2)(1)(15)(10)

PSCB

Tue, 10/22/2019 - 4:03pm

The Traditional Grade Calculations report is not fully compatible with Powerschool 19.x. An updated version of the report is currently under development.

--
Rob Staats
PSCB Development

jwydra

Wed, 10/23/2019 - 12:48pm

Gradebook - Traditonal Grade Calculations View a list of tradiitonal grade calculation setups for each class.

Traditional is spelled wrong x2, just thought I should let someone know ;)

PSCB

Wed, 10/23/2019 - 2:39pm

Thanks for making us aware of the typo(s).

--
Rob Staats
PSCB Development

AmandaK-Reg1

Thu, 10/31/2019 - 7:59am

Do we have an update on when the new version of the Traditional Grade Calculations report will be available?

Amanda Kilian
Region One District Application Coordinator

PSCB

Thu, 10/31/2019 - 2:42pm

The new Gradebook - Traditional Grade Calculations report is still under development. No release date has been set.

--
Rob Staats
PSCB Development

PSCB

Fri, 11/01/2019 - 12:33pm

Update: The new Gradebook - Traditional Grade Calculations report is nearly completed. Updated version is expected to be published next week

--
Rob Staats
PSCB Development

wstevens

Mon, 11/04/2019 - 12:25pm

I always loved using the Letter Grades Report from the old CRB to search for only students meeting a certain minimum threshold. So much so, that I never uninstalled the CRB reports when upgrading to the PSCB suite. Recently I was asked about pulling that report but including student number. I attempted to just add in what I assumed was the appropriate code, but no matter what I do it only displays the internal student ID (the same as on Teacher Comments), not the student_number. Does anyone have any tips? Alternatively, is there any thought to adding an optional minimum # of occurrences to the class/stored grades - search reports within this plugin? It would be greatly appreciated and I'm sure I'm not the only user who loves that functionality as it's a huge timesaver over exporting and manually filtering to students with 2, 3, etc. failing or low grades.

PSCB

Mon, 11/04/2019 - 6:02pm

The current PSCB Class - Grades Search report already includes the student number.

A Minimum # of occurrences option will be included in the next release of the PSCB Stored Grades - Search report.

--
Rob Staats
PSCB Development

wstevens

Mon, 11/25/2019 - 11:51am

Thanks for the update. My comment was probably a bit confusing as it was disjointed. I had meant I was trying to add student number into the old letter grades report, but with the update to add minimum # into PSCB, it does everything we need.

Thanks again for the great work on these plugins!

jwydra

Mon, 11/11/2019 - 1:52pm

Good morning,

I just installed the latest version (1.8) and the Traditional Grade Calculations report is showing that we have several classes that are using total points but when I look at teacher's PowerTeacher Pro traditional grade calculations, I see the categories that are pushed out through district. The only classes at our school that use total points are those that do not have assignments. Does anyone know why this may be?

Pages

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