Continuing Education - Register of Enrolment in Correspondence/Self-Study/e-learning Courses (Legacy)
Introduction
Note: This version of the report references the S9-12.REG.NOLM standard and should be used for classes for school years prior to 2015-2016.
Information from Ministry
This register must be used for recording data on enrolment and attendance only on pupils enrolled in the following courses provided by the board through non-classroom modes of delivery:
correspondence courses offered using materials provided by the Independent Learning Centre
correspondence or self-study courses designed by the board that meet the requirements of courses in curriculum policy documents under Ontario Schools, Kindergarten to Grade 12: Policy and Program Requirements, 2011 (OS) or that have received the ministry’s approval
e-learning courses offered through a continuing education program that satisfy the criteria outlined in the ministry’s memorandum 2010:SB8, “Consolidated Summary of Ministry e-Learning Enrolment Recording Requirements”
Selection Criteria
Teacher Course Section Selection
For the School(s) selected on the report run page, process the Correspondence/Self-Study/e-learning course sections. Use the session term dates based on the term at the top of the report run page to get the students enrolled. Get the Session dates based on the term associated with the section.
Process all selected school(s). Continuing education schools have the Night (Continuing Education) School flag set ([Schools]ON_IsNightSchool = 1). Schools will not be included if Exclude from state reporting set or School is closed flag is set. Only active schools are processed.
Process all continuing education school classes with delivery type ([Sections]ON_Delivery_Type ) of 2, 3, 16, 18 or 19 (cannot be empty).
The Register Type should be empty, since it only applies to Adult Native Language, International Languages Elementary Program and Literacy and Numeracy Program registers. Exclude processing courses if Register Type has a value. Register Types are saved in extension tables to Sections and Courses - [S_ON_SEC_X]Register_Code and [S_ON_CRS_X]Register_Code. .Sections must have a least one student that completed at least one lesson.
Course Offering must be entered for Course or Section. Values are:
Course Purchased From The Independent Learning Centre (ILC) (Code Value 10)
Correspondence Course Prepared By The Board (Code Value 11)
E-Learning Course (Code Value 12)
5. Courses must have students enrolled in course that is tied to Standard Identifier S9-12.REG.NOLM with 20-point scale.
6. Courses where [Section]IsIndependentStudy_Class = 1 are excluded.
7. Only process sections for selected terms. If report is run at school level, the default is to run for all terms in the selected year for that school. If report is run at district level, all terms for the selected year and for each selected term will be processed.
8. Courses are sorted on report based on parameter. Fields used are
a. Course: [Courses]Alt_Course_Number, or if empty [Courses]Course_Number
b. Campus: [Sections]ON_Campus – length of 50
c. Room: [Sections]Room
Student Selection
For each Course Section, get all students
that have CC Enrollments in Section with at least one completed lesson.
not excluded from state reporting
with CC enrollments where the Independent Study Class Flag is not selected
whose Board Residence Status matches Board Residence Status Runtime option. Students for which [Students/ReEnrollments] ON_Brd_Res_Status is undefined are considered "Pupils of the Board".
who have a standard grade for identifier S9-12.REG.NOLM AND a lesson marked value greater than 0.
The report does not consider a student to be enrolled in a class on any day associated with a school enrolment (i.e. Students or ReEnrollments record) with an attendance type (i.e. EnrollmentType field) = 'EX'. This may have the effect of excluding the student from the report if, as a consequence, he has no days considered as enrolled in the class.
Report Input
For help with navigation and running the report, refer to How to Find and Generate a Report.
Field | Description |
Select School* | Choose which school to run the submission report for.
|
Board Residence Status | Select one or multiple Board Residence Status(es). Only students with those codes will be included in the student selection. Default is “Pupil of the Board’. |
Select Term to Print | School Level: Options are any terms for the year associated with the currently selected term. Default is every term will be selected. . District Level: Option is 'All Terms'. |
Sort By | Course Code, Room # or Campus |
Report Output
The register does not print if there are no student details (i.e. no students have registered/enrolled in the class). Refer to Understanding the Report Output Table for a definition of each column in the table.
Data Element | Description | [Table]FieldName |
Fields appearing at top of page | ||
Display: Course Number Section Number Course Name | Appears under the title of the Register | [Sections]Course_Number - [Sections]Section_Number [Courses]ON_ Course_Name OR if empty [Courses]Course_Name |
Display: Sort Method | Appears on top right corner of report pages For each course display ‘Sort by Course’, ‘Sort by Campus’ or ‘Sort by Room’
| [Courses]Alt_Course_Number OR if empty [Courses]Course_Number Campus: [Sections]ON_Campus (max length of 50) Room: [Sections]Room |
School | School Name (60 characters maximum) | If defined [S_ON_SCH_X]Alt_School_Name, otherwise [Schools]Name Based on Report Input Parameter |
Teacher | Lead Teacher on Sections If multiple Teachers during session, list the one active as of the current run date or the latest one if the run date is after the last day of section.
| [Users]LastFirst When [Users]DCID = [SchoolStaff]Users_DCID [SchoolStaff]SchoolID = Report Input Parameter [SchoolStaff]Id = [SectionTeacher]TeacherID [SectionTeacher]Start_Date >= Start Term [SectionTeacher]End_Date <= End Term [SectionTeacher]SectionID = [Sections]ID AND either current run date between [SectionTeacher]Start_Date and [SectionTeacher]End_Date OR current run date > [Terms]LastDay of section and [Terms]LastDay =[SectionTeacher]End_Date |
COURSE DATA | ||
Course Name | Course Name Note: Character limit for Course Name is 150 (max size on extended tables). | [Courses]ON_Course_Name if not empty. Otherwise [Courses]Course_Name
|
Course Code | Common Course Code | [Courses]Alt_Course_Number
|
Credit Value | Credit Value | [Courses]Credit_Hours
|
Check One (only one option is checked) | ||
Course purchased from the Independent Learning Centre
| Course Purchased From The Independent Learning Centre (ILC) (Code Value 10) | [S_ON_CRS_X]Course_Offering |
Correspondence course prepared by the board
| Correspondence Course Prepared By The Board (Code Value 11)
| [S_ON_CRS_X]Course_Offering |
e-Learning course
| E-Learning Course (Code Value 12) | [S_ON_CRS_X]Course_Offering
|
Calculation of Number of Lessons/Work Units Eligible for Funding | ||
September YYYY to June YYYY Total number of lessons/work units marked (not to exceed 20 per credit) | Total Completed Lessons for each student enrolled in section for a school that is not summer.
| Calculated - lessons completed for all eligible students [psm_reportcarditemgrade]actualGradeEntered [Schools]IsSummerSchool not equal 1 Class section starts prior to June 1 |
Summer YYYY Total number of lessons/work units marked and eligible for funding (not to exceed 20 per credit) | Total Completed Lessons for each student enrolled in a section at a summer school. | Calculated - lessons completed for all eligible students enrolled in a summer section [psm_reportcarditemgrade]actualGradeEntered [Schools]IsSummerSchool = 1 Class section starts on or after July 1 |
Subtract: Lessons/Work units for full-time day school pupils | Completed lessons for full time students at a school that is not summer | Calculate which students are PT/FT or CE (see “Category of Pupil” data element) Based on that, sum lessons completed for students that are FT. [Schools]IsSummerSchool not equal 1 |
Total: Number of lessons/work units eligible for funding | Total Completed Lessons for each student enrolled in section for a school that is not summer Minus Completed lessons for full time students at a school that is not summer
| Derived September YYYY to June YYYY Total number of lessons/work units marked Minus Lessons/Work units for full-time day school pupils [Schools]IsSummerSchool not equal 1 |
To be completed where the number of lessons/work units required for the course is less than 20 Only complete when:
| ||
Total Number of lessons/work units (enter total from above) | Value from above when school is not summer AND either credit value less than one OR ‘Number of Lessons/Work Units Required’ is less than 20 | Derive from value above
|
Divide by: Number of lessons/work units required for the course (maximum 20) | Number of Lessons/Work Units Required. Use override value on Sections or Courses, if entered. This overrides the 20 lessons that is the default for the standard.
Otherwise, use 20. This would only be applicable when the credit value is less than 1.00. | [S_ON_SEC_X]ConEd_CompleteCrsLessons OR if Empty [S_ON_CRS_X]ConEd_CompleteCrsLessons OR if Empty Number set up for Standard (should be 20) [gen]valueLI3 where [gen]cat = stdconvscale [gen]ID = [Standards]ID [standards]identifier = 'S9-12.REG.NOLM' |
No Label (this is sub-total of Total Number of lessons/work units divided by Number of lessons/work units required for the course) |
| Derived sub-total |
Multiply by: Credit value of course | Multiply by Credit value of course | [Courses]Credit_Value |
No Label (this is a new sub-total of sub-total from above Times Credit value of course) | Derived sub-total | Derived sub-total |
Total (adjusted) number of lessons/work units eligible for funding | Derived total | Derived total |
PUPIL DATA | ||
Number of pupils as of end of October YYYY | ||
Male | Eligible Male Students in Course enrolled any time prior to October | Count Students And [Students]Gender = M |
Female | Eligible Female Students in Course enrolled any time prior to October | (Same as above) And [Students]Gender = F |
Number of pupils September YYYY to June YYYY | ||
Male | Eligible Male Students in Course enrolled any time during the year | Count Students And [Students]Gender = M |
Female | Eligible Female Students in Course enrolled any time during the year | (Same as above) And [Students]Gender = F |
Number of pupils Summer YYYY | ||
Male | Eligible Male Students in Course enrolled any time during the summer. [Schools]IsSummerSchool = 1 | Count Students in summer school And [Students]Gender = M |
Female | Eligible Female Students in Course enrolled any time during the summer. [Schools]IsSummerSchool = 1 | (Same as above) And [Students]Gender = F |
Calculation of equivalent average daily enrolment (ADE) | ||
Total Number of lessons/work units eligible for funding (from above) | Total number of lessons/work units eligible for funding | Total Number of lessons/work units eligible for funding (from register) |
Equivalent ADE | Equivalent ADE | Calculate as Total Number of lessons’work units eligible for funding * .00579 |
STUDENT REGISTER DETAIL | ||
Lesson (Value 1 to 20) | Lesson number Look at Number of Lessons/Work Units for Course or Section. If entered, list lessons 1 to this value. Otherwise list lessons 1 to 20. | List value 1 to the following value: [S_ON_ SEC _X]ConEd_CompleteCrsLessons if entered, [S_ON_CRS_X] ConEd_CompleteCrsLessons, if entered Otherwise, based on the 20 lessons set up for this standard and list values 1 to 20. |
Pupil Name | Pupil Name (Last Name, First Name) Display up to 40 characters of student last name. If length of last name >= 35 characters then display first initial of first name Otherwise length of first name will be 40 charcters minus the length of last name. | Use [Students]ON_Legal_Last_Name and [Students]ON_Legal_First_Name, if exists. Otherwise [Students]Last_Name and [Students]First_Name
Middle Name is not needed |
OEN | OEN | [Students]State_StudentNumber |
Gender | Gender | [Students]Gender |
Category of Pupil | Get enrollment active on first day of section In the following order
Or If student has CC cross enrollment in the continuing education class and school of enrollment is a continuing education school.
| Derived value of FT, PT or CE FT – Full Time PT – Part Time CE – Continuing Education
Based on these fields
|
Home Address | Home Address If length of Street and length of City <= 43 characters, use Street and ‘,’ and City and Zip. Otherwise use 45 characters of Street and ‘ ’ and Zip. | [Students]Street [Students]City [Students]Zip |
Telephone | Telephone | [Students]Home_Phone |
Session 1 to 20 | Look at Sections/Courses Number of Lessons/Work Units Required. If value less than standard grade value, only mark lessons up to this value. | Derived from [psm_reportcarditemgrade] actualGradeEntered. Based on number entered, display a ‘✓’ for that number of lessons. Use override value [S_ON_CRS_X]ConEd_CompleteCrsLessons when less than [psm_reportcarditemgrade]actualGradeEntered. |
Number of Lessons/work units marked | ||
Sept YYYY to June YYYY | Derive from Standards for student enrolled any time during the year. [Schools]IsSummerSchool NOT = 1 Class section starts prior to July 1 AND | Derived |
Summer YYYY | Derive from Standards for student enrolled any time during the summer. [Schools]IsSummerSchool = 1 Class section starts on or after July 1 | Derived |
Total number of Lessons/work units marked | ||
Total for Sept YYYY to June YYYY |
| Total for all students |
Total for Summer YYYY |
| Total for all students |