Quick Info Reports query information directly from PowerSchool's Oracle Database. Reports as faster than PowerSchools internal reports and can access data from a number of tables, including: Schedules, Attendance, Historical Grades, Gradebook Grades, Health Information and even testing tables not part of PowerSchool.
There are two basic types of reports Current Selection and Query. Current Selection Reports are indicated by a '(CS)' after the report name and are designed to use the active student selection. Query reports make a selection of students based on parameters entered by the user and derived from PowerSchool. Once generated both types of reports can sort and filter the selected data and create a new selection, export data or print. The example on the right shows two Current Selection reports and three Query Reports from the attendance Category. Query Reports can query and select thousands of records and can be used on the school or district level. Current Selection Reports are designed to be used with a maximum of about 1500 records and work better on the school or program level. Teachers have access to many of the reports including most of the CS reports.
Finding just the right report can be daunting so we divided Quick Info Reports into 18 basic categories. The number may grow or contract as we get a handle on what schools need.
- Assessment - Matches elementary assessment information with PowerSchool students. Dibbles, Kindergarten Assessment reports are included in this category.
- Assessment Secondary - Matches secondary assessment including Benchmarks and ACT testing.
- Athletics - Include reports for eligibility and team rosters.
- Attendance - You guessed it attendance points, trends, teachers calling roll and membership summaries.
- Clearinghouse - Reports and audits used to prepare date for UTREX submission and SSIDs.
- Current Selection Filter Reports - Powerful reports designed to let users find at risk students, check graduation status and evaluate subgroups.
- District Wide Info - District level summary reports including: ADA/ADM, boundaries, and membership by grade on a given day.
- Effort Grades Intermediate Schools - Reports specific to Intermediate Schools.
- Federal CRDC - Summarizes date for federal civil rights reports.
- Gradebook - Current grades and assignments from teacher grade books.
- Health - Health and Immunization reports.
- Information - General information often summary reports, duplicate students and student queries.
- Live Scheduling - Information on class size, master schedules and students missing classes in a specific period.
- Next Year Scheduling - Reports and helps to prepare and schedule for next year, quantify requests and monitor scheduling progress.
- Other - These don't fit well in other categories so for now they are other.
- Special Programs - Reports and audits for special program students and groups including: YIC, Title 1 and 23.
- Student Lists - Lists, lists and more lists.
- Transcripts and Grades - All things regarding stored grades and transcripts.
How do I find Quick Info Reports?
- There is a link on PowerSchool's home page on the left under Reports called Quick Info.
- Remember to make a selection of students first if you intend to use one of the (CS) Current Selection Reports.
- For Query Reports just click on the Quick Info link and choose a report from one of the categories. Note on the image below the Attendance Report Category is open showing the individual reports. At the top of the screen you can see the number of students in the Current Selection and Expand or Collapse all categories.
How do I use the reports to get just the information I need?
- Clicking on the column header will sort the rows based on the value of the column. Column headers are bold.
- Clicking a second time will change the order of the sort. First click ascending, next click descending.
- You can return the report to its default order by sorting on the count column.
- There is an empty entry field (box) below the title and above the data rows. It is used to filter the rows based on what you enter in the box. The image below shows the report filtered using three separate fields. Notice just above the Column Headers the number of rows displayed is indicated.
- If you just want to see first grade students and there is a Grade Column type 01 in the filter box.
- You can filter numbers using > or < operators. For example >03 will show students above 4th grade.
- The ! will filter out a value !01 would show all students except 1st graders.
- A little practice and you will be able to focus on a specific group of students. Remember filters only remove rows. You can't add rows to a report unless you change your selection if you are using a CS report or by changing the parameters on a Query Report.
Adding and removing columns
- To hide or show columns click on the Display columns, see image below. Check the columns you want to show and uncheck to hide.
Changing a reports parameters
- If you change the term the data on the report will change to represent the new term.
- Reports with user modifiable parameters can be altered by clicking on the Change Parameters link. This will take you back to the Parameters Page. Note some reports have no user enterable parameters some may have as many as five.
- To change Current Selection Reports (CS) return to the PowerSchool main menu and select a new group of students.
How do I export the data?
- This may be the simplest trick of all. Once you have the rows and columns you want simply click on Export CSV. The file will have the name of the report with .csv appended to the end.
- On Windows you will be asked of you want to save or open the file. Choose Open With and then find Excel. In the future all files will automatically open in Excel.
- If the file doesn't automatically open or prompt you just brows to the file on your computer and open it using Excel.
How can I combine the student selection from a Query Report with a Current Selection Report get the right selection and the fields I need?
- Query Reports can be used to find selections that can then be used in a Current Selection report. For example you could use the Attendance Points Query report to find students with attendance problems and then use an At Risk report to see if their are other problems.
- Many of the student list and audit reports can find specific groups of students that can then be directed to one of the Current Selection Reports to gather more information. Try using ELL Students by School to find the ELL to find ELL students then go to Current Selection Filter Reports and check on graduation progress, At Risk or demographics.
Why do some reports take so long?
- Reports that summarize date from several sources like the At Risk reports which track attendance, Logs, Incidents, Historical Grades, Current Grades and Test Scores take a while. We are talking minutes not hours or days. Other reports that deal with mostly student data are very fast second to run for all the students in a school.
- Be patient and when you are testing different reports to see which one you like run them using small current selections.
The concept of Quick Info Reports is based on a customization by Power Data Solutions but the framework was coded by Jim Black using PHP and Java. The live filters are based on HTML Table Filter Generator v. 2.1 ©2009-2011 by Max Guglielmi.