Attendance Audit Report (Missouri) [.2307 and previous]

Classic View: Attendance > Reports > Attendance Audit Report

Search Terms: Attendance Audit Report

The Missouri Attendance Audit Report is used to audit the attendance data for those students who are included in the MOSIS Enrollment and Attendance Extract. It is an aggregated summary by grade level of student attendance information that has occurred within the selected time frame.

Student information is not included in the Summary Report type; however, the Student Summary and Detail Summary report types do include student names and state IDs.

Four report types are provided:

Missouri Attendance Audit Report

Report Logic

Each student with attendance data and an enrollment in the selected calendar(s) that is not flagged as state exclude or no show will report.

Average Daily Attendance (ADA) is calculated based on the student's enrollment dates, course schedule and present minutes that take place within the date range entered on the report editor. If the enrollment start and end dates are beyond the entered date range on the report editor, ADA is calculated for just the entered date range.

The Virtual Attendance calculation is part of the Present Hours value, which is then added to the Membership Hours (present hours + absent hours = membership hours). Absent hours are not included as they are not applied to virtual courses.

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

Click here to expand...

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

DetailsCalculation
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

Click here to expand...

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

DetailsCalculation
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

Click here to expand...

Virtual Course Attendance calculates the student's attendance for those courses that are taught online. The Regular Hours Attendance calculation is used; once that value is found, it is multiplied by one of the following:

  • When the student does not have a transcript entry for the online course, .47.
  • When the student has a transcript entry for the online course, .94.
  • When the student has a transcript entry of the course AND the Online Course Program is as follows, AND the A+ Student field on the Enrollment record is set to Yes, .95.
    • 50: Missouri Virtual Instructional Program,
    • 52: MOCAP, and the student's enrollment record has the A+ Student field set to Yes).

The course must be an online course (the Online field on the Course editor is set to Yes).

The course does not need to be marked for attendance; the period does not have to be marked as instructional. 

  • When the student's roster start date and end date are the same, hours are not calculated.
  • When multiple online courses are skinnied with other online courses, all minutes for online courses are summed in the skinnied period (for regular courses that are skinnied, only one course is calculated).
  • When online and regular courses are skinnied, all online course minutes/hours are calculated and one of the regular courses is summed.

The current attendance calculation is used, minus all courses and course sections marked as Online. Non-instructional minutes are not calculated.

Once the initial calculation is complete, Transcript entries are reviewed. 

  • During the selected year for a course marked as Online, when a Transcript entry exists, all hours for which the student was enrolled in that course/section are calculated. 94% of those hours are added to the first attendance calculation for the Regular Hours Attended value. 
  • When there is no transcript entry for a course marked as Online, all hours of the course/section are calculated, and 47% of those hours are added to the first attendance calculation.

Attendance minutes in a virtual course are NOT included in the calculation when the No Credit checkbox is marked on the Roster Batch Edit tool OR the student's Schedule tool for the course. Otherwise, the 95, 94, 47% attendance calculation is used.

Scenario

DetailsCalculation
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
Out of those six courses, one course is an online course.1 course period x 60 minutes = 60 online instruction minutes
60 minute periods x 5 non-online courses = 300 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, which are counted for the Regular Attendance value but not for the Online Course value.360 instructional minutes per day x 2 total days absent = 720 absent minutes

120 minutes of those 720 are for the online course, which means the student's overall absent minutes is 600.
3600 minutes - 600 absent minutes = 3000 minutes

3000 total instructional minutes - 60 online instruction minutes = 2940 instructional minutes

2940 minutes / 60 minutes per hour =  49 hours
Option 1: The student does not have a transcript entry for the course.49 hours x .47 = 23.03
rounded to the nearest whole number = 23
Option 2: The student has a transcript entry for the course.49 hours x .94 = 46.06
rounded to the nearest whole number = 46
Option 3: The student has a transcript entry of the course, and the Online Course Program for the Online Course is set to 50, and the the A+ Student field on the Enrollment record is set to Yes.49 hours x .94 = 46.55
rounded to the nearest whole number = 47

Quarantine, Distance and Blended Learning Attendance Calculation

Click here to expand...

The Quarantine, Distance and Blended Instruction attendance uses the Blended Learning Group rotation of the student to find when the student was physically on-site (in the school building) for instruction or distance learning for instruction (Note that the Blended Learning Group tools refer to distance learning as virtual learning)

See the Blended Learning tools for more information on Blended Learning available in Campus:

