PowerSchool Customizations... SIS-yphean

Originally released in 2003! This is the original auto-refreshing report queue (...use to be a big deal).
I keep it going because I like an automatic 10 second count down. As apposed to the built in button that you can set to refresh every 30 seconds (and forgets that you set it that way).
Other features:

  • Includes new versions of the PowerTeacher and ReportWorks report queues.
  • Each report row will display a refresh icon which when clicked will re-submit the job.  This is just an easier way to re-run a report without having to click the report name, check the re-run check box, and click submit. Saves a bunch of clicks when testing new object reports.
  • Adds the target="_blank" attribute to every completed link so the reports open in a new tab. Might as well seeing everyone's browser is previewing PDFs these days.
  • Adds a column to the admin report queue showing which school the report was run under.


Version History:

2.7 - Added a column for school abbreviation to the old school admin report queue.
2.6 - Made it so all complete report links open in a new tab. Thanks Eric for the idea and code!
2.5 - Added the admin/teacher ReportWorks queue pages. They will auto-refresh like the original report queue
2.4 - Fixed a situation that would cause an report to endlessly load
2.3 - Fixed a cross-site scripting error introduced in PS version 11.0.4.
2.2 - Updated this venerable little guy to be a plugin. And took out the independent refresh icon and started using a built in image.
2.0 - Updated for PowerSchool version 7. Formatted for upload to CPM.
1.0 - Initial release.

Screen shot:

AttachmentSize
Package icon AwesomeReportQ_2_7.zip8.53 KB

FYI: This is NOT a plugin... yet. I'll be working on an updated version soon that is a user-friendly plugin.
The class roster feature in powerschool is a great way to get class information out of the system in a nice printable format.  However... try explaining to your office staff that after they took the time figuring out all the parameters, field names, and column widths, to create the roster, they cannot save it for future use!
This custom class roster page allows a powerschool admin to pre load all the parameters into a javascript allowing the office staff to simply pick which roster they would like to run through a drop down box.  After selecting a roster to load, they could then go and alter the parameters, or just click submit as is.
The page also includes another handy little javascript which will calculate the width of the fields you have specified, and display the total underneath the field input box.  The first sum being just the column widths specified, and the second sum takes into account the page margins or padding that has been applied.  This was included to get around the annoying task of running a report to see if your column widths where okay.
Now updated to blend with PowerSchool version 7. For those updating from the old version, you only need to replace the classrosters.html page. Your previous roster setups will work just the way they where.

Note: I realize that this customization is very tricky.  If you are not familiar at all with javascript writing the code for pre-defined rosters can be daunting.  Often I find people want to use this customization to facilitate running grade verification rosters.  So I have put together two class roster packages which already has the code setup for for these grade verification reports.

Screenshots:


Version History:

2.1 - Fixed an issue with page orientation, and width not updating when selecting rosters. Thanks Leslie! Made the zip download CPM friendly.
2.0 - Updated for PowerSchool version 7.
1.0 - Initial release.

If you are in Illinois and participate in IAR testing... You most likely also participate in ACCESS 2.0 testing.
So why not track accommodations for both tests on a single student screen.
This plugin includes all the bells and whistles of IARrific PLUS has a section at the bottom of the student screen to track ACCESS 2.0 accommodations.
The ACCESS section is only made available if a student is marked both LEP (S_IL_STU_X.LEP) and either IEP (S_IL_STU_X.IEP) or 504 (S_IL_STU_Plan504_X.Participant).
IAR accommodations are state fields uploaded to SIS. ACCESS accommodations however are not state fields. So the plugin will create the fields as database extensions under the table U_ACCESS_ACCOM.
If you have the SQLreports plugin installed (www.sqlreports.net) I also have a SQLreport below you can import and use to generate the .csv file needed to mass update accommodations in WIDA/AMS (www.drcedirect.com).

*** If you are using the companion SQLreport, make sure to update that as well to the latest version ***

Installation:

  1. Go to System - System Settings - Plugin Management Configuration.
  2. If you are updating from a previous version, first delete the current plugin version. Then Install the new zip file.
  3. Enable the Plugin (THIS WILL CREATE DATABASE EXTENSIONS ON YOUR PS SERVER).
  4. Set page permissions on the new IAR/DLM/ACCESS student screen so only those groups editing/viewing IAR/ACCESS test info can access it (optional but encouraged).
  5. If you wish to hide the "Proctor/School Provided Administration Considerations" sections of the student page you can do so in District > Miscellaneous. They are displayed by default.

