2b:null 2c:["$","title",null,{"children":"Grade standings DESIGN | 🪦 dis-2025-fall | 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:T571,files = ({ "2025-09-01T0944": FileAttachment("2025-09-01T0944_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-09-18T0954": FileAttachment("2025-09-18T0954_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-10-01T1005": FileAttachment("2025-10-01T1005_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-10-23T0833": FileAttachment("2025-10-23T0833_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-10-31T2311": FileAttachment("2025-10-31T2311_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-11-17T0821": FileAttachment("2025-11-17T0821_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-11-24T1039": FileAttachment("2025-11-24T1039_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-12-01T0923": FileAttachment("2025-12-01T0923_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-12-02T0843": FileAttachment("2025-12-02T0843_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-12-10T1224": FileAttachment("2025-12-10T1224_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-12-11T1047": FileAttachment("2025-12-11T1047_Grades-2504046___Data_Visualization.csv").csv({typed: true}), "2025-12-30T0049": FileAttachment("2025-12-30T0049_Grades-2504046___Data_Visualization.csv").csv({typed: true}), })34:[{"id":"57ae20a9811715468226484b86988aa8329c91b7309a5eb13a29f89ec54708ac90fcd848396474b7d15aa6defb88750f10bd41dd0be9b01a5c74bcb439a1e871","href":"https://static.observableusercontent.com/files/57ae20a9811715468226484b86988aa8329c91b7309a5eb13a29f89ec54708ac90fcd848396474b7d15aa6defb88750f10bd41dd0be9b01a5c74bcb439a1e871","name":"2025-09-18T0954_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1758182113699.664,"size":6105},{"id":"ce01225faac69ba4e5e3c28b78da4b9b6e022db54025da4fc9f13dc374d924ea47e3727da08bf31582cdc815075e6986721c314fd9b2472d0b6cf1bb808b90fd","href":"https://static.observableusercontent.com/files/ce01225faac69ba4e5e3c28b78da4b9b6e022db54025da4fc9f13dc374d924ea47e3727da08bf31582cdc815075e6986721c314fd9b2472d0b6cf1bb808b90fd","name":"2025-09-01T0944_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1756719099865.566,"size":5714},{"id":"8c8793f5defb877003d89801b1cbfa201907363bb4083c834958c8c553d964a942f246ed9740046c23da4cb0db8a5dec9be1e19641e2dd3b95511d705fba2842","href":"https://static.observableusercontent.com/files/8c8793f5defb877003d89801b1cbfa201907363bb4083c834958c8c553d964a942f246ed9740046c23da4cb0db8a5dec9be1e19641e2dd3b95511d705fba2842","name":"2025-10-01T1005_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1759306044039.88,"size":6229},{"id":"fee87228d4f93a6a70a0116508012f7e5558b68cd791fc5193f9e6f62dacd5ba5bbd0fb96ca8b078f007413762c5803c8381a2bf6ed847b29f2b4e8cf52f8eca","href":"https://static.observableusercontent.com/files/fee87228d4f93a6a70a0116508012f7e5558b68cd791fc5193f9e6f62dacd5ba5bbd0fb96ca8b078f007413762c5803c8381a2bf6ed847b29f2b4e8cf52f8eca","name":"2025-10-23T0833_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1761201293113.297,"size":6397},{"id":"d59eb4cd42f4c49a98ab5ed9dd8fb01a91349fc4d3decf30cbe92fd7099d8f08fb34917185d2d3eed0de5cc24b1467eec210e40c462878a742231b47a1810a99","href":"https://static.observableusercontent.com/files/d59eb4cd42f4c49a98ab5ed9dd8fb01a91349fc4d3decf30cbe92fd7099d8f08fb34917185d2d3eed0de5cc24b1467eec210e40c462878a742231b47a1810a99","name":"allquizzes.csv","type":"text/csv","lastModified":1761947774364.509,"size":2107},{"id":"1f67f8cc1ac962e50a0043e3109e2f171c968e4e142f850e71145d7e3f99096aa9e3d382280502ef76ddfcc58e4a9459252b3df78e62b6f028e5cebc4ab274dd","href":"https://static.observableusercontent.com/files/1f67f8cc1ac962e50a0043e3109e2f171c968e4e142f850e71145d7e3f99096aa9e3d382280502ef76ddfcc58e4a9459252b3df78e62b6f028e5cebc4ab274dd","name":"2025-10-31T2311_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1761948739122.58,"size":6515},{"id":"5fb4932a64b1b307985dfd7d5779f48f32f7cd18ec8ba5630b3933c5e4f477b70df5507daf4eaf174ced9835012c19989eff1a266e0a5d9125c5b308059a8945","href":"https://static.observableusercontent.com/files/5fb4932a64b1b307985dfd7d5779f48f32f7cd18ec8ba5630b3933c5e4f477b70df5507daf4eaf174ced9835012c19989eff1a266e0a5d9125c5b308059a8945","name":"2025-11-17T0821_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1763364221002.296,"size":6609},{"id":"533e8b8ea92feb56d75e29e1aabbb7a5af8869b26ae019bf6b9ebea421798ff627b8f5b70c13992f6dd4727179b2cd9145ddcfc8649fe4309d8cf26e03345b1b","href":"https://static.observableusercontent.com/files/533e8b8ea92feb56d75e29e1aabbb7a5af8869b26ae019bf6b9ebea421798ff627b8f5b70c13992f6dd4727179b2cd9145ddcfc8649fe4309d8cf26e03345b1b","name":"2025-11-24T1039_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1763977222757.767,"size":6843},{"id":"539bb73d09f73b0b8e78c1e7bffbd6f3ce884836e031319d89ea4583a8811117a2af416e13737bb3785871597bb8952a9cdc832665ce6892e98a3b2e8689765a","href":"https://static.observableusercontent.com/files/539bb73d09f73b0b8e78c1e7bffbd6f3ce884836e031319d89ea4583a8811117a2af416e13737bb3785871597bb8952a9cdc832665ce6892e98a3b2e8689765a","name":"2025-12-01T0923_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1764577447196.707,"size":6839},{"id":"5d8bb21d58a16ac4d96e1b131fd51d0ed2769aa4fa7d4213da95d11cb2a5cfe63229f9cebffb1435a49590a665e0b95aa3020c4c58cd63670af51907375d8b27","href":"https://static.observableusercontent.com/files/5d8bb21d58a16ac4d96e1b131fd51d0ed2769aa4fa7d4213da95d11cb2a5cfe63229f9cebffb1435a49590a665e0b95aa3020c4c58cd63670af51907375d8b27","name":"2025-12-02T0843_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1764661442172.795,"size":6847},{"id":"2b97e014d7facbcf0c3c5b8c26bf0c2888fc5774b639b4bfd3b5a3b0f7ba6408f6e006f1f09d962850e6bf9231e24798a6b113fff73594aa369a8fe9e5b470c7","href":"https://static.observableusercontent.com/files/2b97e014d7facbcf0c3c5b8c26bf0c2888fc5774b639b4bfd3b5a3b0f7ba6408f6e006f1f09d962850e6bf9231e24798a6b113fff73594aa369a8fe9e5b470c7","name":"2025-12-10T1224_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1765365945303.552,"size":6850},{"id":"40970a21f6e09850d166511fe4db9b0f89c4c2b4fdf345ff0dae90b40b1648cdccc1e7482dfd69d25d98f2e71fd5f6420026d97c6953b5af052cdabaa8d5b95d","href":"https://static.observableusercontent.com/files/40970a21f6e09850d166511fe4db9b0f89c4c2b4fdf345ff0dae90b40b1648cdccc1e7482dfd69d25d98f2e71fd5f6420026d97c6953b5af052cdabaa8d5b95d","name":"2025-12-11T1047_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1765446674001.12,"size":6858},{"id":"f61653ab78642425167425e8f15cdb0f0bcaa59984743c69d4d574c74ca86f543ee9fd5b7f0e54ed81506e012cb70a6498fad38343cad538a67425b01c439b88","href":"https://static.observableusercontent.com/files/f61653ab78642425167425e8f15cdb0f0bcaa59984743c69d4d574c74ca86f543ee9fd5b7f0e54ed81506e012cb70a6498fad38343cad538a67425b01c439b88","name":"2025-12-30T0049_Grades-2504046___Data_Visualization.csv","type":"text/csv","lastModified":1767052205355.247,"size":6460}] 2f:{"id":"e212a8a69c4d110e","slug":"grade-standings-design","title":"Grade standings DESIGN","thumbnail":"4bf208000a604eae74ea5ac8a1ca3e901352a647ab22ca68b809c1bd5d25a4fc","access_level":"public","create_time":"$D2025-09-01T09:30:53.334Z","update_time":"$D2025-12-29T23:50:31.045Z","view_time":null,"first_public_time":"$D2025-09-01T09:36:33.066Z","fork":{"id":"1f6e3e7959d07936","slug":"grade-standings-dev","title":"Grade standings DEV","owner":{"id":"e9b2f7fde85a5f53","login":"dis-2025-fall","name":"🪦 dis-2025-fall"}},"stars":0,"starred":false,"owner":{"type":"team","id":"e9b2f7fde85a5f53","login":"dis-2025-fall","name":"🪦 dis-2025-fall","avatar_url":"https://avatars-next.observableusercontent.com/a95179728f7a208605a8a434afc1723fb8e19b4266664a0a24602d1c54817cd7","tier":"pro_2024"},"version":1354,"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":"e9b2f7fde85a5f53","login":"dis-2025-fall","name":"🪦 dis-2025-fall","avatar_url":"https://avatars-next.observableusercontent.com/a95179728f7a208605a8a434afc1723fb8e19b4266664a0a24602d1c54817cd7","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":true,"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 = \"2025-08-16T0000\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":392,"value":"courseEnds = \"2025-12-10T0000\"","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":"$33","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":"$W34","stdlib":"1","titling":"auto"}} 30:"$2f:body"