Alpha Mathematics spreadsheets

These spreadsheets are Microsoft Excel worksheets.  Each spreadsheet can either be opened and run, or saved to any location on your computer or network.

Worked examples                Simulations                Data Sets                Answers

 

Worked examples 

54           Simple integer division formulas.xls
54           Simple integer division result.xls
69           Terminating decimals - formulas.xls
69           Terminating decimals - results.xls
75           Squares of numbers.xls
143         Lee's monthly budget.xls
151         Compound interest (what you type).xls
151         Compound interest (what you get).xls
189         Spreadsheet powers what you type.xls
189         Spreadsheet powers what you get.xls
190         Multiply powers.xls
202         Matchstick hexagons.xls
204         John's spreadsheet - what he types.xls
204         John's spreadsheet - what he gets.xls
254         y-4x-5 what you type.xls
254         y-4x-5 what you get.xls
474         Year 12 subjects.xls
484         Government Expenses 2006.xls
491         Height vs long jump distance.xls
504         Car colours.xls
506         Average - get.xls
515         Wrist sizes - males and female.xls
527         Access to telecommunications by region.xls

 

Simulations

530         Coin-tossing simulation (fair coin).xls
531         Die-rolling simulation (fair six-sided die).xls
534         Rolling an icosahedron simulation.xls
535         Mystery spinner simulation.xls
539         200 Coin tosses simulation (fair coin).xls

 

Data sets

488         Overseas visitor arrivals.xls
492         Cell phone data.xls
492         Premature birth data.xls
493         Washing machines - volume and water use.xls
507         Urban areas - population.xls
518         Data set for 40 Year 9 students.xls
520         Alpha Mathematics Data Set.xls

 

Answers 

54           Dividing integers Answers.xls
69           Terminating decimals Answers.xls
75           Squares of numbers Answers.xls
118         Decimal detective Answers.xls
136         LCD monitors Answers.xls
145         Bargaining strategy Answers.xls
151         Compound interest Answers.xls
189         Spreadsheet powers Answers.xls
204         Solving equations by comparing spreadsheet columns Answers.xls
250         Fuel economy Answers.xls
257         Ex 18-02 Answers.xls
258         Connecting a rule with a graph Answers.xls
431         Isosceles triangles with a fixed perimeter Answers.xls
482         Sunshine hours Answers.xls
488         Student roll numbers Answers.xls
488         Overseas visitor arrivals Answers.xls
492         Cell phone data Answers.xls
492         Premature birth data Answers.xls
493         Washing machines - volume and water use (Answers).xls
497         New Plymouth temperatures (two-hourly in January) Answers.xls
507         Ex 31-10 Answers.xls
548         All faces different simulation Answers.xls
555         Dividing integers Answers.xls
558         Terminating decimals Answers.xls
559         Squares of numbers Answers.xls
567         Decimal detective Answers.xls
569         LCD monitors Answers.xls
570         Bargaining strategy Answers.xls
570         Compound interest Answers.xls
576         Spreadsheet powers Answers.xls
578         Solving equations by comparing spreadsheet columns Answers.xls
584         Fuel economy Answers.xls
586         Ex 18-02 Answers.xls
587         Connecting a rule with a graph Answers.xls
607         Isosceles triangles with a fixed perimeter Answers.xls
617         Sunshine hours Answers.xls
619         Overseas visitor arrivals Answers.xls
619         Student roll numbers Answers.xls
620         Cell phone data Answers.xls
621         Premature birth data Answers.xls
621         Washing machines - volume and water use (Answers).xls
622         New Plymouth temperatures (two-hourly in January) Answers.xls
623         Ex 31-10 Answers.xls
630         All faces different simulation Answers.xls