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:

Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.
All Schools – Run the report for the entire district.

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:

Year
Smallest Terms Defined Each School (Semester, Trimester, Quarter, etc.)

If run from a School:

Year
Selected Term

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.