Theory Pastpapers

Cambridge IGCSE™
*0123456789*
INFORMATION AND COMMUNICATION TECHNOLOGY 0417/01

Paper 1 Theory For examination from 2023
SPECIMEN PAPER 1 hour 30 minutes
You must answer on the question paper.
No additional materials are needed.
INSTRUCTIONS
● Answer all questions.
● Use a black or dark blue pen.
● Write your name, centre number and candidate number in the boxes at the top of the page.
● Write your answer to each question in the space provided.
● Do not use an erasable pen or correction fluid.
● Do not write on any bar codes.
● You may use an HB pencil for any diagrams, graphs or rough working.
INFORMATION
● The total mark for this paper is 80.
● The number of marks for each question or part question is shown in brackets [ ].
● No marks will be awarded for using brand names of software packages or hardware.
This document has 12 pages.
© UCLES 2020 [Turn over

2
1 Circle two items which are internal hardware components.
Actuator Keyboard Linker Monitor
Mouse Printer Processor Sound card

[2]
2 One component of the internal memory of a computer is Random Access Memory (RAM).
State two characteristics of RAM.
1 ........................................................................................................................................................
...........................................................................................................................................................
2 ........................................................................................................................................................
...........................................................................................................................................................
[2]
3 Tick () which device produces solid objects.
A Inkjet printer
B Dot matrix printer
C Laser printer
D 3D printer
[1]
4 For each of the following uses of data capture, name one appropriate direct data entry device. The
devices must be different in each case.
(a) Contactless credit cards
............................................................................................................................................... [1]
(b) Multiple choice answers in an examination paper
............................................................................................................................................... [1]
(c) To scan items at a computerised till
............................................................................................................................................... [1]
© UCLES 2020 0417/01/SP/23

3
5 A glasshouse is used to grow plants and is computer controlled.
(a) Name three sensors which could be used in this glasshouse.
1 .................................................................................................................................................
2 .................................................................................................................................................
3 .................................................................................................................................................
[3]
(b) Give two reasons why data from the sensors need to be converted for use by a computer.
1 .................................................................................................................................................
....................................................................................................................................................
2 .................................................................................................................................................
....................................................................................................................................................
[2]
6 A smartphone has many uses, for example making and receiving telephone calls.
Give four other uses of a smartphone.
1 ........................................................................................................................................................
...........................................................................................................................................................
2 ........................................................................................................................................................
...........................................................................................................................................................
3 ........................................................................................................................................................
...........................................................................................................................................................
4 ........................................................................................................................................................
...........................................................................................................................................................
[4]
© UCLES 2020 0417/01/SP/23 [Turn over

4
7 A developer is writing a program to record the results of examinations taken by students in a

school.
(a) The program will be tested to make sure that it works.
There are three types of test data that can be used to test a system: normal, abnormal and
extreme.
Explain what is meant by normal, abnormal and extreme test data.
Normal .......................................................................................................................................
....................................................................................................................................................
Abnormal ...................................................................................................................................
....................................................................................................................................................
Extreme .....................................................................................................................................
....................................................................................................................................................
[3]
(b) The program collects a large amount of data and this could be stored using either a fixed
solid-state drive (SSD) or cloud storage.
The developer is planning to use cloud storage.
(i) Describe four advantages to the school of using cloud storage rather than using the
SSD.
1 .........................................................................................................................................
............................................................................................................................................
2 .........................................................................................................................................
............................................................................................................................................
3 .........................................................................................................................................
............................................................................................................................................
4 .........................................................................................................................................
............................................................................................................................................
[4]
© UCLES 2020 0417/01/SP/23

5
(ii) Describe three disadvantages to the school of using cloud storage rather than using the
SSD.
1 .........................................................................................................................................
............................................................................................................................................
2 .........................................................................................................................................
............................................................................................................................................
3 .........................................................................................................................................
............................................................................................................................................
[3]
(c) The developer spends a great deal of time using a computer.
For each of the statements given, identify a health problem and describe a possible solution.
Your answers must be different in each case.
Health problem Possible solution

Using a mouse for a long
period of time
Sitting for too long in one

position
[4]
8 A company has an extranet.
Explain what is meant by an extranet.
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...................................................................................................................................................... [3]

6
9 A taxi company tracks the routes their cars have travelled and the current location of each one
using a Global Positioning System (GPS).
A map showing the route taken and current location of each car is displayed on the office monitor.
Describe in detail how this system could work.
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...................................................................................................................................................... [4]
© UCLES 2020 0417/01/SP/23

7
10 A headteacher is planning to hold a video-conference with headteachers from other schools.
The headteachers already have basic internet connected desktop computer systems including a
monitor, keyboard and mouse.
(a) Identify three pieces of additional hardware they need in order to participate in a video-
conference.
1 .................................................................................................................................................
2 .................................................................................................................................................
3 .................................................................................................................................................
[3]
(b) A technician is setting up the hardware for the video-conference.
State three tasks the technician would need to do to set up the hardware for the video-
conference.
You can assume that the hardware required has already been purchased.
1 .................................................................................................................................................
....................................................................................................................................................
2 .................................................................................................................................................
....................................................................................................................................................
3 .................................................................................................................................................
....................................................................................................................................................
[3]

8
11 Microprocessor-controlled devices in the home have had positive effects on people’s lifestyles.
One of the positive effects of using these devices is that we can now set a cooker to switch on
whilst we are out so that we arrive home to a cooked meal.
Describe the positive effects of using other microprocessor-controlled devices in the home.
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...................................................................................................................................................... [4]
12 Tawara Retail is an online store. This online store does not have physical shops. Customers buy
products from this store using internet shopping.
Describe the advantages to Tawara Retail of offering internet shopping.
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...................................................................................................................................................... [4]
© UCLES 2020 0417/01/SP/23

9
13 A media student is creating a movie, in school, for a project. He needs to take the movie home to
edit it.
The student intends to use a CFast solid-state memory card to transport the movie files.
The student is unable to save the work on the memory card.
Give two error messages that may appear when attempting to save the work.
1 ........................................................................................................................................................
...........................................................................................................................................................
2 ........................................................................................................................................................
...........................................................................................................................................................
[2]
14 Compare the similarities and differences between Bluetooth and wi-fi.
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...................................................................................................................................................... [4]

10
15 Discuss the advantages and disadvantages to customers of using internet banking rather than
visiting a bank.
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...........................................................................................................................................................
...................................................................................................................................................... [6]
16 Some confidential personal data can be classed as sensitive data.
Name three items of personal data that could also be sensitive data.
1 ........................................................................................................................................................
2 ........................................................................................................................................................
3 ........................................................................................................................................................
[3]
© UCLES 2020 0417/01/SP/23

11
17 A student uses social media to keep in contact with other people.
Describe four strategies that the student could use to stay safe when using social media to
communicate with others.
1 ........................................................................................................................................................
...........................................................................................................................................................
2 ........................................................................................................................................................
...........................................................................................................................................................
3 ........................................................................................................................................................
...........................................................................................................................................................
4 ........................................................................................................................................................
...........................................................................................................................................................
[4]

12
18 A manager in a hospital has decided to ask a software company to develop a computer system.
The system should allow patients to book all their medical appointments online.
(a) Discuss the advantages and disadvantages to both the patients and the medical staff of this
type of system.
....................................................................................................................................................
....................................................................................................................................................
....................................................................................................................................................
....................................................................................................................................................
....................................................................................................................................................
....................................................................................................................................................
....................................................................................................................................................
....................................................................................................................................................
....................................................................................................................................................
....................................................................................................................................................
....................................................................................................................................................
............................................................................................................................................... [6]
(b) The manager of the hospital has purchased an expert system to help diagnose their patients’
illnesses.
Name three components of an expert system.
1 .................................................................................................................................................
2 .................................................................................................................................................
3 .................................................................................................................................................
[3]
Permission to reproduce items where third-party owned material protected by copyright is included has been sought and cleared where possible. Every
reasonable effort has been made by the publisher (UCLES) to trace copyright holders, but if any items requiring clearance have unwittingly been included, the
publisher will be pleased to make amends at the earliest possible opportunity.
Cambridge Assessment International Education is part of the Cambridge Assessment Group. Cambridge Assessment is the brand name of the University of
Cambridge Local Examinations Syndicate (UCLES), which itself is a department of the University of Cambridge.
© UCLES 2020 0417/01/SP/23

Cambridge IGCSE™

Paper 1 Theory For examination from 2023
MARK SCHEME
Maximum Mark: 80
Specimen
This document has 10 pages. Any blank pages are indicated.

0417/01 Cambridge IGCSE – Mark Scheme For examination
SPECIMEN from 2023
Generic Marking Principles
These general marking principles must be applied by all examiners when marking candidate answers.
They should be applied alongside the specific content of the mark scheme or generic level descriptors
for a question. Each question paper and mark scheme will also comply with these marking principles.
GENERIC MARKING PRINCIPLE 1:
Marks must be awarded in line with:
• the specific content of the mark scheme or the generic level descriptors for the question
• the specific skills defined in the mark scheme or in the generic level descriptors for the
question
• the standard of response required by a candidate as exemplified by the standardisation
scripts.
Marks awarded are always whole marks (not half marks, or other fractions).
Marks must be awarded positively:
• marks are awarded for correct/valid answers, as defined in the mark scheme. However, credit
is given for valid answers which go beyond the scope of the syllabus and mark scheme,
referring to your Team Leader as appropriate
• marks are awarded when candidates clearly demonstrate what they know and can do
• marks are not deducted for errors
• marks are not deducted for omissions
• answers should only be judged on the quality of spelling, punctuation and grammar when
these features are specifically assessed by the question as indicated by the mark scheme. The
meaning, however, should be unambiguous.
Rules must be applied consistently e.g. in situations where candidates have not followed
instructions or in the application of generic level descriptors.
Marks should be awarded using the full range of marks defined in the mark scheme for the
question (however; the use of the full mark range may be limited according to the quality of the
candidate responses seen).
Marks awarded are based solely on the requirements as defined in the mark scheme. Marks should
not be awarded with grade thresholds or grade descriptors in mind.
© UCLES 2020 Page 2 of 10

SPECIMEN from 2023
Mark scheme abbreviations
/ separates alternative words / phrases within a marking point

// separates alternative answers within a marking point
underline actual word given must be used by candidate (grammatical variants accepted)
max indicates the maximum number of marks that can be awarded
() the word / phrase in brackets is not required, but sets the context
Note: No marks are awarded for using brand names of software packages or hardware.

SPECIMEN from 2023
Question Answer Marks

1 Processor 2
Sound card

2 Two from: 2
RAM can be read from and written to
RAM is volatile memory
RAM is temporary storage

3 D 1

4(a) Radio Frequency Identification/RFID reader 1
4(b) Optical Mark Reader/OMR 1
4(c) Bar Code reader/scanner 1

5(a) Three from: 3
Temperature sensor
Humidity/moisture sensor
Light sensor
pH sensor
5(b) Two from: 2
So that the data from the sensor can be understood by the computer
The output from a sensor is analogue
The input to the computer is digital

6 Four from, for example: 4
Global Positioning System//satellite navigation
Calendar
Video calling
Social networking
Online banking
Emails
Playing and streaming videos/music
Text messaging
Searching the internet
Taking photos
Gaming
Control of home devices
Language translation

SPECIMEN from 2023

7(a) Normal 3
Data is within the range of acceptability
Abnormal
One from:
Data outside the range of acceptability
Data that is of an incorrect type
Extreme
Data that is on the boundary/limit of acceptability
7(b)(i) Four from: 4
The cloud has greater storage capacity
The data could be sent directly to/from the cloud from any computer/device
Storage capacity can be increased without adding additional physical devices
Many people can share the data
The school would only pay for the storage used
There is an automatic backup of data
7(b)(ii) Three from: 3
More security issues as multiple copies of the data are stored
The school loses control over the storage of the data
Cloud storage has an ongoing cost
Users must have a reliable internet connection to store data
Users must have an internet connection to access data
7(c) 4
Health Possible solution
problem
Using a mouse for a Repetitive Use a wrist rest
long period of time strain injury Take regular breaks
Use a trackerball//an ergonomic
mouse
Hand exercises
Voice activated software
Sitting for too long in Back problems Use a foot rest
one position Take regular breaks
Walk around//stand up
Use an ergonomic/adjustable chair
Sit with correct posture//with
straight back

8 Three from: 3
Extranet is a network controlled by a company
Restricted/private network
Allows access for partners/vendors/suppliers
Allows access for authorised customers

SPECIMEN from 2023

9 Four from: 4
The position/location of the car is calculated using GPS software
Data is transmitted/sent to the office computer
Data is transmitted every few seconds
An algorithm calculates the speed/location of the cars
The data is stored/saved in the computer
The map is updated every few seconds

10(a) Microphone 3
Video camera/webcam
Speakers/headphones
10(b) Three from: 3
Ensure the video camera/webcam, microphone, speakers/headphones are
switched on
Ensure the hardware devices are connected
Carry out tests on the microphone, video camera/webcam and speakers/
headphones
Adjust the video camera/webcam so the headteacher can be seen
Check the volume levels
Check internet connectivity

Microprocessor-controlled devices reduce the need for people to do manual
tasks at home
People can use microprocessor-controlled devices for physical fitness
tracking in the home
People have more time to spend on leisure activities/shopping/socialising
Increased sense of security as homes are protected with burglar alarms/
smoke alarms/fire alarms
Smart fridges can be used to improve healthy lifestyle//Smart fridges
automatically order fresh food//Smart fridges reduce food waste
Microprocessor-controlled devices can be set remotely using a smartphone
Saves fuel as the heating/air conditioning is not on all day
Reduces injuries by using microprocessor-controlled lights outside

Tawara Retail can target prices, products and services at specific groups
based on buying data
Tawara Retail can update stock availability/prices more quickly than a
physical store through their website
Cheaper to publicise special offers rather than mail shots
International customer base//global market
Increased profits/lower prices due to lower overheads/fewer staff

SPECIMEN from 2023

13 Two from: 2
Medium is full
Corrupt card
Write error
Card error
Card not initialised
Virus found on the card
Device not recognised

14 Max three from: 4
Similiarities
Both use wireless communications
Both use radio frequencies for communication
Both allow several devices to be connected
Both use security when sending data
Max three from:
Differences
wi-fi has a faster data transfer rate
wi-fi has a greater range of transmission
wi-fi uses key matching encryption
Bluetooth uses WEP and WPA security together
wi-fi can be broadcast
wi-fi connects more devices
Bluetooth has a lower frequency than wi-fi

SPECIMEN from 2023

15 Max five from: 6
Advantages
Reduces the number of journeys to and from the bank
Saves money as fewer journeys are made travelling to the bank
Reduces the time wasted travelling to the bank/waiting in queues
The interest rates may be better using internet banking
Easier to shop around for the better bank accounts
24/7 banking
No physical robberies of customers
Max five from:
Disadvantages
Security is an issue as transactions are carried out over the internet/
unsecured networks
The user needs a reliable internet connection
More risk of pharming/phishing/fraud
Easier to make errors whilst using internet banking e.g. incorrect input
If the internet connection drops during a transaction, then there may be issues
Device needed for two-factor authentication
Physical money/cash cannot be deposited or withdrawn using online banking

16 Three from: 3
Ethnic/racial origin
Religion/philosophical beliefs
Political views/opinions
Membership of a political party
Membership of a trade union
Sexual orientation
Criminal record
Health/medical record
Genetic data/DNA
Biometric data

17 Four from: 4
Don’t give out other people’s personal information such as address or phone
number
Don’t send inappropriate images to anyone
Don’t open/click on suspicious links/adverts on social media
Don’t become online ‘friends’ with people you do not know//don’t contact/chat
to people you do not know
Never arrange to meet someone in person who you only met online
If anything you see or read online worries you, you should tell someone about
it/block them
Use appropriate language
Set security so only friends can contact you

SPECIMEN from 2023

18(a) Max five from: 6
Advantages
Bookings can be made last minute
24/7 booking
The bookings can be easily checked on the internet
Faster to cancel/change a booking
The patient cancels/changes their own appointment which ensures it has
been done
Multiple bookings can be made for different medical units
Email/text reminders can be sent automatically
More convenient – can book from any device/on the move
Automatic confirmation of the booking
Less time spent on the phone therefore freeing up staff
The bookings can be planned easily in advance
Reminders can be sent via email/text therefore reducing cost of posting them
Repeat appointments can be made automatically therefore saving time
Frees up staff to do other things
Max five from:
Disadvantages
Concerns about the privacy/security of the data
If the system goes down the ability to book an appointment is lost
Some people prefer to talk to a medical person
Medical emergencies may be overlooked
Internet connected device required by patient
Computer skills required
Administration staff may lose their jobs
18(b) Three from: 3
Inference engine
Knowledge base
Rules base
User interface
Explanation system

SPECIMEN from 2023
BLANK PAGE

™
Cambridge IGCSE

*8329717149*
Paper 1 Theory October/November 2022

2 hours
INSTRUCTIONS
• Answer all questions.
• Use a black or dark blue pen.
• Write your name, centre number and candidate number in the boxes at the top of the page.
• Write your answer to each question in the space provided.
• Do not use an erasable pen or correction fluid.
• Do not write on any bar codes.
• You may use an HB pencil for any diagrams, graphs or rough working.
INFORMATION
• The total mark for this paper is 100.
• The number of marks for each question or part question is shown in brackets [ ].
• No marks will be awarded for using brand names of software packages or hardware.
11_0417_11_2022_1.16
2
1 Complete the following sentences using the most appropriate words from the list.
centre double line space footer gutter hanging

header indented justified left wrapping
(a) A margin between the main content of the page and the fold of a book is called a
........................................................................................................................................... [1]
(b) An area at the top of a page is called a
........................................................................................................................................... [1]
(c) Feature of word processing that causes text to flow around an image is called
........................................................................................................................................... [1]
(d) When text is aligned along both the left and right margins this is called
........................................................................................................................................... [1]
2 Smartphones and smartwatches can be used in everyday life. A smartwatch is a wearable computer
in the form of a wrist-watch.
(a) Apart from accessing the internet, give three other uses of a smartphone.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
© UCLES 2022 11_0417_11_2022_1.16

3
(b) Give two advantages of using a smartwatch rather than a smartphone.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
(c) Give two disadvantages of using a smartwatch rather than a smartphone.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
3 According to research carried out on passwords the top three most used passwords are 12345,
qwerty and sunshine.
Describe, using other examples, the difference between a weak password and a strong password.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [4]
© UCLES 2022 11_0417_11_2022_1.16 [Turn over

4
4 A teacher is setting up a database which she will use to record her student’s exam marks.
(a) The teacher is planning to test the mark range using different types of test data. The range of
marks that the teacher can award is 0 to 100.
(i) Write down one example of extreme test data that the teacher can use to check the
range.
................................................................................................................................ [1]
(ii) Extreme test data is one type of test data. The teacher uses two other pieces of test
data.
Write down the type of test data for each of the examples.
TEN .......................................................................................................................
55 ..........................................................................................................................
[2]
(b) Part of the database is shown.
Student_name Date_of_birth Gender Exam_mark Average_mark
Seth 25/02/2007 M 22 43.4
Adom 17/07/2007 M 67 73.1
Maria 02/05/2007 F 78 67.9
Lesedi 15/12/2006 F 45 50.0
Write down the field name which is the most appropriate for the data type, based on the data
shown in the table. Your answers must be different in each case.
Boolean ............................................................................................................................
Numeric: integer ...............................................................................................................
Numeric: decimal ..............................................................................................................
Alphanumeric ....................................................................................................................
[4]
© UCLES 2022 11_0417_11_2022_1.16

5
5 A student is carrying out a scientific experiment to measure the temperature of a liquid as it cools
down. The student uses a sensor connected to a computer to read the temperature.
(a) Give three advantages of using computers and sensors rather than the student taking the
temperature readings herself.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
(b) Describe how the readings taken by the sensor are displayed on a graph using the computer.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 11_0417_11_2022_1.16 [Turn over

6
(c) Explain the differences between measurement systems and control systems.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 11_0417_11_2022_1.16

7
6 There have been major issues regarding the accuracy of facial recognition systems for identifying
suspects by the police.
Tawara Airport has installed biometric security including facial recognition systems to help the
police recognise known criminals entering and leaving the country. Previously video was taken of
all passengers and then checked manually.
(a) Discuss the effectiveness of using facial recognition systems rather than the manual video
system to increase security in this way.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [8]
(b) Give three examples of biometric data.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
[3]
© UCLES 2022 11_0417_11_2022_1.16 [Turn over

8
7 Instant messaging involves users sending text messages to each other.
Evaluate how you would use eSafety strategies in your own use of instant messaging.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
8 Discuss the moral implications which need to be considered when creating an ICT solution.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [4]
© UCLES 2022 11_0417_11_2022_1.16

9
9 Use of smartphones to access the internet has increased by over 200% in the past five years.
Compare the use of smartphones to access the internet with the use of desktop computers to
access the internet. Your answer must include similarities and differences.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
© UCLES 2022 11_0417_11_2022_1.16 [Turn over

10
10 A group of students in a school are planning to publicise a school concert. They can either produce
a web page which will be sent to the company that runs the school website or create a multimedia
presentation and show this to students and visitors.
(a) Give two types of content which could be used in a multimedia presentation that cannot be
used in a printed leaflet.
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
(b) Describe the advantages and disadvantages of using a multimedia presentation rather than
a web page on the school website.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 11_0417_11_2022_1.16

11
The students need to test their multimedia presentation before it can be used.
(c) Name two output devices they can use and for each one, write down a reason for its use.
Output device 1 ................................................................................................................
Reason .............................................................................................................................
...........................................................................................................................................
Output device 2 ................................................................................................................
Reason .............................................................................................................................
...........................................................................................................................................
[4]
11 A receptionist in a medical centre is going to send out emails to patients about medical results. The
receptionist will use the data from patients’ medical and personal records and mail merge these.
One of the disadvantages of this system is that the receptionist will have access to personal data.
(a) Describe four other disadvantages of using mail merge.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
4 ........................................................................................................................................
...........................................................................................................................................
[4]
© UCLES 2022 11_0417_11_2022_1.16 [Turn over

12
Due to data protection laws, personal data should be kept confidential and secure.
(b) Explain why personal data should be kept confidential and secure.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
12 Many students prefer to store data on external storage devices like pen drives or portable hard disk
drives.
Describe four advantages of using a pen drive rather than a portable hard disk drive.
1 ...............................................................................................................................................
..................................................................................................................................................
2 ...............................................................................................................................................
..................................................................................................................................................
3 ...............................................................................................................................................
..................................................................................................................................................
4 ...............................................................................................................................................
..................................................................................................................................................
[4]
© UCLES 2022 11_0417_11_2022_1.16

13
13 Hyperlinks, bookmarks and anchors are software tools used in web pages and web browsers.
(a) Describe the function of a hyperlink.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Describe the term bookmark.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(c) Describe the function of an anchor.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
© UCLES 2022 11_0417_11_2022_1.16 [Turn over

14
14 A research student is undertaking a study of endangered animals in the Amazon rainforest. She
is using a drone to replace surveys carried out on foot. A drone is a remote-controlled flying vehicle.
Describe the benefits and drawbacks of using a drone to monitor the animals in the rainforest.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
© UCLES 2022 11_0417_11_2022_1.16

15
BLANK PAGE
© UCLES 2022 11_0417_11_2022_1.16

16
BLANK PAGE
Permission to reproduce items where third-party owned material protected by copyright is included has been sought and cleared where possible. Every reasonable
effort has been made by the publisher (UCLES) to trace copyright holders, but if any items requiring clearance have unwittingly been included, the publisher will
be pleased to make amends at the earliest possible opportunity.
To avoid the issue of disclosure of answer-related information to candidates, all copyright acknowledgements are reproduced online in the Cambridge Assessment
International Education Copyright Acknowledgements Booklet. This is produced for each series of examinations and is freely available to download at
www.cambridgeinternational.org after the live examination series.
Cambridge Assessment International Education is part of Cambridge Assessment. Cambridge Assessment is the brand name of the University of Cambridge Local
Examinations Syndicate (UCLES), which is a department of the University of Cambridge.
© UCLES 2022 11_0417_11_2022_1.16

Cambridge IGCSE™
INFORMATION & COMMUNICATION TECHNOLOGY 0417/11

MARK SCHEME
Maximum Mark: 100
Published
This mark scheme is published as an aid to teachers and candidates, to indicate the requirements of the
examination. It shows the basis on which Examiners were instructed to award marks. It does not indicate the
details of the discussions that took place at an Examiners’ meeting before marking began, which would have
considered the acceptability of alternative answers.
Mark schemes should be read in conjunction with the question paper and the Principal Examiner Report for
Teachers.
Cambridge International will not enter into discussions about these mark schemes.
Cambridge International is publishing the mark schemes for the October/November 2022 series for most
Cambridge IGCSE™, Cambridge International A and AS Level components and some Cambridge O Level
components.
This document consists of 10 printed pages.

0417/11 Cambridge IGCSE – Mark Scheme October/November
PUBLISHED 2022
• the specific skills defined in the mark scheme or in the generic level descriptors for the question
• the standard of response required by a candidate as exemplified by the standardisation scripts.
• answers should only be judged on the quality of spelling, punctuation and grammar when these
features are specifically assessed by the question as indicated by the mark scheme. The
Rules must be applied consistently, e.g. in situations where candidates have not followed
Marks should be awarded using the full range of marks defined in the mark scheme for the question
(however; the use of the full mark range may be limited according to the quality of the candidate
responses seen).

PUBLISHED 2022
1(a) Gutter 1
1(b) Header 1
1(c) Wrapping 1
1(d) Justified 1
2(a) Three from, for example: 3

SMS
Making/receiving a phone call
Checking the time
Use appointments/calendar
Taking pictures
Record sound
Bluetooth to share files
2(b) Two from: 2

More accessible/portable as it is on the wrist
Less chance of being lost/stolen/forgotten
Less chance of it being dropped as it is fastened to the wrist
Can access simple apps easier for example heart rate/timer
2(c) Two from: 2

Smaller screen size therefore difficult to see
More difficult to enter the data
More difficult to access detailed apps for example, email
3 Max three from: 4

Weak password is easy to guess
Weak passwords consist of all letters or all digits or all digits with one letter/all
letters with one digit//words found in a dictionary//Strong passwords use a
mixture of upper case, lower case, symbols and digits
Weak password is one that has less than 8 characters
Weak password has repeated characters
Weak password has characters next to each other on a QWERTY keyboard
Weak passwords are ones that are similar to the username
Weak passwords can use personal information
All of the examples given in the question are weak passwords
Max two from:

A good example of a strong password
A good example of a different weak password

PUBLISHED 2022
4(a)(i) One from: 1

0
100
4(a)(ii) Abnormal 2
Normal
4(b) Boolean Gender 4

Numeric: integer Exam_mark
Numeric: decimal Average_mark
Alphanumeric Student_name
5(a) Three from: 3

Measurements can be taken continually
Safer to take the measurements
Measurements can be taken outside school hours
The computer will not forget to take readings
Readings are taken at a more consistent time interval
The computer reads the data more accurately
5(b) Six from: 6

The data from the sensor is read/received by the computer
The data is converted to digital by the ADC
The software is opened on the computer
The graph type is loaded/selected
The data is uploaded to the graph
The graph is plotted/created
Axes/legend/title added
5(c) Four from: 4

Measurement
Automatically detects changes in the environment
Measurement takes the readings and stores the result
Measures/reads physical quantities
Control
Changes the environment
Compares against preset value
Action taken depending on comparison to preset value
To gain full marks the description must have correct answers for both
measurement and control

PUBLISHED 2022
6(a) Eight from: 8

For
Face can be identified faster
Face can be identified by electronic comparison therefore relative higher level
of accuracy
Facial recognition can uniquely identify individuals
Can automatically compare faces from older images
System can work continuously but a human checker would need to take
breaks
Against
Dark glasses/facial hair/face coverings may cause the facial recognition
systems to not work
More difficult to change biometric data
Recognising a person can be slower as more checking is carried out
Harder to set up the facial recognition system
Takes longer to add new people to the system
Biometrics can use a lot of memory to store the data
Intrusive as personal details have to be stored
More likely to be affected by the environment
With the video system each frame needs to be checked with known images
which can lead to errors
To gain full marks the discussion must have correct answers for both
for and against
6(b) Three from: 3

Finger print
Hand print
Vein geometry
Retina
Iris
Speech/Voice

PUBLISHED 2022
7 Six from: 6
I block unwanted messages/suspicious users…
…and report the sender
Before using the messaging system, I check how to block and report
unwanted users…
…this stops predators
I never arrange to meet strangers alone
I always tell a responsible adult if I plan to meet someone
I always meet in a public place
I avoid giving away personal information
I report abusive messages from a sender of the messages
I report cyber-bullying
When sending messages I always use appropriate language
If someone messages me with private and personal information about
themselves I respect their confidentiality/privacy
I always read carefully the messages before I send
I avoid sarcasm
I am not offensive when replying
I carefully check that I am replying to the correct person
I do not enable my location when messaging
8 Four from: 4
What may be immoral in some cultures may be acceptable in others
Just because something is immoral doesn't mean that it is illegal
The ICT solution can cause distress to others/be offensive
Becomes immoral if the person gains from their actions
Max two marks for examples:

Not creating a website full of false facts/news
Not including obscene/offensive/inappropriate/extreme/blasphemy
/discriminatory content
Not creating a video solution that earns you money by stating false facts/lies
Not creating an ICT solution that coerces people to give money
Invasion of privacy

PUBLISHED 2022
9 Six from: 6
Similarities
Both can use Wi-Fi to access the internet
Both can access the internet use hotspots
Both can use Bluetooth Tethering to allow access to the internet
Differences
Desktops
More websites will work with the desktop
Larger keyboards to type in a web address
Larger screens to see the whole webpage
More stable and reliable connections
Tends to be a clearer layout to make it easier to access the internet
More accessible information
A desktop can connect to the internet via an ethernet cable
Smartphones
Access the internet from more locations
Easier to look things up on the go
Screen/keyboard built into the device therefore easier to access websites
A smartphone can use mobile data/4G/3G to access the internet
A smartphone is more portable therefore you can access the internet while
travelling
To gain full marks the comparison must have correct answers for both
similarities and differences
10(a) Two from: 2

Moving images/video
Sound/Audio
Animation

PUBLISHED 2022
10(b) Six from: 6

Advantages
Easier to display to parents
Can take less time to display the information
Quicker to change/update content of the multimedia presentation
More control over the layout of the presentation as not using a third party
browser
More control over the sound in the presentation as using own equipment
People viewing the Multimedia Presentation will be school based
Can be viewed without internet access
Disadvantages
The multimedia presentation is only available in the school during school time
whereas a web page can be used in other places
The visitor may not see the whole presentation
The multimedia presentation may not include sound due to being shown in
the school
Multimedia presentations can require expensive hardware to produce and
view
Multimedia seen by less people
Multimedia more expensive software needed to produce the presentation
More specialist training needed to produce it
advantages and disadvantages
10(c) Monitor/data projector – 1 mark 4

One from:
To show what the presentation looks like
To show the layout of the presentation
Speaker – 1 mark
To listen if the sound matches the images – 1 mark
Printer – 1 mark
To check that handout format works – 1 mark
11(a) Four from: 4

The email appears generic
If the email is not checked and the data not kept up to date before the mail
merge the errors are more difficult to change
If a mistake is made on the master/template then all emails are affected
Emails can be sent with wrong data/records which could be embarrassing
Emails could be sent to the wrong patient
Moving the data file/source/renaming the file can cause the mail merge to fail
The emails may be directed to junk mail folders

PUBLISHED 2022
11(b) Six from: 6

The data will have the name/medical information attached therefore it needs
protecting
The data is confidential as it links directly to the person
The data will be sensitive
To prevent blackmail/bullying from using medical results
To prevent fraud from using financial information
To prevent identity theft using contact details
To avoid the doctor’s surgery getting fined if it got made public
The doctor’s surgery’s reputation would suffer
Patients would lose trust
12 Four from: 4
Is more robust as no moving parts
Can be more easily carried
Use less power
Have faster data access
Have faster data transfer times
13(a) Two from: 2

Method of accessing/linking other resources/web pages from the current web
page
Clicking on the word/phrase/image/area of page
Navigation/re-directed to another web page
13(b) Two from: 2

Method of saving a web page’s address
Used for easy retrieval of the website
Storing a link to a website
13(c) Two from: 2

An anchor is a specific location/reference point within a web page
When clicked it can move the pointer to the start/end of a page
Used on very long pages to save you having to physically scroll all the way
down/up the page.
The browser will automatically jump to the corresponding heading within the
page/destination anchor

PUBLISHED 2022
14 Six from: 6
Benefits
Safer to use drones than human life being risked in forest areas
Drones can gain a better overall view of the forest than the human
Drones can be used in areas that would not be accessible to humans
Drones can cover a greater area than a human in the time available
Data from the drone can be automatically uploaded to computer system
May change animal behaviour if humans are used//Less invasive for the
animals
Drawbacks
Damp conditions/environment/weather may cause issues with the electronics
Difficult to navigate in the tree areas
Noise/sight of the drone may affect the animals
More chance of collision/bird attack
If drone crashes it could be difficult to find/retrieve
Potential danger to other animals/birds
benefits and drawbacks

™
Cambridge IGCSE

*5122596074*

2 hours
INSTRUCTIONS
INFORMATION
11_0417_12_2022_1.13
2
1 Complete the following sentences using the most appropriate words from this list of word processing
terms.
bullet centred gutter hanging header

justified landscape orphan portrait widow
(a) The orientation of a page that is wider than it is high is called
........................................................................................................................................... [1]
(b) A symbol placed in front of each item in a list is called a
........................................................................................................................................... [1]
(c) The indentation of a paragraph where all the lines except the first are indented is called
........................................................................................................................................... [1]
(d) The last line of a paragraph that appears as the first line of the next page is called a
........................................................................................................................................... [1]
2 Database, presentation, spreadsheet and word processing software are used by a medical centre.
Tick (✓) the most appropriate piece of software to carry out the tasks shown.
database presentation spreadsheet word processing

(✓) (✓) (✓) (✓)
Producing a letter to send out to
patients
Creating graphs to show

numbers of people attending the
medical centre
Creating queries from patients’

details
Creating an interactive display

of services offered
[4]
© UCLES 2022 11_0417_12_2022_1.13

3
3 Smartphones use a Graphical User Interface (GUI).
(a) Give three benefits of using a GUI.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
(b) Give three characteristics of a smartphone.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
© UCLES 2022 11_0417_12_2022_1.13 [Turn over

4
4 Workers in an office log onto the office computer network using a password.
(a) Aaron is using his name as his password.
Give two reasons why this is not a good idea.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
(b) One method that hackers use to find people’s passwords is to install key-logging spyware onto
computers.
Give two methods that could be used to safely enter passwords even if key-logging spyware
has been installed on a computer.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
© UCLES 2022 11_0417_12_2022_1.13

5
5 The secretary of a sports club is setting up a database of members to replace the current manual
system. He will need to create a database structure.
(a) Describe the steps involved in setting up and testing the database structure before it can be
used in the new system.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
When the new system is completed it needs to be implemented. The secretary of the sports club
can implement it using direct changeover or parallel running.
(b) Describe the term parallel running, giving one benefit and one drawback of using this method
of implementation.
Parallel running .................................................................................................................
...........................................................................................................................................
Benefit ..............................................................................................................................
...........................................................................................................................................
Drawback ..........................................................................................................................
...........................................................................................................................................
[3]
© UCLES 2022 11_0417_12_2022_1.13 [Turn over

6
6 In June 2000 the London Millennium Bridge opened to the public but closed shortly afterwards for
repairs. The bridge was swaying as people walked across it. Before bridges are built, computer
models are produced and the models are tested.
Explain why computer models are used before building a bridge.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [4]
7 A club has many members. The secretary of the club wants to keep details of the club members
in a database.
(a) Describe the benefits and drawbacks of storing membership details on a computer database.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 11_0417_12_2022_1.13

7
(b) The secretary collects data from the members on paper-based forms.
Describe five features of a well-designed paper-based data capture form.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
4 ........................................................................................................................................
...........................................................................................................................................
5 ........................................................................................................................................
...........................................................................................................................................
[5]
© UCLES 2022 11_0417_12_2022_1.13 [Turn over

8
8 In 2019 Cambridge recorded the highest temperature for July in the UK. The data was collected
automatically using sensors by a weather station and sent to a computer.
Discuss the advantages and disadvantages of using sensors to collect data rather than humans
collecting the data.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [8]
© UCLES 2022 11_0417_12_2022_1.13

9
9 Many organisations store data in the cloud.
(a) Explain what is meant by the ICT term cloud.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
(b) Explain the issues of storing data in the cloud.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 11_0417_12_2022_1.13 [Turn over

10
As our use of the cloud increases, new ways of accessing it safely need to be developed.
(c) The use of typed passwords is being replaced by biometric methods.
Discuss the benefits and drawbacks of using biometric methods.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [8]
© UCLES 2022 11_0417_12_2022_1.13

11
10 High street banks now offer customers access to internet banking when they are in the physical
bank.
Discuss the advantages and disadvantages to the bank of using internet banking in this way.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
11 A village is built next to a river. During heavy rain the river floods and endangers the people living
in the village. If the river is in danger of flooding, an email is sent to all members of the village.
(a) Explain why an email group is used when contacting the villagers.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
© UCLES 2022 11_0417_12_2022_1.13 [Turn over

12
Sensors are placed in the river to check the water level. If the water level in the river rises more
than 5m above normal river levels, a flood barrier is raised to safeguard the village. The flood barrier
remains raised until the water level drops to normal levels.
(b) Explain why the data from the sensors cannot be read directly by the computer and name the
device that needs to be used so that the computer can read the data.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
(c) Describe how a microprocessor uses the data from the sensors to raise and lower the flood
barrier.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 11_0417_12_2022_1.13

13
12 A computer system uses a Graphical User Interface (GUI).
Write down two features of a GUI and for each give a reason why they are needed.
Feature 1 ..................................................................................................................................
Reason 1 ..................................................................................................................................
..................................................................................................................................................
Feature 2 ..................................................................................................................................
Reason 2 ..................................................................................................................................
..................................................................................................................................................
[4]
13 Computers are being used in offices.
Describe how the use of computers has affected the work of employees and their working patterns.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
© UCLES 2022 11_0417_12_2022_1.13 [Turn over

14
14 rtf and pdf are file types.
(a) Describe what is meant by an rtf and a pdf file type.
rtf ......................................................................................................................................
...........................................................................................................................................
pdf .....................................................................................................................................
...........................................................................................................................................
[2]
(b) Explain the differences between the two file types.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
15 Proofreading is often confused with visual verification.
Describe the differences between proofreading and visual verification.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [2]
© UCLES 2022 11_0417_12_2022_1.13

15
BLANK PAGE
© UCLES 2022 11_0417_12_2022_1.13

16
BLANK PAGE
© UCLES 2022 11_0417_12_2022_1.13

Cambridge IGCSE™

MARK SCHEME
Maximum Mark: 100
Published
Teachers.
components.

PUBLISHED 2022
responses seen).

PUBLISHED 2022
1(a) Landscape 1
1(b) Bullet 1
1(c) Hanging 1
1(d) Widow 1
2 4
database presentation spreadsheet word
(✓) (✓) (✓) processing
(✓)
Producing a
letter to send
✓
out to
patients
Creating
graphs to
show
numbers of
✓
people
attending the
medical
centre
Creating
queries from
✓
patient’s
details
Creating an
interactive
display of ✓
services
offered
3(a) Three from: 3

Quick to enter commands
Easy to enter commands
Do not have to learn commands
Less errors as commands not typed
Works with a touch screen
Intuitive
Easy to select options/tasks

PUBLISHED 2022
3(b) Three from: 3

Connectivity – can connect using Wi-Fi/3G/4G/5G/Bluetooth/NFC
Touch screen technology
Camera Technology
Responds to physical world using sensors
GPS/Sat nav
Audio technology
Messaging technology
4(a) Two from: 2

Password is too short
Easy to guess
Contains personal information
Doesn’t contain a mixture of uppercase, lowercase letters, numbers, and
symbols
Contains repeated letters
4(b) Two from: 2

Use drop-down lists
Use biometric passwords
Use one use tokens/OTP
Use a device instead of a password
5(a) Max three from: 4

Load the database software
Set up tables
Set up field names
Set up primary/foreign key fields
Set up relationships
Set up the field types/properties/formatting/data types
Set up the validation routines
Set up input forms
Set up queries/reports
Type in/import records
Create a test strategy/plan
Max three from:

Test using normal, abnormal, and extreme data
If errors are found, make corrections
Re-test the database structure
Test with live data

PUBLISHED 2022
5(b) The old and new systems/both run side by side until the new system takes 3
over
Benefit
One from:
The old system can be used as a back up
Staff can be trained gradually
Drawback
One from:
More time consuming as the data needs to be entered into two systems
More chance of error on data entry as two systems are being used
More costly as there are two sets of staff
Uses more power running two systems
6 Four from: 4
Fewer errors in final version of real item as errors would have been resolved
in model
Saves money as it saves on resources
Safer to run a computer model rather than risking human life
Different scenarios/what ifs can be carried out which may happen in real life/to
experiment
To build the bridge and test it would be impracticable due to cost/time
7(a) Six from: 6

Benefits
Membership details can be searched very quickly as there are many
members
Membership details can be quickly edited/updated
The data in the database can be backed up easily
Easier to create an archive of past members
More secure with a valid reason
Can be used as a source for mail merging
Less errors as data does not have to be re-written
Reduces the time as data does not have to be re-written
Drawbacks
Need IT skills to use the software/computer
Need to have to additional equipment which is expensive
Can take up a lot of storage space/memory in the computer
Expensive to buy software
Expensive to secure the system as it contains personal data
Training staff on how to use the software will be time consuming
Training could be expensive for the club

PUBLISHED 2022
7(b) Five from: 5

Adequate space for response//Individual character boxes
Fonts/font size should be easy to read
Instructions how to complete form
Logical order of questions
Questions spaced out
Appropriate white space
Questions should be clear and understandable
8 Eight from: 8
Advantages
Readings are taken at a more consistent time interval
The sensor reads the data more accurately
Safer as humans do not need to take the measurements
Computers can analyse the data continuously
Readings taken more frequently
Multiple variables can be monitored at the same time
Disadvantages
Sensors can malfunction due to the temperature
If sensors malfunction this could lead to incorrect readings
Sensors could be stolen
9(a) Three from: 3

Cloud consists of large groups of remote networked servers
They allow centralised data storage
Offsite data storage/servers owned by a third party
Accessed from any internet compatible device
Access from anywhere with an internet connection
9(b) Six from: 6

Loss of control of the data as the data is controlled by a data storage provider
Data can be affected without the user knowing
The data remains on the server for a long time therefore more chance of it
being hacked
Many copies of the data made therefore easier to compromise
Users must use strong passwords/authentication methods as hackers have
longer time to be able to crack the password
If internet connection is lost, then the cloud cannot be accessed
If internet connection is lost when data is saved, then data could be lost
A subscription needs to be paid whereas an HDD is one fee
Difficult to delete all copies of a file as it is in multiple locations

PUBLISHED 2022
9(c) Eight from: 8

Benefits
Faster way of accessing systems
Cannot forget the biometric data
Must be physically at the device to access it
More secure as it uses unique data
Difficult to copy/forge
Drawbacks
Invasion of privacy
User may not know they have logged off
Biometrics may change therefore data will need to be kept up to date
Expensive method/technology to set up
Environment can affect measurements
Over usage can affect the measurements
Difficult to reset once compromised
Difficult to set up
Time consuming to set up as measurements must be taken
Facial coverings/changes can prevent system from working
10 Six from: 6
Advantages
Branches can stay open longer and offer other services
More bank staff are available to help customers
Less chance of hacking/fraud as system used in the banks
Fewer bank tellers so more profitable for the bank
As the service is quicker/more services more likely to remain
Disadvantages
Initial cost of hardware/software is expensive
Need to retrain staff which can be expensive
System maintenance costs will be expensive as more inexperienced people
are using the system
Staff numbers may increase as staff are needed to help internet banking
customers

PUBLISHED 2022
11(a) Three from: 3

The sender only needs to type in the name of the group
Saves time rather than typing out all the email addresses
Less likely that an email address is omitted
The sender does not have to remember individual email addresses
Less likely to send the same email twice to one villager
Less likely to send emails to the wrong people
11(b) Data from sensor is in analogue form 3

Computer only reads digital data
Analogue to Digital Convertor
11(c) Six from: 6

Microprocessor reads the data from the ADC
Microprocessor stores pre-set value
Microprocessor compares current water level with preset value
If the current water level is greater than the pre-set value …
… the microprocessor sends a signal ...
… to the DAC to convert data to analogue
… signal sent to an actuator
Actuator raises the flood barrier
Continual process
12 One mark for correct feature and one mark for correct associated reason 4
Feature: Windows
Reasons: See more than one task at a time
Each task can be in a separate window
To display the task
Feature: Icons
Reasons: Tasks can be recognised
Click on an icon and it opens (a task/app)
Easy/faster to open an app by clicking on it
Feature: Menus
Reasons: To choose all the available options
Feature: Pointers
Reasons: To select tasks/icons

PUBLISHED 2022
13 Max five from: 6

The use of computers has reduced the number of office staff
Computers can help office staff to be more productive
More employees are working from home due to the increase in technology
Computers can cause less productivity due to distractions
Workers could be working longer hours
De-skilling of staff
Increase in training for staff as they need to learn new skills
Increase in the number of blue-collar workers/supervisors
Increase in the number of maintenance staff/technicians
Higher security issues due to networking
Less people work in offices
Max two marks:

Increase in part time/job sharing/compressed hours/flexible working/working
from home
Computers have allowed staff to work part-time/compressed hours/job
sharing/flexible working/working from home
14(a) rtf 2
Text file with formatting/generic text files
pdf
Standard/generic image file
14(b) Three from: 3

pdf their layout and formatting stay the same, regardless of which
device/operating system/application being used whereas rtf formatting can
change
pdf take up less memory for the same size of document
pdf files are compressed
pdf the formatting can be more complex whereas rtf has basic formatting
pdf are harder to edit
pdf generic image format
rtf can be read by most word processing editors

rtf is a generic text format
15 Two from: 2
Visual verification refers to the original document whereas proofreading does
not need to refer to the original document
Proofreading is checking spelling and grammar errors whereas visual
verification does not check for errors
Visual verification checks that the data has been copied correctly

™
Cambridge IGCSE

*0243543375*

2 hours
INSTRUCTIONS
INFORMATION
11_0417_13_2022_1.11
2
1 Complete the following sentences using the most appropriate words from the list.
centred a footer a gutter a header indented

justified landscape an orphan portrait a widow
(a) The orientation of a page that is taller than it is wide is called
........................................................................................................................................... [1]
(b) An area at the bottom of a page is called
........................................................................................................................................... [1]
(c) The first line of a paragraph that appears as the last line of the previous page is called
........................................................................................................................................... [1]
(d) Text that is aligned horizontally in the middle of a line is called
........................................................................................................................................... [1]
2 A computer controlled glasshouse is used to grow plants.
State three sensors that could be used in the glasshouse.
1 ...............................................................................................................................................
2 ...............................................................................................................................................
3 ...............................................................................................................................................
[3]
3 Circle two features of multimedia presentations which would not be found in a word processed
document.
bullets images numbers photographs
sound tables text video
[2]
© UCLES 2022 11_0417_13_2022_1.11

3
4 A person contacts an online medical website that uses an expert system to allow users to
self-diagnose illnesses.
(a) Write down the component within the expert system that matches the definition given.
(i) This component contains a database of facts.
................................................................................................................................
................................................................................................................................ [1]
(ii) This component carries out the reasoning of the expert system.
................................................................................................................................
................................................................................................................................ [1]
(iii) This component allows the person to interact with the system.
................................................................................................................................
................................................................................................................................ [1]
(b) Describe how an expert system is used to diagnose an illness.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 11_0417_13_2022_1.11 [Turn over

4
5 A restaurant uses a number of different types of software. These include control, measurement,
spreadsheet and word processing software.
(a) Tick (✓) the most appropriate piece of software to carry out the tasks shown.
Word
Control Measurement Spreadsheet processing
(✓) (✓) (✓) (✓)
Producing menus for the restaurant
Calculating the cost of each of the

meals
Automatically turning on the fans

when the room gets too hot
Monitoring the temperature in the

restaurant
[4]
© UCLES 2022 11_0417_13_2022_1.11

5
The restaurant owner is planning to upgrade the software used to book reservations. He has
employed a systems analyst who is analysing the current system. The systems analyst can either
send out questionnaires for staff to answer or observe staff working with the current system.
(b) Discuss the advantages and disadvantages of using questionnaires that staff answer rather
than observing staff to gather information about the current system.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 11_0417_13_2022_1.11 [Turn over

6
6 A web page can contain images saved as png or gif file types.
(a) State what is meant by png and gif file types.
png ....................................................................................................................................
...........................................................................................................................................
gif ......................................................................................................................................
...........................................................................................................................................
[2]
(b) Explain the differences between the two file types.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
© UCLES 2022 11_0417_13_2022_1.11

7
7 A school librarian is setting up a database of all the revision books he has in stock. The school
library sells revision books to students. The books range in value from $1 to $10 and are available
either in electronic book type (E) or physical book type (P).
(a) The librarian is planning to set up a number of different types of validation rule for the fields
to check data entry. Write down the most appropriate field name from the table that could be
used with each of the validation rules. Your answers must be different in each case.
Name_of_book Department ISBN Book_type Cost
Modern History HIS 0140621393432 P $5.20
GCSE ICT ICT 0006132237 E $1
A Level Calculus MAT 0006153516 E $1
Human Biology SCI 0006511376 E $2.30
Presence ..........................................................................................................................
Lookup ..............................................................................................................................
Range ...............................................................................................................................
Length ...............................................................................................................................
[4]
The librarian needs to set up a primary key field.
(b) Write down the most appropriate field name from the table that could be used as a primary
key field.
........................................................................................................................................... [1]
© UCLES 2022 11_0417_13_2022_1.11 [Turn over

8
Most of the revision books are available in electronic book type as digital versions of the printed
books. These are stored as interactive PDF files.
(c) Describe the benefits and drawbacks of using the digital versions.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 11_0417_13_2022_1.11

9
8 An organisation has changed the way in which members of staff can enter the building. Previously
they typed in a four-digit code on a key pad; now they use a device that reads a handprint.
(a) Discuss the effectiveness of using a handprint to enter the building rather than keying in a
code.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [8]
Handprint scans are an example of a biometric method to enter a building.
(b) Give two other examples of biometric methods that could be used in this scenario.
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
© UCLES 2022 11_0417_13_2022_1.11 [Turn over

10
9 The use of email has replaced many forms of communication.
Describe the constraints that you need to consider when writing and sending an email.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
10 (a) For each of the following types of backing storage give one example of its associated media.
Your answers must be different in each case.
Optical ..............................................................................................................................
...........................................................................................................................................
Magnetic ...........................................................................................................................
...........................................................................................................................................
Solid state .........................................................................................................................
...........................................................................................................................................
[3]
© UCLES 2022 11_0417_13_2022_1.11

11
(b) Describe three differences between optical and magnetic backing storage.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
11 A student is carrying out some research for school.
(a) Explain two ways she could search for information on the World Wide Web (WWW).
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
(b) Explain the differences between the internet and the World Wide Web (WWW).
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 11_0417_13_2022_1.11 [Turn over

12
12 The internet contains three web development layers. One layer is the content layer. This layer is
used to enter the content of a web page structure.
(a) Name and describe the other two web development layers.
Layer .................................................................................................................................
Description ........................................................................................................................
...........................................................................................................................................
Layer .................................................................................................................................
Description ........................................................................................................................
...........................................................................................................................................
[4]
(b) Explain why tables can be used to structure elements within a web page.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
© UCLES 2022 11_0417_13_2022_1.11

13
13 A teacher is concerned that students are playing online computer games at home without considering
eSafety. The teacher is going to create a set of rules that he feels they should be following.
Write down a list of eSafety rules that he could include.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
14 Explain why page, section and column breaks are used in documents.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [3]
© UCLES 2022 11_0417_13_2022_1.11 [Turn over

14
15 An employee is carrying out work for her company at home. The work she is doing is confidential.
She has been advised by her company to use encryption. She wishes to transfer some of this work
to the office.
(a) Discuss two different methods she could use to transfer this work to the office. Include in your
answer the advantages and disadvantages of each method.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
(b) Describe what is meant by the term encryption and why it is used.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
© UCLES 2022 11_0417_13_2022_1.11

15
(c) Tick (✓) the most appropriate working pattern to match the following statements.
Compressed Flexible Job Part-time

hours hours sharing working
(✓) (✓) (✓) (✓)
An employee works a full day but

negotiates with the employer the start
and end times
An employee works the same number

of hours as a full week but in fewer
days
An employee works for fewer hours

than a full-time employee
[3]
© UCLES 2022 11_0417_13_2022_1.11

16
BLANK PAGE
© UCLES 2022 11_0417_13_2022_1.11

Cambridge IGCSE™

MARK SCHEME
Maximum Mark: 100
Published
Teachers.
components.

PUBLISHED 2022
responses seen).

PUBLISHED 2022
1(a) portrait 1
1(b) a footer 1
1(c) an orphan 1
1(d) centred 1
2 Three from: 3
Light
Temperature
Humidity/moisture
pH
CO2
3 Sound 2
Video
4(a)(i) Knowledge base 1
4(a)(ii) Inference engine 1
4(a)(iii) Interactive user interface 1
4(b) Six from: 6

An Interactive user interface appears
The expert system asks questions about the illness
Yes and No type answers to the questions
Answers lead to other questions
The inference engine searches…
…the knowledge base…
…uses the rules base
Probabilities/possibilities of diagnoses and treatments are displayed
Displays the ways it achieved the solutions/conclusions

PUBLISHED 2022
5(a) 4
Control Measure Spread Wordproc
(✓) ment sheet essing
(✓) (✓) (✓)
Producing menus for the

✓
restaurant
Calculating the cost of

✓
each of the meals
Automatically turning on
the fans when the room ✓
gets too hot
Monitoring the
temperature in the ✓
restaurant
5(b) Six from: 6

Advantages
Answers are more honest as they are anonymous
Staff can remain anonymous whereas the observation cannot be
anonymous
Can be sent to all the staff at the same time whereas the observer may only
see one part of the operation
Questionnaires can be filled in at any time whereas observations can only
be carried out when the restaurant is working
Analysis of questionnaire can be carried out automatically whereas
observations the observer must produce notes
Observer may miss elements whereas questionnaires are filled in by the
users
Disadvantages
Users do not always complete the questionnaire and hand it back but
observation watches users working
Work rate can be influenced by being observed but this does not apply to
questionnaires
More chances of incorrect data if question not understood
The observer can see exactly how the system works well and not so well
whereas a questionnaire takes the users viewpoint

PUBLISHED 2022
6(a) png 2
One from:
Raster/full colour digital photos
Images with a transparent background
gif
Moving/animated image
6(b) Three from: 3

Same images saved as a GIF loads/reads faster than PNG
GIF uses limited colours (256) whereas PNG uses a bitmap of colours
GIF can have moving and static images whereas PNG only have static
images
PNG can have transparent background
PNG is compressed
PNG is lossless
7(a) Presence ISBN 4

Lookup Book_type
Range Cost
Length Department
7(b) ISBN 1
7(c) Six from: 6

Benefits
Digital therefore can easily be used in other documents/software
Instant access on many devices
More accessible for disabled
Quicker to search digital books
Drawbacks
Health issues with using a computer to read the book
Cannot be written in braille
May require extra software/reader
Never own the book as it is only data
Need to purchase a device to read them
Needs the internet to download the book

PUBLISHED 2022
8(a) Eight from: 8

Positives
Data can be read/identified faster
Data can be read/identified by electronic comparison therefore relative higher
level of accuracy
Increases security as the hand is unique whereas a four-digit code easier to
guess
Can’t forget your handprint, unlike a code
The person must be present to enter the building
Negatives
If the hand is damaged, then may not work
More difficult to change biometric data
Only works with one hand therefore difficult for right-handed people
Recognition could be slower as system is more complex
Harder to set up the biometric system
Takes longer to add new people/change biometric data to the system
Biometrics can use a lot of memory to store the data
Intrusive as personal details must be stored in biometrics
More likely to be affected by the environment
positives and negatives
8(b) Two from: 2

Fingerprint
Vein geometry
Retina
Iris
Face
9 Six from: 6
Abide by the laws within the country that affect the general use of emails
Use acceptable language
Abide by copyright
Follow local guidelines set by an employer/schools
Use appropriate security
Follow netiquette
Respect other people/s/own privacy
Be aware of the need for password protection
Be aware that email accounts can be Illegally accessed

PUBLISHED 2022
10(a) Optical 3
CD ROM/DVD ROM, CD R/DVD R, CD RW/DVD RW, DVD RAM, Blu-ray
discs/CD/DVD
Magnetic
Fixed/portable/removable hard disks/magnetic tape.
Solid state
Memory stick/flash card
10(b) Three from: 3

Optical data is stored using laser whereas Magnetic data is stored using
magnetic fields
Optical disc storage is serial whereas Magnetic disk storage is direct/sectors
and tracks
Magnetic storage is affected by magnetic fields whereas Optical storage is
not
Magnetic media tends to store more data than optical media
Optical storage is more robust
Optical has a faster data access/transfer speed
11(a) Two from: 2

Type in a web address
Use a search engine
Type what you need on the search bar
11(b) Four from: 4

The internet
Network of Networks//WAN
It is the infrastructure
Contains email, FTP
The World Wide Web

Collection of websites
Accessed from the internet
Service of the internet
To gain full marks the explanation must have correct answers for both
the internet and World Wide Web

PUBLISHED 2022
12(a) Presentation 4
Defines the format of a web page/individual elements through styling
Behaviour
To enter scripting language to a web page/individual element
12(b) Three from: 3

Allows greater control over page layout
Positions elements/data on the page
Conveys relationships between items
Displays data
13 Six from: 6
Examples
Do not give away personal information
Do not use your real name as your username
Do not use your face image as your avatar
If you receive messages from unwanted users block and report them
Do not meet unknown users in real life//use a chaperone
Do not give financial information to other users
If you receive unwanted and abusive messages report the sender of the
messages
When sending messages always us appropriate language
Think before you reply to a message
14 Three from: 3
To adjust pagination
To avoid orphans/widows
To improve layout on the page
To allow for the change of orientation of pages in the document
To enable to start a new chapter on a new page

PUBLISHED 2022
15(a) Use of the Cloud 6

The cloud does not require a physical device
Storage size is not an issue with the cloud
Cloud is operated by a third party therefore security could be an issue

Require a stable internet to access to upload and download the data
Portable device: pen drive/Hard drive

The device uses USB port therefore it is easy to plug in
Does not require access to the internet to access the data
May be lost/damaged in transit

Magnetic drives can be affected by strong magnets/x rays
Limited number of read/writes
Email as an attachment
Do not require physical device
Require access to the email account both at home and in the office
The memory size could be an issue
Requires the use of the internet
15(b) Max two from: 3

Scrambling data
Changing plain text into cipher
Encryption converts text into a meaningless form
Max two from:

To prevent data/information from being understandable to people who
access/intercept the data
Protects data
15(c) 3
Part-
Compressed Flexible Job
time
hours hours sharing
working
(✓) (✓) (✓)
(✓)
An employee works a
full day but negotiates
✓
with the employer the
start and end times
An employee works the

same time as a full ✓
week but in fewer days
An employee works for

fewer hours than a full- ✓
time employee

™
Cambridge IGCSE

*4935696006*
Paper 1 Theory May/June 2023

1 hour 30 minutes
INSTRUCTIONS
INFORMATION
06_0417_11_2023_1.9
2
1 A book has an ISBN which is 330247204X
Tick (✓) the most appropriate data type for the ISBN.
A Numeric: integer
B Text
C Boolean
D Date
[1]
2 Identify the hardware from the descriptions given.
(a) A volatile internal memory that stores the current instruction.
........................................................................................................................................... [1]
(b) A printed circuit board containing the CPU and other components of a computer.
........................................................................................................................................... [1]
(c) A printed circuit board that controls the output to a monitor.
........................................................................................................................................... [1]
(d) A printed circuit board that is installed in a computer so that the computer can be connected
to a network.
........................................................................................................................................... [1]
3 A headteacher is setting up a newsletter to send to parents of pupils at a school. She has some
photographs saved on storage devices that she needs to place in the newsletter.
State two communication methods which the headteacher could use to upload the photographs
onto the school network.
1 ...............................................................................................................................................
2 ................................................................................................................................................
[2]
© UCLES 2023 06_0417_11_2023_1.9

3
4 (a) Describe the purpose of a web browser.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) A company may use an intranet or an extranet.
Describe the differences between an intranet and an extranet.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
5 State the safety issue that is most likely to occur for each of these causes.
(a) Spilling drinks on computer equipment
........................................................................................................................................... [1]
(b) Overloading sockets by plugging in too many devices
........................................................................................................................................... [1]
(c) Trailing cables across the floor
........................................................................................................................................... [1]
(d) Placing a laser printer at the edge of a table
...........................................................................................................................................
........................................................................................................................................... [1]
© UCLES 2023 06_0417_11_2023_1.9 [Turn over

4
6 A student has set up a password for his laptop computer. The password he has chosen is
Px2zY!Cg3?bd
(a) Discuss the benefits and drawbacks of using this password.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
(b) The student could have protected his laptop computer by using two-factor authentication. This
could have combined his password with a biometric method.
State two examples of biometric methods he could use.
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
7 A systems analyst has been asked to carry out an analysis of a company’s current computer system.
(a) State three methods of analysing the current system.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
[3]
© UCLES 2023 06_0417_11_2023_1.9

5
(b) The systems analyst is working with a team to create some new software. The software
documentation will be stored on the cloud.
Describe how the team can use the cloud to share the documentation.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(c) Members of the team can use video-conferencing to join business meetings from different
locations around the world.
Describe, giving reasons, three disadvantages of using video-conferencing for business

meetings rather than meeting in person.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2023 06_0417_11_2023_1.9 [Turn over

6
8 (a) Compare Optical Mark Readers (OMRs) with Optical Character Readers (OCRs). Your answer
must include similarities and differences.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
(b) Identify two uses of Optical Mark Recognition (OMR).
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
9 (a) Absolute and relative file paths are used in the content layer when creating a web page.
(i) Explain the differences between an absolute file path and a relative file path.
................................................................................................................................
................................................................................................................................
................................................................................................................................
................................................................................................................................ [2]
(ii) Explain why absolute file paths should not be used for hyperlinks to locally-saved web
pages.
................................................................................................................................
................................................................................................................................ [1]
© UCLES 2023 06_0417_11_2023_1.9

7
(b) Anchors and hyperlinks are both used in HTML.
Compare an anchor with a hyperlink. Your answer must include similarities and differences.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
10 Some people use dialogue-based user interfaces to operate their car audio system.
(a) Describe what is meant by a dialogue-based user interface.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Describe the benefits and drawbacks of using a dialogue-based user interface in this way.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2023 06_0417_11_2023_1.9 [Turn over

8
11 Portable hard drives can be Solid State Drives (SSDs) or Hard Disk Drives (HDDs).
Explain why the SSD may be better to use than the HDD.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [4]
12 Many media companies now provide media streaming for users to watch their television programmes.
(a) Explain what is meant by the term media streaming.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Describe the benefits and drawbacks of media streaming.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2023 06_0417_11_2023_1.9

9
13 gif and jpg file formats are used to store images.
(a) Give one reason for using each of the file formats. Each of your reasons must be different.
gif ......................................................................................................................................
...........................................................................................................................................
jpg .....................................................................................................................................
...........................................................................................................................................
[2]
(b) Explain the differences between the two file formats.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2023 06_0417_11_2023_1.9 [Turn over

10
(c) The file size of an image can be reduced by changing the file format of the image.
State two other ways of reducing the file size of an image.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
14 Identify the most appropriate method for reducing data entry errors from the descriptions given.
(a) Manually checking the data without reference to the original copy.
........................................................................................................................................... [1]
(b) Checking that the data being entered is reasonable.
........................................................................................................................................... [1]
(c) Preventing errors when data is copied from one medium to another.
........................................................................................................................................... [1]
© UCLES 2023 06_0417_11_2023_1.9

11
BLANK PAGE
© UCLES 2023 06_0417_11_2023_1.9

12
BLANK PAGE
To avoid the issue of disclosure of answer-related information to candidates, all copyright acknowledgements are reproduced online in the Cambridge
Assessment International Education Copyright Acknowledgements Booklet. This is produced for each series of examinations and is freely available to download
at www.cambridgeinternational.org after the live examination series.
Cambridge Assessment International Education is part of Cambridge Assessment. Cambridge Assessment is the brand name of the University of Cambridge
Local Examinations Syndicate (UCLES), which is a department of the University of Cambridge.
© UCLES 2023 06_0417_11_2023_1.9

Cambridge IGCSE™

MARK SCHEME
Maximum Mark: 80
Published
Teachers.
Cambridge International is publishing the mark schemes for the May/June 2023 series for most
Cambridge IGCSE, Cambridge International A and AS Level and Cambridge Pre-U components, and some
Cambridge O Level components.

0417/11 Cambridge IGCSE – Mark Scheme May/June 2023
PUBLISHED
 the specific content of the mark scheme or the generic level descriptors for the question
 the specific skills defined in the mark scheme or in the generic level descriptors for the question
 the standard of response required by a candidate as exemplified by the standardisation scripts.
 marks are awarded for correct/valid answers, as defined in the mark scheme. However, credit
 marks are awarded when candidates clearly demonstrate what they know and can do
 marks are not deducted for errors
 marks are not deducted for omissions
 answers should only be judged on the quality of spelling, punctuation and grammar when these
responses seen).

PUBLISHED
1 Text 1
2(a) Random Access Memory//RAM 1
2(b) Motherboard 1
2(c) Graphics card 1
2(d) Network (interface) Card/NIC 1
3 Two from: 2
Connecting a storage device to the computer by (USB) cable Connecting a
storage device by Bluetooth
Connecting a storage device/cloud by wi-fi
4(a) Two from: 2

Retrieves code from the server//Downloads information resources
Interprets the code as a web page//Uses page resources to build a web
page//Runs the code
The web page is displayed//Renders web page to view
Allows the user to navigate to other information
Runs 'client-side' scripts on the web page
4(b) Two from: 2

Intranet shares data within an organisation whereas Extranet shares content
with customers/suppliers
Intranet allows communication within the organisation whereas Extranet
allows communication with customers/suppliers
Intranet is owned is by a single organisation whereas Extranet can be used by
several organisations
Extranet is part of a company’s intranet
Extranet can lead to more security breaches
5(a) Electrocution 1
5(b) Fire 1
5(c) Tripping 1
5(d) Heavy equipment falling and injuring people 1

PUBLISHED
6(a) Six from: 6
Benefits
It is a strong password
Hard to crack
More secure
Password is long therefore shoulder surfing is reduced
Does not contain personal information so harder to crack
Drawbacks
Easy to forget as it has many different characters
Even though it is still strong it is easy for a computer to crack
The user would have to look at the keyboard when entering the password
The user may have to write it down to remember it
Letters and numbers could be confused…
…such as 1 and I, 2 and Z, 5 and S
As it is long/complex it could be mis-typed
To gain full marks candidates must have correct answers for both
6(b) Two from: 2

Retina scan
Fingerprint/thumbprint
Iris scan
Facial recognition
Voice recognition
7(a) Three from: 3

Observation
Interviews
Questionnaires
Examination of existing documents
7(b) Four from: 4

Documentation is uploaded to the cloud
Access is given to members of the team
Members of the team log into the cloud
Members of the team open the documentation
Members of the team update the documentation
Documentation is synced
Can be tracked by the owner of the document
Several copies of the document are made

PUBLISHED
7(c) Three matched pairs: 6

More difficult to carry out projects ...
... as individuals are working on their own
Difficult to form relationships with staff ...
... as individuals are working on their own
Requires a good/fast/reliable internet connection ...
... as documents/images may require more bandwidth
Requires specialist hardware/software ...
... can be expensive to purchase
Time zone differences …
… as staff work in other parts of the world/time of meeting may be difficult
May require training …
… this may take time/expensive
Communication issues …
... causing lip syncing/lagging
Disconnection issues/speed of the internet …
… members of the meeting miss sections/meeting
Background noise/echo …
… could be distracting
Users could be distracted …
… not pay attention to the meeting
8(a) Six from: 6
Similarities
Both read/scan data using optical methods
Both use direct data entry
Both are input devices
Both read data from printed documents
Both input large amounts of data
Both read data very quickly
Differences
OMR does not need to read the characters written only the marks OMR is
unable to recognise machine or hand-printed characters For OMR to read,
marks need to be within a specified area
The OMR marks have to be in the correct location
OCR is more accurate at reading detailed data

Data read from an OCR can be manipulated by word processing software
OCR requires manual intervention to change the scanned words.
8(b) Two from, for example: 2

Lottery tickets
Bar codes//QR codes
Multiple Choice forms//Questionaries
Attendance registers

PUBLISHED
9(a)(i) Two from: 2

Absolute file paths contain a complete URL/full file path with file name
Contents of the URL include protocol, the website's domain name, specific
file, subfolder, page name – 1 mark awarded for at least two named
Relative file paths only include a specific file or page
This is relative to the current path//starts from the same folder as the web
page.
9(a)(ii) One from: 1

If the web pages have moved then the references refer to an old/previous file
path
Hyperlinks will not work
9(b) Four from: 4
Similarities
Both are links (in a web page)
Both can be attached to icons/text/graphics
Both are html tags used on web pages
Both are used for navigation
Both are coded as html tags starting with <A...>
Differences
An anchor allows the user to move from one part of a web page to another
part.
An anchor is a label that identifies a specific position in a document//An
anchor is within a hyperlink
An anchor needs a point set in the document and a link//A hyperlink only
needs the link and a web address
The code within an anchor will either be "name.." or "id.."
An anchor determines a fixed point on a web page that is used as a bookmark
An anchor can be placed at any point on a web page
A hyperlink allows the user to move from one web page to another web
page/website
The code within a hyperlink can be "href..", "rel..”, “target..”
A hyperlink can be attached to a block of text or image
A hyperlink can be clicked on to cause another web page or part of the same
web page to be displayed
A hyperlink can redirect a user to an anchor by including its name
A hyperlink is clickable
10(a) Two from: 2

Software that interacts through speech recognition
Uses the spoken word/voice …
… to carry out actions/control devices

PUBLISHED
10(b) Four from: 4
Benefits
Allows for hands free control
Safer than using a standard interface
More useful for physically disabled users
Drawbacks
Limited access due to the number of commands stored
More expensive to develop
May not operate reliably due to background noise/speech impediment/accents
Need to be ‘trained’ by the user
Can be distracting if the commands are not understood
To gain full marks there must be correct benefits and drawbacks
11 Four from: 4
The SSD is more portable
The seek time in the SSD is smaller
The data transfer rate in the SSD is better/smaller
There is less chance of the data becoming corrupted as it can save whilst the
drive is being moved
The SSD is smaller/thinner
The SSD uses less energy
SSD is more robust as no moving parts
12(a) Two from: 2

Live or recorded content
Delivered to computers/mobile devices via the internet
Played back in real time/on demand.
Allows the user to view the media without downloading it

PUBLISHED
12(b) Four from: 4
Benefits
Instant access to the media
Saves time rather than downloading/going to the shops
No need for storage space as there is no copy
Drawbacks
Requires an internet connection
Requires a good internet/bandwidth connection otherwise buffering
Don’t get to keep the product
Online security issue related to the subscription
Technology could fail in the middle of the stream
If media is downloaded it is time locked
13(a) gif 2
One from:
Used to store animated/moving images
Used to store icons/simple logos
jpg
One from:
Used to store photographic images
Used to store graphics with complex colours and gradients
13(b) Six from 6
gif
Graphics Interchange Format
Supported by all web browsers
Can be animated images
Supports 8-bit colours/256 colours/limited
Features background transparency
Image quality never degrades with resaves
jpg
Joint Photographic (Experts) Group
Supports 24-bit colours/16.7 million colours//More colours
Image quality degrades slightly when a JPG is resaved.
Uses lossy compression
No background transparency
Enlarging the image can cause pixelation
Image quality is better
To gain full marks candidates must have correct answers for both gif
and jpg

PUBLISHED
13(c) Two from: 2

Change the resolution/quality of the image
Reduce the colour/bit depth
Change the compression method//Compress the file
Reduce layers
14(a) Proofreading 1
14(b) Validation 1
14(c) Verification 1

™
Cambridge IGCSE

*3882223209*

1 hour 30 minutes
INSTRUCTIONS
INFORMATION
06_0417_12_2023_1.13
2
1 A book contains a bar code whose number is 503619309903
Tick (✓) the most appropriate validation check to test the validity of the bar code.
A check digit
B format check
C range check
D spell check
[1]
2 Identify the most appropriate hardware from the descriptions given:
(a) non-volatile internal memory used to store the start-up instructions
........................................................................................................................................... [1]
(b) an internal component that provides the input and output of audio signals
........................................................................................................................................... [1]
(c) an internal component that is composed of the main memory, the control unit and the arithmetic
logic unit.
........................................................................................................................................... [1]
3 A headteacher is producing a web page about the history of her school. She has been given some
old hard-copy photographs which she will include on the web page. She has a digital camera and
a scanner to use to convert the hard-copy photographs into a digital format.
Compare the use of a digital camera with a scanner in this scenario. Your answer must include
similarities and differences.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [4]
© UCLES 2023 06_0417_12_2023_1.13

3
4 A company uses an extranet.
(a) Explain what is meant by an extranet.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Describe the differences between the internet and an extranet.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
5 State which health issue is most likely to occur from each description shown. Your answer must
be different in each case.
(a) typing on a keyboard for long periods of time
........................................................................................................................................... [1]
(b) looking at a computer screen for a long time
........................................................................................................................................... [1]
(c) sitting with poor posture
........................................................................................................................................... [1]
© UCLES 2023 06_0417_12_2023_1.13 [Turn over

4
6 A company requires its employees to regularly change their login passwords for the company’s
computer systems. Passwords must be strong and cannot be reused.
(a) Explain three problems that may occur when the employees change their passwords regularly.
1 ........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
[6]
(b) The company has a website which uses a digital certificate.
Explain the purpose of the digital certificate.
...........................................................................................................................................
........................................................................................................................................... [1]
(c) A digital certificate is attached to an email.
State three items contained in a digital certificate.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
[3]
© UCLES 2023 06_0417_12_2023_1.13

5
7 A student is creating a spreadsheet that includes a formula to check a number entered in a cell is
between two values.
• The number is entered in cell A10 as an integer.

• If the number is between the two values then a message ‘OK’ is displayed, otherwise ‘error’
is displayed.
The formula the student has created is:
=IF(AND(A10>1,A10<32),"OK","error")
Data will be used to test the formula.
(a) Identify two items of extreme test data the student should use and give the reason why this
data was chosen.
Extreme test data 1 ..........................................................................................................
Extreme test data 2 ..........................................................................................................
Reason .............................................................................................................................
...........................................................................................................................................
[3]
(b) The student has entered an item of abnormal test data.
Explain why abnormal test data is used.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
© UCLES 2023 06_0417_12_2023_1.13 [Turn over

6
8 A teacher provides revision lessons during the holidays. The teacher plans to use web-conferencing
for the lessons.
(a) Explain what is meant by web-conferencing.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
(b) Evaluate the use of web-conferencing in this scenario.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2023 06_0417_12_2023_1.13

7
9 (a) The products in a warehouse contain either a bar code or a Radio Frequency Identification
(RFID) tag.
The data about each product is read electronically.
Compare bar code readers and RFID readers. Your answer must include similarities and
differences.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
(b) Identify two other uses of RFID.
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
© UCLES 2023 06_0417_12_2023_1.13 [Turn over

8
10 Metatags can be used in a web page.
(a) A metatag can be used to define the viewport settings.
Identify three other items that can be defined in metatags.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
[3]
(b) Metatags are used in the HTML of web pages.
State the section of the HTML which contains the metatags.
........................................................................................................................................... [1]
11 Some gaming systems use gesture based user interfaces to operate a game.
(a) Describe what is meant by a gesture based user interface.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Describe the drawbacks of using gesture based user interfaces in this way.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2023 06_0417_12_2023_1.13

9
12 Movies can be stored on Blu-ray discs or an internal hard disk.
(a) Describe why Blu-ray discs are preferred to an internal hard disk for storing movies.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(b) Hard disks and Blu-ray discs are examples of backing storage.
(i) State two characteristics of backing storage.
1 ............................................................................................................................
................................................................................................................................
2 ............................................................................................................................
................................................................................................................................
[2]
(ii) Identify two other types of backing storage.
1 ............................................................................................................................
2 ............................................................................................................................
[2]
© UCLES 2023 06_0417_12_2023_1.13 [Turn over

10
13 Weather forecasters use computer modelling.
(a) Explain why computer modelling is used to forecast the weather.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(b) Data is collected by different types of sensor and then input to the computer model to be
processed.
Identify two sensors that could be used to collect weather data.
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
(c) The processed data is then output.
Identify two output devices that could be used.
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
© UCLES 2023 06_0417_12_2023_1.13

11
14 ePublishing software is used to create an ePublication to display a school’s yearly magazine.
(a) Describe the characteristics of an ePublication.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(b) The ePublishing software is subject to software copyright legislation.
Give two methods that could be used to prevent software copyright legislation being broken.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
© UCLES 2023 06_0417_12_2023_1.13

12
BLANK PAGE
© UCLES 2023 06_0417_12_2023_1.13

Cambridge IGCSE™

MARK SCHEME
Maximum Mark: 80
Published
Teachers.

PUBLISHED
responses seen).

PUBLISHED
Mark scheme Abbreviations and Rules

( ) the word / phrase in brackets is not required, but sets the context
Note: No marks are awarded for using brand names of software packages or hardware. These must
be created
Examiners must ensure that annotations are placed to show that the whole answer has been
seen.
Annotations MUST be placed in white space close to where the mark is awarded.
Before submitting a script please check all ticks match marks.
At the end of prose answers place a TV to show that the whole answer has been marked.
Any blank pages place the SEEN annotation.
If an answer is left blank then use SEEN and award NR, but if anything has been written for
example ‘Don’t know’, ‘?’ etc. then use NAQ and award 0. If an answer has been attempted and
crossed out then attempt to mark it.

PUBLISHED
1 Check digit 1
2(a) Read Only Memory/ROM 1
2(b) Sound card 1
2(c) CPU/Processor 1
3 Four from: 4
Similarities
Both capture images
Both store digital data
Both create digital images
Differences
Digital camera is more portable
Scanner captures the image in more detail
Scanners do not have a keystone effect
Digital camera may capture glare/shadow off the image
Digital camera has faster data capture
4(a) Two from: 2

An extranet is part of a company's intranet
The company gives permission for customers and suppliers to access it
Enables businesses to exchange information over the internet in a secure way
Requires credentials/username and password to access it
4(b) Two from: 2

Internet allows public access to information whereas Extranet allows limited
access
Extranet is more secure
The internet is not owned by anyone whereas the Extranet is owned by a
company
More information on the internet

PUBLISHED
5(a) Repetitive strain injury/RSI/carpel syndrome 1
5(b) Eye strain/headache/neckache 1
5(c) Neck ache/back ache 1
6(a) Three matched pairs from: 6
The passwords could become similar …

… security/passwords could be weakened
May be more difficult to find a different password …

… the passwords/security could be weakened
Users could easily forget the current password …

… leading to system lock out
It may be typed incorrectly as the password is like the previous one …

… could lead to login errors
Users may have to write the passwords down so they are not forgotten …
… this may lead to others seeing the passwords
6(b) One from: 1

To ensure a website is trusted/authentic/genuine
Verifies if the company owns the website
To share a public key for encryption when communicating with the website
6(c) Three from: 3

Company/owner's name
Owner's/company public key
Date issued
Expiry date
Company/owner's digital signature
Issuer's/Sender’s name
Serial number
7(a) 2 – 1 mark 3
31 – 1 mark
One from:
To test the boundaries (of the formula)
To test the comparisons are correct

PUBLISHED
7(b) Three from: 3

To test that data outside the range is not acceptable
To test that the correct data type is entered
To test that the error message works
To test that the errors are trapped correctly
8(a) Three from: 3

Form of real-time/live/online communication
Multiple users/devices connect …
… using the internet
All users see the same screen.
Communication using video cameras/microphones
8(b) Six from: 6
Positives
The students save time as they do not need to travel to the school
The students save the cost of travelling to the school.
The school saves costs as it does not need to open in the holidays
Students and teachers can work from anywhere in the world
Can be recorded for students who miss the lesson
Negatives
Hardware/software could be expensive
Requires a good/reliable internet connection
There could be issues with child protection
More difficult to concentrate/motivate
If the hardware breaks/loss of connection/lack of hardware then the student
cannot participate
Only students with the correct specialist devices will be able to access
positives and negatives

PUBLISHED
9(a) Six from: 6
Similarities
Both readers scan the product code
Both readers use direct data entry
Both readers allow tracking of products
Both readers are contactless
Differences
Bar code readers only scan one bar code at a time whereas RFID readers
read multiple tags at the same time
Bar code readers require a direct line-of-sight with the code
RFID readers use near-field technology
Bar code readers need to be close to the bar code
Bar code needs to be in the correct position for reader to be able to read it
Bar codes readers might not be able to read a damaged/scratched bar code
whereas RFID can read data as long as chip/tag is not severely damaged.
Bar code reader might have read errors if the bar code is damaged/scratched
whereas RFID readers are more likely to read damaged/scratched tags
Bar code readers emit/use light whereas RFID uses electromagnetic/radio
waves
9(b) Two from for example: 2

Race timing Tracking
Event Attendee Tracking
Livestock Tracking
Library book Tracking
Contactless/credit/debit card payment
Passports/ID cards
10(a) Three from: 3

Name attributes
Charset//Character set
Content attributes
10(b) The <head> element 1

PUBLISHED
11(a) Two from: 2

Where the human body interacts with the device
Where a human gives a command ...
… without using a keyboard/mouse/pointing device
11(b) Four from: 4

Fatigue/gorilla arm
User can unintentionally activate the device …
… by moving their arms/fingers
Not as accurate as other interfaces
Issues with stopping the gesture …
… if user touches a button, interface knows the command is completed
Have to learn what the gestures do//Having to remember the gestures
Could cause damage if in restricted space
May have a limited number of gestures that can be used
Users with physical disabilities may not be able to make the gestures
Have to use/learn the gestures accurately otherwise they may not be
identified
12(a) Four from: 4

Data cannot be erased/edited
Blu-ray discs are portable
As it is on an external device it does not take up internal storage
You can have large number of Blu-ray discs therefore more storage
Hard Disk is fixed in the computer
12(b)(i) Two from: 2

Non-volatile
Stores data permanently
Slower to access than internal memory
12(b)(ii) Two from: 2

Magnetic tape
CD
DVD
DVD RAM
Memory cards
Pen drives
SSD
Cloud storage
Flash memory

PUBLISHED
13(a) Four from: 4

The large number of variables makes it more difficult for a human to forecast
correctly/accurately
Can predict long range weather trends/global warming
Faster way of producing weather patterns than using a human
Can deal with the more complex calculations quicker
More accurate results produced
Can give residents early warning of severe weather
13(b) Two from: 2

Pressure
Temperature
Moisture/Humidity
Wind speed
13(c) Two from: 2

Monitor
Printer
Plotter
14(a) Four from: 4

Allows multimedia to be embedded in the pages
Allows auto change of pages
It is digital so can be used in other documents
Sections can be linked internally/externally
Readers can interact with the ePublication
Can be used by many users simultaneously
More up-to-date than physical magazines
14(b) Two from: 2

Users type in a unique licence key/serial number/authorisation key
Users install DRM (parts of the code which stop you from copying it)
Use of licence agreements
Running the software with a dongle/CD/Pendrive attached
Getting permission from the owner

™
Cambridge IGCSE

*1803529937*

1 hour 30 minutes
INSTRUCTIONS
INFORMATION
06_0417_13_2023_1.12
2
1 A book has an ISBN which is 0 330 24720 4
Tick (✓) the most appropriate validation check to test the validity of the ISBN.
A character check
B format check
C length check
D range check
[1]
2 Identify the most appropriate hardware from the descriptions given.
(a) An internal hardware component that connects a computer to a Local Area Network.
........................................................................................................................................... [1]
(b) An external device that retains a computer’s data even after the computer is turned off.
........................................................................................................................................... [1]
(c) An input device that is attached to a monitor.
........................................................................................................................................... [1]
© UCLES 2023 06_0417_13_2023_1.12

3
3 A group of students are producing a class newsletter which they will email to parents of
students in the class. They are deciding whether to use a laptop computer or a smartphone
to type the newsletter.
(a) Discuss the advantages and disadvantages of using a laptop computer rather than a
smartphone for this purpose.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2023 06_0417_13_2023_1.12 [Turn over

4
(b) The students have decided to use a smartphone. Data for the newsletter will be input,
stored and output by the smartphone.
(i) Identify two devices that are part of the smartphone that could be used to input
the data for the newsletter.
1 ............................................................................................................................
2 ............................................................................................................................
[2]
(ii) Identify two devices that are part of the smartphone that could be used to output
data from the newsletter.
1 ............................................................................................................................
2 ............................................................................................................................
[2]
(iii) Identify two appropriate devices that could be used to store data for the
newsletter.
1 ............................................................................................................................
2 ............................................................................................................................
[2]
(c) The newsletter is to be saved as a PDF and sent as an email attachment to parents.
Describe two benefits of saving the newsletter as a PDF.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
© UCLES 2023 06_0417_13_2023_1.12

5
(d) Describe the features that the students must include to make the newsletter appeal to
the parents.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2023 06_0417_13_2023_1.12 [Turn over

6
4 A company uses an intranet. They are considering using an extranet.
Compare an intranet with an extranet. Your answer must include similarities and differences.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
5 Identify two appropriate IT-related causes for each of the health issues. Your answers
must be different in each case.
(a) repetitive strain injury (RSI)
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
(b) eye strain
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
© UCLES 2023 06_0417_13_2023_1.12

7
6 Two-factor authentication can use a number of different forms of identification.
(a) One form of identification is to use ‘where the user is’.

An example of this would be the user’s GPS location.
State two other forms of identification. Give an appropriate example of each.
1 ........................................................................................................................................
...........................................................................................................................................
Example ............................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
Example ............................................................................................................................
...........................................................................................................................................
[4]
(b) Explain the purpose of two-factor authentication.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
© UCLES 2023 06_0417_13_2023_1.12 [Turn over

8
7 The retail industry uses point of sale (POS) systems.
(a) Discuss the benefits of using POS in the retail industry.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(b) Describe the steps involved in automatic stock control when an item is sold at a POS
terminal.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2023 06_0417_13_2023_1.12

9
8 A teacher is creating a spreadsheet as an electronic mark book. Part of the electronic mark
book displays how well a student did on a piece of work. When a student completes a piece
of work the teacher will enter the mark into the electronic mark book and a message will be
displayed.
• If the student gains 60 or more marks then ‘Merit’ is displayed

• If the student gains 50 to 59 marks then ‘Pass’ is displayed
• If the student gains a mark below 50 marks then ‘Not Pass’ is displayed.
The formula the teacher has used is:
=IF(A1>=60,"Merit",IF(A1>50,"Pass","Not Pass"))
The formula will need to be tested. The teacher will do this by entering test data into cell A1.
(a) Explain the steps that need to be taken to test the formula. Include in your answer any
test data used and the reasons why these were chosen.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [5]
(b) When the teacher enters a mark of 50 he expects ‘Pass’ to be displayed.
State the changes he needs to make to the formula to ensure ‘Pass’ is displayed.
...........................................................................................................................................
........................................................................................................................................... [1]
© UCLES 2023 06_0417_13_2023_1.12 [Turn over

10
(c) When the electronic mark book is complete it needs to be tested with live data.
Explain what is meant by live data.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
9 The manager of an organisation is planning a meeting of its directors. The manager plans
to use audio-conferencing for the meeting.
(a) Explain what is meant by audio-conferencing.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
(b) The organisation could use video-conferencing for the meeting.
Describe three advantages of using audio-conferencing rather than video-conferencing

in this scenario.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
© UCLES 2023 06_0417_13_2023_1.12

11
(c) Identify the hardware and software required to join the audio-conference.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
10 A school secretary is composing an email. She will send the email to a teacher and will
copy the headteacher into the message. She can either copy the headteacher in as cc or
bcc.
Compose
To:
cc:
bcc:
Subject:
(a) Describe what is meant by cc and bcc.
cc ......................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
bcc ....................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
[4]
© UCLES 2023 06_0417_13_2023_1.12 [Turn over

12
(b) A teacher is considering setting up either a forum or a blog for his class to help his
students with their studies.
Describe the benefits of using a forum rather than a blog.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [5]
11 Many books contain a gutter margin.
Explain what is meant by a gutter margin.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [3]
12 A web page has an attached stylesheet in the head section and also has an inline style
attribute in the body section.
Explain why the inline style attribute is used.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [2]
© UCLES 2023 06_0417_13_2023_1.12

13
BLANK PAGE
© UCLES 2023 06_0417_13_2023_1.12

14
BLANK PAGE
© UCLES 2023 06_0417_13_2023_1.12

15
BLANK PAGE
© UCLES 2023 06_0417_13_2023_1.12

16
BLANK PAGE
© UCLES 2023 06_0417_13_2023_1.12

Cambridge IGCSE™

MARK SCHEME
Maximum Mark: 80
Published
Teachers.

PUBLISHED
responses seen).

PUBLISHED
Mark scheme Abbreviations and Rules

( ) the word / phrase in brackets is not required, but sets the context
Note: No marks are awarded for using brand names of software packages or hardware. These must
be created.
Examiners must ensure that annotations are placed to show that the whole answer has been
seen
Annotations MUST be placed in white space close to where the mark is awarded
Before submitting a script please check all ticks match marks
At the end of prose answers place a TV to show that the whole answer has been marked
Any blank pages place the SEEN annotation
If an answer is left blank then use SEEN and award NR, but if anything has been written for
example ‘Don’t know’, ‘?’ etc. then use NAQ and award 0. If an answer has been attempted
and crossed out then attempt to mark it.

PUBLISHED
1 B Format check 1
2(a) Network Interface Card / NIC 1
2(b) Backing storage 1
2(c) Touch screen 1
3(a) Six from: 6
Advantages
Larger screen to read the typed data
Laptop uses a physical keyboard therefore easier to type
Larger keyboard to type in the data
Fewer data entry errors due to larger screen / keyboard
More suited for entering mass amounts of data
Laptop version of software will have more features than smartphone version
of software
More computer storage for typed text
Easier to add other devices to store the data
Disadvantages
Less portable / heavier than a smartphone as the smartphone can be
slipped into a pocket
Smartphones are smaller therefore easier to carry
More likely to have a smartphone with them
To gain full marks candidates must have correct answers from both
advantages and disadvantages.
3(b)(i) Two from: 2
Camera
Microphone
Touch screen
3(b)(ii) Two from: 2
Speaker
Screen
3(b)(iii) Two from: 2
SD card
Flash memory
Internal storage
SSD

PUBLISHED
3(c) Two from: 2
Retains the format of the original newsletter

Takes up less storage space
Independent of hardware and software
3(d) Four from: 4

Interesting / engaging content
Use of longer sentences / not using slang / emoticons
Use of some technical language
More text than pictures
Balanced use of white space and content
Clear readable fonts
Formal layout
Balance of size between headings and text
Contrasting colours
Use suitable images
More real images than cartoons
4 Six from: 6
Similarities
Both have shared content
Both use internet technologies / TCP-IP
Both have restricted access
Both sit behind a firewall
Differences
Intranet shares data within an organisation whereas extranet shares content
with external users and employees
Extranet is part of a company’s intranet
Intranet allows communication within the organisation whereas extranet
allows communication with customers / suppliers
Extranet can lead to more security breaches
Intranet is owned is by a single organisation whereas extranet can be used
by several organisations
To gain full marks candidates must have correct answers from both

PUBLISHED
5(a) Two from: 2
Prolonged use of a keyboard

Prolonged use of a mouse
Using a keyboard with a bad posture
Working in a cramped workspace
5(b) Two from: 2
Staring at a computer screen for a long time

Glare / flicker on the computer screen
Dirt on the computer screen
Screen brightness does not match the room light brightness
Sitting too close to the screen
Top of monitor not in line with the eyes
6(a) One mark for each form of identification and one mark for each 4
corresponding example given:
Form of identification: something the user owns:

Example: card reader / pen drive / dongle / mobile phone
Form of identification: something the user knows:

Example: password / PIN / TAN / email address / CVV on back of a credit
card / answers to security questions
Form of identification: something the user has:

Example: biometrics
6(b) Two from: 2
To protect user’s data / credentials

To reduce the possibility of unauthorised access
Combines two different forms of identification
Makes it more secure by adding an extra layer of security

PUBLISHED
7(a) Four from: 4
By electronically tracking the sales of goods the industry could know when
to order items…
…so that the goods do not run out in the stores
The POS system allows a business to identify which products are selling
well / selling badly…
…so products do not run out / left of the shelves
Through this identification, a business can increase the order of profitable
products and reduce unmarketable inventory
Increases speed of transaction as the checkout staff do not need to enter
the price of each item
Itemised bills can be generated on screen and printed for customers
It allows self check out which means less staff are needed therefore
reducing staff costs
7(b) Six from: 6
The (bar codes on) goods are scanned at the checkout

The item code is searched in the stock database
When the item is found…
…the number sold of that item is read
The number in stock is reduced by this number
If the number in stock is lower than the reorder / preset value…
…then a message is sent to automatically re-order stock
When the new stock arrives database is updated with the new stock
Quantity available will be increased when new stock arrives
Generates a report on selling trends
8(a) Five from: 5

Enter test data
Run the formula
If actual output does not match expected value…
…make corrections to formula
Re-test the formula
8(b) One from: 1
Change A1 > 50 to A1 > = 50

Change A1 > 50 to A1 > 49
8(c) Two from: 2
Real data relating to tests that have been carried out previously
To ensure that the electronic mark book should work with real data

PUBLISHED
9(a) Three from: 3
Audio-conferencing is where two or more people…

…in different locations
…use technology to hold an audio call
All the participants dial into a central system that connects them
Removes the need to directly call each other
9(b) Three from: 3
Easier to set up
Does not need specialist equipment…
…therefore saves money
No issue with lip syncing
Less bandwidth is needed therefore reduces hanging / freeze
More privacy as they do not use cameras
9(c) Max three from: 4

Microphone
Speaker
Telephone handset
Max two from:

Audio-conferencing software / app
Internet / broadband connection
10(a) Four from: 4
CC
Cc stands for carbon copy
The Headteacher would receive a copy of the message with the teacher
knowing
All recipients would know who is on the cc list and where it was from
BCC
Bcc stands for blind carbon copy
The Headteacher would receive a copy of the message without the teacher
knowing
All recipients on bcc would only know where it was from to and the cc list
To gain full marks candidates must have correct answers from both cc
and bcc.

PUBLISHED
10(b) Five from: 5
In forum posts are in chronological order therefore it makes it easier to find

replies / data
In forums easier for students to start new topics / sub-topics / forums / ask
questions/give answers
Topics / sub-topics cannot be created in a blog by the student
Forums are moderated by an administrator
Forums are checked before they are published
In forums students generate the content rather than leaving messages on a
named topic
Many students develop the direction of the forum rather than one person
In forums everyone can contribute / / In blogs only the content creator writes
the blog whereas the readers / followers can comment on a blog
A forum would allow private messaging as well as to all the group
11 Three from: 3
Used as an extra margin

Adds extra space to the inside / top margin
Helps to ensure the text is not obscured by the binding
12 Two from: 2
Inline style attributes have a higher hierarchy than external stylesheets

If there is a conflict on an element then the inline style attribute will apply
It applies style attributes that do not appear in the external stylesheet
Inline style attributes apply to one single web page

™
Cambridge IGCSE

*6189791534*

2 hours
INSTRUCTIONS
INFORMATION
06_0417_11_2022_1.16
2
1 Circle two network devices.
Actuator Bridge Database DVD
Hub Linker Monitor Printer
[2]
2 Complete each sentence using the most appropriate item from the list. Your answers must be
different in each case.
ADC an applet hardware HDD

a router a sensor software SSD
(a) The physical components of a computer are called
........................................................................................................................................... [1]
(b) Programs and data are examples of
........................................................................................................................................... [1]
(c) A small application performing one or two simple functions is called
........................................................................................................................................... [1]
(d) An input device used in measurement applications is called
........................................................................................................................................... [1]
3 Identify two devices which are used in control systems.
1 ...............................................................................................................................................
2 ...............................................................................................................................................
[2]
© UCLES 2022 06_0417_11_2022_1.16

3
4 Many laptop computers use the cloud to store data. A technician has produced a report on his
laptop computer but has stored the report on a memory stick rather than storing it on the cloud.
Describe two advantages of using a memory stick rather than the cloud to store data.
1 ...............................................................................................................................................
..................................................................................................................................................
2 ...............................................................................................................................................
..................................................................................................................................................
[2]
5 Many bank cards now use contactless technology.
Describe the advantages and disadvantages of using these cards rather than cards that use chip
and PIN.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [4]
© UCLES 2022 06_0417_11_2022_1.16 [Turn over

4
6 Stylesheets are used in web pages.
(a) Explain the term stylesheets when used in web pages.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Explain the differences between attached stylesheets and inline style attributes.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 06_0417_11_2022_1.16

5
7 Two types of database are relational and flat file.
(a) Compare and contrast relational databases and flat file databases. Your answer must include
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [8]
(b) Give, using an example, one reason why flat file databases are used in certain applications
rather than relational databases.
Reason .............................................................................................................................
...........................................................................................................................................
Example ............................................................................................................................
...........................................................................................................................................
[2]
© UCLES 2022 06_0417_11_2022_1.16 [Turn over

6
8 When using computers people can suffer from Repetitive Strain Injury (RSI).
(a) Describe the term RSI. Include in your answer the causes of RSI.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
(b) Identify three methods of reducing the effects of RSI.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
9 Martin, who is a teacher, is creating a multimedia presentation to explain a topic to his students.
(a) He produces a master slide.
Write down four objects he could include in the master slide.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
4 ........................................................................................................................................
[4]
© UCLES 2022 06_0417_11_2022_1.16

7
(b) Martin wants to record a message for his students. His voice will be added to the presentation.
He will also need to listen to his voice to make sure the sound is of good quality.
Name two devices that he will need.
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
(c) Martin will need to use software to create different types of content before including them in
the presentation.
Name two types of software that he might use and for each one, write down what he would
use it for.
Software 1 ........................................................................................................................
...........................................................................................................................................
Use ...................................................................................................................................
...........................................................................................................................................
Software 2 ........................................................................................................................
...........................................................................................................................................
Use ...................................................................................................................................
...........................................................................................................................................
[4]
© UCLES 2022 06_0417_11_2022_1.16 [Turn over

8
10 A river authority is concerned about levels of pollution in a major river. The quality of the water in
the river needs to be monitored using sensors.
(a) Name three sensors that could be used to measure the pollution in the river.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
[3]
(b) Discuss the advantages and disadvantages of using computers to measure the pollution in
the river rather than humans measuring the pollution.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 06_0417_11_2022_1.16

9
11 A system can be analysed using different methods.
Discuss the advantages and disadvantages of analysing a system by interviewing staff rather than
using questionnaires.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
© UCLES 2022 06_0417_11_2022_1.16 [Turn over

10
12 Many company computer network systems use WiFi as a communication system to help prevent
the issue of tripping over trailing cables.
(a) For each of the following physical safety issues describe two ways of helping to prevent them.
(i) Fire
Prevention 1 ..........................................................................................................
................................................................................................................................
Prevention 2 ..........................................................................................................
................................................................................................................................
[2]
(ii) Electrocution
Prevention 1 ..........................................................................................................
................................................................................................................................
Prevention 2 ..........................................................................................................
................................................................................................................................
[2]
A common use of home computers is online gaming.
(b) Describe three eSafety measures which should be taken when playing games on the internet.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
© UCLES 2022 06_0417_11_2022_1.16

11
(c) In order to log onto online gaming a user ID and password is needed.
Explain what is meant by a user ID and password and why they are needed.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 06_0417_11_2022_1.16 [Turn over

12
13 (a) Explain the need for copyright legislation when data is published on the internet.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(b) Describe methods that software producers use to prevent software copyright being broken.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 06_0417_11_2022_1.16

13
(c) Emails are used by people to communicate with each other. Copyright and using acceptable
language in the email are two of the constraints that affect the use of email.
(i) Describe four other constraints that may affect the use of email.
1 ............................................................................................................................
................................................................................................................................
2 ............................................................................................................................
................................................................................................................................
3 ............................................................................................................................
................................................................................................................................
4 ............................................................................................................................
................................................................................................................................
[4]
(ii) Describe two rules of the use of acceptable language in emails.
1 ............................................................................................................................
................................................................................................................................
2 ............................................................................................................................
................................................................................................................................
[2]
© UCLES 2022 06_0417_11_2022_1.16 [Turn over

14
14 The manager of a medical centre keeps the doctor’s stock records in a database. The stock for
any item is not allowed to fall below 15 items and the manager keeps a maximum of 100 items in
stock.
The table shows examples of the stock.
Name_of_item Serial_number Number_in_stock Name_of_supplier Shelf_number
Medihoney 3081043612211 15 Capimed 0126
Sodium fusidate 1437210227870 60 Brooks Medical 0112
Crepe bandage 2541233164353 100 Capimed 0064
Crepe bandage 2834954736849 89 Cams Meds 0064
As data is entered it needs to be verified and validated.
(a) Explain why verification is carried out.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Write down the field name from the table that would be the most appropriate for each of these
validation checks. Each answer must be different.
Check digit ........................................................................................................................
Length ...............................................................................................................................
Type ..................................................................................................................................
[3]
(c) Name the most appropriate field from the table that could be used as a primary key in the
database.
........................................................................................................................................... [1]
© UCLES 2022 06_0417_11_2022_1.16

15
15 A customer is booking a seat on a theatre’s online booking system. The customer reserves seats
using the theatre’s website and a debit card. The website displays the seats that are available and
a database stores the customer details, the payment details and the seat details.
When the customer enters their debit card details for a seat, the theatre’s computer communicates
with the bank’s computer.
(a) Describe four checks that the bank’s computer will make on the customer’s bank account.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
4 ........................................................................................................................................
...........................................................................................................................................
[4]
(b) Describe the processing carried out by the theatre’s computer when making a booking.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 06_0417_11_2022_1.16

16
BLANK PAGE
© UCLES 2022 06_0417_11_2022_1.16

Cambridge IGCSE™

MARK SCHEME
Maximum Mark: 100
Published
Teachers.

PUBLISHED
These general marking principles must be applied by all examiners when marking candidate answers. They should be applied alongside the
specific content of the mark scheme or generic level descriptors for a question. Each question paper and mark scheme will also comply with these
marking principles.
 marks are awarded for correct/valid answers, as defined in the mark scheme. However, credit is given for valid answers which go beyond the
scope of the syllabus and mark scheme, referring to your Team Leader as appropriate
 answers should only be judged on the quality of spelling, punctuation and grammar when these features are specifically assessed by the
question as indicated by the mark scheme. The meaning, however, should be unambiguous.
Rules must be applied consistently, e.g. in situations where candidates have not followed instructions or in the application of generic level
descriptors.

PUBLISHED
Marks should be awarded using the full range of marks defined in the mark scheme for the question (however; the use of the full mark range may
be limited according to the quality of the candidate responses seen).
Marks awarded are based solely on the requirements as defined in the mark scheme. Marks should not be awarded with grade thresholds or
grade descriptors in mind.

PUBLISHED
1 Hub 2
Bridge
2(a) hardware 1
2(b) software 1
2(c) an applet 1
2(d) a sensor 1
3 Two from: 2
Computer
Analogue to digital convertor/ADC
Digital to Analogue convertor/DAC
Actuator
4 Two from: 2
Does not need access to the internet
Fewer issues storing the data as the connection could drop during storage if the cloud is used
More control over the stored data

PUBLISHED
5 Four from: 4
Advantages
Less wear on the card as it is not used in a device
Transaction is quicker
Can be read from a pocket
No shoulder surfing
Disadvantages
Transaction can be read by hacker’s device
Does not use a PIN therefore money can be taken if lost
Limit on spending on the card
If lost the card could be used by anyone so is less secure
To gain full marks the description must have correct answers for both advantages and disadvantages
6(a) Used to describe the presentation of a document written in HTML 2

Enables the separation of presentation and content
Part of the presentation layer
6(b) Four from: 4

Attached stylesheets are separate from the web page whereas Inline style attributes are within each web page
An attached stylesheet is edited in one file whereas Inline style attributes are edited by changing each web page
Attached stylesheet link has to go into the head section of the web page whereas Inline style attributes can be anywhere in
the web page
Inline style attributes can be within HTML tags
Attached stylesheets can be applied to multiple pages whereas Inline style attributes only apply to individual web pages
Inline style attributes can be used to override the attached stylesheet

PUBLISHED
7(a) Eight from: 8

Similarity
Both use a primary key
Both can create searches/reports
Both store data in records and fields in the table
Both use indexes
Differences
Flat file database is a plain text file
Flat file is a simple structure
Flat file uses one table
Relational database has linked tables/relationships
Relational database allows searches/reports to be created over multiple tables
Relational database allows cross referencing between tables
Relational database records are easier to add
Relational databases are more powerful
Relational database reduces duplicate data
Relational database uses foreign keys
To gain full marks there must be correct answers for both similarities and differences
7(b) One from: 2

The data is in a list
There is only a small amount of data
A single table is to be used
One mark:
Example of a list such as name, address/CSV files

PUBLISHED
8(a) One from: 3

Aches and pains in the hands and fingers
Painful swelling of the wrist and fingers
Two from:
Caused by repetitive movements
Caused by holding a mouse and clicking the buttons repetitively
Caused by constant typing on a keyboard
Caused by sitting in a poor posture for a long period of time
8(b) Three from: 3

Use of a wrist rest
Use of a mouse rest
Take regular breaks
Exercise the hand and fingers
Use an ergonomic keyboard/ergonomic mouse
Arrange workspace so that it is not cramped
Using an ergonomic chair
9(a) Four from: 4

Text
Images
Logos
Slide footer/header
Automatic slide number
Link/button to other slide/file/web page
Lines for layout
Animation/video/sound
9(b) Two from: 2

Microphone
Headphones/speakers
Sound card

PUBLISHED
9(c) Matched pairs: 4

Word processing
Type/enter the text for the presentation
Image editing software/graphics package/photo editing
To prepare images for inclusion in the presentation
Sound editing software
To record the message for the presentation
Video editing software
To change the video of Martin
Spreadsheet
To create a chart/graph
10(a) Three from: 3

Oxygen
Light
pH
Turbidity

PUBLISHED
10(b) Six from: 6

Advantages
More accurate results produced
Computer does not forget to take a reading
Results are processed automatically
Readings can be taken at more points as many humans are needed
Readings can be taken that would be impossible for humans
Data can be analysed continuously
Readings can be taken more frequently
Safer than using humans
Better response time
Can work 24/7
Can be placed in remote areas where humans could not work
Fewer humans required therefore reducing the cost
Disadvantages
Computer responds less to unusual circumstances
Computer equipment can be more susceptible to atmospheric conditions
Computer equipment is more likely to be damaged or stolen by vandals
To gain full marks the discussion must have correct answers for both advantages and disadvantages

PUBLISHED
11 Interviews 6
Advantages
Questions can be explained if they are misunderstood this cannot happen withquestionnaires
Questions can be asked relating to the answers given previously
More detailed answers can be given
More complex questions can be asked
Questions can be changed to suit the person being interviewed
The person being interviewed tends to answer all the questions
Can see body language
Disadvantages
They are not anonymous whereas questionnaires are
Takes far longer to complete than a questionnaire
The interviewer and interviewee must be available at the same time
More expensive as the interviewer has to be hired and interviewee needs time off
Answers may not be honest//more honest with a questionnaire as the person isanonymous
Answers may be skewed by the interviewer
Answers in a questionnaire can be analysed quicker through OMR
Questionnaires tend to be sent to more people
To gain full marks the discussion must have correct answers for both interviews and questionnaires
12(a)(i) Fire 2
Two from:
CO2 fire extinguisher
Don’t overload sockets
Have fans/cooling system
Use Residual Circuit Breaker/RCB
12(a)(ii) Electrocution 2
Don’t bring drinks close to computers
Cover/insulate live/bare wires

PUBLISHED
12(b) Three from: 3

Report/block cyberbullies
Respect other players
Check game ratings for age
Reduce the amount of time spent gaming
Be careful of in-app purchases
Turn on privacy settings
Don’t use your real name//use a nick name
Don’t give away personal information
12(c) Max two from: 4

Part of the authentication system
Needed to improve security
Max three from:

Combined they are unique
User ID is an identifier for the user
Password is a string of characters
Passwords verify the user in the authentication process
13(a) Four from: 4

Copyright is the legal and exclusive right to copy, or permit to be copied, some specific work
If you own the copyright on the content of a web page someone else cannot make a copy of it without your permission
Copyright usually originates with the creator of a work, but can be sold, traded, orinherited by others
If you blog, take photographs, publish music, or otherwise produce copyrightable content, you legally own that content
Whether you want to let other people use it or not is your decision
If you want to use other people’s content, you have to understand permissions andlicensing, what is legal and what
isn’t//Read Terms and Conditions
Supports the original producers of the software/content

PUBLISHED
13(b) Serial numbers/product keys 4

When software is being installed, users are often asked to enter a unique number which proves the software is original
Serial numbers and product keys are supplied with the original copy of the software
Holograms
Holograms are often used on the packaging of software and they indicate that the copy is genuine
Software without a hologram on the packaging is usually an illegal copy as they are too difficult and costly for pirates to
implement
Licence agreements
Licence agreements are part of the software installation process and they inform the user exactly how they are legally
allowed to use the product
Users are required to 'agree to terms of use' before they can complete the installation Any breach of this can mean
prosecution and fines
One mark for naming the method then one mark for each reason
To gain full marks candidates must have at least one description in addition to naming the methods
13(c)(i) Four from: 4

The laws within a country//In some countries emails are monitored and people arepunished for what they write
Using emails for marketing purposes//Laws differ in different countries
Netiquette
Local guidelines set by an employer
The need for security//Some countries monitor keywords in emails
Password protection does not allow people to see the contents
Cultural offences

PUBLISHED
13(c)(ii) Two from for example: 2

Include a clear, direct subject line
Use a professional email address
Use professional salutations
Use exclamation points sparingly
Be cautious with humour/sarcasm/slang
Proofread the message before you click send
Do not use capital letters as it implies shouting
Do not use swear/offensive words
Do not use defamatory comments
Protect others privacy
14(a) Checks the data entered/transferred/copied correctly 2

Matches the original document
14(b) Check digit: Serial_number 3

Length: Shelf_number
Type: Number_in_stock//Name_of_supplier//Name_of_item
14(c) Serial_number 1
15(a) Four from: 4

Is debit card number valid/exists
Does name entered match that on system
Is expiry/start date valid/matches date stored on system
Does security code/CVV entered match that stored on system
Is there available credit/funds in the bank account
Checks for unusual spending patterns
Is card blocked/reported stolen/lost

PUBLISHED
15(b) Four from: 4

Computer looks up the date of performance/performance reference number
Matching record is retrieved
Checks/Searches if the seats are available
Flags the seats to stop double booking as temporary hold
Reduced number of available seats by the number booked//seats flagged as fully booked
Calculate cost of seats
Prints ticket/generates e-ticket
E-ticket/ticket sent to customer
Receipt is printed/Verification email sent
Data is checked for accuracy
If booking not completed, then temporarily hold flag is removed from the seat
Reduce number of seats available once the booking is complete

™
Cambridge IGCSE

*8667658371*

2 hours
INSTRUCTIONS
INFORMATION
06_0417_12_2022_1.15
2
1 Circle two input devices.

Digital
3D printer Actuator CD ROM
camera
Keyboard Linker Monitor Speaker
[2]
2 A computer-controlled glasshouse is used to grow plants.
Identify two output devices used in this glasshouse.
1 ...............................................................................................................................................
2 ...............................................................................................................................................
[2]
3 Network devices are used in computer systems.
Complete each sentence by identifying the most appropriate network device.
(a) The network device that is used to transmit the data along an analogue telephone line is a
........................................................................................................................................... [1]
(b) The network device that connects a LAN to a WAN is a
........................................................................................................................................... [1]
(c) The network device that allows data to be directed to a specific computer on a LAN is a
........................................................................................................................................... [1]
(d) The internal network device that allows a computer to connect to a LAN is a
........................................................................................................................................... [1]
© UCLES 2022 06_0417_12_2022_1.15

3
4 Many word processing packages have a number of formatting features.
The paragraph below shows some of the formatting features that can be used.
(a) Write down four of the formatting features that have been used in the paragraph shown.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
4 ........................................................................................................................................
[4]
© UCLES 2022 06_0417_12_2022_1.15 [Turn over

4
(b) The logo for the Summer Steam Festival is shown and labelled A. The organisers of the event
are planning to create a second logo for all their correspondence. This is shown and labelled B.
Summer
Steam Festival Summer
2022 Steam Festival
2022
A B
Describe the steps that have been used to transform logo A into logo B.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 06_0417_12_2022_1.15

5
5 A library is considering the way it issues books. The librarians are planning to use RFID rather than
bar codes.
Describe the advantages of using RFID rather than bar codes.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [4]
6 Laptop computers use Solid State Drives (SSD) rather than Hard Disc Drives (HDD).
Describe two disadvantages of using an SSD rather than an HDD in a laptop computer.
1 ...............................................................................................................................................
..................................................................................................................................................
2 ...............................................................................................................................................
..................................................................................................................................................
[2]
© UCLES 2022 06_0417_12_2022_1.15 [Turn over

6
7 A patient has an injury and the doctor treating him needs to find out information about the patient.
Most of the data he needs to collect is personal data.
The data collected is protected by data protection legislation. Most data protection acts include the
principle that data should be kept confidential and secure.
(a) List four other principles of a typical data protection act.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
4 ........................................................................................................................................
...........................................................................................................................................
[4]
(b) Explain what is meant by personal data. Include two examples of personal data in your answer.
Explanation .......................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
Example 1 .........................................................................................................................
...........................................................................................................................................
Example 2 .........................................................................................................................
...........................................................................................................................................
[3]
© UCLES 2022 06_0417_12_2022_1.15

7
(c) Explain why personal data should be kept confidential and secure.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
8 Uniform Resource Locators (URL) are used to locate websites and resources. A teacher needs to
find a teaching guide from Cambridge Assessment International Education. To download the
teaching guide she types in:
(a) Write down only the part of the URL which shows the file name of the teaching guide.
........................................................................................................................................... [1]
(b) Write down only the part of the URL which is the folder where the teaching guide is stored.
........................................................................................................................................... [1]
(c) Write down only the part of the URL which is the domain name.
........................................................................................................................................... [1]
(d) Explain what is meant by https.
...........................................................................................................................................
........................................................................................................................................... [1]
© UCLES 2022 06_0417_12_2022_1.15 [Turn over

8
9 A student is creating a spreadsheet of airports for a project.
The formula in G2 is:
=VLOOKUP(F2,A2:B9,2,0)
(a) Explain, in detail, what the formula in G2 does.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(b) Before the spreadsheet can be used, data needs to be entered to test the spreadsheet.
There are three types of test data: normal, abnormal and extreme.
Explain what is meant by these three types of test data.
Normal ..............................................................................................................................
...........................................................................................................................................
Abnormal ..........................................................................................................................
...........................................................................................................................................
Extreme ............................................................................................................................
...........................................................................................................................................
[3]
© UCLES 2022 06_0417_12_2022_1.15

9
(c) Explain, using examples, the differences between a function and a formula.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
(d) The completed file could have been created using a database.
Describe two reasons why databases are used in certain applications rather than spreadsheets.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
© UCLES 2022 06_0417_12_2022_1.15 [Turn over

10
10 The prolonged use of computers can cause several health problems particularly when sitting down
and using monitors.
Discuss the strategies that you have developed to minimise health risks which only relate to sitting
down and using a monitor.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [8]
© UCLES 2022 06_0417_12_2022_1.15

11
11 A car manufacturing company uses computer-controlled robots to manufacture its cars.
Discuss the advantages and disadvantages to the company of using computer-controlled robots
rather than using humans to manufacture the cars.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
© UCLES 2022 06_0417_12_2022_1.15 [Turn over

12
12 Different methods can be used to analyse a system.
Discuss the benefits and drawbacks of analysing a system by observing staff rather than looking
at the current systems documentation.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
13 A librarian in a college department library is entering data into a student borrowers’ file. As the data
is entered it needs to be verified.
(a) Describe the two types of verification.
1 ........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
[4]
© UCLES 2022 06_0417_12_2022_1.15

13
(b) Explain, using examples, why it is necessary to carry out validation as well as verification for
this system.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 06_0417_12_2022_1.15 [Turn over

14
14 Spam is associated with ICT systems.
(a) Explain what is meant by the term spam.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Describe the ways that a user can recognise spam and methods to help prevent it.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 06_0417_12_2022_1.15

15
15 (a) Explain what is meant by cloud storage and how it is used.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
(b) Describe two issues related to the security of data in the cloud.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
[2]
© UCLES 2022 06_0417_12_2022_1.15 [Turn over

16
16 A company uses corporate house style within the headers and footers in its documents.
(a) Explain what is meant by corporate house style.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Explain why headers and footers are needed.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
© UCLES 2022 06_0417_12_2022_1.15

Cambridge IGCSE™

MARK SCHEME
Maximum Mark: 100
Published
Teachers.

PUBLISHED
marking principles.
descriptors.

PUBLISHED

PUBLISHED
1 Keyboard 2
Digital camera
2 Two from, for example: 2

Sprinkler
Lamp
Heater
Vents/Window openers/Motor
Actuator
3(a) Modem 1
3(b) Router 1
3(c) Switch 1
3(d) Network interface Card/NIC 1

PUBLISHED
4(a) Four from: 4

Bold
Full justification
Highlight
Underlined
Italic
4(b) Four from: 4

Click on the shape/logo A
Slide the corners in to reduce the size of the shape/logo
Keep the aspect ratio//type in the height and width
Fill the shape/logo with black
Highlight the text
Reduce the size of the text
Change the colour of the text to white
Click on the image/train
Reduce the height and width//reduce the size of the image/train
5 Four from: 4
RFID are faster to read than bar codes
RFID scanning is more accurate than bar codes
RFID does not need line of sight to read but bar code does
RFID will read the data if the reader is further away
RFID can scan multiple items at the same time
RFID allows greater security
RFID can store more data than a bar code
RFID tags can be rewritten, so can be reused
RFID tags are more robust as bar codes will not scan if damaged

PUBLISHED
6 They tend to have a more limited number of read and writes 2

More expensive per Gb than HDD
7(a) Four from: 4

Data should be fairly and lawfully processed//Data should be processed in a transparent manner
Data should only be processed for the stated purpose
Data should be adequate, relevant and not excessive/limited
Data should not be kept longer than necessary
Data should be processed in accordance with the data subject’s rights
Data should be collected for specific purposes
Data should only be further processed for archive purposes which is compatible with the initial purposes
Data kept for archiving should safeguard the rights and freedoms of individuals
Explicit consent required for processing sensitive data
Data subjects are allowed access to their personal data
Data should be accurate and kept up to date
Data should not be transferred to another country unless they have adequate protection
Parental consent required for processing personal data of children including online services
7(b) One mark for the explanation 3

Personal data is data relating to an individual/person that can be identified
One mark per example

Name, address, date of birth, gender, biometrics, mobile/cell phone number, credit/debit card number, personnel ID
number, personal appearance, medical record, criminal record, ethnic origin, picture of yourself, political opinions, religious
or philosophical beliefs, trade-union membership record, genetic data, IP address, racial identity
7(c) Four from: 4

The person can be identified from the data
The data is confidential as it links directly to the person
If someone gets access to the data then they can use the information to attack the person
If not kept confidential and secure it could lead to home burglaries as people post holiday details on social media
If not kept confidential and secure it could lead to the chance of users suffering physical harm
Protects sensitive data

PUBLISHED
8(a) 2193733.pdf 1
8(b) igcse-ICT-0417 1
8(c) www.cambridgeinternational.org 1
8(d) Secure internet protocol 1
9(a) =VLOOKUP(F2,A2:B9,2,0) 4
Four from:
Looks up F2/Airport name
Looks up in the range A2:B9/Code and Name
Finds the corresponding value from the 2nd column
Displays the value in G2
Finds exact match
9(b) Normal 3
Data that is within the boundary of acceptability
Abnormal
Data that is outside the boundary/limit of acceptability/incorrect data
Extreme
Data on the edge of acceptability

PUBLISHED
9(c) Max two from: 6

Formula
A formula is a statement written by the user
A formula is an equation
A formula can contain values/references to cells/defined names
A formula can contain functions
One mark
Examples =A1+B1, =SUM(A2:B2)
Max two from:

Function
A function is a named piece of code designed to calculate specific values
Functions are used inside formulas
A function is a built in/predefined operation
One mark
Examples SUM/AVERAGE etc
9(d) Two from: 2

A database can use queries
A database can use relationships
Referential integrity can be enforced in a database
Easier to create forms on a database
Easier to create reports on a database
Better user security
Data is easier to manage in a database
A database can reduce data duplication

PUBLISHED
10 Eight from: 8
Use of the monitor
Using a flat screen monitor can reduce eye strain and headaches
I turn the monitor 90 deg to the window to reduce the glare on the screen
If I turn the monitor this can cause problems with the layout of the room
I need to buy a monitor that could tilt to reduce neck ache
I close the window blinds to avoid glare on monitor/headaches
I should not use rooms with more than one window but this could be difficult
I could use a matt screen to prevent glare/headaches
I use a flat screen monitor as there is less flicker therefore reduces the chance of an epileptic seizure/eye strain/headaches
I keep the screen clear of dust to reduce static and eye strain
I could have my eyesight tested regularly
Brightness of the room should equal the brightness of the screen to prevent eye strain
Enable blue light filter/blue light glasses to prevent eye strain
I could set night light on the computer to prevent eye strain
I sit at arms length from the screen to prevent eye strain
Sitting down
I use an ergonomic chair/standing desk to reduce back and neck pains
I sit with correct posture to help reduce back and neck pain
I use a footrest to reduce DVT/improve posture
If there are wheels on the chair for easy movement I should be careful to avoid injury problems with the chair moving
backwards
Maximum of six marks if candidate only mention strategies for either sitting down or using a monitor

PUBLISHED
11 Six from: 6
Advantages
Robots can work in sterile/harmful areas which are dangerous for humans
Humans would need protective clothing which would cost the company more money
Robots can more easily be used for transferring large delicate items
Robots can work 24/7
Cheaper in the long run
Higher productivity
More accurate/precise engineering
More frequent checking of the equipment
Fewer workers are needed therefore lowering costs
Production of the cars is more consistent
Disadvantages
Expensive to buy robots
Maintenance is expensive
Requires backup systems, which are expensive
They replace skilled workers, leading to de-skilling
They need constant observation which increases the cost of maintenance crews

PUBLISHED
12 Observation 6
The analyst sees it with their own eyes
Get a complete picture of the whole system
Cheaper as it does not take the worker away from work
Description of the Hawthorne effect
The quality and accuracy of information is highly dependent on the skill of the observer
Examining documents
Can see exact details of inputs, processing and outputs
Saves time as there could be copies of previous analysis
Allows the analyst to predict the size of the new system by analysing the amount of data
Very time consuming to look through all the documents
Very expensive to pay for an analyst to look through all the documents
To gain full marks the discussion must have correct answers for both observation and examining documents
13(a) One mark for naming the verification and one mark for explanation 4
Visual verification
Person enters the data it is read through and corrected as needed using the original copy
Double data entry

One from:
Person types the data then retypes the data from the original copy/source
Person types the data and another types the data from the original copy/source

PUBLISHED
13(b) Max three from: 4

Not all errors are found by validation and verification separately
Source document may contain errors
Verification only checks that data is copied correctly
Verification does not check if data is reasonable/sensible
Validation checks are carried out automatically by the computer
Max two examples:

Correct appropriate example of a verification check
e.g. data supplied by the borrower is incorrect on the source document and was copied
Correct appropriate explanation of an example of a validation check
e.g. (Number of books borrowed is 1 misread as a 7; in a range check of 1–10)
14(a) Two from: 2

Spam is junk mail
Sent in large numbers to inboxes
Unwanted/unsolicited emails
Fills the inbox
Used for advertising
Used for phishing/spreading malware

PUBLISHED
14(b) Max four from: 6

Multiple spelling/grammatical errors
Asked to carry out tasks immediately
Asking to click on a link
Does not ask for you by name
Stored in a SPAM folder
Email asks for personal information
Large amount of repeated emails from same user
Lots of other similar email addresses in the send to box
Max four from:

Use a spam filter
Not filling your details on online form
Not replying to spam emails
Not having an auto reply set
Not consenting to marketing when providing details to a company
Do not give email address

PUBLISHED
15(a) Six from: 6

What it is:
Cloud storage involves storing data in a remote physical location
Online storage platform
Cloud storage systems use hundreds of interlinked data servers
Storage system that requires access to the internet
How is it used:
User accesses the cloud storage using the internet
Cloud data can be accessed from any device
Clients send files to a data server
The server is maintained by a cloud provider
Data can be shared with other users
Cloud storage automatically backs up data
If one server fails there are others used as backup
Users pay a monthly/annual fee for storage used
To gain full marks the explanation must have correct answers for both what it is and how it is used
15(b) Two from: 2

Easier to hack as data is always available
Lose control of your data
More than one copy available to access therefore security is reduced
More difficult to delete all copies of the data
16(a) Two from: 2

A set of rules
House style states how all documents and written communication should be formatted
Consistency across all documents in the portfolio of the company
Used to promote the company
Controls how the colours/font style/font size/font type/position of logo/justification of text/position and style of address
details to be used – 1 mark for any two items

PUBLISHED
16(b) Two from: 2

To display descriptive information on each page
Helps the user to navigate through the document
Used for repeatable items
Headers and footers can be on every page
Maintains consistency in the document
Saves time rather than writing the same things on each page

™
Cambridge IGCSE

*2949337011*

2 hours
INSTRUCTIONS
INFORMATION
06_0417_13_2022_1.12
2
1 Circle two storage devices.
Digital DVD RAM

Bridge Linker
camera Drive
Memory
Mouse Printer Spreadsheet
stick
[2]
2 Name an appropriate validation routine for each statement. Each answer must be different.
(a) The last digit in a code used to ensure the other digits have been entered correctly.
........................................................................................................................................... [1]
(b) This validation routine ensures a password is always 8 characters.
........................................................................................................................................... [1]
(c) This validation routine ensures data has been entered into a field.
........................................................................................................................................... [1]
(d) This validation routine ensures that a date is entered as DD/MM/YYYY.
........................................................................................................................................... [1]
3 Identify two input devices which are used in computer control systems.
1 ...............................................................................................................................................
2 ...............................................................................................................................................
[2]
© UCLES 2022 06_0417_13_2022_1.12

3
4 Computers can store data in the cloud rather than using storage devices in the computer.
(a) Describe three benefits of storing data in the cloud.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
(b) Describe three drawbacks of storing data in the cloud.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
5 The manager of a cinema has purchased a new booking system. There are 26 rows in the cinema
with 20 seats on a row. Each seat is identified by a unique ID. The seat ID consists of the row letter
followed by the position of the seat on the row. An example of the seat on row F position 12 would
be F12.
He is setting up a test plan to test the system.
(a) Write down one example of each of the following types of test data. The answers must be
different in each case.
Normal ..............................................................................................................................
Abnormal ..........................................................................................................................
[2]
© UCLES 2022 06_0417_13_2022_1.12 [Turn over

4
(b) When a ticket is produced for the new system it contains a QR code.
Here is an example of a QR code.
Describe the benefits of using a QR code.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [5]
© UCLES 2022 06_0417_13_2022_1.12

5
(c) Discuss the advantages and disadvantages of using manual booking systems rather than
online booking systems.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [8]
© UCLES 2022 06_0417_13_2022_1.12 [Turn over

6
6 Eye strain is one of the health issues associated with using computers.
(a) Explain three causes of eye strain when using computers.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
(b) Identify four methods of reducing the effects of eye strain.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
4 ........................................................................................................................................
...........................................................................................................................................
[4]
© UCLES 2022 06_0417_13_2022_1.12

7
7 Tawara Stores has realised that the number of people shopping for food online has increased over
the past few years.
(a) Discuss the advantages and disadvantages to the customer of shopping for food online.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [8]
© UCLES 2022 06_0417_13_2022_1.12 [Turn over

8
(b) Tawara Stores are also aware that many current websites do not cater for older people. They
intend to create a version of their website for this audience.
Describe the features of this website to meet the needs of an older audience, giving reasons
for your choice of features.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
8 Tawara Hotel uses magnetic stripe cards to allow guests access to their bedrooms. The hotel is
changing the electronic lock it uses on its bedroom doors so the lock can work with RFID cards.
Compare the use of magnetic stripe cards and RFID cards for key entry. Your answer must include
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
© UCLES 2022 06_0417_13_2022_1.12

9
9 The Internet of Things (IoT) allows devices as well as computers to connect to the internet using
a router. Each device uses an IP address.
(a) Explain what is meant by an IP address.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
(b) Explain how a router sends data packets to another network.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
(c) The network has a firewall.
Explain why a firewall is needed.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 06_0417_13_2022_1.12 [Turn over

10
10 Both the internet and the intranet are used for communication.
(a) Define the terms internet and intranet.
(i) Internet
................................................................................................................................
................................................................................................................................
................................................................................................................................
................................................................................................................................ [2]
(ii) Intranet
................................................................................................................................
................................................................................................................................
................................................................................................................................
................................................................................................................................ [2]
(b) The World Wide Web is part of the internet.
Explain why the World Wide Web has become so popular.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
© UCLES 2022 06_0417_13_2022_1.12

11
11 An image has been taken of a bird watcher and a bird. The original image has been saved as a
jpg file type. You have been asked to remove parts of the image to just show the bird and to save
it as a png file type to become the new image.
Original image
New image
(a) Explain the steps needed to change the original image to the new image.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 06_0417_13_2022_1.12 [Turn over

12
(b) Explain the differences between a jpg and a png file type.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
12 The protection of personal data is important as many transactions are carried out online.
(a) Explain how to avoid inappropriate disclosure of personal data.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
© UCLES 2022 06_0417_13_2022_1.12

13
(b) Controlling the freedom of speech is part of policing the internet.
Discuss whether the internet should be policed or not.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
13 In a college library if a book is not available students can reserve the book. When the book becomes
available the librarian needs to inform the student. He does this by typing a letter and printing it.
He has a database of students and has decided that in future he will use mail merge to produce
the letters.
Give four advantages of using mail merge instead of typing out the letter each time.
1 ...............................................................................................................................................
..................................................................................................................................................
2 ...............................................................................................................................................
..................................................................................................................................................
3 ...............................................................................................................................................
..................................................................................................................................................
4 ...............................................................................................................................................
..................................................................................................................................................
[4]
© UCLES 2022 06_0417_13_2022_1.12 [Turn over

14
14 People can manage their banking transactions using the internet. However, if the internet signal is
poor telephone banking can be used.
A person wishes to use telephone banking without speaking to an operator to transfer money from
one bank account to another.
Describe the steps needed to do this.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
© UCLES 2022 06_0417_13_2022_1.12

15
BLANK PAGE
© UCLES 2022 06_0417_13_2022_1.12

16
BLANK PAGE
© UCLES 2022 06_0417_13_2022_1.12

Cambridge IGCSE™

MARK SCHEME
Maximum Mark: 100
Published
Teachers.

PUBLISHED
marking principles.
descriptors.

PUBLISHED

PUBLISHED
1 DVD RAM Drive 2

Memory stick
2(a) Check digit 1
2(b) Length check 1
2(c) Presence check 1
2(d) Format check 1
3 Two from: 2
Sensors
Keypad/Number pad
Touch screen
Microphone
Camera
4(a) Three from: 3

Automatic backup
More storage
Difficult to lose the data as many copies are made of it
Many people can share access to the data
Can be accessed anywhere there is internet connection
Can be accessed from many devices

PUBLISHED
4(b) Three from: 3

No control over data/security
Requires internet access
If the company goes out of business can lose data
If the internet crashes during sending or receiving then data could be lost
Many copies are made of the data which increases security issues
More expensive in the long run due to monthly charges
5(a) Normal 2
Any seat from A1 to Z20//Any letter from A to Z inclusive followed by any number 1 to 20 inclusive
Abnormal
Any incorrect seat row or number/Any character other than A to Z and/or any number outside range 120 or anything that’s
incorrect
5(b) Five from: 5

Can be used for multiple elements
Fast access to additional information
Can be linked into a website
Can automatically link to email
The QR code is unique to the ticket
More robust than bar codes
Secure as the code cannot be swapped

PUBLISHED
5(c) Eight from: 8

Advantages
The customer does not need an email address for the booking
The customer can pay by cash or electronic means whereas is an online system cards/apps are needed
Customers do not need an internet connection
More control of the booking therefore less errors for customers
Easier to cancel a booking once made
It is easier for the customer to gain information/help on the purchase
Disadvantages
Manual systems can result in double booking
Manual booking systems update the data less often than online systems
Difficult to see if a seat is taken as the seats are not updated when booked
Bookings can only be made when the booking office is open
Can only book at a booking office
People have to travel to the booking office to book, therefore wastes time
People have to travel to the booking office to book wastes cost
More difficult to change bookings
Physical tickets are issued which can be lost more easily
6(a) Three from: 3

Staring at a computer screen for prolonged periods of time
Working in a room with poor lighting/Screen brightness too high/blue light of screen
Wrong setting on contrast
Glare from windows
Flickering screens
Dirty screens
Sitting too close to a screen
Text too small/font colour is contrasting with background/incorrect resolution/screen too small

PUBLISHED
6(b) Four from: 4

Take regular breaks/look into the distance to relax the eyes/look at green objects
Use TFT/LCD/LED/flat screens to reduce the flicker
Use anti-glare screens/TFT/matt screens/window blinds to reduce the glare
Match the lighting in the room with the brightness of the computer screen
Turn the screens 90 degrees to the window to reduce the glare on the screen
Enable blue light filter/wear blue light glasses
Use night screen light on the computer
Have eyes tested regularly
Use a LED/LCD/flat screen monitor can reduce eye strain and headaches
Keep the screen clear of dust/dirt

PUBLISHED
7(a) Eight from: 8

Advantages
No longer need to travel to the store so it saves the cost of travelling
No longer need to travel to the store so it saves the time of travelling
Saves time shopping as favourite lists can be produced
Saves time shopping around different stores
Wider range of shops
Customers can shop 24/7
Customers can compare the prices of different stores without travel
Shopping can take place using mobile devices anywhere there is an internet connection
Regular shopping schedules can be set up
Can see the physical objects in store and then have the advantages of shopping online
Disadvantages
Makes people lazy/lack of exercise
Over-reliance on computers
More security issues
Needs a reliable internet connection
Goods can take time to arrive
Goods could be damaged in transit
More chance of errors in the ordering
More difficult to amend an order after purchase
No way of checking the goods before buying
There may be delivery/packaging costs
7(b) Four from: 4

Bold colours/contrasting colours making it easier to read
Larger font sizes/clear font so it is easier for people reading the text
Simple navigation makes it easier to find the products
Larger buttons so they can be easily seen
Interactive screens/buttons/drop down menus to reduce typing
Larger bold heading to make it an easy to read layout

PUBLISHED
8 Six from: 6
Similarities
Both have improved security by using encryption
Data cannot be read by eye so more secure
Data can be re-written
Direct data entry
Both allow fast access to the room
Both are read by a reader/scanner
Both can be easily damaged
Differences
RFID is contactless therefore has less wear and tear whereas magnetic is placed in reader
RFID reads the data faster
More data on RFID card
RFID cannot be left in the lock accidentally
RFID cards can be read by others from a distance using a device
Easier to clone a magnetic stripe card
Magnetic cards can only be read in one direction whereas RFID are only tapped
Magnetic stripe can be affected by magnets/mobile phones
RFID cards are more robust
To gain full marks the comparison must have correct answers for both similarities and differences

PUBLISHED
9(a) Three from: 3

Internet protocol address
Assigned to your computer/NIC/device when it connects to a network
Uniquely identifies NIC/device on an IP network/unique number
Locates individual devices on a network/internet
Can show/indicate/track the physical location of the device
9(b) Three from: 3

The router creates data packets
The router receives the data packet
The data packet contains the destination/IP address
The router looks at the destination/IP address in the packet
The router uses its/has a routing table
Router compares the destination address in the packet with the addresses in its routing table
The router then determines the best route to the next router/network/destination
9(c) Four from: 4

It is needed for network security
It controls/checks the incoming and outgoing network traffic
A firewall is a barrier between a trusted secure internal network and the internet//network and the user
It can log incoming and outgoing traffic
It stops malicious traffic/cyber attacks/checks incoming data against criteria
It prevents computers connecting to unwanted sites
It prevents untrusted/un-recognised/un-authorised computers/users accessing data on the system
Protects data
Sends warnings/alerts the user

PUBLISHED
10(a)(i) Two from: 2

Public access
Its world wide/International
Vast collection of computers and networks/network of networks/WAN/Wide Area Network
10(a)(ii) Two from: 2

Private network
Restricted access
Used in companies and organisations
Used to share internal documents, internal emails
Uses internet technology
10(b) Six from: 6

Vast amount of information
Faster to access information
Search engines allow the user to search quickly vast amounts of information
Information increases all the time
Its widely available
Allows users to meet other people/like minded people/communicate with friends over long distances
Easy for all people to use
Allows people to easily join specialist world wide groups
Allows social networking
Pages are hyperlinked so easier/quicker to find related pages
Allows online shopping/banking
Allows online up to date news, sports around the world/TV on demand
Allows interactivity, such as watching a video to see how to do a task/training aid
Helps vulnerable people to communicate with others
Allows people to be creative/make own websites

PUBLISHED
11(a) Four from: 4

Load the image/photo editing software
Load/import the image
Click on image
Click on crop
Move arrows to select area to be cropped/Draw around the area to be cut out
Click on delete/Click outside the image
Select Save As/export and then select png format
11(b) Four from: 4

jpg is lossy format
Smaller file size
Joint photographic experts group
Loses quality when compressed
png is lossless format

Does not lose quality when compressed
Portable network graphics

PUBLISHED
12(a) Four from: 6

Be careful of impersonators/people pretending to be officials
Safely dispose of personal information
Encrypt your data
Keep passwords private/Use a strong password
Don’t share personal data
Keep privacy settings high
Use security software/anti-spyware
Avoid phishing emails
Use a nickname/alias online
12(b) Four from: 4

For policed
Prevents illegal material being readily available
Prevents young children accessing unsuitable material
Ensures copyright laws are maintained
Stops extreme viewpoints from being seen
Prevents libelous text being added
Prevents hate comments/foul language/racial comments
Against policed
Governments block text/viewpoints/their own bias viewpoint
Unsuitable material is easily available in other ways
Control would cost money and users would have to pay
Control would be very difficult to enforce
Could cause less people to use it
Laws are different in each country but the internet is world wide
Creates a feeling of big brother/always being watched
To gain full marks the discussion must have correct answers for both for and against policed

PUBLISHED
13 Four from: 4
Letters can be personalised for each student
The data is from the file therefore fewer errors
Saves time than typing in all the details each time
Letter can be saved and used again
Standard letter can be used each time/More consistency
Data in the database need only be checked
Easier to make changes to the letters

PUBLISHED
14 Six from: 6
User telephones the bank telephone centre
System asks for the long number on the credit/debit card/sort code and account number/customer Access/ID number
The user taps out the number on the phone keypad and presses #/speaks the number
System asks for certain characters in a password/phone banking security number
The user taps out the characters asked for/security number and presses #
System checks the number is correct
System rejects the password/security number
The user re-enters the characters/security number
After three attempts the telephone connection drops
System asks other security answers
The user taps it in/speaks the answer
System asks which service you require/options given
Users tap in the number to select transfer from one account to another
System asks number of account transfer from
User taps in account number
System connects with the bank account
System asks for number of account transfer money to
User taps in account number
System asks amount to transfer
User taps in the amount
Checks the amount in the account/maximum not exceeded
Approves request
If amount exceeded the call is terminated/transaction declined/insufficient funds
System asks when the transfer should happen
The user taps in the date
System asks you to confirm it/sends a text message/send email
Customer hangs up to end the transaction

™
Cambridge IGCSE

*5302604894*
Paper 1 Theory February/March 2023

1 hour 30 minutes
INSTRUCTIONS
INFORMATION
03_0417_12_2023_1.10
2
1 (a) Explain what is meant by the term software.
...........................................................................................................................................
........................................................................................................................................... [1]
(b) State the two types of software used by computers.
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
2 Tick ( ✓) the device which produces hard copy.
A Buzzer
B Laser printer
C Touch screen
D Webcam
[1]
3 State three items that should be included in the technical documentation of a computer system.
1 ...............................................................................................................................................
2 ...............................................................................................................................................
3 ...............................................................................................................................................
[3]
© UCLES 2023 03_0417_12_2023_1.10

3
4 Young people use the internet for research and communication.
(a) Search engines can be used to research information on the internet.
Describe three benefits of using a search engine to find information.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
(b) Social media can be used to communicate with friends.
Give four precautions that young people should take when using social media.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
4 ........................................................................................................................................
...........................................................................................................................................
[4]
© UCLES 2023 03_0417_12_2023_1.10 [Turn over

4
5 The number of people using online shopping has increased. This has led to an increase in the
number of journeys for the delivery drivers.
Describe how an expert system can be used to produce the best route for the delivery of items.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
6 Bluetooth is a method of wireless communication.
State two devices found in the home which could be connected via Bluetooth.
1 ...............................................................................................................................................
2 ...............................................................................................................................................
[2]
© UCLES 2023 03_0417_12_2023_1.10

5
7 Describe the characteristics of a primary key and a foreign key.
(a) Primary key
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Foreign key
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
8 Many devices in the home can connect to the internet. These are called smart devices.
Describe four benefits of using these smart devices.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [4]
© UCLES 2023 03_0417_12_2023_1.10 [Turn over

6
9 A web page can contain three web development layers. One of these is the content layer.
(a) State one use of the content layer.
...........................................................................................................................................
........................................................................................................................................... [1]
(b) Identify the other two web development layers and give a use for each.
1 ........................................................................................................................................
Use ...................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
Use ...................................................................................................................................
...........................................................................................................................................
[4]
10 Some computers have touch screens.
Describe three benefits of using a touch screen.
1 ...............................................................................................................................................
..................................................................................................................................................
2 ...............................................................................................................................................
..................................................................................................................................................
3 ...............................................................................................................................................
..................................................................................................................................................
[3]
© UCLES 2023 03_0417_12_2023_1.10

7
11 A student has downloaded a file which contains a virus.
(a) Describe the possible effects on his computer system if he opens the file.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Explain how the student could prevent the computer from being infected by viruses.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
(c) Some files containing viruses have to be quarantined as they cannot be deleted.
(i) State the type of files that may have to be quarantined rather than deleted.
................................................................................................................................ [1]
(ii) Explain how the software detects and quarantines the file.
................................................................................................................................
................................................................................................................................
................................................................................................................................
................................................................................................................................
................................................................................................................................
................................................................................................................................ [3]
© UCLES 2023 03_0417_12_2023_1.10 [Turn over

8
12 A tennis coach is creating a presentation to explain to teenagers the basics of playing tennis.
(a) Describe the design features that must be included to make the presentation appeal to the
teenagers.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(b) The designer needs to be aware of copyright legislation when creating the presentation.
Explain the need for copyright legislation.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
13 People can watch a movie either by streaming or from a Blu-ray disc.
Give two advantages of watching the movie by streaming rather than from a Blu-ray disc.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [2]
© UCLES 2023 03_0417_12_2023_1.10

9
14 Compare RAM and ROM. Your answer must include similarities and differences.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [4]
15 Tawara Stores is a small company that does not make much profit. The managing director is
deciding whether to implement a new IT system using direct changeover or parallel running.
Describe the advantages and disadvantages of using direct changeover compared with parallel
running in this scenario.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
© UCLES 2023 03_0417_12_2023_1.10 [Turn over

10
16 A school car park is controlled by a barrier. When teachers enter the car park their number plate
is read and the barrier is raised automatically.
camera
microphone
keypad
speaker
pressure
sensor
motor
Fig. 16.1
(a) Visitors can use the keypad as an input device to enter a code which allows the barrier to be
raised.
Identify three other input devices shown in Fig. 16.1.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
[3]
© UCLES 2023 03_0417_12_2023_1.10

11
(b) Automated Number Plate Recognition (ANPR) is used to read and check the number plate of
the vehicle.
Discuss the benefits and drawbacks of using an ANPR system.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [6]
Please turn over for Question 17.
© UCLES 2023 03_0417_12_2023_1.10 [Turn over

12
17 Verification and validation are used to check data.
(a) Identify and describe two methods of verification.
Method 1 ...........................................................................................................................
Description ........................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
Method 2 ...........................................................................................................................
Description ........................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
[4]
(b) Explain the following validation checks.
(i) Presence check
................................................................................................................................
................................................................................................................................ [1]
(ii) Type check
................................................................................................................................
................................................................................................................................ [1]
© UCLES 2023 03_0417_12_2023_1.10

Cambridge IGCSE™

Paper 1 Theory February/March 2023
MARK SCHEME
Maximum Mark: 80
Published
Teachers.
Cambridge International is publishing the mark schemes for the February/March 2023 series for most
components.

0417/12 Cambridge IGCSE – Mark Scheme February/March 2023
PUBLISHED
responses seen).

PUBLISHED
1(a) One from: 1

Software are programs/apps used by a computer
Software is used to control the operation of a computer
Software are programs/apps for processing of electronic data
1(b) Applications 2
System
2 B Laser printer 1
3 Three from: 3
Purpose of the system/program/software
Limitations of the system
Program listing/coding
Program language used
Program flowcharts/algorithms
System flowchart
Hardware requirements
Software requirements
File structures
List of variables
Input format
Output format
Sample runs/test runs
Validation routines/rules
4(a) Fast to find the information needed 3

More relevant websites are at the top of the list
The amount of information found is reduced making it easier to find relevant
information
4(b) Four from: 4

Block/report unwanted users
Do not arrange to meet online strangers face to face
Do not meet people you do not know alone
Do not disclose personal data
Do not use your real name for the social media name
Do not post images that can link directly to you
Do not post inappropriate images
Do not use inappropriate language
Respect people's confidentiality/privacy
Set status to private

PUBLISHED
5 Six from: 6
Interactive user interface asks questions about the route
The user answers the questions with Yes/No answers
The towns and areas visited/start/end point are typed/entered into the
interactive user interface
Answers lead to other questions
The inference engine searches…
…the knowledge base…
…uses the rules base
The knowledge base is searched for suitable routes between two points
Suggested/probable routes and schedules are displayed
6 Two from, for example: 2

Keyboard
Headphones
Printer
Smart phone
7(a) Two from: 2

It is unique
It cannot be a null value
Identifies a record
7(b) Two from: 2

Is needed to act as a link in relationships
It is only present in relational databases
It is a primary key in another table

Can control the heating from your smartphone so that you come home to a
warm house
Smart TVs allow programs to be recorded remotely
Smart TVs allow view on demand via the internet
Money saving due to reduced utility bills as heating is only turned on when
needed
Smart fridges allow food to be automatically added to the food order
Increased sense of security in the home due to monitoring the CCTV
remotely
The smart device sends alerts to your phone/portable device
Can control the power to devices from anywhere in the home therefore
saves money

PUBLISHED
9(a) One from: 1

Holds/to enter the information of a web page
Create the structure of the web page
9(b) One from: 4

Presentation
Styles
One from:
To display elements within the web page
Holds the css/stylesheet
Defines the format of a web page through styling elements
Maintains the consistency of the elements in the web page
One from:
Behaviour
Scripting
One from:
For scripting language to control elements within the web page
Holds the forms/image galleries
Adds Interactive content of the web page
Adds functionality
10 Three from: 3
Quick to select options
Small footprint
Improved hand/eye coordination
Allows the user to use zoom and pinch making item selection quick
11(a) Two from: 2

Pop up messages can appear on the computer screen
Causes the computer processing to slow down
Causes the computer to crash
Deletes/corrupts files/programs/data
11(b) Three from: 3

Download/use up to date anti-virus software
Regularly scan the computer for viruses
Only open email attachments from people you trust
Scan all portable storage media before downloading files/software
11(c)(i) System files 1

PUBLISHED
11(c)(ii) Max two from: 3

Scan the computer for viruses
If a virus is found in the file…
…it alerts the user that the file needs to be quarantined
Re-scan the computer to check for further viruses
Max two from:

Allows the user to accept/reject the quarantining of the file/
The file is moved to a hidden directory
The user does not have access to the quarantined file
12(a) Four from, for example: 4

Use of videos/animation relating to the topic
Use images relating to the topic
Consistent layout across all the slides
Balance of pictures and text
Balanced use of white space and content
Use bullet points as easier to absorb information
Balance of size between headings and text
Use of interactive elements
Use of background music/sound
12(b) Two from: 2

Copyright is a type of intellectual property
It gives the owner of the copyright the exclusive right to make copies of the
work
It allows the owner to give permission for others to use the work
13 Two from: 2
Cheaper than buying the Blu-ray player
Streaming works on different internet connected devices
Streaming uses a simpler interface

PUBLISHED
14 Four from: 4
Similarities
Both are internal memory
Both are primary storage
The data on both can be read
Both are directly accessed by the CPU
Differences
RAM is volatile//ROM is non-volatile
RAM data can be read from and written to//ROM is read only
RAM is temporary memory//ROM is permanent memory
ROM stores the start up instructions whereas RAM is used to store the
current program/instruction
15 Six from: 6
Advantages
Benefits are immediate whereas with parallel running it takes time for the
new system to be fully running
With direct they only have to pay for one set of staff therefore saves costs
Costs are saved as only one computer system is needed
With direct the maintenance is cheaper as there is only one set of
computers
Data is only entered once so saves duplication of data
The new system is checked thoroughly before implementation
Disadvantages
Staff have to be trained and be fully ready to use the new system before it is
implemented
Staff cannot be trained on the new system whereas in parallel both systems
are running
If there is a problem, then all the data can be lost; this could be disastrous for
the company whereas in parallel there is the original system
With direct staff cannot be trained gradually
16(a) Microphone 3
Camera
Pressure sensor

PUBLISHED
16(b) Six from: 6

Benefits
Saves time in having to check the number plates manually
Less errors as the recognition system is automatic
Saves money as there is no need to check the number plates manually
Secure system as it only allows stored vehicles
Drawbacks
All vehicles need to be added to the database
If the number plate is obscured/dirty it is difficult to read
Some number plates cannot be read due to odd font/sideways
Data needs to be kept up to date
Expensive to setup/maintain the system
17(a) Visual verification – 1 mark 4

Re-reading the document referring to the original – 1 mark
Double data entry – 1 mark

One from:
One person types in the data again referring to the original document
A second person types in the data from the original document and the two
entries are compared
Allow one mark for the method and one mark for the corresponding
description
17(b)(i) Checks that the data has been entered/present into the field 1
17(b)(ii) One from: 1

Checks the input data does not contain invalid characters
Checks the data contains the correct data type

Theory Pastpapers

Uploaded by

Copyright:

Available Formats

Theory Pastpapers

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Theory Pastpapers

Uploaded by

Copyright:

Available Formats

Cambridge IGCSE™

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/01

SPECIMEN PAPER 1 hour 30 minutes

You must answer on the question paper.

No additional materials are needed.

This document has 12 pages.

© UCLES 2020 [Turn over

1 Circle two items which are internal hardware components.

Actuator Keyboard Linker Monitor

Mouse Printer Processor Sound card

State two characteristics of RAM.

3 Tick () which device produces solid objects.

B Dot matrix printer

(a) Contactless credit cards

(b) Multiple choice answers in an examination paper

(c) To scan items at a computerised till

© UCLES 2020 0417/01/SP/23

5 A glasshouse is used to grow plants and is computer controlled.

(a) Name three sensors which could be used in this glasshouse.

Give four other uses of a smartphone.

© UCLES 2020 0417/01/SP/23 [Turn over

7 A developer is writing a program to record the results of examinations taken by students in a

(a) The program will be tested to make sure that it works.

Explain what is meant by normal, abnormal and extreme test data.

The developer is planning to use cloud storage.

© UCLES 2020 0417/01/SP/23

(c) The developer spends a great deal of time using a computer.

Your answers must be different in each case.

Health problem Possible solution

Sitting for too long in one

8 A company has an extranet.

Explain what is meant by an extranet.

© UCLES 2020 0417/01/SP/23 [Turn over

Describe in detail how this system could work.

© UCLES 2020 0417/01/SP/23

10 A headteacher is planning to hold a video-conference with headteachers from other schools.

(b) A technician is setting up the hardware for the video-conference.

© UCLES 2020 0417/01/SP/23 [Turn over

Describe the advantages to Tawara Retail of offering internet shopping.

© UCLES 2020 0417/01/SP/23

The student is unable to save the work on the memory card.

14 Compare the similarities and differences between Bluetooth and wi-fi.

© UCLES 2020 0417/01/SP/23 [Turn over

16 Some confidential personal data can be classed as sensitive data.

© UCLES 2020 0417/01/SP/23

17 A student uses social media to keep in contact with other people.

© UCLES 2020 0417/01/SP/23 [Turn over

Name three components of an expert system.

© UCLES 2020 0417/01/SP/23

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/01

This document has 10 pages. Any blank pages are indicated.

© UCLES 2020 [Turn over

Generic Marking Principles

GENERIC MARKING PRINCIPLE 1:

Marks must be awarded in line with:

Marks must be awarded positively:

© UCLES 2020 Page 2 of 10

Mark scheme abbreviations

/ separates alternative words / phrases within a marking point

© UCLES 2020 Page 3 of 10

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/01

SPECIMEN PAPER 1 hour 30 minutes

© UCLES 2020 [Turn over

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/01

© UCLES 2020 [Turn over