Version History:

1.7 - ACCESS accommodations updated to reflect 21-22 changes. ALSO DELETE/RE-IMPORT the v3 SQLreport for the new upload template.
1.6 - Updated the ACCESS accommodations so Mode of Administration cannot be filled out if the student is in kindergarten. The import wants them all to be blank. Also if the student is marked Alternative ACCESS then the Mode of Administration, BR, and LR accommodations will upload blank. The companion SQLreport has been updated to reflect these changes.
1.5 - IAR Human Signer for Test Directions accommodations added to bring in line with 20.12.1 state reporting update.
1.4 - Added new accommodations/admin considerations to align with PS state reporting update 20.11.2. Swapped out the DLM-AA indicator for the Alternative Assessment Indicator used on the IL Demographics Enrollment because that is what creates the DLM Pre-ID in SIS. Added an option in District > Miscellaneous to hide the Administration Considerations as districts may not care to track/upload those to PAN. Other minor bug fixes.
1.3 - Minor option changes to coincide with the state reporting 19.12.1 release. Minor changes to field validation to match the Spring 2020 PNP document. Now the Dual Language state field is taken into account for validation on Math Transadaptation into Spanish and Math Text-to-Speech accommodations.
1.2 - The accommodation "Spanish Transadaptation of the Mathematics Assessment" no longer requires the student to be marked LEP.
1.1 - Corrected a form validation that would prevent you submitting ACCESS accommodations if mode of administration was paper, Alt ACCESS was checked, and no tier level was set. Found out that Alt ACCESS has no tiers.
1.0 - Initial Release

Screenshot:

IARrific is a souped-up version of the IAR Pre-ID state tab. It does not replace the state screen, but instead creates a new student page called "IAR/DLM" linked off the student navigation (more2.html) on the admin side.
The accommodations for ELA and Math are hidden until the ela_accommodations or math_accommodations checkboxes are checked. This way it is super-easy to search for students who have any accommodations marked.
This page will also check if you have accommodations already entered in the built in state page and blink a warning next to the "parent" ela_accommodations or math_accommodations checkboxes that they have automatically been checked and the page needs to be submitted. Best solution I could come up with.
This page uses the IL state fields, so no trouble running the "IL IAR Report" or "IL DLM-AA Pre-ID Report". However, their are 3 new custom fields that are created when the plugin is installed (using the database extension group U_PARCC).

A huge amount of form validation has been added to only allow marking accommodations if all of PAN's requirements are met. These requirements are mapped out in the Spring 2020 Student Registration/Personal Needs Profile Field Definitions.

*** You must have the 20.12.1 or later state reporting update installed before updating to version 1.4 of this plugin ***

Installation:

  1. Go to System - System Settings - Plugin Management Configuration.
  2. If you are updating from a previous version, first delete the current plugin version. Then Install the new zip file.
  3. Enable the Plugin (THIS WILL CREATE DATABASE EXTENSIONS ON YOUR PS SERVER).
  4. Set page permissions on the new IAR/DLM student screen so only those groups editing/viewing test info can access it (optional but encouraged).
  5. If you wish to hide the "Proctor/School Provided Administration Considerations" sections of the student page you can do so in District > Miscellaneous. They are displayed by default.

Version History:

1.4 - IAR Human Signer for Test Directions accommodations added to bring in line with 20.12.1 state reporting update.
1.3 - Added new accommodations/admin considerations to align with PS state reporting update 20.11.2. Swapped out the DLM-AA indicator for the Alternative Assessment Indicator used on the IL Demographics Enrollment because that is what creates the DLM Pre-ID in SIS. Added an option in District > Miscellaneous to hide the Administration Considerations as districts may not care to track/upload those to PAN. Other minor bug fixes.
1.2 - Minor option changes to coincide with the state reporting 19.12.1 release. Minor changes to field validation to match the Spring 2020 PNP document. Now the Dual Language state field is taken into account for validation on Math Transadaptation into Spanish and Math Text-to-Speech accommodations.
1.1 - The accommodation "Spanish Transadaptation of the Mathematics Assessment" no longer requires the student to be marked LEP.
1.0 (IARrific) - Changed plugin name to IARrific. Cosmetic changes from PARCC to IAR. Removed the ESOL Participation Code field for DLM-AA.
*** If you previously installed the PARCCtatic plugin YOU MUST DELETE THAT PLUGIN BEFORE INSTALLING IARrific ***

