Flashcards

CP1401 Data and Visualisation

d_cull91 CP1401Programming Bachelors Degree English 9 cards

Cards in this deck (9)

1What is the difference between Data, Information and KnowledgeData:
Simple values (e.g. “1400”, “Bob”, “True”)
Information is data in context
Knowledge is based on information, and information is based on data
2Characteristics of DataAvailability, Correctness, Timeliness, Authenticity, Integrity, Consistency, Utility, Possession, Confidentiality, Accuracy, Uniqueness
3Sources of bad quality dataHuman Error
Data entry mistakes
Online forms
People often give false information
Data collected by an external organisation may not be accurate
4Derived DataData 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
5Charts and GraphsAllow us to present data visually
Makes it easier to identify interesting patterns and trends
6Pivot TablesAllow us to quickly and easily look at aggregate data
Very useful when we:
Need aggregate measurements (totals, etc)
Have a very large data set
7Goal SeekUseful tool which allows us to automatically change values in a formula to meet simple conditions
8SolverSimilar to Goal Seek
We can add many constraints to our solution
9Trend analysisTaking known ‘past’ data an extrapolating it to predict future ‘data’