Collecting, Presenting & Interpreting Data

Collecting, Presenting & Interpreting Data

Lessons covering every topic
Quizzes for every lesson
Awards, experience points & levels
Analytics for student tracking
Course Dashboard
Subscribe

Content Areas

Learning Aim A

Understand how data is collected and used by organisations and its impact on individuals.

Learning Aim B

Be able to create a dashboard using data manipulation tools

Learning Aim C

Be able draw conclusions and review data presentation methods

Modules

Expand All
Characteristics of Data & Information
Expand
The concepts of data and how it is meaningless without converting it into information by adding structure and context.
1 Lesson | 1 Quiz Sample Module
Data & Information
Data & Information
Representing Information
Expand
The different ways of representing information and the situations where they would be used.
2 Lessons | 2 Quizzes
Text, Numbers & Tables
Text, Numbers & Tables
Graphs, Sparklines & Infographics
Graphs, Sparklines & Infographics
Ensuring Data is Suitable for Processing
Expand
The methods that can be used to ensure data input is suitable and within boundaries so that it is ready to be processed.
1 Lesson | 1 Quiz
Validation & Verification Methods
Validation & Verification Methods
Data Collection
Expand
The different types of data collection methods, their strengths & weaknesses, how data collection features affect reliability and how the collection of data could be improved.
3 Lessons | 3 Quizzes
Primary Data Collection Methods
Primary Data Collection Methods
Secondary Data Collection Methods
Secondary Data Collection Methods
Data Collection Features
Data Collection Features
Quality of Information
Expand
The factors that affect the quality of information.
1 Lesson | 1 Quiz
Quality of Information Factors
Quality of Information Factors
Sectors That Use Data Modelling
Expand
How different types of data are used by organisations for data modelling.
2 Lessons | 2 Quizzes
Types of Sectors 1
Types of Sectors 1
Types of Sectors 2
Types of Sectors 2
Threats to Individuals
Expand
The different threats that face individuals who have data stored about them.
1 Lesson | 1 Quiz
Threats to Individuals
Threats to Individuals
Data Processing Methods
Expand
How data can be imported from an external source and how to accurately apply data processing methods to aid decision making.
6 Lessons | 6 Quizzes
Importing Data & Sorting
Importing Data & Sorting
Formulae & Functions
Formulae & Functions
Decision-Making, Lookup & Count
Decision-Making, Lookup & Count
Logical Operators, Outlining, Filtering & Text to Columns
Logical Operators, Outlining, Filtering & Text to Columns
Cell References, Worksheets & Comments
Cell References, Worksheets, Views & Comments
Conditional Formatting, Macros & Views
Conditional Formatting, Macros & Views
Producing a Dashboard
Expand
Use a dashboard to select and display information summaries based on a given data set.
3 Lessons | 3 Quizzes
Showing Data Summaries
Showing Data Summaries
Presentation Methods
Presentation Methods
Presentation Features
Presentation Features
Drawing Conclusions Based On Findings
Expand
Use a dataset and dashboard to present findings and draw conclusions based on your findings.
1 Lesson | 1 Quiz
Drawing Conclusions
Drawing Conclusions
How Presentation Affects Understanding
Expand
How well the presentation methods and features have been used.
1 Lesson | 1 Quiz
How Presentation Affects Understanding
How Presentation Affects Understanding