Physics Experiments for High School: Spreadsheet Graphing

Free physics experiments for high school lessons. Students learn how to collect motion data, calculate velocity and acceleration in a spreadsheet, and use graphs to interpret what happened in the lab.

Overview

Small groups run a short motion investigation using a rolling cart or ball. Each team collects distance-and-time data at several marked positions, builds a spreadsheet that calculates average velocity and average acceleration, and creates three graphs: distance vs. time, velocity vs. time, and acceleration vs. time. Learners then use slope and graph shape to explain the motion and evaluate a simple prediction made at the start of the lab.

Subject Connections

The motion graphing lab strengthens math skills related to slope, rate of change, and unit reasoning. The spreadsheet investigation also builds technology fluency by having groups organize data, apply formulas, and generate graphs that support scientific claims.

Learning Goals

• Collect accurate distance and time data from a repeated motion trial
• Use a spreadsheet to compute average velocity and average acceleration with correct units
• Create and label graphs that include titles, axis labels, and units
• Use slope and graph features to explain motion in words
• Compare patterns across multiple groups’ data and draw conclusions

Materials

• Rolling cart and track, or a smooth ramp and a ball
• Measuring tape or meterstick
• Tape for marking distances
• Stopwatches, with several shared across the class
• Computers for groups with spreadsheet software, such as Excel, Google Sheets, or similar
• Optional: phone slow-motion video for checking timing, controlled according to school policy

Preparation

Set up a straight track or ramp and mark distances at 1 m, 2 m, 3 m, 4 m, and 5 m. Adjust the distance markers if space is limited. Run a sample trial to confirm the rolling cart or ball reliably reaches the final mark. Plan groups of 3–4, with each allocating release, timing, and recording roles. Create a simple spreadsheet template header for teams to copy: Distance, Total Time, Change in Distance, Change in Time, Avg Velocity, Change in Velocity, Avg Acceleration.

Teaching Procedure

Each session fits a standard class period of 45–50 minutes.

Session 1 – Prediction and Data Collection

1. Prompt a quick prediction about motion on two different paths or ramp setups, such as a steeper start versus a gentle slope. Have each group write a one-sentence hypothesis and a one-sentence reason.
2. Activity: Tell the class they will time a cart or ball as the object reaches marked distances, then use the results to build a dataset. Each group assigns roles, including release, timekeepers at each marker, and recorder. Teams run at least three trials and record the total time to each distance mark. Check that each group produces a neat data table with units for every entry.
3. Lead a brief accuracy check. Students identify one likely source of timing error and write one improvement to try next session.

Session 2 – Build the Spreadsheet and Calculate Velocity

1. Model how to enter data and use formulas in one example row. Demonstrate “fill down” to apply the formula to the full column. Have groups recreate the spreadsheet layout in their own file.
2. Activity: Students turn raw timing data into motion quantities. Each team enters distance and time, computes change in distance and change in time between points, and calculates average velocity for each interval. Check learning by having each group show formulas visible in the spreadsheet and explain one velocity value checked by hand for reasonableness.
3. Circulate to confirm that teams write units in headers and do not mix meters and seconds with other units.

Session 3 – Calculate Acceleration and Create Three Graphs

1. Review how slope on a distance vs. time graph represents velocity, and how slope on a velocity vs. time graph represents acceleration. Have groups record the velocity-slope and acceleration-slope relationships in their lab notes with units.
2. Activity: Students generate evidence from graphs. Each group calculates change in velocity and average acceleration by interval, then creates and labels three graphs: distance vs. time, velocity vs. time, and acceleration vs. time. Check whether each graph has a clear title, axis labels, and units.
3. Prompt analysis questions. Students answer in complete sentences using their graphs: what the slope of the distance-time graph represents, what the slope of the velocity-time graph represents, and what a negative value would indicate in context.

Session 4 – Combine Class Data and Compare Patterns

1. Assign each group a label and have them share their distance-time table by copying the table into a shared file or uploading the table through the usual class system. Have each group add at least two other teams’ data as separate series.
2. Activity: Students look for consistency and differences. Each group graphs velocity vs. time and acceleration vs. time with multiple group series, then identifies one similarity across teams and one meaningful difference. Check learning by asking students to annotate one graph, digitally or on paper, with two short evidence notes.
3. Lead a closing discussion. Students revisit the Session 1 hypothesis and write a short conclusion using at least one graph feature as evidence.

Assessment

• Data table completeness and units, with distance marks and times recorded clearly
• Spreadsheet correctness, including formulas, fill-down use, and reasonable values
• Graph quality, including titles, axis labels, units, and readable scales
• Written responses that interpret slope and sign correctly in context
• Conclusion supported by graph evidence

Differentiation

For students that need support, provide a spreadsheet with column headers already entered and include one completed sample formula. Allow support-level groups to focus on one graph, distance vs. time, first. Have them add velocity and acceleration graphs if time allows.

For advanced students, ask them to estimate an instantaneous velocity at a chosen time by using a tangent concept on the distance-time curve or by using a smaller time interval approach. Advanced groups shall explain the difference between average and instantaneous values.

Grade Adaptation

Grade 11 groups performance can be assessed around clean spreadsheet structure, correct units, and interpreting slopes with confidence. Grade 12 groups can extend the analysis: compare multiple trials, discuss uncertainty, and explain how changing the ramp angle or surface affects the graphs and motion model.

Extension Ideas

Have students redesign the experiment to reduce error through role changes, more trials, or a better timing protocol. Students can then compare “before and after” graphs. As an at-home option, when appropriate, individual learners can use a toy car and a measured floor distance with a phone timer, then build a matching motion-analysis spreadsheet and graph set using their own dataset.