Sharing is not the end. It is a test.
Before you send the teacher a link or a PDF, go through the Sorter checklist. A hidden filter, a forgotten duplicate, SUM 21 instead of 22 — the teacher sees that before you.
The Sorter does not end with cleaning data. It ends with certainty that the data is ready to go out.
Checklist before sending
-
Filters: on every sheet the filter icon off or “Select all”. All rows visible.
-
Hidden rows/columns: right-click → Unhide. Nothing important hidden.
-
Grade average: B8 = PRŮMĚR(B2:B6). Change one grade — the average moves. Text in column C (Status) fits.
-
Survey: SUMA(E2:E5) = number of respondents. The sentence under the chart uses the same numbers. Raw export on a copy of the sheet.
-
Pocket money: seven days, D (Left) fits with B−C or a formula. No day duplicated
Mon. -
PDF preview: charts whole, print area without empty pages. File name with your last name.
إرسال a teammate a view link for ten minutes. Let them find a mistake before the teacher. Two pairs of eyes > one pride.
Check table
| Sheet | What to check | OK |
|---|---|---|
| Znamky | validation, average, filter off | ☐ |
| Kapesne | Kč format, D formulas | ☐ |
| Pruzkum | COUNTIF, SUM, clean-up C | ☐ |
| Poznamky | not in the PDF/hand-in | ☐ |
What often goes wrong
Sharing with edit rights for the whole class. Someone deletes the average. View or comment.
PDF with the filter on. Rows missing in the PDF — it looks like too few votes.
A link instead of a PDF without agreement. The teacher wanted an attachment — send a PDF. They wanted a live workbook — a view link.
🏫 Grade average — one truth
Average only in B8. Nowhere else 1.8 copied by hand. Dashboard later by a link, not a copy.
💰 Pocket money — private?
Pocket money does not have to be in a workbook shared with the class. For the teacher a PDF of one sheet is enough. Think about what is sensitive.
📊 Class survey — anonymity
Hide respondent names or delete them from the class copy. The chart gets a summary, not a list of names.
🏆 Mini dashboard — later with the Boss
You will use this checklist again before the final dashboard. For now check the data sheets.
Now you 💪
First: go through the check table. Fix what does not pass.
Second: a teammate or a parent — 5 minutes “find a mistake”. Write down what they found.
Check: All ☐ ticked. PDF opened on a phone. Filter off.
What to take from this lesson
- Checklist before sharing = filter, SUM, PDF, rights.
- A teammate review saves embarrassment.
- Poznamky does not belong in the hand-in.
© 2026 Ing. Martin Polak / AlgoRhino · شروط استخدام المحتوى