Analyzing the Results of the Ball Tossing Experiment Using Excel

Good Afternoon Visionaries!

Today you are going to use Excel to create a model (picture) of what happens when a ball is tossed in the air.

Make sure you save your Excel spreadsheet on the student server - do not print it out.

Follow the steps below for completing the Excel part of the project:

1. Open up Microsoft Excel.
2. Copy Table B: Actual Time vs. Height Results onto the Excel spreadsheet.
3. Next, select the bar graph icon at the top.
4. Choose XY (Scatter) for Chart Type.
5. Choose the picture that has curves with the points (middle left).
6. For the data range, highlight only the NUMBERS in your spreadsheet (no words).
7. Make sure "Series in Columns" is checked.
8. Give your chart a title, as welll as the x and y axes (with units!).
9. Choose to place the chart in a new sheet.
10. Compare the Excel graph to the prediction you wrote in your case journal. Sketch what the Excel graph looks like in your journal, next to your prediction.
11. Finally, save your work on the student server, in your own folder.