ICT REVISION NOTES
Topic 12 – Modeling
What is a Spreadsheet?
A spread sheet is a table that can contain data; data can be stored using a Spreadsheet.
Features and Functions of a Spreadsheet:
- Data Formats
- Formatting Text
- Formatting numbers
- Common formulas/standard functions
- Relative and absolute cell references
- Lookup, VLookup and Hlookup tables
- Spinners, list boxes and combo boxes…
- 3D Referencing
- AutoFill Lists
Simulation Modelling is producing a series of mathematical equations which can be used to mimic real life situations.
There are many types of simulation modelling software from games to flight simulations, Models can be created to describe the flow of traffic at junctions and the output from the model can be used to alter the time that the traffic lights stay on green.
Uses of Simulation Modelling:
Economic and financial models
o Sales analysis
o Break-even analysis
o Modelling the effects of inflation
o Working out depreciation
o Working out the value of…