News‎ > ‎

9IPT: Analysing with Excel

posted May 15, 2011, 3:34 PM by Eddie Woo   [ updated May 15, 2011, 3:36 PM ]
Download the Mile Run spreadsheet.
  1. Identify the data present in this information system.
  2. Have a look at some of the equations in the cells. What kinds of analysis can you observe?
  3. Experiment with some of the values or equations. What kind of information can be gained from the analysing methods present in this system?
  4. Propose two additional methods of analysis that would be beneficial to this information system, and justify your choices.
Then, make your own spreadsheet to create a what-if scenario. Choose one from the list below:
  1. "Salary calculator" - how much will you earn by a certain age, given a certain salary?
  2. "Interest calculator" - how much interest will a bank account earn for you, given a certain time period and interest rate?
  3. "Tax calculator" - how much tax will you pay on a given income? (ATO) (P.S. This one is tricky!)