Classic View: MO State Reporting > MOSIS Extracts > Pre-Code File > Extract Type: MAP SPR
Search Terms: MOSIS Extracts
The MAP Spring Assessment Pre-Code file generates pre-code labels for students in grades 3-8 who take the spring Missouri Assessment Program. The MAP Assessment is submitted in January.
Report Logic
The roster date is ignored for this extract; meaning, a student who dropped a course still reports on the extract. This also means a student who is not scheduled into any courses for ELA, MATH or SC still reports a record.
Only one homeroom record generates as a result in the extract if the student is scheduled into multiple homeroom sections.
- If MAP Sort Option is set to Room Number, the homeroom flag does not need to be selected.
- If the assessment is chosen as MAPSPR, the SORT value is expected. This value is chosen on the Course Section editor.
- If MAP Sort Value 1: Room Number is selected, the room number of the section into which the student is scheduled report.
When the Assessment Subject field on the Course editor is set to ELA, MATH and SC, a record for each subject area reports, if the student is enrolled in a course section with the associated assessment subjects.
- MATH and ELA report for grades 3-12.
- MATH, ELA and SC report for grades 5, 8 and 11.
- SC reports for grades 5, 8 and 11.
- If there is no subject code, the Teacher's first and last name and email address does not report.
- If students meet the reporting population but are not scheduled into a course with a Subject Area of ELA, MAP or SC, one record reports as a blank value.
- When the Subject Code is ELA, MATH and SC but no section has the assessment type of MAPSPR, a record reports for the student but teacher data reports a blank value.
Information does not report if a student's enrollment record is marked as MAP-A in the Enrollments Editor.
Additional records are not returned for students with the same first and last names.
Report Editor
Field | Description |
---|---|
Extract Type | Indicates the type of MOSIS Extract being generated. Choose Pre-code File. |
Report Protected Identities | When marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields. |
Report State Excluded Student | When marked, students who meet the report population requirements but their enrollment record is marked as State Exclude report along with all other records. When not marked, students marked as State Exclude on their enrollment record are excluded from the report. |
Date Range | Entered date is used to return students actively enrolled as of that date. |
Ad hoc Filter | Selection of a filter limits the set of students to only those included in the filter. |
Assessment Type | Determines the pre-code file that generates. Choose MAPSPR: MAP |
Select Grades | Indicates which grade levels are included in the extract. All grade levels can be selected, but the MAP Assessment extract only reports data for students in grades 03-08. |
Format | Determines the program used to display the report. State Format is in CSV - use this option when submitting data to the state. Use the other options or data review and testing - Tab Delimited, HTML, or XML. |
Calendar Selection | Indicates from which enrollments are included in the extract. At least one calendar must be selected to generate the report. Calendars can be selected by active year, school name or year. |
Report Generation | The report can be generated immediately using the Generate Extract button. When there is a larger amount of data chosen (several calendars, large date range, etc.), use the Submit to Batch button, which allows the user to choose when the report is generated. See the Batch Queue article for more information. |
Generate the MAP Assessment Pre-Code Extract
- Select the Pre-code File option from the Extract Type dropdown list.
- Mark the Report Protected Identities checkbox, if desired.
- Mark the Report State Excluded Students checkbox, if desired.
- Enter the Date Range in mmddyy format or by clicking the calendar icon and selecting a date, if applicable.
- Select an Ad hoc Filter, if applicable.
- Select the Assessment Type as MAPSPR: MAP from the dropdown list.
- Select which Grades to include in the report.
- Select the desired Format of the extract. For submission to MOSIS, select the State Format (CSV). Select any of the other formats for data review prior to submission.
- Select which Calendar(s) to include report within the extract. Selecting multiple calendars may impact extract generation times and overall Campus performance.
- Click the Generate Extract button or the Submit to Batch button. The extract will appear in a separate window in the designated format.
Report Layout for MAP Pre-Code Files
Element Name | Description | Location |
---|---|---|
Collection Version | Indicates the assessment type selected on the extract editor Collection version contains the value YYYYMAPSPR1.0AsmPre where: YYYY = the reporting school year (2010, 2011, etc.). Alphanumeric, 50 characters | MO State Reporting > MOSIS Extracts |
Current School Year | The ending year of the current school year. Date field, 4 characters (YYYY) | System Administration > Calendar >School Years > End Year Calendar.endYear |
Reporting District Code | DESE-assigned 6-digit county district code for the district reporting. Numeric, 6 digits | System Administration > Resources > District Information > State District Name District.number |
Reporting School Code | DESE-assigned 6-digit school code for the reporting school. Reports the selected code entered on the State Reporting Fields Enrollment editor, if populated.
Numeric, 4 digits | Student Information > General > Enrollments > State Reporting Fields > Reporting School; Residing School Enrollment.reportingSchool Enrollment.residingSchool System Administration > Calendar > Calendar > Calendar > Type Calendar.type System Administration > Resources > School > School Org Type; State School Number School.type School.number |
State ID | State-assigned student identifier. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
Local Student ID | School-assigned student identifier. Numeric 20 digits | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
Last Name | Legal last name as it appears on the student's birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's last name reports from the Legal Last Name field if populated. Alphanumeric, 50 characters | Census > People > Demographics > Person Information > Last Name Identity.lastName Census > People > Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
First Name | Legal first name as it appears on the student's birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > First Name Identity.firstName Census > People > Identities > Protected Identity Information > Legal First Name Identity.legalFirstName |
Middle Name | Legal middle Name as it appears on the birth certificate. When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Middle Name field if populated. Alphanumeric, 30 characters | Census > People > Demographics > Person Information > Middle Name Identity.middleName Census > People > Identities > Protected Identity Information > Legal Middle Name Identity.legalMiddleName |
Suffix | Generational indication (Jr., III, etc.) part of the name, if any. When the Report Protected Identities checkbox is marked on the report editor, the student's middle name reports from the Legal Suffix field if populated. Alphanumeric, 10 characters | Census > People > Demographics > Person Information > Suffix Identity.suffix Census > People > Identities > Protected Identity Information > Legal Suffix Identity.legalSuffix |
Date of Birth | Student's birth date as it appears on the birth certificate. Date field, 10 characters | Census > People > Demographics > Person Information > Birth Date Identity.birthdate |
Student Grade Level | Grade level of enrollment at the time data is being submitted, unless otherwise specified. Alphanumeric, 2 characters | Student Information > General > Enrollments > General Enrollment Information > Grade GradeLevel.stateGrade Enrollment.grade |
Gender | Reports the student's gender. When the Report Protected Identities checkbox is marked on the report editor, the student's gender reports from the Legal First Name field if populated. Alphabetic, 1 character (M or F) | Census > People > Demographics > Person Information > Gender Identity.gender Census > People > Identities > Protected Identity Information > Legal Gender Identity.legalGender |
Race/Ethnicity | The student's defined race/ethnicity. Alphanumeric, 2 characters | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
Assessment | For students marked as MAP-A on their enrollment editor, MAPA reports; for all other students, MAPSPR reports. Alphanumeric, 6 characters | Data not stored |
TestMethod | Reports a value of PENPAP or ONLINE when selection the MAP Sort field on the Section Editor. Alphanumeric, 6 characters | Scheduling > Courses > Course > Section > Section Editor > Test Method Section.testMethod |
ED First Name | Reports the active primary teacher's first name as of the report end date entered on the extract editor who is administering the assessment. If no end date is selected, the most recent Primary Teacher record associated with the section reports. This field reports when the Course Assessment Subject is ELA, LEP/ELL, MATH or SC, and when the Course Section Assessment Type is MAPSPR. If the teacher's first name is blank, this field reports blank, but an overall record still reports. If the student does not have any courses where the Subject Area is ELA, LEP/ELL, MATH or SC, one record for the student reports but this field, ED Last Name field and the Examiner Email field are blank. Alphanumeric, 60 characters | Scheduling > Courses > Course > Section > Staff History > Primary Teacher Section.teacher |
ED Last Name | Reports the active primary teacher's last name as of the report end date entered on the extract editor who is administering the assessment. If no end date is selected, the most recent Primary Teacher record associated with the section reports. This field reports when the Course Assessment Subject is ELA, LEP/ELL, MATH or SC, and when the Course Section Assessment Type is MAPSPR. If the teacher's first name is blank, this field reports blank, but an overall record still reports. If the student does not have any courses where the Subject Area is ELA, LEP/ELL, MATH or SC, one record for the student reports but this field, ED Last Name field and the Examiner Email field are blank. Alphanumeric, 60 characters | Scheduling > Courses > Course > Section > Staff History > Primary Teacher Section.teacher |
Subject | Subject for which the student is assessed. See the Reporting Logic for the Subject Field above for setup options. Reports either ELA, MAP or SC based on the assigned Assessment Subject on the Course editor.
Alphanumeric, 6 characters | Scheduling > Courses > Course > Custom Data Elements > Assessment Subject Courses.assessmentSubject |
Period | Period in which the instruction took place. This only reports for EOCFAL, EOCSUM and EOCSPR assessments. Alphanumeric, 2 characters | Scheduling > Courses > Course > Section > Section Editor > Schedule Placement Period.Name |
Sort | Indicates how the labels are sorted.
Alphanumeric, 40 characters | Student Information > General > Assessment > Precode > MAP Sort Section.mapSort |
Examiner Email | Reports the active primary teacher's email address as of the report end date for who is administering the assessment. If no end date is selected, the latest Primary Teacher record associated with the section reports. If there is no Primary Teacher for the section, any teacher assigned to the section who is active on the end date in the extract editor reports. If no end date is selected, the latest teacher record associated with the section reports. This field reports blank if the student does not have any courses where the subject area is ELA, MAP or SC. Alphanumeric, 60 characters | Census > Demographics > Personal Contact Information > Email Contact.email |