PSCB - Custom Reports (Schedule Current Year)

View PSCB Plugin Directory

Version 1.9

Description

This bundle includes 22 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
    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.

Powerschool Compatible Versions

19.x, 20.4.x

Additional Plugin Requirement

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

PSCB - Base Resources
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.

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

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

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

--
Rob Staats
PSCB Development

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

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

--
Rob Staats
PSCB Development

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

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.

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

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

--
Rob Staats
PSCB Development

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

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

--
Rob Staats
PSCB Development

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

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

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

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

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

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?

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

Rob

That fixed it.

Perfect. Thanks.

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

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

--
Rob Staats
PSCB Development

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 plans to develop a separate report for listing course descriptions.

--
Rob Staats
PSCB Development

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

This request will be added to the PSCB enhancement list.

--
Rob Staats
PSCB Development

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

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

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

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

--
Rob Staats
PSCB Development

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

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

--
Rob Staats
PSCB Development

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

Yadi Caviness
Bartlett City Schools

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

Could Track count be added to Sections-Master Schedule?

S. Poarch

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

Great@ Thank you!!

S. Poarch

Where do I find this release?

Thank you!
Jeanne Corcoran

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

--
Rob Staats
PSCB Development

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

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

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

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

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

Please confirm that you have version 1.5 installed.

--
Rob Staats
PSCB Development

Hi Rob, yes 1.5. Thanks!

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

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.

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

Joseph Albert

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

--
Rob Staats
PSCB Development

Thank you!!

Joseph Albert

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

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

--
Rob Staats
PSCB Development

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