PSCB - Custom Reports (Schedule Current Year)

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

View PSCB Plugin Directory

Version 2.4

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

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

pmedema

Wed, 11/28/2018 - 7:46am

Would it be possible to:

1) Add a column for Credit Type? A lot of the schools that I do support for use credit type in transcripts and graduation planner.

2) Put in a filter for Active courses?

3) Put links from the course name to the course page?

Please and thank you in advance.

Peggy Medema

PSCB

Wed, 11/28/2018 - 9:37am

Excellent suggestions. These enhancements will be included in the next release of the PSCB - Custom Reports (Schedule CY) plugin.

--
Rob Staats
PSCB Development

G0414

Fri, 01/25/2019 - 7:13am

Is this information pulled from PowerScheduler? Want to clarify what I am seeing in the course enrollment numbers compared to current course enrollment.
Beth Neidenbach

Beth R Neidenbach
Data Support Staff
Academics
508 Oak St
Gainesville, Ga 30501
770-536-5275 ext 5141
elizabeth.neidenbach@gcssk12.net

PSCB

Fri, 01/25/2019 - 8:40am

All PSCB - Custom Reports (Schedule Current Year) pull data from the current year schedule and course information - not PowerScheduler.

--
Rob Staats
PSCB Development

Vreelands

Fri, 08/09/2019 - 11:24am

Thank you so much for these reports, they are so helpful!! Is there a way to run the reports for a current selection of students?

Sara Vreeland
Tredyffrin-Easttown SD

bjkemp

Fri, 08/09/2019 - 2:18pm

We're on 19.4.2 and are seeing the same thing. I think it has something to do with the ~[f.table_info tag

I changed:

AND s.ID in ((~[f.table_info;table=students;dothisfor=currentsel;fn=value;field=id;delim=cma]-1))

to:

AND s.dcid in ( SELECT dcid FROM ~[temp.table.current.selection:students] )

and it now works for us.

PSCB

Fri, 08/09/2019 - 3:26pm

Further clarification. We are researching the "f.table_info;table" coding issue to determine the root cause. We will be updating all PSCB reports where necessary.

Thanks for bringing this issue to our attention. Very much appreciated.

--
Rob Staats
PSCB Development

PSCB

Sat, 08/10/2019 - 6:13am

Have you installed and enabled the PSCB - Base Resources v2.4 plug-in?

--
Rob Staats
PSCB Development

nmay

Wed, 09/25/2019 - 2:06pm

Has anyone else found when they select “current selection” it returns no results, however one of those same students explicitly selected returns their non scheduled periods?

Nicole May

PSCB

Wed, 09/25/2019 - 3:45pm

Thank you for bringing this issue to our attention. It will be corrected in the next release of the plugin.

--
Rob Staats
PSCB Development

ablazey

Mon, 11/11/2019 - 12:45pm

In the course information report, could we add when the period is offered? That would allow us to use that report as a reference when helping students review what courses they can take when. Thanks!

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

PSCB

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

Periods/Expressions are associated with course sections. The information you want is available in the Sections - Master Schedule List report. Sort by course to see periods offered.

--
Rob Staats
PSCB Development

ablazey

Tue, 11/12/2019 - 10:26am

Sorry, not sure how I missed that. THANK YOU!

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

ablazey

Fri, 11/15/2019 - 8:44am

Can we please add the course description in the Course Information report and it would be great to have it in the Sections - Master Schedule as well; but I understand if the intent for that report is different. It would be helpful to be able to use either report as a dynamic course catalog that we can pull for students to use to help them choose classes. Thank you!

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

allanihall

Mon, 11/18/2019 - 10:46am

I can't load the main reports homepage

/admin/reports_pscb/pscb_home.html. I get this "The page you requested could not be found on this server."
I dont see it when I go to page and data management either. Sub pages are there.

Any suggestions?

PSCB

Mon, 11/18/2019 - 11:43am

You need to download and enable the PSCB - Custom Reports(_Home Page) plugin. This creates the Custom Reports Main menu.

https://powerdatasolutionss.org/content/pscb-custom-reports-home-page

--
Rob Staats
PSCB Development

allanihall

Tue, 11/19/2019 - 10:17am

Rob

That fixed it.

Perfect. Thanks.

ablazey

Tue, 11/19/2019 - 11:13am

Hi,
I was running this report to review one of our PE courses. When I tried to search by the name of the course, the filtering did not work. Then when I selected by department, then course, it still pulled other courses that were not the one I selected. I think the coding may be off or preventing both from working in tandem. Thank you !

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

PSCB

Tue, 11/19/2019 - 11:17am

Thank you for bringing this issue to our attention. It will be addresses in the next release of the plugin.

--
Rob Staats
PSCB Development

ablazey

Wed, 11/20/2019 - 12:19pm

I think this got passed over. Can we please add the course description in the Course Information report and it would be great to have it in the Sections - Master Schedule as well; but I understand if the intent for that report is different. It would be helpful to be able to use either report as a dynamic course catalog that we can pull for students to use to help them choose classes. Thank you!

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

PSCB

Wed, 11/20/2019 - 12:38pm

PSCB plans to develop a separate report for listing course descriptions.

--
Rob Staats
PSCB Development

ablazey

Wed, 12/04/2019 - 7:34am

Hi, I just had two data requests related to what students we enrolled in a specific period. It would be helpful to add the ability to select a specific period as a report filter. We have 1300 students and 11 periods, so it takes a long time to pull the data. Thanks

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

PSCB

Wed, 12/04/2019 - 2:05pm

