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
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
- 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
- RequiredMust come first
- HelpfulHelps, but not essential
Before this
3 topics- Recording data and resultsRequired
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 topicScientific Inquiry // Ages 12 to 13
Drawing quantitative conclusions and identifying systematic errors requires the ability to plot and read graphs correctly
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
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).
- Start from a real paired dataset, e.g. spring extension vs load (Load / N: 1, 2, 3; Extension / cm: 3, 6, 9).
- 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.
- 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.
- 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).
- 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
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.
- 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.
- Match: categoric IV → bar chart; continuous IV → line graph; two co-varying continuous measures → scatter graph.
- Sort the two variables onto the correct axes: independent variable on the x-axis, dependent variable on the y-axis.
- Explain for each case why the chosen display reveals (or a wrong one hides) the pattern.
- 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.
- 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.
- Complete a table heading by supplying the correct SI unit in ratio form.
- Sort given variables onto x- vs y-axis (IV vs DV).
- Read a value off a plotted line of best fit using a slider/marker.
- Sketch a line of best fit through a plotted point cloud.
Science // Scientific Inquiry
More in Scientific Inquiry
- Writing Science ReportsAges 13 to 14Thinking skillCommunicate scientific findings in a structured report using appropriate scientific vocabulary, SI units, and standard notation; describe how peer review and…
- Controlling variables (age 11+)Ages 11 to 12Thinking skillForm a testable scientific hypothesis linking an independent variable to a predicted outcome, plan a full investigation identifying independent, dependent, and…
- Evidence Supporting IdeasAges 9 to 11Thinking skillIdentify scientific evidence that has been used to support or refute ideas or arguments, evaluating the strength of evidence
- Drawing conclusions from evidence (age 9+)Ages 9 to 11Thinking skillReport and present findings including conclusions, causal relationships, explanations, and a degree of trust in results using oral and written forms
- Controlling variablesAges 9 to 11Thinking skillPlan different types of scientific enquiries to answer questions, recognising and controlling variables where necessary
- Fair testing (age 9+)Ages 9 to 11Thinking skillUse test results to make predictions and set up further comparative and fair tests to investigate new questions
- Science Can Be RevisedAges 9 to 11Thinking skillScientific knowledge is provisional — it is the best current explanation based on available evidence, and it can and should be revised when better evidence…
- Accurate MeasurementAges 9 to 11MethodTake measurements with increasing accuracy and precision using a range of scientific equipment, taking repeat readings when appropriate