Lesson 4 - data analysis in Excel 

Now that you have collected your environmental data the next step is to analyse it. Making some cool charts or graphs will really help you understand what is going on and hopefully answer some of those scientific questions you asked. Microsoft Excel is a great programme for doing this. It should be available on most school laptops. 

​​

​​

​

​Click for instructions for completing

the lesson: 

​​​​

​​

​​​

There is also a PowerPoint presentation

(with a script in the slide comments)

that the teacher can use to introduce

the lesson:

​​​

​​​​​​​

​

Lastly, if you need some help example

data and charts can be found here:

​​​​

​​

​​​

If you feel up to presenting the PowerPoint presentation, I've recorded myself going through the presentation: (I'm sure you can do it better, give it a go!)

​​

​

​

​

​

​

​

​

​

​