2c:null 2d:["$","title",null,{"children":"Grade standings DEV | 🪦 dis-2025-fall | Observable"}] 32: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); } }) ] })33: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" }) ] })34:T5d1,files = ({ "2025-09-01T0939": FileAttachment("2025-09-01T0939_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-09-15T0959": FileAttachment("2025-09-15T0959_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-10-02T1001": FileAttachment("2025-10-02T1001_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-10-23T0920": FileAttachment("2025-10-23T0920_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-10-30T2319": FileAttachment("2025-10-30T2319_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-10-31T2048": FileAttachment("2025-10-31T2048_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-11-20T1158": FileAttachment("2025-11-20T1158_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-12-01T0902": FileAttachment("2025-12-01T0902_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-12-02T0842": FileAttachment("2025-12-02T0842_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-12-11T1047": FileAttachment("2025-12-11T1047_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-12-30T0029": FileAttachment("2025-12-30T0029_Grades-2504030___Data-Driven_Information_Visualization.csv").csv({typed: true}), })35:[{"id":"e4b2dc75f1e7686712a8b7226cbc5e758478b96ea9e783668a64f92ec7910bb82e560ae7b46b6b62724c4886004e56e0bada4c483a29422558791f9397bf1dd1","href":"https://static.observableusercontent.com/files/e4b2dc75f1e7686712a8b7226cbc5e758478b96ea9e783668a64f92ec7910bb82e560ae7b46b6b62724c4886004e56e0bada4c483a29422558791f9397bf1dd1","name":"2025-09-15T0959_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1757923294738.555,"size":5268},{"id":"fc021b481877a693b5439e2069b02123f4cfeaea5cb0824d7a05da478417fa5804dfd2518fa622b828441189b54e8e5d53eda383a91ebf59dc92181a74faea4b","href":"https://static.observableusercontent.com/files/fc021b481877a693b5439e2069b02123f4cfeaea5cb0824d7a05da478417fa5804dfd2518fa622b828441189b54e8e5d53eda383a91ebf59dc92181a74faea4b","name":"2025-09-01T0939_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1756713313865.271,"size":4948},{"id":"3365de13970971a410dd90a6d71d836bf6045e7d305c058f49e3fc237101632e01ae75dc51dbdd6cfa91a723360742aaca885a400ea99d629e219c80154b5db2","href":"https://static.observableusercontent.com/files/3365de13970971a410dd90a6d71d836bf6045e7d305c058f49e3fc237101632e01ae75dc51dbdd6cfa91a723360742aaca885a400ea99d629e219c80154b5db2","name":"2025-10-02T1001_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1759392152959.184,"size":5382},{"id":"22d625079e38c8200aae5c042a4012dc0e8ea2d8aa8cb808138ee5ae7e7cd8eee46d67b96ca011a121778131c6da7d19c252317936ec1fc0fdcb7a19f283cb93","href":"https://static.observableusercontent.com/files/22d625079e38c8200aae5c042a4012dc0e8ea2d8aa8cb808138ee5ae7e7cd8eee46d67b96ca011a121778131c6da7d19c252317936ec1fc0fdcb7a19f283cb93","name":"2025-10-23T0920_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1761204119402.504,"size":5522},{"id":"5d4509205ff6e72b316b7d72f2ff0717e6125deafeb2fa8c712cece558432850b391f1ba9e7b0648d42cccec311c6a1c48da98cea8485824280e4e567acf19de","href":"https://static.observableusercontent.com/files/5d4509205ff6e72b316b7d72f2ff0717e6125deafeb2fa8c712cece558432850b391f1ba9e7b0648d42cccec311c6a1c48da98cea8485824280e4e567acf19de","name":"2025-10-30T2319_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1761862852396.845,"size":5576},{"id":"5d2a57b04c3b53b68fb7a6315dd37fb156eff2245e5790877b825d1484c2ec2e044bcd7ff0dac7af0330fd219bff934b75817f509037dbd9c30746bf14fb5527","href":"https://static.observableusercontent.com/files/5d2a57b04c3b53b68fb7a6315dd37fb156eff2245e5790877b825d1484c2ec2e044bcd7ff0dac7af0330fd219bff934b75817f509037dbd9c30746bf14fb5527","name":"2025-10-31T2048_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1761940149218.718,"size":5586},{"id":"d59eb4cd42f4c49a98ab5ed9dd8fb01a91349fc4d3decf30cbe92fd7099d8f08fb34917185d2d3eed0de5cc24b1467eec210e40c462878a742231b47a1810a99","href":"https://static.observableusercontent.com/files/d59eb4cd42f4c49a98ab5ed9dd8fb01a91349fc4d3decf30cbe92fd7099d8f08fb34917185d2d3eed0de5cc24b1467eec210e40c462878a742231b47a1810a99","name":"allquizzes.csv","type":"text/csv","lastModified":1761942185149.704,"size":2107},{"id":"93d13dbee13a830bab806923773d90507524ece9d35a2ffd6d1e2a2eca4f275898dcc7979191041e0677cc87f5a628f15489c02ea6b686470b5b1b62ed9b07f2","href":"https://static.observableusercontent.com/files/93d13dbee13a830bab806923773d90507524ece9d35a2ffd6d1e2a2eca4f275898dcc7979191041e0677cc87f5a628f15489c02ea6b686470b5b1b62ed9b07f2","name":"2025-11-20T1158_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1763636391488.229,"size":5628},{"id":"ec4cc34e90aaae86f8a13c1225fdaf52f6ce47b18f9071bd9f71cdff48ae70d69da1010ef6f9477f028a534a62c56533c1bb3216d5a2ab6dc83b5cde9ffb67df","href":"https://static.observableusercontent.com/files/ec4cc34e90aaae86f8a13c1225fdaf52f6ce47b18f9071bd9f71cdff48ae70d69da1010ef6f9477f028a534a62c56533c1bb3216d5a2ab6dc83b5cde9ffb67df","name":"2025-12-01T0902_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1764576183011.599,"size":5749},{"id":"799ba566435882ad850f0750cacc54d3d7a487141b5f59c1918ba7873d7291a0d0dc7b4242cb384e08d2b0cb20afa773aaea5432af6160f09c476ebd1421fc6a","href":"https://static.observableusercontent.com/files/799ba566435882ad850f0750cacc54d3d7a487141b5f59c1918ba7873d7291a0d0dc7b4242cb384e08d2b0cb20afa773aaea5432af6160f09c476ebd1421fc6a","name":"2025-12-02T0842_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1764661553547.316,"size":5757},{"id":"b74b131d535026072c851518ce7a2167921fd4232e22a6d5bfd7717b615db0f843147d979d143cd951fe6845eef2f0ee1d078af9aea543c2c28f56800737e214","href":"https://static.observableusercontent.com/files/b74b131d535026072c851518ce7a2167921fd4232e22a6d5bfd7717b615db0f843147d979d143cd951fe6845eef2f0ee1d078af9aea543c2c28f56800737e214","name":"2025-12-11T1047_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1765446558528.637,"size":5774},{"id":"aa11ed859c0ccba4644aac6c25eaca735a0c23b0e03be6a8052b87506a108aa38e37afb5c85b9da8d4e926bd3310dd196902a5625a887c7915506f3314b0d88d","href":"https://static.observableusercontent.com/files/aa11ed859c0ccba4644aac6c25eaca735a0c23b0e03be6a8052b87506a108aa38e37afb5c85b9da8d4e926bd3310dd196902a5625a887c7915506f3314b0d88d","name":"2025-12-30T0029_Grades-2504030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1767051037415.07,"size":5782}] 30:{"id":"1f6e3e7959d07936","slug":"grade-standings-dev","title":"Grade standings DEV","thumbnail":"49e36d74d29eaab76c6602993c53f7c767ab0fd6406b0ed28802d59240842c41","access_level":"public","create_time":"$D2025-08-21T01:17:36.750Z","update_time":"$D2025-12-29T23:30:57.026Z","view_time":null,"first_public_time":"$D2025-08-21T01:19:32.252Z","has_unpublished_edits":null,"fork":{"id":"7c60a1054de92ba3","slug":"grade-standings","title":"Grade standings","owner":{"id":"caa1f4ddba1048c5","login":"dv-develop-2025s","name":"🪦 dv develop 2025 spring"}},"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":1366,"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":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Grade standings DEV","cells":[{"id":0,"value":"# Grade standings DEV","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":448,"value":"lastUpdate = Object.keys(files).at(-1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":293,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"mutable time = lastUpdate","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":660,"value":"showForecast = 50 <= percentCourseComplete && percentCourseComplete <= 95","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":759,"value":"attendancePoints = 27","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":755,"value":"forecastMin = (d) => (d[\"points\"] - attendancePoints) * forecastFactor + pessimisticPoints + attendancePoints","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":762,"value":"forecastMax = (d) => (d[\"points\"] - attendancePoints) * forecastFactor + optimisticPoints + attendancePoints","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":589,"value":"width = 928\n ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":590,"value":"height = 600","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":399,"value":"courseStarts = \"2025-08-16T0000\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":392,"value":"courseEnds = \"2025-12-8T0000\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":418,"value":"forecastFactor = 100/percentCourseComplete","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":453,"value":"pessimisticPoints = 3","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"optimisticPoints = 9","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":318,"value":"timeformat = \"%Y-%m-%dT%H%M\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"loadPromise = Promise.all(Object.values(files))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"excludeColumnsContaining = [\" Score\", \" ID\", \" Grade\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"excludeColumnsEqualTo = [\"ID\", \"Student\", \"Section\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":811,"value":"tidydata = applyDataTransformations(data);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$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\")\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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1199,"value":"

${quizChart1}

${quizChart2}

","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$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","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1"}} 31:"$30:body"