Tool Search: MOSIS Extracts
The Student Enrollment and Attendance extract is generated two times during the school year, once in June for the main school year data and once in August for the summer school year data. A single record is reported for each enrollment in the selected calendar(s) when the student begins enrollment at a school, ends enrollment at a school, changes a grade level or changes residency status.
Student Enrollment and Attendance Extract Editor
Read - Generate MOSIS Student Enrollment and Attendance.
Write - N/A
Add - N/A
Delete - N/A
For more information about Tool Rights and how they function, see the Tool Rights article.
Report Logic
Attendance calculation for this extract is as follows:
- All instructional minutes for which a student was marked absent during a report period are summed.
- All instructional minutes for which a student was marked present during a report period are summed.
- The minutes total is converted into total hours absent/present and rounded to the nearest ten-thousandth.
For the June cycle:
- A single record reports for each enrollment in the calendar(s) selected in the extract editor, which is intended to report each time a student enters school, exits a school, changes grade, or changes residency status.
- Enrollments marked as No Show report.
For the August cycle (summer school):
- A single record is reported for each student attending summer school.
- Enrollments are only reported when the calendar is marked as a Summer School calendar.
Combine Enrollment Hours Logic:
- Calendars must be selected for reporting.
- The P: Primary enrollment as of the reporting date reports. When no active enrollment, the most recent enrollment as of the report generation date reports.
- When there is no P: Primary enrollment is active, then the S: Partial enrollment reports. When there is no S: Partial enrollment, N: Special Ed Services enrollment reports.
- When multiple enrollments exist in the same school where the enrollment dates are within the primary enrollment date:
- when each enrollment is P: Primary, a separate record reports for each.
- when a S: Partial or N: Special Ed Services enrollment falls within the primary enrollment dates, a record is NOT reported for each. The student's present and absent hours for the S: Partial and/or N: Special Ed enrollment are added to the P: Primary enrollment's reporting record.
- When multiple enrollments exist in different schools where the enrollment dates are within the P: Primary enrollment dates:
- when each enrollment is P: Primary, a separate record reports for each.
- when a S: Partial or N: Special Ed Services enrollment falls within the primary enrollment dates, a record is NOT reported for each. The student's present and absent hours for the S: Partial and/or N: Special Ed enrollment are added to the P: Primary enrollment's reporting record.
- when only one school is selected during report generation, all data associated with the enrollment reports.
- When multiple enrollments exist in the same school where the enrollment dates are NOT within the P: Primary enrollment dates:
- when each enrollment is P: Primary, a separate record reports for each.
- when a S: Partial and/or N: Special Ed Services enrollment date does NOT fall within the primary enrollment date, a separate record reports for the S: Partial and/or N: Special Ed Services enrollment for the dates that are not within the primary enrollment record's dates.
- The Start Date reports as the enrollment Start Date when it is NOT within the P: Primary enrollment dates.
- The Start Date reports as the day after the P: Primary enrollment's End Date when the enrollment's Start Date is within the P: Primary enrollments dates but its End Date is after the P: Primary enrollment's End Date.
- The End Date reports as the enrollment End Date when it is NOT within the P: Primary enrollment's dates.
- The End Date reports as the P: Primary enrollments Start Date it it is within the P: Primary enrollment dates.
- the students present and absent hours will sum for dates NOT within the P: Primary enrollment dates.
- the student's present and absent hours for dates within a P: Primary enrollment will be added into the P: Primary enrollment record.
- When multiple enrollments exist in different schools where the enrollments dates are NOT within the P: Primary enrollments dates:
- when each enrollment is P: Primary, a separate record reports for each.
- when a S: Partial and/or N: Special Ed Services enrollment date does NOT fall within the primary enrollment date, a separate record reports for the S: Partial and/or N: Special Ed Services enrollment for the dates that are not within the primary enrollment record's dates, when each school of enrollment is selected during report generation.
- The Start Date reports as the enrollment Start Date when it is NOT within the P: Primary enrollment dates.
- The Start Date reports as the day after the P: Primary enrollment's End Date when the enrollment's Start Date is within the P: Primary enrollments dates but its End Date is after the P: Primary enrollment's End Date.
- The End Date reports as the enrollment End Date when it is NOT within the P: Primary enrollment's dates.
- The End Date reports as the P: Primary enrollments Start Date when it is within the P: Primary enrollment dates.
- the students present and absent hours will sum for dates NOT within the P: Primary enrollment dates.
- the student's present and absent hours for dates within a P: Primary enrollment will be added into the P: Primary enrollment record.
Attendance Calculations
For attendance reporting used in MOSIS Extracts, the following calculations are used to determine a student's total hours attended for a selected calendar.
Different calculations are used when the student is scheduled into a virtual course. Additional calculations are used when a school or district adjusts learning options for students because of quarantine restrictions, Blended Learning accommodations and Distance Learning structures.
Regular Hours Attended and Regular Hours Absent are reported on the MOSIS Student Enrollment and Attendance Extract and the Attendance Audit Report.
The value reported in the Present hours, Regular Hours Absent and Remedial Hours Attended fields on the Attendance Audit Report should match the values returned on the Student Enrollment and Attendance Extract:
- The Present Hours value on the Attendance Audit Summary must equal the sum of the Regular Hours Attended value and the Remedial Hours Attended value on the MOSIS Student Enrollment and Attendance report.
- The Absent Hours value on the Attendance Audit must equal the Regular Hours Absent value on the MOSIS Student Enrollment and Attendance > Regular Hours Absent.
- The Membership Hours value must equal Present and Absent hours on the Attendance Audit report.
- The Membership Hours value on the Attendance Audit Report must equal Regular Hours Attended, Regular Hours Absent and the Remedial Hours Attended values on the MOSIS Student Enrollment and Attendance report.
The State Reporting Enrollment editor contains a Regular Hours Attended field and a Regular Hours Absent field, which indicates the number of hours the student has spent in attendance or being absent in the district. The value entered into these fields reports ONLY when there is no actual attendance or absent hours to calculate for the student.
Enrollment Fields for Regular Hours Attended, Regular Hours Absent
Regular Hours Attended
This value uses a calculation of the sum of Instructional Minutes for each course into which the student is enrolled minus the absent minutes recorded for the student within the Date Range of the report. The student's entire schedule is used and each scheduled day's instructional minutes are included, and reports as a whole number.
- The Calendar Period must be marked as Instructional (System Administration > Calendar > Calendar > Period).
- The Course must be marked to record attendance (Scheduling > Courses > Course > Attendance).
- Absences can have an excuse of Excused, Unknown or Unexcused.
The Regular Hours Attended value cannot exceed the Duration value on the Calendar Day editor. When the Duration field is blank or set to zero, the Student Day (instructional minutes) value on the Calendar Details editor are used. Regular hours attended must equal calendar minutes when they exceed calendar instructional minutes for the entire calculation.
Day Duration Value
Student Day Value
The roster date (student's start date in the course section) is compared to the term date, using the maximum start date between the term and the roster start date, whichever is the latest date. The minimum end date of the term date and the roster date is used, whichever comes first.
Additional Information:
- When the end date and start date of the enrollment are both on the first day of the school year, a value of zero reports.
- A value greater than zero reports when the grade level of enrollment is something other than PK.
- The periods into which the student is scheduled for the day is the cap of instructional minutes for the day.
Scenario
| Details | Calculation |
|---|---|
| A student is scheduled into 6 courses, each meeting for 60 minutes and each in Instructional period. | 60 minute periods x 6 course = 360 instructional minutes per day |
| The report is generated from November 1 to November 13, a total of 10 school days. | 360 instructional minutes x 10 school days = 3600 total instructional minutes |
| The student has two excused full absent days during that time. | 360 instructional minutes per day x 2 total days absent = 720 absent minutes |
| 3600 minutes - 720 absent minutes = 2880 minutes 2880 minutes / 60 minutes per hour = 48 hours The student's Regular Hours Attended is 48 hours for 10 days. |
Regular Hours Absent
This value is the total number of hours a student has been marked absent based on the student's schedule by day. It uses a calculation of the sum of Instructional Minutes for each course into which the student is enrolled minus the absent minutes recorded for the student within the Date Range of the report.
- The Calendar Period must be marked as Instructional (System Administration > Calendar > Calendar > Period).
- The Course must be marked to record attendance (Scheduling > Courses > Course > Attendance).
- Absences can have an excuse of Excused, Unknown or Unexcused.
- Regular Hours Absent does NOT calculate absent hours for virtual classes. An absent calculation is not done for online courses, even when there is an absence for the period.
- The periods into which the student is scheduled for the day is the cap of instructional minutes for the day.
The Regular Hours Absent value cannot exceed the Duration value on the Calendar Day editor. When the Duration field is blank or set to zero, the Student Day (instructional minutes) value on the Calendar Details editor are used. Regular hours absent must equal calendar minutes when they exceed calendar instructional minutes for the entire calculation.
Day Duration Value
Student Day Value
Scenario
| Details | Calculation |
|---|---|
| A student is scheduled into 6 courses, each meeting for 60 minutes and each in Instructional period. | 60 minute periods x 6 course = 360 instructional minutes per day |
| The student has two excused full absent days during the date range of the report. | 360 instructional minutes per day x 2 total days absent = 720 absent minutes |
| 720 absent minutes / 60 minutes per hour = 12 absent hours The student's Regular Hours Absent is 12 hours for 10 days. |
Virtual Course Attendance Calculation
Quarantine, Distance and Blended Learning Attendance Calculation
Competency Based Attendance Calculations
Report Editor
Different options are available for entry on the Extract editor depending on the chosen Reporting Period. The following defines the available Extract Options, noting the different fields.
Extract Option | Description |
|---|---|
Extract Type | Determines the extract that generates. Selection should be Student Enrollment and Attendance. Click this Student Enrollment and Attendance PDF link for the full report layout. |
Reporting Period | Indicates the section of the school year for which student data is being reported. Each selection contains the same layout, but certain fields may be required in certain extracts, and optional in others. |
| Report Protected Identities | When selected, optional fields are included in the extract. These optional fields may be blank depending on the available student data. |
| Report State Excluded Students | 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. |
| Combine Enrollments | When marked, the report combines the Regular Hours Attended and Regular Hours Absent for the student when the student has multiple enrollments that are primary and/or secondary in calendars selected for reporting. This only displays with the Report Period = June. |
Optional Fields Allowed | When selected, optional fields are included in the extract. These optional fields may be blank depending on the available student data. |
Date Range | Entered dates are used to return students enrolled during that time frame. Enter dates in mmddyy format or use the calendar icon to choose a date. |
Ad hoc Filter | Selection includes only those students included in the filter. |
Format | Determines how the extract generates. Use the State Format (CSV) when submitting the final data to MOSIS. Use the other available formats (HTML, Tab Delimited, XML) for data review and testing. |
Calendar | Selected calendar indicates which students are included in the report. Multiple calendars can be selected at one time; it is recommended that all calendars in a district not be selected as this increases the amount of time it takes to generate the extract. The calendar chosen in the Campus toolbar is already selected. |
Generate Extract | Displays the selected calendar information and extract immediately for data review and printing purposes in one of the selected formats. |
Submit to Batch | Delays the generation of the extract for data review and printing purposes for a designated time. See the Batch Queue documentation for more information. |
Generate the Student Enrollment and Attendance Extract
- Select the Student Enrollment and Attendance report.
- Select the Reporting Period.
- Mark the Report Protected Identities checkbox, if desired.
- Mark the Report State Excluded Students checkbox, if desired.
- Mark the Combine Enrollment checkbox, if desired.
- Mark the Optional Fields Allowed checkbox, when applicable.
- Enter the Date Range for the selected reporting period.
- Select any applicable Ad hoc Filters.
- Select the Format of the extract.
- Select which Calendar(s) to include within the extract.
- Click the Generate Extract button or the Submit to Batch button.
August Student Enrollment and Attendance - State Format (CSV)
Previous Versions
MOSIS Student Enrollment and Attendance (Missouri) [.2223 - .2307]
