Student Test Score Import
Introduction
This import reads a tab delimited file containing the necessary data for importing Student Test Scores. The import adds the scores to the StudentTestScores table for the specified students, tests and terms. The import also creates a result page, saved for subsequent viewing on the Student test Score Import Results page.
Selection Criteria
This report has no specified selection criteria.
Report Input
For help with navigation and running the report, refer to How to Find and Generate a Report.
Field | Description |
File To Import | Click the Browse button and navigate to and select the tab delimited file to import. Required. |
Header Row? | Select Yes or No to indicate if the file contains a header row. |
Date Format Used In File | Select the format used for the date data. |
Import Process
When a Student Test Score occurs, the selected file is read by PowerSchool and values are extracted from the file. This includes:
If the user has indicated that there is a header row, the first line will be ignored.
Data is tab delimited, with data organized in tab delimited columns, in the following order:
Data marked with * is required. Blank values may exist for non-required fields, but the tab separation must still be maintained.
The values imported correspond to the following fields within PowerSchool:
STUDENT_NUMBER*
SCHOOL_NUMBER
TERM_CODE
GRADE_LEVEL
TEST_NAME*
TEST_DATE*
SCORE_NAME*
ALPHA_SCORE
NUMERIC_SCORE
PERCENT_SCORE
Import Value | PowerSchool Database Field | Constraints |
STUDENT_NUMBER | [Students]Student_Number | Matching value must exist for import of record to occur. |
SCHOOL_NUMBER | [Schools]Alternate_School_Number or [Schools]School_Number if [Schools]Alternate_School_Number is 0 | Matching value (or blank) must exist for import of record to occur. Must exist if TERM_CODE is specified. |
TERM_CODE | [Terms]ID | Matching value (or blank) must exist for import of record to occur. |
GRADE_LEVEL | [StudentTest]Grade_Level | If SCHOOL_NUMBER is specified, this value must be between [Schools]Low_Grade and [Schools]High_Grade for import of record to occur. |
TEST_NAME | [Test]Name | Matching value must exist for import of record to occur. |
TEST_DATE | [StudentTest]Test_Date | Must be a valid date and must be formatted as specified at import run time. It TERM_CODE is specified, must exist within term. |
SCORE_NAME | [TestScore]Name | Matching value must exist for import of record to occur. Must also have corresponding [TestScore]TestID as matches imported TEST_NAME. |
ALPHA_SCORE | [StudentTestScore]ALPHASCORE | If matching [StudentTestScore] record exists, this value will be updated. |
NUMERIC_SCORE | [StudentTestScore]NUMSCORE | Must be numeric. If matching [StudentTestScore] record exists, this value will be updated. |
PERCENT_SCORE | [StudentTestScore]PERCENTSCORE | Must be numeric. If matching [StudentTestScore] record exists, this value will be updated. |
The import will search for a matching StudentTest value, where the test name matches the imported TEST_NAME and the [StudentTest]StudentID corresponds to the student specified by STUDENT_NUMBER. If there is no match, a StudentTest record will be created.
The record must contain at least one of the following:
ALPHA_SCORE
NUMERIC_SCORE
PERCENT_SCORE
Results of the import (successes or fails) will be sent to the import log for later review. The results of the import log are discussed in Import Results.
Because the import may be performed for multiple schools, most results will only be available at the District Office level.