GitXplorerGitXplorer
M

wisconsin_teachers

public
1 stars
1 forks
6 issues

Commits

List of commits on branch master.
Verified
559fbf8fa66a676e68e7f066e4003c8df922691f

url typo

MMichaelChirico committed 7 years ago
Unverified
36c1d7dff4ccf9a7315276eb434f8cca889cecb3

undo fake commit

MMichaelChirico committed 8 years ago
Unverified
0b5abd84fa0d8e8da223d0fa403dc9d157152fb3

fake commit

MMichaelChirico committed 8 years ago
Unverified
c176908a1dfac961223f4fecd085a3311533c245

Add a regression table reflecting local relative wages as opposed to wage levels

MMichaelChirico committed 8 years ago
Unverified
0c48ebb35e1b3b940852e707e98c612d3b176e2c

align axes on payscales plots

MMichaelChirico committed 8 years ago
Unverified
51103fd95f18136b0af040f3f721da4249bdff5a

final tweak

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.