| Perhaps the most difficult part of the ICT curriculum
to work up enthusiasm for must be Spreadsheets - or so I thought
before the World Cup proved to be a real saviour! We used this
exciting tournament as a vehicle -
Internet navigation - comparison of the FIFA and BBC sites
as the children researched them both for information on their
chosen group and for minute by minute updates of afternoon
scoring as they waited to add to their spreadsheets. A P6
pupil also went on to use timetables from airlines and then
accommodation sites to choose a 5 star hotel as a base for
attending the final in Yokohama. After she had checked out
the exchange rate for the Yen she was all set to go.
Spreadsheet - we used Excel as the children found the program
easy enough to use and it served all their needs. A spreadsheet
was made for each world cup group and the children updated
the table with each score, realising quickly that they had
to add an extra column - Goal Difference - to be able to sort
teams with the same score. In the end they were sorting according
to 3 categories. As usual, they were not content with ordinary
looking tables and Word Art and Clipart flags were added to
great effect.
The pupil who was ready to leave for Japan worked out how
to make a Yen currency converter using a formula and added
a Euro converter for family use in the summer holidays for
good measure.
Database - Using Granada Toolkit a database was constructed
using information on the teams gleaned from the internet.
Clipart - always ready to push the boundaries of their ICT
knowledge a couple of the class found they could dissect Clipart
and produced a heading for the wall in which a Clipart footballer
was changed into a Brazilian player, with the appropriate
strip - the ball had to be heading for the back of the net
too!
This really turned out to be a fun way to explore the uses
of spreadsheets in particular, but as usual the topic just
mushroomed and so many other parts of the curriculum were
addressed - now to think of a follow-up!
|