Tools/Spreadsheets: Difference between revisions

|description=A {{tag|spreadsheet}} probably found itself in school by accident, but in no time at all, its {{tag|calculating}} and {{tag|graph}} 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 are 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