This request will be added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

ablazey

Tue, 12/17/2019 - 9:34am

Hi,
When you "export CSV File" you cannot add the total enrollment. I think it may be adding a space to the front of the number and keeps it from being summed in excel. Is there a quick way to remove this from excel or anything you can do to the report to fix this? Thanks!

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

PSCB

Tue, 12/17/2019 - 9:54am

I tested the report in 5 different school districts. The Export CSV File opened in Excel without issue. Not sure what is happening with your export.

--
Rob Staats
PSCB Development

ablazey

Tue, 12/17/2019 - 11:53am

It exports fine into excel but when you try and add a function, for example a sum function to the enrollment total of the sections; it does not work. I think there is a hidden space in the number or because it is a link when its viewed through PowerSchool. Hopefully that helps!

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

PSCB

Wed, 12/18/2019 - 1:11pm

The information is exported "as is". Any reformatting of the data in Excel is the responsibility of the user.

--
Rob Staats
PSCB Development

nmay

Mon, 01/13/2020 - 11:34am

We miss the ability in this report to have it applicable to only the current terms. For example we are in 2019-2020 school year at which time all 19-20 year long courses as well as semester 1 courses are active and the report only provides results on Teacher Free periods for 19-20 and semester 2 course schedules. Could you add a dropdown at the top that values from years and terms (almost more of a checklist)?

Nicole May

PSCB

Mon, 01/13/2020 - 11:48am

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

--
Rob Staats
PSCB Development

cavinessyc

Mon, 01/27/2020 - 9:50am

It would be great if the Teacher Free report excluded Co-Teachers.

Yadi Caviness
Bartlett City Schools

PSCB

Tue, 01/28/2020 - 1:42pm

Sorry, PSCB has no plans to to modify the report at this time. Schools can create numerous teacher roles in addition to lead teacher and co-teacher. It would cause problems if PSCB excludes a specific role that other districts may want to see.

--
Rob Staats
PSCB Development

spoarch@caldwel...

Tue, 07/21/2020 - 12:33pm

Could Track count be added to Sections-Master Schedule?

S. Poarch

PSCB

Tue, 07/21/2020 - 1:25pm

Track has already been added to the report. It will be included in the next release of the PSCB - Custom Reports (Schedule Current Year) bundle. The publish date is scheduled for 8/1 2020.

--
Rob Staats
PSCB Development

spoarch@caldwel...

Tue, 07/21/2020 - 1:42pm

Great@ Thank you!!

S. Poarch

JCORCORAN

Tue, 08/04/2020 - 7:11am

Where do I find this release?

Thank you!
Jeanne Corcoran

PSCB

Tue, 08/04/2020 - 9:44am

The release date for the PSCB - Custom Reports (Schedule CY) v1.3 plugin has been reset to 8/10/20.

--
Rob Staats
PSCB Development

PSCB

Mon, 08/17/2020 - 3:58pm

The PSCB - Custom Reports (Schedule Current Year) v1.3 plugin has been released,

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

--
Rob Staats
PSCB Development

dorothy.tribble

Thu, 08/13/2020 - 10:20am

Has the Adding Track Count been updated? If so, where can I find this release?

jroberts

Tue, 08/18/2020 - 11:09am

With v1.3, the link to Sections Report on the Start Page still goes to SectionsReport.html, but the report has been renamed SectionsDetailReport.html

PSCB

Tue, 08/18/2020 - 11:30am

Thanks for bringing this issue to our attention. This issue will be addressed in the v1.4 update which will include some additional enhancements. Publish date is scheduled for 8/21.

--
Rob Staats
PSCB Development

ablazey

Mon, 08/24/2020 - 11:43am

Hi,
There are still some issues with this report running correctly. We have classes that are run year or semester long. When I run the report, every student is getting an error for every period, because if they have a full year course, it is saying they are missing courses for the 2 semesters. It is causing reports to take really long to pull and inaccurately pulling most students in. Are we able to get this updated? Maybe it can just look if a period is blank instead of within a reporting term? Thanks!

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

PSCB

Mon, 08/24/2020 - 12:01pm

Please confirm that you have version 1.5 installed.

--
Rob Staats
PSCB Development

ablazey

Mon, 08/24/2020 - 12:34pm

Hi Rob, yes 1.5. Thanks!

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

sreichel

Wed, 08/26/2020 - 7:38am

Hi, I'm also having trouble with the Students Non Scheduled Periods report. I have 1.5 installed and the report just continues loading and never returns any results.

jalbert

Tue, 09/01/2020 - 2:26pm

I'm having a similar issue. No matter what block I choose, the entire student body shows up in the results.

Joseph Albert

PSCB

Tue, 09/01/2020 - 3:11pm

We have discovered the issue with the report. An update will be posted next week.

--
Rob Staats
PSCB Development

jalbert

Wed, 09/02/2020 - 1:44pm

Thank you!!

Joseph Albert

ViViper1

Mon, 08/31/2020 - 12:31pm

Is it possible to add Sched_HouseCode to the table for the Master Schedule List under Master Schedule List (Current Year).

PSCB

Mon, 08/31/2020 - 3:04pm

Team and House will be include in the next release of the plugin scheduled for 9/14/20.

--
Rob Staats
PSCB Development

janagamn@nths.net

Tue, 09/01/2020 - 8:00pm

Student Non-Scheduled Periods - I have the most recent version installed. However, it just gives me all students all the time irrespective of what parameters I select.

Thanks,
Niha Janagama
New Trier Township High School District 203

Pages

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