Skip to main content
Skip table of contents

Student Test Score Import

Contents

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, see 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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.