sisresources.com logo
 


 

RE - Premier 5.2 Versions Only

Click on the report names to download a zip file which has the report inside of it.   If you're not familiar with loading a reporting engine report or viewing the setup, visit the Reporting Engine Basics page first.

Absentee Report - Daily - (created by Bob McGregor) - a modified version of the absentee report that includes mother and father day phone.  Be sure to read the readme pdf for possible changes to make for the report to run correctly for your school.

Absentee Report - Meeting - (created by Bob McGregor) - a modified version of the absentee report that includes mother and father day phone, and a minimum number of periods that must be met to appear on the report.  Be sure to read the readme pdf for possible changes to make for the report to run correctly for your school.

EOY Checker - (will appear as PRE - EOY Checker in the report list) - a report to help with the end of year process.  The report shows the student name, grade level, next grade level, and next school.  The student name is a hyperlink to the student's Schedule Setup screen to make making changes easier.  If the next grade level is less than or equal to the current level, the line is highlighted.  If the next school is blank, the 0 in that column is highlighted.  Runs for current school only.

Low Current Grades - (version 5.2a, will appear as Low Current Grades in the report list) - this report generates a list of students who are currently receiving low grades based on either letter grades or percentages or numbers.  There are three reports in the download.  Two will let you can run the report for the entire student body or for students involved in a particular activity.  The other one will let you run the report for the current selection of students or the entire student body.  You can sort by student name, grade level, expression, grade percentage, teacher name, or course name.  You can choose which columns to display on the report and at the bottom is a link to Group Functions.   Be sure to read the readme file in the download for important information.

Low Current Grades Export - (version 5.2a, will appear as Low Current Grades Export in the report list) - this report generates a tab-delimited file of students who are currently receiving low grades based on either letter grades or percentages.  The report will run for the entire student body at the school.  You can sort by student name, grade level, expression, grade percentage, teacher name, or course name. 

Student Attendance Detail - (created by Bob McGregor) - a report that will show all attendance for a student or students based on the school the student was enrolled in for the last date you request.  Will also show any attendance comments.  The current school can run the report for a student for the prior school or school year for the student as well.  Be sure to read the readme pdf for possible changes to make for the report to run correctly for your school.


Pro or Premier

The following reporting engine reports run on Pro 4.3.x and Premier 5.1 and 5.2.  Some of these reports have been created as custom pages, but for ASP customers it may be easier and faster to load the report than wait on support to get the custom page installed.

Daily Log (v. 1.1, appears in Powerschool as Calendar Hours/Minutes) - generates a report of the number of minutes and hours within a user defined time frame for a school day based on the school's calendar setup.  Requires modifications so be sure to read and follow the readme pdf in the download file closely.

DBLog Transactions (v. 1.0 - click here to read more about it) - generates a report that lists information from the dblog table, which is a table that keeps track of certain changes to the database, including when certain things are modified or deleted.  Can be run for a date range and show transactions of all staff or just certain staff.  Output can be sorted by name, date, ip address, or transaction code, and output shows the name of the person, his or her ip address, date and time of the transaction, and code and any additional data that was recorded with the transaction.

Detailed PowerLunch Cash Report (v. 1.1 - fixes guest reporting problem of 1.0) - generates a detailed report for the school regarding cash and check transactions.  Allows you to specify a range of dates and look at only student transactions, staff transactions, guests, or all three.

Enhanced Birthday List (v. 1.1, updated to include 2009) - generates monthly birthday lists based on the DOB field so no need to export to Excel.  Also lets you choose to show all the students in the school who match the criteria or just ones in certain grade levels.  Zip file includes readme on how to change the drop-down list of year choices.

Inactive or Active Since (v. 1.2) - generates a list of students for the current school based on searching for inactive students since a specific exit date or active students enrolled since a specific entry date.  Each name on the list is a hyperlink to the student screen for the student.  There's also a group functions link at the top in case you want to run a group function for the group or select some of the students by hand for a report or other functions.

Last Grade Update (v. 1.2 - adds an easier way to select terms to view) - This report allows admins to view the last time a teacher updated grades or added an assignment.  It runs at the school level and can be run for one teacher, a selection of teachers, or all the teachers.  The report will show the teacher, term, expression, course name, last grade update, and the number of days ago the update happened.  If a teacher has not entered any grades or assignments for a course, the row for that course will be highlighted.  You can also have the report highlight rows where the update is older than a certain amount of days. 

Login Information - System Wide (v. 1.0) - any user type who has logged in during the time period you specify will appear on the report based on your criteria.   You can choose to show statistics on  guardians, students, teachers, substitutes, admins, PowerSchool support, or all the types.  The dates, times, hits, views, and durations of logins during the time period are shown.  Various sorts are possible with totals and averages based on the sort, as well as overall totals and averages at the end of the report.  (screenshot - similar to the one for Guardian and Student Login Statistics report)

Login Search by Date (v. 1.0) - this report will generate a list of student accounts which have either 1) not been accessed since a certain date, or 2) were  accessed at least once on a specific date.  It can be run to look up either guardian login or the the student login information.  The output will show the student name and grade level, and there is a link on the bottom of the report to the group functions page with those students as the current selection.  There is also a number to the left of each student's name that when clicked on will take you to his or her's Net/Phone Access student screen.

Page Permissions by Group (v. 1.0) - should only be loaded and used by the system administrator, choose a group and the report will show the current access for that group on pages that have had permissions modified

Page Permissions by Page (v. 1.0) - should only be loaded and used by the system administrator, choose a page that has had it's permissions modified and the report will show permissions for that page for all the groups

 

Back to the main RE page.



Home  |  RE  |  DDE  |  ODBC  |  SQL  |  PT  |  FAQ  |  Contact

Latest Updates to the Site

© Matt Freund - 2008

Any software mentioned on this site is the trademark of the respective owners.

This site is best viewed with Internet Explorer.