EOC EXP Assessment (Missouri) [.2223 and previous]

Classic View: MO State Reporting > MOSIS Extracts > Pre-Code File > Extract Type: EOCEXP: EOC Exception Assessment

Search Terms: MOSIS Extracts

The EOC EXP Assessment reports reasons for why a student is not required to take an end-of-course exam. The End-of Course Exception Assessment is submitted in March.

MOSIS Precode - EOC EXP Assessment Extract 

Report Logic

The following logic applies to the EOC EXP Assessment:

  • Only 12th grade students who have an active enrollment record on the effective date entered in the extract editor are included in the report.
  • There may be between zero and four records per student, with 1 record per student for each of the four required EOC assessment subjects for which an exception result is returned.
  • Information from the student's Assessment tab is used in this extract.

The following Result Codes must be added to the the Assessment Test Result Statuses and the EOC Assessment and the MAP Assessment must be marked with one of the EOCEXP codes at the student level to be included in the report.

Exception Code

Description

EOCEX2

Received content out-of-states; private/parochial/home school

EOCEX3

MAP-A received credit in other district or content n/a

EOCEX4

Student took content in another public Missouri district but was not assessed

One record per assessment with an exception is returned when:

  • Assessment State Code = EOC and the student's Test Score Result = EOCEX2, EOCEX3 or EOCEX4.
    • All EOC exception results are returned with any date for students in the reporting population.

OR

One record per student is returned for each of the four required EOC assessments where:

  • Special Education Enrollment Field Map A is marked with the Extract field EOCEX3.
  • EOC Assessment Subject Codes include ENGL12, ALGEB1, BIOLO1, AMGOV1 (created in the Assessment Tests editor).
  • Four records per student are returned where MAP-A is selected, one for each of the above state codes in the subject field.
  • Each of the four records return with the Assessment field value = EOCEX3.

EOC Exception “download” report is made available to districts and allows districts to download students reported as 12th grade and enrolled in the district on the last Wednesday in January that do not have an EOC assessment record, pre-formatted for the EOC Exception file layout.

District are required to modify this EOC Exception “download” report before submitting it back to the DOE.

  • Students may need to be removed (took assessment during spring administration).
  • Students may need to be added (not enrolled at time the report generated). AND
  • The exception reason (EOCEXP1, EOCEXP2, EOCEXP3, EOCEX4) needs to be added in the assessment field for each student left in the file.

Report Editor

Field

Description

Extract Type

Indicates the type of MOSIS Extract being generated. Choose Pre-code File.

Report Protected IdentitiesWhen 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 EOCEXP: EOC Exception.

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 EOC EXP: EOC Exception Pre-Code Extract

  1. Select the Pre-code File option from the Extract Type dropdown list.
  2. Mark the Report Protected Identities checkbox, if desired.
  3. Mark the Report State Excluded Students checkbox, if desired.
  4. Enter the Date Range in mmddyy format or by clicking the calendar icon and selecting a date, if applicable.
  5. Select an Ad hoc Filter, if applicable.
  6. Select the Assessment Type as EOCEXP: EOC Exception from the dropdown list.
  7. 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.
  8. Select which Calendar(s) to include report within the extract. Selecting multiple calendars may impact extract generation times and overall Campus performance.
  9. 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 the EOC EXP Assessment

Element Name

Description

Location

Collection Version
Required

Indicates the assessment type selected on the extract editor.

Collection version contains the value YYYYXXXXXX1.0AsmPre where:

  • YYYY = the reporting school year (2010, 2011, etc.)
  • XXXXXX = the assessment type selected

Alphanumeric, 50 characters

MO State Reporting > MOSIS Extracts

Current School Year
Required

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
Required

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.

  • If not populated, the Calendar Type is used to determine the reported value. If the Calendar Type Code is AP: Alternative Program School, all students enrolled in that calendar report the value entered in the Residing School field on the State Reporting Enrollment editor.
  • If the Reporting School field is not populated and the Calendar Type is not AP, the School Organization Type is used. When the School Organization Type Code is AP: Alternative Program School, all students enrolled in that school report the value entered in the Residing School field on the State Reporting Enrollment editor. 
  • If the Reporting School field is not populated and the Calendar Type is not AP and the School Organization Type is not AP, the Reporting School reports from the State School Number.

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
Required

State-assigned student identifier.


Numeric, 10 digits

Census > People > Demographics > Person Identifiers > State ID


Person.stateID

Local Student ID
Optional

School-assigned student identifier.


Numeric 20 digits

Census > People > Demographics > Person Identifiers > Student Number


Person.studentNumber

Last Name
Required

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
Required

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
Optional

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
Optional

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
Required

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
Required

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
Required

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
Required

The student's defined race/ethnicity.


Alphanumeric, 2 characters

Census > People > Demographics > Person Information > Race/Ethnicity


Identity.raceEthnicity

Assessment
Required

Reports the EOC Exception Reason for the student.


Alphanumeric, 6 characters

Student Information > General > Assessments > Test Score Detail > Result


TestScore.result

TestMethod 

This field does not report.

 N/A

ED First Name 

This field does not report.

 N/A

ED Last Name 

This field does not report.

 N/A

Subject
Required

Subject for which the student will be assessed. See the Reporting Logic for the Subject Field for setup options.


Alphanumeric, 6 characters

Scheduling > Courses > Course > Section


Courses.assessmentSubject

Period 

This field does not report.

 N/A

Sort 

This field does not report.

 N/A

Examiner Email 

This field does not report.

 N/A