Courses and Sections
This category carries the education course offerings and the related course sections, including the times and days the sections are offered, and includes the following data views and resources:
Course Offerings
This view captures the detailed list of Course Offerings as published in the CourseOffering entity within the Master Schedule interchange. The layout includes the Course Number, Course Name, Section Number, Term, Last Publish Date, and the Publishing ID.
CourseOffering
This entity represents an entry in the course catalog of available courses offered by the school during a session.
Primary PowerSchool Data
- [Courses]
- [Sections]
- [Terms]
Selection Criteria
Records are published if the following criteria are met:
- The school where the course is offered must not be excluded from state reporting.
- The course is offered during the year for the Term selected in the PowerSchool UI.
- The course must have a valid state course code.
- The course, the course sections, and the section teachers must not be excluded from state reporting ("AZ_ExcludeSTC").
Note: If AZ_ExcludesSTC is set to exclude the course, section, or teacher, the course offering will still be published if the Provider Last Name (AZ_ProviderT1LastName) is populated for the section. - Post-Secondary Concurrent Coursework
- The school must be flagged as a Post-Secondary School Type.
- Students must be concurrently enrolled at the post-secondary school and have an Enrollment Type (membership type) of C - Concurrent Coursework.
- Students need to be enrolled in a class at the post-secondary school and must also be enrolled in at least one class at their home school.
Entity Output
- A separate courseOffering record is published for each unique combination of course and section scheduled at each school based on the year for the Term selected in the PowerSchool UI.
- For tuitioned-out schools, a separate courseOffering record is published for each unique School Entity ID Override entered at a valid student school enrollment for the publishing year in which there is a class section enrollment.
- For post-secondary schools, a separate courseOffering record is published for each unique section scheduled at each post-secondary school based on the year for the Term selected in the PowerSchool UI.
- The courseSchedules element is only published for post-secondary schools.
Note: In PowerSchool, section records and courseOffering records are essentially the same; the ensuing Ed-Fi Section record within the Master Schedule interchange adds location and period information.
- The CourseOffering entity is dependent on the prior publishing of the following entities: Session.
- LEAs and Schools may upload (publish) data to the ODS in real time or on demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
schoolReference/ | SchoolID - The school that offers the course. | Integer | SchoolID downloaded from State Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases. Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
localCourseCode | The local code assigned by the School that identifies the course offering provided for the instruction of students. | Varchar(20) | [Courses]Course_Number + '-' + [Courses]DCID Post-secondary schools [Courses]Course_Number + '-' + [Sections]DCID | M |
localCourseTitle | The descriptive name given to a course of study offered in the school, if different from the CourseTitle. | Varchar(60) | [Courses]Course_Name | O |
courseSchedules | O | |||
/scheduleDate | The Schedule date for the course. | Date | [Calendar_Day]Date_Value if the date falls between [Terms]FirstDay and [Terms]LastDay, the section is meeting, and Calendar_Day]InSession = 1 | R |
/instructionalMinutesPlanned | The number of instructional minutes planned for the scheduledDate. | Integer | Calculated from: [Bell_Schedule_Items]Minutes_Attended | R |
sessionReference/sessionIdentity | M | |||
/schoolReference/ | SchoolID - The school for which the session is defined. | Integer | SchoolID downloaded from State Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases. Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
/schoolYear | SchoolYearType - The identifier for the school year. | Enumerated List | [Terms]YearID | M |
/term | TermType – The term type of the session. | Enumerated List | if [S_AZ_StuTchCrsConnection_S]TermTypeCode is not empty:
Otherwise: Note: The 2017-18 year term is still reported as 'Year Round'. | M |
courseReference/courseIdentity | M | |||
/courseCode | The course being offered by the school. This is typically the CourseCode in the downloaded Course entity, usually the state CourseCode. Typically, if CourseCode does not match a CourseCode in the downloaded Course entity, it will result in an error and/or be prevented from publishing. | Varchar(60) | [S_AZ_SEC_X]CourseID [Courses]Alt_Course_ number | M |
/educationOrganizationReference/ | EducationOrganizationID – The Education Organization that defines the curriculum and courses offered - often the LEA or school. This organization identifier matches the EducationOrganizationID in the downloaded Course entity, usually the SEAId. | Integer | SEAId as downloaded from the state: '79275' | M |
endOfCourseAssessmentCodeType | The End of Course Assessment Code indicates that a section or course is an AzMerit Testing Course. | String | [S_AZ_SEC_X]EOC_AssessmentCodeType [S_AZ_CRS_X]EOC_AssessmentCodeType Valid values:
Blank values are not published. | C |
Sections
This view captures the course sections offered at each school as published in the Section entity of the Master Schedule interchange. The layout captures the School Name, Course Number, Course Name, Section Number, Period Number, Last Publish Date, and the Publishing ID.
Section
This entity represents a setting in which organized instruction of course content is provided, in-person or otherwise, to one or more students for a given period of time. In Ed-Fi, a course offering may be scheduled for more than one section, but for PowerSchool there is a one-to-one correspondence between each course offering and its corresponding section.
Primary PowerSchool Source Data
- [Sections]
- [Section_Meeting]
- [Courses]
- [Terms]
- [Schools]
Selection Criteria
Records are published if the following criteria are met:
- The school where the section is taught must not be excluded from state reporting.
- The section must not be excluded from state reporting.
- The section is taught during the year for the Term selected in the PowerSchool UI.
- The course must have a valid state course code.
- The course, the course section, and the section teacher must not be excluded from state reporting ("AZ_ExcludeSTC").
Note: If AZ_ExcludesSTC is set to exclude the course, section, or teacher, the section will still be published if the Provider Last Name (AZ_ProviderT1LastName) is populated for the section.
Entity Output
- A separate Section record is published for each unique combination of school, course, and section based on the year for the Term selected in the PowerSchool UI.
- For tuitioned-out schools, a separate section record is published for each unique School Entity ID Override entered at a valid student school enrollment for the publishing year in which there is a class section enrollment.
- The AvailableCredits complex type reports credit information for sections based on the value in [Courses]Credit_Hours.
- Each Section record will also contain mandatory references to the CourseOffering, Location, and Class Period entities as contained in the Education Organization and Master Schedule interchanges.
- The Section entity is dependent on the prior publishing of the following entities: CourseOffering, Session, Location, and Class Period.
- LEAs and Schools may upload (publish) data to the ODS in real time or on demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
uniqueSectionCode | A unique identifier for the section that is defined by the classroom, the subjects taught, and the instructors that are assigned. | Varchar(255) | [Sections]SchoolID + [Sections]Course_Number + [Sections]DCID | R |
sequenceOfCourse | When a section is part of a sequence of parts for a course, the number in the sequence. If the course has only one part, the value should be 1. | Integer | Not stored in PowerSchool Default: '1' | R |
educationalEnvironment | EducationalEnvironmentType - The setting in which a child receives education and related services, for example, Center-based instruction, Home-based instruction, Hospital class, Mainstream, Residential care and treatment facility. | Enumerated List | [S_AZ_SEC_X]InstSet [S_AZ_CRS_X]InstSet
Default: 'Classroom' | O |
availableCredits The amount of credit available to a student who successfully meets the objectives of the course. Available credits are measured in Carnegie units. A course meeting every day for one period of the school day over the span of a school year offers one Carnegie unit. | R | |||
/credit | The value of credits or units of value awarded for the completion of a course. | Decimal (18,4) | [Courses]Credit_Hours | R |
courseCharacteristic (1-many) | CourseLevelCharacteristicType - Indication of the nature and difficulty of instruction: Remedial, Basic, Honors, Ap, IB, Dual Credit, CTE, etc. Dual Credit, CTE Certificate, and Graduation Requirement are published only for sections containing students in grade levels 9 or higher where the source value is not NULL. | Enumerated List | Course Level: [S_AZ_SEC_X]CourseLevel Dual Credit: [S_AZ_SEC_X]DualCredit CTE Certificate: [S_AZ_SEC_X]CTECert Graduation Requirement: [S_AZ_SEC_X]ReqGrad | R |
externalProviderTeacher (0-many) | O | |||
/externalProviderName | If the course is being provided by an external organization, e.g. a distance education or virtual course, the name of that providing organization. | Varchar(75) | [S_AZ_SEC_X]Provider | R |
/providerTeacherLastName | If the course is being provided by an external provider, the last name of the instructor. | Varchar(35) | [S_AZ_SEC_X]ProviderT1LastName [S_AZ_SEC_X]ProviderT2LastName | R |
/providerTeacherFirstName | If the course is being provided by an external provider, the first name of the instructor. | Varchar(35) | [S_AZ_SEC_X]ProviderT1FirstName [S_AZ_SEC_X]ProviderT2FirstName | R |
/classroomPosition | ClassroomPositionDescriptor – The instructional role of the instructor. | Descriptor | [S_AZ_SEC_X]ProviderT1Role [S_AZ_SEC_X]ProviderT2Role | R |
/beginDate | The begin date for the instructor. | Date | Override: [S_AZ_SEC_X]STC_CourseStartDate Else: [SectionTeacher]Start _Date | R |
/endDate | The end date for the instructor. | Date | Override: [S_AZ_SEC_X]STC_CourseEndDate Else: [SectionTeacher]End_Date | R |
sectionGradeLevels (1-many) | GradeLevelDescriptor – The grade level(s) of students either enrolled in the course or for which the course is targeted. | Descriptor | Derived from: [S_AZ_SEC_X]LowGrade [S_AZ_SEC_X]HighGrade [S_AZ_CRS_X]LowGrade [S_AZ_CRS_X]HighGrade [Schools]Low_Grade [Schools]High_Grade | R |
note | Any clarifying information for the course section. | Varchar(250) | [S_AZ_SEC_X]Notes | O |
timetableDayIdentifier | The days on which the course/section meets. | Varchar(250) | Derived from: [Sections]Expression |
|
courseOfferingReference/courseOfferingIdentity The course offering taught in the section. | M | |||
/localCourseCode | The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students. This must match LocalCourseCode in corresponding CourseOffering. | Varchar(20) | [Courses]Course_Number + '-' + [Courses]DCID Post-secondary schools [Courses]Course_Number + '-' + [Sections]DCID | M |
/term | TermType - The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match Term in corresponding CourseOffering. | Enumerated List | if [S_AZ_StuTchCrsConnection_S]TermTypeCode is not empty:
Otherwise: Note: The 2017-18 year term is still reported as 'Year Round'. | M |
/schoolYear | SchoolYearType - The identifier for the school year, for example, 2010-2011. This must match SchoolYear in corresponding CourseOffering. | Enumerated List | [Terms]YearID | M |
/schoolReference/ | SchoolId – The school offering the course. This must match SchoolId in corresponding CourseOffering. | Integer | SchoolID downloaded from State Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases. Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
locationReference/locationIdentity The location, typically a classroom, where the section meets. | M | |||
/classroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | Varchar(20) | [Sections]Room If blank, Default: 'OPEN' | M |
/schoolReference/ | SchoolId – The school for the section's classroom. | Integer | SchoolID downloaded from State Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases. Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |
classPeriodReference/classPeriodIdentity The class period during which the section meets. | M | |||
/classPeriodName | An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules. | Varchar(20) | [Period]Abbreviation If blank, Period_Number is used. Derived from: [Section_Meeting]Period_Number | M |
/schoolReference/ | SchoolId – The school for the class period. | Integer | SchoolID downloaded from State Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases. Tuitioned-out schools: [S_AZ_STU_X]EntityID_Ovr or [S_AZ_REN_X]EntityID_Ovr or [S_AZ_STU_CONENR_C]EntityID_Ovr | M |