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.

At a glance

1

Paper

3

Marks

Topic

Manipulate data

Exam-style question

Try this first

Paper 1Theory3 marks

A company database stores employee information including department and salary.

Description

Employee Database

The database includes fields for employee names, departments, and salaries. You need to find employees in the 'Sales' department earning more than $50,000.

  1. a

    State the criteria to search for employees in the 'Sales' department.

    Aim for approximately 1 distinct marking point.

    [1]
  2. b

    Describe how you would use operators to find employees earning more than $50,000.

    Aim for approximately 2 distinct marking points.

    [2]

0 of 2 parts 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 1Theory4 marks

Description

Student Grades Database

The database includes fields for student names, subjects, and grades. You need to find students who scored above 80 in Mathematics and below 70 in English.

  1. a

    Identify the criteria you would use to search for students who scored above 80 in Mathematics.

    Aim for approximately 2 distinct marking points.

    [2]
  2. b

    Explain how you would use operators to find students who scored below 70 in English.

    Aim for approximately 2 distinct marking points.

    [2]