Please enable JavaScript.

Coggle requires JavaScript to display documents.

Question 9 (Spreadsheets (Automatic Recalculation (If one variable that…

- - - - E.g. If someones hourly pay is changed then their wages are automatically recalculated.
  - - - E.g. Manager giving pay rise; can change to different amounts to see if they can afford.
  - - - E.g. Manager can look at graph to see what was selling more or less.
  - - - E.g. When calculating quotes, such as, number of items for a customer.
- - - - -Cheaper; no cars destroyed.
      - -Safer; nobody is hurt.
      - -Different scenarios can be explored by changing variables.
    - - -Data errors will ruin accuracy.
      - -Large, powerful computer is needed.
      - -Will never be completely accurate due to oversimplification.
  - - - -Cheaper; not going to waste money on impossible actions.
      - -Possible to experience a lot more situations by changing different variables.
      - -Can save time; see what will happen after one year.
    - - -Accuracy of rules and variables.
      - -Some situations are hard to model.
      - -Always some difference between reality and simulation.
  - - - -Can predict path of hurricanes; prepare for evacuations.
      - -Help farmers plan work.
      - -Only takes one hour to predict 6-day forecast.
    - - -Cost of buying a supercomputer.
      - -Long range forecasts will never be 100% accurate.