Section - Course Report
Contents
Introduction
Use the Section - Course report to collect the course portion of the Teacher Course Student Data Collection.
Required Data Setup
You must define the following information before generating this extract.
- Courses must be flagged for ELA or Math Provider.
- Sections must have the teacher of record information set as well as any contributing educator information completed.
- Contributing Educators must be assigned to an individual student and the sections for which they are contributing ELA or Math.
Selection Criteria – Section - Course
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.
The report selects records based on the following criteria:
- All Courses that have associated sections in the school year of the Term the user is logged into in PowerSchool will be selected.
- The Course cannot be set to be excluded from state reporting.
Report Input – Section - Course
For help with navigation and running the report, see How to Find and Generate a Report.
Data to be Filled | |
School Year | Select the school year for which the report is to be run. |
Scheduling Options | Description |
Scheduling – Run Now | Leave Run Now selected to run the report now. |
Submit | Click Submit to run the report now. |
Scheduling – Please Select When to run | Click the Schedule button to schedule this report to run. |
Please Select Schedule Settings | Enter the Start Date and Start time. Click the Repeat button. |
Please select repeat cycle options. | Choose the applicable option. |
Please select end date range option | Enter the appropriate information. |
Submit | Click Submit to schedule the report |
Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.
Report Output – Section - Course
Each of the fields displayed in the output of the report are 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 |
A | DISTCODE | This field contains the reporting district code | [Schools]District_Number | Text | 2 |
B | SCHCODE | This field contains the reporting school number. | [S_RI_SCH_X]Ride_ID | Text | 5 |
C | LOCALCOURSEID | The identifier for the course assigned by the local education agency (LEA). If the Course RI Course Classification ID = 23002 is reported as a preschool course and so the local course id will be the Service Delivery Module + School Code + Section ID | [Courses]Course_Number OR [S_RI_CRS_X]Service_Delivery_Model + [S_RI_SCH_X]Ride_ID OR [S_RI_CRS_X]Private_SpecialEd_School + [S_RI_SEC_X]PreSchool_Section_ID | Text | 20 |
D | LOCALCOURSETITLE | The descriptive name given to a course of study offered in a school or other institution or organization. | [Courses]Course_Name | Text | 100 |
E | SCEDCOURSE | The five-digit School Codes for the Exchange of Data (SCED) code and name of the course. The first two digits of the code represent the Secondary Course Subject Area. | [S_RI_CRS_X]Classification_ID | Text | 5 |
F | COURSELEVEL | This field contains the course level of rigor. This is an optional field and will be blank in the output file. | Extracted as Null [S_RI_CRS_X]Course_Level | Text | 1 |
G | HSCOURSEREQUIRED | An indication that this course credit is required for high school diploma. This is an optional field and will be blank in the output file. | Extracted as Null [S_RI_CRS_X]HS_Required | Text | 1 |
H | CREDITAVAILABLE | The amount of Carnegie credit available to a student who successfully meets the objectives for courses that carry credit. Available Credit is coded as a one-digit number carried out to two decimal places. (Examples: 1.00, 0.50). This is an optional field and will be blank in the output file. | Extracted as Null | Text | 4 |
I | GRADESPAN | Identifies the intended grade span for which the course is appropriate and is represented as a four-character code with no decimals. Grade levels are represented by a two-digit code, ranging from 01 to 12; kindergarten is KG, and prekindergarten is PK. | [S_RI_CRS_X]GradeSpan | Text | 4 |