The Import Test Results page includes the file layout for the NWEA MAP assessment results.
Select the NWEA MAP - ComboStudentAssessment file layout to import the NWEA MAP assessment results.
The Import Test Results page has been programmed to import only the ComboStudentAssessment layout. This is a single comma separated file (.csv) that includes both the student demographic information and the assessment results.
Select the file and click on Open. Then continue to load and match the records.
The Default Date for the NWEA MAP Results is the oldest date in the data file. The Testing Administration for the Test Results is YYMM where YY is the year and MM is the month of the student's Test Start Date in the data file. The Default Date and default Testing Administration will be used for any records that do not have a Test Start Date in the data file.
The Student's Permanent ID is the primary identification in the NWEA MAP Combo Student Assessment data files. It should be the first method used for matching students. The student's name and date of birth are also in the file and can also be used as additional matching criteria.
The NWEA MAP import will add/update records to the Testing (TST) and Content Standards (CST) tables.
After the import process has completed an email with summary information will be sent to the user that initiated the import.
The NWEA MAP test results can be viewed in the Test Details page or in the Test Scores and Content Standards Scores pages.
The Test Details page displays the NWEA MAP results in a card format by Testing Administration. The subject area, test date, Overall RIT Score, Percent Correct and Percentile are stored in the Testing (TST) records in Aeries. The Goals RIT scores are stored in the Content Standards (CST) records in Aeries. The Reading assessment may also include a Lexile® level which displays on the Reading card and is also stored in the Testing (TST) records.
The Test Scores (TST) page includes the overall performance information for the assessment.
Below is a chart of where the NWEA MAP scores are stored in the Testing (TST) table and how they are identified in the Test Details page:
|NWEA MAP Score Field||Aeries TST field||Test Details Identifier|
|TestRITScore||Scale Score (TST.SS)||Overall RIT Score|
|PercentCorrect||Percent (TST.PR)||% Correct|
|RITtoReadingScore||Other (TST.OT)||Lexile® Measure|
Negative values in the Other (TST.OT) field will display as a BR Lexile® measure on the Test Details page:
The Content Standards Scores (CST) page includes the Goal RIT scores for the assessment. The GoalRitScore for each NWEA MAP goal is stored in the Content Standards Score (CST.RS) field.
NWEA MAP Test Codes and AdminCS
The NWEA MAP test areas and goals are defined in the Testing Control Table (CTL) and Content Standard Names (CSN) tables. Running AdminCS will add/update the appropriate codes into each table. Since there are a variety of NWEA test types, measurement scales and goals that can be imported, Aeries is defining all of the codified values for the NWEA MAP test parts. We do not recommend that districts create their own codes for the NWEA MAP assessments.
Beginning with the 11/22/2019 Aeries Client update if new NWEA MAP test parts are in conflict with existing district-defined Testing Control Table (CTL) records, a message will appear during the AdminCS update.
In the below example the district defined Testing Control Table (CTL) part 4 as Literature and part 23 as Oper & Alg Thinking. After the AdminCS update was run these parts were re-defined as Reading - Spanish and Math-Spanish.
In this example the district will need to determine how many students have Test Scores (TST) records with parts 4 and 23 (remember to Include Inactive Students):
LIST STU IDN TST STU.TG STU.SC STU.ID STU.LN STU.FN STU.GR TST.ID TST.PT TST.TD TST.TA IF ID = MAP AND ( PT = 4 OR PT = 23 )
These students will need to have their Test Scores (TST) and Content Standard Scores (CST) records reviewed and/or updated to use the Aeries standard for the NWEA MAP scores, which is overall subject scores in the Test Scores (TST) table and the individual assessment parts in the Content Standards (CST) table.
NOTE: : Aeries has defined all of the codified values for the NWEA MAP test parts. We do not recommend that districts create their own codes for the NWEA MAP assessments.