Information and Communication Technology 0417/13 May/June 2019: question paper and mark scheme
Cambridge IGCSE Information and Communication Technology (0417), Paper 1 Written, May/June 2019. Read both free below, or download them. Done the paper? Get it marked by AI against this mark scheme.
Data can be stored on Magnetic, Optical or Solid state media.
Tick the most appropriate type of medium for each of the examples.
Magnetic Optical Solid state
(✓) (✓) (✓)
Blu-ray disc
Hard disk
Pen drive
Flash memory card
[4]
Mark scheme
1 4
Magnetic Optical Solid state
Blu-ray disc 9
Hard disk 9
Pen drive 9
Flash memory card 9
Tick the most appropriate type of computer that matches each description.
Desktop Laptop Smartphone
(✓) (✓) (✓)
A portable computer that would most easily fit into your pocket
A computer that is not powered by batteries
A computer that has the smallest screen
A portable computer with a keyboard and with a built-in 15 inch monitor
[4]
Mark scheme
2 4
Desktop Laptop Smartphone
A portable computer
that would most
9
easily fit into your
pocket
A computer that is
not powered by 9
batteries
A computer that has
9
the smallest screen
A portable computer
with a keyboard and
9
with a built-in 15 inch
monitor
A bank has trialled the replacement of Magnetic Ink Character Recognition (MICR) for the details at the bottom of the cheques with bar codes.
Describe two advantages of using Magnetic Ink Character Recognition (MICR) rather than bar codes when processing cheques.
…… [2]
Mark scheme
3 Two from: 2
The data on the MICR is human readable easier to check the data
Cannot be read by MICR if the cheque is illegally photocopied
Higher security than using bar codes
Truck repair shops tend to use dot matrix printers to produce their invoices.
Identify two advantages of using a dot matrix printer rather than a laser printer in this environment.
…… [2]
Mark scheme
4 Two from: 2
Noise of the printer will not be a distraction in a noisy environment
The dot matrix is more resistant to an oily / dirty environment
Don’t have to fill the paper tray as often
Uses multi-part stationery
Can use carbonised paper
A computer contains system software and applications software.
(a) Explain what is meant by system software.
…… [1]
(b) Explain what is meant by applications software.
…… [1]
(c) Circle two types of system software.
Actuator Linker Operating system
Photo-editing software Sensor Spreadsheet
[2]
Mark scheme
5(a) One from: 1
Programs that control and manage the computer’s hardware//it runs the
applications software
Interface between the computer hardware and the user applications
5(b) Programs that allow the user to carry out specific tasks 1
5(c) Linker 2
Operating system
Phishing, pharming and smishing can affect the security of your data.
For each of these security issues describe the methods which you could use to try to prevent them.
(a) Phishing
…… [2]
(b) Pharming
…… [2]
(c) Smishing
…… [2]
Mark scheme
6(a) Two from: 2
Be careful when opening emails from people you do not know
Be careful when opening attachments from people you do not know
Do not click on executable (.exe) files / batch (.bat) files sent to you
Never give out bank details / PIN / passwords / personal details in an email
Report any phishing attempts
Do not respond to emails from addresses you do not recognise
6(b) Two from: 2
Use anti-spyware to remove pharming code
Check sites carefully before a link is clicked
Delay using a link sent in an email as some sites are time related
Check the URL / web address of the website before you enter personal
details
Make sure you are on a secure website
6(c) Two from: 2
Never give your bank details / PIN / password/personal details over the
mobile phone / text message
Ignore text messages from numbers you do not recognise
Report any smishing attempts
Never click on links in text messages from unexpected people
Never phone the phone numbers that are given in a suspect text message
A number of devices are used to enable computers to communicate within a network. Two of these devices are hubs and switches.
(a) Compare and contrast the use of a hub and a switch.
…… [4]
(b) Bluetooth is an alternative method of allowing computers to communicate with other computers and devices.
Describe how a tablet computer can connect to a printer using Bluetooth.
…… [4]
Mark scheme
7(a) Four from: 4
Similarities
A hub and a switch both are used to connect devices to form a LAN
Both a hub and a switch use data packets
A switch is a type of hub
Both check/read the data packets
Differences
In a hub a data packet is broadcast / sent to every computer or device on
the LAN whereas in a switch the data packet is sent to a specific computer
Security is lower in a hub as all data is broadcast
In the switch the destination address is determined/looked up before it is
sent whereas in a hub data packets are sent to all
A switch uses MAC addresses to locate the destination of the device
whereas is a hub MAC addresses are not checked
A switch uses a look up table to determine destination this is not required in
a hub
A switch is capable of more functionality / multiple VLANs but not in a hub
To gain full marks both similarities and differences are required
7(b) Four from: 4
The devices automatically connect when they come into range
Tablet sends radio signals to the printer / printer receives radio signals from
the tablet
Tablet receives radio signals from the printer / printer responds using radio
signals
A handshake takes place
Award a mark for mention of use of 4 digit code for access / default code /
auto connection with code / some devices don’t need code
Uses a band of 79 radio frequencies / channels
The tablet computer randomly chooses one of the radio frequencies /
channels to use
If it is being used it chooses another at random until it finds a free one
Uses spread-spectrum frequency hopping
2 marks can be awarded for a good description of the handshake.
Tawara Health Centre is creating a new online appointment system for its patients.
The developer has created a table showing part of the file structure of the new database.
Field name Data type Field length Comment
Medical_ID_number Numeric: integer 12-digit unique number
Date_of_birth Date/Time dd/mmm/yyyy
Family_name Text 10
Doctor_name Text 20
Appointment_time Date/Time 5 hh:mm
Contact_telephone_number Text 01617151234
Current_medication Text 20
A, O, AB, B
Blood_type Text 3
Each can be + or –
(a) Apart from presence check, for each field, name an appropriate validation check that could be used. Your answer should be different in each case.
Field name Validation check
Medical_ID_number
Blood_type
Date_of_birth
Contact_telephone_number
[4]
(b) Referring to the fields in the table, name the most appropriate field that could be used as a primary key.
…… [1]
(c) Using the fields given in the database complete the design below showing a suitable online data entry form for the receptionist to fill in.
[6]
(d) The health centre has a new logo that appears on their online data entry form. The developers originally produced a logo and then had to change it so that it could be used appropriately on the online data entry form. The original logo is shown before the changes and the new logo after the changes.
Before
After
Describe the changes that have been made to the original logo to create the new logo.
…… [4]
(e) The doctors in the health centre use an expert system to help them diagnose illnesses.
The symptoms of the patient’s illness are typed in by the doctor.
Describe the processing that the system uses so that it can suggest possible illnesses.
…… [5]
Mark scheme
8(a) 4
Field Name Validation check
Medical_ID_number length check/check digit/type/character
check
Blood_type Lookup check
Date_of_birth Format check/range check/length
check
Contact_telephone_number Length check/character check/type
check
8(b) Medical_ID_number 1
8(c) Max Six from: 6
Information about the patient :
Medical_ID_number, Date_of_birth, Family_name, Doctor_name,
Appointment_time, Contact_telephone_number, Current_medication,
Blood_type
2 marks for all 8 items
1 mark for at least 6 items
Heading –1 mark
Fills the page and is clearly an online form - 1 mark
Home / submit button – 1 mark
Radio buttons for blood type / doctor / Drop down lists – 1 mark
Calendar for appointment time – 1 mark
Appropriate boxes to type in the details – 1 mark
Must have the correct details but appropriate headings are allowed
8(d) Four from: 4
The image has been reduced in size
The background and foreground colours have been inverted
The image has been rotated anti-clockwise / counter-clockwise
The image has been cropped
8(e) Five from: 5
System generates questions
Inference Engine compares data
Compares data with that held in the knowledge base
Uses rules base
Matches to the symptoms are found
System generates a list of possible diagnoses
A large city centre hotel uses a computer-controlled barrier for entry into its car park. A light sensor is used to detect the presence of a car and prevent the barrier from dropping onto the car.
Describe how a microprocessor uses the data from the sensor to control the car park barrier.
…… [6]
Mark scheme
9 Six from: 6
Microprocessor is programmed with pre-set values
Microprocessor reads data from the sensor
Microprocessor compares sensor readings with pre-set values
If the readings show there is a car present...
...the microprocessor sends a signal to the actuator
Actuator opens/raises the barrier
If the readings show no car present the microprocessor sends a signal to
the actuator
Actuator lowers the barrier
Name three physical safety issues associated with the use of ICT equipment, and for each one, suggest a possible method to help to prevent the issue. The methods should be different in each case.
Issue 1……
Method……
Issue 2……
Method……
Issue 3……
Method……
[6]
Mark scheme
10 Three Matched pairs: 6
Electrocution from spilling drinks
Use of RCB / Check insulation regularly / check equipment regularly /
No drinks or food near ICT equipment
Fire from sockets being overloaded or equipment overheating
Use a CO2 fire extinguisher / Don’t cover IT equipment vents / check
electrics regularly / don’t overload sockets / ensure good ventilation
Tripping over trailing cables
Use cable ducts / fasten cables to walls / use wireless devices / hide cables
under flooring
Heavy equipment falling could injure someone
Use strong desks / use large desks / secure equipment to wall or floor or
desk
A small library is situated in a village. When a book is borrowed from the library the borrower presents the book and their library card to the librarian.
(a) Discuss the advantages and disadvantages of the different input devices which could be used by the librarian to record a book being borrowed.
…… [6]
(b) Sometimes specialist books are needed in the library. When this happens a message has to be sent to the main library in the town. The message can either be sent by email or by physical fax.
Describe the advantages and disadvantages of using email compared with sending a fax.
…… [6]
Mark scheme
11(a) Six from: 6
Advantages
Bar code reader / QR reader / Magnetic stripe reader / RFID reader /
Touchscreen is quicker to enter data than keyboard / mouse
Bar code reader / QR reader / Magnetic stripe reader / RFID reader is more
accurate when entering data than keyboard / touchscreen
RFID reader / keyboard can input more information than magnetic stripe
reader / bar code reader / mouse / touchscreen
Disadvantages
Chip / stripe / bar code readers / touchscreen have to be bought / keyboard /
mouse comes with the computer
Continuous use of mouse/keyboard can cause RSI but other devices do not
cause this
If data is typed in using a keyboard / touchscreen then this could lead to
more input errors
More limited options when using a mouse / touchscreen
To gain full marks both advantages and disadvantages are required
11(b) Six from: 6
Advantages of email
Fax the document needs to be printed therefore if the receiving fax is out of
paper this cannot happen / An email does not need to be printed
The document can be more easily lost if sent by fax as it is sent to a device
in a library
The fax machine must be switched on to receive the fax / Emails are
received even if the computer is turned off
The quality of the fax may be poor depending on the print quality
The fax will print even if no ink is in the machine
To use a fax in other documents it needs to be manually entered«
«this could lead to errors
If the line is busy there could be a delay in sending the fax
Each sheet has to be transmitted separately in a fax
No need to buy a fax machine if sending an email
An email is sent directly to the inbox/a person / more private
The email’s data is digital therefore it can be directly used in other software
It is faster to send an email than a fax
The email could be sent to a number of different places at once
The email could be sent to numerous devices at once
The email can have the book order as an attachment
Disadvantages of email
Emails can be spam
The content of the email can be changed electronically whereas the fax is
permanent
Emails can contain viruses
To gain full marks both advantages and disadvantages are required
As student data is entered into a school registration system it needs to be verified.
(a) Name two types of verification.
1……
2……
[2]
(b) Explain using examples why it is necessary to carry out validation as well as verification for this system.
…… [4]
Mark scheme
12(a) Visual verification 2
Double data entry
12(b) Max three from: 4
Not all errors are found by either validation or verification separately
Source document may contain errors
Verification only checks that data is copied correctly
Validation only checks if data is reasonable/sensible
Max two from:
Allow any correct example e.g. the mark registered for a student is incorrect
on the source document and was copied
Correct appropriate explanation of an example of a validation check; e.g.
number of lates for a student is 7 misread as a 1; in a range check of 1 – 10
(a) Explain the term function with reference to spreadsheets.
…… [2]
(b) State the purpose of absolute cell referencing and give the symbol that is used to indicate absolute cell referencing.
…… [2]
(c) Explain why named ranges are sometimes used in spreadsheets.
…… [2]
Mark scheme
13(a) Two from: 2
A function is a pre-defined piece of code
Pass parameters / variables to functions
Function has a pre-defined name in the software / reserved word
They are used inside formulae
A built in operation
Allow 1 mark for examples SUM() / AVERAGE() / NOW() etc.
13(b) The reference of the cell does not change when replicated 2
Uses a $ to show the absolute reference
13(c) Two from: 2
Used if a range of cells are to be used many times
Easier to remember a name rather than the cell references
Example – a range of cells, constant value or a formula
If the range of cells moves the reference remains within the workbook
Several EFTPOS terminals have recently been installed in the ticket booking area of a train station.
Describe the inputs and outputs of such a system when purchasing a ticket.
…… [6]
Mark scheme
14 Six from: 6
Output: ‘Message about the journey’
Input: Customer selects journey details
Output: Message ‘Please enter your card / swipe card’
Input: Customer inserts card into chip reader / customer swipes
card/customer places (contactless) card on reader
Input: Data from the card is read by RFID / magnetic stripe reader /
chip reader
Output: message ‘Please enter your PIN’
Input: PIN is entered
If incorrect, customer is asked to re-enter PIN
Output: Message 'Do not remove your card'
Output: Message 'Please remove your card'
Output: Ticket is printed
Output: Message 'Do you require a receipt?'
Input: Yes / No selected
Output: If Yes selected, the station EFTPOS terminal produces a receipt
Output: verbal instructions on what to do
Peter is researching his family tree for his history project. He has the choice of using historical records stored in the local library or the internet to find the necessary information.
Apart from not having to travel, discuss the advantages and disadvantages to Peter of using historical records stored in the local library rather than the internet.
…… [8]
Mark scheme
15 To be marked as a level of response: 8
Level 3 [7 – 8 marks]
Candidates will address both aspects of the question and discuss/consider
different advantages/disadvantages. The issues raised will be justified.
There will be a reasoned conclusion. The information will be relevant, clear,
organised and presented in a structured and coherent format.
Level 2 [4 – 6 marks]
Candidates will address both aspects of the question and discuss/consider
different advantages / disadvantages although development of some of the
points will be limited to one side of the argument. There will be a conclusion.
For the most part the information will be relevant and presented in a
structured and coherent format.
Level 1 [1 – 3 marks]
Candidates may only address one side of the argument, and give basic
advantages/disadvantages. Answers may be simplistic with little or no
relevance.
Level 0 [0 marks]
Response with no valid content
Answers may make reference to e.g.:
Advantages
No danger of accessing inappropriate information
Relevant information can be found quite quickly, if the information you need
is local to the area and held in the historical records at the library
Don’t have to worry about having to have internet connectivity
Less likely to be information overload compared to the internet
Librarian can recommend what and how to search in the historical records
Index makes searching more efficient
Disadvantages
Historical records have limited amounts of information
Historical records only contain one type of information whereas the internet
contains records from other places
Can be slower to find relevant information than using a search engine
The census contains hand written data that is scanned therefore could be
difficult to read
Manual records don’t have multimedia to help explain information
Data in the historical records is not in digital form therefore cannot be copied
and pasted.
More errors in transferring the data than from the internet
Access is limited to library opening hours
Historical records cannot find information from around the world quickly
It can be slower to search for information compared to the internet
Checked your answers against these? Let AI mark the whole paper, on your own working.
Examiners follow the generic marking principles at the front of the scheme, then each question's points: method (M), accuracy (A) and independent (B) marks, error carried forward where the scheme allows it, and positive marking, so you're credited for what you got right.
Check your answers against it
Done this paper? Upload your script and CIE Buddy's AI marker marks it question by question against this exact scheme, puts the ticks on your own working and says what each lost mark needed.
Where can I find the 0417/13 May/June 2019 mark scheme?+
On this page, free: the mark scheme for IGCSE Information and Communication Technology 0417/13, May/June 2019 (0417_s19_ms_13), and the question paper (0417_s19_qp_13), to read or download, with each question's marking points written out underneath.
How many marks is 0417/13 out of?+
Information and Communication Technology 0417/13 for May/June 2019 is out of 100 marks, with 2 hours to answer it.
Can I get my 0417/13 answers marked?+
Yes. Upload your answers to 0417/13/M/J/19 as a PDF or photos, and CIE Buddy marks every question against this paper's official mark scheme, using Cambridge's marking rules. You get your score, each lost mark explained on your own script, and the topics to revise. It's a guide, not an official Cambridge grade.