The teacher has a minute
A dashboard for the teacher is not the whole workbook. It is one screen: project title, three KPIs, a grades chart, optionally a sentence about the survey. No F2, no raw answers, no Poznamky sheet.
The Workbook boss cuts what the Modeller and Chart maker already built.
Put the final dashboard together
-
Sheet Dashboard. A1
Excel project — [name] — March. Bold, bigger. -
Rows 3–5: KPIs from the KPI lesson (C3 average, C4 spending, C5 winner + D5 votes). Formats: decimal, Kč, text.
-
Grades chart: from sheet
Znamkycopy the chart (Ctrl+C on the chart → paste on Dashboard). OR insert a new one from A1:B6 — it must fit with the KPI. Chart title visible. -
Under the chart cell A10: survey sentence
Most common snack: roll (8/22).— a link to numbers D5/E5 or text + D5. -
Hide sheets
Poznamky,Import-test(right-click → Hide sheet). The teacher gets a link with default sheet Dashboard (Sheets: File → Settings → default sheet).
A chart copied onto the dashboard does not update automatically in some versions — a linked chart from the same workbook does. After a grade change check the chart bars. If not, insert the chart again or fix the range.
Dashboard print area
Select A1:F15 (KPI + chart + sentence). Set print area. Landscape. PDF only Dashboard — that is what you send the teacher as the final project poster.
What often goes wrong
KPI hardcoded. You already know — always a link.
A chart without a title. The teacher does not see that they are grades.
Hidden sheets with sensitive pocket money. A teacher with the view right can unhide sheets. Pocket money better in another workbook or only the total on the dashboard.
🏫 Grade average — KPI + chart
C3 and the chart from the same table A1:B6. Consistency.
💰 Pocket money — only the total
C4 = SUMA C, not the whole table of days. Sensitivity + clarity.
📊 Class survey — a sentence
A10 one sentence. Details on hidden Pruzkum.
🏆 Mini dashboard — 完成
This is the mini dashboard from 准备课 — finished. Three numbers, a chart, a sentence. PDF = hand-in.
Now you 💪
First: a dashboard according to the steps above.
Second: PDF of only the dashboard, open on a phone — readable?
Check: The teacher understands the project in 60 s. Hidden sheets OK. Default sheet Dashboard.
What to take from this lesson
- A teacher dashboard = KPI + chart + one sentence.
- Hide helper sheets. Set the default sheet.
- Dashboard PDF = the final poster.
© 2026 Ing. Martin Polak / AlgoRhino · 内容使用条款