PSCB - PowerScheduler Reports

Description

This is a bundle of reports that help provide information related to scheduling for both build and/or load scenarios. There are a couple core reports that are included but were enhanced by adding sorting capabilities. Some reports are customized versions from PowerDataSolutions reports. And finally some reports are of original design. This also includes the report from Brian Andle's plugin for ease of reference.

There are some page fragments and reports included that contain Legacy Custom Fields, those page fragments and reports are listed below for ease of reference.

This bundle includes 22 PowerScheduler reports organized into 2 categories.

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

Acknowledgements

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

PowerData Solutions 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

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

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.
Click on the Plugin name and chose the Update button.
Browse to select the new file and click Submit.
Enable the plugin.

Instructions

Go to a school that uses PowerScheduler.
Click on PowerScheduler.
Click theCustom Reports (PSCB)link located on the PowerScheduler menu.

Other Information

Report: Student List
Filename:
Legacy Field(s) Include: sched_allowrequests, sched_loadlock, counselor

Page Fragment: PowerScheduler > Students > Scheduling Preferences
Filename: admin\powerschedule\students\prefs.CustomContent.content.footer.txt
Legacy Field(s) Include: sched_loadlock, sched_allowrequests

Page Fragment: Student Screen > Schedule Setup
Filename: admin\students\schedulesetup.CustomContent.content.footer.txt
Legacy Field(s) Include: sched_loadlock, sched_allowrequests

About the Schedule Load Option:
Schedule Load Lock is a custom field that can be used to track students to include/exclude from the in PowerScheduler load process.

The box should be checked for students that are to be excluded from the PowerScheduler load process.

Just prior to running a PowerScheduler Load. Perform the following student search: Sched_LoadLock = False. This will select all students to be included in the next Load.

Before executing the load, check the "Reschedule the selected x students" option.

PS Verions

11.x: 
Y
12.x: 
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

Subscribe to Comments for "PSCB - PowerScheduler Reports"