codefordurham / school-navigator

Navigate the Durham, NC public school system
https://durhamschoolnavigator.org
26 stars 16 forks source link

Add school background data #85

Open alexlemann opened 9 years ago

alexlemann commented 9 years ago

Teacher info, school test scores, etc.

http://www.ncschoolreportcard.org/src/search.jsp?pYear=2012-2013&pList=1&pListVal=320%3ADurham+Public+Schools+++++++++++++++++++&GO2=GO

jtf621 commented 9 years ago

It looks like the data is available from www.ncpublicschools.org/src/researchers/

at http://www.ncpublicschools.org/docs/src/researchers/src-combined.zip

NoOutlet commented 9 years ago

Found a resource using SAS which has school data, but it looks pretty locked down to me. https://ncreportcards.ondemand.sas.com/landing.html

Also looking into using http://www.ncschoolreportcard.org/src/ with Beautiful Soup Python library to parse data for all the relevant schools.

Consider adding information from http://apps.schools.nc.gov/pls/apex/f?p=155:2:0::NO for teacher evaluations.

NoOutlet commented 9 years ago

This is outside the scope of the project, but it's something I found while working on data-scraping and I'm pretty interested and concerned about what happened here... http://www.ncschoolreportcard.org/src/stateDetails.jsp?pYear=2012-2013 http://www.ncschoolreportcard.org/src/stateDetails.jsp?Page=8&pYear=2012-2013&pDataType=1

Did Common Core play a role? (notice "implemented in 2012-13") http://www.dpi.state.nc.us/core-explained/

adamajm commented 9 years ago

Charters: List/Addresses: http://www.ncpublicschools.org/charterschools/schools/ Data: http://apps.schools.nc.gov/pls/apex/f?p=1:60:0::NO::: (see left nav for the following tables) Table 34 - Final Pupils by Year and Grade Table 37 - Membership by Race and Sex Table 37 - Interactive Report (Prior to 2011) Table 38 - Pupils Being Served by Exceptional Children Program Table 39 - Enrollment by Year, Academic Level, Course, Ethnicity, and Gender Table 40.1 - Per Pupil Expenditure Ranking (Child Nutrition Included) Table 40.2 - Per Pupil Expenditure Ranking (Child Nutrition Excluded) Table 41 - Revenue From All Sources Table 42 - Current Expense Expenditures by Purpose Codes

sarahsba commented 9 years ago

Greatschools.org has info on public and charter schools. Most useful for the qualitative parent and student reviews. Would be great if we could pull these in.

sarahsba commented 9 years ago

sample site from Memphis: http://memphisschoolguide.org/

sarahsba commented 9 years ago

qualitative reviews / testimonials for magnet and traditional public schools: http://www.strongdurhamschools.com/

jtf621 commented 9 years ago

another sample site http://www.myschooldc.org