OnSIS Verification Details - Section F
Section F - French as a Second Language
The Section F (French as a Second Language) report displays the detailed information for verification of French as a Second Language - Elementary and Private, by minutes and Secondary school for three submission periods ( October, March, and June). It lists individual student information for students included in the OnSIS Verification Details - Section F report.
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 the Exclude From State Reporting ([Schools]State_ExcludeFromReporting) selected are not included.
Student Selection
The report should list the details of the students counted in the Summary Report for the selected academic year, School (BSID), and Submission period
- The report groups students by program type, and grade. Order by Program type, grade, and Student Name/OEN based on the Sort order input parameter selection.
Report Output
See OnSIS Verification Details - Section F for a definition of each column in the table.
| Field | Description | [Table]FieldName |
| Report Run Date | The system date and time displayed at the upper-left of the report Format: YYYY/MMM/DD HH: MM | |
| Page Number | The page number is displayed in the upper-right of the report. Format: Page # of # | |
| Header | ||
| Mid Page Header | OnSIS Detail 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 OnSIS Verification Details - Section F. 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. |
| Students are grouped by program type, grade. Order by Program type, grade, and Student Name/OEN based on the sort order selected. | ||
| OEN | The student's OEN. | [S_ON_STU_XML_School_Enrol_C]OEN |
| Student name | The Student's name. The last name followed by the first name. | [S_ON_STU_X]Legal_Last_Name or [Students]Last_Name [S_ON_STU_X]Legal_First_Name or [Students]First_Name |
Number of Minutes | Minutes per day of instruction | S_ON_STU_XML_SECOND_LANG_C.Type.Minutes_Per_Day_Of_Instr |
| Sub-Total for Grade | Total by Second Language Program Type and Grade Type. Total xxxxxxxx for grade xx where xxxxxxxx is the Second Language Program Type and xx is Grade Type. The report totals only display for programs that have data. | Calculated |
| Total for all students | Total students per program type Total xxxxxxxx, where xxxxxxxx is the Second Language Program Type. | Calculated |
| Grand Total | Grand total of Students per program. Total for xxxxxxxxxx - Core: ###### Extended: ###### - Immersion: ######, where xxxxxxxx is the School Number and Name. | Calculated |
Programs or grade levels are not printed if there no students listed. For example, if there are no students counted under the Core program then Core is not listed.
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 that have Exclude From State Reporting ([Schools]State_ExcludeFromReporting) selected are not included.
Student Selection
The report should list the details of the students counted in the Summary Report for the selected academic year, School (BSID), and Submission period
- The report groups students by Secondary: Grade, program type. Order by Grade, Program type, and Student Name/OEN based on the Sort order input parameter selection.
Report Output
See Understanding the Report Output Table for a definition of each column in the table.
| Field | Description | [Table]FieldName |
| Report Run Date | The system date and time displayed at the upper-left of the report Format: YYYY/MMM/DD HH:MM | |
| Page Number | The page number is displayed in the upper-right of the report. Format: Page # of # | |
| Header | ||
| Mid Page Header | OnSIS Detail 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. |
| OEN | The student's OEN. | [S_ON_STU_XML_School_Enrol_C]OEN |
| Student name | The Student's name. The last name followed by the first name. | [S_ON_STU_X]Legal_Last_Name or [Students]Last_Name [S_ON_STU_X]Legal_First_Name or [Students]First_Name |
Core Intr. Credits | CREDIT_VALUE Based on the grade, program, ministry_defined_course/Locally_defined_course, where [S_ON_STU_XML_SECOND_LANG_C]Type = 001 (FSL Core) | Prints "Intermediate" (Grade 9, 10) credits where: Course Codes begin with FS and 4th character is 1 or 2 under the Student's corresponding Second Language Type group. |
| Core Senior Credits | CREDIT_VALUE Based on the grade, program, ministry_defined_course/Locally_defined_course, where [S_ON_STU_XML_SECOND_LANG_C]Type = 001 (FSL Core) Field Format: ##.## | Prints "Senior" (Grade 11, 12) credits where: Course Codes begin with FSF and the 4th character is 3, 4 under the Student's corresponding Second Language Type group. |
| French Intr. Credits | CREDIT_VALUE Based on the grade, program, ministry_defined_course/Locally_defined_course, where [S_ON_STU_XML_SECOND_LANG_C]Type = 002 (FEF) or 003 (FIF) Field Format: ##.## | Prints "Intermediate" (Grade 9, 10) credits where: Course Codes begin with FEF or FIF and 4th character is 1 or 2 under the Student's corresponding Second Language Type group. |
| French Senior Credits | CREDIT_VALUE Based on the grade, program, ministry_defined_course/Locally_defined_course, where [S_ON_STU_XML_SECOND_LANG_C]Type = 002 (FEF) or 003 (FIF) Field Format: ##.## | Prints "Senior" (Grade 11, 12) credits where: Course Codes begin with FEF or FIF and the 4th character is 3, 4 under the Student's corresponding Second Language Type group. |
| Other Intr. Credits | CREDIT_VALUE Based on the grade, program, ministry_defined_course/Locally_defined_course. LanguageType = F Field Format: ##.## | Prints "Intermediate" (Grade 9 and 10) credits where: (Course) Language of Instruction= French And Course Codes = refer to Summary report notes - "Other Subjects Intermediate Credits" and "Other Subjects Senior Credits". under the Student's corresponding Second Language Type group. |
| Other Senior Credits | CREDIT_VALUE Based on the grade, program, ministry_defined_course/Locally_defined_course.Language_Type = F Field Format: ##.## | CREDIT_VALUE Based on the grade, program, ministry_defined_course/Locally_defined_course.Language_Type = F Field Format: ##.## |
| Age 21+ Indicator | Check this box for students counted on the Student 21 or over. | Prints checkmark if student 21 or older. Refer to summary report - age calculation |
| Sub-Total for Grade | Total by Second Language Program Type and Grade Type. Total xxxxxxxx for grade xx where xxxxxxxx is the Second Language Program Type and xx is Grade Type. The report totals should only display programs that have data and for students under 21 years. | Calculated |
| Total for all students | Total students per program type in the same grade Total xxxxxxxx where xxxxxxxx is the Second Language Program Type and and for student under 21 years. | Calculated |
| Grand Total | Grand total of Students per program. Total for xxxxxxxxxx - Core: ###### Extended: ###### - Immersion: ######, where xxxxxxxx is the School Number and Name and for student under 21 years. | Calculated |
Report Sub Totals and Totals
Column Name | Description / Comments /Restrictions |
Total Second Language Program where Second language program is Core, ICFP, etc., name of the program | A count of the students for the Second Language Program within the grade. |
Total Grade ##: where ## is the grade number, 09, 10, etc. | A count of the students within each grade. |
Grand Total | Total counts of all students in all grades and programs. |
Programs or grade levels are not printed if there no students listed. For example, if there are no students counted under the Core program then Core is not listed.