This task will enable you to use the Modelling strand of ICT while supporting and enhancing mathematics.

The topic/theme to be supported should be one where formulae are required to calculate a variety of mathematical operations.

Intermediate Task:

Decide on the focus for the activity and the desired learning outcomes.

Decide on the content of the spreadsheet.

Collect the data.

Enter appropriate formulae to calculate a variety of mathematical operations - eg. add two numbers together and multiply the result by two.

Decide what graphs to plot from the information.

Plot and interpret the graphs.

Demonstrate to pupils how to:

  • enter data into a spreadsheet
  • enter appropriate formulae
  • save, retrieve, amend and print the spreadsheet
  • plot a graph from the data
  • save the graph as an image to use in a word processor

Prepare differentiated, focused pupil worksheets.

Set an investigation for the pupils to interpret their results.


Resources

  • spreadsheet program
  • computer
  • printer

Teaching Strategies: Intermediate