2b:null 2c:["$","title",null,{"children":"Grade standings | 🪦 dv develop 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:T7e8,files = ({ "2025-01-30T0929": FileAttachment("2025-01-30T0929_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-02-20T1927": FileAttachment("2025-02-20T1927_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-03-10T0843": FileAttachment("2025-03-10T0843_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-03-15T1921": FileAttachment("2025-03-15T1921_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-03-17T1947": FileAttachment("2025-03-17T1947_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-03-31T1210": FileAttachment("2025-03-31T1210_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-04-09T1333": FileAttachment("2025-04-09T1333_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-04-10T0957": FileAttachment("2025-04-10T0957_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-04-14T0953": FileAttachment("2025-04-14T0953_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-04-28T0942": FileAttachment("2025-04-28T0942_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-04-29T1219": FileAttachment("2025-04-29T1219_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-05-03T0147": FileAttachment("2025-05-03T0147_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-05-11T1436": FileAttachment("2025-05-11T1436_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-05-12T1313": FileAttachment("2025-05-12T1313_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), "2025-05-17T1736": FileAttachment("2025-05-17T1736_Grades-2502030___Data-Driven_Information_Visualization.csv").csv({typed: true}), })34:[{"id":"589647af44a9356c055eec0f18a381df7eebf278b25eaa19913d86ac2c934617f812c1df93f6ca16463ec63027cba5efc592a4cdfcbb259fdee26216d5f3f30b","href":"https://static.observableusercontent.com/files/589647af44a9356c055eec0f18a381df7eebf278b25eaa19913d86ac2c934617f812c1df93f6ca16463ec63027cba5efc592a4cdfcbb259fdee26216d5f3f30b","name":"quizzes.csv","type":"text/csv","lastModified":1736878589119.261,"size":1248},{"id":"60c195b2a2f4f34a9a1161ae6c91980bd3f553d92264eaa6fb721afb94dc012f829b49bcea29182a031f2a7c09940c3f726118867fc17b70a781b05b59eb3e98","href":"https://static.observableusercontent.com/files/60c195b2a2f4f34a9a1161ae6c91980bd3f553d92264eaa6fb721afb94dc012f829b49bcea29182a031f2a7c09940c3f726118867fc17b70a781b05b59eb3e98","name":"2025-01-30T0929_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1738227183100.738,"size":7609},{"id":"3271d64f6f11121dde11c6b4722fe06c7f365af032d0443a881017a2ea88b627dc6438d11b614420ad591fa74fdb9069f93e0ee1be0f08282c1c9243faa116e9","href":"https://static.observableusercontent.com/files/3271d64f6f11121dde11c6b4722fe06c7f365af032d0443a881017a2ea88b627dc6438d11b614420ad591fa74fdb9069f93e0ee1be0f08282c1c9243faa116e9","name":"2025-03-31T1210_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1743415941884.386,"size":7865},{"id":"6343cd420e41f059bfa3d6804bb9403eb7cd9919eb7b3e88edbe9e6b1d5e8b4dc53cd300caa036d1b2601a42d40d4560c4e0144cdf2ce1b9c7ac1408377c3ca8","href":"https://static.observableusercontent.com/files/6343cd420e41f059bfa3d6804bb9403eb7cd9919eb7b3e88edbe9e6b1d5e8b4dc53cd300caa036d1b2601a42d40d4560c4e0144cdf2ce1b9c7ac1408377c3ca8","name":"2025-02-20T1927_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1740076855979.854,"size":7276},{"id":"d8399710f6b1dd9af1a0a3e5fde4ce71b1b5fe1a6ef571271ffcdb22251ce5d39e568703745304c9cc7e7363766651894a1666530d8cddc92753851ee2f26774","href":"https://static.observableusercontent.com/files/d8399710f6b1dd9af1a0a3e5fde4ce71b1b5fe1a6ef571271ffcdb22251ce5d39e568703745304c9cc7e7363766651894a1666530d8cddc92753851ee2f26774","name":"2025-03-10T0843_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1741592747431.35,"size":7377},{"id":"f95a0828f017ab528b5d4bc41e10051b9e52b63e49ae99f67abca0c48f7ea4028dd657892723b06a063ffe9861389a9b944b4f036406fa89dd06c273fd5a9b8a","href":"https://static.observableusercontent.com/files/f95a0828f017ab528b5d4bc41e10051b9e52b63e49ae99f67abca0c48f7ea4028dd657892723b06a063ffe9861389a9b944b4f036406fa89dd06c273fd5a9b8a","name":"2025-03-15T1921_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1742063278542.63,"size":7735},{"id":"07dc5c46279a399c20783e7b5685c4634ca3537b209e35b4257bb5b3402fcc8f6230a2763acd2ab9f94f154524b3205aa1bef46e92c568cc0c82f3ffa3901ec0","href":"https://static.observableusercontent.com/files/07dc5c46279a399c20783e7b5685c4634ca3537b209e35b4257bb5b3402fcc8f6230a2763acd2ab9f94f154524b3205aa1bef46e92c568cc0c82f3ffa3901ec0","name":"2025-03-17T1947_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1742237402931.385,"size":7795},{"id":"274b893714d4269f563552c9c1268491845e8cf7ecefb8ad11e180e7789a15535f427cc5977b9bedcdbaf4243be18fa0f27840ab444cfd02701f422578431452","href":"https://static.observableusercontent.com/files/274b893714d4269f563552c9c1268491845e8cf7ecefb8ad11e180e7789a15535f427cc5977b9bedcdbaf4243be18fa0f27840ab444cfd02701f422578431452","name":"2025-05-11T1436_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1746967081254.31,"size":8203},{"id":"036c12259305900242356e8918892591426941a9396fcd8ce3d827b85f63259f59614674ab23dab9638f7749e9555417b16f9743fc87e5a377acae74613f3ce3","href":"https://static.observableusercontent.com/files/036c12259305900242356e8918892591426941a9396fcd8ce3d827b85f63259f59614674ab23dab9638f7749e9555417b16f9743fc87e5a377acae74613f3ce3","name":"2025-04-09T1333_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1744198492254.596,"size":7996},{"id":"bdb8d99eb82f73514007fe4db431536500ddf61871bff9e78e1e803dcaef4220066ad0efbf36aa683c4b410181a5175d885d457b227f7ad704fe96398f1778b2","href":"https://static.observableusercontent.com/files/bdb8d99eb82f73514007fe4db431536500ddf61871bff9e78e1e803dcaef4220066ad0efbf36aa683c4b410181a5175d885d457b227f7ad704fe96398f1778b2","name":"2025-05-17T1736_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1747496229118.121,"size":8453},{"id":"66987bf0b8888b36fe8cdbea8c56f9226cc7fe4c7e7aab35b6d7b00cc3dd110db87ee254e6ab61865ed8ce5751acecbb2516be008ebc72dd4b2e1f9b3940b90b","href":"https://static.observableusercontent.com/files/66987bf0b8888b36fe8cdbea8c56f9226cc7fe4c7e7aab35b6d7b00cc3dd110db87ee254e6ab61865ed8ce5751acecbb2516be008ebc72dd4b2e1f9b3940b90b","name":"2025-04-10T0957_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1744271939355.348,"size":8012},{"id":"2650f75c6d2c6924414a19389234fc2a676dbd2ebe46fce39e8491d30865ebb6fc4e89e4800d310fd10565a25f1e4b1d79dcda41101a8b1be9968d646d6951b3","href":"https://static.observableusercontent.com/files/2650f75c6d2c6924414a19389234fc2a676dbd2ebe46fce39e8491d30865ebb6fc4e89e4800d310fd10565a25f1e4b1d79dcda41101a8b1be9968d646d6951b3","name":"2025-05-12T1313_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1747048474942.057,"size":8355},{"id":"ee59bef5339a6c84ca3c0b33f427bdfb49fbb471165540ac7890336b0b594f0298904bf4e932452a8046967b629a0250639cc4ff1eb78d46490785ec48199061","href":"https://static.observableusercontent.com/files/ee59bef5339a6c84ca3c0b33f427bdfb49fbb471165540ac7890336b0b594f0298904bf4e932452a8046967b629a0250639cc4ff1eb78d46490785ec48199061","name":"2025-05-03T0147_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1746229763982.571,"size":8157},{"id":"392297ec29adf49a576dc86a83e19567a04c7ef2f72faa0f322183ab633d694ef458fb3fbf9eb285ebaa5e04e4ad03773156d69044b588063184b706333ac8a4","href":"https://static.observableusercontent.com/files/392297ec29adf49a576dc86a83e19567a04c7ef2f72faa0f322183ab633d694ef458fb3fbf9eb285ebaa5e04e4ad03773156d69044b588063184b706333ac8a4","name":"2025-04-28T0942_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1745826212650.966,"size":8094},{"id":"373361ddd8de3f592d23263c2b84c95b6c98b35daf43d5288fbfcef228432c9b0255597af7f9bb1b52aa6be567159bbb3e75af197a4f4a4fa3b62f7fee70ab83","href":"https://static.observableusercontent.com/files/373361ddd8de3f592d23263c2b84c95b6c98b35daf43d5288fbfcef228432c9b0255597af7f9bb1b52aa6be567159bbb3e75af197a4f4a4fa3b62f7fee70ab83","name":"2025-04-14T0953_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1744617299143.549,"size":8038},{"id":"0da2f3823b668b546cd5766f9ad4a425ef9d13d5b3411539b264b84966eee3e045c21339f6fdf149f9cd8d0fd3b0a24a8c43b6e9dac6680e1798528f5414358c","href":"https://static.observableusercontent.com/files/0da2f3823b668b546cd5766f9ad4a425ef9d13d5b3411539b264b84966eee3e045c21339f6fdf149f9cd8d0fd3b0a24a8c43b6e9dac6680e1798528f5414358c","name":"2025-04-29T1219_Grades-2502030___Data-Driven_Information_Visualization.csv","type":"text/csv","lastModified":1745922102148.626,"size":8151}] 2f:{"id":"7c60a1054de92ba3","slug":"grade-standings","title":"Grade standings","thumbnail":"a418ad3f757417182d9144cc9c167935b263509c9618ec8a55cbf00899ec55c6","access_level":"public","create_time":"$D2025-01-14T18:16:29.119Z","update_time":"$D2025-11-27T19:51:26.262Z","view_time":null,"first_public_time":"$D2025-01-14T18:20:06.562Z","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":"caa1f4ddba1048c5","login":"dv-develop-2025s","name":"🪦 dv develop 2025 spring","avatar_url":"https://avatars-next.observableusercontent.com/4e75b7ea2e28b63057c20457d28474e4c0622d1b506ebef5d878e38c0c606a40","tier":"pro_2024"},"version":1311,"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":"caa1f4ddba1048c5","login":"dv-develop-2025s","name":"🪦 dv develop 2025 spring","avatar_url":"https://avatars-next.observableusercontent.com/4e75b7ea2e28b63057c20457d28474e4c0622d1b506ebef5d878e38c0c606a40","tier":"pro_2024","role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"subscribed":null,"forks":1,"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 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-01-16T0000\"","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":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 = 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\")\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"