Thursday-Friday, May6-7, 2010 (2 series)

Objective(s):
By the end of today you will...
Students will be able to conduct a controlled experiment, tabulating data into excel for further analysis. Students will use appropriate formulas to calculate the average of all trials.

Students will convert tabulated data to graphs and combine their data with class aggregate data

Agenda:
1. Warm Up
2. Announcements
3. 2 and 3 Series Graphs
4. Which Sense is the Fastest? Instructions
5. Data Collection
6. Graphing

Warm Up: (MS EXCEL!)
Two cars are being compared in their ability to accelerate from 0 to 60 MPH. A Jetta and Porche will be accelerated from 0 to 60 in this experiment. We will keep track of how long (in seconds) it takes these cars to go from 0 to 60.  This experiment will be done 5 Times (5 trials) for each car. An average [=average(range)]time will also be calculated for all the trials.

Create (1) a table and (2) a graph for the results.


 Graph the results as well as the average
Here's the results -

Jetta: (in seconds)
Trial #1 = 9.2

Trial #2 = 11
Trial #3 = 13
Trial #4 = 8.5
Trial #5 = 9

Porche: (in seconds)
Trial #1 = 7
Trial #2 = 6
Trial #3 = 5
Trial #4 = 8
Trial #5 = 5.2

Needing a HINT? Take a peak here





No comments: