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
|