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.

Teaching If Statements using EXCEL This is a series of interactive resources to teach IF Statements in EXCEL. The EXCEL workbook contains the following sheets: • A word cloud starter with spreadsheet terms • An interactive “Build an IF statement” whiteboard sheet • 10 x “Build an IF Statement” question sheets designed to practice creating IF statements • 5 x Project sheets where the students need to build a complete interactive test sheet for younger students to practice their maths. These include self-assessment sheets with indicative levels • 3 x Help sheets and example sheets to support students • 1 x Final assessment sheet with timer where the students have to evaluate 5 if statements. (Random number generation so that all students have a different assessment answer set) 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.

ICT Assessment Tracker in EXCEL This is a level tracker for use with KS3 students. The pupils self assess and the member of staff has the option to assess the progress if the tracker is shared, for example, using Office 365. 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.