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
|