42632
Description
Chapter 4
- Mathematical Modelling
- Based on rows and columns so sequencing can be used
- Functions and formulae used to allow numbers to be input
and for any changes to be automatically recalculated
- Many scenarios can be tried out
- What-If questions allow values
to be changed to see the effect
- Goal-seeking
- Variables and constants used
- Cells and ranges can be given names to
make it easier for the user to understand
- Based on rows and columns so sequencing can be used
- Modelling Of Objects
- Create a natural representation of an object
- Effect of external influences
- Questions can be asked
- Rotated, shown in detail
- Create a natural representation of an object
- Variables, Formulae, Rules and Functions
- Variables
- Cell reference or cell name
- Identifier associated with a
particular cell that contains a value
- Value contained within the variable that is used
- Cell reference or cell name
- Formulae
- Way the calculation is presented
- Numbers, cell references/names,
and mathematical operators
- Way the calculation is presented
- Rules
- Procedures
must be followed
- Sequence of events required
for the calculation to work
- Validation rule applied
- Followed by different
people and a comparable
result obtained
- Procedures
must be followed
- Functions
- Predefined complex formulae
- Reserved words built in; MAX, MIN, SUM etc
- Represent standard routines to
perform common tasks
- Predefined complex formulae
- Variables
- What-If Questions
- Data Models
- Calculations
- Formulae
- Functions
- Rules
- Named cells
- Cell references
- Calculations
- Data Models
Want to create your own Mind Maps for free with GoConqr? Learn more.