1 Report header
Optional. These two lines are not in the DESE workbook; they print at the top of the sheet so it can go in the audit file.
2 Standard Day Length Calculation Tool
One row per building or grade span. Standard Day Length is the time from the start of the school day to its end, less lunch and less any extra passing time at lunch that cannot be counted. The hours figure in the last column is the value keyed on MOSIS Core Data Screen 10.
| # | Building or Grade Levels | *Start Time | *End Time | Difference in Time | Converted to Minutes | Lunch Time | **Extra Passing Time at Lunch Which Can Not be Included in the Standard Day Length | Standard Day Length in Minutes | Standard Day Length for Screen 10 | |
|---|---|---|---|---|---|---|---|---|---|---|
* Pick each time with the clock field, or type it with a space before AM or PM (for example 7:55 AM). The Start and End Time must be on the same day, so check AM and PM.
**Some grade levels may have the passing time included in the lunch time. Leave as zero if that is the case.
Lunch Time and Extra Passing Time are lengths in minutes, not clock times. A row stays blank until both times are entered.
3 Screen 10 summary
The calculated rows in one place, for the audit file. Key the last column on Core Data Screen 10.
Where this method comes from
Source: the Missouri Department of Elementary and Secondary Education (DESE), School Finance, "Standard Day Length Calculation Tool" Excel workbook, last modified June 1, 2017, from the School Finance calculation tools page.
Method, as the workbook computes it for each row: Difference in Time is End Time minus Start Time; Converted to Minutes is that difference in whole minutes; Standard Day Length in Minutes is Converted to Minutes minus Lunch Time minus Extra Passing Time; Standard Day Length for Screen 10 is that figure divided by 60 and rounded to 4 decimal places (halves round away from zero).
The hours figure is the value a district reports on MOSIS Core Data Screen 10 (the school calendar and hours screen). The workbook does not cite a statute or regulation for the method. This is an independent rebuild of the workbook's arithmetic, not a DESE product.