2f:T503,{ if (!showPlot) return md``; const scores = await FileAttachment("Grades@1.xlsx") .xlsx() .then((wb) => wb.sheet(0, { headers: true })); return Plot.plot({ y: { ticks: 10, nice: true, domain: [0, 100] }, x: { ticks: 10, nice: true, domain: [0, 100] }, marks: [ Plot.text([`Summative vs. Formative Assessments`], { frameAnchor: "top" }), Plot.dot(scores, { x: "Formative", y: "Summative", fill: (d) => Math.abs(d.Summative - d.Formative) > 40 ? "red" : "blue", title: (d) => d.Summative - d.Formative > 40 ? `Earth Shattering!\n\nStudent ID: ${d.Student}\nSummative: ${d.Summative}\nFormative ${d.Formative}` : Math.abs(d.Summative - d.Formative) > 40 ? `Perhaps Test Day Jitters?\n\nStudent ID: ${d.Student}\nSummative: ${d.Summative}\nFormative ${d.Formative}` : `Student ID: ${d.Student}\nSummative: ${d.Summative}\nFormative ${d.Formative}`, target: "_blank", href: (d) => d.Summative - d.Formative > 40 ? "https://en.wikipedia.org/wiki/2011_Virginia_earthquake" : "https://keydifferences.com/difference-between-formative-and-summative-assessment.html" }) ] }); }30:[{"id":"dd67626eb53063f15a97b177726c5292bbf36b4948c0b5853ffda4dd2daf52245a339866da74859b46501dc6c099489bd046d5672100ccc704c6e10be23e5a0f","href":"https://static.observableusercontent.com/files/dd67626eb53063f15a97b177726c5292bbf36b4948c0b5853ffda4dd2daf52245a339866da74859b46501dc6c099489bd046d5672100ccc704c6e10be23e5a0f","name":"Grades.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1673548762226.186,"size":30486},{"id":"5ed83bc4378bfbdced7c93ad2161c9691a07f1d169a88f3e345f6695d91b0b92c12f521d27f5c01e09711ff829d424636b45aedfa99a7746ac4d2f56313da9b4","href":"https://static.observableusercontent.com/files/5ed83bc4378bfbdced7c93ad2161c9691a07f1d169a88f3e345f6695d91b0b92c12f521d27f5c01e09711ff829d424636b45aedfa99a7746ac4d2f56313da9b4","name":"Grades@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1673813442777.764,"size":27759},{"id":"d4ba6464874b36877eaed5706183ade8a1ee9cf6d13cf41c8dd30020688ee1f7d797a0f325f56b3acd1e1622562b190b03d7189714067d95310cf6ece42707ed","href":"https://static.observableusercontent.com/files/d4ba6464874b36877eaed5706183ade8a1ee9cf6d13cf41c8dd30020688ee1f7d797a0f325f56b3acd1e1622562b190b03d7189714067d95310cf6ece42707ed","name":"image.png","type":"image/png","lastModified":1675015022718.095,"size":79803}] 2d:{"title":"Facts 🢂 Knowledge 🢂 Wisdom","cells":[{"id":0,"value":"# Facts 🢂 Knowledge 🢂 Wisdom\n","pinned":false,"hidden":false,"mode":"md"},{"id":167,"value":"toc(\"H2\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"##

Lessons from Academia","pinned":false,"hidden":false,"mode":"md"},{"id":186,"value":"viewof heightWidth = Inputs.range([400, 800], {\n label: \"Table's Height/Width:\",\n value: 400,\n step: 1\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"*
${await FileAttachment(\"image.png\").image({height: heightWidth, width: heightWidth})}\n
--[Difference Between Formative and Summative Assessment](https://keydifferences.com/difference-between-formative-and-summative-assessment.html)\n* An illustration of hidden wisdom in everyday data: Grades Workbook\n","pinned":false,"hidden":false,"mode":"md"},{"id":111,"value":"Unfortunately, [Excel doesn't yet provide a contextual tooltip for an XY Scatter chart](https://www.clearlyandsimply.com/clearly_and_simply/2016/08/customizable-tooltips-on-excel-charts.html). Same for [Google Sheets](https://support.google.com/docs/thread/73425733/i-d-like-the-tooltip-in-a-scatterplot-to-display-an-additional-column-s-information?hl=en). \n\nSelect ***Show Plot*** ☟ below to see an example of a contextual tooltip. ","pinned":false,"hidden":false,"mode":"md"},{"id":95,"value":"viewof showPlot = Inputs.toggle({ label: \"Show Plot\", value: false })","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":164,"value":"##

Towards Insight and Creativity","pinned":false,"hidden":false,"mode":"md"},{"id":146,"value":"Like this Observable, spreadsheets are software tools that can complement our creativity; an area of thought provoking research:\n","pinned":false,"hidden":false,"mode":"md"},{"id":170,"value":"import { toc } from \"@mbostock/toc\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}