5665169
| Question | Answer |
| What is the difference between Data, Information and Knowledge | Data: Simple values (e.g. “1400”, “Bob”, “True”) Information is data in context Knowledge is based on information, and information is based on data |
| Characteristics of Data | Availability, Correctness, Timeliness, Authenticity, Integrity, Consistency, Utility, Possession, Confidentiality, Accuracy, Uniqueness |
| Sources of bad quality data | Human Error Data entry mistakes Online forms People often give false information Data collected by an external organisation may not be accurate |
| Derived Data | Data can be classified as ‘primary’ or ‘secondary’ Secondary data is often called ‘derived’ data Derived data is data that is calculated from other values Any data which is based on the whole data set is also called ‘aggregate’ data Totals, averages |
| Charts and Graphs | Allow us to present data visually Makes it easier to identify interesting patterns and trends |
| Pivot Tables | Allow us to quickly and easily look at aggregate data Very useful when we: Need aggregate measurements (totals, etc) Have a very large data set |
| Goal Seek | Useful tool which allows us to automatically change values in a formula to meet simple conditions |
| Solver | Similar to Goal Seek We can add many constraints to our solution |
| Trend analysis | Taking known ‘past’ data an extrapolating it to predict future ‘data’ |
Want to create your own Flashcards for free with GoConqr? Learn more.