Science skill: Tabulating experimental data

Aim

To learn how to build a clear, complete data table that records readings and derived values correctly.

Variables

• Manipulated: The manipulated variable is placed in the first column, listed in order.
• Responding: The responding variable (and its repeats and average) follows in the next columns.
• Constant: Constant variables are noted beside the table rather than given data columns.

Apparatus & materials

• Ruler
• Sharp pencil
• The recorded readings from the experiment

Procedure

1. Draw the table with a ruler before you start, with a clear grid of rows and columns.
2. Head each column with the quantity and its unit, written as a ratio such as l / cm or T / s.
3. Put the manipulated variable in the first column, arranged in increasing order.
4. Add columns for repeated readings and their average where readings are repeated.
5. Add columns for any derived quantities you will need, such as T² or 1/V.
6. Record every reading to a consistent number of decimal places that matches the precision of the instrument.

Tabulating results

A good table lists the manipulated variable first, then repeated readings and their average of the responding variable, and finally any derived columns, each headed with the quantity and unit.

The graph

The derived column in the table is often the quantity you plot, so plan the table so the axes of your graph can be read straight from it.

Analysis

Examiners award credit for column headings that include the correct unit, for readings recorded to a consistent number of decimal places, and for correctly calculated derived values.

A worked table and what it shows

This skill is best learned by building one table well. Suppose you timed 20 oscillations of a pendulum at several lengths.

A clear table records the manipulated variable first, then the repeated readings and their average, then any derived column (label the entries as example data):

• l / cm = 20.0; t₁ / s = 18.1; t₂ / s = 18.3; average t / s = 18.2; T = t/20 / s = 0.91; T² / s² = 0.83
• l / cm = 40.0; t₁ / s = 25.5; t₂ / s = 25.7; average t / s = 25.6; T / s = 1.28; T² / s² = 1.64
• l / cm = 60.0; t₁ / s = 31.2; t₂ / s = 31.4; average t / s = 31.3; T / s = 1.57; T² / s² = 2.46

What this shows is order and completeness. Every column is headed with a quantity and its unit, the readings keep a consistent number of decimal places, and the derived columns T and T² are calculated correctly, ready to plot.

From the table to the graph axes

A well-planned table already contains your graph. The derived column is usually the quantity you plot, so the axes can be read straight from the table headings.

For the pendulum data you would plot T² (y-axis) against l (x-axis), taking both columns directly from the table.

Notice how the ratio-style heading helps. Writing T² / s² in the heading means the numbers in the column are pure values, so the axis is labelled the same way and the gradient carries clean units.

One worked derived value: T = t ÷ 20 = 18.2 s ÷ 20 = 0.91 s, then T² = (0.91 s)² = 0.83 s².

Planning the derived column before you start saves rework: you record the raw times once, and the columns you need for the graph are already sitting there.

Marks examiners look for

Simple rules that keep a table tidy: put the unit in the column heading only, not beside every reading; keep the same number of decimal places down each column; and never mix different units in one column.

For the Paper-3 science-process skills, the marks are awarded for:

• Column headings that state the quantity and the correct unit, written as a ratio such as l / cm or T / s.
• Readings recorded to a consistent number of decimal places that matches the instrument's precision.
• Repeated readings with a correctly calculated average.
• Derived values (such as T²) calculated correctly.
• A neat table drawn with a ruler, with the manipulated variable in the first column in order.

Source: DSKP KSSM Physics Form 4 and 5 (Versi English) (Bahagian Pembangunan Kurikulum (BPK), KPM)