PowerSchool Test Scores

On this page:

Using the PowerSchool Test Scores tab, you can easily manage test results for an individual student.

Note: In order for tests to appear in the Enter New Test pop-up menu, they must first be created.

Enter Student PowerSchool Test Scores

  1. On the start page, search for and select a student
  2. Under Academics, choose Test Results from the student pages menu. The Test Results page appears for that student.
  3. Click the PowerSchool Test Scores tab.
  4. Choose a test from the Enter New Test pop-up menu. If selecting the test that currently appears, click Submit. The New Student Test: [Test Name] page appears.
    Note: is not necessary to have all three score types (number, percent, or alpha) when importing a score. Import one, two, or all three score.
  5. Use the following table to enter information in the fields:

    FieldDescription
    TestThe selected test appears.
    DateEnter the date of the test using the format mm/dd/yyyy or mm-dd-yyyy. If you do not use this format, an alert appears. If you submit the date with an incorrect format, the date field is submitted as a blank entry.
    TermChoose the term from the pop-up menu.
    Grade LevelEnter the grade level for the test.
    ScoreFor each of the test results, enter the number score, the percent score, and the alpha letter grade.
  6. Click Submit. The Test Results page displays the new test score for that student.

Import PowerSchool Test Scores

Use the Import Test Results function when setting up your initial PowerSchool data, enrolling a large number of new or transferring students, or entering test results for students after receiving the test results. Before importing test results, you must have an ASCII text file containing the test score data being imported, preferably delimited by tabs.

The following table displays a sample import file for eleventh graders who recently took the ACT. This example shows an import file reporting the numeric scores, test date, and students' grade level at the time the test was given. The test results are named Composite, English, Math, Reading, and Science.

student_numberDategrade_levelcompositeenglishmathreadingscience
6452366538/7/03111818171621
6452367418/7/03112829272925
6452366548/7/03111814221918

To record the numeric, percentage, and alphanumeric scores for test results, use the following numeric suffixes after the column headings and one space:

  •  [Column name] 1: Displays the numeric score. For example, include in the Math 1 column the scores 17, 27, and 22.
  • [Column name] 2: Displays the percentage score. For example, include in the Math 2 column the scores 57%, 90%, and 73%.
  • [Column name] 3: Displays that alphanumeric score. For example, include in the Math 3 column the scores F, A-, and C.

Note: It is not necessary to have all three score types (number, percent, or alpha) when importing a score. Import one, two, or all three score types.

The following table displays a sample import file for eleventh graders who recently took a district-level math test. This example shows an import file reporting the numeric, percentage, and alphanumeric scores, test date, and students' grade level at the time the test was given.

student_numberDategrade_levelMath 1Math 2Math 3
6452366538/7/03111757F
6452367418/7/03112790A-
6452366548/7/03112273C


Before importing test results, you must first create a test and its scores

Note: The Quick Import page is now also accessible via Start > System > Page and Data Management > Quick Import.

  1. On the start page, choose Special Functions under Functions in the main menu. The Special Functions page appears.
  2. Click Importing & Exporting. The Importing & Exporting page appears.
  3. Click Quick Import. The Quick Import page appears.
  4. Use the following table to enter information in the fields:

    FieldDescription
    TableChoose the Test Results table from the pop-up menu.
    Field delimiterChoose the field delimiter from the pop-up menu. This refers to the item that will separate the fields in the exported data. If you choose Other, enter the delimiter in the field.
    End-of-line markerChoose the end-of-line marker from the pop-up menu. This refers to the item that will separate the records in the exported data. If you choose Other, enter the delimiter in the field.
    • CR: Carriage return
    • CRLF: Carriage return line feed
    • LF: Line feed
    File to importClick Browse… next to the File to import field. Navigate to the data file and click b.
    Suggest field mapSelect the checkbox to have the system suggest PowerSchool field names for the information in the data file. These are just suggestions and can be changed.
    SchoolThe selected school appears.
  5. Click Import. The Select Test page appears.
  6. Choose a test from the Test pop-up menu. If the test you want does not appear, create it
  7. Click Submit. The Import Records from an ASCII Text File page appears.
  8. Choose the PowerSchool field into which you want to enter each value from the To PowerSchool pop-up menu.
  9. Select the checkbox to exclude the first row. Depending on the text file, the first row may include information about the file and not about the student test results.
  10. Enter the imported value you want to use in the unmapped field, and choose the PowerSchool field from the pop-up menu.
  11. Click Submit. The Import Progress page displays the records that were successfully imported and those that the system could not import because of your specifications. The system imports the data into the Test Scores table. Depending on the type of data, you can view, edit, and report on it.

Edit Student PowerSchool Test Results

  1. On the start page, search for and select a student.
  2. Under Academics, choose Test Results from the student pages menu. The Test Results page appears for that student.
  3. Click the PowerSchool Test Scores tab.
  4. Click the name of the test you want to edit. The Edit Student Test: [test name] page appears.
  5. Edit the information as needed.
  6. Click Submit. The Test Results page displays the edited test score for that student.

Delete Student PowerSchool Test Results

  1. On the start page, search for and select a student.
  2. Under Academics, choose Test Results from the student pages menu. The Test Results page appears for that student.
  3. Click the PowerSchool Test Scores tab.
  4. Click the name of the test you want to delete. The Edit Student Test: [test name] page appears.
  5. Click Delete.
  6. Click Confirm Delete. The Selection Delete page appears.