Dashboard Metrics
Falling Class Grades
Background
District Dashboard Metrics
Because of the need to closely monitor course performance, many school districts across the nation, including Chicago, Dallas and New York, have incorporated metrics on course performance and associated credit accumulation into their internal performance management dashboards. In addition, during focus groups conducted with over 2,600 educators throughout Texas, the Falling Class Grade metric was considered useful by 95% of those surveyed.
Primary Metric
- Falling Class Grade: percent of students with a core course grade, as of the most recent grading period, that dropped 10% or more from the grading period prior to the most recent.
User Interface
Dashboard Example
Figure 1 show the Falling Class Grade metric as seen on the district dashboard.
Figure 1 TSDS Falling Class Grade Metric
Status Definition on Dashboard
The Status column displays the percentage of students with current core subject course grades dropping 10 or more percentage points (or one or more letter grades) from the prior grading period. Core courses include:
- ELA/Reading
- Mathematics
- Science
- Social Studies
The District Goal column has district goals which are configurable. The default threshold in TSDS dashboards is 15%.
Table 2 defines the threshold color indicators. The actual value is displayed with the indicator.
Metric Status Indicator | |||
Metric Name | Sub-metric Name | Metric Status Indicator | District Goal (Delta) |
Falling Class Grades | ELA/Reading | Red (Percentage) = if percentage of students with course grades dropping from the prior grading period is greater than or equal to district goal Green (Percentage) = if percentage of students with course grades dropping from the prior grading period is less than district goal | District goal and the percentage of students with course grade dropping from the prior grading period |
Mathematics | Red (Percentage) = if percentage of students with course grades dropping from the prior grading period is greater than or equal to district goal Green (Percentage) = if percentage of students with course grades dropping from the prior grading period is less than district goal | District Goal and the percentage of students with course grades dropping from the prior grading period | |
Science | Red (Percentage) = if percentage of students with course grades dropping from the prior grading period is greater than or equal to district goal Green (Percentage) = if percentage of students with course grades dropping from the prior grading period is less than the district goal | District Goal and the percentage of students with course grades dropping from the prior grading period | |
Social Studies | Red (Percentage) = if percentage of students with course grades dropping from the prior grading period is greater than or equal to district goal Green (Percentage) = if percentage of students with course grades dropping from the prior grading period is less than district goal | District goal and the percentage of students with course grades dropping from the prior grading period | |
(a) The Value column displays the number of students with core subject course grades dropping 10 or more percentage points (or one or more letter grades) from the prior grading period out of the total number of students.
Trends
Currently the dashboards do not support trends for this district metric.
Trend Definition
Table 3 lists the trend indicators for the Falling Class Grades metric.
Trend Indicators: Objective is to indicate Falling Class Grades | |||
| Up green | If the value for the current time frame is more than 5 percentage points higher than the prior time frame, then display a gray arrow trending upward. | |
| Unchanged | If the value for the current time frame is less than or equal to 5 percentage points higher or less than or equal to 5 percentage points lower than the prior time frame, then display two gray arrows pointing outward indicating no direction. | |
| Down red | If the value for the current time frame is more than 5 percentage points lower than the prior time frame, then display a gray arrow trending downward. | |
The trend does not show for the first occurrence of a time frame since data is not available.
Delta Definition
The Delta column reflects the absolute value of the difference between the falling grade percentage (Status column) and the campus goal percentage (Goal column).
Delta indicators: Objective is to indicate Falling Class Grades | |||
| Metric Name | Sub-metric Name | District Goal | Delta |
Falling Class Grades | ELA/Reading | Set district goal | Red (Delta Percentage) = if the students with course grades dropping from the prior grading period is more than the district goal Black (Delta Percentage) = if the students with course grades dropping from the prior grading period is less than the district goal |
Mathematics | Set district goal | Red (Delta Percentage) = if the students with course grades dropping from the prior grading period is more than the district goal Black (Delta Percentage) = if the students with course grades dropping from the prior grading period is less than the district goal | |
Science | Set district goal | Red (Delta Percentage) = if the students with course grades dropping from the prior grading period is more than the district goal Black (Delta Percentage) = if the students with course grades from the prior grading period is less than the district goal | |
Social Studies | Set district goal | Red (Delta Percentage) = if the students with course grades dropping from the prior grading period is more than the district goal Black (Delta Percentage) = if the students with course grades dropping from the prior grading period is less than the district goal | |
Periodicity
The data is most actionable when loaded at the end of each grading period after grades are posted. Grading periods vary by state and district. In Texas, grading periods are typically six or nine weeks.
Table 5 Recommended Load Characteristics for Falling Class Grades
Recommended Load Characteristics | |
Calendar | Throughout the school year |
Frequency of data load | Once each grading period |
Latency | 6-9 weeks |
Interchange schema | Interchange-StudentGrade.xsd |
Tooltips
The standard tool tips for the metric definition, column headers, and help functions display for this metric.
- Green metric status: OK
- Red metric status: HIGH
- 'More' indicates drill down views for this metric
is ‘No change from the prior period'
is ‘Getting worse from the prior period’
is 'Getting better from the prior period'
Business Rules
The Falling Class Grade metric identifies the percentage of students whose latest reported class grade is dropping more than 10% for each of the four core subject areas. For numeric grading systems, this is defined as dropping 10 percentage points or more. For example, if a student’s course grade in the previous grading period is 85, the course is counted as dropping 10% or more if current grades are 75 or less. For letter grading systems, this is defined as dropping one letter grade or more.
The length of the grading period is configurable and is defined by the district—typically either 6 or 9 weeks.
The metric must have at least two completed grading periods of information. Therefore, the metric is grayed-out until the second grading period is completed and grades are recorded.
Data Assumptions
- Course grades are numeric or letter based.
- District has set the value that drives the campus goals.
Computed Values
The cohort is the set of current students for whom grades are loaded for the last reported grading period. It includes students of all grades on all middle and high school campuses and excludes transfer students (late enrollment) for whom a grade is not available for the last or the previous reported grading period.
For each core subject area, the metric value is the percentage of students that have falling grades (defined as dropping 10 percentage points or more for numeric grades or one letter grade or more for letter grades).
Table 6 defines how values on the district dashboard are calculated. The result of the calculation displays in the Status column on the dashboard.
| Metric | Calculation |
Falling Class Grade | (Number of current students in cohort where (grade in specific subject for previous grading period – grade in specific subject for latest grading period is equal to or greater than 10 percentage points or one letter grade)) * 100 / total number of current students in cohort |
Data Anomalies
Footnotes
An icon appears next to any metric where students have been excluded. When the user hovers over the icon, count of students who have been excluded appear in a tooltip with the reason(s) for exclusion. By clicking on the icon, the data administrator will link to the data administrator’s page for more detail.
Best practice is to exclude and footnote students based on the following criteria:
- Missing data
Date of Refresh
Best practice is for the date of last data refresh to appear next the metric in the following format:
(Through Third Grading Period)
Implementation Considerations
Numeric or Letter Grading System
Best practice is for the metric to support both numeric and letter grading systems.
Late Enrollments or Missing Transcript Information
Students who transferred or enrolled late or students with incomplete data in their course transcript from the previous grading period are not included in the cohort.
Frequency of Uploading Data
The metric computation assumes that two grading periods are loaded: the most recent and the one prior to that. Grading periods vary by campus—typically 6 or 9 weeks.
Drill Downs
Drill Down Views
The dashboards include the option to see more detail that is associated with a metric. Table 7 lists the drill down views that are recommended for this metric.
| Campus List | List of campuses and whether or not they are meeting their goals for this metric for the specified period. |