In the Spring 2017, the Laftech Senior Project Team, comprised of Conrad Stoerker, Will Dixon, and Manuel Tenorio, integrated 6 databases on K-12 education in Pennsylvania for the United Way of the Greater Lehigh Valley. These databases were created out of more than 60 source files by the Fall 2016 Database Systems Class.
Laftech’s database is available by emailing me (ordillej at lafayette.edu). The team audited the data for accuracy and produced a web tool for the United Way of the Greater Lehigh Valley. You can use the tool from a PC to compare pairs of schools or districts side by side. The Laftech User Manual provides more information on the features of the tool.
The database includes the following information:
● Schools:
○ School fact summaries from school year 2012-2013 to 2014-2015
○ Academic performance data from 2012-2013 to 2014-2015
○ Enrollment reports for public schools from 2007-2008 to 2015-2016
○ Enrollment reports for private schools from 2005-2006 to 2014-2015
● Districts:
○ Stanford Education Data Project: aggregated performance means in grade equivalent units, constant population units, NAEP referenced units, and state referenced units including white-black and white-Hispanic achievement gaps, along with model covariates. Data from 2008-2009 to 2012-2013
○ Fiscal data from 2012-2013 to 2013-2014
○ Academic performance data from 2012-2013 to 2014-2015
○ District fact summaries from school year 2012-2013 to 2014-2015
Additional team project overviews from the United Way Project are available:
UC Team United Way Project (Fall 2016)