When the student has a combination of physically on-site and distance learning, the physically on-site attendance percentage applies to the distance learning minutes. When the physically on-site present percentage is 88%, then only 88% of the distance learning minutes can be counted/reported.

The Present Minute total cannot exceed the calendar instructional minutes for that student. When this occurs, minutes are removed from the virtual course/days to cap the Present Minute total at the calendar instructional minutes for the date range of the report.  

Summary of Calculation

  • When the Course editor or Section editor has the Online Learning field set to Yes, the Virtual Attendance calculation is used, regardless of the student being in a Blended Learning Group. 
  • When student is in distance learning, the in-seat percentage applies to the sum of the distance learning minutes. No absences are subtracted from the distance learning present minutes.
  • When student is in-seat, absent minutes are subtracted from the instructional minutes.
  • All calculations are done within date range of report generation.

Step 1. Calculate the attendance minutes for only courses using the regular (on-site) attendance and virtual attendance logic. 

Step 2. For students in a blended learning group, find when the student is on-site (in-seat) and count all present instructional minutes, minus the absent minutes. Determine the percent of time the student is present 

  • Total Instructional Minutes - Absent Minutes = Total Present Minutes
  • Total Present Minutes / Total Instructional Minutes = Percentage of Present

Step 3. Find the days when the student is in distance learning. Total the distance learning minutes. Apply the Percentage of Present to the Total Distance Learning minutes. This is the total number of hours the student is present. This value reports in the Present Hours and Regular Hours Attended fields. 

Step 4. Apply the non-present percent of minutes to the Absent Hours field on the Attendance Reports.

On-Site Instruction (OS):

On-Site Instructions uses the current attendance calculation for regular and virtual attendance.

  • A student does not need to be in a blended learning group. When Blended Learning Groups were assigned for all students in the building, regardless of being on-site or virtual, the On-Site Instruction Students would be in a Blended Learning Group where that group is not assigned to any attendance days and is considered always in school. 
  • Course sections marked as Online calculate 95%, 94% and 47% of instructional minutes based on a transcript entry (see previous information on that calculation).

On-site Instruction minutes are calculated first.

When student is not in any blended learning group, use the current MO attendance calculation for regular/on-site (OS) and online course sections (VI).

Virtual Instruction (VI)

  • Virtual Attendance is only applied when the Online Learning field on the Course editor or on the Section Editor is set to Yes. 
  • 95, 94 and 47% of instructional minutes will be calculated based on a transcript entry.

Intermittent Blended Instruction (IBI), Fixed Blended Instruction (FB),  and Instruction during Quarantine (QI)

This is a combination of On-Site and Distance Learning (DL). 

  • A student’s Blended Learning Group on distance days indicates what days the student is not on-site.
  • First, the On-Site attendance minutes are calculated to find the Present Percent. This is the percentage of minutes allowed for Distance Learning minutes/hours.  

Competency Based Attendance Calculations

Click here to expand...

Competency-based attendance calculations are specific for those courses and sections marked as Competency Based. See the Missouri Scheduling Components article for additional information on this checkbox.

The following is used to calculate competency-based attendance for reporting:

  1. Competency Based courses are identified:
    • When a course is marked as Competency Based but the sections are not, all the sections are counted as Competency Based.
    • When a course is NOT marked marked as Competency Based, all sections are checked for the Competency Based checkbox.
  2. When a student has a transcript entry for the course/section where Competency Based is marked, the sum instructional minutes of the section within the Date Range of report generation or student's enrollment dates are summed.
    • Absences, present, or tardy minutes are not counted.
    • When the student's Schedule entry associated with the Competency Based course/section has No Credit marked (Section > Roster Batch Edit), minutes are not counted.
  3. The sum of minutes is converted to hours (divided by 60) and multiplied by the Prior Year Average Attendance Percent (System Administration > Resources > District Information) to calculate present hours.
  4. The competency based section's present levels are added to the Regular Hours Attended (field 095) on the MOSIS Student Enrollment and Attendance Report. See the Regular House Attended section above for more information.
  5. The competency based section's hours are to the Present Hours on the MO Attendance Audit Report (Attendance > Reports > Missouri Attendance Audit Report).

Report Editor

The following defines the different options available on the report editor.

Field

Description

Student Selection

Students can be chosen by Grade Level or an Ad hoc Filter. All students can also be selected.


If using an ad hoc filter, only those students included in the filter will be included in the extract if they meet other reporting requirements.

Date Range

Enter a Start Date and an End Date on which to return the attendance data. A start date is not required, but generating the report this way may increase report generation time. It is advised that attendance data be reviewed on a regular basis (by week, by month, etc.).

