AS IT Modelling key terms

some key terms for ocr as IT on modelling

?
model
consists of data about a thing and rules that control what the data does.
1 of 11
Financial model
used with mathimatical calculations and often done on spreadsheets
2 of 11
what if
an analysis that can predict the effects of the user changing certain varibles to see the outcome.
3 of 11
object model
a vertual representation and can be used to model large objects like buildings
4 of 11
formulae
an instruction to a computer to process data in specific cells, using simple mathimatical calculations to find the value of those cells eg C4+D5
5 of 11
functions
more complicated formulae that are built in to the computer and use words as instructions to work out a calculation
6 of 11
SUM
a function that calculates the total of a range of cells
7 of 11
AVERAGE
calaculates the mean of a range of cells
8 of 11
MIN
calculates the smallest value in a range of data
9 of 11
MAX
calculates the largest value in a range of data
10 of 11
varible
an identifier and are used in what if analysis as the thing the user changes to see the effect that will have on the rest of the model
11 of 11

Other cards in this set

Card 2

Front

used with mathimatical calculations and often done on spreadsheets

Back

Financial model

Card 3

Front

an analysis that can predict the effects of the user changing certain varibles to see the outcome.

Back

Preview of the back of card 3

Card 4

Front

a vertual representation and can be used to model large objects like buildings

Back

Preview of the back of card 4

Card 5

Front

an instruction to a computer to process data in specific cells, using simple mathimatical calculations to find the value of those cells eg C4+D5

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Databases resources »