Data Management Skill Revision Session 01

Select the correct order for the following steps in data management:

• Defining the needs - Data collection - Analysis -Visualization - Reporting- Sharing.

• Defining the needs - Data collection - Cleaning -Analysis -Visualization - Reporting- Sharing.

• Defining the needs - Data collection - Analysis -Cleaning -Visualization - Reporting- Sharing.

• Data collection -Cleaning - Analysis -Visualization – Reporting - Defining the needs -  Sharing

Data from secondary sources

• is not as important as the data from primary sources

• Data that is collected for the research by the researcher.

• Data that has already been collected for another purpose and is used for new research.

Quantitative data

• Non-numerical nature, with information represented in words, pictures...

• Numerical values that can be measured or counted and used in scientific research.

• Phone Numbers

• Cannot be counted, measured, or easily expressed using numbers.

In Excel: When a formula tries to divide a number by zero.

• #NUM!

• #######

• #REF!

• #DIV/0!

In Excel: When using a formula for incorrect value type.

• #NUM!

• #VALUE!

• #REF!

• #DIV/0!

(multiple correct answers): Select the most important steps for a reliable data collection tool in Excel

• Formatting the cells to define data types

• Formatting the ranges as table

• Restricting the data entry through data validation.

• coloring the table in green.

Restricting the entry to accept only dates before or after a certain date is possible in Excel

• True

• False

In Excel when restricting data entry using drop lists/ranges of values or dates/defined text length... we go to:

• Formatting cells

• Formula

• Data validation

• Developer options