PSCB - Custom Reports (Schedule Current Year)

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

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 - Enrollments by Grade Level
    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 - Not Enrolled in a Course
    Students - Non Scheduled Periods
    Teacher - Class Counts
    Teacher - Count Per Section
    Teacher - Free
    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

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
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: 
Y
Plugin: 
Y
CPM Import Friendly: 
Y
Report Type: 
Web Based Report

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

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