GitXplorerGitXplorer
M

wisconsin_teachers

public
1 stars
1 forks
6 issues

Commits

List of commits on branch master.
Unverified
fed14d90dca7c3950d3247eabd4e73b9965a708c

district_fill -> district, finished robustness to pay metric, finish appendix

MMichaelChirico committed 8 years ago
Unverified
ae30bd8e95768e27d7db59355c9f42c56ba43b76

some improvements to pre-processing of raw data, dropping kenosha errors, add table note, work on appendix

MMichaelChirico committed 8 years ago
Unverified
0f30e960444f684e8c86fc167470d86c2531179d

cobs summary 'graph, start matching appendix

MMichaelChirico committed 8 years ago
Unverified
e4c407c2cc71ae556f04fca2490cb7fd9f925319

obsolete file

MMichaelChirico committed 8 years ago
Unverified
3897e6c2724b18fb10eccaa7987f178b236d330a

axing some notes

MMichaelChirico committed 8 years ago
Unverified
18264af8b220212989a024573f3532fc7d4f7db4

return small districts figure

MMichaelChirico committed 8 years ago

README

The README file for this repository.

This repository provides reproduction code for the paper Teacher Turnover in Wisconsin, which can be downloaded here. The paper was compiled with rmarkdown through knitr; the .Rmd document for the paper is this one.

Raw Data

There are three public sources of data for this paper:

  1. Wisconsin Department of Public Instruction (DPI) collects and releases annual WISEstaff PI-1202 reports which give teacher- (more specificaly, assignment-) level snapshots of the full panoply of school employees in the state. These are available here. The R script raw_data_cleaner.R will download these files and do some baseline touchup to the raw files (which are mostly in fixed-width format) before producing easy-to-use .csv versions of the raw data. The script can be run at the command line with Rscript raw_data_cleaner.R; be sure to customize the wd.data variable to the local paths to which to download the data and write the .csvs.

  2. Wisconsin's WKCE test score data is also released by DPI at the district and school level. As per here, the WKCE is part of the WSAS battery of tests; the full set of these results can be downloaded through the WINSS historical data file repository here.

  3. The NCES Common Core of Data District- and School-level data files.

Pre-Paper Data Cleaning

turnover_paper.Rmd runs the turnover_data_cleaner.R script internally (which does some final data wrangling and runs the COBS routine, but relies on two scripts to be run beforehand:

  1. background_data_cleaner.R assembles school- and district-level files from the DPI and NCES; be sure to customize wds here as well, which tell the script where to find these raw data files and where to write the output.

  2. teacher_match_and_clean.R runs the teacher matching algorithm described in the paper's Appendix in order to create a panel of data from the DPI's cross-sections.

Feel free to file an issue or e-mail me for any further clarification/concerns.