Activity 01
Spreadsheet Hunt: Weather Data Outliers
Provide datasets of daily temperatures. Students sort data in spreadsheets, calculate averages, and highlight points more than 1.5 times the range from the mean. Pairs discuss and mark potential outliers with colours, then share findings.
Explain how to identify an outlier in a given dataset.
Facilitation TipDuring Spreadsheet Hunt, circulate and ask each pair to explain why they marked a certain day as an outlier so you can catch any ‘highest or lowest only’ reasoning early.
What to look forPresent students with a small spreadsheet of data, for example, daily rainfall amounts for a month. Ask them to identify any data points that seem unusually high or low and write down their reasons for choosing them.