5 - 14

Mathematics
Information Handling

Jo Roger

 

Kingsbarns Primary
Level D

Allowing pupils to produce work to present to others is a motivating way to extend their language skills.

Spreadsheets can capture children's imagination!

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!

 

 

 


Good Practice - 5 - 14