logo

Cambridge IGCSE Information and Communication Technology practice

Paper 1 structured question: Manipulate data

Try the question first, then check the answer and practise the same topic again.

Attempt questionManipulate data revisionRevise the key idea

At a glance

1

Paper

3

Marks

Topic

Manipulate data

Exam-style question

Try this first

Paper 1Theory3 marks

A database contains customer records with fields for Name, Age, and City.

Description

Customer Records

The database stores customer information including their name, age, and city of residence.

NameAgeCity
Alice30London
Bob25Manchester
Carol35London
Dave40Bristol
  1. a

    Explain How would you search for customers who live in London and are older than 30?

    Aim for approximately 3 distinct marking points.

    [3]

0 of 1 part answered

Answer every part before opening the mark scheme.

Common mistake

No common mistake is linked to this question yet.

Related flashcards

Flashcard 1 of 6

Press Space to flip, arrows to move

Related practice questions

Question 1 of 5

Choose an answer, get feedback, then move sideways through the set.

0 of 4 attempted

Paper 1 structured question: Manipulate data

Paper 1Theory2 marks

Description

Sales Data Table

The table records sales transactions including the product name, quantity sold, and price per unit.

ProductQuantity SoldPrice per Unit
Pen1000.50
Notebook501.20
Eraser750.30
Marker401.00
  1. a

    Describe How would you create a calculated field to find the total sales for each product?

    Aim for approximately 2 distinct marking points.

    [2]