Learning Model and Enrollment Data Collection (Weekly)

Contents

Report Description

The Learning Model and Enrollment Data Collection (weekly) was developed by the Connecticut State Department of Education (CSDE) in 2020 to collect the information on the learning model for each grade in a district and information on the number of students enrolled, fully remote and disconnected while fully remote for that district.

This report can be run at the district level.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] or [ReEnrollments] table based on the following criteria:

The student must not be excluded from state reporting.
The student must have a school enrollment record that starts before the report ADA/ADM End Date and ends after the report ADA/ADM Start Date.

The end date of the school enrollment must be greater than the start date.
The start date of the enrollment must be less than or equal to the Enrollment Snapshot Date and the end date of the enrollment must be equal to or greater than the Enrollment Snapshot Date

Report Input

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

Field	Description
Select Students	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
ADA/ADM Start Date	Enter the date you want the report to use as the start date for calculating attendance and membership data for each student.
ADA/ADM End Date	Enter the date you want the report to use as the end date for calculating attendance and membership data for each student.
Display Headers?	Choose Yes or No from the drop-down menu to determine whether to display header fields in the extract. Headers display the name of each data element for each record extracted. Use headers for troubleshooting purposes.

Report Output

Each of the fields displayed in the output of the report is described below. For more information about the report output from the state Department of Education, see http://www.csde.state.ct.us/public/psis/downloads.asp

See Understanding the Report Output Table for a definition of each column in the table.

Note: For fields that are historically tracked, there may be multiple stored values. If so, the output reports the value from the most recent Effective Date that occurs on or before the Enrollment Snapshot Date.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Grade Level	Each grade level for a District	[S_InstructionModeByGrades_S]GradeLevel	Number	3
2	Learning Model	The learning model by grades as updated at District Setup > Connecticut State Information: Learning Model by Grade Setup	[S_InstructionModeByGrades_S]InstructionMode	Char	11
3	End of Record Marker	Denotes the end of a record.	Always “X”	Alpha-numeric	1
4	Number of Students Enrolled	Total active students enrolled who are not excluded from state reporting	[Students]Enroll_Status = 0 [Students]State_ExcludeFromReporting != 1	Numeric	Variable
5	Number of Remote Students	The number of students who were fully remote The student with In-person membership equal to 0 and Remote membership greater than 0 for the selected dates	Calculated based on [PS_ADAADM_Defaults_All]Potential_AttendanceValue = 1 [CODE_Entity]CE_Code = ‘Remote’ In-person membership = 0 and Remote membership > 0 [PS_ADAADM_Defaults_All]CalendarDate based on the dates entered in the report parameters for: ADA/ADM Start Date ADA/ADM End Date	Numeric	Variable
6	Number of Discontinued remote students	The number of fully remote students who were disconnected The students with In-person membership equal to 0, Remote membership greater than 0, and remote attendance equal to 0 for the selected dates	Calculated based on [PS_ADAADM_Defaults_All]Potential_AttendanceValue = 1 [CODE_Entity]CE_Code = ‘Remote’ In-person membership = 0 and Remote membership > 0 [PS_ADAADM_Defaults_All]AttendanceValue = 0 [PS_ADAADM_Defaults_All]CalendarDate based on the dates entered in the report parameters for: ADA/ADM Start Date ADA/ADM End Date	Numeric	Variable
7	End of Record Marker	Denotes the end of a record.	Always “X”	Alpha-numeric	1