Screenshot:

iarrific_12_3_20.jpg

AttachmentSize
Package icon IARrific_1_4.zip13.09 KB

One of my favorite t-sirts exclaims "Go away or I will replace you with a very small shell script". This is how I feel about the family_rep field in PowerSchool. Does anyone really keep it up to date properly? And if you don't, aren't families at risk of missing that important mailing?
This plugin eliminates the need to manually maintain family reps.

How Does it work?
When in the DISTRICT OFFICE a link "Select District Family Reps" appears after Stored Selections on the admin homepage. This links to a familyreps.html page that picks the youngest student at each household for the entire district BASED ON HOME PHONE NUMBER. The family reps become the current selection and you are redirected back to the start page.
When your in a SCHOOL the link changes to "Select [school abbreviation] Family Reps" and finds the family reps at each household just within the school.
There is also an added option to select family reps from within your current selection of students in the group functions popup.
The SQL query does take into account students who are checkmarked as a family_rep on the Modify Info screen. Those checked always get included in the student selection. This is to account for those rare instances where two or more students have the same home phone but still need individual copies of all school mailings.
Twins and triplets are taken into account when selecting family reps. Students with blank home phone numbers are also included automatically.

THIS CUSTOMIZATION IS NOT FOR EVERYONE. BEFORE DEPLOYING PLEASE NOTE:
- Your school may have different way of determining student family representatives. This will only be a replacement for schools that group households by home phone.
- The home_phone field will have to be uniformly formatted for every student or this will not work. We use data validation to prevent the home_phone from being submitted if it is malformed.
- If you plan on using this customization in production you should clear the family_rep field for every student EXCEPT for students who are not the youngest of the household but still need a copy of mailers (as noted earlier).

Version History:

5.0 - Updated for the "New Experience" on PS v20 (yes I finally switched). Also change the redirect so you are taken back to the start page rather than the group functions page. I think it is less confusing for end users.
4.3 - Removed a problematic [if] tag on the admin home page fragment.
4.2 - Refined the SQL query because once again sometimes oldest sibling was selected rather than youngest! Gees Nick get it together!
4.1 - Added the option to select family reps from within your current student selection. Fixed a problem where the oldest student was selected family rep instead of the youngest. Converted to a plugin for installation. SQL query now pulls family_rep field from "studentcorefields" table.
4.0 - Converted home page link to page fragment and therefore PS version 8 ready.
3.3 - Minor update to accommodate changes in PS version 7.8.2.
3.2 - Fixed a screw up that broke the district family rep function.
3.1 - Minor update to accommodate changed in PS version 7.8.
3.0 - Moved the sql onto it's own page to avoid the admin home page having to run the script on load. Altered the selection proccess to take twins/triplets into account. Family reps now include any student with a blank home_phone field.
2.2 - Updated for PowerSchool version 7.2.x.
2.1 - Updated for PowerSchool version 7.1 admin homepage changes.  Corrected a CSS glitch. Corrected a SQL glitch that would not select the correct school. Corrected the zip file structure to work properly when imported via CPM.
1.0 - Initial release

AttachmentSize
Package icon instant_family_rep_v5_0.zip4.98 KB

After a great many years, List Students Auto-Loader is now a user-friendly plugin!
As the name implies, it allows users in the PowerSchool admin portal to save what I call "List Sets" for the List Students group function (Screenshot).
These list sets show in dropdown menu in the upper-right of the List Student screen and when selected automatically input all the saved fields, titles, and settings.
All users can save "personal" list sets. You may give particular security groups permission to create list sets for their school, or multiple schools/the entire district.
List Students Auto-Loader is also fully compatible with another great plugin by the PSCB folks which expands the number of list columns, and enhances the resulting list options.

Setup:

