Cambridge Technicals in IT - Unit 02 - LO3.5

What is an example of data cleaning?

• Removing duplicate rows in a table.
• Creating a pie chart for sales data.
• Tracking a vehicle's location.
• Generating a report.

Answer explanation

Data cleaning involves removing unnecessary or inaccurate data to improve accuracy.

What is the purpose of a geographic information system (GIS)?

• Identifying trends in a dataset.
• Tracking the movement of shipping containers.
• Removing outdated customer details.
• Calculating monthly sales.

Answer explanation

GIS is used to map and analyse geographic data, such as tracking shipping containers.

How does visualisation of data help in analysis?

• It removes outdated records.
• It tracks geographic movements.
• It simplifies complex data for better understanding.
• It generates tables for raw data.

Answer explanation

Visualisation simplifies data presentation, making it easier to understand patterns and insights.

What is a key use of data tables?

• To identify trends in data.
• To organise raw data into structured formats.
• To display data visually.
• To process data into graphs.

Answer explanation

Data tables organise raw data into structured formats for easier analysis.

What tool is used to identify trends and patterns in data?

• A pie chart.
• A line graph.
• A bar graph.
• A map.

Answer explanation

Line graphs are commonly used to identify trends and patterns in data.

Which tool is best for visualising proportions?

• Line graph.
• Pie chart.
• Data table.
• GIS.

Answer explanation

Pie charts effectively display proportions between categories.

What is the main use of a data table in a database?

• To visualise data trends.
• To provide structured storage for data.
• To produce charts.
• To clean data.

Answer explanation

Data tables are used to store raw data in an organised format.

How can geographic information systems (GIS) benefit logistics?

• By identifying trends in product sales.
• By visualising profit margins.
• By tracking the location of vehicles and shipments.
• By recording customer feedback.

Answer explanation

GIS can track locations of vehicles and shipments to optimise logistics.

Which stage of data analysis uses data cleaning?

• Identify the need.
• Define scope.
• Process and analyse data.
• Share results.

Answer explanation

Data cleaning is part of processing and analysing data to ensure quality results.

Which is NOT an example of data cleaning?

• Removing inaccurate entries.
• Filtering duplicate entries.
• Plotting a chart.
• Updating outdated values.

Answer explanation

Data cleaning does not involve charting or visualisation.