Student Class Grade Detail (EWS)
Contents
Introduction
The Student Class Grade Detail template contains a record for the grade each student earned in each marking period and the final course grade for their enrollment in a course section.
Selection Criteria
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.
Student Record Type Selection
The report selects records from the Table Name table based on the following criteria:
- One record per LEA / Location / Course Code / Section / School Year / Student ID / Grade Detail Code / Marking Period Code / Reporting Date
- The course must not be excluded from EWS reporting.
- The section must not be excluded from EWS reporting.
- The student must not be excluded from EWS reporting.
- Teacher must not be excluded from EWS reporting.
- Course Sections must have a teacher associated to the section (via Course Instructor Snapshot) before student grades can be loaded for the section.
- Letter grades in the grade scale must be mapped to the EWS letter grade value.
Report Input
For help with report navigation and generation, see How to Find and Generate a Report.
Field | Description |
Schools to include* | Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled:
If sub-districts are enabled:
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. |
Report Start Date* | Enter the start date using the format mm/dd/yyyy for the first day of the reporting period. |
Report End Date* | Enter the end date using the format mm/dd/yyyy for the last day of the reporting period. |
Field Delimiter | Choose the field delimiter for the extract file from the pop-up menu. |
Include Header Labels in output file? | Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report. |
Scheduling | Select when to run the report.
|
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.
Item # | Data Element | Description | [Table]FieldName | Field Type | Req’d |
1 | DISTRICT CODE | The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. Note: All LEA and School codes can be found at http://www.edna.ed.state.pa.us/. | [Prefs]District_Number If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | Numeric | R |
2 | LOCATION CODE | The PDE-defined, 4-digit code identifying the school. Note: All LEA and School codes can be found at http://www.edna.ed.state.pa.us/. | [Schools]School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID | Numeric | R |
3 | COURSE CODE | The locally unique COURSE CODE assigned by the Local Education Agency. Note: Courses may have multiple sections. Each course should have a single COURSE CODE. Do not assign a separate course code to sections of the same course. This should be the same course code that is used to populate related “COURSE CODE LONG” field in the Course Instructor Template. | [Courses]Course_Number | AlphaNumeric
| R |
4 | SCHOOL YEAR DATE | A single date indicating the whole school year. June 30, at the end of the standard school year, is used to designate a school year. Thus, the 2014-2015 school year would be indicated by 2015-06-30. | Derived from [Terms] | Date
| R |
6 | SECTION CODE | The number assigned by the LEA to identify distinct classes within a course offering. This field should be the local section number only. | Derived | AlphaNumeric
| R |
7 | STUDENT ID | The unique, 10-digit PAsecureID assigned to the student. | [Students]State_StudentNumber | Numeric | R |
8 | GRADE DETAIL CODE | The type of grade reported for the specified course and section. | Static values: 01=current grades 02=final grades | Numeric | R |
9 | REPORTING DATE | For Dashboard Data Submissions this should always be the School Year Date. | Derived | Date | R |
10 | MARKING PERIOD CODE | A code indicating the marking period during the school year for which the student earned a grade in the class section. | [S_PA_TRB_X]State_Marking_Period Use final grade setup page for the mapping for PowerSchool Final Grade Setup Codes to the PA Marking period Code | AlphaNumeric | R |
12 | ALPHA GRADE | A letter grade indicator of student performance in a class as submitted by the instructor. | For current alpha grades > [PGFinalGrades]Grade For final alpha Grades [StoredGrades]grade Must map state grade values to the local grade values in District Office > Grade scale setup [S_PA_GSI_X]State_Grade_Code | Alpha | O |
13 | NUMERIC GRADE | A numeric grade indicator of student performance in a class as submitted by the instructor. This should be the student’s percentage grade in the course on a scale of 0 – 100. If the student earned higher than 100% through extra credit, submit 100. Either a Numeric Grade or an Alpha Grade must be submitted for students. | For current grades > [PGFinalGrades]percent
For final Grades [StoredGrades]percent | Numeric | CR |
20 | TERM CODE | The type of the session during the school year in which the course section was offered. | [S_PA_TRM_X]State_Term_Code | AlphaNumeric | R |