igcse2 – yew wah international school. key concepts creating a data model testing a data model...
TRANSCRIPT
Data AnalysisIGCSE2 – Yew Wah International school
Data AnalysisIGCSE2 – Yew Wah International school
Key Concepts
Creating a data modelTesting a data model
Manipulating dataPresenting data
Data Model
What is a data Model?
It is used to mimic a real situationData models can be used to provide answers to questions
such as“What would happen if I do this”
Data Model
Creating a data Model?
A B C D1234
Column
Row
Active cell
Cell
Address likeA1, B3
Data Model
FormulaeAre used to perform calculations on the cell contents
Add
Subtract
Multiply
DividePower
LabelsFunctions
Data Model
Copy and pasteDrag and drop
AutoFillCtrl
Manually verifying data entry