Welcome to Analysing Experimental Data

Welcome to one of the most useful chapters in your CCEA GCSE Double Award Science course! Whether you are studying Biology, Chemistry, or Physics, collecting and understanding data is the heart of real science. In your Unit 7: Practical Skills assessment (especially Booklet B, which makes up 17.5% of your total GCSE), you will be asked to read tables, spot patterns, draw graphs, and calculate values.

Don't worry if maths and graph work seem a bit tricky at first. We will break down every single skill step by step so you can pick up maximum marks in your exams!

1. Scientific Variables: The Building Blocks of Any Experiment

Before you can analyse data, you need to understand where the numbers come from. In every experiment, there are three types of variables you must know:

  • Independent Variable: The factor that you (the experimenter) deliberately change or select.
    Where does it go? On the horizontal \(x\)-axis of a graph, and in the first (left-hand) column of a results table.
  • Dependent Variable: The factor that you measure for each change. Its value depends on the independent variable.
    Where does it go? On the vertical \(y\)-axis of a graph, and in the subsequent (right-hand) columns of a results table.
  • Controlled Variables (Control Variables): All the other factors that must be kept constant throughout the experiment. Keeping these the same ensures a fair test and makes your results valid, meaning any changes in the dependent variable are caused only by the independent variable.

Memory Trick:
I change the Independent variable.
The Dependent variable is the Data you measure.

Common Exam Mistake to Avoid: Never just write "keep everything else the same" when asked how to make a test fair. Always name the specific variables you must control (e.g., "keep the temperature of the water bath and the concentration of the acid constant").

Key Takeaway: The independent variable is what you change (\(x\)-axis), the dependent variable is what you measure (\(y\)-axis), and controlled variables are kept constant to ensure validity.

2. Key Scientific Vocabulary: Getting the Definitions Right

Examiners often test your understanding of precision words. Using them correctly will earn you easy marks!

  • Accuracy: How close a measured value is to the true or accepted value.
    Analogy: Hitting the bullseye on a dartboard.
  • Precision: How close repeated measurements are to one another. If you measure something three times and get almost the exact same number, your results are precise (even if your scale was slightly wrong!).
  • Reliability / Repeatability: Results are reliable/repeatable when the same investigator repeats the experiment using the same equipment and method and gets consistent, concordant results.
  • Reproducibility: Results are reproducible when a different person repeats the investigation (or uses different equipment/techniques) and obtains the same pattern or results.
  • Validity: How suitable the investigation is to answer the question being asked. An experiment is valid if it is a fair test (all control variables are kept constant) and uses appropriate measurement tools.
  • Anomalous Result (Outlier): A measurement that does not fit the pattern of the rest of the data or deviates significantly from repeated readings.

Did You Know? Repeating an experiment does not make a single measurement more accurate, but it allows you to spot anomalies and calculate a reliable mean!

Key Takeaway: Precision is about consistency between repeats; accuracy is about closeness to the true value; validity is about having a fair, well-controlled experiment.

3. Recording and Processing Data

A. Rules for Drawing Tables

When presenting data in a table, follow these strict CCEA conventions:

  1. Put the independent variable in the left column.
  2. Put the dependent variable and repeat columns to the right.
  3. Every column header must have the full quantity name and unit, written as Quantity / unit (e.g., \(\text{Time / s}\)) or Quantity (unit) (e.g., \(\text{Volume } (\text{cm}^3)\)).
  4. Never write units inside the data cells! Only put numbers in the grid.
  5. Keep the same number of decimal places down any single column to match the precision of your measuring instrument (e.g., write \(12.0\), \(12.3\), \(12.4\) instead of mixing \(12\), \(12.3\), and \(12.35\)).

B. Calculating the Mean (Average)

When you have repeated measurements, calculate the arithmetic mean:

\(\text{Mean} = \frac{\sum \text{concordant values}}{\text{number of concordant values}}\)

CRUCIAL RULE: Always look out for anomalies first! You must exclude/circle anomalies and NOT include them in your mean calculation.

Example: If three time trials are \(14.2\text{ s}\), \(14.4\text{ s}\), and \(21.8\text{ s}\):
- \(21.8\text{ s}\) is clearly an anomaly.
- Exclude \(21.8\text{ s}\) and calculate: \(\text{Mean} = \frac{14.2 + 14.4}{2} = 14.3\text{ s}\).

C. Calculating the Range

The range shows the spread of your data:

\(\text{Range} = \text{Maximum value} - \text{Minimum value}\)

D. Percentage Change

Very common in biology practicals (e.g., changes in potato mass during osmosis):

