Information and Communication Technology 0417/12 February/March 2019: question paper and mark scheme
Cambridge IGCSE Information and Communication Technology (0417), Paper 1 Written Paper, February/March 2019. Read both free below, or download them. Done the paper? Get it marked by AI against this mark scheme.
For each of the different statements, tick the most appropriate network.
WAN WLAN LAN
(✓) (✓) (✓)
A cabled network used in one building.
The internet is an example of this type of network.
Several networks connected together using a router.
This network is connected without cables.
[4]
Mark scheme
1 4
WAN WLAN LAN
(3) (3) (3)
A cabled network used in one building. 3
The internet is an example of this type of 3
network.
Several networks connected together using a 3
router.
This network is connected without cables. 3
Tick whether the following are examples of System Software or Applications Software.
System Applications
Software Software
(✓) (✓)
Compiler
Word processing software
Spreadsheet software
Operating system
[2]
Mark scheme
2 2
System Software Applications Software
(3) (3)
Compiler 3
Word processing 3
software
Spreadsheet 3
software
Operating system 3
4 correct ticks – 2 marks
2 or 3 correct ticks – 1 mark
1 correct tick – 0 marks
Command Line Interface (CLI) and Graphical User Interface (GUI) are examples of interfaces found in computer systems.
Give two advantages of a computer having a GUI rather than a CLI.
1 ……
2 ……
[2]
Mark scheme
3 Two from: 2
The user does not have to learn/remember commands
More user friendly
Can be used on more devices e.g. smartphones
A mouse/finger can be used to select icons
Using a mouse/finger is simpler than typing in commands
Fewer errors are made than typing in commands
A router is used in networks.
Describe how a router routes data packets.
…… [3]
Mark scheme
4 Three from: 3
Inspects the data packets received
Checks the destination IP address
using the stored routing table
It uses a routing table which lists all the different routes to other networks
Uses the IP address to work out the best route
sends the data packet to the next router
The Tawara Tea Company supplies tea to its customers. The company has created a spreadsheet to help its sales team to keep track of its orders.
The spreadsheet has two worksheets, named Products and Orders.
Part of the spreadsheet is shown below.
All prices and costs are displayed in Indian Rupee ₹.
Worksheet: Products
A B C
1 Tea code Product name Price per unit
2 272 Singbulli Champagne Oolong ₹ 16.00
3 347 Phuguri Supreme ₹ 16.00
4 348 Tumsong Supreme ₹ 16.00
5 349 Pussimbing Supreme ₹ 16.00
6 3 Phuguri ₹ 8.50
7 5 Goomtee ₹ 8.00
8 6 Risheehat ₹ 6.40
9 7 Makaibari Organic ₹ 4.90
10 8 Bannockburn ₹ 5.00
11 9 Chamong Organic ₹ 4.00
Worksheet: Orders
A B C D
1 Order ID Tea code Quantity ordered Cost
2 124 272 24
3 124 348 25
4 124 6 105
5 124 9 120
6 124 349 30
7 125 3 225
8 125 5 220
9 125 6 200
A salesman needs to create a formula to be placed in cell D2, in the Orders worksheet, that finds the Price per unit of the tea, multiplies it by the Quantity ordered and then displays the result.
(a) Write a formula that needs to be entered in cell D2. This formula will be replicated down to cell D9.
=
…… [8]
The salesman has created a new worksheet called Receipt which automatically produces a receipt for each order.
Worksheet: Receipt
A B C D E
1 Order ID Tea code Product name Quantity ordered Cost
2 124 272 Singbulli Champagne Oolong 24 ₹ 384
3 348 Tumsong Supreme 25 ₹ 400
4 6 Risheehat 105 ₹ 672
5 9 Chamong Organic 120 ₹ 480
6 349 Pussimbing Supreme 30 ₹ 480
7 Total ₹ 2416
(b) Explain how he could format the Cost column (column E) to display the values in Indian
Rupees as shown.
…… [3]
Mark scheme
7(a) VLOOKUP(B2,Products!A$2:C$11,3,False)*C2 8
1 mark for correct function VLOOKUP()
1 mark (B2,
1 mark Products!
1 mark for A2:C11
1 mark for correct use of $
1 mark for ,3
1 mark for ,False)
1 mark for *C2
All elements must be in the correct order
7(b) Three from: 3
Highlight E2:E7
Select format cells
Select currency/accounting
Select ₹
Select 0 decimal places
A drone is a remote controlled flying vehicle. A drone is being used to monitor floods in Mumbai.
(a) Complete the following sentences, using the most appropriate word or words from the list below.
buzzer joystick monitor pressure sensor
ROM speaker temperature sensor video camera
(i) The drone is microprocessor controlled with input from a
…… [1]
(ii) Images of the floods are captured using a
…… [1]
(iii) The images sent from the drone are displayed on a
…… [1]
(b) Name three advantages of using a drone to monitor the floods rather than collecting the data manually.
1 ……
2 ……
3 ……
[3]
Mark scheme
8(a)(i) joystick 1
8(a)(ii) video camera 1
8(a)(iii) monitor 1
8(b) Three from: 3
Data is continuously sent back to the operator/whereas a person would
collect it and send it back
The drone can work in hazardous conditions
Drones get a wider view of the flood
Can go where people cannot
Aadhya and her family are planning a visit to the Gir National Park and she is creating a web page about the destination.
She has started writing some of the HTML but has made some mistakes.
<html>
<!-- Visit to Gir National Park -->
<head>
</head>
<title>The Gir National Park</title>
<body>
<table style= "width:100%">
<tbody style="background-color: #9acd32>
<tr>
<td rowspan="2"><img src="GIRNP.JPG" width="50" alt="image of an elephant">
</td>
<td><h1>The Gir National Park</h1>
<h3>A National Park of Gujarat</h3>
</td>
<td ><img scr="GIR-LOGO.JPG" alt="Logo for Gir National Park">
</td>
</tr>
<tr>
<td colspan="2" >This webpage is under construction.
</td>
</tr>
</tbody>
<table>
</body>
</html>
Write down four mistakes which would prevent this markup from working properly. Your answers must be different in each case.
1 ……
2 ……
3 ……
4 ……
[4]
Mark scheme
9 </head> is in the wrong place // <title> </title> line is in the wrong place 4
<tbody style="background-color: #9acd32> no ending quotes
scr is not correct syntax should be src
final <table> is not correct should be </table>
An electric bus system is being considered for New Delhi. Passengers will use smart cards to travel on the bus. They will have to add money to their smart card before they can travel.
(a) Compare and contrast the use of smart cards rather than using cash to pay for a journey.
…… [6]
The new electric bus system will help to reduce the air pollution in the city. Sensors are used in the system.
(b) Name a sensor that could be used to detect high levels of air pollution.
…… [1]
(c) The sensor monitors the air pollution. When the air pollution reaches a certain limit, a message is displayed on a street sign in the city to warn pedestrians and road users.
Describe the computer processing involved in this system.
…… [4]
(d) Data from the sensor needs to be converted from analogue to digital before it is processed.
Explain the need for this conversion.
…… [2]
Mark scheme
10(a) Similarities 6
Both used for transactions
Both are portable
Both allow payment at point of use
Max five from:
Differences
Faster process/reading using the card
Someone needs to check correct payment made with cash/card is
automatically checked
May not have enough money on the card and may not know this
When the money has run out on the card it cannot be used until it is topped
up
Card details can be used for statistics to plan for use for the bus
journey/times
A card can be blocked when stolen
More security in place if the card gets stolen
Sometimes you need the correct cash amount/no change given
More likely to have cash in your pocket
If you pay by cash you know how much you have paid/no double payment
No physical cash with a card so less chance of stealing by employees
10(b) One from: 1
Nitrogen oxide (sensor)
Light (sensor)
Gas (sensor)
CO2 (sensor)
pH (sensor)
10(c) Four from: 4
The microprocessor has a stored value/preset
Data from the sensor is compared with the preset value
If the reading is higher than the preset value
Microprocessor sends signal to the street sign
If the reading is lower than the preset value nothing happens / if warning
sign is lit; it is switched off
10(d) Two from: 2
Sensor only reads analogue data
Microprocessor only reads digital data
The systems life cycle is shown. The Design, Evaluation, Documentation and Implementation stages are missing.
Write these stages into their correct places.
Analysis
Development
…… and testing
[4]
Mark scheme
11 4
Evaluation Analysis Design
Implementation
Documentation
Evaluation
Documentation Design
Development
Implementation and Testing
Tawara High School has developed a new computerised system to timetable lessons and examinations. The school needs the new system to be in use before the start of the new school year. The school is planning to implement the new system using either direct changeover or parallel running.
(a) Discuss the advantages and disadvantages of using direct changeover compared with parallel running as a method of implementing the system.
In your answer name the method you would use, giving reasons for your choice.
…… [8]
(b) Describe four advantages of using computerised timetabling systems.
1 ……
2 ……
3 ……
4 ……
[4]
Mark scheme
12(a) Max three from: 8
Advantages
Benefits are immediate whereas in parallel it takes time to fully implement
Costs are reduced as there is only one system to maintain but in parallel
there are two systems and two sets of workers
Less likelihood of bugs as the system will have been fully tested
Data only needs to be entered into one system but with parallel running data
has to be entered into two systems therefore is more time consuming
Max three from:
Disadvantages
If the system fails there is no backup but in parallel running if the system
fails then the old system is still operational//risk of loss of data
Staff have to be trained on the new system as it is implemented with parallel
it is possible to train staff gradually.
Method chosen: Direct Changeover and max two from:
Max two from:
The system will be fully implemented faster than with parallel running
There could be data clashes/inconsistencies with two systems operating at
the same time
Data would be duplicated
The school is dealing with external agencies and therefore need single
output to these agencies
Fewer staff in a school to run two systems
12(b) Four from: 4
Quicker to find clashes within the timetable
Quicker to find the data needed for the timetable
Less error prone
What ... If scenarios can be set up
The data in the timetabling system can be used in other applications
automatically
Quicker to make changes and print timetables
Aayush has been involved in an accident and has badly damaged his hand. A surgeon is attempting to replace Aayush’s hand with a prosthetic hand.
Explain how the surgeon would use a 3D printer to create the prosthetic hand.
…… [4]
Mark scheme
13 Four from: 4
(Both) hand is scanned (using CT or MRI scanners or X-ray)
A 3D digital copy is made of the injured areas/hand
The digital copy is loaded into the software
(Software) slices the model into hundreds of layers
3D printer creates the new hand/prosthetic layer by layer
Uses plastic/resin
The printer binds the layers together
The new hand/prosthetic is compared to his other hand
Re-printed if necessary
The 3D printer prints the final version
A student has handed in her homework. One of the incorrect answers she gave was that encryption could be used to stop an unauthorised person accessing a computer system.
(a) Explain what is meant by encryption and why it is used.
…… [4]
(b) Identify a method which would help to prevent unauthorised access to a computer.
…… [1]
Mark scheme
14(a) Four from: 4
Scrambling/encoding of data
Uses encryption software/encryption key
Requires a decryption/encryption key to unscramble
Meaningless to the hacker
Secures data being transferred from computer to computer
Protects sensitive data/prevents personal/confidential data falling into wrong
hands
14(b) One from: 1
Use of user name and strong password
Biometrics
Use of a dongle
Physical locks
Firewall
Geographic Information Systems (GIS) use satellites.
Describe, using an example, how GIS can be used.
…… [5]
Mark scheme
15 Four max from: 5
Allows the user to model and analyse data according to location
Allows users to create interactive queries
Spatial awareness/see how images fit together in space
Edit map data
Combines maps, graphics and databases
Layers a map with other data
Works with GPS
Examples
One from, for example:
Emergency services can use it to find fire hydrants/other emergency
vehicles
Protection of animal life in certain areas/flood regions
Maps landmarks
Teachers use it in Geography/Science/engineering lessons
Prospecting oil
Maps sites that produce pollution
A programmer is developing a presentation of a new ICT solution for a conference and needs to consider the audience.
(a) Using examples, explain why presentations and ICT solutions have to take into account the type of audience.
…… [4]
(b) The programmer is concerned that the software used for the presentation will be copied by the participants during the conference.
Describe how the software could be protected from illegal copying.
…… [4]
Mark scheme
16(a) Max two marks, for example: 4
The audience could be young
The audience may be teenagers
The audience may be old
Max three from:
The solution must match the age of the audience
More images, sounds, interactive with younger
More words for the older/adults
The audience experience may be greater
More content is needed for younger people to those who are older
Expectations from the audience may be different
An audience of experts would expect more from a solution
More explanation needed from someone who is not an expert
16(b) Four from: 4
Unique reference number/product key needs to be entered when the
product is first installed
the system will check for duplicated numbers
Only runs with CD-ROM/memory stick attached
parts of the software are stored on the memory stick/CD-ROM
Dongle needs to be attached
parts of the software are stored on the dongle
Repetitive Strain Injury (RSI) is one of the health problems associated with the prolonged use of computers.
(a) Describe RSI and what causes it.
…… [2]
(b) State two strategies for preventing RSI.
…… [2]
Mark scheme
17(a) Damage to fingers/wrists 2
Caused by continuous use of keyboards/clicking of mouse
buttons/texting/constant use of mouse
17(b) Two from: 2
Ensure correct position of the arms/hands
Use a wrist rest/mouse rest
Regular breaks
Use ergonomic keyboards/mice
Use voice activated software
Smartphones are being increasingly used by tourists when travelling overseas.
Discuss, using examples, the benefits and drawbacks of the use of smartphones by tourists.
…… [8]
Mark scheme
18 To be marked as a level of response: 8
Award a mark for each benefit or drawback but follow the rules below
Level 3 (7–8 marks):
To gain a level 3 there must be a reasoned conclusion and a justification
and achieved all of level 2
Award a mark for good justification of one of the points raised
Award a mark for a reasoned conclusion
Level 2 (4–6 marks):
For level 2 there must be benefits and drawbacks and achieved all of
Level 1
Level 1 (1–3 marks):
For level 1 there must be benefits or drawbacks up to three
Level 0 (0 marks):
Response with no valid content
Answers may make reference to e.g.:
Drawbacks
Distractions when using the phone
Battery life can be short so needs regular re-charging
Re-charging sockets may be different
Cost of international use can be high
Need a phone plan/phone that can make international calls/data
More likely to be stolen
Loss of signal
Screen size small so difficult to read
Benefits
Phone home without having to find a landline/phone box
Text messages can be sent home rather than finding a landline/ phone box
Take photographs without having to use a separate camera
Take videos without having to use a separate video camera
Look up tourist information easily
Translate the languages immediately
Contact accommodation without having to go to tourist information
Make bookings immediately/without visiting the theatre/hotel/event
Can be used for sat nav without having to carry maps
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/12 February/March 2019 mark scheme?+
On this page, free: the mark scheme for IGCSE Information and Communication Technology 0417/12, February/March 2019 (0417_m19_ms_12), and the question paper (0417_m19_qp_12), to read or download, with each question's marking points written out underneath.
How many marks is 0417/12 out of?+
Information and Communication Technology 0417/12 for February/March 2019 is out of 100 marks, with 2 hours to answer it.
Can I get my 0417/12 answers marked?+
Yes. Upload your answers to 0417/12/F/M/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.