Cambridge Technicals Unit 2 LO3 [3.2 - 3.5]

Which of the following statements about data cleaning is not true?

• It removes erroneous data

• It removes primary data

• It removes incorrect data

• It removes redundant data

This data analysis tool is used to spot connections and patterns between data

• Data cleaning

• Data tables

• Visualisations

• Trend and pattern identification

How many of the following are characteristics of information used by individuals? (choose 1-4)

• Communication

• Contact management

• Entertainment

• Marketing, promotion and sales

How many of the following are characteristics of information used by organisations? (choose 1-4)

• Management Information Systems

• Big data

• Financial analysis and modelling

• Research

Which of the following is NOT a function of a Management Information System? (choose 1 - 4)

• Decision making

• Contact management

• Tracking interactions between customers/clients/employees

• Storing and analysing data

Which of the following shows the correct order of the stages of data analysis?

• Define Scope > Identify Need > ID Sources > Select Tools > Record and Store > Share Results > Process and Analyse > Source and Select

• Select Tools > Source and Select > Identify Need > ID Sources > Record and Store > Share Results > Process and Analyse > Define Scope

• ID Sources > Define Scope > Source and Select > Select Tools > Record and Store > Share Results > Process and Analyse > Identify Need

• Identify Need > Define Scope > ID Sources > Source and Select > Select Tools > Process and Analyse > Record and Store > Share Results >

Bar charts are best used for which purpose?

• Identifying the relationship between different items of data

• Showing percentage or proportional data

• Providing a comparison between different iterms of data

• Looking at the relationship between different variables

Which of the following are uses of data analysis tools? (choose 1-4 answers)

• Performing calculations

• Exploring "what if" scenarios

• Carrying out research

• Looking for trends and patterns

Which of the following is NOT a method of processing / analysing data?

• Using charts/graphs

• Web pages

• Database tables

• Reports

What factors should be considered before deciding which sources of information should be used? (Choose 1-4)

• Whether it is primary or secondary

• The reliability of data

• Whether the data is unbiased

• Whether it is qualitative or quantitative