Attendance Summary by Grade – SI Hourly

Introduction

The Attendance Summary by Grade – SI Hourly report is an attendance Summary by Grade for the Supplemental Instruction program. This is a school level report.

The report indicates the number of students who entered, left, or were already enrolled in the Supplemental Instruction AEP program during the report date range. The report also indicates the ADA and ADA percentage per grade level as well as the number of days that students were off track, not enrolled, and awarded attendance.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The report selects student records based on the following criteria:

The student must be enrolled in a school included in the report during the report date range.
The student must be enrolled in a Supplemental Instruction Program during the report date range; the special program must be associated with one of the SI AEP codes at the district level.
The student must be enrolled in the grade level chosen when running the report.

Report Input

This report is run at the School level only.

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Attendance Mode	Choose the appropriate attendance mode from the pop-up menu. The value defaults to Interval, which is the attendance mode that must be used for Supplemental Instruction.
Grades (leave blank for all)	Select the appropriate student grade levels. For the school year 23-24 or higher, grade level mapped to LTK will be displayed.
Reporting Segment or Begin Date and Ending Date	Choose the appropriate reporting segment, or enter a report begin and end date.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Select Sub-District	If you are at the School Level, you can select only the Current School. If you are at the district level, you can choose the sub-district and select the list of schools in the sub-district. You need to set up sub-district to view the schools in the subdistrict. Select All Schools or Multiple Schools in the Sub-District.
SI Programs (leave blank for all)	Select one or more programs from the list. The page automatically lists special programs associated with the AEP program Supplemental Instruction.
Check for Possible Conflicts	Click the link to check for possible school enrollment date conflicts, such as a school enrollment entry that occurs outside of the dates defined for the school year.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Tables for a definition of each column in the table.

Note: The report determines whether the student is enrolled in the Supplemental Instruction program by referencing the AEP program associated with their special program enrollment. The Special Program must be associated with the Full Time Independent Study AEP program at the district level. The related tables and fields are:

[Gen]Cat=specprog
[Gen]ValueT2 = SI* (starts with SI)
[Gen]ID = [SpEnrollments]ProgramID
[SpEnrollments]StudentID

Report Output Format: The report output format for this report is html.

Data Element	Description	[Table]FieldName
School Name	The school name.	[Schools]Name
DD/MM/YYYY – DD/MM/YYYY	The date range of the report, selected at report runtime.	N/A
[Number of] School Days	The number of in session days within the day range, as defined in the Calendar Setup.	[Calendar_Day]InSession = 1 [Calendar_Day]Date
Group/Program	Indicates whether the table includes students enrolled in Supplemental Instruction.	[Gen]Name [Gen]Cat=specprog [Gen]ValueT2 = SI* (Starts with SI)
Grade Level	The grade level of the students included in the report row. Note: The Translated Text value from the appropriate Grade Level Mapping is used, if present. Otherwise, the numeric value from the Grade Level field is extracted in a 2-character format. EX: 1 = 01	[Students]Grade_Level
Carry Forward	The number of students who enrolled in the SI special program before the start date of the report.	[SpEnrollments]Enter_Date < Report Start Date [SpEnrollments]ProgramID
Gain	The number of students who enrolled in the SI special program during the report date range.	[SpEnrollments]Enter_Date => Report Start Date [SpEnrollments]Enter_Date <= Report End Date [SpEnrollments]ProgramID
Mult Gain	The number of students withdrew and subsequently reenrolled in the SI special program during the report date range.	[SpEnrollments]Exit_Date < Report End Date [SpEnrollments]Exit_Date > Report Start Date [SpEnrollments]Enter_Date > Report Start Date [SpEnrollments]Enter_Date <= Report End Date [SpEnrollments]ProgramID
Loss	The number of students who exited the SI special program within the report date range.	[SpEnrollments]Exit_Date >= Report Start Date [SpEnrollments]Exit_Date <= Report End Date [SpEnrollments]ProgramID
Ending	The number of students enrolled in the SI special program on the last day of the date range.	[SpEnrollments]Exit_Date > Report End Date [SpEnrollments]ProgramID
Actual Days	The count of potential interval hours for the grade level. The value is calculated based on the number of intervals per section associated with the SI special program.	[Sections]ProgramID [Sections]Att_Mode_Code = ATT_ModeInterval [Sections]Expression [CC]SectionID = [Sections]ID [CC]StudentID
Off Track	Not collected.	NA
Days N/E	The number of days that the student was not enrolled in the SI special program.	[SpEnrollments]Enter_Date [SpEnrollments]Exit_Date [SpEnrollments]ProgramID
Days Not Credited	The number of intervals that the student was enrolled in the school and the SI special program, but not awarded attendance credit. The value is calculated by totaling the number of intervals associated with an Absent attendance code.	[Attendance]Att_Date [Attendance]Attendance_Code_ID = [Attendance_Code]ID [Attendance_Code]School [Attendance_Code]YearID [Attendance_Code]Presence_Status_CD = Absent
Days Credited	The number of intervals that the student was enrolled in school and the SI special program and awarded attendance credit. The value is calculated by totaling the number intervals associated with a Present attendance code.	[Attendance]Att_Date [Attendance]Attendance_Code_ID = [Attendance_Code]ID [Attendance_Code]School [Attendance_Code]YearID [Attendance_Code]Presence_Status_CD = Present
Program Subtotal	The total for the column.	N/A
Program Total	The total for the column.	N/A
Signature and Date Line	The report displays a line to sign and date the output.	N/A