30:T41c,function pointsHeatmapByCategories({ subject }) { const data = questionsAndCategories.filter((d) => d.subject == subject); return Plot.plot({ marginLeft: 150, marginBottom: 170, title: `${formatSubject(subject)} - body dle kategorií`, x: { label: null, tickRotate: -40, tickFormat: d => cat[subject][d] }, y: { label: null, tickFormat: (d) => formatCode(d) }, color: { label: "Body", legend: true, scheme: "YlGnBu" }, marks: [ Plot.cell(data, { ...Plot.group( { fill: "sum" }, { fill: "v", x: "category", y: "code" } ), tip: true }) // Plot.ruleY(data, { // y: "code", // dx: 4, // dy: 0, // filter: (d, i, arr) => { // return false; // const last = i != 0 ? arr[i - 1] : null; // //if (i == 0) console.log(arr); // return last != null && last.grade !== d.grade; // } // }) ] }); }31:T553,function pointsSummary({ subject, grade, year}, totalPoints = 50) { const filteredData = data.filter( (d) => d.subject == subject && (grade == null || d.grade == grade) && (year == null || d.year == year) ); return Plot.plot({ grid: true, axis: null, label: null, width, height: 260, marginTop: 20, marginBottom: 70, title: `${formatSubject(subject)} - body celkem`, subtitle: `z maximálního počtu ${totalPoints} bodů`, marks: [ Plot.axisFx({ lineWidth: 10, anchor: "bottom", dy: 20, text: (d) => { return formatCode(d); // const { grade, year } = parseCode(d); // return `${formatGrade(grade)} ${year}`; } }), Plot.waffleY({ length: 1 }, { y: totalPoints, fillOpacity: 0.4, rx: "100%" }), Plot.waffleY(filteredData, { fx: "code", y: "totalPoints", rx: "100%", fill: "orange", sort: { fx: "y", reverse: true } }), Plot.text(filteredData, { fx: "code", text: (d) => (d.totalPoints / d.maxTotalPoints).toLocaleString("en-US", { style: "percent" }), frameAnchor: "bottom", lineAnchor: "top", dy: 6, fill: "orange", fontSize: 14, fontWeight: "bold" }) ] }); }32:T604,function pointsToMaxPointsByCategories({ subject }) { const data = questionsAndCategories.filter(d => d.subject === subject).map((d) => ({ ...d, tooltip: `${d.v} z ${d.max} - ${d.id}` })); return Plot.plot({ marginLeft: 150, marginBottom: 170, title:`${formatSubject(subject)} - body / maximální počet bodů dle kategorií`, x: { label: null, tickRotate: -40, tickFormat: d => cat[subject][d]}, y: { label: null, tickFormat: (d) => (d != null ? formatCode(d) : "") }, r: { range: [0, 12] }, marks: [ Plot.dot( data, Plot.group( { r: "sum" }, { r: "v", x: "category", y: "code", fill: "lightgreen", } ) ), Plot.dot(data, { ...Plot.group( { r: "sum" }, { r: "max", x: "category", y: "code", //stroke: "blue", //fill: "transparent", title: "tooltip" } ), tip: true, stroke: (arr) => { return arr.some((d) => d.v != d.max) ? "lightsalmon" : "lightgreen"; } }) // Plot.tip([`a.`], { // x: "GRAMMATICAL_CATEGORIES", // y: "C9A-2024", // r: 1, // dy: 3, // anchor: "top" // }) // Plot.tip( // olympians, // Plot.pointer({ // x: "category", // y: "code", // //filter: (d) => d.i, // title: (d) => [d.max, d.v].join("\n\n") // }) // ) ] }); }33:[{"id":"8f9bc8bfc63796b27954e158a81ff1d32b07ddaf9cfa1d2499a6b3679870e8a70a9c22878ca4e7fe477af99fbc990ccdaf5104483e1d14b814240b4c269382b8","href":"https://static.observableusercontent.com/files/8f9bc8bfc63796b27954e158a81ff1d32b07ddaf9cfa1d2499a6b3679870e8a70a9c22878ca4e7fe477af99fbc990ccdaf5104483e1d14b814240b4c269382b8","name":"quiz-categories@4.json","type":"application/json","lastModified":1727117237074.039,"size":49265},{"id":"9817a9072614c904fa1f00df52ee68aecb73e74eb0de203a0918d6ad165ec3e07decf8ca7af567047c9a5e00e1cdb6af4f143692e244971b6cd90069a30859d6","href":"https://static.observableusercontent.com/files/9817a9072614c904fa1f00df52ee68aecb73e74eb0de203a0918d6ad165ec3e07decf8ca7af567047c9a5e00e1cdb6af4f143692e244971b6cd90069a30859d6","name":"quiz-results-gpt-4o@1.json","type":"application/json","lastModified":1727036243195.566,"size":142643},{"id":"0dafb9c092f9312ab83d671be77ded982a3846c21c7c3657270a0b5da95140f0849290e6cedfcdb37654a3ec82af93c4b4e789ec23c0c6e8704253754ae4a5dd","href":"https://static.observableusercontent.com/files/0dafb9c092f9312ab83d671be77ded982a3846c21c7c3657270a0b5da95140f0849290e6cedfcdb37654a3ec82af93c4b4e789ec23c0c6e8704253754ae4a5dd","name":"quiz-results-gpt-4o@2.json","type":"application/json","lastModified":1731842250658.557,"size":162784},{"id":"7afb0c885d3c24920acaaec491a6d0f9e36c70ee85752600b5357d972538ce6a127f38c672d9063e03feba632da2ed4a4744cfbfaf0675c87e75ab5bd9d18d28","href":"https://static.observableusercontent.com/files/7afb0c885d3c24920acaaec491a6d0f9e36c70ee85752600b5357d972538ce6a127f38c672d9063e03feba632da2ed4a4744cfbfaf0675c87e75ab5bd9d18d28","name":"quiz-categories@5.json","type":"application/json","lastModified":1731842260637.161,"size":60744}] 2e:{"title":"Cermat testy - výsledky testů - řešitel AI","cells":[{"id":4,"value":"# Cermat testy - výsledky testů - řešitel AI\nCermat testy řešeny automaticky pomocí AI modelu **gpt-4o**. \n- Vstupem jsou testová zadání v markdown formátu.\n- Výstupem jsou odpovědi na otázky obsažené v testu uložené ve formátu json.\n- Vyhodnocení probíhá pomocí metadat k testovému zadání ve formátu json.\n\nVíce informací lze nalézt zde [https://github.com/rsamec/cermat](https://github.com/rsamec/cermat).","pinned":false,"hidden":false,"mode":"md"},{"id":766,"value":"pointsSummary({subject:'cz'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1549,"value":"html`

${pointsSummary({subject:'en', year: 2023}, 95)}\n${pointsSummary({subject:'en', year: 2024}, 100)}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1033,"value":"pointsHeatmapByCategories({subject:'cz'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1037,"value":"pointsHeatmapByCategories({subject:'math'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1371,"value":"pointsHeatmapByCategories({subject:'en'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1456,"value":"pointsHeatmapByCategories({subject:'de'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1053,"value":"pointsToMaxPointsByCategories({subject:'cz'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1058,"value":"pointsToMaxPointsByCategories({subject:'math'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1413,"value":"pointsToMaxPointsByCategories({subject:'en'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1567,"value":"pointsToMaxPointsByCategories({subject:'de'})","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"viewof search = Inputs.search(data)","pinned":false,"hidden":false,"mode":"ojs"},{"id":7,"value":"viewof selected = Inputs.table(search, {\n required: false,\n columns: [\n \"code\",\n \"subject\",\n \"grade\",\n \"year\",\n \"totalAnswers\",\n \"totalPoints\",\n \"maxTotalPoints\"\n ],\n sort: \"totalPoints\",\n reverse: true,\n format: {\n grade: (d) => formatPeriod(d),\n subject: d => formatSubject(d), \n totalPoints: sparkbar(d3.max(data, (d) => d.totalPoints)),\n year: d3.format(\"d\") // format as \"1960\" rather than \"1,960\"\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":416,"value":"## Shrnutí výsledků","pinned":false,"hidden":false,"mode":"md"},{"id":44,"value":"viewof selectedResult = {\n const data = selected.flatMap((d) => ({...d.corrections, code: d.code, subject: d.subject, grade: d.grade}));\n return Inputs.table(data,{\n columns: uniqueColumns(data),\n format: columnsFormatter(),\n select: false,\n multiple: false,\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":71,"value":"{\n const tables = [];\n for (let selectedResult of selected) {\n const quiz = rawData[selectedResult.code];\n const data = [\n quiz.points,\n quiz.corrections,\n quiz.answers,\n quiz.correctAnswers, \n ];\n tables.push(htl.html`

${formatCode(selectedResult.code)}

${Inputs.table(data, {\n columns: uniqueColumns(data),\n select: false,\n format: columnsFormatter()\n })}

`);\n }\n return htl.html`

${tables}

`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":1342,"value":"### Plot funkce","pinned":false,"hidden":false,"mode":"md"},{"id":919,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":741,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":944,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":936,"value":"function pointsCellByCategory({subject}) {\n return Plot.plot({\n marginBottom: 100,\n title: formatSubject(subject),\n x: {label: null, tickRotate: 40, tickFormat: cat[subject]},\n y: {label: \"Body\", labelAnchor: \"top\", labelArrow: true, reverse: true, },\n color: {type: \"sqrt\", scheme: \"YlGnBu\"},\n marks: [\n Plot.cell(questionsAndCategories.filter(d => d.subject === subject), Plot.group({fill: \"sum\"}, {x: \"category\", y: \"v\"}))\n ]\n})\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":900,"value":"function pointsByCategory({ subject }) {\n return Plot.barX(\n questionsAndCategories.filter((d) => d.v > 0 && d.subject === subject),\n Plot.groupY({ x: \"sum\" }, { y: \"category\", x: \"v\", fill: \"code\" })\n ).plot({\n y: { tickFormat: cat[subject] },\n marginLeft: 260,\n color: { legend: true }\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":317,"value":"## Testová zadání","pinned":false,"hidden":false,"mode":"md"},{"id":864,"value":"questionsAndCategories = data.filter(d => quizCategories[d.code] != null).flatMap(d => {\n const code = d.code;\n const points = rawData[code].points;\n return quizCategories[code].questions.map(d => ({...d, code, ...parseCode(code), ...points[d.id]}))\n})\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":257,"value":"## Helpers","pinned":false,"hidden":false,"mode":"md"},{"id":430,"value":"html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":34,"value":"function sparkbar(max) {\n return x => htl.html`

${x.toLocaleString(\"en\")}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"function validationBar() {\n return x =>\n htl.html`

${x}

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":102,"value":"function columnsFormatter(questionMax = 33, subQuestionMax = 65) {\n return _.range(1, questionMax)\n .flatMap((d) =>\n [`${d}`].concat(_.range(1, subQuestionMax).map((d2) => `${d}.${d2}`))\n )\n .reduce((out, v) => {\n out[v] = (x) =>\n typeof x === \"boolean\"\n ? htl.html`

${x ? \"OK\" : \"X\"}

`\n : x?.v != null && x?.max != null\n ? x.v == x.max\n ? `${x.v}`\n : `${x.v} z ${x.max}`\n : typeof x ===\"string\" && x.startsWith('http') ? htl.html`obrázek`: x;\n\n return out;\n }, {});\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":164,"value":"function uniqueColumns(data){\n return Array.from(new Set(data.flatMap(d => Object.keys(d)))).sort(naturalSorting)\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"function naturalSorting(a, b) {\n const aParts = a.split(\".\").map(Number);\n const bParts = b.split(\".\").map(Number);\n\n for (let i = 0; i < Math.max(aParts.length, bParts.length); i++) {\n const aVal = aParts[i] || 0; // If part is missing, treat it as 0\n const bVal = bParts[i] || 0;\n\n if (aVal !== bVal) {\n return aVal - bVal; // Compare numerically\n }\n }\n return 0;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"rawData = FileAttachment(\"quiz-results-gpt-4o@2.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1388,"value":"quizCategories = ({\n ...quizLangCategories,\n ...quizCategories3\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1381,"value":"quizLangCategories = [\"AJA-2023\",\"AJB-2023\",\"AJA-2024\",\"AJB-2024\",\"DEA-2023\"].reduce((out, d) => {\n out[d] = {\n questions: _.range(1, 11).map((d, i) => ({\n id: d,\n category: i < 4 ? `LISTENING_${d}` : i < 8 ? `READING_${d}`: `GRAMMER_${d}` \n }))\n };\n return out;\n}, {})","pinned":false,"hidden":false,"mode":"ojs"},{"id":20,"value":"data = Object.entries(rawData).map(([code,values]) => ({code,year: parseInt(code.substr(4,4),10),...values}))","pinned":false,"hidden":false,"mode":"ojs"},{"id":1400,"value":"quizCategories3 = FileAttachment(\"quiz-categories@5.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1498,"value":"import {categories as cat, parseCode, formatCode, formatGrade, formatPeriod, formatSubject} from \"@rsamec/quiz-utils\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}