Solar System Spreadsheet: The Power of Division

Year 7 Resource: This activity is designed to get students to consider the power of formulas that make use of division in order to come up with observations about Earth in comparison to other planets in the solar system. As well as getting across some spreadsheet practical use it also provokes some observations for science on this topic in considering the sheer distances involved just in our solar system and the way Earth 'measures up' as a planet compared to other planets. There is massive scope for extension with this task into pupil investigation of charts/graphs but also in making comparisons about masses of planets, for instance, in answering questions such as: how many Earths would fit inside Jupiter?