Tools/Spreadsheets/description

From OER in Education
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

A spreadsheet(tool) may have found itself in school by accident, but in no time at all, its calculating(tool) and graph(tool) drawing abilities found it a secure place. In science teaching, a spreadsheet is a ready-made results-table that quickly produces a graph. Graphs are a key tool for analysing data and a spreadsheet makes them with ease. In fact, spreadsheets can produce an astounding range of graphs. Our role as science teachers may be to encourage pupils to communicate effectively using graphs.

The ability of spreadsheets to organise, record and analyse data fulfils aspects of exploring science. If you had a table of students’ personal data, you could sort it into order of shoe size, or work out the average size of the class. You could draw a bar chart to see how the shoe sizes vary across the class. Or draw a scattergraph to see if the sizes vary with height. You might also search for those with black hair and see if they have an eye colour in common. Students can similarly use a spreadsheet to sort and search for patterns in the properties of elements in the periodic table

It may be clear already that students using a spreadsheet in these ways have to work scientifically. They would need to define what they want to find out, collect data, organise it and analyse it. A case can be put that the use of a spreadsheet belongs, and probably deserves a place in science teaching.