After installing the plugin, go to System - Groups. The Groups page now has a setting "Create and Edit School/District List Sets". On a per group basis you can choose:
  • Whole District (full access): In addition to personal list sets you can create/edit/delete list sets for a single school, multiple schools, or the whole district. Groups with this access can also manage all list sets created by going to District - List Sets. I would suggest giving this access to the Administrator group if not others.
  • School You're Under: In addition to personal list sets you can create/edit list sets that can be used by the school it was created under. I give my office secretaries and school nurses this option.

Saving/Editing List Sets:

On the List Students screen, fill in the fields/titles and other settings as you would normally.
At the bottom of the List Students screen you will see a new button "Save/Edit List Set". Click "Save as Personal List Set" and give your list a name. This name is what shows in the Load List dropdown.
Depending on your group access, you may also see the button "Save as New School/District List Set". If you have school level access, a message will appear letting you know the list will be available under your current school. If you have district level access, you will be presented with a series of checkboxes for each school in the district.
To edit a list set (assuming you have access to it), select that list in the dropdown and click "Update Current List Set". The list set name will already be filled in, but can be altered.
To delete a list set (assuming you have access to it), select that list in the dropdown and click "Delete Current List Set".
If you have district level access (see setup) you can manage all list sets (school/district/personal) via District - List Sets (under the Code Sets section).

Updating From a Version Previous to 4.x

If you had a version of List Students Auto-Loader before version 4 please visit read these additional instructions.

Version History:

4.2.1 - First release as a plugin. All previous versions were a series of custom pages that you had to edit manually. This version is so much better!

"The email links on Powerschool are not working for me. When I click one it tells me I need to setup Outlook Express?!"
This is why my middle school asked to have all the Mailto links disabled on the parent portal. If your school feels the same way install these custom pages and kiss the idea that everyone uses an email client goodbye.
These pages are formatted for PS version 8.

Technical details:

  • Added a jQuery script to home.html that finds every Mailto link on the page after the quicklookup stuff is rendered and takes out the href attribute.
  • Removed the Mailto links entirely from the teachercomments.html page and added a column that displays the teacher's email address as plain text.
  • Removed the Mailto link in teacherinfo.html and left the email address as plain text.

Version History:

1.5 - Updated for PS version 8. Now uses a page fragment to insert the script on home.html. This means it will not interfere with other customizations and/or PowerSchool updates. See the Database Extensions Advanced User Guide for future explanation.
1.4 - Minor update to accommodate changes in PS version 7.11.
1.3 - Minor update to accommodate changes in PS version 7.8.2.
1.2 - Minor update to accommodate changes in PS version 7.8.
1.1 - Slighlty altered for string changes in PowerSchool version 7.1. Corrected the zip file structure to work properly when imported via CPM.
1.0 - Initial release.

AttachmentSize
Package icon no_more_mailto_v1_5.zip2.78 KB

This customization of the student log page was created to facilitate the printing of a student's log entries for permanent record keeping. The school office also wanted the ability to have signatures print at the bottom. Hence in the upper-right of the page is a drop-down to select a signature, and a button which will reformat the student log entries in a new window with selected signature minus header, footer, and left frame.  It is also worth noting that you could use any image you want in the signatures drop-down. As an example, one could make a image which said "confidential" in big bold letters
The zip file contains three signature examples for you to experiment with.

Setup Instructions:

