How to Make Data Tables and Graphs for a Science Fair
By the School Project Lab Team · Updated · 5 min read · All grades
In this guide
A science fair data table organizes every measurement you collected, and a graph turns those numbers into a picture that shows the pattern at a glance. To make both, list your independent variable in the first column, record each trial with units, calculate averages, then choose a bar or line graph that fits your data. This guide walks through each step with examples for every grade.
Why Tables and Graphs Matter
Judges often look at the graph before reading anything else on the board. A clear graph tells them right away whether the student collected real data and understood it. A messy or mislabeled graph can make even a careful experiment look confusing.
Data tables matter just as much. They show the raw numbers from every trial, which proves the student actually did the testing and lets judges check the math. Together, the table and graph form the evidence that supports the conclusion.
How to Build a Data Table
A good data table is simple, labeled and complete. Follow these steps:
- Give it a title that describes what was measured, like "Time for Ice Cubes to Melt With Different Toppings."
- Make the first column your independent variable, the thing you changed. List each level in its own row: salt, sugar, sand, nothing.
- Add a column for each trial of your dependent variable, the thing you measured. Include units in the heading, like "Trial 1 (minutes)."
- Add an average column at the end.
- Fill in every number from your lab notebook, exactly as recorded.
Here is an example:
| Topping | Trial 1 (min) | Trial 2 (min) | Trial 3 (min) | Average (min) |
|---|---|---|---|---|
| Salt | 11 | 13 | 12 | 12 |
| Sugar | 19 | 21 | 20 | 20 |
| Sand | 23 | 24 | 25 | 24 |
| Nothing (control) | 26 | 25 | 27 | 26 |
Notice that the control group is labeled clearly, and every number has a unit in the heading.
How to Calculate the Average
The average, also called the mean, shows the typical result for each group. To find it:
- Add all the trials for one group together.
- Divide by the number of trials.
For salt: 11 + 13 + 12 = 36 minutes. Then 36 ÷ 3 = 12 minutes.
Round to a sensible number of decimal places. For most elementary and middle school projects, one decimal place or whole numbers is plenty. High school students may also calculate the range (highest minus lowest) or standard deviation to show how spread out their trials were.
Younger children can do this with a parent and a calculator. The important thing is that the student understands what the average means: "If I did this many more times, this is about what I would usually get."
Choosing the Right Graph
Different data needs different graphs. Picking the right one is a skill judges notice.
Bar Graph
Use a bar graph when your independent variable is a set of categories, like types of paper towel, brands of soil or colors of light. Each bar shows the average for one category. The ice-topping example above is perfect for a bar graph.
Line Graph
Use a line graph when your independent variable is a number that changes continuously, like time, temperature or ramp height. Line graphs show trends, such as a plant growing taller each day. Plot each point, then connect them in order.
Scatter Plot
High school students sometimes use a scatter plot to look for a relationship between two measured numbers, such as hours of sunlight and plant height across many plants. A trend line can show the overall direction.
Pie Chart
Pie charts show parts of a whole, like survey answers that add up to 100 percent. They are rarely the best choice for experiment results, so use them only when your data truly represents portions of one total.
How to Draw a Graph Step by Step
Whether by hand or on a computer, every science fair graph needs the same parts.
- Title: Describe the relationship, like "Effect of Topping on Ice Melting Time."
- X-axis (horizontal): Label it with the independent variable.
- Y-axis (vertical): Label it with the dependent variable and its units, like "Average Melting Time (minutes)."
- Scale: Use even steps, such as 0, 5, 10, 15, 20. Start the y-axis at zero for bar graphs so the bars are honest.
- Plot the data: Draw bars or points carefully with a ruler.
- Key or legend: Add one if you use more than one color or line.
For hand-drawn graphs, use graph paper, a sharp pencil first, then trace over with fine-tip markers. Colored pencils make bars stand out without bleeding through the paper. For computer graphs, free spreadsheet programs let you enter your table and insert a chart, but always check that labels and titles are correct before printing.
Parent tip: Ask your child to explain the graph to you without looking at the table. If they can say, "The salt bar is shortest, which means salt melted ice the fastest," they truly understand their results. If not, sit together and trace each bar back to its row in the table.
Common Mistakes to Avoid
Missing units. Every axis label and table heading needs units, such as seconds, centimeters or milliliters.
Uneven scales. Jumping from 0 to 5 to 20 makes the graph misleading. Keep steps equal.
Swapped axes. The thing you changed goes on the x-axis, and the thing you measured goes on the y-axis.
Wrong graph type. Do not connect bar categories with a line. Lines suggest a continuous change that is not there.
Editing data. Never remove a trial because it looks strange. Keep it in the table and mention it in the conclusion as a possible error. Honest data is more important than a perfect-looking graph.
Too much decoration. Clip art and glitter distract. Let the data be the star.
Writing About Your Graph
A graph does not speak for itself; the results section should describe it in one or two sentences. Point out the biggest difference and give the numbers: "Salt melted ice in an average of 12 minutes, less than half the 26 minutes for the control." Then mention any trial that did not fit the pattern and what might explain it. Keep interpretation for the conclusion, and keep the results section focused on what the data shows.
Quick Checklist
Tap the boxes as you go — progress saves on this device only.
- Give your table a title
- Put what you changed in the first column
- Write units in every heading
- Fill in every trial
- Find the average for each group
- Pick a bar or line graph
- Label both axes with units
- Use even steps on your scale
- Give your graph a title
- Explain your graph to a grown-up
Time and Cost Estimate
| Item | Estimate |
|---|---|
| Prep time (organizing notebook data) | 20 to 40 minutes |
| Build time (table and graph) | 45 to 90 minutes |
| Typical cost | $0 to $10 |
| Difficulty | Easy to moderate |
A well-made table and graph turn a pile of numbers into a story anyone can follow. Take your time, label everything and let the student explain what the picture shows, and the results section will become one of the strongest parts of the board.
Frequently asked questions
Should I make my graph by hand or on a computer?
Either is fine for most school fairs. Younger students often learn more by drawing on graph paper, while older students can use free spreadsheet software. Ask your teacher if they have a preference.
What goes on the x-axis and the y-axis?
The independent variable, the thing you changed, goes on the horizontal x-axis. The dependent variable, the thing you measured, goes on the vertical y-axis.
Do I need to show every trial or just the average?
Put every trial in your data table so judges can see your raw data. The graph usually shows the averages, which makes the pattern easier to see at a glance.