Abstract
Due to the teacher shortage in the U.S., an automatic toolbox with secondary development based on the ArcPy package was created to explore the spatial imbalance of the pupil–teacher ratio. It consists of four tools (or toolsets) for multi-scale spatial visualization, a sensitivity analysis with a heat map, the ordinary least squares regression with spatial autocorrelation, and the random forest tree regression. This study demonstrated the application of the toolset in the evaluation of educational resource spatial misallocation. Firstly, multi-scale analysis results showed that, the loss of teachers was mainly distributed in Oregon, Nevada, Arizona, and California from the state level, while it focused on such counties as Terrebonne Parish, Concordia Parish, and Bienville Parish in Louisiana in the county level. Secondly, it was found through heatmap sensitivity analysis that pupil–teacher ratios were highly related to low levels of student support services staff, free lunch programs, and low levels of local education agency (LEA) administrators. Then, the OLS tool was used to automatically calculate the spatial weighted matrix, the Moran I, R2, and AICC indices, AdjR2, F-Stat, F-Prob, and the Wald statistic, which showed whether the model was significant or not. This was followed by random forest tree regression modeling, which found that the LEA administrative support staff and the totally free lunch number highly impacted pupil–teacher ratios. Besides, the designed tool provided ribbons for the Common Core of Data (CCD) to link to other data sources.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.