12,782
edits
Tools/Spreadsheets: Difference between revisions
From OER in Education
m
Fixing tagging, as well as cross-curric, vocabulary, distance learning, share practice, DfE, DfEScience templates
mNo edit summary |
m (Fixing tagging, as well as cross-curric, vocabulary, distance learning, share practice, DfE, DfEScience templates) |
||
| Line 3: | Line 3: | ||
|tagline=Numbers, graphs and maths | |tagline=Numbers, graphs and maths | ||
|image=Itinsecondaryscience5.png | |image=Itinsecondaryscience5.png | ||
|description=A {{ | |description=A {{tooltag|spreadsheet}} may have found itself in school by accident, but in no time at all, its {{tooltag|calculating}} and {{tooltag|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 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 <em>scattergraph</em> 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 | 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 <em>scattergraph</em> 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 | ||