Dates are entered in mmddyy format or can be chosen by clicking the calendar icon.

Report Type

Selection determines how the report will generate.

  • When the Summary Report Type is selected, the user also needs to determine if remedial hours are to be included in the ADA calculation. If yes, mark the Include Remedial Hours in ADA Calculation checkbox.
  • When the Student Summary Report Type is selected, the user also needs to determine if remedial hours are to be included in the ADA calculation. If yes, mark the Include Remedial Hours in ADA Calculation checkbox.
  • When the Detail Report Type is selected, the user can determine the sort order of the information - by Grade, by State ID or by Student Name.
  • When the Calendar Report Type is selected, the report will reference the selected calendar.

Include Remedial Hours in ADA Calculation

If selected, remedial hours will be included in the ADA calculation.

Format Type

The report can be generated in either PDF or CSV format.

Include State Excluded Students

If selected, students marked as state exclude will be reported. This applies to:

  • Students marked as State Exclude on their enrollment records.
  • Students enrolled in a grade level marked as state exclude
  • Students in a calendar marked as state exclude.

When the Calendar Report Type is selected, this option is not available.

Calendar Selection

At least one calendar needs to be selected in order to generate the report.

Report Generation

The report can be generated for immediate review using the Generate Report button. It can also be saved and generated at a later time using the Submit to Batch button. See the Batch Queue documentation for additional guidance.

Generate the Attendance Audit Report

  1. Select the students to include in the report by selecting either a Grade Level or an Ad hoc Filter.
  2. Enter the Date Range of the report. 
  3. Select the desired Report Type - Summary, Student Summary, Detail or Calendar.
  4. If generating the Summary Report, select the Include Remedial Hours in ADA Calculation checkbox to include that information in the average daily attendance value.
  5. If generating the Detail Report, select the desired Sort Order.
  6. Select the Format Type of the report.
  7. Mark the Include State Excluded Students checkbox to include students marked as state exclude in the report.
  8. Select the Calendars to include in the report.
  9. Click the Generate Report button to build the report immediately.
  10. Click the Submit to Batch button to build the report at a later time.

The report will display in the selected format. Sample images for each report type in PDF format and report layout information follows.

Report Layouts

Summary Report Layout

The following reports in the Header section:

  • Selected School and Calendar
  • Selected Grade Levels
  • Academic Year
  • Total number of days based on the dates entered in the Date Range fields
  • Total number of Instructional days based on the dates entered in the Date Range fields
  • Total number of students with more than 90% present attendance
  • Total number of students with less than 90% present attendance
  • Percentage of Attendance Status
  • Entered Date Range

Attendance Audit Report - Summary Type

Data Element

Description

Location

Grade

Grade levels included in the report.


Alphanumeric, 2 characters

Student Information > General > Enrollments > Grade



Enrollment.grade

Student Count

Number of students enrolled in the school by grade within the time frame specified.


Numeric, 4 digits

Calculated, value not stored

Present Hours

Number of total present hours by grade within the time frame specified.


See the Attendance Calculations section for information.


This number is an actual count of hours attended based on the student's course schedule and the summation of each scheduled day.


The total number of present hours cannot exceed the total Instructional Hours of the selected calendar.


Numeric, 9 digits

Calculated, value not stored

Absent Hours

The number of hours a student was marked absent based on the student's schedule by day.


See the Attendance Calculations section for information.


Numeric, 9 digits

Calculated, value not stored

Membership Hours

Total number of hours a student is scheduled to be in attendance by day.


The total number of membership hours cannot exceed the total Instructional Hours of the selected calendar.


Numeric, 9 digits

Calculated, value not stored

Remedial Hours

Number of total remedial hours for all students reported by grade based on the Remedial Hours field on the student's State Reporting Enrollment editor.


Numeric, 9 digits

Calculated, value not stored

Present Percent

The Present Percent calculation is based on the student's present minutes for the day divided by the student's scheduled instructional minutes for the day (membership minutes). It is not looking at the Calendar Periods Instructional minutes for the day. 


Ex: 109.998/219.996 = .50 Present percent


