PSCB - Custom Reports (Schedule Current Year)

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

View PSCB Plugin Directory

Version 2.5

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 AP Courses
    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
    Students - Schedule Credits Summary
    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

2.1 (2021-04-07)
- Added a Search Date option to the following reports
Students - Non Scheduled Periods
Teachers - Non Scheduled Periods
- Added alternate row shading by selected report column to the following reports
Students - Class Roster
Teacher – Sections List
- Added Room Number to the Sections – Enrollment Summary report.

2.2 (2021-04-25)
- Added Room Max Enrollment to the Sections – Enrollment Summary report.

2.3 (2021-07-31)
- Fixed an issue with the Students - Non Scheduled Periods. The report now lists results for only the selected school

2.4 (2021-10-19)
- Added 2 new reports.
Students - Enrolled in AP Courses
Students - Schedule Credits Summary
- Enhanced the functionally of the Students - Class Roster report
- New design and coding for the Students - Non Scheduled Periods report
- All section reports now display the external expression
- Added edit links to numerous reports.
- Added filter options and new fields to numerous reports

2.5 (2021-12-17)
- Added additional fields to the Students - Multiple Enrollments report
- Added a Multi-Select course option to the Students - Not Enrolled in Course(s) report.

Powerschool Compatible Versions

21.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.3
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:

Report Type: 
Web Based Report
Compatible PS Versions: 
20.x, 21.x
Plugin: 
Y
CPM Import Friendly: 
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

DDolan

Fri, 04/02/2021 - 8:06am

This report has been extremely helpful especially because it has the track information. Would it be possible to add the section's room number to this report?
Thanks for all these good reports.
Dianne Dolan
Stoughton Public Schools
Stoughton, MA

Dianne Dolan

PSCB

Wed, 04/07/2021 - 6:47pm

Room number has been added to this report in the 2.1 release of the PSCB - Reports (Scheduling Current Year) plugin

--
Rob Staats
PSCB Development

cmcquitty

Mon, 07/19/2021 - 3:20pm

Newbie here and I love these reports. I was reviewing the CY Schedule and how perfect the data is. I also need that exact data or rather which tables to use to build a query off of so that I can export and send via SFTP. Fields needed are: Sections_Numbers, Teacher_Numbers, Students_Numbers, Term_Name, Term_FirstDay, Term_LastDay, and Period_Name for each student for the current year only. I would like a year choice to filter when exporting but do not need the year to actually export in the file. If this is not the place to ask this sort of thing, would you happen to have suggestions? TY, Cathy

PSCB

Wed, 07/21/2021 - 9:42am

Sorry, PSCB Development does not provide personalized customization services. I would suggest you post your request on PowerSource or https://groups.io/login.

--
Rob Staats
PSCB Development

chrismitchell03

Wed, 07/28/2021 - 7:31am

I love the reports in this bundle but just wanted to bring to someone's attention that the Students - Non Scheduled Periods Report lists students from across the district no matter which school we are logged into or who runs the report. I like that feature if I'm logged into District Office, but could this be fixed in a future release so it only shows students enrolled at the currently selected school for our school level users?

PSCB

Wed, 07/28/2021 - 6:24pm

This report issue has been corrected and be included in the next release of the plugin.

--
Rob Staats
PSCB Development

HHughes3

Thu, 08/05/2021 - 1:57pm

For this report, I am only getting returning students that are free. New students do not appear in the report right now. I am picking a future date to search when I know school is in session.

jalbert

Mon, 08/09/2021 - 10:48am

Hi there!

Is the Non-Scheduled Periods report supposed to have a "Make Current Student Selection" option? If so, mine is not showing up. If not, can I make a request that it be added? Thank you!

Joseph Albert

PSCB

Tue, 08/10/2021 - 10:06am

The Make Current Student Selection button will be included in the next release of this plugin.

--
Rob Staats
PSCB Development

lkent

Fri, 08/20/2021 - 1:54pm

Hello,

Is there a way to get the External Period Expression to appear on this report?

Thank You

Linda

LKent

PSCB

Sat, 08/21/2021 - 8:32am

The next release of the PSCB - Custom Reports (Schedule Current Year) plugin is scheduled for 8/30/21. All reports will display the External Period Expression.

--
Rob Staats
PSCB Development

jalbert

Tue, 08/24/2021 - 10:32am

Hi there,

I ran the "enrolled in a course" report to see which students I had in my own math class, but when I ran the report for S1, only 4 students came up. However, when I ran it for S2, all of my students came up. Any ideas why? I checked the enrollments screen for the students who did not show up in S1 and they all looked good and are enrolled.

Thanks in advance for your help!

Joseph Albert

PSCB

Tue, 08/24/2021 - 12:11pm

Check the student course enrollment dates for S1. They need to be in sync with S1 term dates.

--
Rob Staats
PSCB Development

jalbert

Thu, 08/26/2021 - 10:52am

That was the issue... thank you!

Joseph Albert

reynoldsn

Fri, 09/17/2021 - 4:58pm

How can I add or edit one of these reports to tally the number of AP classes a student is scheduled into? We have a huge need for this?

PSCB

Wed, 09/22/2021 - 10:22am

A PSCB AP Class Count report is under development and will be published next week.

--
Rob Staats
PSCB Development

cmcquitty

Wed, 10/20/2021 - 10:22am

CY is missing from this download. It is now gone. Here is what I'm getting now:

Attendance Custom school/district level attendance reports.
Grading Custom school level grading reports for PowerTeacher Pro gradebook and Stored Grades.
Scheduling (Future Year) Custom school scheduling reports (PowerScheduler - Future Year).
Transportation Custom school/district transportation reports.
Validation Custom school/district data validation reports for setup parameters.

Daily Attendance Codes Enter Daily Attendance Code preferences for PSCB Custom Reports.
Meeting Attendance Codes Enter Meeting Attendance Code preferences for PSCB Custom Reports.
Grade Reporting Terms Enter Grade Reporting Term preferences for PSCB Custom Reports.

PSCB

Wed, 10/20/2021 - 2:29pm

Delete and re-install version 2.4 of the plugin.

--
Rob Staats
PSCB Development

kirschd

Wed, 01/12/2022 - 8:43am

I just updated the PSCB - Custom Reports (Schedule Current Year) and the students with non scheduled periods report is showing that students are not scheduled when in fact they are. Any period that a student is scheduled in quarter or semester long classes, shows them not scheduled for the term 21-22. Is there a way to revert back to the older version until this is resolved?

PSCB

Wed, 01/12/2022 - 3:13pm

Version 2.5 was republished with a fix for the Student - Non Scheduled Periods report. Download and re-install.

--
Rob Staats
PSCB Development

kirschd

Thu, 01/13/2022 - 7:10am

I just downloaded and reinstalled version 2.5 and I am still having the same issue. Students who are enrolled in quarter or semester courses for a specific period are coming up as not scheduled for those periods for the term 21-22.

Pages

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