2c:null 2d:["$","title",null,{"children":"Facts 🢂 Knowledge 🢂 Wisdom | Mario Delgado | Observable"}] 32: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" }) ] }); }33:[{"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}] 30:{"id":"2756f2fdd355a49d","slug":null,"title":"Facts 🢂 Knowledge 🢂 Wisdom","thumbnail":"2c5a0e947b03498f61fb8c8afd1b73603737b2c6a7b1f17d9406d5be0f82d918","access_level":"public","create_time":"$D2023-01-12T10:30:06.919Z","update_time":"$D2023-02-02T18:39:11.588Z","view_time":null,"first_public_time":"$D2023-01-12T10:52:26.561Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"f57b9f8a19d28778","login":"mariodelgadosr","name":"Mario Delgado ","avatar_url":"https://avatars-next.observableusercontent.com/2d2982ad09c4ca9dfd6570810ae00301e0db6ef798c4f7025ea03d4325d4807d","tier":"starter_2024"},"version":214,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"1d3988d482a8ec0f","login":"mariodelgadosr","name":"Mario Delgado ","avatar_url":"https://avatars-next.observableusercontent.com/2d2982ad09c4ca9dfd6570810ae00301e0db6ef798c4f7025ea03d4325d4807d","tier":null}],"members":[{"type":"individual","id":"1d3988d482a8ec0f","login":"mariodelgadosr","name":"Mario Delgado ","avatar_url":"https://avatars-next.observableusercontent.com/2d2982ad09c4ca9dfd6570810ae00301e0db6ef798c4f7025ea03d4325d4807d","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"acca8c9ab863046d","slug":"online-spreadsheets-for-household-finance","title":"Online Spreadsheets for Household Finance","owner":{"id":"f57b9f8a19d28778","login":"mariodelgadosr","name":"Mario Delgado "}},"type":"notebook","body":{"title":"Facts 🢂 Knowledge 🢂 Wisdom","cells":[{"id":0,"value":"# Facts 🢂 Knowledge 🢂 Wisdom\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":167,"value":"toc(\"H2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"##

Lessons from Academia","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":95,"value":"viewof showPlot = Inputs.toggle({ label: \"Show Plot\", value: false })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"##

Towards Insight and Creativity","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":170,"value":"import { toc } from \"@mbostock/toc\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 31:"$30:body"