← Level 3 – Chart maker

11 / 12 ⏱ 20 minutes Premium

Export to PDF for a teacher

One file, readable charts, a name in the file name.

A PDF is a snapshot. The workbook is the truth.

You send a teacher a PDF — what they see today. You send a workbook link only when they want to see formulas. A Chart maker PDF must have: readable tables, whole charts, a name in the file name.

Today you put together a hand-in pack: a PDF of three sheets + two chart PNGs + a short email (you prepare the text with a parent).

A pack for a teacher

  1. Check sheets Grades, Pocket, Survey. Charts named. Average in B8, totals fit. Survey: SUM = the number of votes.

  2. On Survey under the chart a cell with a sentence: Most common: roll (8/22). Without a sentence the PDF talks only in pictures.

  3. Print → pick three sheets → PDF. Nama: surname-excel-chartmaker.pdf (no spaces, no special letters in the file name feel free novak-excel-chartmaker.pdf).

  4. The grades chart and the survey chart: Download PNG separately. grades-march.png, survey-snack.png. Into a folder with the PDF.

  5. With a parent write three email sentences: what is in the attachment, that the workbook lives on Drive (do not send a link yet if the teacher did not want it), a sign-off.

💡

Do not send a PDF as a picture in a chat — quality gets smashed. An email attachment or school storage. Chart PNGs are a bonus for a report, not a stand-in for a table in the PDF.

A check before sending

WhatOK?
The PDF opens on a phone and a computer
Charts are not cut
Chart titles are not “Chart 1”
The grade average matches the table
The file name contains a surname

One mistake = a teacher writes back. Five minutes of checking saves a message “send it again”.

What often goes wrong

A screenshot instead of a PDF. A blurry number. Use export from Print.

The survey missing. A PDF of grades only. Pick all three sheets.

A giant file. Ten empty pages — print area from the last lesson.

🏫 Grade average — in the PDF

On sheet Grades B8 with the average must be visible and a teacher will see the formula only in the workbook. In the PDF number 1.8 is enough — formatted right (one decimal).

💰 Pocket money — Kč format

In the PDF korunas must be readable — 50.00 Kč, not 50. Cell format before print.

📊 Class survey — a sentence + a chart

A PDF of sheet Survey = table D:E + a chart + a sentence. A PNG extra for putting into Word. The same numbers everywhere.

🏆 Mini dashboard — not yet

You add a dashboard to a PDF only as a final course hand-in. Now a teacher sees more raw sheets — that is fine for Chart maker.

Now you 💪

First: a PDF of three sheets, named, opened and checked.

Second: two chart PNGs in the same folder. Write (into Catatans) an email text for a teacher — three sentences.

Check: You would send the pack to a teacher without shame. PDF + PNG + a sentence by the survey. A name in the file name.

What to take from this lesson