Educator Pipeline Dashboard
Educator Pipeline User Guide
This PowerBI dashboard allows users to follow educators from the Institutional Recommendation (IR) to certification to the classroom (as reported in Teacher Input Application- TIA).
Page 1 – IRs to Cert to Class
On page one, the top bar graph shows the last 4 years with navy representing the number of IRs received each year for unique educators. The crimson represents the number of unique educators that received an IR that year and went on to later be issued a provisional or standard certificate to teach in Arizona. Lastly, the copper represents the number of unique educators that received an IR that year and was reported in TIA as a classroom teacher at any point.
The bottom half of page one breaks apart the IRs, certificates, and teachers reported in TIA into separate graphs with individual lines representing each Institution that offered Educator Prep Programs and reported IRs.
Users may use the filter in the top right corner to choose a single or multiple institutions to display on this page. This filter affects all 4 graphs on the page.
Page 2 – Program Types and Content
On page two, the top graph displays the number of IRs issued each fiscal year by program type. The bottom graph shows of those later reported in TIA, what content they were reported as teaching. (The TIA graph is not reporting the program they completed, but instead how they were reported by their LEA. For example, an educator may complete an elementary education program and go on to teach 1st grade in an LEA and the LEA reports their position as Early Childhood even though they didn’t complete and Early Childhood program.)
Users may use the filter in the top right corner to choose a single or multiple institutions to display on this page. This filter affects both graphs on the page.
Page 3– Approved Areas
On page 3, the graph shows the number of educators holding certificates with specific approved areas by IR year.
Users may use the filter for specific institutions or specific approved areas. Users may select multiple on either filter by holding down ctrl.
Page4– Certficates
On page 4, the graph shows the number of educators holding specific certificates by IR year.
Users may use the filter for specific institutions or specific certificates. Users may select multiple on either filter by holding down ctrl.
Notes about the data used and how to read it:
Institutional Recommendation Data:
Prior to 2021, institutional recommendations (IRs) were distributed to program completers and ADE only received them if a person was turning it in when they applied for certification.
Starting in FY 2021, educator prep programs (EPPs) were asked to send a spreadsheet of all program completers to ADE, thus making the data more complete.
Teacher Input Application Data:
All educator assignments are expected to be entered yearly into the Teacher Input Application (TIA) by each Local Education Agency (LEA). All data entered is self-reported by the LEA by an employee of their choosing. Some LEAs complete this at the site level and others at the district/charter organization level. The system is dated and can be cumbersome, especially for LEAs with a larger collection of educators. Errors and missing data have been identified and addressed as much as possible but keep in mind that there is some level of error to any self-reported data.
Understanding the impact of Institutions with a large online presence:
When reading the graphs provided it is important to note that some of the approved EPPs for Arizona serve students residing outside of Arizona through online options. While many of these students complete their programs, receive an IR, and many times will even become certified here in Arizona, they may never intend to teach here in Arizona. A certificate in Arizona can often be used to obtain a reciprocal certificate in another state.
The following Institutions are known to have a large percentage of online, out-of-state program completers:
Grand Canyon University
Ottawa University
University of Phoenix
