Classroom Teacher Attrition and Retention Dashboard
User Guide
This PowerBI dashboard allows users to dive into what percent and what type of teachers were reported in the Teacher Input Application (TIA) in a chosen year as compared to the next.
Notes on the data: The data used to build this dashboard is collected in the Teacher Input Application from each Local Education Agency (public school districts and charter organizations). All LEAs are expected to report to TIA annually by November 15th. The data displayed is contingent on what is reported to us. Some LEAs report experience in various ways. For example, total teaching experience may not be a teacher's total time teaching, as some LEAs choose to report this as the teacher's teaching time in their LEA only.
In terms of attrition for this dashboard we are including any classroom teachers that were reported in the classroom one year and no longer reported as a classroom teacher the next year. This could be for any reason including but not limited to: retirement, moving out of state, leaving the profession, or moving into a different educator role such as administration, mentor, instructional coach, etc.
Page 1 – Experience and Age
On page one, users must first select a year and teacher status they would like to view. For attrition, users can select either “Dropped From TIA” indicating they want to see graphs for teachers that were not reported anywhere in TIA the following year (as a classroom teacher) or “Switched LEA” indicating the teacher moved from one LEA to another. If users would like to see both at the same time, they can hold ctrl to select multiple. To see retention data, users should select “Stayed in LEA”. Across the top you will see the total numbers of teachers for the selected category from the selected year to the next. Each box also includes an “out of total” which shows the total number that were originally reported in TIA in the year you have selected in the “Employed Year” filter.
The second line includes a pie graph showing the percentage of teachers in the selected teacher status by age and a bar graph by experience level. The light blue box at the bottom of the bar graph shows the totals for the selected year to give context to the workforce.
The third line displays another bar graph showing the percent of each experience category for the selected teacher status. The dark blue box displays the percent of teachers dropped, which is the total teachers no longer reported in TIA the following year (as a classroom teacher) divided by the total reported in the selected year. Finally, the red box displays the percentage of classroom teachers the moved from one LEA to another from the selected year to the next.
Users can choose to additionally drill down to a specific County or LEA. Any filter chosen will affect all graphs and numbers on the entire page.
*Note: <1% did not report gender
Page 2 – Ethnicity and Certified Status
Users will need to first choose their filters for year and teacher status. County and LEA are additional optional filters. All filters affect all graphs and numerical values on the page.
The second row includes a bar graph showing the ethnicity of teachers for the selected teacher status with the total makeup of the selected workforce in the light blue bar below. Also on the second row is a pie graph display what percentage of the selected teacher status was considered appropriately certified. The light blue bar beneath the graph shows the makeup of the workforce for the selected filters.
The third row includes a second bar graph for the percentage of each ethnicity group for the selected teacher status.
Note: ~5% of teachers chose not to report ethnicity
Page 3 –Grade Level and Content
Users will need to first choose their filters for year and teacher status. County and LEA are additional optional filters. An additional filter is available on this page for position title. TIA allows LEAs to report a position that may be more specific than content area. This is particularly helpful in identifying special education teachers. The filter is defaulted to all positions, but user can select one or more positions to display. All filters affect all graphs and numerical values on the page.
The second line includes bar graphs for grade level and content area showing the number of teachers for the selected teacher status.
The third line includes a bar graph showing the percentage of teachers in each grade level and content area for the selected teacher status.
Page 4 – Over Time
On page 4, users will need to first choose their filter for teacher status. County and LEA are additional optional filters. All filters affect the two graphs on the right.
There are 4 bar graphs that show the number and percentage of teachers for the selected teacher status over the last 4 years. The first graph shows the percentage of teachers that were reported in the year shown but not the next. The percentage of teachers switched LEAs compares the LEA reported in the given year to the next for each teacher.
The two graphs on the right report raw numbers for the selected filter over a 4 year period for experience and content areas.
