Flashcards
AS IT Spreadsheets
Cards in this deck (18)
- 1CellA rectangle within a spreadsheet where data can be positioned
- 2FormulaA mathematical equation. Where the user types in the calculation themselves using mathematical symbols
- 3OrientationThe direction of text, for example horizontal and vertical
- 4AlignmentPositioning text so that it is in line, for example the left, right or centre
- 5FunctionA ready-made formula representing a complex calculation
- 6ValidationThe process of checking data matches acceptable rules
- 7VerifyTo check that data matches the original data
- 8ImportTo bring in data from another application
- 9ExportTo prepare data for use in another application
- 10Types of test dataNormal
Extreme
Abnormal
Live - 11ModelA computer representation of a real-world process. Created through mathematical analysis of the real world process.
- 12Characteristics of a modelUses CAD
The ability to change variables within the software
Asking what-if questions to see what the result of changing the variables would be
Formula and functions to carry out mathematical calculations
Automatic recalculation
Rules that define how the model behaves
Layers of the model - 13Need for computer modelsTraining people to use equipment
Less risk of negative events using equipment
Costs are saved
Train in scenarios that are unpredictable
Forecasting
Help to design aesthetically pleasing - 14Evaluation of spreadsheet modelsVariables which can be changed to ask what-if
Formula and functions to define rules
Graphs and charts can be produced
Automatic
Conditional formatting to highlight events
Ability to share and lots of people own the software
Only as accurate as the formula and functions
Requires complex rules
Very long time to produce
Can only simulate numbers - 15SimulationUsing a model to predict real life behaviour
- 16Advantages of simulationsCan be used instead of expensive prototypes
Changes to the model can be made quickly
Alternative designs can be used
Unusual events can be tested
Equipment doesn't suffer wear and tear
Dangerous situations can be placed without the risk of injury
Simulations can be sped up - 17Disadvantages of simulationsOnly as good as the model based upon
Software can be expensive
People need to be trained to use the software
Complex models can take years to develop
Impossible to be a perfect real life representation - 18Uses of simulationNatural disaster planning
Pilot training
Car driving
Nuclear science research
Information
- Description
- AS level IT Flashcards on AS IT Spreadsheets, created by Sean Byrne on 09/05/2017.
- Created by
- Sean Byrne · May 2017
- Updated
- May 9, 2017
- Views
- 1
- Rating