Skip to content

Instantly share code, notes, and snippets.

View erikerickson's full-sized avatar

Erik Erickson erikerickson

  • TEC, SAU (NH), Ed Consultant.
  • NH
View GitHub Profile
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 16 columns, instead of 3. in line 9.
DistrictName,City,Lon,Lat,DistrictCode,TestsTaken,Score=1,Score=2,Score=3,Score=4,Score=5,Score1-2,Score 3-5,Year,Qualify,Success
Abington,Abington,-70.9453218,42.1048228,10000,146,13,32,55,34,12,30.8,69.2,2017 - 18,101,69.18%
Academy Of the Pacific Rim Charter Public,Boston,-71.0582912,42.3602534,4120000,57,24,21,10,2,0,78.9,21.1,2017 - 18,12,21.05%
Acton-Boxborough,Acton,-71.43284,42.4850931,6000000,"1,156",6,48,153,372,577,4.7,95.3,2017 - 18,"1,102",95.33%
Adams-Cheshire,Pittsfield,-73.2453785,42.4500967,6030000,144,32,64,37,11,0,66.7,33.3,2017 - 18,48,33.33%
Advanced Math and Science Academy Charter,Marlborough,-71.5522874,42.3459271,4300000,352,3,27,75,100,147,8.5,91.5,2017 - 18,322,91.48%
Agawam,Agawam,-72.6148117,42.0695391,50000,411,36,135,136,70,34,41.6,58.4,2017 - 18,240,58.39%
Amesbury,Amesbury,-70.9300548,42.8584235,70000,127,14,24,33,36,20,29.9,70.1,2017 - 18,89,70.08%
Amherst-Pelham,Amherst,-72.523143,42.3803676,6050000,231,7,29,60,65,70,15.6,84.4,2017 - 18,195,84.42%
Andover,Andover,-71.1408776
@erikerickson
erikerickson / mass.json
Last active October 16, 2019 16:10
MassGEO.json
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@erikerickson
erikerickson / SCHOOLDISTRICTS_POLY.json
Last active October 9, 2019 19:29
JSON of Massachusetts School Districts boundaries.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
District Name,Year,Tests Taken,Score,Level
Abby Kelley Foster Charter Public,2010 - 11,1,1,1
Abby Kelley Foster Charter Public,2010 - 11,,2,2
Abby Kelley Foster Charter Public,2010 - 11,,3,3
Abby Kelley Foster Charter Public,2010 - 11,,4,4
Abby Kelley Foster Charter Public,2010 - 11,,5,5
Abington,2014 - 15,99,4,1
Abington,2014 - 15,,30,2
Abington,2014 - 15,,35,3
Abington,2014 - 15,,21,4
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 21 columns, instead of 1. in line 5.
School Name,District,School,9-12 Pop,Tests Taken,% Students taking at least 1 AP Test,Score=1,Score=2,Score=3,Score=4,Score=5,% Score 1-2,% Score 3-5,# Tests Takers,One Test #,One Test %,Two Tests,Two Tests %,Three Tests,Four Tests,Five or More Tests
Abington High (Abington),Abington,Abington High,517,146,0.15,13,32,55,34,12,30.8,69.2,79,36,45.57%,21,26.58%,20,2,0
Academy Of the Pacific Rim Charter Public School (Academy Of the Pacific Rim Charter Public (District)),Academy Of the Pacific Rim Charter Public (District),Academy Of the Pacific Rim Charter Public School,211,57,0.15,24,21,10,2,0,78.9,21.1,32,15,46.88%,9,28.13%,8,0,0
Acton-Boxborough Regional High (Acton-Boxborough),Acton-Boxborough,Acton-Boxborough Regional High,1827,1156,0.28,6,48,153,372,577,4.7,95.3,518,195,37.64%,134,25.87%,104,53,32
Hoosac Valley High School (Adams-Cheshire),Adams-Cheshire,Hoosac Valley High School,296,144,0.33,32,64,37,11,0,66.7,33.3,98,65,66.33%,21,21.43%,11,1,0
Advanced Math and Science Academy Charter School (Advanced Mat
@erikerickson
erikerickson / README.md
Last active September 24, 2019 22:31
StudentAttendanceRetention

This is a Massaschusetts Department of Elementary and Secondary Education (DESE) public data set on student retention. This report presents data on grade retention rates in Massachusetts public schools. The Massachusetts Department of Elementary and Secondary Education defines a student retention as: a student who was reported to have repeated the grade in which he or she was enrolled during the previous school year.

What are the most attending districts? Are there geopraphical patterns to absenteeism? Is there a correlations between retention and absenteeism?

Year (quantitative), District Name (Categorical), Chronically Absent (10% or more) (quantitative)

@erikerickson
erikerickson / DESE AP w. LonLat
Last active October 17, 2019 02:58
maDESE_AP_Performance
DistrictName,City,Lon,Lat,DistrictCode,TestsTaken,Score=1,Score=2,Score=3,Score=4,Score=5,Score1-2,Score 3-5,Year,Qualify,Success
Abby Kelley Foster Charter Public,Worcester,-71.8022934,42.2625932,04450000,1,,,,,, .0, .0,2010 - 11,0,0.00%
Abington,Abington,-70.9453218,42.1048228,00010000,99,4,30,35,21,9, 34.3, 65.7,2014 - 15,65,65.66%
Abington,Abington,-70.9453218,42.1048228,00010000,123,8,46,40,20,9, 43.9, 56.1,2015 - 16,69,56.10%
Abington,Abington,-70.9453218,42.1048228,00010000,128,11,45,46,22,4, 43.8, 56.3,2016 - 17,72,56.25%
Abington,Abington,-70.9453218,42.1048228,00010000,75,5,29,29,9,3, 45.3, 54.7,2012 - 13,41,54.67%
Abington,Abington,-70.9453218,42.1048228,00010000,105,12,36,40,11,6, 45.7, 54.3,2011 - 12,57,54.29%
Abington,Abington,-70.9453218,42.1048228,00010000,93,16,25,30,14,8, 44.1, 55.9,2010 - 11,52,55.91%
Abington,Abington,-70.9453218,42.1048228,00010000,146,13,32,55,34,12, 30.8, 69.2,2017 - 18,101,69.18%
Academy Of the Pacific Rim Charter Public,Boston,-71.0582912,42.360253
@erikerickson
erikerickson / README.md
Last active September 19, 2019 00:04
maDropOutRate

This is a Massaschusetts Department of Elementary and Secondary Education (DESE) public data set on Drop Out Rates showing the percentage of Massachusetts public high school graduates who drop out of high school.

Are there geographical patterns in MA Drop Out Rates? Are there notable dropout patterns with Gender, Race, or Grade? What are the most significant dimensions to dropout rates in MA? What are the best and worst performing schools districts with regard to dropout rates?

Most Interesting: Gender (categorical), Race (Categorical)