The Average Smarties Investigation
This is a user guide to creating a spreadsheet that calculates averages (mean, median and mode) and then gets pupils to think about why certain things happen with averages. During the process students also learn some formatting techniques on EXCEL.
This resource can be used from a Mathematics point of view to look at averages or an ICT point of view to look at formulae use and modelling in spreadsheets
The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4.
You will need to enable the macros for the resource to work properly.
This is a user guide to creating a spreadsheet that calculates averages (mean, median and mode) and then gets pupils to think about why certain things happen with averages. During the process students also learn some formatting techniques on EXCEL.
This resource can be used from a Mathematics point of view to look at averages or an ICT point of view to look at formulae use and modelling in spreadsheets
The resources are written using EXCEL 2013 and include VBA code to randomise questions and include countdown timers. Worksheets are formatted for printing on a single sheet of A4.
You will need to enable the macros for the resource to work properly.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£2.00