# modelling ict

Mind Map by james buchan, updated more than 1 year ago
 Created by james buchan almost 7 years ago
37
0

### Description

(GEOGRAPHY) Mind Map on modelling ict, created by james buchan on 06/22/2013.

## Resource summary

modelling ict
1 model
1.1 a simulation
1.1.1 The 3 main types of data in a spreadsheet model
1.1.1.1 cells
1.1.1.1.1 rows
1.1.1.1.1.1 columns
1.1.1.1.1.1.1 relative cell referencing:not using the \$ in cell references so the cell does change when a formula is copied into another cell
1.1.1.1.1.1.1.1 how to format a spreadsheet:including widen columns,change the colour,size,embolden,underline,borders etc
1.1.1.1.1.1.2 all the cells going down a spreadsheet in a line:labelled with a letter
1.1.1.1.1.2 all the cells going across a spreadsheet in a line:labelled with a number
1.1.1.1.2 individual boxes in a spreadsheet where you can enter data
1.1.1.2 including rules,variables and labels (a.k.a formulae,numbers and text
1.1.2 changing the variables in a model to test different situations
1.2 a representation of a real life situation or thing
1.2.1 what a formula is
1.2.1.1 an automatic calculation in a spreadsheet
1.2.1.1.1 cell reference
1.2.1.1.1.1 i.e A1,C4 etc
1.2.1.1.1.1.1 Formula to add/subtract the values of cells together
1.2.1.1.1.1.1.1 formula to multiply values together
1.2.1.1.1.1.1.1.1 formula to divide values
1.2.1.1.1.1.1.1.1.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.2.1.1.1.1.1.1.1.1.1 absolute cell referencing:using the\$to make the cell reference stay the same when a formula is copied into another cell
2 different value formats including:currency,date,text decimals etc
2.1 what "what if" questions are in a spreadsheet model
2.1.1.1 graphs,price/cost,profit/loss,surveys,questionnaires
2.1.1.1.1 close question:questions are limited to a few choices
2.1.1.1.1.1 open question:questions that could have any answer

### Similar

Geography Coastal Zones Flashcards
Geography Quiz
Using GoConqr to study geography
All the Countries of the World and their Capital Cities
River Processes and Landforms
Volcanoes
The Rock Cycle
GCSE Geography - Causes of Climate Change
Tectonic Hazards flashcards
Globalisation Case Studies
Characteristics and Climate of a hot desert