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 statistical information is collected and Sum and Averages are needed - eg. if the topic is Weather, the children can collect information on daily temperatures or daily rainfall. The information can be placed in the spreadsheet, and formulae for creating Sum and Average used.

Pupils could be set investigative tasks to discover the days which were above or below average. This information could be analysed to support classroom activities.

Novice Task:

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

Decide on the content of the spreadsheet.

Collect the data.

Using a spreadsheet program, create a simple tally sheet into which pupils can enter the collected data.

Use the built-in formulae or functions - eg. Sum and/or Average.

Decide what graphs to plot from the information.

Plot and interpret the graphs.

Demonstrate to pupils how to:

  • enter data into a spreadsheet
  • use built-in formulae or functions - eg. Sum and/or Average
  • save, retrieve and print the spreadsheet
  • plot a graph from the data
  • save a graph as an image to use in a word processor

Prepare differentiated, focused pupil worksheets.

Allow pupils to interpret the graphs and hypothesise about the reasons for - eg. the above or below average findings.


Resources

  • spreadsheet program
  • computer
  • printer

Teaching Strategies: Novice