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.

SMILE Spreadsheets

This resource from SMILE Mathematics contains 20 activities for using spreadsheets to solve mathematical problems in the classroom, rather than gaining spreadsheet skills in the computer room. By encouraging students to use spreadsheets when appropriate to the mathematics, they can be an aid to the development of mathematical thinking. Students should begin working with pencil, paper and a calculator, to allow them to get an understanding of the problem before using a spreadsheet to generate some results for analysis.

The activities:

Target 100 - place value and estimation

Dividing investigation - place value and decimals

Trick or treat - patterns and generalisations

Calculator trial and error - trial and improvement

A rich aunt - cumulative totals or constructing formulae

Again and again - sequences leading to limits

Consecutives - analysis of prime factors

Pamphlets - trial and improvement

Differences - sequences from polynomials leading to generalisations

Percentage problems - compound percentage increase or decrease

Jeans - effect of price increases on large quantities of material

Square root investigation - sequences formed by multiples of square roots

Strings - integer parts of a sequence

Averaging out - limits of sequences from the means of previous terms

What's recurring? - recurring and non-recurring decimal parts from fractions

String - open ended activity

A problem of power - calculating powers and modulos

Limits - iterative processes to find cube and square roots

Optimising - maximum volume

Converging sequences - limits of sequences leading to algebraic proof

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.

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