PSCB - Custom Reports (Schedule Current Year)

Submitted by PSCB on Thu, 05/24/2018 - 3:04pm

View PSCB Plugin Directory

Version 2.0

Description

This bundle includes 23 Scheduling reports for the Current Year.

    Course - Enrollment Counts
    Course - Information
    Room - Availability
    Room - Conflicts
    Sections - Dependent Sections List
    Sections - Details Report
    Sections - Enrollment Summary
    Sections - Master Schedule List
    Sections - No Room Assigned
    Students - Class Roster
    Students - Current Class
    Students - Dropped Classes
    Students - Enrolled in a Course
    Students - Enrolled with a Teacher
    Students - Multiple Enrollments
    Students - Non Scheduled Periods
    Students - Not Enrolled in a Course
    Students - Schedule Conflicts
    Teacher - Class Counts
    Teacher - Count Per Section
    Teacher - Non Scheduled Periods
    Teacher - Sections Count
    Teacher - Sections List

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

Version Info

1.2 (2018-05-24)
- Initial Release

1.3 (2020-08-17)
- Updated all reports to include additional options and features.
Report to note in this bundle: Sections - Enrollment Summary
Lists active section enrollments by grade level, gender, track and total students for a selected term.

1.4 (2020-08-21)
- Fixed the Sections Report link on the Start Page - Left Navigation menu.
- The Course - Enrollment Counts report now includes summary totals for grade levels and tracks.
- The Sections - Enrollment Summary report now references the Years and Terms setup associated with the current year.
- The Teacher - Class Counts report now includes column filters and sorting.

1.5 (2020-08-22)
- Updated sql query for the Teacher - Non Scheduled Periods report.

1.6 (2020-09-11)
- Updated sql query for the Student - Non Scheduled Periods report.

1.7 (2020-10-5)
- Student track has been added to the Sections - Enrollment Summary and Students - Class Roster reports.

1.8 (2020-10-12)
- The Students - Class Roster report now includes students cross enrolled at another school in the district.

1.9 (2020-11-16)
- Corrected rendering issue with the Sections - Enrollment Summary report.

1.10 (2021-01-20)
- The Students - Class Roster report only lists students enrolled in classes offered at the selected school.

2.0 (2021-02-21)
- Added new report: Students - Schedule Conflicts

Powerschool Compatible Versions

19.x, 20.x

Additional Plugin Requirement

The following PSCB plugins should be installed prior to the installation of this reports bundle.

PSCB - Base Resources 3.1
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 Scheduling (CY) link to access the Scheduling (Current Year) Reports menu.

Customization:

Tags:

PS Verions

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

Comments

alvarez-re

Mon, 09/21/2020 - 1:42pm

Love the update that included the Tracks. Is there a way to make the number count of each track a Hyperlink to quick see who those students are? Specifically the Null students would be awesome!

PSCB

Mon, 09/28/2020 - 11:16am

A hyperlink will be added in the next release of the report.

--
Rob Staats
PSCB Development

alvarez-re

Mon, 10/12/2020 - 10:51am

Thank you so much for the hyperlink!

ablazey

Thu, 10/01/2020 - 6:39pm

Hi,
We use these reports all the time at our high school, now I am trying to pull it in our other schools and Im getting blanks for this report. When I pull the "Students - Enrolled in a Course" it runs, any ideas on troubleshooting this? Thanks!

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

dbbcr54

Fri, 10/09/2020 - 10:20am

Hi All, one of my high schools has found that this report is selecting transferred out students from last year. Can this be fixed? Great report as always, and all the others. The report I am running is the Students - Non Scheduled Periods

Doug Robertson

PSCB

Fri, 10/09/2020 - 10:40am

You need to update to PSCB - Custom Reports (Schedule CY) V 1.7.

The issue you described was addressed in the 1.7 version.

--
Rob Staats
PSCB Development

dbbcr54

Fri, 10/09/2020 - 12:27pm

Thanks Rob, I will do that

Doug Robertson

pmedema

Mon, 10/26/2020 - 11:59am

I have this installed on a number of districts and this report isn't pulling any data.

Peggy Medema

PSCB

Sun, 11/01/2020 - 11:59am

If you would like to investigate this issue via a Zoom session please send me a contact email to: pscb.development@gmail.com.

--
Rob Staats
PSCB Development

nvanvolkenburg

Mon, 11/09/2020 - 6:41pm

My AP uses this report on a regular basis and now it is not returning any data. We created a new year for Power Scheduler and I am wondering if our new year of 20-21 is considered the current scheduling year?

Thank you

Nancy L Van Volkenburg

PSCB

Wed, 11/11/2020 - 3:05pm

Nancy,

If you would like to investigate this issue further, please a contact email to: pscb.development@gmail.com

--
Rob Staats
PSCB Development

miletiche

