School Calendar Instructional Time Verification Report
Introduction
The School Calendar Instructional Time Verification Report allows schools and districts to verify the Instructional Time in the School Calendar to help ensure that the schools are in compliance with state requirements for instructional hours. The report can be run from an individual school, or from the district for all or selected schools. The report output is a .zip file containing a formatted PDF report that includes sub-totals of instructional minutes and hours by term and a grand total for the year, along with a CSV file where each calendar date is reported as a separate row. Sub-totals and grand total are not included in the CSV file.
Report Input
For help with navigation and running the report, seeHow to Find and Generate a Report.
Field | Description |
---|---|
Select Schools | If run at the district level, choose one of the following:
If run at the school level, the currently selected school is the only option. |
School Year | Choose the school year. This value will also appear in the output file name. |
Summarize By | Choose how to group each school's data. If run from the District:
If run from a School:
|
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Element # | Data Element | Description | [Table]FieldName |
---|---|---|---|
1 | School Number | The school number and school name reported in this section. | [Calendar_Day]SchoolID [Schools]School_Number |
2 | School | The School Name. | [Schools]Name |
3 | Term | The name of the term containing the range of calendar dates. | [Terms]Name |
4 | Date | The date in the calendar in YYYY-MM-DD format. | [Calendar_Day]Date_Value |
5 | Day | The day of the week the calendar day falls on. | [Calendar_Day]Date_Value |
6 | Cycle Day | The cycle day associated to the calendar day. | [Calendar_Day]Cycle_Day_ID |
7 | Bell Schedule | The bell cycle associated to the calendar day. | [Calendar_Day]Bell_Schedule_ID |
8 | Type | The type of day; such as "In-Session" or "Holiday". | If the value for [Calendar_Day]Type is not blank, the description of the day type is displayed. If the value for [Calendar_Day]Type is blank, and [Calendar_Day]InSession = 1, "In Session" is displayed. Non-In Session days with a blank day type are suppressed. |
9 | School Min | The total number of minutes for the school on this date. | [S_ND_CLD_X]Schl_Instr_Minutes_Ovr [S_ND_SCH_SCHOOLS_X]Schl_ Instr_Minutes_Default |
10 | Track A Min | The number of minutes for Track A on this date. | [S_ND_CLD_C]Track_Instr_Minutes_Ovr where Track = A [S_ND_SCH_SCHOOLS_C]Track_Instr_Minutes_Default where Track = A |
11 | Track B Min | The number of minutes for Track B on this date. | [S_ND_CLD_C]Track_Instr_Minutes_Ovr where Track = B [S_ND_SCH_SCHOOLS_C]Track_Instr_Minutes_Default where Track = B |
12 | Track C Min | The number of minutes for Track C on this date. | [S_ND_CLD_C]Track_Instr_Minutes_Ovr where Track = C [S_ND_SCH_SCHOOLS_C]Track_Instr_Minutes_Default where Track = C |
13 | Track D Min | The number of minutes for Track D on this date. | [S_ND_CLD_C]Track_Instr_Minutes_Ovr where Track = D [S_ND_SCH_SCHOOLS_C]Track_Instr_Minutes_Default where Track = D |
14 | Track E Min | The number of minutes for Track E on this date. | [S_ND_CLD_C]Track_Instr_Minutes_Ovr where Track = E [S_ND_SCH_SCHOOLS_C]Track_Instr_Minutes_Default where Track = E |
15 | Track F Min | The number of minutes for Track F on this date. | [S_ND_CLD_C]Track_Instr_Minutes_Ovr where Track = F [S_ND_SCH_SCHOOLS_C]Track_Instr_Minutes_Default where Track = F |
16 | Total Instructional Minutes | The total number of Instructional Minutes for the school and term, along with totals for each track. | Calculated. |
17 | Total Instructional Hours | The total number of Instructional Hours for the school and term, along with totals for each track. | Calculated. |
18 | Grand Total Instructional Minutes | The grand total number of Instructional Minutes for the school and year along with totals for each track. | Calculated. |
19 | Grand Total Instructional Hours | The grand total number of Instructional Hours for the school and year along with totals for each track. | Calculated. |