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.

Direct Proportion

This interactive excel file has separate sheets which deal with direct proportion where the functions are linear, quadratic, cubic and square root.

Each sheet begins with a statement of the proportional relationship, the formula with the constant of proportionality and data so that the constant can be calculated. The student then substitutes given values in order to answer further questions. Tables of values and graphs illustrate each of the proportional relationships. Answers can be revealed and new questions generated.

The particular example leading to A=πr2 is dealt with in a similar format on a separate sheet.

The final interactive sheet shows sets of mixed questions with answers available.

There are a further four sheets of questions which may be suitable for use in the classroom.


This program was designed by 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 users' machines.

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