J01 - System Course
Introduction
Student Learning Objective (SLO) master course data. One record is transmitted for courses that have the same course number in the "xx.0xxx000" format with the same SLO Measure Type and SLO target values.
Note: Courses with a course number in the format xx.8xxxxxx are not included in this report.
Selection Criteria
Selection criteria determine which database records are used in the report.
Course Selection
Required: All SLO courses need to have an SLO Measure Type defined.
Required: A default target needs to be defined at the district level for each measure type used (percentage and rubric). If no default is defined, then the report will continue to output blanks for columns J108 to J124.
When a specific target is not set for an SLO course the report pulls the default SLO Target. See requirement above.
The courses are consolidated per the following rules:
- Only one record will be reported for courses that have the same course number in the "xx.0xxx000" format with the same SLO Measure type and SLO target values.
- The course number (J106) is reported in the "xx.0xxx000" format.
- The course name (J125) is reported as the one that has the lowest first digit after the decimal in multiple iterations.
- The courses included in the report are the courses marked as SLO courses that have sections defined for at least one of the schools selected, with a term within the date range of Report Start Date and Report End Date, which are provided when the report is run.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Select Schools | Run the report using a selection of multiple schools or for all schools. |
Report Start Date | Enter the start date of the report. Note: Enter the date in a format of MM/DD/YYYY. |
Report End Date | Enter the end date of the report. Note: Enter the date in a format of MM/DD/YYYY. |
File Path and File Suffix | The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix. For example a report run at district 999 on August 1, 2014 at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201408010915_AAA.txt in the provided location. If no path is given, or if PowerSchool is unable to write to the given folder, the report will run but will not be saved to the server. |
Report Output
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.
ID | Data Element | Description | [Table]FieldName | Length |
|---|---|---|---|---|
J101 | Fiscal Year | The fiscal year of the record. The report extracts the year based on the last day in the current school calendar. | [Terms]LastDay | 4 |
J102 | Period | The reporting period. Always 1. | N/A | 1 |
J103 | System Code | The school system code. This is the district number in PowerSchool. | [Prefs]Value [Prefs]Name=districtnumber | 3 |
J104 | Record Type | The record type. Always J01. | N/A | 3 |
J105 | School Code | The school code. Note: The alternate school number is reported, if populated. Otherwise, the school number is reported. | [Schools]Alternate_School_Number | 4 |
J106 | Course Number | The 9-digit number designating an official course as specified in SBOE Rule 160-4-2-.20 with decimal added to format. See selection criteria for description of how duplicate SLO course records are determined. | [Courses]Course_Number | 10 |
J107 | SLO Measure Type | Indicates whether individual student growth in this course is measured using a uniform rubric or an individual percentage growth on a SLO assessment. | [S_GA_CRS_X]SLOMeasureType | 2 |
J108 | Expected Percentage Growth | The percentage of growth in the course for a student to meet the expected growth target. | [S_GA_SLOTargets_S]ExpectedGrowth1 | 3 |
J109 | High Percentage Growth | The percentage of growth in the course for a student to meet the high growth Target. | [S_GA_SLOTargets_S]HighGrowth1 | 3 |
J110 | Total Uniform Rubric Levels | Indicates how many levels exist in the rubric for this course. | [S_GA_SLOTargets_S]TotalRubricLevels | 1 |
J111 | Level 1 Expected | Indicates the expected target rubric level on the post-test (at the end of the course) for Level 1 pre-test measurements. | [S_GA_SLOTargets_S]ExpectedGrowth1 | 1 |
J112 | Level 1 High | Indicates the high target rubric level on the post-test (at the end of the course) for Level 1 pre-test measurements. | [S_GA_SLOTargets_S]HighGrowth1 | 1 |
J113 | Level 2 Expected | Indicates the expected target rubric level on the post-test (at the end of the course) for Level 2 pre-test measurements. | [S_GA_SLOTargets_S]ExpectedGrowth2 | 1 |
J114 | Level 2 High | Indicates the high target rubric level on the post-test (at the end of the course) for Level 2 pre-test measurements. | [S_GA_SLOTargets_S]HighGrowth2 | 1 |
J115 | Level 3 Expected | Indicates the expected target rubric level on the post-test (at the end of the course) for Level 3 pre-test measurements. | [S_GA_SLOTargets_S]ExpectedGrowth3 | 1 |
J116 | Level 3 High | Indicates the high target rubric level on the post-test (at the end of the course) for Level 3 pre-test measurements. | [S_GA_SLOTargets_S]HighGrowth3 | 1 |
J117 | Level 4 Expected | Indicates the expected target rubric level on the post-test (at the end of the course) for Level 4 pre-test measurements. | [S_GA_SLOTargets_S]ExpectedGrowth4 | 1 |
J118 | Level 4 High | Indicates the high target rubric level on the post-test (at the end of the course) for Level 4 pre-test measurements. | [S_GA_SLOTargets_S]HighGrowth4 | 1 |
J119 | Level 5 Expected | Indicates the expected target rubric level on the post-test (at the end of the course) for Level 5 pre-test measurements. | [S_GA_SLOTargets_S]ExpectedGrowth5 | 1 |
J120 | Level 5 High | Indicates the high target rubric level on the post-test (at the end of the course) for Level 5 pre-test measurements. | [S_GA_SLOTargets_S]HighGrowth5 | 1 |
J121 | Level 6 Expected | Indicates the expected target rubric level on the post-test (at the end of the course) for Level 6 pre-test measurements. | [S_GA_SLOTargets_S]ExpectedGrowth6 | 1 |
J122 | Level 6 High | Indicates the high target rubric level on the post-test (at the end of the course) for Level 6 pre-test measurements. | [S_GA_SLOTargets_S]HighGrowth6 | 1 |
J123 | Level 7 Expected | Indicates the expected target rubric level on the post-test (at the end of the course) for Level 7 pre-test measurements. | [S_GA_SLOTargets_S]ExpectedGrowth7 | 1 |
J124 | Level 7 High | Indicates the high target rubric level on the post-test (at the end of the course) for Level 7 pre-test measurements | [S_GA_SLOTargets_S]HighGrowth7 | 1 |
J125 | Local Course Name | The local course name used to identify the course on class rosters and grade books. If blank, default display in reports will be the official course name as defined in GaDOE Board Rule. See selection criteria for description of how duplicate SLO course records are determined. | [Courses]Course_Name | 31 |
J126 | Filler | Filler | N/A | 50 |