PowerSchool SIS Manitoba
PowerSchool SIS Manitoba
Breadcrumbs

Import Early Reading Screening Test Scores

Import Early Reading Screening (ERS) test scores into PowerSchool using Quick Import:

  • Quick Import: Use this method to import test results for a single school at the School level.

Prerequisites

  • An Early Reading Screening (ERS-E or ERS-F) test has been created.

  • The test name contains (ERS-E or ERS-F).

  • An Outcome score has been defined for the test.

  • Early Reading Screening (ERS-E): should be used for English assessments

  • Early Reading Screening (ERS-F): should be used for French assessments

Quick Import

Prepare the Quick Import File

Create a tab-delimited text file with the four columns listed below. Use the exact column header names so PowerSchool maps them automatically to the table fields.

Date Format: MM-DD-YYYY

Alpha Score Valid Values:

  • 1: Completed and Met the Benchmark

  • 2: Completed and Did Not Meet the Benchmark

  • N/A: Student is Exempt

Other values may be imported, but they will map to “Did Not Complete Screening” on the report card.

Student_Number

Date

Grade_Level

Alpha

200837

11-30-2023

1

1

Import Using Quick Import

Use this option only when importing test results for a single school at the School level. Do not use this option from the District Office.

  1. Select the school for which you want to import test results.

  2. Navigate to Data and Reporting > Imports > Quick Import.

  3. From the Table menu, select Test Results.

  4. Select the appropriate Field delimiter.

  5. Select the appropriate End-of-line marker.

QuickImport1.png

  1. Click Choose File, and then select your prepared import file.

  2. Select Suggest field map to have PowerSchool map the file fields to the PowerSchool table fields.

  3. Click Import.

  4. From the Test Name menu, select Early Reading Screening (ERS-E for English assessment or ERS-F for French assessment).

  5. Click Submit.

  6. On the field mapping screen, verify that each import field correctly maps to its corresponding PowerSchool field in the To PowerSchool column.

  7. Click Submit.

  8. Review the Import Progress page to verify successful records and resolve any specification errors. Data is imported into the studenttest and studenttestscore tables.


Important Notes:

  • Verify that the import data is accurate before importing.

  • Select the date format that matches the import file.

  • Verify that the term, test date, and school are accurate.

  • Ensure there are no extra spaces or trailing delimiters at the end of the template. Extra spaces can cause the import to fail.