Change in time - column C calculates the change in time the same as column B calculated the change in distance. Have students reason this formula for themselves while assisting teams that are struggling. Teams that are ahead can continue inputing data, formatting their spreadsheet or assisting other teams while you assist others teams. All teams should have at least ten data points entered and columns B, C and E calculating correctly before demonstrating the next step. Velocity - this is the simplest calculation and the data necessary for the graph.
Velocity is the change in distance divided by the change in time.
Take a moment to review the work done to this point. Make sure students review their data and that it makes sense. Spreadsheets make calculations easily and quickly, but they do not think. The learners must look for unreasonable results and use their judgment. Show the Graph sheet from the sample spreadsheet and discuss the results.