2c:null 2d:["$","title",null,{"children":"Grade standings | 🪦 dis-2026-summer | Observable"}] 32:T423,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), 4)]}, 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:Ta39,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://s3.angiehjort.com/public-library/datavis-course/assets/images/stonks.png" }) ] })34:T5e5,files = ({ "2026-05-29T1148": FileAttachment("2026-05-29T1148_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-01T0831": FileAttachment("2026-06-01T0831_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-02T2009": FileAttachment("2026-06-02T2009_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-04T0727": FileAttachment("2026-06-04T0727_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-08T0930": FileAttachment("2026-06-08T0930_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-09T0715": FileAttachment("2026-06-09T0715_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-10T0817": FileAttachment("2026-06-10T0817_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-11T0910": FileAttachment("2026-06-11T0910_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-12T0846": FileAttachment("2026-06-12T0846_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-15T0914": FileAttachment("2026-06-15T0914_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-16T1024": FileAttachment("2026-06-16T1024_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-17T0813": FileAttachment("2026-06-17T0813_Grades-2603046___Data_Visualization.csv").csv({typed: true}), "2026-06-18T0107": FileAttachment("2026-06-18T0107_Grades-2603046___Data_Visualization.csv").csv({typed: true}), })35:[{"id":"d59eb4cd42f4c49a98ab5ed9dd8fb01a91349fc4d3decf30cbe92fd7099d8f08fb34917185d2d3eed0de5cc24b1467eec210e40c462878a742231b47a1810a99","href":"https://static.observableusercontent.com/files/d59eb4cd42f4c49a98ab5ed9dd8fb01a91349fc4d3decf30cbe92fd7099d8f08fb34917185d2d3eed0de5cc24b1467eec210e40c462878a742231b47a1810a99","name":"allquizzes.csv","type":"text/csv","lastModified":1780048201886.882,"size":2107},{"id":"d564075af92140e71b6d0baee96c3d4727bb3ea805a6fd18c8bd0245e4e0755af4e42fcf9707e8dfd65a61e8781b13d0bbb17cd6f6fc12771cf7b281c1020017","href":"https://static.observableusercontent.com/files/d564075af92140e71b6d0baee96c3d4727bb3ea805a6fd18c8bd0245e4e0755af4e42fcf9707e8dfd65a61e8781b13d0bbb17cd6f6fc12771cf7b281c1020017","name":"2026-05-29T1148_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1780048361006.33,"size":7232},{"id":"f73c7c0218fdfa6bddca2837f4c44215e0375e0f6b862efc8ce1528ee5aff44ffb7ba18ee2549e8d3d8737ee6992f19d0759ebef2e47c374f50fad44ca2abfda","href":"https://static.observableusercontent.com/files/f73c7c0218fdfa6bddca2837f4c44215e0375e0f6b862efc8ce1528ee5aff44ffb7ba18ee2549e8d3d8737ee6992f19d0759ebef2e47c374f50fad44ca2abfda","name":"2026-06-01T0831_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1780295526496.634,"size":7344},{"id":"dec08087f22519e243cec262bf2901c2f5a007f4ea54c47888f5752c46224d1c598d1d0a659d4d078aeddb0ad4cf6b1a41dfab3ac79e6691beb43417c2a9098d","href":"https://static.observableusercontent.com/files/dec08087f22519e243cec262bf2901c2f5a007f4ea54c47888f5752c46224d1c598d1d0a659d4d078aeddb0ad4cf6b1a41dfab3ac79e6691beb43417c2a9098d","name":"2026-06-02T2009_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1780423812570.752,"size":7356},{"id":"57093093cadb6279314db2457ddbb3556c76d3e26c3b98db902ee9d0ed2b0805ff30dc3a13febede9a6b5fb8bccca96e0d6f000b1dfe7cf0ae391230d84b7636","href":"https://static.observableusercontent.com/files/57093093cadb6279314db2457ddbb3556c76d3e26c3b98db902ee9d0ed2b0805ff30dc3a13febede9a6b5fb8bccca96e0d6f000b1dfe7cf0ae391230d84b7636","name":"2026-06-04T0727_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1780550928536.56,"size":7388},{"id":"fa993149c89fb7129dd63f91e7ce4249ca6d57465536b5589cf9d6598d55730c37d7f4b944a585a1aa621e3393a79200aed072f91cce6cba2f5362864d7281dc","href":"https://static.observableusercontent.com/files/fa993149c89fb7129dd63f91e7ce4249ca6d57465536b5589cf9d6598d55730c37d7f4b944a585a1aa621e3393a79200aed072f91cce6cba2f5362864d7281dc","name":"2026-06-10T0817_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1781072390012.609,"size":7476},{"id":"f81de4859066e335ea0bf2bf24f5509fcdc82e93eccdd7ab4741c6dd296840c2fafd18cfc20ae7f6d4bdc1b42d11b1d3e52faf38c36a62d77391d8361b0af180","href":"https://static.observableusercontent.com/files/f81de4859066e335ea0bf2bf24f5509fcdc82e93eccdd7ab4741c6dd296840c2fafd18cfc20ae7f6d4bdc1b42d11b1d3e52faf38c36a62d77391d8361b0af180","name":"2026-06-08T0930_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1780903928888.856,"size":7436},{"id":"3fdf9e7d4277721710bda3716917f83906cb74897e539c35c692fce8edba54ad69692d587766699973f9e66e567266990b562519440641e5e04f81425eec293e","href":"https://static.observableusercontent.com/files/3fdf9e7d4277721710bda3716917f83906cb74897e539c35c692fce8edba54ad69692d587766699973f9e66e567266990b562519440641e5e04f81425eec293e","name":"2026-06-09T0715_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1780982209198.479,"size":7452},{"id":"440a79be73081245d545c988aceb868b9e38e4df6198f1a89f809138c18478ef1e9cc37c4ea001aa1579509a7a35f98f4b943416db5aab3052e49ec55c24a55a","href":"https://static.observableusercontent.com/files/440a79be73081245d545c988aceb868b9e38e4df6198f1a89f809138c18478ef1e9cc37c4ea001aa1579509a7a35f98f4b943416db5aab3052e49ec55c24a55a","name":"2026-06-11T0910_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1781161884111.773,"size":7578},{"id":"a8275293ae20b1361c6d88f4066592f2dc96c8c519908f9e6f3e69db0861adfaf442b30ef6603699286176d616229c3cd37f7e9b4e4118d23ebbf85b5beae6e0","href":"https://static.observableusercontent.com/files/a8275293ae20b1361c6d88f4066592f2dc96c8c519908f9e6f3e69db0861adfaf442b30ef6603699286176d616229c3cd37f7e9b4e4118d23ebbf85b5beae6e0","name":"2026-06-12T0846_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1781246880328.108,"size":7586},{"id":"7a57376af077d6f6c1b7e9e6b1b988af2e90e7b8a9fc6ceef8c1402160b900c68121fa7cdca00f910689444db74a3eb7f6b4ffee95ccd403dd27e69e102f8e4c","href":"https://static.observableusercontent.com/files/7a57376af077d6f6c1b7e9e6b1b988af2e90e7b8a9fc6ceef8c1402160b900c68121fa7cdca00f910689444db74a3eb7f6b4ffee95ccd403dd27e69e102f8e4c","name":"2026-06-15T0914_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1781507760698.27,"size":7606},{"id":"6887c714d293e9287ade6ea6a066f92018bab93f36065dab29d09466e4c855f50e7a9e77335c8b529a357e201d3f5327866b933e8c9ffe8d90dd9c62bc7e71a0","href":"https://static.observableusercontent.com/files/6887c714d293e9287ade6ea6a066f92018bab93f36065dab29d09466e4c855f50e7a9e77335c8b529a357e201d3f5327866b933e8c9ffe8d90dd9c62bc7e71a0","name":"2026-06-16T1024_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1781598346343.303,"size":7618},{"id":"15f2d09cf0d65dde3cb581bf8a2934adca76d6c10583fbd20d1f29f1d28734485e609740cdb6e85ad2086097d3ba17fbabcc0381900e7a9eb6584b72ff345bb0","href":"https://static.observableusercontent.com/files/15f2d09cf0d65dde3cb581bf8a2934adca76d6c10583fbd20d1f29f1d28734485e609740cdb6e85ad2086097d3ba17fbabcc0381900e7a9eb6584b72ff345bb0","name":"2026-06-17T0813_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1781676897309.924,"size":7624},{"id":"911f3c7c4fd82ef8d9a3af94b58c8346da73ffe30b17bead43824c050a20f55bc94da450e39f48bed46c58d270ac9fb4fbc40d06701330b3e86deb2d5fdc3540","href":"https://static.observableusercontent.com/files/911f3c7c4fd82ef8d9a3af94b58c8346da73ffe30b17bead43824c050a20f55bc94da450e39f48bed46c58d270ac9fb4fbc40d06701330b3e86deb2d5fdc3540","name":"2026-06-18T0107_Grades-2603046___Data_Visualization.csv","type":"text/csv","lastModified":1781737706315.35,"size":7635}] 30:{"id":"236584b3d90c455f","slug":"grade-standings","title":"Grade standings","thumbnail":"9da036f971e48dfc0acf6cbe82a8c3637a8f20f823d2b34c968b803dcba85fbe","access_level":"public","create_time":"$D2026-05-29T09:50:01.886Z","update_time":"$D2026-09-24T07:37:30.519Z","view_time":null,"first_public_time":"$D2026-05-29T09:50:01.886Z","has_unpublished_edits":null,"fork":{"id":"453aac4cbddb716c","slug":"grade-standings","title":"Grade standings DESIGN","owner":{"id":"e73bb746871f7c8a","login":"dv-design-2026s","name":"🪦 dv design 2026 spring"}},"stars":0,"starred":false,"owner":{"type":"team","id":"7798254538ffe6ba","login":"dis-2026-summer","name":"🪦 dis-2026-summer","avatar_url":"https://avatars-next.observableusercontent.com/ca468dc6a7c3135fb5c1b1e7b63a23e1f78da7014b68bc50114f6823acc4bf7b","tier":"education_2026"},"version":1416,"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":"7798254538ffe6ba","login":"dis-2026-summer","name":"🪦 dis-2026-summer","avatar_url":"https://avatars-next.observableusercontent.com/ca468dc6a7c3135fb5c1b1e7b63a23e1f78da7014b68bc50114f6823acc4bf7b","tier":"education_2026","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Grade standings","cells":[{"id":0,"value":"# Grade standings","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":1199,"value":"

${quizChart1}

${quizChart2}

","pinned":false,"hidden":false,"mode":"html","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":false,"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 + groupProjectMin + 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 + groupProjectMax + 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 = \"2026-05-26T0000\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":392,"value":"courseEnds = \"2026-06-17T0000\"","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":"groupProjectMin = 3","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"groupProjectMax = 10","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\" && !!f[\"name\"])\n //remove unnecessary columns\n .map(m => filterObjectProps(m, columns))\n //add a total score\n .map((m, i) => {m.total = d3.sum(Object.values(m).map(m => m || 0)); return m;})\n\n //unpivot the data table (derp derp, there should be a better way to do that)\n const result = []\n for (let student of data2) {\n for (let assignment of Object.keys(student).filter(f => f!==\"name\" && f!==\"emoji\")) {\n result.push({student: student.name, emoji: student.emoji, assignment, points: student[assignment]})\n }\n }\n return result\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","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":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":1388,"value":"allQuizzesRaw","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","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"