| Spreadsheets in Maths Book 1 is an introduction to spreadsheets and their usefulness as mathematical and analytical tools. The work sheets are based on Microsoft Excel®, but they can also be used with other spreadsheet programs.
Students can work through the activities on each work sheet at their own pace by following the step-by-step instructions on spreasheet techniques and referring to the useful illustrations and screen dumps from the spreadsheet program. Once students have learnt a new technique, they are encouraged to apply their new skills through the Practice Time section.
Topics Included:
- Introduction
- Saving a Spreadsheet
- Speadsheet Tips
- Cut, Copy, Paste and Print
- Fill Command and Finding Totals
- Formatting Spreadsheets
- Averages
- Cell References
- Absolute Cell References
- Calculating Simple Interest
- The Game of Nim
- Consecutive Numbers
- Magic Squares
- Number Theory
- Pythagoras' Theorem
- Heron's Formula
- Area and Perimeter
- Graphing Spreadheets
- Statistics
- Loan Repayments
- Pie Graphs
- Random Numbers
- Dice Simulations
- Graphing Lines
- Fibonacci Numbers
- Compound Interest
- Budgets and Ranking. |