If a student only has two scheduled periods in a day with 6 schedule periods and the student misses one of the scheduled periods, the Present Percent could equal .50 while the ADA/ADM could equal .1451 (since it is looking at the potential minutes the student could be scheduled that day versus the student's actual membership minutes).


Numeric, 9 digits

Calculated, value not stored

ADA

Student's average daily attendance, using the calculation of Present Minutes divided by the Calendar Day's potential instructional minutes.

Calculation for R2 students =
(Present Hours) / (Membership Hours by day)

Calculation for non-R2 students =
((Attendance Hours* + Remedial Hours) / (number of students in grade level * total instructional hours in calendar)) * number of students in grade level

Remedial hours are only included in the ADA calculation if the Include Remedial checkbox is selected.


The Present Hours value in the calculation cannot exceed the total Instructional Hours of the selected calendar.


Numeric, 9 digits

Calculated, value not stored

ADM

Student's average daily membership.

Calculation =
(Present Hours) / (Instructional hours in the day)


Numeric, 9 digits

Calculated, value not stored

A Total by District record is listed at the end of the Summary Report type, listing the following fields:

  • Student Count
  • Present Hours
  • Absent Hours
  • Membership Hours
  • Remedial Hours
  • Present Percent
  • ADA
  • ADM

Summary Type District Totals

Student Summary Report Layout

The following reports in the Header section:

  • Selected School and Calendar
  • Selected Grade Levels
  • Academic Year
  • Total number of days based on the dates entered in the Date Range fields
  • Total number of Instructional days based on the dates entered in the Date Range fields
  • Entered Date Range
  • Total count of students who have greater than or equal to 90% Present Percentage
  • Total count of students who have less than 90% Present Percentage
  • Attendance Status Percentage

Students are not included in this report when the enrollment record is marked as a No Show. Students whose enrollment records start and end on the same date and have no courses on their schedule will not be counted in the Students with less than 90% Present Percent.

Attendance Audit Report - Student Summary Type

Data Element

Description

Location

Student Name

Reports the student's first and last names.


Alphanumeric, 50 characters

Census > People > Demographics > Person Information > Last Name, First Name


Identity.firstName

Identity.lastName

State IDReports the student's state-assigned ID number.

Numeric, 10 digits
Census > People > Demographics > Person Identifiers > Student State ID

Person.stateID

Present Hours

Number of total present hours by grade within the time frame specified.


See the Attendance Calculations section for information.


This number is an actual count of hours attended based on the student's course schedule and the summation of each scheduled day.


The total number of present hours cannot exceed the total Instructional Hours of the selected calendar.


If the student does not have any attendance records, this field reports blank. 


Numeric, 9 digits

Calculated, value not stored

Absent Hours

The number of hours a student was marked absent based on the student's schedule by day.


If the student does not have any attendance records, this field reports blank.


Numeric, 9 digits

Calculated, value not stored

Membership Hours

Total number of hours a student is scheduled to be in attendance by day.


The total number of membership hours cannot exceed the total Instructional Hours of the selected calendar.


If the student does not have any attendance records, this field reports blank.


Numeric, 9 digits

Calculated, value not stored

Present Percent

The Present Percent calculation is based on the student's present minutes for the day divided by the student's scheduled instructional minutes for the day (membership minutes). It is not looking at the Calendar Periods Instructional minutes for the day. 


Ex: 109.998/219.996 = .50 Present percent


If a student only has two scheduled periods in a day with 6 schedule periods and the student misses one of the scheduled periods, the Present Percent could equal .50 while the ADA/ADM could equal .1451 (since it is looking at the potential minutes the student could be scheduled that day versus the student's actual membership minutes).


If the student does not have any attendance records, this field reports blank.


Numeric, 9 digits

Calculated, value not stored

ADA

Student's average daily attendance, using the calculation of Present Minutes divided by the Calendar Day's potential instructional minutes.

Calculation for R2 students =
(Present Hours) / (Membership Hours by day)

Calculation for non-R2 students =
((Attendance Hours* + Remedial Hours) / (number of students in grade level * total instructional hours in calendar)) * number of students in grade level

Remedial hours are only included in the ADA calculation if the Include Remedial checkbox is selected.


The total number of Present Hours used in the ADA calculation cannot exceed the total Instructional Hours of the selected calendar.


If the student does not have any attendance records, this field reports blank.


Numeric, 9 digits

Calculated, value not stored

Detail Report Layout

The following reports in the Header section:

  • Student Name
  • Selected School and Calendar
  • Student's Grade Level, State ID and Enrollment Start Status
  • Academic Year
  • Total number of days based on the dates entered in the Date Range fields
  • Total number of Instructional days based on the dates entered in the Date Range fields
  • Entered Date Range
  • Calculated Present Hours and Absent Hours
  • FTE (Percent of Enrollment)
  • Regular Hours Present
  • Regular Hours Absent
  • Hours in Session

Attendance Audit Report - Detail Type

Data Element

Description

Location

Day

Reports the day of the week based on the time frame specific within the calendar year. Only the days within the date range entered on the extract editor will print.


Alphanumeric, 1 character

Calculated, value not stored

Date

Date of the week on which the day falls.


Date field, 10 characters (MM/DD/YYYY)

Calculated, value not stored

Residency Status

Reports the State Aid code assigned to the student.


Alphanumeric, 2 characters

Student Information > General > Enrollment > State Reporting Fields > State Aid


EnrollmentMO.
residencyStatus

Present Hours

The number of hours a student was scheduled to be in attendance minus the absent hours by day. This is reported in whole numbers but is calculated in minutes (then converted to hours).


See the Attendance Calculations section for information.


This number is an actual count of hours attended based on the student's course schedule and the summation of each scheduled day. If there is data in the Regular Hours Attendance field, this value reports.


Data from the Regular Hours Attended and Regular Hours Absent fields are summed into the current calculation.


The total number of present hours attended cannot exceed the total Instructional Hours of the selected calendar.


Numeric, (up to10 digits) (XXXX.XXXX)

Student Information > General > Enrollment > State Reporting Fields > Regular Hours Attendance


Enrollment.regular HoursAttendance

Absent Hours

The number of hours a student was marked absent based on the student's schedule by day. If Residency Status is NOT HS, this value must be greater than zero. If there is data in the Regular Hours Absent field, this value reports.


Data from the Regular Hours Attended and Regular Hours Absent fields are summed into the current calculation.


Numeric, 9 digits

Student Information > General > Enrollment > State Reporting Fields > Regular Hours Absent


Enrollment.regular HoursAbsent

Membership Hours

Total number of hours a student is scheduled to be in attendance by day.


When the State Aid Category is not R2: Resident II, data for Regular Hours Present and Regular hours Absent fields is summed and reported. If there is no data to calculate in the current calculation, data from the Regular Hours Attended and Regular Hours Absent fields are summed into the current calculation.


If only one of the fields has data, it is reported from that field only.


The total number of membership hours attended cannot exceed the total Instructional Hours of the selected calendar.


Numeric, 9 digits

Student Information > General > Enrollment > State Reporting Fields > Resident 2 Hours in Session


Enrollment.Res2Hours inSession

Present Percent

The Present Percent calculation is based on the student's present minutes for the day divided by the student's scheduled instructional minutes for the day (membership minutes). It is not looking at the Calendar Periods Instructional minutes for the day. 


Ex: 109.998/219.996 = .50 Present percent


If a student only has two scheduled periods in a day with 6 schedule periods and the student misses one of the scheduled periods, the Present Percent could equal .50 while the ADA/ADM could equal .1451 (since it is looking at the potential minutes the student could be scheduled that day versus the student's actual membership minutes).


Numeric, 9 digits

Calculated, value not stored

ADA

Student's average daily attendance, using the calculation of Present Minutes divided by the Calendar Day's potential instructional minutes.

Calculation for R2 students =
(Present Hours) / (Membership Hours by day)

Calculation for non-R2 students =
(Present Hours) / (Instructional Hours in the day)

The total number of  present hours used in the calculation cannot exceed the total Instructional Hours of the selected calendar.


Numeric, 9 digits

Calculated, value not stored

ADM

Student's average daily membership.

Calculation =
(Present Hours) / (Instructional hours in the day)


Numeric, 9 digits

Calculated, value not stored.

Calendar Report Layout

The following reports in the Header section:

  • Selected School and Calendar
  • Total number of Instructional days based on the dates entered in the Date Range fields
  • Entered Date Range

Attendance Audit Report - Calendar Type

Data Element

Description

Location

Day

One record for each day marked as both instructional and attendance for the selected calendar, sorted by date.


Alphanumeric, 1 character

Not stored

Date

Date of the day of the week based on the time frame specified within the calendar year. Only the dates within the date range entered on the extract editor will report.


Date field, 10 characters (MM/DD/YYYY)

Not stored

Instructional Minutes

Total instructional time (not including lunch time or non-instructional time) for the day being reported in minutes.


Numeric, 4 digits

Calculated, value not stored

Instructional Hours

Instructional minute value converted to hours and rounded to the nearest ten thousandth.


Numeric, 7 digits

Calculated, value not stored

Period Schedule

Lists the period schedule associated with the calendar.


Alphanumeric, 10 characters

System Administration > Calendar > Calendar > Days  > Day Detail - Period Schedule


Calendar.periods