← All subjects

Maths & technology · CAMBRIDGE 0417

Information & Communication Technology

Build practical skills with spreadsheets, databases and digital safety.

Revision notes

Try each question before revealing the answer. Check your exam-year syllabus for the full topic list.

TOPIC 01

Spreadsheet references

A relative cell reference moves when copied. A dollar sign locks the row or column that follows it.

Quick practice

Copy =B2*$E$1 from C2 down to C3. What does the formula become?

Reveal answer

=B3*$E$1. The relative row changes and the fixed reference stays E1.

TOPIC 02

Databases

A primary key uniquely identifies a record. Use field types that match how the data will be stored and queried.

Quick practice

Why is a student ID a better primary key than a surname?

Reveal answer

Student IDs can be unique, while several students may share a surname.

TOPIC 03

Digital security

Phishing uses deceptive messages to make people reveal information or take an unsafe action.

Quick practice

An unexpected email asks you to reset your school password through a link. How can you check it safely?

Reveal answer

Go to the school’s known website or ask school IT through a trusted contact method.