These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.

Rounding Numbers

This series of twelve interactive excel sheets explore rounding numbers. New questions can be generated each time by the click of a button. To check the answers click on the smiley face.

In the first sheet students have to round a generated number to the nearest multiple of ten, choosing from two options. In the following sheet the number is to be rounded to the nearest 100.

The third sheet generates a series of six values for students to round to the nearest ten or hundred.

In the third sheet students have to round a series of distances between five UK locations to the nearest 10 miles.

In the fourth sheet students have to select the best approximation from four possible options given for a series of addition or subtraction.

In the following three sheets students have to round up when asked as series of questions that look at how many different buses are needed to transport groups of differing sizes. In the final sheet students also have to calculate how many empty seats there will be.

The eighth sheet calculates the distance from London to various cities in Europe. By clicking on the city the distance in miles and kilometres can then be shown, and the distance rounded to the nearest 10 or 100 can also be revealed.

The ninth sheet generates a series of multiplication questions in which students have to select the best approximation of the four possible options given. In the tenth sheet students have to estimate the answer to a question involving division.

The final sheet generates a series of weights, in kilograms, displayed on a scale. Students have to round the value shown to the nearest 10 and 20kg.

This program was designed to be viewed on a screen with a resolution of 1024 x 768. Users may have to adjust the resolution of their screen for the pages to display as was originally intended. The program uses macros which need to be enabled on the users machine.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.


Show downloads

Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.