Test Scores

There are no special requirements for entering Test Scores for PIMS State Reporting. The following section explains how to use the Import Scores from File utility to load students' test data into eSchoolPlus from an outside file.

Import Scores from File

Test Scores > All > Utilities > Import Scores from File

This menu option allows the user to load test data from a file into eSchoolPlus.

Fields	Description
Interface ID	Select the import definition you wish to run.
Test – Level – Form	Displays the test, level, and form. This will fill automatically depending on the Interface ID you select.
Test Date	Enter the date the test was taken. If the import definition has a test date defined, this field is inaccessible.
Run Mode	Select the mode you wish to run: Verify upload data: This mode will produce a log file showing the changes that will be made to the database. You can review the changes to be made and make any corrections. Run Test Score Import: This mode will run the upload and will insert records or update existing records.
Insert New Records	Checked if you want to create new records.
Update Existing Records	Checked if you want to update existing records.
Only Update Blank Fields	Checked if you want the upload to only update fields that are blank.
Import Directory	Path where the file will be stored.
File Name	Filename of the source data. The default name comes from the Import Definition, but you can change it.

To Run the Test Score Import

Select Test Scores > All > Utilities > Import Scores from File, and then select the appropriate Interface ID.
At the Run Mode prompt, choose the option Verify Upload Data to verify the import interface is defined correctly for the data file.
Choose a Test Date, and select whether you want the import to Insert New Records and Update Existing Records.
ClickRun.
From the Navigation bar's Tasks/Reports menu, select the Test Score Import Log and review the SQL to verify data will be correctly updated or inserted.
If the data is not correct, review the data file and import definition and make the necessary changes to the definition. Repeat Steps 1-3 until the SQL is correct.
Once the data is correct, set the Run Mode to Run Test Score Import.
Set values for the remaining prompts, and then click Run.
From the Navigation bar's Tasks/Reports menu, select the Test Score Import Log and review for errors.
Check test records that were loaded to verify the records are correct. Select Test Scores > All > Office > Test History by Test to open the Test History by Test Search page and click the link for the test you loaded.