\(\text{Percentage Change} = \frac{\text{Change in Value}}{\text{Original Value}} \times 100\)

Example: A potato cylinder has a starting mass of \(2.50\text{ g}\) and ends with a mass of \(2.85\text{ g}\).
1. Change in mass \(= 2.85 - 2.50 = +0.35\text{ g}\)
2. \(\text{Percentage Change} = \frac{0.35}{2.50} \times 100 = +14\%\)

E. Rate of Change / Reaction

To find how fast a change happens:

\(\text{Rate} = \frac{\text{Change in mass, volume, or concentration}}{\text{Time taken}}\quad \text{or}\quad \text{Rate} = \frac{1}{\text{Time}}\)

Key Takeaway: Always check for anomalies and leave them out of your mean calculations. Keep decimal places consistent throughout your table columns.

4. Master Graph Drawing Skills

Drawing graphs accurately is worth a significant number of marks in Booklet B. Follow the CCEA Graph Checklist:

  • Axes & Scales:
    • Independent variable on the \(x\)-axis; dependent variable on the \(y\)-axis.
    • Label both axes clearly with Quantity / unit.
    • Choose sensible, linear scales (multiples of \(1\), \(2\), \(5\), or \(10\)). Never use multiples of \(3\) or \(7\)!
    • Your scale must use more than 50% of the grid along both axes.
  • Plotting Points:
    • Plot each point neatly using a small \(\times\) or a circled dot (\(\odot\)).
    • Points must be accurate to within \(\pm 0.5\) of a small grid square.
  • Line of Best Fit:
    • Draw a single, continuous, smooth thin line using a sharp pencil.
    • Use a ruler if it is a straight line; draw a smooth curve freehand if it bends.
    • Ensure an equal balance of points above and below the line.
    • Do NOT: sketch multiple feathered lines ("tramlines"), connect points dot-to-dot (unless told to), or force the line through \((0,0)\) if the data does not go there!
    • Ignore any obvious anomaly points when positioning your line.

5. Interpreting Graphs & Calculating Gradients

A. Calculating the Gradient of a Straight Line

The gradient tells you the rate of change or the steepness of your line:

\(\text{Gradient } (m) = \frac{\Delta y}{\Delta x} = \frac{y_2 - y_1}{x_2 - x_1}\)

Step-by-Step Method for Gradients:

  1. Draw a large triangle on your line of best fit (it must cover at least half the length of your drawn line).
  2. Read the coordinates \((x_1, y_1)\) and \((x_2, y_2)\) directly from the line of best fit, NOT from your raw data table.
  3. Calculate the vertical change (\(\Delta y = y_2 - y_1\)) and horizontal change (\(\Delta x = x_2 - x_1\)).
  4. Divide \(\Delta y\) by \(\Delta x\) to find the gradient. Include units if asked!

B. Recognising Graph Relationships

  • Directly Proportional:
    A straight line that passes directly through the origin \((0,0)\).
    Formula: \(y = kx\) (if \(x\) doubles, \(y\) doubles).
  • Linear (but NOT proportional):
    A straight line that has a non-zero intercept (does not go through \((0,0)\)).
    Formula: \(y = mx + c\).
  • Inversely Proportional:
    As \(x\) increases, \(y\) decreases such that \(y \propto \frac{1}{x}\) (or \(x \times y = \text{constant}\)). This forms a downward curve that flattens near the axes.
  • Plateau / Limiting Factor:
    A curve that rises at first and then levels off horizontally (common in enzyme reactions as active sites become saturated, or photosynthesis when another factor limits the rate).

Common Exam Mistake to Avoid: Do not describe a graph as "directly proportional" just because it goes up! It is only directly proportional if it is a straight line AND passes through the origin \((0,0)\).

Key Takeaway: For gradients, use a large triangle on the line of best fit. Remember that direct proportionality requires a straight line through \((0,0)\).

Quick Summary Checklist for Unit 7 Data Analysis

  • Independent Variable: Plotted on \(x\)-axis, placed in 1st column of table.
  • Dependent Variable: Plotted on \(y\)-axis, placed in subsequent columns.
  • Control Variables: Kept constant to ensure a valid, fair test.
  • Anomalies: Identified and excluded before calculating means.
  • Tables: Units strictly in headers (\(\text{Quantity / unit}\)); consistent decimal places.
  • Graphs: Sensible scales using \(>50\%\) of the grid; sharp, single line of best fit.
  • Gradient: \(\frac{\Delta y}{\Delta x}\) using a large triangle with points taken from the drawn line.