2b:null 2c:["$","title",null,{"children":"Grade standings | 🪦 dis-2024-fall | Observable"}] 31:T419,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:Ta06,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) => Math.floor(d.points), textAnchor: "start", fill: "black", stroke: "white", strokeWidth: 3, fontSize: "14px", paintOrder: "stroke", dx: 2 }), //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:T572,files = ({ "2024-09-24T1619": FileAttachment("2024-09-24T1619_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-10-03T0935": FileAttachment("2024-10-03T0935_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-10-13T2242": FileAttachment("2024-10-13T2242_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-10-21T2346": FileAttachment("2024-10-21T2346_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-10-26T2124": FileAttachment("2024-10-26T2124_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-11-18T0039": FileAttachment("2024-11-18T0039_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-11-19T0945": FileAttachment("2024-11-19T0945_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-11-25T1503": FileAttachment("2024-11-25T1503_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-12-05T1333": FileAttachment("2024-12-05T1333_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-12-09T1727": FileAttachment("2024-12-09T1727_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-12-11T2329": FileAttachment("2024-12-11T2329_Grades-2404046___Data_Visualization.csv").csv({typed: true}), "2024-12-15T1119": FileAttachment("2024-12-15T1119_Grades-2404046___Data_Visualization.csv").csv({typed: true}), })34:[{"id":"1b4d8d24858fc96044325bb29f8c751521959d2dee48eaea52cdcd52e3a32838543396242596d964d6a2fb7c064916f1957f5c6f6aa7186a9e9a518ee665e460","href":"https://static.observableusercontent.com/files/1b4d8d24858fc96044325bb29f8c751521959d2dee48eaea52cdcd52e3a32838543396242596d964d6a2fb7c064916f1957f5c6f6aa7186a9e9a518ee665e460","name":"2024-09-24T1619_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1727188026933.254,"size":7040},{"id":"883ff16be15f7596c60fceda981b7713cab2cda3fdd0074a3c8888fe4e8400c2a763e32579348162a7ea405977aeea2d02a3fc2e6470742da4c85e18430fb239","href":"https://static.observableusercontent.com/files/883ff16be15f7596c60fceda981b7713cab2cda3fdd0074a3c8888fe4e8400c2a763e32579348162a7ea405977aeea2d02a3fc2e6470742da4c85e18430fb239","name":"2024-10-13T2242_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1728852303766.952,"size":7379},{"id":"0e6b037a8ed9ecc0ef19e19e0d654315a1ca4c84dd015fa1f4cc76dedf0fb6b7f902321d0f8b3ca6f3ffc7ced3a8c2cdec2553ab42dc20f84987fda6491a8d5b","href":"https://static.observableusercontent.com/files/0e6b037a8ed9ecc0ef19e19e0d654315a1ca4c84dd015fa1f4cc76dedf0fb6b7f902321d0f8b3ca6f3ffc7ced3a8c2cdec2553ab42dc20f84987fda6491a8d5b","name":"2024-10-03T0935_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1727941058506.283,"size":7299},{"id":"18ef83135f67126663f81f471b23dc1d7e97e38057114d7f0ee6b11a92c1ebbb10777d2c3ee3c3b80859863807ae796b7f94dd791b74a52f4d2d0d505d7d7d68","href":"https://static.observableusercontent.com/files/18ef83135f67126663f81f471b23dc1d7e97e38057114d7f0ee6b11a92c1ebbb10777d2c3ee3c3b80859863807ae796b7f94dd791b74a52f4d2d0d505d7d7d68","name":"2024-12-11T2329_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1733956214613.012,"size":8735},{"id":"1c021bf60523510e119a7dd2092da553029ec92d1c95fc70353e04c6f580e5a996fbf2c30572b6efe8ec96f85017a0950878fd6a1b345476aea8d447baa59465","href":"https://static.observableusercontent.com/files/1c021bf60523510e119a7dd2092da553029ec92d1c95fc70353e04c6f580e5a996fbf2c30572b6efe8ec96f85017a0950878fd6a1b345476aea8d447baa59465","name":"2024-10-26T2124_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1729970760422.646,"size":7611},{"id":"edf5d687de1c592d219d43218ba86e1a8e58393e71355ea0a59534b09e92b19a972f3d4a4c18ec376666a1f4d979b32586a0edd095a1ab78e8e722f8cbdec4af","href":"https://static.observableusercontent.com/files/edf5d687de1c592d219d43218ba86e1a8e58393e71355ea0a59534b09e92b19a972f3d4a4c18ec376666a1f4d979b32586a0edd095a1ab78e8e722f8cbdec4af","name":"2024-12-05T1333_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1733402069084.819,"size":8169},{"id":"d8d2e1fe46a4003ba15a2ce112409eb55e4b22c696f29577dbddbe63c94e3111ac32a3a09f9a3caf11e8c2f41e3a155efe57ab3bc9064f157b31a8d5a72fcb86","href":"https://static.observableusercontent.com/files/d8d2e1fe46a4003ba15a2ce112409eb55e4b22c696f29577dbddbe63c94e3111ac32a3a09f9a3caf11e8c2f41e3a155efe57ab3bc9064f157b31a8d5a72fcb86","name":"2024-12-09T1727_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1733761715157.572,"size":8181},{"id":"dbb38b012699fd58d822d1369149f2bfc217b7b54dbafb3a2fcbca1c69c98744961a339169922db3dd3e5a793f5258fee736bd572b0d20b4dc428b92e021cc72","href":"https://static.observableusercontent.com/files/dbb38b012699fd58d822d1369149f2bfc217b7b54dbafb3a2fcbca1c69c98744961a339169922db3dd3e5a793f5258fee736bd572b0d20b4dc428b92e021cc72","name":"2024-12-15T1119_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1734258039696.485,"size":8735},{"id":"a78328a64c52d5c50dd38b4a5d00e1cf7dee604c8dc6f0a7922ee0157798880f0b5b93b32f95524558ab43feb14694af76c59d3932f1344b0670394349c8edca","href":"https://static.observableusercontent.com/files/a78328a64c52d5c50dd38b4a5d00e1cf7dee604c8dc6f0a7922ee0157798880f0b5b93b32f95524558ab43feb14694af76c59d3932f1344b0670394349c8edca","name":"2024-11-18T0039_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1731886869292.366,"size":7907},{"id":"0f6eca49a09393e804e46bf23f1ce3a7b065aa1ff4330baee41e42dbe76affc59dfe8657787fb3ddbaacaab1104ad5202d3ab57e27a267c2051b1e98bcca110e","href":"https://static.observableusercontent.com/files/0f6eca49a09393e804e46bf23f1ce3a7b065aa1ff4330baee41e42dbe76affc59dfe8657787fb3ddbaacaab1104ad5202d3ab57e27a267c2051b1e98bcca110e","name":"2024-10-21T2346_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1729547310351.37,"size":7467},{"id":"542808eab73320347ff005866e7d688b996b4e67fba54677e2639c9e20f8f3e8755afa839ec927e40f01a21782149dacae08d6d592b00086baff2c426cd11b44","href":"https://static.observableusercontent.com/files/542808eab73320347ff005866e7d688b996b4e67fba54677e2639c9e20f8f3e8755afa839ec927e40f01a21782149dacae08d6d592b00086baff2c426cd11b44","name":"2024-11-19T0945_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1732006362615.631,"size":7939},{"id":"589647af44a9356c055eec0f18a381df7eebf278b25eaa19913d86ac2c934617f812c1df93f6ca16463ec63027cba5efc592a4cdfcbb259fdee26216d5f3f30b","href":"https://static.observableusercontent.com/files/589647af44a9356c055eec0f18a381df7eebf278b25eaa19913d86ac2c934617f812c1df93f6ca16463ec63027cba5efc592a4cdfcbb259fdee26216d5f3f30b","name":"quizzes.csv","type":"text/csv","lastModified":1732008146682.954,"size":1248},{"id":"b6f1f9c0a5a4f6790cd8c31cd81b1ffd7739eb406179f78ce6e18bfbde1c0dfe6d582336d8d65cee16809464773fd4b742853c734deae5ef1e088ff6fb77dfd6","href":"https://static.observableusercontent.com/files/b6f1f9c0a5a4f6790cd8c31cd81b1ffd7739eb406179f78ce6e18bfbde1c0dfe6d582336d8d65cee16809464773fd4b742853c734deae5ef1e088ff6fb77dfd6","name":"2024-11-25T1503_Grades-2404046___Data_Visualization.csv","type":"text/csv","lastModified":1732543469886.041,"size":8067}] 2f:{"id":"4646df841f69d337","slug":"grade-standings","title":"Grade standings","thumbnail":"233651b8d3ea7faa7b9bb22dd705f1e2200fc2d3345f0a7128fd4a6b410f803c","access_level":"public","create_time":"$D2024-08-15T22:24:59.258Z","update_time":"$D2024-12-15T10:23:42.646Z","view_time":null,"first_public_time":"$D2024-08-15T22:24:59.258Z","fork":{"id":"49862399b7bcc235","slug":"grade-standings","title":"Grade standings","owner":{"id":"0e4f3bfcc8beb20b","login":"dis-2024-spring","name":"🪦 dis-2024-spring"}},"stars":1,"starred":false,"owner":{"type":"team","id":"c9e6070fd9224ac1","login":"dis-2024-fall","name":"🪦 dis-2024-fall","avatar_url":"https://avatars-next.observableusercontent.com/71df23f8dbebe46a8246fa2cd15f75fba2173c7a9264e208f4bd503bf79212c1","tier":"pro_2024"},"version":1280,"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":"c9e6070fd9224ac1","login":"dis-2024-fall","name":"🪦 dis-2024-fall","avatar_url":"https://avatars-next.observableusercontent.com/71df23f8dbebe46a8246fa2cd15f75fba2173c7a9264e208f4bd503bf79212c1","tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"subscribed":null,"forks":2,"collection":null,"type":"notebook","body":{"title":"Grade standings","cells":[{"id":0,"value":"# Grade standings","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 points for the group project come at the very end so then adds 5 for lower estimate and 15 for 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 = 24","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":392,"value":"courseEnds = \"2024-12-16T0000\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":399,"value":"courseStarts = \"2024-08-20T0000\"","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 = 0","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"groupProjectMax = 15","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\")\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 = allQuizzesEver.filter(f => f.date < new Date(\"2024-12-01\")).length / 3","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":997,"value":"allQuizzesRaw = FileAttachment(\"quizzes.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"