modelling ict

james buchan
Mind Map by james buchan, updated more than 1 year ago
james buchan
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.
Tags

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 advantages of using spreadsheet models
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
Show full summary Hide full summary

Similar

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