modelling ict

Description

(GEOGRAPHY) Mind Map on modelling ict, created by james buchan on 22/06/2013.
james buchan
Mind Map by james buchan, updated more than 1 year ago
james buchan
Created by james buchan over 11 years ago
40
0

Resource summary

modelling ict
  1. model
    1. a simulation
      1. The 3 main types of data in a spreadsheet model
        1. cells
          1. rows
            1. columns
              1. relative cell referencing:not using the $ in cell references so the cell does change when a formula is copied into another cell
                1. how to format a spreadsheet:including widen columns,change the colour,size,embolden,underline,borders etc
                2. all the cells going down a spreadsheet in a line:labelled with a letter
                3. all the cells going across a spreadsheet in a line:labelled with a number
                4. individual boxes in a spreadsheet where you can enter data
                5. including rules,variables and labels (a.k.a formulae,numbers and text
                6. changing the variables in a model to test different situations
                7. a representation of a real life situation or thing
                  1. what a formula is
                    1. an automatic calculation in a spreadsheet
                      1. cell reference
                        1. i.e A1,C4 etc
                          1. Formula to add/subtract the values of cells together
                            1. formula to multiply values together
                              1. formula to divide values
                                1. how the results of formula change when another cell value is changed:you should be able to predict what will happen in a spreadsheet when a variable is changed.e.g if the price of an item goes up... the total income will go up by
                                  1. absolute cell referencing:using the$to make the cell reference stay the same when a formula is copied into another cell
                8. different value formats including:currency,date,text decimals etc
                  1. what "what if" questions are in a spreadsheet model
                    1. advantages of using spreadsheet models
                      1. graphs,price/cost,profit/loss,surveys,questionnaires
                        1. close question:questions are limited to a few choices
                          1. open question:questions that could have any answer
                  Show full summary Hide full summary

                  Similar

                  Geography Coastal Zones Flashcards
                  Zakiya Tabassum
                  Tectonic Hazards flashcards
                  katiehumphrey
                  Volcanoes
                  1jdjdjd1
                  River Processes and Landforms
                  1jdjdjd1
                  Geography Quiz
                  PatrickNoonan
                  Using GoConqr to study geography
                  Sarah Egan
                  All the Countries of the World and their Capital Cities
                  PatrickNoonan
                  GCSE Geography - Causes of Climate Change
                  Beth Coiley
                  The Rock Cycle
                  eimearkelly3
                  Plate Tectonics
                  eimearkelly3
                  Characteristics and Climate of a hot desert
                  Adam Collinge