Spreadsheet tutorials

This series of spreadsheet tutorials for excel 10, from the Howard Hughes Medical Institute, work through a range of spreadsheet functions that can be used when analysing data.

Each tutorial contains detailed instructions and a series of exercises to work through. The tutorials start with some of the more...

Transit Math

This series of activities from NASA take a mathematical approach to looking at transits, eclipses and occultations. They are intended as supplementary problems for students looking for additional challenges in mathematics and physical science from age 11 to 19 years.

The problems were created to be authentic...

Which Team Won?

This resource can be used as an introductory exercise into mathematical modelling. The problem is to decide on the winning team in a race. Students need to examine the data and decide on a model to determine the winner.

Overview
This brief overview...

Patriotic Design

In this activity students explore the idea of correlation. The resource contains an overview, teacher guidance, data sheet and handouts. The activity provides an introduction to correlation, showing the basis of Spearman’s Rank Correlation Coefficient, but also indicating there are other methods of trying to...

Population Data

This resource contains seven activities related to population statistics.

Data Assessment is fourteen pages of questions to be used a test of the topics covered in the seven lessons.

Population Change Information Sheet is...

Scams

This resource is designed to introduce students to the need to be wary when an offer seems too good to be true. The resource contains an outline, guidance for teachers and a handout suitable for duplication for students. Students can use simulation or a more theoretical analysis of probability to work out why the...

Climate Change

In this resource students are required to use moving averages to investigate evidence for trends in local temperature change. There are links to the very real political and scientific debates regarding the question of climate change.

Climate Change Overview This brief overview makes...

100m Sprint

In this activity students examine the Olympic 100m winning times from 1928 to 2012. Both men's and women's times show an improvement. The challenge is how to show that there is an improving trend and to show which times show the most improvement. Scatter graphs, regression and the Least Squares Regression Line are...

Fitting numbers

In this Core Maths activity students are asked to play a ‘ladder game’ in order to improve decision making and explore probability theory.

Fitting Numbers: Overview
This teacher guidance contains a range of information including prior student knowledge, suggested approaches and possible...

Histograms

This is a series of interactive excel sheets that look at histograms.

The first sheet contains a histogram displaying a summary of time spent travelling to work. A new set of data can be generated at the click of a button. Alongside the graph tables calculating class width and frequency density can be...