G061- CHAPTER 4

?
  • Created by: Nadia162N
  • Created on: 20-04-17 11:27
View mindmap
  • CHAPTER 4
    • Modelling Software
      • Object modelling 
        • buildings, cars, aircraft, computer games
        • Use of layers 
        • Virtual representation
        • +Expensive prototypes don’t need to be built
        • +No equipment is damaged
        • +People are not put in any danger
        • +Modifications can be made easily and re-tested quickly
        • +Time can be sped up/slowed down
        • -Results depend entirely on how good the model is
          • -Simulations can’t completely re-create real-life situations
        • -equipment and software are expensive
        • -training required
      • Financial modelling 
        • test results, business income
        • Use spreadsheets
          • +“What if...?” statements can be asked without rebuilding a model from scratch
          • +minimise financial risk
          • +provide quick answers
          • +Graphs can be produced
          • -Some might be too simple to be of any use
          • -time consuming
          • -expensive, bespoke software required
      • Mathematical modelling 
        • Use spreadsheets
          • +“What if...?” statements can be asked without rebuilding a model from scratch
          • +minimise financial risk
          • +provide quick answers
          • +Graphs can be produced
          • -Some might be too simple to be of any use
          • -time consuming
          • -expensive, bespoke software required
    • Worksheet
      • Consists of all the cells on a sheet
    • Workbook
      • A collection of worksheets
    • Row
      • A range of cells across the sheet
    • Column
      • A range of cells down the sheet
    • Range
      • A group of cells
    • Absolute cell referencing
      • Always refers to the same cell
    • Relative cell referencing
      • Changes the cell it references according to the movement of the target cell

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheet concepts resources »