KS3: Understanding Data and Information

What does a cell reference in a spreadsheet represent?

• The content of a cell, such as a formula or a value.

• The formatting applied to a cell, like font or colour.

• The location of a cell, made up of a column name and a row number.

• The size of a cell, determining its width and height.

Which of the following best describes secondary source data?

• Data collected and used by the same person.

• Data collected by someone else and used by you.

• Data that is always numerical and quantitative.

• Data that is always qualitative and descriptive.

What is the general term for facts and figures?

• Information

• Data

• Analysis

• Interpretation

What distinguishes information from data?

• Information is always numerical, while data can be text-based.

• Information is raw and unorganised, while data is processed.

• Information is organised and meaningful, while data is raw and unprocessed.

• Information is always collected directly, while data can be from secondary sources.

What characterises primary source data?

• Data that is readily available online.

• Data that you have collected and are using yourself.

• Data that is collected by a third party.

• Data that is always more reliable than secondary sources.

Which of the following is an example of a primary source?

• A textbook summarising historical events.

• A diary entry from a historical figure.

• A newspaper article analysing a recent event.

• A documentary about a scientific discovery.

What is the purpose of a formula in a spreadsheet?

• To change the colour of the cells.

• To perform calculations automatically.

• To organise data into categories.

• To create a visual chart.

What is the main advantage of using a spreadsheet?

• It can only store text data.

• It allows for easy data manipulation and analysis.

• It is only useful for creating charts.

• It can only be used for financial calculations.