1. Resources Home
  2. Primary
  3. Mathematics
  4. Data and statistics
Averages Lesson

Averages Lesson

Functional Skills/GCSE Foundation- Lesson on finding mean, median, mode and range. Contains a presentation with an activity based on measuring hand size and comparing with hand size of a basketball player (video included) and bingo plenary and accompanying workbook. Included in workbook are exam type questions, an averages codebreaker and a number of other extension activities. A homework also included.
gazza1973
Data Handling Black Cab Traffic Light Waiting Time

Data Handling Black Cab Traffic Light Waiting Time

Microsoft Excel required A new set of numbers every time the file is opened 10 different London cabs use the same route during the day and go through 6 sets of traffic lights. An even number means the light is green and the cab does not have to stop and wait. An odd number, however, means the light is red and the cab has to wait at the traffic light. The time that the cab has to wait is in the Waiting Time in seconds column. Use the data to work out the total waiting time in minutes and seconds that each cab had on the journey. Use the data to work out the total amount of waiting time in minutes and seconds, each Traffic Light had. A purposeful resource that works really well as an extension or homework activity.
pjmcc2
Numeracy Assessment Interactive Spreadsheet

Numeracy Assessment Interactive Spreadsheet

This is a complete numeracy package called 'Lighthouses', the contents of which was developed with colleagues in the Millais Alliance Teaching School. The download is an Excel workbook. There are nine spreadsheets in total, covering key numeracy topics throughout GCSE. The idea is that the questions can be done without a calculator, and there are helpful record sheets included in the package. Click the rubber to start, enter in your answers in the yellow boxes and click the black rectangle to mark it all. Note that your computer will need Microsoft Excel with Calculation Options set to 'Manual' and Macros enabled. There is a set up sheet which gives some advice on how to do this. Clicking the 'rubber' will clear the sheet and recalculate questions and answers. Excel's Zoom Bar can be used to scale the sheet up and down to fit on your monitor. Note that as the questions are randomised, some questions could be repeated. With a constant number of re-generated questions (and answers), students can practice this to their heart's content. After all, practice makes perfect!
Ralphbutcher
YEAR 1 MATHS OBJECTIVES

YEAR 1 MATHS OBJECTIVES

All the maths objectives for Year 1 in one handy checklist. Ideal for tracking individual progression and ensuring curriculum coverage Ideal for use by Private Tutors
moonadaly
YEAR 5 MATHS OBJCTIVES

YEAR 5 MATHS OBJCTIVES

All of the Year 5 Maths objectives in one handy checklist Ideal for tracking progression and ensuring curriculum coverage Ideal for use by Private Tutors
moonadaly
YEAR 4 MATHS OBJECTIVES

YEAR 4 MATHS OBJECTIVES

All of the NC objectives for Year 4 Maths in one handy checklist Ideal for tracking individual progress and for ensuring curriculum coverage Ideal for Private Tutors
moonadaly
YEAR 3 MATHS

YEAR 3 MATHS

All of the Year 3 Maths objectives on one handy checklist Ideal for tracking individual progress and to ensure coverage of all objectives Ideal for Private Tutors
moonadaly
Estimating Mean from Grouped Distribution Interactive Spreadsheet

Estimating Mean from Grouped Distribution Interactive Spreadsheet

An Excel Workbook containing a spreadsheet to practice the GCSE skill of estimating a mean average from a grouped distribution using midpoints where appropriate. The sheet has an associated answer sheet going through each question. The questions have multiple choice answers, generated using the answer and potential misconceptions. If the correct letter is given it turns the answer box green, or red if incorrect. Note that your computer will need Microsoft Excel with Calculation Options set to 'Manual' and Macros enabled. There is a set up sheet which gives some advice on how to do this. Clicking the 'More Questions' black square will clear the sheet and recalculate questions and answers. Excel's Zoom Bar can be used to scale the sheet up and down to fit on your monitor. Note that as the questions are randomised, some questions could be repeated. With a constant number of re-generated questions (and answers), students can practice this to their heart's content. After all, practice makes perfect!
Ralphbutcher
Year 2 Maths objectives checklist

Year 2 Maths objectives checklist

All of the Year 2 Maths objectives in one handy checklist. Ideal for tracking individual progress and ensuring coverage of the NC objectives. Ideal for use by Private Tutors
moonadaly
Practice Exam Style Mean Averages Question Interactive Spreadsheet

Practice Exam Style Mean Averages Question Interactive Spreadsheet

An Excel Workbook containing a spreadsheet to practice the GCSE skill of utilising a mean average to calculate information. The sheet has an associated answer sheet going through each question. The questions have multiple choice answers, generated using the answer and potential misconceptions. If the correct letter is given it turns the answer box green, or red if incorrect. Note that your computer will need Microsoft Excel with Calculation Options set to 'Manual' and Macros enabled. There is a set up sheet which gives some advice on how to do this. Clicking the 'More Questions' black square will clear the sheet and recalculate questions and answers. Excel's Zoom Bar can be used to scale the sheet up and down to fit on your monitor. Note that as the questions are randomised, some questions could be repeated. With a constant number of re-generated questions (and answers), students can practice this to their heart's content. After all, practice makes perfect!
Ralphbutcher