In this page, you will learn how to import test scores into PowerSchool. For the purposes of this walkthrough, an ACT upload is used but the same would apply to any test.
Step 1: Populate the test import template
Start by downloading the Import Test Scores Template here:
The header row should look something like this:
If you are not sure about what the {ScoreName} should be in your case, please contact us and we will help you to find out how your test is configured.
Step 2: Save the file as a tab delimited text file in Excel.
This should be located under File > Save As in Excel. You might the “Format” pull-down but this is dependent on the version of Excel that you have.
Step 3: Upload
From the Admin Home Page, navigate to Special Functions > Importing and Exporting >Quick Import.
If you do not have access privileges, please contact us. From here, you want to
- Choose “Table: Test Results”
- Chose the tab delimited text file that you have now saved to your computer.
- Click Import
Choose the Test Name and click “Submit”
Map your file headers to matching PS fields and check the box titled “Check to exclude first row” and click Submit.
Spot Check to make sure that there were no errors upon upload. If there are errors, they will show up in Red.
