Historical weather data in Excel

During Computing, Year 5 Kestrels have been looking at historical weather data using the Met Office’s archive website. The children learned about the closest weather station to Birmingham was Sutton Bonington. They also learned about what the weather stations are used for.

Mr Baddhan introduced Microsoft Excel to input some of the weather data. They were asked to use the sum and average formula in their spreadsheets. They then created various graphs to demonstrate the average rainfall in a specific year.

4 thoughts on “Historical weather data in Excel

    1. Using Microsoft Excel for the first time can be challenging, your class did really well considering it was the first time you had used it. Well done Kyann.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.