End of Pathway Assessments
Introduction
The End of Pathway Assessment report includes data for students in grades K-12 who have taken an End of Pathway Assessment test.
Selection Criteria
Selection criteria determine which database records are used in the report.
Student Selection
The report selects records from the [Students] table based on the following criteria:
- The student must be enrolled at the reporting school.
- The student must have taken a CTAE End of Pathway Assessment test with the selected date range.
- The student's CTAE End of Pathway Assessment test result must be marked as "Passed" or "Failed".
- The student must not be excluded from state reporting.
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. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
Select Students | Run the report for the current selection of students or all students. |
Report Start Date | Select the start date for the report range. The report will return assessments taken between the selected start and end dates. |
Report End Date | Select the end date for the report range. The report will return assessments taken between the selected start and end dates. |
Assessments to Report | Select what records to be reported:
When selecting to report “one assessment per pathway per student” the most recent assessment within the report period with a result of “passed” is reported. When no assessments have a result of “passed”, the most recent assessment within the report period with a result of “failed” is reported instead. Assessments with a result of “Not Taken” are not reported. When selecting to report “all assessments for each student”, one record is returned for each assessment taken within the report period with a result of “passed” or “failed”. |
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 |
EP01 | 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 |
EP02 | Record Type | Identifies the record type. The value is extracted as “EPA” for End of Pathway Assessment layout | N/A | 3 |
EP03 | System Code | The school system code. This is the district number in PowerSchool. | [Prefs]Value [Prefs]Name=districtnumber | 3 |
EP04 | School Code | The school code. Note: The alternate school number is reported, if populated. Otherwise, the school number is reported. | [Schools]Alternate_School_Number [Schools]School_Number | 4 |
Filler | Filler | Formerly Student ID. | N/A | 9 |
EP06 | GTID | The student’s Georgia Testing Identifier. | [Students]State_StudentNumber | 10 |
EP07 | Assessment Code | The code representing the type of End of Pathway Assessment taken by the student. Note: This should only be reported if the student took the assessment. | [S_GA_STU_CTAE_PathAssessment_C]Assessment_Code [S_GA_STU_CTAE_StudentPath_C]AssessmentCode | 11 |
EP08 | Pass/Fail Indicator | Indicates whether the student passed the End of Pathway Assessment. | [S_GA_STU_CTAE_StudentPath_C]Passed | 1 |
EP09 | Pathway Code | Indicates the pathway associated with the assessment code. | [S_GA_CTAE_Pathway_S]PathCode | 3 |
Filler | Filler | Filler | N/A | 27 |