E3 - Using and Manipulating data Flashcards

1
Q

What are the two data sources?

A

primary and secondary

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

What is a primary data source?

A

Original research, from the source, no third party (EG: interviews, questionnaires, sensors, measurements)

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

What are the advantages of a primary data source?

A
  • Up to date and valid
  • relevant: direct data gathering to find 1 precise data
  • reliable
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a secondary data source?

A

3rd party gathered data (EG: census data, textbooks, web info, official statistics

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

What are the advantages of a secondary data source?

A
  • cheaper
  • quicker
  • isn’t subject to organisation’s bias
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is the criteria for a reliable data source?

A

Completeness - all data for investigation is included
Accuracy - consistent and can be repeated with the same results, data gathered matches the true value/source
Methods for a good survey - avoid using jargon (professional words), avoid language bias (leading questions), used closed answer questions (easy to analyse)

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

What are the 3 main data collection methods?

A
  • Questionnaire
  • Focus Groups
  • Interview
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a focus group?

A

group asked questions on a topic (product, service, ad…)

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

What are the positives and negatives of Focus Groups?

A

+ can build on eachothers answers = detailed answers
+ wider group than interview meaning it’s cost effective
+ can alter questions to fit ongoing conversations for more detail

  • respondents can influence eachother’s answers
  • qualitative data produce, hard to analyse
  • organising a group for same time = difficult
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a Questionnaire?

A

It consists of closed format questions for statistical / personal info from respondents

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

What are the positives and negatives of Questionnaires?

A

+ good for data from large groups in short time ( more data = more reliable)
+ everyone answers same questions = not bias & more consistent
+ can be done anonymously meaning more honey answers

  • poorly worded questions = bias results
  • no in-depth answers as questions are closed & follw-up questions can’t be asked
  • poor response rates ( busy users )
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is an Interview?

A

It is a 1 on 1 conversation with another person & can ask follow up questions

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

What are the positives and negatives of Interviews?

A

+ good for detailed responses, provide more clarity & ensures questions are fully understood
+ more honesty as there is good personal contact

  • more time consuming for data from more people
  • qualitative data meaning its harder to analyse
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Ensuring Data Accuracy

A

Reasons for Ensuring Data Accuracy:
- PCs have no common sense
( GIGO, run out of stock )

Methods for Ensuring Data Accuracy
Validation
-> ensures data is sensible, but no accurate
Date of Birth - dd/mm/yyyy, ensure data is in the past

Verification
-> ensure data entered matches original source of data
-> proofreading, double entry checking

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

Extracting & Sorting Data

A
  • Queries, allow us to retrieve the data we want

2 key abilities of queries:
> Extracting - select precise fields of data (first name)
> Sorting - ascending/descening order

  • Makes it easier to use data gathered
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Numerical & Data Modelling

A

Numerical Modelling
- math calculations to analyse data & make future predictions ( weather, stock levels etc )

Data Modelling
- process to plan the structure of a database to ensure its stored in the most organised & efficient way

-> table with fields, each field has certaind ata type & properties ( next length )
-> = efficient storing, processing & extracting of data

17
Q

Presenting Data & Results

A

Tabular :
- text presentation of data in a table meaning precise & detailed info for qualitative data

Graphical :
- data presented as chart/diagram = quickly interpret data (spotting trends)

18
Q

Different Implications of User Interfaces for Data Collection ( 7 )

A
  • Ease Of Use
  • Accessibility
  • Error Reduction
  • Intuitiveness
  • Functionality
  • Performance
  • Compatibility
19
Q

Implications of User Interfaces for Data Collection (Ease Of Use)

A
  • Easy interface = good labelling (input boxes), different input options for different types of data to simplify input (data pick, drop-down)
20
Q

Implications of User Interfaces for Data Collection (Accessibility)

A
  • clear & simple interface
  • navigation can be performed with different inputs (mouse..)
  • more contrast scheme so key elements can be identified
  • don’t just use colours for visual uses
  • support changing size of icons, text
21
Q

Implications of User Interfaces for Data Collection (Error Reduction)

A
  • poor labelling = confusion
  • add validation, verification, input masks to indicate format data should be entered in ( postcode - LLN NLL)
  • CLEAR warning messages
22
Q

Implications of User Interfaces for Data Collection (Intuitiveness)

A
  • use without training
  • good labelling, clear navigation
  • online should match paper forms that data is transferred from meaning its easier for inputter
23
Q

Implications of User Interfaces for Data Collection (Functionality)

A
  • performing certain queries & producing report
  • results displayed in useful way
  • if its difficult for user to perform functionality = less productivity
24
Q

Implications of User Interfaces for Data Collection (Performance)

A
  • data collection and processing is faster
  • less steps to do tasks = less confusion and less errors
25
Q

Implications of User Interfaces for Data Collection (Compatibility)

A
  • compatible with other systems which means easily imported
  • spreadsheet to data .;. export/import as a CSV file (generic)