Science // Scientific Inquiry

Tables, charts, and graphs

Construct data tables with correct headings and SI units, plot appropriate graph types (bar chart, line graph, scatter graph), draw a line of best fit, and calculate the gradient of a straight-line graph

Ages
12 to 13
Type
Representation
Builds on
3 topics
Leads to
1 topic

Quick check

If the learner collected data on how spring length changes with the weight added, could they put it in a correct table, plot it as a line graph with axes labelled in the right units, draw a line of best fit, and calculate the gradient?

Ask this to see whether the topic is secure.

Topic // Mastery

What mastery looks like

What a learner can do once this topic is secure.
  • Constructs a table with column headings that include quantity and unit (e.g. Mass / g)
  • Selects the appropriate graph type for the data and plots it accurately with labelled axes and scales
  • Draws a line of best fit for linear data and correctly calculates its gradient using two points

Topic // Map

Where this fits

What to learn first and what this topic opens up, with the reason for each link. Required links come first.
  • RequiredMust come first
  • HelpfulHelps, but not essential

Before this

3 topics
  • Scientific Inquiry // Ages 9 to 11

    KS3 graphing (lines of best fit, gradients) extends KS2 ability to construct and interpret line graphs and scatter graphs

  • Bar graphsHelpful

    Mathematics // Data & Statistics // Ages 8 to 9

    Science inquiry recording data in tables and graphs draws on the bar chart and time graph skills from Math data representation

  • Scientific Inquiry // Ages 11 to 12

    Correct use of SI units and significant figures in tables and axes is grounded in the precision/accuracy topic

You are here

Tables, charts, and graphs

Ages 12 to 13 // Representation

Leads to

1 topic

Topic // Research-informed

Teaching notes

From the Marble Skill Taxonomy. These notes have not been validated in classrooms, so treat them as a starting point for your own judgement.

The approach

For ages 12–13, learners work both directions on paired continuous data: they interpret what a line shows (a straight line indicates a constant-rate/linear relationship, and one through the origin — as in this spring data — is additionally proportional) AND construct the representation — a headed data table with ratio-form SI units, a graph type chosen from the data structure, accurately plotted points on evenly-scaled labelled axes, a single line of best fit, and a gradient read from two points on that line with its compound unit. The load-bearing work is construction with feedback at each step; recognition and value-reading tasks test the skill but do not themselves have the learner construct a table and graph from scratch. A spring extension vs load dataset makes the gradient a meaningful physical quantity (extension per unit load, in cm/N; this is the inverse of the spring's stiffness, which is load ÷ extension in N/cm).

Common misconceptions

  • Joining data points dot-to-dot and calling it a line graph, instead of drawing a single best-fit line.
  • Believing the line of best fit must pass through every point or always through the origin.
  • Reading the gradient from raw data points rather than from two points on the drawn line.
  • Choosing a bar chart when both variables are continuous (so the trend/relationship is lost).
  • Omitting units from table headings and axis labels, or writing them inside every cell instead of in the heading.
  • Using a non-uniform, cramped or origin-forced scale that distorts or hides the pattern.
  • Quoting a gradient as a bare number with no unit, treating it as dimensionless.

Useful representations

  • Headed data table with ratio-form units, e.g. column 'Mass / g' | 'Extension / mm'
  • The graph-type decision tree: categoric IV → bar chart; continuous IV → line graph; two continuous measures → scatter graph
  • Labelled, evenly-scaled x–y axes (IV on x, DV on y) with a 'sensible scale' fraction-of-grid heuristic
  • Line of best fit balancing points above and below, with a right-angled 'rise/run' triangle drawn on it
  • Gradient as rise ÷ run carrying compound units (e.g. mm/g), read from two points on the line

Teaching practices

  • Teach the data structure first, then the display: decide whether the independent variable is categoric (→ bar chart) or continuous (→ line/scatter) BEFORE drawing anything, so graph choice is a reasoned decision not a habit.
  • Require the ratio-form unit in every heading and on every axis (e.g. 'Mass / g'), so the numbers in cells and on axes are pure and unambiguous — model it explicitly and mark it every time.
  • Explicitly teach scale choice as a design decision: axes should use at least half the available grid with a sensible interval (1, 2, 5, 10), and demonstrate side-by-side how a squashed or awkward scale hides a trend.
  • Contrast a line of best fit with a dot-to-dot join: show that best fit summarises the trend and averages out scatter, deliberately need NOT pass through every point (or the origin), and enables reading between data.
  • Read the gradient from two widely-separated points ON the line, not from raw data, and always attach the compound unit — practise the rise÷run with the units carried through the calculation.
  • Use real experimental data the child has a stake in (e.g. spring extension vs mass, cooling curves) so the gradient means something physical rather than being an abstract exercise.

Activities to try

  1. 1

    Graphing Studio: from raw data to a gradient

    Why it works: Each table/graph convention exists to make data readable and computable: the graph is not decoration but a machine for extracting a physical quantity, and the gradient is that quantity carried with its unit — while the shape of the line tells you about the relationship (a straight line means a constant rate, and through the origin it is proportional).

    1. Start from a real paired dataset, e.g. spring extension vs load (Load / N: 1, 2, 3; Extension / cm: 3, 6, 9).
    2. Type table column headings; a heading of 'Load' (or 'Mass') alone is flagged until you add the unit as a ratio, e.g. 'Load / N' or 'Mass / g', at which point the column is accepted.
    3. Choose a graph type for the data: if you pick a bar chart for two continuous measures, the x-axis stays in discrete blocks and the trend cannot appear, prompting you to switch to a line/scatter graph so the axis becomes continuous.
    4. Set the axis scales; a cramped scale (e.g. an axis running to 100 when the extensions only reach 9 cm) lights a 'wasted grid' meter and the points huddle in one corner, so you re-space in equal steps until the data fills at least about half the available grid using a sensible interval (1, 2, 5, 10).
    5. Drag a single straight line through the point cloud; a live residual indicator shows points pulling above and below until the pulls balance, and the line deliberately does NOT have to pass through every point (nor be forced through the origin).
  2. 2

    Decide the display before you draw

    Why it works: Graph choice is a reasoned decision driven by the data structure, not a drawing habit; the right display preserves the relationship you want to read.

    1. Given a described dataset, classify the independent variable as categoric (e.g. favourite colours) or continuous (e.g. load in newtons) BEFORE choosing any display.
    2. Match: categoric IV → bar chart; continuous IV → line graph; two co-varying continuous measures → scatter graph.
    3. Sort the two variables onto the correct axes: independent variable on the x-axis, dependent variable on the y-axis.
    4. Explain for each case why the chosen display reveals (or a wrong one hides) the pattern.
  3. 3

    Test your graphing: targeted question set

    Why it works: Confirm that each convention — unit in heading, correct graph type, axis assignment, reading off the line, gradient with units — can be applied independently and under the classic error conditions.

    1. Pick the correct graph type for a described dataset, including a distractor case where a bar chart is tempting but wrong because both variables are continuous.
    2. Complete a table heading by supplying the correct SI unit in ratio form.
    3. Sort given variables onto x- vs y-axis (IV vs DV).
    4. Read a value off a plotted line of best fit using a slider/marker.
    5. Sketch a line of best fit through a plotted point cloud.

Science // Scientific Inquiry