T5 | Using and Manipulating Data Flashcards

1
Q

Digital data & Information

A

Used to record everything (stock, weather, medical records, birth records etc)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Impacts on organisation

A
  • Shelves/rooms not needed
  • Data searched quickly
  • Data processed easily
  • Data backed up offsite
  • Sales data analysed
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Impact on individuals

A
  • Reducing amount of physical mail

- Invoices automatically emailed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Data accuracy

A

Data must be accurate, if not then the analysis of the data will not be helpful either.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Data accuracy - Common concept

A

Garbage in, Garbage out (GIGO)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Reasons for data inaccuracy

A
  • Outdated
  • Bias
  • Mistyped
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Validation - Definition

A

Checking data is sensible, which helps reduce errors. Doesn’t check its correctness, just checks suitability.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Validation checks:

A
  • Range check
  • Length check
  • Format check
  • Presence check
  • Type check
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Verification - Definition

A

Checking data has been entered correctly, do they match?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Verification methods:

A
  • Double entry check
  • Link sent to email
  • Checking against original documents
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Analysis of Data

A

Once data has been checked for accuracy, it can be processed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Analysis of Data - Examples

A
  • Averages
  • Graphs
  • Filtering
  • Sorting
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Sorting Data - Examples

A

A-Z (example of filters), filters sort data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Queries - Definition

A

Used to select certain information from a database. Criteria can be added as well, SQL used for queries.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Numeric and Data Modelling - Definition

A

Allows businesses to predict costs and performance. Models will show how viable a decision is.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Reports - Definition

A

Combine data, charts and text and can be made into a PDF

17
Q

Charts

A

They can quickly reveal trends in data