1. Download and unzip the pages.
2. Scan the signatures you will be using to picture files named appropriately. Try to keep them around 100x250 pixels, although there is no restriction. Put the files into the signatures folder.
3. Alter the signatures.html file so that each option listed corresponds to your signature pictures such as: <option value="John_Doe.jpg">John Doe</option>
4. Copy both the log.html page and the signatures folder to web_root/admin/student/ or re-zip and upload through Custom Page Management (download Pearson's guide to CPM).

Screen shot:

Version History:

2.0 - Updated for PowerSchool version 7.1. Signature drop-down code moved to it's own file (signatures.html). Example signatures now provided. Zip file formatted for import into CPM. Name changed from "Printable Nurse Log" to "Printable Student Log".
1.0 - Initial release.

AttachmentSize
Package icon printable_student_log_v2.zip11.81 KB

This screen is meant to be a one-stop-shop for all common data collected for a student when they register.  Some of the fields are custom. But most are built in. The screen has evolved over time to suit the needs of my district. Even though this is one old old customization (about 15 years now) I still keep it alive as people continue asking about it. And I'm a people person.
I highly recommend that you install the plugin and then alter the /admin/students/registration.html page. I'm sure your district collects different info than mine.

***NOTE*** The unlimited contacts introduced in PS version 12 are NOT supported.

Features:

  • Two versions of the page for download. One with a few Illinois specific fields. The other is not state specific and all the Illinois fields have been stripped out.
  • Hovering your mouse over a fields name will show the internal field name (search term) in a tool-tip.
  • Links at the top will "jump to" specific sections to save on scrolling.  In addition each section header has up/down arrows which will jump to the top/bottom of the page. An additional submit button has been added to the top of the page.
  • The Enrollment Notes link, also at the top, will open a dialog window containing guidance on filling out the registration screen. You enable and edit the enrollment notes at: District -> Enrollment Notes
  • "Copy to mailing" button copies all the home address fields to the mailing address fields.  "Copy to Mom/Dad" button copies the home_phone to mother_home_phone and father_home_phone.  "Map" links next to each address field opens the address on Google maps.

PLEASE NOTE:

  • I've included a Page Fragment that will add the "Registration" link to the student left-hand navigation.
  • If you would like to include some "enrollment notes" for your staff you can enable and edit them at: District -> Enrollment Notes.
  • This page does not incorporate PowerSchool's address validation.
  • You will have to use "page permissions" to specify which users can view and/or edit the page. Article 55267 on PowerSource explains page permissions.

Version History:

5.2 - Just for the Illinois version. Updated the code that pulls in the IL home language codes.
5.1 - Added a page fragment that makes it possible to set the Registration page as a user's Initial Student Screen under Personalize.
5.0 - Overhauled the page a bit. It needed some TLC after years of neglect. Made it so you can enable/edit the enrollment notes in the PS user interface. And made the whole thing a plugin.
4.4 - Replaced the included more2.html page with a page fragment so as not to interfere with all the other stuff people add to the left navigation. Replaced the Enrollment Notes html page with a page fragment. CSS styling for PS version 8.
4.3 - Small update to accomidate the changes in PS 7.8.
4.2 - Had to update the IL state javascripts to work with the 12/12/12 state reporting update. Fixed a minor javascript error related to built in data validation.
4.1 - Updated more2.html page for PS 7.2. Took out javascript field validation and made the page compatible with PS 7.2 built in data validation system. Fixed the federal "default ethnicity". Improved the look of read-only access. Added area/neighborhood, Date of Entry into USA, and two more IL state fields. Added a submit button to the top of the page.
4.0 - Updated for Powerschool version 7

 

Turns out in most of my elementary schools each classroom sends a student down to the office with bus notes each and every morning.
"Susie will be walking today", "Johnny will be dropped off at such and such the rest of the week", etc.
The office then compiles these slips of paper and hands out "Today's Bus Notes" to staff on bus duty and the drivers.
One of my front office friends explained this process to me and asked "Can you streamline this awful thing!"
This may not apply to your district. However, I still think this would serve as a good example for PS admins looking to build something similar with database extensions and the ~[DirectTable.Select...] tag.

Today's Bus Notes plugin adds a new bus icon to the PowerTeacher home page for each section listing. This new Bus Notes page allows you to add/edit/delete one or more bus notes for each student in the class. Notes default to being for "today", but you can change their duration and start date.
On the admin side of PS these notes can be added/edited/deleted from the student Transportation screen.
A page fragment is used to add a link to the admin start page left navigation called "Bus Notes" (only when in a school). This is the report that lists out all the notes for the current date. And this can be printed by the office as much as it likes.
Simple and effective.

Installation:

  1. Go to System - System Settings - Plugin Management Configuration
  2. Upload the Zip file
  3. Enable the Plugin (THIS WILL CREATE DATABASE EXTENSIONS ON YOUR PS SERVER)

Version History:

1.4 - Corrected a big ol' error that prevented the "Permanent Bus Notes" field from saving
1.3 - Corrected a small code error in the more2 page fragment
1.2 - Removed the /admin/student/transportation.html page and added a page fragment in it's place. Added home_room to the "today's bus notes" report.
1.1 - Removed the teachers/home.html page and added a page fragment to create the bus icon for teachers
1.0 - Initial release.

Screenshots:



ADMIN SIDE...

AttachmentSize
Package icon BUS_NOTESv1_4.zip12.95 KB