Worksheet: The power of data: Using data modelling | IGCSE Cambridge Computing for Year 6 - Class 6 PDF Download

Multiple Choice Questions (MCQs):

Q1: What is the primary purpose of using a data capture form?

A) To enter data directly into a database

B) To gather information before entering it into a database

C) To create a new database table

D) To format and highlight data in a spreadsheet

Ans: B

Data capture forms are used to gather information in the correct format before it is entered into a database.

Q2: Which of the following is NOT a commonly used data type in databases?

A) Currency

B) Number

C) Yes/No

D) Paragraph

Ans: D

Paragraph is not a commonly used data type in databases. The other options (Currency, Number, and Yes/No) are standard data types.

Q3: What is the purpose of a primary key in a database table?

A) To perform calculations on data

B) To set the field size for text data

C) To ensure each record in the table is unique

D) To format and highlight data based on conditions

Ans: C

A primary key is a special field added to a database table to ensure that each record is unique, often using an autonumber field.

Q4: Which of the following is NOT a common feature of spreadsheet applications?

A) Cells for storing data

B) Formulas for calculations

C) Conditional formatting

D) Queries for searching data

Ans: D

Queries for searching data are a feature of database applications, not spreadsheet applications like Microsoft Excel.

Q5: What is the purpose of using conditional formatting in data models?

A) To perform calculations on data

B) To highlight important data based on specific conditions

C) To create a new database table

D) To gather information from users

Ans: B

Conditional formatting is used in data models to highlight important data based on specific conditions, making it easier to identify and analyze.

Fill in the Blanks:

Q1: A ____________ is a visual way to represent an algorithm or plan for a program.

Ans: Flowchart

Q2: In a spreadsheet application, each box where data is stored is called a ____________.

Ans: Cell

Q3: The ____________ function in Excel is used to add up a group of numbers.

Ans: SUM

Q4: In a database, a ____________ is a set of instructions used to find and select specific data.

Ans: Query

Q5: ____________ operators, such as >, <, and =, are used in database queries to compare data.

Ans: Comparison

True/False:

Q1: Spreadsheets are better suited than databases for handling large volumes of complex data.

Ans: False

Databases are designed to handle large volumes of complex data more effectively than spreadsheets.

Q2: In a database, each piece of data must be assigned a specific data type, such as text or number.

Ans: True

Assigning the correct data type is crucial in databases to ensure proper data handling and processing.

Q3: Conditional formatting in spreadsheets can be used to highlight cells based on specific conditions.

Ans: True

Both spreadsheets and databases offer conditional formatting to highlight data based on set conditions.

Q4: Queries in databases are used to perform calculations on data.

Ans: False

Queries in databases are primarily used to search for and filter data based on specific criteria, not to perform calculations.

Q5: A primary key in a database table can contain duplicate values.

Ans: False

The primary key field in a database table must contain unique values to identify each record distinctly.

Match the Following:

Ans: 1 - b, 2 - a, 3 - c, 4 - d, 5 - e