Report

Entry/Exit Report V 3.1

Submitted by jtreadwell on Fri, 01/08/2010 - 3:16pm

Oracle Version: Premier report that allows a user to search for student entries and exits during a certain month. Special thanks to Brian P. Andle.

V 1.0 (01/12/2008)
- Initial Release

V 2.0 (07/29/2008)
- Updated for Oracle
- Added EntryExitReportHeader.html and EntryExitReportFooter.html

V 2.0.1 (07/31/2008)
- Fixed a problem with the EntryExitReportHeader.html page and EntryExitReport.html page. All other pages are the same as V 2.0

V 2.1 (09/20/2008)
- Added Grade_Level to the report.

V 2.2 (02/27/2009)

Daily Attendance Summary with Subtotals V 1.1

Submitted by jtreadwell on Thu, 10/29/2009 - 3:13pm

Daily Attendance By Date, Code, School Report will report the attendance counts by code, by date, and by school for one school or the entire district. Users can pick the date range, if they want present codes, absent codes or both, and if to view just one school or the entire district. Subtotals by Present/Absent, School, and Day.

Version History:
V 1.0 (08/16/2008)
- Initial Release

V 1.1 (10/29/2009)
- Added % of total enrollment for each day

Alert List V 3.1.1

Submitted by jtreadwell on Fri, 10/02/2009 - 9:30am

Oracle Version: Report that displays which alert each student has in a class or section. User hovers over the image to view the alert. Based off of a Advanced Learning Summit 2008 customization by PowerSchool

V 2.0 (05/29/2008)
- Initial Release

V 2.1 (06/02/2008)
- Added a link on admin/alerts/alertlist.html to launch a new window with the student’s record when clicked.
- Added a link on teachers/alerts/alertlist.html to launch a new window with the student’s record when clicked.

V 3.0 (09/20/2008)
- Updated for Oracle

V 3.1 (09/18/2009)

sqlReports

Submitted by ddahlvan on Wed, 03/25/2009 - 1:26pm

sqlReports is an ad hoc reporting add-on that can turn simple to medium sql queries in to web based reports in PowerSchool. Essentially, you would create a sql query in your favorite query tool then copy and paste the query in to sqlReports. sqlReports will help convert the query from multiple columns of raw data to just sql one column with data separated by table cell tags (the tds and /tds). You also can use up to 5 different parameters to make the reporting more flexible.

One Stop Attendance V 3.1

Submitted by jtreadwell on Wed, 02/25/2009 - 3:45pm

Oracle Version: Attendance screen that allows for the search and edit of attendance records all from one screen. Users can search for attendance by code, all codes, daily, meeting, all present codes, all absent codes, etc.

V 2.0 (01/14/2008)
– Initial Public Release

V 2.1 (01/16/2008)
– Updated attendancetoday.html to take account for blank present codes. Previously would not return any data if the present code was a blank (as powerschool recommends). Now will display present records correctly.

V 2.2 (03/07/2008)

Live Side Teacher Free Report V 1.1

Submitted by jtreadwell on Wed, 10/22/2008 - 11:49am

Live Side Teacher Free Report (Oracle)
This new report displays teacher free periods. Users can search by teacher, department, period, rotation day or any combination of them. The user must select a date to search which means you can search months into the future. This allows for finding free teachers during future testing dates (that was my user's first reaction).

Version History:
V 1.0 (09/23/2008)
– Initial Release

V 1.1 (10/22/2008)
– Page headers print on all pages

Grade Information by Department Report V 2.0

Submitted by jtreadwell on Tue, 10/21/2008 - 4:53pm

This new report allows a user to look up all grades for a particular department. The term the user is in determines what sections are pulled. This means that changing a term to a previous year will pull up grades from past years. The store codes pulled will be the same store codes that are set up for the verification screens. Results are sorted by Teacher, course number, section number, then student's name.

V 1.0 (05/29/2008)
– Initial Release

V 2.0 (08/04/2008)
– Updated for Oracle

V 2.1 (10/21/2008)
– Page headers print on all pages

Gradebook Categories V 2.1

Submitted by jtreadwell on Tue, 10/21/2008 - 4:13pm

This new report shows all the different gradebook categories being used by any of the teachers in a single school or the entire district.

V 1.0 (01/14/2008)
– Initial Release

V 1.1 (02/28/2008)
– Fixed printability for IE. Should now print correctly.

V 2.0 (08/04/2008)
– Updated for Oracle

V 2.1 (10/21/2008)
– Page headers print on all pages

Live Side Student Free Report

Submitted by jtreadwell on Tue, 09/23/2008 - 9:06pm

Live Side Student Free Report (Oracle)
This new report displays student free periods. Users can search by student, grade level, team, period, rotation day or any combination of them. The user must select a date to search which means you can search months into the future. This allows for finding free periods after courses are dropped as well.

Version History:
V 1.0 (09/23/2008)
Initial Release

Syndicate content Syndicate content Syndicate content