Essential Question 1: Vacancy

Key Data Definitions

• A current vacancy is defined as any position reported that does not have a filled date as of last refresh.
• A school year, for demo purposes, is defined using July 1 as the new year cutoff date. Any vacancy open on or after July 1 will be counted toward the new school year ((cut off month is set based on demo data; adjust for local context)..
• Vacancies are assigned to months based on whether they were open during any part of a given month. For example, if a vacancy was posted on August 15th and closed on September 5th, it will show as being an open vacancy for months of August and September.

Chart Navigation

In line graphs with multiple series, series may overlap, making selecting for just a single point difficult. If encountering this difficulty, the recommended approach is to filter the chart down to a single series and then select points as needed. For example in the Vacancies through time chart, which displays vacancy series for multiple years, apply the SchoolYear filter for the desired year.

Current Vacancies - County View

This page provides a view into all vacancies in the county broken down by district, as well as by assignment category. It provides insight into how vacancies vary by district.

Current Vacancies - District View

This page provides a view into all vacancies in a district broken down by campus as well as by assignment category. It provides insight into how vacancies vary within a district. This page will be filtered for data only available in the user's assigned district.

Vacancies through Time - County View

This page provides a view into all vacancies in the county across years and snapshots within each year. Vacancies are also shown by assignment category and assignment type. It provides insight into how vacancies vary across time in order to surface vacancy trends.

Vacancies through Time - District View

This page provides a view into all vacancies in the district across years and snapshots within each year. Vacancies are also shown by assignment category and assignment type. It provides insight into how vacancies vary across time in order to surface vacancy trends. This page will be filtered for data only available in the user's assigned district.

Essential Question 2: Staff Retention

Key Data Definitions

• Staff is considered not retained for a year if they are assigned to a school or district in a given year but not the following year.
• RetainedInDistrictAndSchool - Staff was retained by the school and the district.
• RetainedInDistrictNotSchool - Staff switched schools within a district.
• NoLongerInDistrict - Staff switched to a different district within a county.
• NoLongerInCountry - Staff left assignment with no subsequent assignment record.
• Retained Percent - a retention is counted for purposes of total retained percent if one of the two apply: staff were retained by a school or staff switched schools within a district.

Chart Navigation

In line graphs with multiple series, series may overlap, making selecting for just a single point difficult. If encountering this difficulty, the recommended approach is to filter the chart down to a single series and then select points as needed.

For example in the Retention Across School Years chart, if the line chart is being analyzed by assignment type, filter the dashboard for just a single assignment type to view just a single line.

Additionally, the retention trends line charts have a vertical zoom feature that allows you to limit the range of the Y-Axis, which has the effect of spreading out individual lines.

Educator Retention Summary - County View

This page provides a summary of staff retention levels at the county. Charts can be broken down and filtered using multiple dimensions.

A staff member is considered not retained for a year if they are assigned to a school or district in a given year but not the following year. By default, data on this page is filtered for the most recent school year.

This page provides a summary of staff retention levels at the district level. Charts can be broken down and filtered using multiple dimensions.

Educator Retention - County View

This page provides a summary of staff retention levels at the district level. Charts can be broken down and filtered using multiple dimensions.

A staff member is considered not retained for a year if they are assigned to a school or district in a given year but not the following year. By default, data on this page is filtered for the most recent school year.

Staff Retention - County View

This page shows retention trends at the county level over time. Trends can be analyzed across four different dimensions. A chart provides additional details.

A staff member is considered not retained for a year if they are assigned to a school or district in a given year but not the following year.

Staff Retention - District View

This page shows retention trends at the district level over time. Trends can be analyzed across four different dimensions. A table chart provides additional details.

A staff member is considered not retained for a year if they are assigned to a school or district in a given year but not the following year.

Essential Question 3: Staff Summary

Key Data Definitions

• New Hire - Staff is considered to be a new hire for a given year if it is their first year assigned to a district.
• Near Retirement - Staff is considered to be near retirement if they are X years or older. 57 years or older is set based on demo data; adjust for local context) Multiple Races - Staff and students are considered to have multiple races if there are more than one distinct race associated with them within Ed-Fi
• Educator Population can be filtered by New Hires and Near Retirement staff. These filter buttons only show if there are staff that fall within the given category.

Educator Summary - No Students - County

This page shows a summary of educators at the county level, broken down by race/ethnicity and certification type in addition to map and totals views.

Educator population can be filtered by new hires and near retirement staff. These filter buttons only show if there are staff that fall within the given category.

Educator Summary - No Students - District

This page shows a summary of educators at the district level, broken down by race/ethnicity and certification type in addition to map and totals views.

Educator population can be filtered by new hires and near retirement staff. These filter buttons only show if there are staff that fall within the given category.

Educator Summary - Students - County

This page shows a summary of educators at the county level, broken down by race/ethnicity and certification type in addition to map and totals views. It also includes a view of students broken down by race/ethnicity for comparison. The student chart will not respond to any of the staff filters, and instead will always show the current student population.

Educator population can be filtered by new hires and near retirement staff. These filter buttons only show if there are staff that fall within the given category.

Educator Summary - No Students - District

This page shows a summary of educators at the district level, broken down by race/ethnicity and certification type in addition to map and totals views. It also includes a view of students broken down by race/ethnicity for comparison. The student chart will not respond to any of the staff filters, and instead will always show the current student population.

Educator population can be filtered by new hires and near retirement staff. These filter buttons only show if there are staff that fall within the given category.