28:null 29:["$","title",null,{"children":"Untitled | Mia Davis | Observable"}] 2e:T557,{ // Calculate percentages for each institution const pieResults = [ "University of Hawai`i - West O`ahu", "University of Hawai`i at Manoa" ].map(campus => { const rows = ageSummary.filter( d => d.campus === campus ); const older = rows.find( d => d.ageGroup === "45+ years" ).enrollment; const younger = rows.find( d => d.ageGroup === "Under 45 years" ).enrollment; const total = older + younger; return { name: campus.includes("West O`ahu") ? "West Oahu" : "Manoa", olderPercent: (older / total) * 100 }; }); display(html`

${pieResults.map(d => html`

${d.name}

${d.olderPercent.toFixed(1)}% age 45+

${(100 - d.olderPercent).toFixed(1)}% under 45

`)}

`); } 2f:[{"id":"9a8d9eb82d624a524eeb2ec54c2a485459bcdbe63f4bed91ba4ad5dbca07280b10df89d7e6813dcde8bc55e99c1ca468d165ef171717f8308674771a8b605d9b","href":"https://static.observableusercontent.com/files/9a8d9eb82d624a524eeb2ec54c2a485459bcdbe63f4bed91ba4ad5dbca07280b10df89d7e6813dcde8bc55e99c1ca468d165ef171717f8308674771a8b605d9b","name":"292575da-41cc-4f03-8012-5c1a8743fc74.csv","type":"text/csv","lastModified":1790376109000,"size":80719}] 2c:{"id":"11885e7d8604804d","slug":"untitled","title":"","thumbnail":"5e5a2eb8058818c0ebe66647575a1e86314017b10e41abfd49322f1f6e6cf41d","access_level":"public","create_time":"$D2026-09-25T22:18:33.022Z","update_time":"$D2026-09-25T23:10:51.772Z","view_time":null,"first_public_time":"$D2026-09-25T23:12:18.850Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"d93a73473c9722da","login":"miadavis","name":"Mia Davis","avatar_url":null,"tier":"free_2026"},"version":67,"publish_version":67,"role":null,"authored":false,"authors":[{"type":"individual","id":"269356153a32ef92","login":"miadavis","name":"Mia Davis","avatar_url":null,"tier":null}],"members":[{"type":"team","id":"d93a73473c9722da","login":"miadavis","name":"Mia Davis","avatar_url":null,"tier":"free_2026","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"$undefined","cells":[{"id":1,"value":"# Untitled","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"const enrollment = await FileAttachment(\n \"292575da-41cc-4f03-8012-5c1a8743fc74.csv\"\n).csv({typed: true});\n\ndisplay(enrollment);","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"display(Object.keys(enrollment[0]));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"const schools = [\n \"University of Hawai`i at Manoa\",\n \"University of Hawai`i - West O`ahu\"\n];\n\n// Keep only the two schools and years 2010-2024\nconst filteredEnrollment = enrollment.filter(d => {\n const year = Number(d.SEMESTER.replace(\"Fall \", \"\"));\n\n return schools.includes(d.CAMPUS) &&\n year >= 2010 &&\n year <= 2024;\n});\n\ndisplay(filteredEnrollment);","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"const schools = [\n \"University of Hawai`i at Manoa\",\n \"University of Hawai`i - West O`ahu\"\n];\n\n// Keep only the two schools and years 2010-2024\nconst filteredEnrollment = enrollment.filter(d => {\n const year = Number(d.SEMESTER.replace(\"Fall \", \"\"));\n\n return schools.includes(d.CAMPUS) &&\n year >= 2010 &&\n year <= 2024;\n});\n\ndisplay(filteredEnrollment);","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"const campusNames = [...new Set(enrollment.map(d => d.CAMPUS))];\n\ndisplay(campusNames);","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"const schools = [\n \"University of Hawai`i at Manoa\",\n \"University of Hawai`i - West O`ahu\"\n];\n\n// Keep only the two selected schools\nconst selectedData = enrollment.filter(d =>\n schools.includes(d.CAMPUS)\n);\n\n// Add together all age groups for each school and semester\nconst yearlyEnrollment = d3.flatRollup(\n selectedData,\n rows => d3.sum(rows, d => d[\"COUNT(1)\"]),\n d => d.SEMESTER,\n d => d.CAMPUS\n).map(([semester, campus, total]) => ({\n semester: semester,\n year: Number(semester.replace(\"Fall \", \"\")),\n campus: campus,\n enrollment: total\n}));\n\n// Keep only 2010 through 2024\nconst enrollment2010to2024 = yearlyEnrollment\n .filter(d => d.year >= 2010 && d.year <= 2024)\n .sort((a, b) => a.year - b.year);\n\ndisplay(enrollment2010to2024);","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"display(\n Plot.plot({\n title: \"Fall Enrollment Trends from 2010-2024\",\n\n x: {\n label: \"Year\",\n tickFormat: d3.format(\"d\")\n },\n\n y: {\n label: \"Total Enrollment\",\n grid: true\n },\n\n color: {\n legend: true\n },\n\n marks: [\n Plot.line(\n enrollment2010to2024,\n {\n x: \"year\",\n y: \"enrollment\",\n stroke: \"campus\"\n }\n ),\n\n Plot.dot(\n enrollment2010to2024,\n {\n x: \"year\",\n y: \"enrollment\",\n fill: \"campus\",\n r: 4\n }\n )\n ]\n })\n);","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"Data wrangling\nThe enrollment data was filtered to include the University of Hawaiʻi at Manoa and the University of Hawaiʻi West Oʻahu. The enrollment counts for all age groups were then added together for each institution and semester. This gives the total enrollment for each institution regardless of age. The data was limited to the years 2010 through 2024 and sorted by year.\n","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"Design choices\nI chose a line chart because it clearly shows how enrollment changes over time. Each institution has its own line, which makes it easier to compare their enrollment trends from 2010 through 2024. Points were added for each year so that the individual yearly observations are also visible. The graph includes a title, labeled axes, a legend, and gridlines to make the data easier to read.","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"Enrollment trends\nMānoa's enrollment decreased from 2010 until around 2019, then began increasing again through 2024. West Oʻahu's enrollment generally increased from 2010 through the late 2010s and then slightly decreased in the following years. Important changes could be emphasized on the graph by highlighting certain years, such as the period around COVID-19.","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"// Separate students into 45+ and under 45\nconst ageData = selectedData.map(d => ({\n campus: d.CAMPUS,\n\n ageGroup:\n d.AGE_GROUP === \"45-59 yrs\" ||\n d.AGE_GROUP === \"60+ yrs\"\n ? \"45+ years\"\n : \"Under 45 years\",\n\n enrollment: d[\"COUNT(1)\"]\n}));\n\n// Add enrollment across all years\nconst ageSummary = d3.flatRollup(\n ageData,\n rows => d3.sum(rows, d => d.enrollment),\n d => d.campus,\n d => d.ageGroup\n).map(([campus, ageGroup, enrollment]) => ({\n campus: campus,\n ageGroup: ageGroup,\n enrollment: enrollment\n}));\n\ndisplay(ageSummary);","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"{\n // Calculate the proportion for each age group\n const ageProportions = ageSummary.map(d => {\n\n const total = d3.sum(\n ageSummary.filter(x => x.campus === d.campus),\n x => x.enrollment\n );\n\n return {\n campus: d.campus,\n ageGroup: d.ageGroup,\n proportion: d.enrollment / total\n };\n });\n\n // Keep only students who are 45 or older\n const olderStudents = ageProportions.filter(\n d => d.ageGroup === \"45+ years\"\n );\n\n // Create the graph\n display(\n Plot.plot({\n title: \"Percentage of Students Age 45 and Older\",\n\n x: {\n label: \"Institution\"\n },\n\n y: {\n label: \"Percent Age 45+\",\n percent: true,\n grid: true\n },\n\n marks: [\n Plot.barY(olderStudents, {\n x: \"campus\",\n y: \"proportion\"\n }),\n\n Plot.text(olderStudents, {\n x: \"campus\",\n y: \"proportion\",\n text: d => d3.format(\".1%\")(d.proportion),\n dy: -10\n })\n ]\n })\n );\n}\n","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"$2e","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"I used a bar chart and pie charts to show the proportion of students age 45 and older. The bar chart makes it easy to compare the percentage of older students between the two institutions. The pie charts show how the older student population compares with the under 45 population within each institution.","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"West Oʻahu has a higher proportion of students age 45 and older. About 7.6% of its enrollment is age 45 or older, compared with about 4.0% at Mānoa. At both institutions, the majority of students are under 45. Of the two chart types, I think the bar chart works better for comparing the institutions because the difference between 7.6% and 4.0% is easier to see.","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2f","stdlib":"2","titling":"auto"}} 2d:"$2c:body"