the process of detecting and correcting, or removing, corrupt or inaccurate data

Data cleansing

Computing

Using data to support decision making

Global data

The investigative cycle

Capturing data to investigate an issue

Using data to make recommendations

In this unit pupils will discover how to use data to investigate problems and make changes to the world around them. Pupils will be exposed to both global and local data sets and gain an understanding of how visualising data can help with the process of identifying patterns and trends.

Using data science

What is the process called that involves finding and fixing errors or removing incorrect information from a data set?

to ensure the data is accurate and reliable for analysis

You can sometimes use an average value to fill in missing data.

Missing data can cause problems in analysis.

You can’t do anything if data is missing.

Data cleansing can help fix missing values.

Which statement about missing data is incorrect?

Put these steps in order for preparing data for analysis:

the process of finding and fixing errors in data

a value that is not present in the data set

a typical value calculated from several numbers

Which tool can help you visualise a cleansed data set?

Match each step of the investigative cycle to its description:

to collect information in a clear and organised way

What is the main purpose of a data capture form?

What word describes a question that is clear, specific, and unambiguous?

“How many hours do you spend on homework each week?”

Which of these is the best example of a precise question?

to make sure you collect useful and relevant information

Why is it important to decide what data you need before starting an investigation?

You might collect data that is hard to use or doesn’t answer your question.

What could happen if your data capture form is unclear or confusing?

This lesson will be removed by end of Summer Term 2025.

Data cleansing

Lesson outcome

This lesson will be removed by end of Summer Term 2025.