Reports / Charts:  Activities - Attendance - Discipline / Incident Mgmt - Enrollment - Fees - Grades - Gradebook - Health - Live Schedules - Logins - Misc-Staff - Misc-Students - PowerLunch - Scheduling - Single Sign-on - Standards - Student Contacts - System Admin - Test Scores

If you get a Cross-Site Scripting Error when trying to import a report, please read this article.

 

Gradebook Reports

The following is a list of reports that can be imported into sqlReports, version 4.3 or higher.  Clicking on the report name will take you to the page with the coding to import.  The screenshots were created from fictional data in a sample database provided by PowerSchool.  Reports with uploaded dates prior to 9/1/16 were originally uploaded to sqlreports4.com.  If there are two dates, the - O is the original upload date and the - U is when an updated version was uploaded.

Admin Portal Reports - Any Version

Report Name / Description Created By Uploaded

 
Final Grades and Comments by Course
Allows an admin to choose a course and a grading term and see the grades, percents, and comments entered by the teachers for that term.  (screenshot)
  Matt Freund 1/5/15

 
Final Grades and Comments by Teacher
Allows an admin to choose a teacher and a grading term and see the grades, percents, and comments entered by the teacher for that term.  (screenshot)
  Matt Freund 1/5/15

 
Last Gradebook Update
Allows an admin to enter a date and see those gradebooks that have not been updated since that date.  (screenshot)
  Matt Freund 1/5/15 - O
9/7/16 - U


Admin Portal Reports - PT Pro Only

Report Name / Description Created By Uploaded

 
All Assignments for a Teacher - PTP Only
Allows an admin to choose a teacher and see setup information regarding assignments that a teacher has created for sections in the current term.  (screenshot)
  Matt Freund O - 9/12/16
U - 9/28/16

 
Assignments for a Section - PTP Only
Allows an admin to choose a section and see setup information regarding assignments that a teacher has created for that section.  (screenshot)
  Matt Freund 9/12/16

 
Assignment Scores Info by Section - PTP Only
Allows admins to see when assignment scores were updated for a section within a date range.  Only looks at PT Pro data.  (screenshot)
  Matt Freund 4/10/17

 
Assignment Scores Info by Student - PTP Only
Allows admins to see when assignment scores were updated for a student within a date range.  Only looks at PT Pro data.  (screenshot)
  Matt Freund 4/10/17

 
Assignment Scores Info by Teacher - PTP Only
Allows admins to see when assignment scores were updated for a teacher within a date range.  Only looks at PT Pro data.  (screenshot)
  Matt Freund 4/10/17

 
Comparison of Teacher's Comment Banks
Allows admins to see which teachers at the current school have comments in their teacher PTG and PT Pro comment banks.  School must be using PS 12. (screenshot)
  Matt Freund 4/27/18

 
Lock Reporting Term Information
Allows an admin to view lock reporting term information for the current school.  Only looks at PT Pro data in PS 12.  (screenshot)
  Matt Freund 4/26/18

 free
Lock Status by Section
Allows an admin to view the lock status of all the sections at the current school.  Only looks at PT Pro data in PS 12.  (screenshot)
  Matt Freund 4/26/18

 free
Missing Assignments in PT Pro
Allows an admin to view assignments marked Missing in sections at the current school for the current year.  Only looks at PT Pro data.  (screenshot)
  Matt Freund 1/12/17

 
PT Pro Teacher Comment Banks
Allows admins to view details about PT Pro teacher comment banks for teachers at the current school.  School must be using PS 12.  (screenshot)
  Matt Freund 4/27/18

 free
PT Pro Section Readiness
Allows an admin to run a sqlReports version of the section readiness report.  Sections not stored are excluded.  School must be using PS 11.  (screenshot)
  Matt Freund 10/13/17

 
PT Pro Section Readiness Enhanced
Allows an admin to run a sqlReports version of the section readiness report.  Sections not stored are excluded, plus admins can include additional sections to exclude.  School must be using PS 11. (screenshot)
  Matt Freund 10/13/17

 
Teacher Assignments - PTP Only
Allows an admin to choose a teacher and see basic information about assignments that teacher has created for sections in the current term.  (screenshot)
  Matt Freund O - 9/12/16
U - 9/28/16


Admin Portal Reports - PTG Only

Report Name / Description Created By Uploaded

 
All Assignments for a Teacher - PTG Only
Allows an admin to choose a teacher and see setup information regarding assignments that a teacher has created for sections in the current term.  (screenshot)
  Matt Freund 11/12/14

 
