i.4.see ELO Student Submission

Contents

Introduction

This report produces the Extended Learning Opportunity (ELO) Submission file for the Initiative for School Empowerment and Excellence (i.4.see).

Selection Criteria

Selection criteria determine which database records are used in the report. For the i.4.see ELO Submission, student enrollment records are selected.

School Selection

The report selects which school records to use based on the following criteria:

The school must be associated with a student included in the report.
The school must not be excluded from state reporting.

Student Selection

The report selects which student records to use based on the following criteria:

The student is not excluded from state reporting.
The student is enrolled in the district (by default) or current school the date range specified.
The student is enrolled in an ELO course during the date range specified.
The student's ELO courses are identified by flagging the Historical Grade record that has ELO credit data.

Report Input

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

Field	Description
Academic Year	Select the appropriate academic year.
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 report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
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 the report.
Start Date	Enter the first date in the date range for this report. A student must have an active enrollment record equal to or later than this date to be included in the report.
End Date	Enter the last date in the date range for this report. A student must have an active enrollment record prior to or equal to this date to be included in the report.
Include Column Headings	Choose the option to include or not include column headings in the report. Note: If running this report for the i4see Extended Learning Opportunity Student Submission, do not include the column headings.
Include Student Names	Choose the option to include or not include a column of student names in the report. The state file should not include the student names, the 'Yes' option is for verification purposes only. The default is set to ‘No’. Note: If running this report for the i4see Extended Learning Opportunity Student Submission, do not include the student names.
Scheduling – Run Now	Leave Run Now selected to run the report now.
Scheduling – Please Select When to run	Click the Schedule button to schedule this report to run nightly, and then selecttheWeekdaysonlycheckbox.

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.

Column	Data Element	Description	[Table]FieldName	Field Type	Field Length	Begin / End Position
A	SAU Number	This field contains the school administrative unit number assigned to the school submitting the report. This field is extracted from the Start Page > District Setup > District Information.	[Prefs]NH_SAUNBR	Numeric	3	N/A
B	District Number	This field contains the number of the district submitting the report. This field is extracted from the Start Page > District Setup > District Information.	[Schools]District_Number OR [Prefs]Name-districtnumber	Numeric	3	N/A
C	School Number	This field contains the number of the school submitting the report. This field is extracted from the Alternate School Number field on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School. If the Alternate School Number field is blank, this field is extracted from the School Number field on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.	[Schools]Alternate_School_Number Or [Schools]School_Number Or [S_NH_STU_X]School_Number_Override Or [S_NH_REN_X]School_Number_Override	Numeric	5	N/A
D	SASID	This field contains SASID assigned to this student by the New Hampshire Department of Education. This field is extracted from the Start Page > Student Selection > New Hampshire State Information > i.4.see Data Elements.	[Students]State_StudentNumber	Numeric	10	N/A
E	Student Name	If 'Yes' is selected in the 'Include Student Names' parameter, this column will appear with the student name in Last First Middle order. This a not a State Data Element for the report but is an option for the purpose of verification. If running this report for the i4see Extended Learning Opportunity Student Submission, this column should not be in the file.	[Students]LastFirst	Alpha-numeric	135	N/A
E or F	ELO Type	The ELO Type. Note: If ELO Type Work Based Learning - External Partner (WBLE) is selected, Community Partner must not be blank.	[S_NH_SGR_X]ELO_Description [S_NH_CC_X]ELO_Description [S_NH_SEC_X]ELO_Description [S_NH_CRS_X]ELO_Description	Alpha-numeric	4	N/A
F or G	ELO Subject Area	The ELO Subject Area. View Codes.	[S_NH_SGR_X]ELO_Subject_Area [S_NH_CC_X]ELO_Subject_Area [S_NH_SEC_X]ELO_Subject_Area [S_NH_CRS_X]ELO_Subject_Area	Alpha-numeric	8	N/A
G or H	ELO Career Cluster	The ELO Career Cluster. View Codes	[S_NH_SGR_X]ELO_Career_Cluster [S_NH_CC_X]ELO_Career_Cluster [S_NH_SEC_X]ELO_Career_Cluster [S_NH_CRS_X]ELO_Career_Cluster	Alpha-numeric	8	N/A
H or I	ELO Community Partner	The ELO Community Partner Name. Note: Community Partner must be indicated If ELO Type Work Based Learning - External Partner (WBLE) is selected.	[S_NH_SGR_X]ELO_Community_Partner [S_NH_CC_X]ELO_Community_Partner [S_NH_SEC_X]ELO_Community_Partner [S_NH_CRS_X]ELO_Community_Partner	Alpha	100	N/A
I or J	Off Campus	Must be either Y or N. If combination, use where the majority of ELO was completed.	[S_NH_SGR_X]ELO_Off_Campus [S_NH_CC_X]ELO_Off_Campus [S_NH_SEC_X]ELO_Off_Campus [S_NH_CRS_X]ELO_Off_Campus	Alpha	1	N/A
J or K	ELO Credits Earned	Indicates the student earned any amount of credit, full or partial for this ELO course. Valid options: Y - Yes, Partial or Full Credit Earned N - No Credit Earned	[S_NH_SGR_X]ELO_Credit_Data = Y	Alpha	1	N/A
K or L	Number Credits Earned	Number of ELO Credits Earned	When [S_NH_SGR_X]ELO_Credit_Data = Y Then [StoredGrades]EarnedCrHrs	Numeric	(3,2)	N/A
L or M	Credits Attempted	Number of ELO Credits Attempted.	When [S_NH_SGR_X]ELO_Credit_Data = Y Then [StoredGrades]PotentialCrHrs	Numeric	(3,2)	N/A