Data Collection, Tables & Graphing: Sixth Grade Science

Transforming raw numbers into structured data tables and visual graphs allows scientists to identify trends, communicate patterns, and reveal underlying physical laws.

The Principles of Structured Data Collection

During an investigation, data collection must be systematic, prompt, and meticulously organized. Human memory is fallible, so raw measurements must be recorded immediately in a scientific log. Setting up a pre-planned data table before beginning an experiment ensures that every variable, trial, and unit of measurement is accounted for without omission.

+-----------------------------------------------------------------------------+
|                      ANATOMY OF A SCIENTIFIC DATA TABLE                     |
|                                                                             |
|      Title: The Effect of [Independent Variable] on [Dependent Variable]   |
+-------------------+-------------------------------------+-------------------+
| Independent       | Dependent Variable: Time (seconds)  | Average           |
| Variable: Ramp    +---------+---------+---------+-------+ Elapsed           |
| Height (cm)       | Trial 1 | Trial 2 | Trial 3 | Trial 4| Time (s)         |
+-------------------+---------+---------+---------+-------+-------------------+
| 10                | 3.82    | 3.79    | 3.85    | 3.82  | 3.82              |
| 20                | 2.71    | 2.68    | 2.74    | 2.71  | 2.71              |
| 30                | 2.15    | 2.21    | 2.18    | 2.14  | 2.17              |
| 40                | 1.76    | 1.72    | 1.79    | 1.77  | 1.76              |
+-------------------+---------+---------+---------+-------+-------------------+

Table Architecture and Column Labeling

A well-constructed data table follows strict structural conventions:
- The independent variable is positioned in the leftmost column.

- The dependent variable occupies the subsequent columns to the right, divided into individual trials.

- A final right-hand column is reserved for calculated statistics, such as the mathematical mean (average).

- Every column header must include the variable name and the exact unit of measurement enclosed in parentheses. Units should never be written inside individual data cells alongside the numbers; this keeps the numerical data clean for calculation.


Calculating the Mean Across Repeated Trials

Conducting multiple trials reduces the impact of random measurement fluctuations and human reaction time delays. To calculate the mean (average), add the values of all reliable trials together and divide by the total number of trials. If an obvious procedural anomaly occurred during one trial—such as a student accidentally bumping the ramp—that trial is flagged as an outlier, omitted from the calculation, and repeated.

Selecting and Constructing the Correct Graph

Graphs are visual tools that communicate mathematical relationships between variables. Choosing the wrong type of graph obscures relationships and misleads observers.

+-----------------------------------------------------------------------------+
|                        GRAPH SELECTION DECISION GUIDE                       |
+-------------+-------------------------------+-------------------------------+
| Graph Type  | Primary Purpose & Function    | Typical Scientific Example    |
+-------------+-------------------------------+-------------------------------+
| Line Graph  | Shows how a continuous        | Water temperature cooling over|
|             | variable changes over time or | time; seedling height measured|
|             | across a continuous spectrum  | daily for three weeks         |
+-------------+-------------------------------+-------------------------------+
| Bar Graph   | Compares discrete categories  | Average rainfall in six biomes;|
|             | or separate groups            | tensile strength of 4 metals  |
+-------------+-------------------------------+-------------------------------+
| Scatter Plot| Identifies correlation trends | Relationship between foot size|
| & Trendline | between two continuous sets   | and body height in mammals    |
+-------------+-------------------------------+-------------------------------+
| Pie Chart   | Shows proportions or parts of | Atmospheric gas composition;  |
|             | a whole (must sum to 100%)    | mineral abundance in granite  |
+-------------+-------------------------------+-------------------------------+

The TAILS Method for Perfect Graph Construction

To ensure complete accuracy when plotting a scientific graph on grid paper, remember the mnemonic acronym TAILS:
- T - Title: Write a descriptive title stating: "The Effect of [Independent Variable] on [Dependent Variable]."

- A - Axes: Plot the independent variable on the horizontal x-axis and the dependent variable on the vertical y-axis (remember the memory aid DRY MIX: Dependent / Responding on Y, Manipulated / Independent on X).

- I - Intervals: Choose consistent, even numerical intervals along each axis (such as counting by 2s, 5s, 10s, or 50s). Never skip numbers or change spacing between grid lines.

- L - Labels: Clearly label both axes with the variable name and enclose the metric unit in parentheses (e.g., "Elapsed Time (s)" or "Temperature (°C)").

- S - Scale: Scale the graph so that data points fill more than half of the available grid space, avoiding cramped plots in one corner.


+-----------------------------------------------------------------------------+
|                     LINE GRAPH WITH CONTINUOUS TRENDLINE                    |
|                                                                             |
|   Velocity (m/s)                                                            |
|        ^                                                                    |
|     20 |                                        * (4s, 19.6 m/s)            |
|        |                                 *                                  |
|     15 |                          *                                         |
|        |                   *                                                |
|     10 |            *                                                       |
|        |     *                                                              |
|      5 |                                                                    |
|        +---------------------------------------------> Time (seconds)       |
|        0     1      2      3      4      5                                  |
+-----------------------------------------------------------------------------+

Exercises and Solutions

Exercise 1: Choosing Graph Types and Identifying Axes. For each of the following scientific investigations, state whether a line graph or a bar graph is the appropriate visual representation, and identify which variable belongs on the x-axis and which belongs on the y-axis: (a) An investigation measuring the electrical conductivity of four different metal wires (copper, aluminum, iron, and zinc); (b) An investigation tracking the internal body temperature of a hibernating groundhog measured every hour for twenty-four hours.

Solution 1: (a) A bar graph is appropriate because the independent variable consists of discrete, separate categories (different types of metal wires). The x-axis will display the categories of metal wires, and the y-axis will display the electrical conductivity measured in Siemens per meter. (b) A line graph is appropriate because time is a continuous, unbroken variable. The continuous independent variable (Time in hours) will be plotted on the horizontal x-axis, and the dependent variable (Internal Body Temperature in degrees Celsius) will be plotted on the vertical y-axis.

Exercise 2: Identifying Scaling and Graphing Errors. A student creates a distance-time graph on grid paper. Along the horizontal x-axis, the student marks the grid lines with the following numbers: 0, 5, 10, 15, 25, 30, 40. Along the vertical y-axis, the label reads simply "Speed" without any units. Identify two fundamental graphing errors the student made and explain how to correct them using standard scientific conventions.

Solution 2: The first error is inconsistent numerical intervals along the x-axis. The student initially counted by intervals of 5 (from 0 to 15), then jumped by 10 (from 15 to 25), then by 5 (to 30), and then by 10 (to 40). Numerical intervals along an axis must be mathematically uniform; each grid line must increase by the exact same value (e.g., 0, 5, 10, 15, 20, 25, 30, 35, 40). The second error is omitting measurement units on the y-axis. A bare label of "Speed" is ambiguous; the student must specify the exact metric unit in parentheses, such as "Speed (meters per second)" or "Speed (km/h)", so that observers know the magnitude of the data.