29:null 2a:["$","title",null,{"children":"Secondary Schools Performance | TippyTappy | Observable"}] 2f:[{"id":"441e73abdf4a22d464e4043f3041ade53cc0866efa4e516fc3d2beb7edb857576c2a469a9232ce6dc6cc7d8204463c5d508c24d17ef71a8daa0bf4aba006c26f","href":"https://static.observableusercontent.com/files/441e73abdf4a22d464e4043f3041ade53cc0866efa4e516fc3d2beb7edb857576c2a469a9232ce6dc6cc7d8204463c5d508c24d17ef71a8daa0bf4aba006c26f","name":"secondary_schools_results.json","type":"application/json","lastModified":1729960581153.988,"size":20705580},{"id":"58c39241e06af483e06ba1c263cfc7e061d5e6e4696ef5483a75b14d8be0a336be08b0e5ca4ea684300a98577bbe1359fc495fd58008451d1a89b6991c1ad890","href":"https://static.observableusercontent.com/files/58c39241e06af483e06ba1c263cfc7e061d5e6e4696ef5483a75b14d8be0a336be08b0e5ca4ea684300a98577bbe1359fc495fd58008451d1a89b6991c1ad890","name":"performance_21_22.json","type":"application/json","lastModified":1684610921742.132,"size":10178491}] 2d:{"id":"d65648172da5ead6","slug":null,"title":"Secondary Schools Performance","thumbnail":"4dba647de14abe017cad169fec9f8d509528dd3d72510742c3d94793df7d055e","access_level":"public","create_time":"$D2023-05-11T09:29:40.956Z","update_time":"$D2025-10-10T15:25:33.824Z","view_time":null,"first_public_time":"$D2023-11-27T18:35:06.264Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"b5a2601d5822b2bf","login":"tippytappy","name":"TippyTappy","avatar_url":"https://avatars-next.observableusercontent.com/2e581c387148636bf3d1ea4f76c74bd4887af44015a37cef5d3790db542690ca","tier":"starter_2024"},"version":1154,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"aa0a3b8ae504ad9a","login":"tippytappy","name":"TippyTappy","avatar_url":"https://avatars-next.observableusercontent.com/2e581c387148636bf3d1ea4f76c74bd4887af44015a37cef5d3790db542690ca","tier":null}],"members":[{"type":"individual","id":"aa0a3b8ae504ad9a","login":"tippytappy","name":"TippyTappy","avatar_url":"https://avatars-next.observableusercontent.com/2e581c387148636bf3d1ea4f76c74bd4887af44015a37cef5d3790db542690ca","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Secondary Schools Performance","cells":[{"id":0,"value":"# Secondary Schools Performance\nThis notebook gives you a way to compare schools in your local area. In the UK there are two metrics which can be useful for that:\n\n**Attainment (A8)** is the level of achievement that students reach by the end of a specific stage, e.g. secondary school. Typically measured using standardized assessments, attainment metrics are a snapshot of how well students perform academically at a particular point in time.\n\n**Progress (P8)** measures a student's progress over a specific key stage. It considers their starting point and tracks development relative to their expected progress. Progress metrics are one way to assess the value schools add to students' learning journeys.\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":873,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":458,"value":"### Find schools in your area\nEnter a postcode and search radius to get a list of schools.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":844,"value":"viewof search_form = Inputs.form({\n postcode: Inputs.text({label: \"Postcode\", submit: true, value: \"RG2 0DJ\"}),\n radius: Inputs.range([1, 20], {label: \"Search radius (miles)\", step: 1, value: 5})\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":396,"value":"SELECT \n \"schname\", \"minorgroup\", \n \"gender\", \"relchar\", \"admpol\", \"ofstedrating\", \n ROUND(SQRT(POW(\"longitude\" - CAST(${position.lon} AS FLOAT), 2) + POW(\"latitude\" - CAST(${position.lat} AS FLOAT), 2)) * 69.0, 1) AS distance, \"a8_avg\", \"a8_avg_boy\", \"a8_avg_girl\",\n \"p8_avg_adjusted\", \"p8_avg_adj_boys\", \"p8_avg_adj_girls\",\n \"total_pupils\", \"pcnt_girls\", \"age_range\",\n \"street\", \"town\", \"postcode\", \"longitude\", \"latitude\",\n \"pcnt_further_edu\", \"pcnt_school_sixth_form\", \"pcnt_sixth_form_college\", \"pcnt_other_edu_dest\",\n RANDOM()\n FROM \"data\"\n WHERE isfinite(\"longitude\") AND SQRT(POW(\"longitude\" - CAST(${position.lon} AS FLOAT), 2) + POW(\"latitude\" - CAST(${position.lat} AS FLOAT), 2)) * 69.0 < ${search_form.radius}\nORDER BY \"a8_avg\" DESC NULLS LAST","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"local_data","database":"var:data"},{"id":574,"value":"
\n#### Compare performance\nLocal schools (black circles) are shown over all other UK schools (background circles). Hover on a school for more information or use the dropdown to highlight a particular school.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":691,"value":"viewof selected_school = Inputs.select(local_schools, {label: \"Highlight\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":808,"value":"

Attainment

\n ${performance_chart('a8_avg', 'Average attainment')}\n ${performance_chart('a8_avg_boy', 'Average attainment: boys')}\n ${performance_chart('a8_avg_girl', 'Average attainment: girls')}","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":892,"value":"

Progress

\n ${performance_chart('p8_avg_adjusted', 'Average progress')}\n ${performance_chart('p8_avg_adj_boys', 'Average progress: boys')}\n ${performance_chart('p8_avg_adj_girls', 'Average progress: girls')}","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":562,"value":"
\n#### Attainment by gender\nAttainment splits by boy/girl let us see whether there's a performance gap for a given school. \n_Note: single gender schools will only show the relevant value_","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1055,"value":"Plot.plot({\n marginLeft: 220,\n x: {grid: true, domain: [0, 100]},\n y: {grid: true, label: ''},\n marks: [\n //Plot.sort(local_data, {channel: \"schname\"}),\n Plot.ruleY(local_data, {x1: \"a8_avg_boy\", x2: \"a8_avg_girl\", y: \"schname\", \n stroke: \"grey\", strokeWidth: 2,\n sort: {y: \"-x\", reduce: \"max\"}}),\n Plot.dot(local_data, {x: \"a8_avg_boy\", y: \"schname\", r: 5, \n stroke: 'grey', strokeWidth: 2, fill: colours.boys}),\n Plot.dot(local_data, {x: \"a8_avg_girl\", y: \"schname\", r: 5, \n stroke: 'grey', strokeWidth: 2, fill: colours.girls})\n \n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":543,"value":"---\n### Notebook components","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":625,"value":"colours = ({\n boys: \"orange\",\n girls: \"lightgreen\",\n mixed: \"#d2c7e0\",\n context: \"lightblue\",\n context2: \"steelblue\",\n highlight: \"red\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":783,"value":"xJitter = d3.scaleLinear()\n .domain([0, local_schools.length])\n .range([0.95, 0.05])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":785,"value":"local_schools = Array.from(new Set(local_data.map(d => d.schname))).sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":159,"value":"position = {\n search_form.postcode;\n const t1 = performance.now();\n let result = await geocoding(search_form.postcode);\n if (result[0]) {\n result[0].time = performance.now() - t1;\n return result[0];\n } else return result;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":155,"value":"geocoding = (address, geo_bounds = [], number_result = 1) => {\n let viewbox =\n geo_bounds && geo_bounds[0] && geo_bounds[1]\n ? `&viewbox=${geo_bounds[0][0]},${geo_bounds[0][1]},${geo_bounds[1][0]},${geo_bounds[1][1]}`\n : \"\";\n return fetch(\n `https://nominatim.openstreetmap.org/search?q=${address}&format=json&limit=${number_result}${viewbox}`,\n { referrer: \"https://observablehq.com/@pierreleripoll/geocoding-nominatim\" }\n )\n .then((res) => {\n if (res.ok && res.json) {\n return res.json();\n } else {\n return {\n error: `Position not found for address = ${address}`\n };\n }\n })\n .catch((err) => {\n return { error: err };\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":130,"value":"map = {\n const container = yield htl.html`

`;\n const map = L.map(container).setView([position.lat, position.lon], 16);\n L.tileLayer(\"https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png\", {\n attribution: \"© OpenStreetMap contributors\"\n }).addTo(map);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":524,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":374,"value":"### The data\nThe table below shows the full 2021-22 data set for the UK. \n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":7,"value":"data = await FileAttachment(\"secondary_schools_results.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":664,"value":"function performance_chart(metric, label) {\n return Plot.plot({\n width: 300,\n height: 300,\n x: {ticks: false},\n y: {grid: true, label: label, domain: Array.from(metric)[0] == \"a\" ? [0, 100] : [-4.5, 2.5]},\n marks: [\n Plot.ruleY([0], {stroke: \"grey\"}),\n Plot.ruleY(data, Plot.groupZ({y: \"median\"}, {y: metric, stroke: colours.context})),\n Plot.textY([d3.median(data, d => d[metric]) + 0], {text: ['UK median'], fill: colours.context2}),\n Plot.dot(local_data, {x: (d, i) => xJitter(i), y: metric, r: 5, \n stroke: 'black', \n fill: d => d.schname == selected_school ? colours.highlight : colours.context,\n title: d => `${d.schname} \\n Attainment: ${d.a8_avg} \\n Progress: ${d.p8_avg_adjusted}`}),\n Plot.frame({stroke: 'grey'})\n ]\n})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1123,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2e:"$2d:body"