Advanced Placement (AP) Performance

This dataset contains Advanced Placement (AP) score data for all Massachusetts public and charter schools and districts since 2007. It shows the number of students who received each possible score (1-5) on AP exams, as well as the percent of students scoring 1-2 or 3-5 on those exams, disaggregated by student group.

Economically Disadvantaged was used 2015-2021. Low Income was used prior to 2015, and has been used again since 2022. Please see the <a href="https://www.doe.mass.edu/research/researchers.html" target="_blank" rel="noreferrer noopener">DESE Researcher's Guide</a> for more information.

This dataset contains the same data that is also published on our DESE Profiles site:

<a href="https://profiles.doe.mass.edu/statereport/ap.aspx" target="_blank" rel="noreferrer noopener">Advanced Placement Performance</a>

<b>List of AP Subjects</b>

Arts<ul><li>2-D Art and Design</li><li>3-D Art and Design</li><li>Drawing</li><li>Music Theory</li><li>Studio Art: 2-D Design</li><li>Studio Art: 3-D Design</li><li>Studio Art: Drawing</li></ul>English Language Arts<ul><li>English Lang/Comp</li><li>English Lit/Comp</li></ul>Foreign Languages<ul><li>Chinese Lang</li><li>French Lang</li><li>French Lit</li><li>German Lang</li><li>Italian Lang</li><li>Japanese Lang</li><li>Latin: Lit</li><li>Latin: Vergil</li><li>Spanish Lang</li><li>Spanish Lit</li></ul>History and Social Science<ul><li>Art History</li><li>Economics: Macro</li><li>Economics: Micro</li><li>Govt & Pol: Comp</li><li>Govt & Pol: U.S.</li><li>Govt RAD: Comp</li><li>Govt RAD: U.S.</li><li>History: European</li><li>History: U.S.</li><li>History: World</li><li>Human Geography</li><li>Psychology</li><li>World History: Modern</li></ul>Math and Computer Science<ul><li>Calculus AB</li><li>Calculus BC</li><li>Computer Sci A</li><li>Computer Sci AB</li><li>Computer Sci Principles</li><li>Statistics</li></ul>Science and Technology<ul><li>Biology</li><li>Chemistry</li><li>Environmental Sci</li><li>Physics 1</li><li>Physics 2</li><li>Physics B</li><li>Physics C: E</li><li>Physics C: E&M</li><li>Physics C: Mech</li></ul>Capstone<ul><li>Capstone Research</li><li>Capstone Seminar</li></ul>

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"educationtocareer-data-mass-gov/advanced-placement-ap-performance-787a-3wen\".\"advanced_placement_ap_performance\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.