Follow the process
Name and describe the first step in the data analytics process
Data collection/acquisition is gathering raw data through observation, surveys, etc.
This type of data contains countable or measurable things, such as amounts, ranges, counts
Quantitative data
This method of data collection is fast, low-cost, and sends the same questions to everyone.
Survey
Name the validation check that ensures the age field is completed before the form can be submitted
Existence check
Name the aspect of data integrity related to the data source being correct
Authenticity
Name and describe the last step of the data analytics process
Data visualisation is displaying processed data visually through charts, graphs, etc.
Boolean
This type of data is collected directly by researcher
Primary data
Name the validation check that ensures only ages 0 to 100 are accepted
Range check
Name the data integrity issue for a survey for the new the school mascot with 30% of the student body participation.
Completeness
Name the step that removes spelling errors from raw data and include another example
Data cleaning (removing duplicates, standardising date formats, clarifying units, deleting missing data)
A student's phone number is this category of data (not integer)
Qualitative data
This type of data collection allows the researcher to ask follow-up questions and gain deeper insights
Interview
Name the validation check that ensures passwords are exactly 8 characters
Length check
Name the data integrity problem(s) with using rainfall data from Hanoi 10 years ago to determine whether it will rain in HCMC tomorrow.
Timeliness, relatedness
Name the data analytics process in the correct oder
Data collection --> cleaning --> wrangling --> visualisation
This type of question produces qualitative data because respondents can answer many ways
RMIT wants to know how long students spend on Canvas. What is the best data collection method?
Sensor
Name the validation check that ensures value matchrd an acceptable option from a table
Lookup table
Name the data integrity problem(s) with the following university student birthday data: "15/12/2007", "11/29/2020"
Reasonableness, consistency
Name a processing step that could happen during both data cleaning and wrangling
Fixing incorrect data entries, addressing outlier data points
Identify the data type of the following:
15, "Phu", False, '0'
Integer, String, Boolean, Character
A company downloads population statistics from a government database to decide where to open a new store. Name the data type and one advantage.
Secondary data, cheap/quick and available in large quantities
Name 2 types of software interface objects
Dropdown menu, checkbox, radio
What are the 4 aspects of accuracy?
Completeness, correctness, clarity, consistency