There are two ways to add test scores into PowerSchool, manually or an import. When adding many scores, importing is the best method, but takes time and care. Adding one off or adjusting scores can be done though the manual method.

Manually Adding Test Scores

1. Log into PowerSchool Administrator
2. Select the student
3. Click on Test Results from the left menu
4. Select the test the scores are a part of
5. Click Submit
6. Enter the date of the test
   • For test dates other then MAP and AP tests, the actual test date can be used.
   • The test dates for MAP must be one of the below where YYYY is the four digit year 
     • For Fall     10/01/YYYY
     • For Winter 01/01/YYYY
     • For Spring 05/01/YYYY
   • For AP Tests use 05/01/YYYY
7. Enter the semester it was taken
8. Enter the grade level of the student at the time the test was taken
9. The next screen will show all the possible scores available
10. Enter the score in the Numeric column that corresponds to that score
    • Do not enter information in the Alpha and Percent columns

Importing Scores

Importing test scores is different then a normal import.  For each test, one of the below templates must be used.  Also once a test is imported, test scores cannot be add, updated, or changes via an import; they must be done by hand, manually.  The import templates are to be opened using Excel

Importing scores is a two step process. Step one is enter the data into the proper template below.  Step two is to send the template to the school data personal, who can then import the data.  If the data is not enter correctly in step one, the data personal are not responsible for data being importing incorrectly.

Using the Import Template

The staff member in charge of creating the file to be imported into PowerSchool must use the appropriate template below.

1. Decide which test will be imported
2. Download the appropriate template below
3. Open the template in Excel
   • For more information on opening the template in Excel Please go here Opening File in Excel
4. All fields in the template are required
   • If a score is unavailable, leave that score empty.  Do not enter a zero or anything
   • For test dates other then MAP, the actual test date can be used.
   • The test dates for MAP must be one of the below where YYYY is the four digit year 
     • For Fall     10/01/YYYY
     • For Winter 01/01/YYYY
     • For Spring 05/01/YYYY
5. Once the file is finished, create a Web Help Desk ticket with the attachment with the problem type of student data request
   • Remember that once scores are imported the only way to change, update, or delete scores is by individual students manually

Importing Test Score

In the building, only data personal are allowed to import data into PowerSchool.  Test scores follow a similar process to import test scores are import demographics.  The only difference is that there is one more step involved.  As with every import into PowerSchool, always either test the import on the test server or import only the first several line, check the import, and then import the remainder of the file

1. Review the file and verify that everything is filled in properly
   • If the file is incorrect, notify the person creating the file that something is out of place.  Be specific.
2. Log into PowerSchool
3. Click on Special Function>Importing & Exporting>Quick Import
4. For Table choose Test Results
5. Choose the file
6. Check the checkbox Suggest field map
7. Click Submit
8. Choose the proper test
9. Make sure the settings look like the settings in the table below
10. Click Submit

Test	Import Template	Import Settings
ACT	ACT-Score-Template
Explore	Explorer Score Template
MAP	MAP Score Template
PLAN	PLAN Score Template
PSAE	PSAE Score Template
ACCESS	Access Score Template
SAT	SAT Score Template
PSAT 8/9 PSAT/NMSQT	PSAT Score Template
AP Test	AP Test Template
AAPPLTest	AAPPL Test Template
DLM Put in the score of 9 for missing/not tested stores	DML Test Template
STAMP If Listening and Speaking have non-numeric values use the column ending in .3	STAMP Test Template