Schedule a demo

Delivering Data You Can Trust

3 min read

How to Quickly Produce a Test Scores Report in PowerSchool

March 11, 2022 at 10:00 AM

Districts often enter test scores into PowerSchool whether this means SAT or ACT scores at the high school, state testing scores for elementary or middle school students, placement test data for specific subject areas, or any other test scores that need to be available for review.

PowerSchool allows for the ability to enter this data for each individual student. Reviewing the data by students has always been the easy part. 

However, reviewing if for larger groups is much more complicated. Whether trying to export the data directly or just print it to a report such as a transcript.

The options for accessing test scores, directly from PowerSchool, have always been limited. But now with the use of our Test Scores Report, the ability to review and filter all test scores, whether for a single student or a larger group, has just gotten a whole lot easier.


How to run the report:

Before navigating to the reports, you can select from the start page the group of students for whom you want to run the report. This can be anywhere from a single student to the entire school.

Once selected, click on RealTime Reports from the Level Data app section of the start page. From the dashboard, select the Test Scores Report.

When the pre-filter appears, you can select a specific test or tests from the drop-down list. If no selection is made the report will return a record for every test ever taken for the selected group of students.

The student selection will reflect the previously selected student group. Once all options have been made, click run.

Once the report loads, you'll see a graphical breakdown of data by test score and then by each score type, alpha, number and percent, as well as a breakdown by gender, grade level, and ethnicity.

Individual student records

To view the individual student records, scroll down the page. In the table, you'll see a list with a record for each student and test that includes some basic demographics data, along with information specific to each test such as name, type, the school enrolled, term, grade level and date when taken, in addition to the alpha percent or number scores.

Data from this report can be useful in several ways, whether simply trying to export all of the results for a specific test term or grade, to compare scores based on gender or ethnicity, or even to review a student's progression over time. 

Getting to the data you need is as simple as selecting the necessary filters. For example, if I wanted to find all 11th-grade students that have an ACT reading score for the 2021 term, I would select from the filters on the left, the test score name of ACT reading, the term 2021, and the grade of 11.

Note that the test scores names and terms will be specific to the way your district entered the data.

No matter what the criteria, this report provides a simple and straightforward process to get to the data you need.

If you'd like to work with the filtered group of students back in PowerSchool you can make a current student selection button to create a new student selection or you can click the add to current student selection if there's already a group you're working with and you just like to add the filtered students to that list. 

If you'd like to export the results, click the export button. This will generate a CSV file that includes all the report data for the filtered group of students.

No need to know any field names, table names, or complicated dot tags.

Getting to your data has never been easier.

Tom Lang
Written by Tom Lang

Tom Lang has spent more than 3 decades in the field of journalism and marketing, while always having a hand in public education. His father was a school teacher, his mom a school secretary, and his wife teaches high school English and Humanities. On his own, Tom worked his way through college as a school bus driver and today remains closely tied to education as a Board member of FIRST (Robotics) in Michigan. He has worked with high school coaches and athletes for nearly 30 years as a freelance sports writer at the Detroit Free Press, and for more than 10 years as a basketball referee. Bottom line -- help kids grow, learn and create productive futures.

Post a Comment