Tooltip
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.

Ratio and Proportion

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

The first sheet displays a series of rectangles shaded in two colours. For each diagram the given ratio and the simplified version can be revealed. The sheet also asks what fraction of the whole each colour makes up.

The second sheet generates a series of four equivalent ratios which can be revealed one value at a time.

The following two sheets set out two step by step written methods for solving ratio questions.

The final sheet generates a series of six ratio questions for students to attempt themselves.

Note:
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.

Lists that tag this content