2b:null 2c:["$","title",null,{"children":"Grade standings | 🪦 dv design 2025 spring | 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: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:T65b,files = ({ "2025-01-30T0923": FileAttachment("2025-01-30T0923_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-02-20T1937": FileAttachment("2025-02-20T1937_Grades-2502046___Data_Visualization@1.csv").csv({typed: true}), "2025-03-10T0842": FileAttachment("2025-03-10T0842_Grades-2502046___Data_Visualization(1).csv").csv({typed: true}), "2025-03-13T0023": FileAttachment("2025-03-13T0023_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-03-15T1922": FileAttachment("2025-03-15T1922_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-03-17T1948": FileAttachment("2025-03-17T1948_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-03-20T0943": FileAttachment("2025-03-20T0943_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-04-03T0946": FileAttachment("2025-04-03T0946_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-04-07T0846": FileAttachment("2025-04-07T0846_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-04-28T1114": FileAttachment("2025-04-28T1114_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-05-03T0147": FileAttachment("2025-05-03T0147_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-05-12T1225": FileAttachment("2025-05-12T1225_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-05-14T0033": FileAttachment("2025-05-14T0033_Grades-2502046___Data_Visualization.csv").csv({typed: true}), "2025-05-17T1643": FileAttachment("2025-05-17T1643_Grades-2502046___Data_Visualization.csv").csv({typed: true}) })34:[{"id":"589647af44a9356c055eec0f18a381df7eebf278b25eaa19913d86ac2c934617f812c1df93f6ca16463ec63027cba5efc592a4cdfcbb259fdee26216d5f3f30b","href":"https://static.observableusercontent.com/files/589647af44a9356c055eec0f18a381df7eebf278b25eaa19913d86ac2c934617f812c1df93f6ca16463ec63027cba5efc592a4cdfcbb259fdee26216d5f3f30b","name":"quizzes.csv","type":"text/csv","lastModified":1736878599468.332,"size":1248},{"id":"9a24a980b48fd62da4447ed92c92166db5d11a0ac8eb4ad7d5823e0cfc10efcbca433c4147b29bdf5a24b14c823d267315743f519915c8419c0e265c5a8f35da","href":"https://static.observableusercontent.com/files/9a24a980b48fd62da4447ed92c92166db5d11a0ac8eb4ad7d5823e0cfc10efcbca433c4147b29bdf5a24b14c823d267315743f519915c8419c0e265c5a8f35da","name":"2025-01-30T0923_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1738227023073.869,"size":6796},{"id":"7205c88479dfca371327d1154d599b10ab81a55420de56eed5f2f36a14702a5cb3d402158febf11e83eb1bba618525839fac09ae41ebabb6dbdf3b1d8defdefc","href":"https://static.observableusercontent.com/files/7205c88479dfca371327d1154d599b10ab81a55420de56eed5f2f36a14702a5cb3d402158febf11e83eb1bba618525839fac09ae41ebabb6dbdf3b1d8defdefc","name":"2025-04-07T0846_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1744008440010.983,"size":7076},{"id":"75e5a9c1eae1ec18b93d8146393d5cc2cb05f1796c8e2099367fc2af6d9334a4ae234e6fa82017b6e02e119c19a2565e80223281e2c7b7e59d0ccacd5cdc1212","href":"https://static.observableusercontent.com/files/75e5a9c1eae1ec18b93d8146393d5cc2cb05f1796c8e2099367fc2af6d9334a4ae234e6fa82017b6e02e119c19a2565e80223281e2c7b7e59d0ccacd5cdc1212","name":"2025-03-13T0023_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1741821856150.004,"size":6673},{"id":"9871e9b4c4543150cfd8a8bdc7540e887e3ef9af444d3bd1171ac28e3c0adc6d4c4e703a223f6705272b76195b593fd0291360105b1be6d5f178a6452f3cb33a","href":"https://static.observableusercontent.com/files/9871e9b4c4543150cfd8a8bdc7540e887e3ef9af444d3bd1171ac28e3c0adc6d4c4e703a223f6705272b76195b593fd0291360105b1be6d5f178a6452f3cb33a","name":"2025-02-20T1937_Grades-2502046___Data_Visualization@1.csv","type":"text/csv","lastModified":1740077264967.023,"size":6397},{"id":"e8bf3d24739982855ed1c0f54e8912aa801f51445bd736c115df06b08abe30b84774c792aff208099257c0754ec84b05572859472592240e21a3ff6b22afc618","href":"https://static.observableusercontent.com/files/e8bf3d24739982855ed1c0f54e8912aa801f51445bd736c115df06b08abe30b84774c792aff208099257c0754ec84b05572859472592240e21a3ff6b22afc618","name":"2025-03-10T0842_Grades-2502046___Data_Visualization(1).csv","type":"text/csv","lastModified":1741593457959.017,"size":6445},{"id":"e7d0874d6d9971ebef2b6a60a5e9cea6499590aa5de13c147170418815ad473eabc7432ea83671fbcd51b5886d21e856646813cae63f0ce5ac9f2fa23a12fa71","href":"https://static.observableusercontent.com/files/e7d0874d6d9971ebef2b6a60a5e9cea6499590aa5de13c147170418815ad473eabc7432ea83671fbcd51b5886d21e856646813cae63f0ce5ac9f2fa23a12fa71","name":"2025-03-20T0943_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1742460635357.824,"size":6860},{"id":"cef81f8078ff38e7c6776a8e76860e0d66dc4dbf0798e006fc3bbb1e346122580e2a1551aeed5ea392581e458f0783cfbc19f871bd9afcb266fb772c511da17f","href":"https://static.observableusercontent.com/files/cef81f8078ff38e7c6776a8e76860e0d66dc4dbf0798e006fc3bbb1e346122580e2a1551aeed5ea392581e458f0783cfbc19f871bd9afcb266fb772c511da17f","name":"2025-03-15T1922_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1742063052266.304,"size":6701},{"id":"744e51e69b549c226b0bd24a3f3acc0d1564051c7be613543ccff01ecf64c60ad80fdaccb291e283e2f4647867792b3adb7a82a788a4c461b9de92cf8f3d0fb7","href":"https://static.observableusercontent.com/files/744e51e69b549c226b0bd24a3f3acc0d1564051c7be613543ccff01ecf64c60ad80fdaccb291e283e2f4647867792b3adb7a82a788a4c461b9de92cf8f3d0fb7","name":"2025-03-17T1948_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1742237482837.52,"size":6837},{"id":"52048b1c8ab642193d765acd234b8e883793980204c67b8e0de4d3630fb774c1d5db28afacfa6b4bcb08767aff1e15fdb8c65c90bf52459625c99a50b00b84dd","href":"https://static.observableusercontent.com/files/52048b1c8ab642193d765acd234b8e883793980204c67b8e0de4d3630fb774c1d5db28afacfa6b4bcb08767aff1e15fdb8c65c90bf52459625c99a50b00b84dd","name":"2025-04-03T0946_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1743666488797.823,"size":6975},{"id":"c5f0b78f6a78ec07e5d8e8cdde01b5cf4ad22bd187f21e7e243e7daca5a45587a5302d32eafb6d921c2688d32a261e657a89a31a550bd785f8e1dc766bab0020","href":"https://static.observableusercontent.com/files/c5f0b78f6a78ec07e5d8e8cdde01b5cf4ad22bd187f21e7e243e7daca5a45587a5302d32eafb6d921c2688d32a261e657a89a31a550bd785f8e1dc766bab0020","name":"2025-05-17T1643_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1747493027807.693,"size":7613},{"id":"699b1c0ac8bbeb0d0f0d6717bdadd8530743e854742e3226951edbb99d728a1f6063ffeb5a4a200174b4a231f27288645e52a8488e3105c9f34d872f070d125e","href":"https://static.observableusercontent.com/files/699b1c0ac8bbeb0d0f0d6717bdadd8530743e854742e3226951edbb99d728a1f6063ffeb5a4a200174b4a231f27288645e52a8488e3105c9f34d872f070d125e","name":"2025-05-12T1225_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1747045585718.962,"size":7613},{"id":"daed2e04ddb3dae9b6b6067517fcfe5bf99d977dba9c26aa8df11e6e30e3820e1d4ba482a56735a30c1a43d26f81c3aa7746308ba2bef825c6bd4e61aacc1eff","href":"https://static.observableusercontent.com/files/daed2e04ddb3dae9b6b6067517fcfe5bf99d977dba9c26aa8df11e6e30e3820e1d4ba482a56735a30c1a43d26f81c3aa7746308ba2bef825c6bd4e61aacc1eff","name":"2025-05-03T0147_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1746229927366.414,"size":7159},{"id":"76f40b78dd633ecc72bc45e95130a66e8d836f5157b75440738c7c4964abc49b2f0e80e3bd23ed322ba8372bdd9045d7b3848cccf4e748a33d9c85d77961b3cd","href":"https://static.observableusercontent.com/files/76f40b78dd633ecc72bc45e95130a66e8d836f5157b75440738c7c4964abc49b2f0e80e3bd23ed322ba8372bdd9045d7b3848cccf4e748a33d9c85d77961b3cd","name":"2025-04-28T1114_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1745831736744.059,"size":7151},{"id":"3ae5f5bf95906a4105820f8af2f0107d82153f0fb80d95cb99fba5eee6365a37f55884cf2a726e18d75ff6c639b55db6611f91694240b589223c13ea92df4e30","href":"https://static.observableusercontent.com/files/3ae5f5bf95906a4105820f8af2f0107d82153f0fb80d95cb99fba5eee6365a37f55884cf2a726e18d75ff6c639b55db6611f91694240b589223c13ea92df4e30","name":"2025-05-14T0033_Grades-2502046___Data_Visualization.csv","type":"text/csv","lastModified":1747175629044.743,"size":7621}] 2f:{"id":"eaa6272d1ef706e4","slug":"grade-standings","title":"Grade standings","thumbnail":"a418ad3f757417182d9144cc9c167935b263509c9618ec8a55cbf00899ec55c6","access_level":"public","create_time":"$D2025-01-14T18:16:39.468Z","update_time":"$D2025-05-17T14:47:40.138Z","view_time":null,"first_public_time":"$D2025-01-14T18:18:02.881Z","fork":{"id":"4646df841f69d337","slug":"grade-standings","title":"Grade standings","owner":{"id":"c9e6070fd9224ac1","login":"dis-2024-fall","name":"🪦 dis-2024-fall"}},"stars":0,"starred":false,"owner":{"type":"team","id":"50ad26f6f15e6ae6","login":"dv-design-2025s","name":"🪦 dv design 2025 spring","avatar_url":"https://avatars-next.observableusercontent.com/682ee67bd6bcc28d575df75caeafae9984eba60d20a6728c4458dea26da63d5a","tier":"pro_2024"},"version":1316,"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":"50ad26f6f15e6ae6","login":"dv-design-2025s","name":"🪦 dv design 2025 spring","avatar_url":"https://avatars-next.observableusercontent.com/682ee67bd6bcc28d575df75caeafae9984eba60d20a6728c4458dea26da63d5a","tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"subscribed":null,"forks":0,"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 = \"2025-05-16T0000\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":399,"value":"courseStarts = \"2025-01-16T0000\"","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 = 12","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\"] !== \"Unknown\")\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: [2,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"