PSCB - Custom Reports (PowerScheduler) 2.2

Description

This bundle includes 24 PowerScheduler reports organized into 2 categories.

There are a couple core reports that are included but were enhanced by adding sorting capabilities. Some reports are updates to previously published PDS reports. Numerous new PSCB reports are also included.

Pre Build Reports

    Course List.
    Course Recommendations
    Course Recommendations Not Given
    Course Relationships
    Course Request Tally
    Course Requests / Sections Tally
    Course Requests by Student or Course
    Room List
    Student List
    Student Request Tally
    Students With Duplicate Schedule Requests
    Students With No Schedule Requests
    Teacher Course Assignments
    Teacher List

Post Build Reports

    Master Schedule List
    Master Schedule List (Team / House)
    Room Availability
    Room Conflicts
    Schedule Course Enrollment
    Schedule Pre-Commit Validation Report
    Schedule Results by Grade
    Student Non-scheduled Course Requests
    Student Scheduled Percent
    Student Scheduled Requests Summary

Acknowledgements

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

Other Contributors
Brian Andle

Version Info

1.3 (2018-05-17)
- Initial Release

1.3.1 (2018-06-09)
- Changed the column display order on the Course Relationships report.

1.4 (2018-08-10)
- Two new reports added to the Post Build Reports category
Room Availability
Room Conflicts

2.0 (2020-01-20)
- The PSCB Custom Reports link now appears on both the PowerScheduler Start Page and the PowerScheduler Students page.
- The Make Current Student Selection button now navigates to PowerScheduler Students page.
- Added auto generated drop-down menu options to the column filters in all reports.
- Numerous data elements were added to many reports.

2.1 (2020-02-06)
- Updated Department filter on the Course Recommendations report.

2.2 (2020-02-11)
- Added course credits to the Course Requests by Student or Course report.
- Updated formatting for numerous 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 3.0

Installation

NOTE: Delete all previous versions of the PowerScheduler Reports plugin before installing PSCB - Reports (PowerScheduler) 2.0.

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.

Instructions

Navigate to a school that uses PowerScheduler.
Click on PowerScheduler.
Click the PSCB Custom Reports link located at the top left of the PowerScheduler Navigational Menu.

PS Verions

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

Comments

When I run the Course Recommendations Report by Department, it does not show me all recommendations for all classes within that department. However, when I list All Departments and choose the classes one by one from the Course list, it shows recommendations for the courses which did not appear in the department listing.

Do you have the correct department assigned to each course in your course setup?

--
Rob Staats
PSCB Development

We've been running this report successfully for a while now, but just today we noticed that sorting by course sometimes does not give us the correct number of requests. For example, we have 30 requests for AP Calculus AB, but if I use the drop down in the report to show AP Calculus AB, the report says that there are 0 requests. If I choose another course, sometimes I get the correct number and sometimes it shows 0. Any ideas on why this is?

Confirm that you have installed and enabled PSCB - Base Resources 2.3

Run the PSCB PowerScheduler - Course List report and confirm that the Terms Offered data has been entered correctly for all courses.

--
Rob Staats
PSCB Development

Once you commit your schedule is there a report that you know of that we can get this same information on the live side?

Dana Bridgeforth

Hi,
I am working on getting in all the post/prerequis. into the Course_Relationship table so that it will run in the Course Relationship report. When I run the PSCB report, it does not match what I am pulling out of the course_relationship table. Does this data live in a different table? If so which one is it pulling from so I can accurately update the data. Thank you!

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

The report lists the course relationships entered into the active PowerScheduler build. This information in stored in the ScheduleCourseRelationships (78) table.

--
Rob Staats
PSCB Development

THANK YOU! I just imported a few updated relationships, I see them in the DDE, but they are not pulling into that relationship report. Any other suggestions? Thanks!

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

Hi,
There is a field we use often because we need students to choose their alternative course. So if they want to take engineering, but it is not offered the period they are free, we have them select another course, so Robotics, that would be the alternative choice for a science credit. I do not currently see a report that could pull that. Is there a way we can get a report that would pull "AlternateCourseName1" that lives in the schedulerequests Table on to one of these reports? OR for the "Student Request Tally" Report can we have a report that provides the details? We dont need to total tallied but the actual detail. Thanks!

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

Is there a way to include admin recommendations on the course recommendations report?

Not with the current reports included in this reports bundle.

--
Rob Staats
PSCB Development

Great set of reports. Just wanted to give you a heads up that the counts may not pull all data. Our course numbers are hs1234 (lower case school identifier, 4 digit course number identifier). Summary from kb65514 (2012!) follows:
SUMMARY
Course Numbers containing Lower Case alpha characters, are changed to Upper Case alpha values upon Submitting Course Request via Request Management > Modify Future Request, and through the Public Portal > Class Registration.

The difference can be significant:
PE_Health hs0521 Group Games 20-21 187 (from Bundle)
HS0521 Group Games 407 (built-in)

This scenario has been a Powerschool issue for a long time. The net result is that the course number in the courses table is out of sync with the course number assigned to the student requests. (Lower case / Upper case)

PowerSchool has always recommended that lower case letters not be used when creating courses/course numbers. The solution I have implemented with numerous school districts is to change all course numbers to use upper case letters only.

--
Rob Staats
PSCB Development

Yeah, it's annoying. Just before running tallies and diving into the build process, I lock out users from requesting, export all requests, backup, delete them in PS, fix case in Excel and Import with correct case. We implemented back in 2007; revised our course numbering then. Would have gone with uppercase, had we known. It wasn't until we opened on-line requesting that we were impacted.

Subscribe to Comments for "PSCB - Custom Reports (PowerScheduler) 2.2"