Assignments for a Section - PTG Only
Allows an admin to choose a section and see setup information regarding assignments that a teacher has created for that section.  (screenshot)
  Matt Freund 11/12/14

 free
PTG Teacher Comment Banks
Allows admins to view details about PTG teacher comment banks for teachers at the current school.  (screenshot)
  Matt Freund 4/27/18

 
Teacher Assignments - PTG Only
Allows an admin to choose a teacher and see basic information about assignments that teacher has created for sections in the current term.  (screenshot)
  Matt Freund 11/12/14

Teacher Portal Reports - Any Gradebook

Report Name / Description Created By Uploaded

 
Final Grades and Comments - all Sections (PST)
Teachers can grades and comments and other information in the gradebook for all their sections by simply choosing a section and a grading term.  (screenshot)
  Matt Freund 9/18/16

 
Final Grades and Comments by Section (PST)
Teachers can view grades and comments and other information in the gradebook by simply choosing a section and a grading term.  (screenshot)
  Matt Freund 9/18/16

 
Final Grades and Percents by Section (PST)
Teachers can view final grades and percents from the gradebook for Q1, Q2, and S1.  (screenshot)
  Matt Freund 11/8/16

 
Gradebook Email Addresses (PST)
Teachers can view email addresses that the gradebook uses.  Results can be filtered by contact type.  (screenshot)
  Matt Freund O - 1/14/16
U - 11/8/16


Teacher Portal Reports - PTP Only

Report Name / Description Created By Uploaded

 
Assignments for a Section - PTP Only
Teachers can choose a section and see setup information for the assignments they've created for that section.  Data can be filtered or exported. (screenshot)
  Matt Freund 9/9/16

 
Assignment Scores Breakdown - PTP Only
Teachers can view score information for the assignments they've created for each of their current sections.   (screenshot)
  Matt Freund 9/9/16

 
Assignment Scores Export - PTP Only
Teachers can choose a section and export assignments scores to import elsewhere or use in Excel to create a scoresheet. (screenshot)
  Matt Freund 9/28/16

 
Assignment Scores for a Student - PTP Only
Teachers can view score information for the assignments for a student in one of their current sections.  (screenshot)
  Matt Freund 9/10/16

 
Assignment Scores Info by Section (PST) - PTP Only
Teachers can view when assignment scores were updated for a section within a date range.  (screenshot)
  Matt Freund 4/10/17

 
Current Assignments - PTP Only
Teachers can view setup information for the assignments they've created for their current sections. (screenshot)
  Matt Freund O - 9/10/16
U - 9/28/16

 
Missing Assignments as of Today - PTP Only
Teachers can view assignments that are currently marked as missing.  (screenshot)
  Matt Freund 9/18/16

 
PT Pro Teacher Comment Bank (PST)
Allows teachers to view details about their comments in the PT Pro teacher comment bank.  School must be using PS 12. (screenshot)
  Matt Freund 4/27/18

 
PTP Scoresheet - 7 Assignments Only
Teachers can view the scores for the first seven assignments in a date range.  Report shows student scores and the class average. (screenshot)
  Matt Freund 9/28/16

 
Teacher Comment Banks (PST)
Allows teachers to view details about their comments in the PTG and PT Pro teacher comment banks.  School must be using PS 12. (screenshot)
  Matt Freund 4/27/18


Teacher Portal Reports - PTG Only

Report Name / Description Created By Uploaded

 
Assignments for a Section - PTG Only
Teachers can choose a section and see setup information for the assignments they've created for that section.  Data can be filtered or exported. (screenshot)
  Matt Freund 11/11/14

 
Assignment Scores Breakdown - PTG Only
Teachers can view score information for the assignments they've created for each of their current sections.  (screenshot)
  Matt Freund 12/2/14

 
Assignment Scores for a Student - PTG Only
Teachers can view score information for the assignments for a student in one of their current sections.  (screenshot)
  Matt Freund 12/4/14

 
Current Assignments - PTG Only
Teachers can view setup information for the assignments they've created for their current sections.  PowerTeacher Gradebook only. (screenshot)
  Matt Freund 11/12/14

 free
PTG Teacher Comment Bank (PST)
Allows teachers to view what they have in the PTG teacher comment bank.  Useful to export comments or check them before importing to PT Pro. (screenshot)
  Matt Freund 4/27/18