The information provided in this document can be referenced to import the Missouri State Assessment (MAP/MAPA/EOC) Test Results.
Focus Version
12.0.74 and later
Supported File Formats
Tab-delimited, Comma-delimited
Supported Score Types
MAP: Scale Score, Performance Level, Performance Level Code
MAPA: Performance Level, Performance Level Code
EOC: Performance Level, Performance Level Code, Administration Window, Total Raw
Score, Total Percent Correct, Score
Provider
Missouri Comprehensive Data System (MCDS)
Select Import Settings
- Navigate to Imports in the Setup menu, then start the process by uploading your file.
- While in the File Format step, reference the Preview section to make your selections.
- If the uploaded data does not contain a header row, uncheck the box.
- Click Next.
- In the Select Tool step click the Import File card to enter the import settings:
- Select the Test History import tool option.
- Select the desired Import Method.
- In the Standardized Test pull-down, select the available Missouri State Assessment Test option by Subject.
- Select the Parse File check box and then select the corresponding file parser from the pull-down:
- MAP - Science (MAP)
- MAP - Mathematics (MAP)
- MAP - English Language Arts (MAP)
- MAPA - Science (MAP)
- MAPA - Mathematics (MAP)
- MAPA - English Language Arts (MAPA)
- EOC - Geometry (EOC)
- EOC - English II (EOC)
- EOC - English I (EOC)
- EOC - Biology (EOC)
- EOC - American History (EOC)
- EOC - American Government (EOC)
- EOC - Algebra II (EOC)
- EOC - Algebra I (EOC)
- In the Scores Layout pull-down will be automatically set to the appropriate option based on your previous selections, with Test Part & Score Types are combined into one or more columns as the default option.
- In the Conversion Fields section:
- For the student_id conversion field, make sure that the MOSIS Student ID (custom_300000000) option is selected, regardless of which test is being imported.
- Click Continue.
Selecting any of the available Missouri State Assessment file parsers will allow you to review and map all available score combinations by subject as reported by the provider. They also transform the year and administration date data elements to identifiable system standards.
Map Fields and Validate
Once back in the Select Tool step:
- Click Next.
- In the Mapping Template step:
- Choose an existing template, or
- Manually map the available fields.
- Click the Validate button.
- Check the validation results and review errors, if any.
- To complete the process, click Import.