Tuesday 18 November 2008

Analysing our results

Unfortunately John could not sign into blogger so I will be writing on behalf of John.


After we had split ourself into two groups half made clinometers (see below) whilst the other half made a graph and put last weeks results on to a spreadsheet.

The two factors we measured were the length that the rocket went and also the volume of the water.

First we signed into Brigshaw learning platform. After that we had to open up a spreadsheet in excel and we entered all of the information we had been given using formulas and cells. We highlighted the information and clicked on the button 'make table' in the toolbar at the top.

Then we turned the information into a scatter graph and we found that some were very innacurate so we had to delete some of the 'flukes'. After this we analysed the graph and saw that with no water the rocket wouldn't launch (too little pressure) and with one litre or more the 'rocket' also failed to launch. We found that the best amount of water to put in the two litre bottle was around 450 - 550ml which showed us that this would make the rocket launch the furthest.
Finally we presented the results to the other half of the class(those that had been making clinometers) and they said that this information was quite accurate. One student said 'We started off with around five hundred mililitres and we couldn't get it to take off.' There could be some improvements which we may discuss at a later date.

No comments: