Teacher Retention

Background

District Dashboard Metrics

Identifying and training effective teachers can be a very expensive and time consuming process. It is therefore advantageous for campuses and districts to retain effective teachers. Moreover, in focus groups with over 2,600 Texas educators, the Teacher Retention metric was seen as useful by 89% of educators. 

Primary Metric

  • Teacher Retention: percentage from teachers returning from the previous year.

User Interface

Dashboard Example

Figure 1 shows the Teacher Retention Rate metric as seen on the staff dashboard.

Figure 1 TSDS Teacher Retention Rate

Status Definition

The status indicator is determined by campus specific goals which are set at the district level.  The TSDS default goal = 80%

Table 2 shows the status indicators for the teacher retention metric.

Table 2 Metric Indicators for Teacher Retention Metric

Metric Indicator

Comparisons

Metric Name

Metric Indicator

Trend

Campus Attainment

Teacher Retention

Red (Percentage) =  fewer teachers returning from prior year  than district goal

Green (Percentage) = percentage of teachers returning from the previous year is equal to or greater than district goal

Current and prior year

The number of campuses meeting their campus goal over the number of campuses with data for the metric

Trends

The dashboards currently do not support trends for this metric.  The UI supports the trend, but the ETL package has not been developed.

Trend Definition.

Table 3 lists the trend indicators for the Teacher Retention metric. .

Table 3 Trends for TSDS Teacher Retention Metric

Trend Indicators for Teacher Retention

Up green

Percentage is higher compared to previous time frame; upward trend is favorable

Unchanged

+ 5 percentage points

Down red

Percentage is lower compared to previous time frame; flag indicates unfavorable trend

Delta Definition

The Delta column appears only in the campus list and is the absolute value of the difference between the campus retention percentage and the campus goal. If the retention percentage is below the campus goal, the delta percentage is displayed in red. If the attendance percentage is equal to or above the campus goal, the delta percentage is displayed in black.

Periodicity

Best practice is to load the data for this metric each semester.

Table 4 Recommended Load Characteristics for TSDS Teacher Retention Metric

Recommended Load Characteristics

Calendar

Throughout the school year

Frequency of data load

Yearly

Latency

Year

Interchange schema

Interchange-StaffAssociation.xsd

Tooltips

The standard tool tips for the metric definition, column headers, and help functions display for this metric.

The following are tooltips specific to the Teacher Education metric:

  • Green metric status: OK
  • Red metric status: LOW
  • '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 Teacher Retention metric displays the percentage of teachers returning from the previous year.

Data Assumptions

  • Data is available in district source systems.
  • Historical Dashboard data is available for this district.

Computed Values

Table 5 defines how values are calculated for the metric. The result of the calculation displays in the Status column on the staff dashboard.

Table 5 Computed Values for TSDS Teacher Retention Metric

Metric Values

Teacher Retention

Total number of teachers on a campus currently who were on the same campus in the prior year/the total number of teachers in the district  the prior year

Data Anomalies

Footnotes

No footnotes are need for this metric.

Date of Refresh

No date of refresh is needed for this metric.

Active Campuses

This metric should not include teachers from campuses that have been closed or are no longer active. 

Drill Downs

Drill Down Views

The dashboards include the option to drill down and see more detail that is associated with a metric. Table 6 lists the drill down views that are defined for this metric.

Table 6 Drill Down Views for Teacher Retention Metric
Campus ListList of campuses and whether or not they are meeting their goal for this metric for the specified period.

User Interface

Figure 2 shows the LEA Teacher Retention Teacher List.

Figure 2 TSDS LEA Teacher Retention Teacher List

Back to top