Intermediate
60 mins
Teacher/Student led
+65 XP

Advanced Chart Interpretation

Learn how to interpret charts by spotting trends, outliers and hidden averages. Write short non-technical paragraphs that highlight the largest and smallest values and connect each chart to a useful decision for your project.

Teacher Class Feed

Load previous activity

    1 - Introduction ~5 mins

    Welcome

    A chart without a plain-English read is just a picture. Decision-makers (a Work Experience supervisor, a club treasurer, an examiner at your VET interview) need the story: what is rising or falling, what is unusual, and what you should do next. Today you learn to write that story in a few clear sentences under every chart in your Specialism portfolio.

    By the end of this lesson, you will be able to:

    • Read charts for trends, outliers, and averages that hide the real pattern
    • Write a short non-technical interpretation that names the biggest and smallest values
    • Link each chart to one decision it informs for your Something Real project

    Warm-up

    If someone only had ten seconds, what is the single most important thing a chart is trying to say?

    • If you already have a project chart in 09_specialism/sm3/, think of that chart and name its one-sentence story.
    • If you do not have a project chart yet, use the GAA stall idea on the board (€50 most weeks, €95 on match day) and say the one thing a club treasurer should notice.

    2 - Key Concepts ~6 mins

    Use this table while you write. Every portfolio chart interpretation should hit all four beats in the last row.

    Tip

    Quick reminder: average = add up the values ÷ how many weeks (or rows) you have.

    ConceptWhy it mattersExample
    Trend — the overall direction the numbers move across the chart (rising, falling, steady, or mixed)Readers decide faster when you name the pattern instead of listing every bar or pointWeekly sales for a phone-case side hustle climb from €40 in week 1 to €70 in week 6
    Outlier — a value that sits far above or below the rest of the setOne wild week can fool you into ordering stock or planning hours for a level that almost never happensA GAA club stall takes €95 on match day and about €50 every other week — €95 is the outlier
    Hidden average — when the average is pulled up or down by outliers so it no longer matches a normal dayPlanning from the average alone can waste money or leave you short; always ask what a typical value looks like without the extremeAverage sales ≈ €57 because of match day, but a typical quiet week is nearer €50
    Chart interpretation paragraph — three to four plain sentences: trend, biggest value, smallest value, one decision the chart informsNon-technical readers (supervisors, examiners, community contacts) get the signal without needing spreadsheet skillsSee the model paragraph your teacher shows after the practice chart

    Model paragraph structure

    Key point

    Write in this order every time: (1) name the trend in everyday language, (2) state the biggest value and what it is, (3) state the smallest value and what it is, (4) name one decision the chart should change. Avoid jargon. Prefer "sales stayed steady most weeks" over "the dataset exhibits low variance".

    If you want a writing frame later, use the Four-beat chart interpretation scaffold worksheet (Trend / Biggest value / Smallest value / Decision).

    3 - Step-by-step Task ~15 mins

    You will build a tiny practice sheet with sample weekly sales, glance at the average, add a simple column chart, then fill a four-beat frame and rewrite it in your own words. That shape is what you will use on your own project charts next.

    4 - Common Issues ~4 mins

    Common Issues

    IssueSolution
    My paragraph only describes the chart shape ("bars go up")Add numbers: name the biggest value, the smallest value, and the units (€, hours, tickets)
    I used the average as if it were a normal weekCheck for an outlier first. If one value is far above or below the rest, say so and plan from a typical value instead
    I cannot fit the paragraph under the chartType the heading and paragraph in cells below or beside the chart (as in the practice file). Widen the column and turn on wrap text so it stays readable
    I am not sure what "decision" to writeAsk: what would someone change after reading this chart — stock levels, opening hours, ticket price, shift length, or a project deadline?

    5 - Independent Practice ~20 mins

    Independent Practice

    Your goal: Put a clear four-beat interpretation under each chart in your Something Real spreadsheet so a non-technical reader can act on the numbers without opening the formulas.
    Time: ~20 minutes
    Task: Open your existing Something Real project workbook in {{code:09_specialism/sm3/}} — the file that already holds your charts from earlier in this unit, usually named {{code:sm3_project_data}}. Work in that named file only: do not type project interpretations into {{code:sm3_interpretation_practice}}. Add a {{code:Chart interpretation}} heading and a three-to-four sentence paragraph under each chart you already have (minimum one full four-beat paragraph today). If you only have one chart, make that paragraph strong and note in a nearby cell where a second chart will go later for KA2. If you do not have a project chart yet, stay in {{code:sm3_interpretation_practice}}, clear any model wording, and write a full four-beat interpretation of the practice stall chart in your own words; add a note in a cell saying where your real project chart will be added for KA2. Keep {{code:sm3_interpretation_practice}} open only as a shape reminder. If the decision sentence feels stuck, ask: what would I change next week because of this chart — stock, price, hours, or deadline? One concrete change is enough; it does not need to sound fancy. Anyone who wants a writing frame can use the Four-beat scaffold worksheet. Near the end of the block your teacher will call a 3-minute screen swap.
    Success criteria:
    • Interpretations are saved in the correct named file ({{code:sm3_project_data}}, or {{code:sm3_interpretation_practice}} only if you had no project chart yet)
    • At least one full four-beat paragraph sits under or beside a chart (more if you already have several charts)
    • Each paragraph names the overall trend plus the biggest and smallest values with units
    • Each paragraph ends with one concrete decision the chart should change for your project
    • After the screen swap, your partner can name a decision from your interpretation alone (without reading the data grid)
    123learn · Online learning platform

    Unlock the full learning experience

    You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

    Hundreds of curriculum-aligned lessons
    Interactive activities in every lesson
    Printable resources & progress tracking
    Copyright Notice
    This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.
    🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more