Related resources for spreadsheets
These resources, covering a range of applications, are just some of the resources that have been developed by the Centre for Learning Innovation. Each uses spreadsheet functions differently according to the analysis and output required. |
The resources can be easily modified to suit a range of context areas. For some of these you may need to select ‘Enable macros’ from the security options.
|
Projectile motionRevise the components of projectile motion (Stage 6 Physics):
Interact with graphs to show the effect of changing variables in projectile motion:
Forces between parallel conductorsThis shows one solution for a particular problem with electric current flowing between two horizontal conductors: RadioactivityThese are basic templates to process radiation counts obtained from radioactive sources passing through different materials:
|
Sunspots image viewerHere, a spreadsheet is used to display images of the sun showing sunspot activity for each month. Each image can be supplemented by a description through a text box or cell note if the user wishes:
MotionFind the acceleration due to gravity for a pendulum using this template, which calculates the period and then graphs it to obtain ‘g’:
Conversion of quantitiesSpreadsheets can be modified to convert a wide range of measurements. See the second sheet of the following resource for conversion factors:
|