OnSIS Verification Summary - Section F
Section F - French as a Second Language
The Section F (French as a Second Language) report collects aggregate data of all students who have an active status as of the last day of the submission period of the current year and for only students who are enrolled in French as a second language (FSL) programs. This report can be run for either elementary or secondary schools also for the three submission periods (October, March, and June).
Elementary Report
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.
School Selection
Schools that have Exclude From State Reporting ([Schools]State_ExcludeFromReporting) selected are not included.
Student Selection
For the selected academic year, School BSID, Submission type, select all students from the school enrolment permanent table where:
Students where S_ON_STU_XML_SCHOOL_ENROL_C.Stu_Brd_Res_Stat_Type = '01' ( Pupil of the Board)
The report includes Active Students only: Student does not have an Enrolment End Date before or on the Count Date for the submission period. Student is active when:
Enrolment End Date = null
For June submission, Enrolment End Date = July 1st. To add flexibility, a student is considered active if the Enrolment End Date is greater than the count date.
And students who have records in S_ON_STU_XML_SECOND_LANG_C table where the [S_ON_STU_XML_SECOND_LANG_C]type is one of ('001','002','003','006', 030).
In the previous version of the report intensive Core French was counted under Core. Report is to include/count Intensive Core French program students in either Extended Program or Immersion Program depending on the number of minutes.
If the number of minutes is from 60 to 149, include/count in Extended.
If the number of minutes is from 150 to 300, include/count in Immersion.
Report Output
See Understanding the Report Output Table for a definition of each column in the table.
Field | Description | [Table]FieldName |
Report Run Date | This is the system date and time Format: YYYY/MMM/DD HH:MM | |
Page Number | Format: Page # of # | |
Header | OnSIS Summary Report Section F: French as a Second Language by Minutes | |
Board Number and Name | The name and Board School identification (BSID) number of the school board. | [Prefs]Value where [Prefs]name is districtnumber, districtname |
School Number and Name | The school's name and Board School identification (BSID) number. | [Schools]Alternate_School_Number. If undefined, [Schools]School_Number [Schools]Name where [Schools]school_number |
Academic Year | The academic year for which the report is run; the report is associated with the OnSIS Reporting Dates entered in District Setup. Format 'YYYY-YYYY'. For example, 2012-2013. | Derived from [Terms]YearId |
Submission Period Type | The submission period type selected on the report run page | Defined at report run time. Submission Period + School Type + "School" |
Core Program Total number of Students | Count number of students in Core program for the grade, where SECOND_LANGUAGE_PROGRAM.MINUTES_PER_DAY_OF_INSTRUCTION is greater than or equal to 20 and less than or equal to 59 minutes | Prints a count of students enrolled in a "Core" program. Counts the total number of students enrolled in Core French as a Second Language program. |
Core Program Number of Minutes of French Instruction per Day | Calculate the average number of minutes of French instruction per day Print (Total Number of Minutes / Total Number of Students enrolled in Core French). Where (SECOND_LANGUAGE_PROGRAM. MINUTES_PER_DAY_OF_INSTRUCTION) is greater than or equal to 20 and less than or equal to 59 Field Format: ###.## | Prints a average count of minutes for students enrolled in a "Core" program. |
Extended Program Total number of Students | Count the number of students in Extended program for the grade, where SECOND_LANGUAGE_PROGRAM.MINUTES_PER_DAY_OF_INSTRUCTION greater than or equal to 60 and less than or equal to 149 | Prints a count of students enrolled in an "Extended" program. Counts the total number of students enrolled in Extended French as a Second Language program. |
Extended Program Number of Minutes of French Instruction per Day | Calculate the average number of minutes of French instruction per day Print (Total Number of Minutes / Total Number of students enrolled in Extended French) where (SECOND_LANGUAGE_PROGRAM.MINUTES_PER_DAY_OF_INSTRUCTION) is greater than or equal to 60 and less than or equal to 149 minutes Field Format: ###.## | Prints a average count of minutes for students enrolled in an "Extended" program. |
Immersion Program Total number of Students | Count the number of students in Immersion program for the grade, where SECOND_LANGUAGE_PROGRAM.MINUTES_PER_DAY_OF_INSTRUCTION greater than or equal to 150 and less than or equal to 300 | Prints a count of students enrolled in an "Immersion" program. Counts the total number of students enrolled in Immersion French as a Second Language program |
Immersion Program Number of Minutes of French Instruction per Day | Calculate the average number of minutes of French instruction per day Print (Total Number of Minutes / Total Number of students enrolled in Immersion French) where (SECOND_LANGUAGE_PROGRAM.MINUTES_PER_DAY_OF_INSTRUCTION) greater than or equal to 150 and less than or equal to 300 Field Format: ###.## | Prints a average count of minutes for students enrolled in an "Immersion" program. |
Total | Total number of students from all grades program wise Core Program, Extended Program, Immersion Program | Calculated |
Grand Total | Total number of students from all grades enrolled in a French Second Language program. This is a row is below the Total. | Calculated |
Secondary Report
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.
School Selection
Schools with the "Exclude From State Reporting" ([Schools]State_ExcludeFromReporting) checkbox selected will not be included.
Student Selection
Report all active students enrolled in second language program
For the selected academic year, School BSID, Submission type, select all students from the school enrolment permanent table
Students where S_ON_STU_XML_SCHOOL_ENROL_C.Stu_Brd_Res_Stat_Type = '01' ( Pupil of the Board) or 06 (Independent Studies)
The report must include Active Students only: Student does not have an Enrolment End Date prior to or on the Count Date for the submission period. Student is active when:
Enrolment End Date = null
For June submission, Enrolment End Date = July 1st. To add flexibility, a student is considered active if the Enrolment End Date is greater than the count date.
and who have records in S_ON_STU_XML_SECOND_LANG_C table where the S_ON_STU_XML_SECOND_LANG_C.type is one of ('001','002','003','006').
Fully High Credit students are excluded:
Students where (S_ON_STU_XML_SCHOOL_ENROL_C.HIGH_CREDIT_FTE > 0 AND S_ON_STU_XML_SCHOOL_ENROL_C.FTE = 0) OR
Students where (S_ON_STU_XML_SCHOOL_ENROL_C.HIGH_CREDIT_ADE > 0 AND S_ON_STU_XML_SCHOOL_ENROL_C.ADE = 0)
Course Selection
Include:
ministry defined courses (MDC) (i.e., MINISTRY_DFND_CRS field) and
locally developed courses (MDC) (i.e., LOCALLY_DEV_CRE field).
Include only courses where S_ON_STU_XML_CLASS_ENROL.Credit_value is greater than zero.
Exclude:
Dual Credit Courses (DCC) . Dual credit course are courses with i.e. INSTITUTION_TYPE is Not NULL
If a student was enrolled in a course in the previous submission period, the report should not include this student's course in the total credits.
Include courses
Where the Course Start Date (STUDENT_CLASS_ENROLMENT.COURSE_START_DATE) is within the submission period Cycle Start Date and Count Date
The course has not been Withdrawn or Dropped (STUDENT_CLASS_ENROLMENT.WITHDRAWAL_TYPE_ID is null) OR It was withdrawn/dropped on the count date (STUDENT_CLASS_ENROLMENT.WITHDRAWAL_DATE/STUDENT_CLASS_ENROLMENT.COURSE_END_DATE = SUBMISSION COUNT DATE
The report searches the Student Class Enrolment table and Segment table to find the course, which begins with one of the following course codes. If one of the course codes is found, it indicates that the student is taking a French As A Second Language course.
Core Program courses will begin with FSF
Extended Program courses will begin with FEF
Immersion Program courses will begin with FIF
All other courses with a Language of Instruction which equals French.
Report Output
See Understanding the Report Output Table for a definition of each column in the table.
Field | Description | [Table]FieldName |
Report Run Date | This is the system date and time Format: YYYY/MMM/DD HH:MM | |
Page Number | Format: Page # of # | |
Header | OnSIS Summary Report Section F: French as a Second Language by Minutes | |
Board Number and Name | The name and Board School identification (BSID) number of the school board. | [Prefs]Value where [Prefs]name is districtnumber, districtname |
School Number and Name | The school's name and Board School identification (BSID) number. | [Schools]Alternate_School_Number. If undefined, [Schools]School_Number [Schools]Name where [Schools]school_number |
Academic Year | The academic year for which the report is run; the report is associated with the OnSIS Reporting Dates entered in District Setup. Format 'YYYY-YYYY'. For example, 2012-2013. | Derived from [Terms]YearId |
Submission Period Type | The submission period type selected on the report run page | Defined at report run time. Submission Period + School Type + "School" |
CORE PROGRAM | ||
Core Program Total number of Students | Based on the students age: IF the student's age as of Dec 31st of the academic year 21 or over then count the student on the 'Student 21 or over' row Else count the student based on the student grade, total number of students where S_ON_STU_XML_SECOND_LANG_C.Type = 001 (FSL Core) or 006 (ICFP) | Prints a Total number count of students enrolled in a "Core French" as a Second Language program. grade wise or Student 21 or over row |
Core Program Total number of credits of Subject of French
| Intermediate: This is the aggregate sum of the credits in a Core FSL Program for all students and place the value in the appropriate row based on the student grade Senior : This is the aggregate sum of the credits in a Core FSL Program for all students and place the value, , in the appropriate row based on the student grade.
IF the student's age as of Dec 31st of the academic year 21 or over then count credit on the 'Student 21 or over' row under the appropriate column Field Format: ##.## | Prints a average count of minutes for students enrolled in a "Core" program. |
EXTENDED or IMMERSION PROGRAM | ||
Total number of Students
| Based on the students age: IF the student's age as of Dec 31st of the academic year 21 or over then count the student on the 'Student 21 or over' row Ese based on grade, total number of student where
| Prints a Total number count of students enrolled in a Extended French as a Second Language program. Prints a Total number count of students enrolled in an "Immersion French as a Second Language program. grade wise or Student 21 or over row |
Total number of credits taught in French Subject of French
| Intermediate: This is the aggregate sum of the credits in an Extended/Immersion Program for all students and place the value in the appropriate row based on the student grade Senior : This is the aggregate sum of the credits in an Extended/Immersion Program for all students and place the value, , in the appropriate row based on the student grade.
IF the student's age as of Dec 31st of the academic year 21 or over then count credit on the 'Student 21 or over' row under the appropriate column Field Format: ##.## | |
Secondary: Total number of credits taught in French Other Subjects
| Other Subjects Intermediate: This is the aggregate sum of the credits in FSL Programs of Extended and/or Immersion, in all other subjects taught in French, for all students and place the value in the appropriate row based on the student's grade. Senior : This is the aggregate sum of the credits in FSL Programs of Extended and/or Immersion, in all other subjects taught in French, for all students and place the value in the appropriate row based on the student's grade. "Other Subjects Intermediate Credits" and "Other Subjects Senior Credits" is based on the following: Rule 1: Language_type = French Rule 2: Case A - For Classical Languages (course code begins with "LV") If the 4th character of the course code is "B" or "C" (Level 2 or 3), it would be counted as an Other Senior Course otherwise it would be counted as an Other Intermediate Course. Case B - For Native Languages (course code begins with "LN") If the 4th character of the course code is "D" or "E" (Level 4 or 5), it would be counted as an Other Senior Course otherwise it would be counted as an Other Intermediate Course. Case C - For International Language courses (course code begins with "L" but not "LV" or "LN") If the 4th character of the course code is "C" or "D" (Level 3 or 4), it would be counted as an Other Senior Course otherwise it would be counted as an Other Intermediate Course. Case D (else) - For all other courses (course code does not begin with an "L" or "FSF", "FEF" or "FIF") If the 4th character of the course code is "3" or "4" (Grade 11 or 12), it would be counted as an Other Senior Course otherwise it would be counted as an Other Intermediate Course. Field Format: ##.## | |
Total | Total number of students from all grades program wise Core Program, Extended Program, Immersion Program | Calculated |
Grand Total | Total number of students from all grades enrolled in a French Second Language program. This is a row is below the Total. Only students under 21 is included in the totals. | Calculated |
Report Row Data Detail:
Column Name | Description / Comments /Restrictions | [Table]FieldName |
Students 21 or over | Prints according to the criteria specified in the column for all students above 21 years. Grade totals are not to include Students 21 or over. These students are to be counted in this row. | Calculated |
Total | Prints total students for each column. The total reflect the students from all grades. Only students that are below 21 years. | Calculated |