2b:null 2c:["$","title",null,{"children":"Grade standings DESIGN | 🪦 dv design 2026 spring | Observable"}] 31:T424,timeline = Plot.plot({ width: 900, height: 50, marginLeft: 0, r: {type: "identity"}, x: {type: "time", domain: [d3.utcParse(timeformat)(courseStarts), d3.utcDay.offset(d3.utcParse(timeformat)(courseEnds), 30)]}, marks: [ Plot.ruleY([0]), on(Plot.dot(timepoints, {x: d => d, y: 0, fill: "black", r: d => (d3.utcFormat(timeformat)(d) === time ? 10 : 5)}), { click: function (event, { datum }) { mutable time = d3.utcFormat(timeformat)(datum) d3.select(event.target) .attr("r", 10) }, pointerenter: function (event, { datum }) { d3.select(event.target) .transition().duration(100) .style("cursor", "pointer") .attr("r", 10) .style("fill", "brown"); }, pointerout: function (event, { datum }) { d3.select(event.target) .transition().duration(500) .style("cursor", "pointer") .attr("r", (d3.utcFormat(timeformat)(datum) === time ? 10 : 5)) .style("fill", null); } }) ] })32:Ta0c,chart = Plot.plot({ width: width, height: height, x: {domain: [0, 110], label: null}, y: {label: "Student", label: null}, style: {fontSize: "16px"}, marginRight: 50, legend: {marginBottom: 50}, color: {domain: allAssignmnets, range: colorRange, legend: true, width: 500, columns:1}, marks: [ Plot.text(gradeBoundaries, {x: "x", text: "grade", fontSize: "10px", textAnchor: "start", dx: 3, dy: -280}), Plot.text(gradeBoundaries, {x: "x", text: "grade", fontSize: "10px", textAnchor: "start", dx: 3, dy: 275}), Plot.ruleX([0, 30, 40, 50, 60, 63, 67, 70, 73, 77, 80, 83, 87, 90, 93, 100]), //BARS Plot.barX(tidydata.filter(f => f.points && f.assignment !== "total"), { x: "points", y: "emoji", fill: "assignment", stroke: "white", sort: {y: "-x"}, tip: true, title: d => d.emoji + " " + d.student + "\n\n" + d.assignment.split("(")[0] + "\n\nCurrent grade: " + d.points }), //NAMES Plot.text(tidydata.filter(f => f.assignment === "total"), { x: 0, y: "emoji", text: "student", textAnchor: "start", fill: "black", stroke: "white", strokeWidth: 3, fontSize: "14px", strokeOpacity: 0.4, paintOrder: "stroke", pointerEvents: "none", dx: 10 }), //FORECAST DUMBBELL showForecast ? Plot.link(tidydata.filter(f => f.assignment === "total"), { x1: forecastMin, x2: forecastMax, y1: d => d["emoji"], y2: d => d["emoji"], markerEnd: "dot", markerStart: "dot", strokeWidth: 2, stroke: "black" }) : null, //FORECAST TEXT showForecast ? Plot.text(tidydata.filter(f => f.assignment === "total"), { x: forecastMin, y: "emoji", text: d => d["points"] === d3.max(tidydata, a => a.points) ? "FORECAST low & high": "", textAnchor: "start", dx: 5, dy: -10, stroke: "white", strokeWidth: 4, fontSize: "10px", paintOrder: "stroke", fill: "black", }) : null, //TOTAL Plot.text(tidydata.filter(f => f.assignment === "total"), { x: "points", y: "emoji", text: (d) => d3.format(".1f")(d.points), textAnchor: "start", fill: "black", stroke: "white", strokeWidth: 3, fontSize: "16px", paintOrder: "stroke", dx: 4 }), //MEME Plot.image(tidydata.slice(0,1), { x: width, y: "emoji", dy: -9, dx: 3, width: 200, src: "https://i.redd.it/1o8zqjm9bqc81.png" }) ] })33:[{"id":"451ff6944279c751038b6f310db0779bd73e71a322ea4d720a6065a39a4f55697bd893693bfb994d26a0159b48310481b58ce31c62f180fda2e7c9d833448f9e","href":"https://static.observableusercontent.com/files/451ff6944279c751038b6f310db0779bd73e71a322ea4d720a6065a39a4f55697bd893693bfb994d26a0159b48310481b58ce31c62f180fda2e7c9d833448f9e","name":"2026-05-28T1459_Grades-2602046___Data_Visualization.csv","type":"text/csv","lastModified":1779973323693.103,"size":9203},{"id":"d59eb4cd42f4c49a98ab5ed9dd8fb01a91349fc4d3decf30cbe92fd7099d8f08fb34917185d2d3eed0de5cc24b1467eec210e40c462878a742231b47a1810a99","href":"https://static.observableusercontent.com/files/d59eb4cd42f4c49a98ab5ed9dd8fb01a91349fc4d3decf30cbe92fd7099d8f08fb34917185d2d3eed0de5cc24b1467eec210e40c462878a742231b47a1810a99","name":"allquizzes.csv","type":"text/csv","lastModified":1769028485803.795,"size":2107},{"id":"162d2b7e46e89a868f1280de42123386e695d5cadf5c78f4ff9f34f6c96dae0b7e9becac424e607cca753f4c8a950e7906925e65a4270304b93ab9d3eb9953b3","href":"https://static.observableusercontent.com/files/162d2b7e46e89a868f1280de42123386e695d5cadf5c78f4ff9f34f6c96dae0b7e9becac424e607cca753f4c8a950e7906925e65a4270304b93ab9d3eb9953b3","name":"2026-02-09T0939_Grades-2602046___Data_Visualization.csv","type":"text/csv","lastModified":1770626503082.29,"size":7073},{"id":"c1f2431b81c499949b1e9814a46baf009511396053f549f399dfb532d11c05bb0776395cb96f8cefe36c8de81fafc36e4d8d95252f690915664cd5ec027282c8","href":"https://static.observableusercontent.com/files/c1f2431b81c499949b1e9814a46baf009511396053f549f399dfb532d11c05bb0776395cb96f8cefe36c8de81fafc36e4d8d95252f690915664cd5ec027282c8","name":"2026-03-05T0915_Grades-2602046___Data_Visualization.csv","type":"text/csv","lastModified":1772698705261.684,"size":7930},{"id":"634660551328cb43490022847f601fadb72eae2c295920b34f5dab636a05926c2a0653cb27eb0d0ba05cb98e0818b91d75716f6ce7a176dd69f7c74f442f8467","href":"https://static.observableusercontent.com/files/634660551328cb43490022847f601fadb72eae2c295920b34f5dab636a05926c2a0653cb27eb0d0ba05cb98e0818b91d75716f6ce7a176dd69f7c74f442f8467","name":"2026-03-09T0945_Grades-2602046___Data_Visualization.csv","type":"text/csv","lastModified":1773046015579.241,"size":8011},{"id":"40c3df3edb3300c23212271d6010b3db83f03d45fd7431e3bb0bdd4416c43de0185e42d5a50d3e04975af050b36504ce12ed4d46d764f33e7550279959bb872e","href":"https://static.observableusercontent.com/files/40c3df3edb3300c23212271d6010b3db83f03d45fd7431e3bb0bdd4416c43de0185e42d5a50d3e04975af050b36504ce12ed4d46d764f33e7550279959bb872e","name":"2026-04-16T1136_Grades-2602046___Data_Visualization.csv","type":"text/csv","lastModified":1776332307287.674,"size":8377},{"id":"1a978818a449c50fec3453e69d79b6494fd95935a5847eb6838bdec6396ed8e366383e3f4788a28f720c0e363264197f985da29fd08d8d752bb084ddc675427e","href":"https://static.observableusercontent.com/files/1a978818a449c50fec3453e69d79b6494fd95935a5847eb6838bdec6396ed8e366383e3f4788a28f720c0e363264197f985da29fd08d8d752bb084ddc675427e","name":"2026-05-06T0037_Grades-2602046___Data_Visualization.csv","type":"text/csv","lastModified":1778020739720.194,"size":8537},{"id":"72dc3100e31320d856fdcd0fd58696b7ab2ca77d04221a84ab1f21bd3e438baaf0a9c5287ad64a6b8f8f90feec6e178197e03a1fb825dcd9850c3d09bac36adc","href":"https://static.observableusercontent.com/files/72dc3100e31320d856fdcd0fd58696b7ab2ca77d04221a84ab1f21bd3e438baaf0a9c5287ad64a6b8f8f90feec6e178197e03a1fb825dcd9850c3d09bac36adc","name":"2026-05-14T0037_Grades-2602046___Data_Visualization.csv","type":"text/csv","lastModified":1778711896158.839,"size":9145},{"id":"bdf01b846db8efe02cb4e7d3f72850d028baea19bcbde19086766cf6aac43a7e6b522c31842f67077c0802ae8d078e077c5b23c9c5ca974b389b78effecf9051","href":"https://static.observableusercontent.com/files/bdf01b846db8efe02cb4e7d3f72850d028baea19bcbde19086766cf6aac43a7e6b522c31842f67077c0802ae8d078e077c5b23c9c5ca974b389b78effecf9051","name":"2026-05-14T1527_Grades-2602046___Data_Visualization.csv","type":"text/csv","lastModified":1778765284475.102,"size":9198}] 2f:{"id":"453aac4cbddb716c","slug":"grade-standings","title":"Grade standings DESIGN","thumbnail":"5ed03e13fb473f262d5d67c617f4b3aa90dd80601010af45bb24141345e4ba86","access_level":"public","create_time":"$D2026-01-21T20:48:05.803Z","update_time":"$D2026-05-28T13:02:48.265Z","view_time":null,"first_public_time":"$D2026-05-29T09:49:53.285Z","fork":{"id":"e212a8a69c4d110e","slug":"grade-standings-design","title":"Grade standings DESIGN","owner":{"id":"e9b2f7fde85a5f53","login":"dis-2025-fall","name":"🪦 dis-2025-fall"}},"stars":1,"starred":false,"owner":{"type":"team","id":"e73bb746871f7c8a","login":"dv-design-2026s","name":"🪦 dv design 2026 spring","avatar_url":"https://avatars-next.observableusercontent.com/4dab7780a17504486f7c5b299e4ca5077bba85e8adfaadc147cf0461b3ee93ad","tier":"pro_2024"},"version":1378,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"1245953aabb247aa","login":"angiehjort","name":"Angie Hjort","avatar_url":"https://avatars-next.observableusercontent.com/d3c0d6d22f1525b9f9f1d4c8187de1dc20adc65c5baeb538c15672fb523883fa","tier":null}],"members":[{"type":"individual","id":"1245953aabb247aa","login":"angiehjort","name":"Angie Hjort","avatar_url":"https://avatars-next.observableusercontent.com/d3c0d6d22f1525b9f9f1d4c8187de1dc20adc65c5baeb538c15672fb523883fa","tier":null,"role":"editor"},{"type":"team","id":"e73bb746871f7c8a","login":"dv-design-2026s","name":"🪦 dv design 2026 spring","avatar_url":"https://avatars-next.observableusercontent.com/4dab7780a17504486f7c5b299e4ca5077bba85e8adfaadc147cf0461b3ee93ad","tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Grade standings DESIGN","cells":[{"id":0,"value":"# Grade standings DESIGN","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":448,"value":"lastUpdate = Object.keys(files).at(-1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"Click dots to see grade status and forecast at different snapshots. \nThe ranking changes every time, and there is no way to automatically track how each student moves up and down, but it would be cool :D","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":605,"value":"The forecast is available after 50% of the course has passed. Forecast is just a guess in the form of \"if the current trend continues\". It takes the percentage of course completion (${percentCourseComplete}%) and computes the base value proportionally to each student's current number of points. It assumes the remaining points for the group project come at the very end so then adds 0 for lower and 10 for higher estimate to the base value.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":293,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"mutable time = lastUpdate","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":395,"value":"percentCourseComplete = {\n const elapsed = d3.timeDays(d3.utcParse(timeformat)(courseStarts), d3.utcParse(timeformat)(time)).length; \n const total = d3.timeDays(d3.utcParse(timeformat)(courseStarts), d3.utcParse(timeformat)(courseEnds)).length; \n return Math.min(Math.round(elapsed/total * 100),100); \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":660,"value":"showForecast = 50 <= percentCourseComplete && percentCourseComplete <= 95","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":759,"value":"attendancePoints = 27","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":755,"value":"forecastMin = (d) => (d[\"points\"] - attendancePoints) * forecastFactor + groupProjectMin + attendancePoints","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":762,"value":"forecastMax = (d) => (d[\"points\"] - attendancePoints) * forecastFactor + groupProjectMax + attendancePoints","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":655,"value":"gradeBoundaries = [\n {x: 0, grade: \"F\"},\n {x: 60, grade: \"D-\"},\n {x: 63, grade: \"D\"},\n {x: 67, grade: \"D+\"},\n {x: 70, grade: \"C-\"},\n {x: 73, grade: \"C\"},\n {x: 77, grade: \"C+\"},\n {x: 80, grade: \"B-\"},\n {x: 83, grade: \"B\"},\n {x: 87, grade: \"B+\"},\n {x: 90, grade: \"A-\"},\n {x: 93, grade: \"A\"},\n {x: 100, grade: \"A+\"},\n ]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":252,"value":"// a trick to move the legend below the chart and flip the image\n{\n d3.select(chart).select(\"div\").raise();\n d3.select(chart).select(\"svg\").selectAll(\"image\")\n .attr(\"transform\",\"scale(-1,1)\")\n .attr(\"x\", -width+20)\n .attr(\"y\", height-240)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":589,"value":"width = 928\n ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":590,"value":"height = 600","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":399,"value":"courseStarts = \"2026-01-15T0000\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":392,"value":"courseEnds = \"2026-05-15T0000\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":418,"value":"forecastFactor = 100/percentCourseComplete","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":453,"value":"groupProjectMin = 3","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"groupProjectMax = 10","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"files = ({\n \"2026-02-09T0939\": FileAttachment(\"2026-02-09T0939_Grades-2602046___Data_Visualization.csv\").csv({typed: true}),\n \"2026-03-05T0915\": FileAttachment(\"2026-03-05T0915_Grades-2602046___Data_Visualization.csv\").csv({typed: true}),\n \"2026-03-09T0945\": FileAttachment(\"2026-03-09T0945_Grades-2602046___Data_Visualization.csv\").csv({typed: true}),\n \"2026-04-16T1136\": FileAttachment(\"2026-04-16T1136_Grades-2602046___Data_Visualization.csv\").csv({typed: true}),\n \"2026-05-06T0037\": FileAttachment(\"2026-05-06T0037_Grades-2602046___Data_Visualization.csv\").csv({typed: true}),\n \"2026-05-13T0037\": FileAttachment(\"2026-05-14T0037_Grades-2602046___Data_Visualization.csv\").csv({typed: true}),\n \"2026-05-14T1527\": FileAttachment(\"2026-05-14T1527_Grades-2602046___Data_Visualization.csv\").csv({typed: true}),\n \"2026-05-28T1459\": FileAttachment(\"2026-05-28T1459_Grades-2602046___Data_Visualization.csv\").csv({typed: true}),\n\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":318,"value":"timeformat = \"%Y-%m-%dT%H%M\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":278,"value":"timepoints = Object.keys(files).map(m => d3.utcParse(timeformat)(m))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"loadPromise = Promise.all(Object.values(files))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"data = loadPromise[Object.keys(files).indexOf(time)]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"columns = data.columns\n .filter(f => excludeColumnsContaining.every(s => !f.includes(s)) && excludeColumnsEqualTo.every(s => f !== s)) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":710,"value":"allAssignmnets = columns.filter(f => f!==\"name\" && f!==\"emoji\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"excludeColumnsContaining = [\" Score\", \" ID\", \" Grade\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"excludeColumnsEqualTo = [\"ID\", \"Student\", \"Section\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":811,"value":"tidydata = applyDataTransformations(data);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"applyDataTransformations = function(data) {\n const data2 = data.slice(1)\n //remove \"test student\"\n .filter(f => f[\"name\"] !== \"Points Possible\" && !!f[\"name\"])\n //remove unnecessary columns\n .map(m => filterObjectProps(m, columns))\n //add a total score\n .map((m, i) => {m.total = d3.sum(Object.values(m).map(m => m || 0)); return m;})\n\n //unpivot the data table (derp derp, there should be a better way to do that)\n const result = []\n for (let student of data2) {\n for (let assignment of Object.keys(student).filter(f => f!==\"name\" && f!==\"emoji\")) {\n result.push({student: student.name, emoji: student.emoji, assignment, points: student[assignment]})\n }\n }\n return result\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":136,"value":"d3.select(chart)\n .append(\"svg:style\")\n .text(`\n rect:hover {stroke-width: 3px; stroke: black;}\n `)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"colorRange = allAssignmnets.map(m => m.slice(0,2))\n .map(m => {\n switch (m) {\n case \"⚪️\": return \"#aaa\";\n case \"🟢\": return \"#41f71d\";\n case \"🟠\": return \"#ff9838\";\n case \"⚫️\": return \"#222\";\n case \"🟤\": return \"#996100\";\n case \"🔴\": return \"#ff1a1a\";\n case \"🟣\": return \"#a64dff\";\n case \"🔵\": return \"#3d77ff\"; \n }\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"filterObjectProps = function(raw, allowed) { \n return Object.keys(raw)\n .filter(key => allowed.includes(key))\n .reduce((obj, key) => {\n obj[key] = raw[key];\n return obj;\n }, {});\n }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":309,"value":"import {on} from \"@fil/plot-onclick-experimental-plugin\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1199,"value":"

${quizChart1}

${quizChart2}

","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":925,"value":"quizChart1 = Plot.plot({\n width: 800,\n height: 300,\n marginRight: 5,\n marginTop: 25,\n marginLeft: 5,\n marginBottom: 50,\n color: {legend: true, domain: [\"past students, n=\" + totalNPreviousStudents], range: [\"#ddd\"]},\n style: {fontSize: \"16px\"},\n fx: {domain: quizzes, label: null, padding: 0.15},\n x: {domain: [0,5], tickSpacing: 40, label: \"Quiz score\"},\n y: {label: null, ticks: false},\n marks: [\n Plot.gridX({interval: 0.5, stroke: \"black\", strokeOpacity: 0.5, strokeWidth: 0.5}),\n Plot.rectY(\n allQuizzesEver.filter(f => f.date < new Date(\"2024-12-01\")),\n Plot.binX({y: \"count\"}, {interval: 0.2, fx: \"assignment\", x: \"points\", fill: \"#ddd\"})\n ),\n Plot.frame(),\n Plot.text(\n tidydata\n .filter(f => f.assignment.includes(\"🟣\"))\n .map(m => ({...m, assignment: quizNameMapping[m.assignment]})),\n Plot.dodgeY({x: \"points\", fx: \"assignment\", r: 12, text: \"emoji\", title: d=>d.student + \" \" + d.points, tip: true, fontSize: 20})\n ),\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1120,"value":"currentStudnetsSumPointsForQuizzes = [...d3.rollup(\n tidydata.filter(f => f.assignment.includes(\"🟣\")),\n v => ({...v[0], assignment: \"All quizzes sum\", points: d3.sum(v, d => d.points)}),\n d => d.student\n).values()]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1170,"value":"quizChart2 = Plot.plot({\n width: 280,\n height: 300,\n marginTop: 25,\n marginRight: 5,\n marginLeft: 5,\n marginBottom: 50,\n color: {legend: true, domain: [\"past students, n=\" + totalNPreviousStudents], range: [\"#ddd\"]},\n style: {fontSize: \"16px\"},\n fx: {label: null, padding: 0},\n x: {domain: [4,15], tickSpacing: 40, label: \"Quiz score\"},\n y: {label: null, ticks: false},\n marks: [\n Plot.gridX({interval: 1, stroke: \"black\", strokeOpacity: 0.5, strokeWidth: 0.5}),\n Plot.rectY(\n allStudnetsSumPointsForQuizzes.filter(f => f.date < new Date(\"2024-12-01\")),\n Plot.binX({y: \"count\"}, {interval: 0.4, fx: \"assignment\", x: \"points\", fill: \"#ddd\"})\n ),\n Plot.frame(),\n Plot.text(\n currentStudnetsSumPointsForQuizzes,\n Plot.dodgeY({x: \"points\", fx: \"assignment\", r: 12, text: \"emoji\", title: d=>d.student + \" \" + d.points, tip: true, fontSize: 20})\n ),\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1155,"value":"allStudnetsSumPointsForQuizzes = allQuizzesRaw\n .map(d => ({ date: d.date, \"assignment\": \"All quizzes sum\", \"points\": d3.sum(quizzes.map(m => d[m])) }))\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1083,"value":"totalNPreviousStudents = allQuizzesRaw.filter(f => f.date < new Date(d3.utcParse(timeformat)(courseStarts))).length ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":997,"value":"allQuizzesRaw = FileAttachment(\"allquizzes.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":999,"value":"allQuizzesEver = aq.from(allQuizzesRaw)\n .fold(allQuizzesRaw.columns.slice(1)) \n .rename({key: \"assignment\", value: \"points\"})\n .objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1021,"value":"quizzes = [\"🟣 „uɐɯnɥ ʎɹǝʌ sı uƃısǝp ǝɥ⊥„\", \"🟣 Data Transformations and Peculiarities\", \"🟣 Perception quiz\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1002,"value":"quizNameMapping = Object.fromEntries( allAssignmnets.filter(f => f.includes(\"🟣\")).map((m,i) => ([m, quizzes[i]])))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 30:"$2f:body"