Wed, 11/11/2020 - 3:27pm

I am the most current version but the Enrollment Summary report is coming up blank.
Any ideas on what is causing the issue.

Thanks
-Eric

PSCB

Wed, 11/11/2020 - 6:47pm

Eric,

Confirm that you have created the 2020-2021 school year at all schools including the District level.

--
Rob Staats
PSCB Development

miletiche

Thu, 11/12/2020 - 2:47pm

Hey Rob, I just double checked and we have the 20-21 term created at all schools, including the DO.

Thanks
-Eric

ashleyclowers

Fri, 01/15/2021 - 8:15am

The Class Roster report pulls all students in the district, not just the school you are in. Should this be the case?

PSCB

Sun, 01/17/2021 - 11:07am

Thanks for brining this issue to our attention. It will be corrected in the next release of the plugin, scheduled for next week.

--
Rob Staats
PSCB Development

LynneMc

Wed, 01/27/2021 - 6:22am

We have both Custom Reports Bundle and PSCB Reports installed. So much of this is duplicate and PSCB is better - in most cases. However, we have found that the CRB - Teacher Free Report is better than the PSCB "Teacher-Non scheduled Periods". Teacher Free runs by date and only pulls teachers with no class scheduled during a certain period on that date. The "Teacher-Non Scheduled" does not have a date....and when we have a teacher with a year long class during period 1- it shows she has no class for S1 or S2. If the date was included as on the "Teacher Free" report, the report would see she has classes scheduled on this date during period 1.
Can you please fix this.
Thanks,

Lynne

PSCB

Wed, 01/27/2021 - 2:13pm

The issue you described - "teacher with a year long class during period 1- it shows she has no class for S1 or S2" was corrected in version 1.10 of the plugin. You should install this update.

The report was purposely designed to a year report with filters provided for teacher, department, period and day. You can also use the column filter to select a term(s).

--
Rob Staats
PSCB Development

ablazey

Thu, 02/04/2021 - 8:05am

Hi,
I thought there used to be a report that you could run to double check a student wasn't enrolled in more than 1 course per period. Has that been removed? Or am I looking in the wrong place? Thanks!

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

PSCB

Thu, 02/04/2021 - 10:53am

PSCB does not currently have such a report. Will add this request to the PSCB - Custom Reports (Scheduling CY) - Multiple Enrollments report.

--
Rob Staats
PSCB Development

ablazey

Fri, 02/05/2021 - 7:53am

Great, thank you!

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

ablazey

Mon, 02/22/2021 - 7:15am

Morning,
I just ran this report and I am noticing it is pulling in period conflicts by just period enrollment but not the enrollment date. We have students that that unenrolled from their 3rd period class the end of the semester 1/30/21. And enrolled in a new class starting 2/1/21 and it is saying there is a conflict. Can it also review enroll dates? Thanks!

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

PSCB

Tue, 02/23/2021 - 2:12pm

This would indicate that the student was not properly dropped from the class or the dropped date was manually changed.

If the semester ended on 1/30/21, the student drop date should be 1/31/21 for the class. Check your enter and exit dates and confirm that are accurate and in sync.

--
Rob Staats
PSCB Development

PSCB

Tue, 02/23/2021 - 11:10am

Thanks for bringing this issue to our attention. We will investigate the cause.

--
Rob Staats
PSCB Development

ablazey

Thu, 02/25/2021 - 6:31am

Morning,
Yes they were properly dropped. Thank you for investigating!

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

CarolinaSC77

Wed, 02/24/2021 - 7:38am

In the old CRM bundle you had a report Student Course Request Report...I don't see that report in the PSCB Custom Reports. I would love it if we could get that back

But--The old CRM report works great for what we are trying to accomplish and I have gone into CPM to make a couple of tweaks to the report so it fits in template that our counselors use. We need a little less white space on your report and I have about a 1 inch space in this area of the report:--how can I get rid of this white space....
select '~[if.~[prefschool:crrept_showalt]=1]Regular [/if]Credit Hours Requested'||chr(58)||' '||sum(c.credit_hours)||'' reqout
from schedulerequests sr
inner join courses c on upper(sr.coursenumber) = upper(c.course_number)
inner join students s on sr.studentid = s.id and s.id=~(id)
where sr.yearid=~(schedule.yearidfuture) and sr.globalalternatecourse = 0]
~(reqout;t)[/tlist_sql]

~[if#1.~[prefschool:crrept_showalt]=1]

Requests: Alternate
Course Number Course Name Credit Hours

Thanks in advance for any suggestions

PSCB

Mon, 03/01/2021 - 6:49pm

If you want to review this issue via a Zoom conference session, please send your contact information to pscb.development@gmail,com.

--
Rob Staats
PSCB Development

Pages

Subscribe to Comments for "PSCB - Custom Reports (Schedule Current Year)"