Gamma Mathematics (NCEA Edition) 

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.

  • To run a spreadsheet, click on its link
  • To download and save a spreadsheet to a folder on your computer, right-click the link, and then click on Save Target As. 



Explanatory and data spreadsheets

Chapter 6 - Simultaneous equations

080 Solving Simultaneous Equations.xls
083 Simultaneous Equations, Graphical Method.xls


Chapter 9 - Parabolas

114 The basic parabola.xls
120 A factorised parabola.xls


Chapter 16 Estimation and limits of accuracy

198 Rounding.xls


Chapter 20 Statistical concepts

275 Pie graph for Fast-food outlets.xls
277 Bar graph for Teeth-cleaning.xls


Chapter 21 - Interpreting statistical information

283 Comparative boxplots.xls
286 Fat content and price data for ice-cream (Ex 21.01 Qn 9).xls

288 Scatterplot - Minimum air temperatures with trend line.xls

291 Price and water usage for dishwashers (Ex 21.02 Qn 3).xls
291 Price and percentage of air in ice-cream (Ex 21.02 Qn 4).xls
293 Height vs arm span (Ex 21.02 Qn 6).xls
293 Water and power consumption at a hotel (Ex 21.02 Qn 7).xls
297 Public transport in Wellington (Ex 21.03 Qn 4).xls
298 Time series and trend lines (Population Growth 1951 - 2001).xls
300 Arrivals from Australia Jan 1991 to Jan 2002 (Ex 21.04 Qn 1).xls
301 Monthly electricity bills (Ex 21.04 Qn 2).xls
302 International visitor arrivals by country of origin 1991 - 2002 (Ex 21.04 Qn 3).xls
303 Digital cameras - price and weight (Ex 21.05 Qn 1).xls
304 Accommodation prices in Christchurch & Queenstown (Ex 21.05 Qn 2).xls
307 Printers - initial cost and ongoing costs (NCEA 1.5 Revision).xls


Chapter 22 - Probability

318 One boy in family of five simulation.xls
321 Simulating tossing two dices.xls


Chapter 24 - Percentages

357 Compound interest.xls
361 Calculating GST (Ex 24.08 Qn 1).xls

362 Calculating GST (Ex 24.08 Qn 2).xls

 

 

Answer spreadsheets

Chapter 4 - Linear equations

053 Jack and the beanstalk.xls


Chapter 9 - Parabolas

117 Translations of parabolas (Ex 9-01 Qns 16-19) Answers.xls
119 Inverted and stretched parabolas (Ex 9-03) Answers.xls

124 Factorised parabolas (Ex 9-05) Answers.xls


Chapter 13 - Volume

164 Flying cats.xls


Chapter 14 - Capacity, Density and time

177 Cheap charters.xls


Chapter
20 - Statistical concepts

278 Simple statistical graphs (Ex 20-04) Answers.xls


Chapter 21 - Interpreting statistical information

286 Fat content and price data for ice-cream (Ex 21-01 Qn 9) Answers.xls
291 Dishwasher prices and water use data (Ex 21-02 Qn 3) Answers.xls

291 Price and percentage of air in ice-cream (Ex 21-02 Qn 4) Answers.xls

292 Length of railways vs motorways (Ex 21-02 Qn 5c) Answers.xls

293 Height vs arm span (Ex 21-02 Qn 6) Answers.xls

293 Water and power consumption at a hotel (Ex 21-2 Qn 7) Answers.xls

297 Public transport in Wellington (Ex 21-3 Qn 4) Answers.xls

301 Monthly Electricity Bills (Ex 21-04 Qn 2) Answers.xls

303 Digital cameras - price and weight (Ex 21-05 Qn 1) Answers.xls

305 Heater data for IXL and EWT (Ex 21-05 Qn 3b&c) Answers.xls

307 Printers - initial cost and ongoing costs (NCEA 1-5 Revision) Answers.xls


Chapter 22 - Probability

319 Softball simulation (Ex 22-03 Qn 7) Answers.xls


Chapter 24 - Percentages

358 Step-by-step compound interest (Ex 24-06) Answers.xls
361 Calculating GST (Ex 24-08 Qn 1) Answers.xls

362 Calculating GST (Ex 24-08 Qn 2) Answers.xls


Chapter 27 - Pythagoras

398 Pythagorean Triples - 1 (Answers).xls
399 Pythagorean Triples - 2 (Answers).xls


Chapter 31 - Angles, parallel lines and polygons

460 EXCELlent Polygons Answers.xls