Cambridge International General Certificate of Secondary Education

Cambridge International Examinations
Cambridge International General Certificate of Secondary Education

* 6 0 9 4 4 3 2 1 6 0 *
INFORMATION AND COMMUNICATION TECHNOLOGY 0417/12

Paper 1 Theory February/March 2018
2 hours
Candidates answer on the Question Paper.
No Additional Materials are required.
READ THESE INSTRUCTIONS FIRST
Write your Centre number, candidate number and name in the spaces at the top of this page and any additional
pages you use.
Write in dark blue or black pen.
Do not use staples, paper clips, glue or correction fluid.
DO NOT WRITE IN ANY BARCODES.
No marks will be awarded for using brand names of software packages or hardware.
Answer all questions.
Any businesses described in this paper are entirely fictitious.
At the end of the examination, fasten all your work securely together.
The number of marks is given in brackets [ ] at the end of each question or part question.
This syllabus is approved for use in England, Wales and Northern Ireland as a Cambridge International Level 1/Level 2 Certificate.
This document consists of 14 printed pages and 2 blank pages.
DC (NH) 148522/3
© UCLES 2018 [Turn over
2
1 Complete the following sentences, using items from the list below.
Applications A bar code reader A compiler A CPU Hardware
A monitor A printer A scanner System USB
(a) ................................................ software is designed to manage computer hardware. [1]
(b) ................................................ software examples include word processing and spreadsheets.

[1]
(c) ................................................ produces output in the form of hard copy. [1]
(d) ................................................ converts high-level language programs into machine code. [1]
2 Tick the most appropriate device for reading the details from the following media:
Optical Magnetic Bar code Chip and

Mark Ink reader PIN reader
Reader Character (3) (3)
(3) Reader
(3)
Debit card
Bank cheques
A candidate’s responses for

multiple-choice exam questions
A label on a can of soup
[4]
© UCLES 2018 0417/12/F/M/18

3
3 (a) Identify two uses of 3D printing that help doctors and patients in hospitals.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
[2]
(b) Identify two uses of holographic imaging that help doctors and patients in hospitals.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
[2]
4 CD, DVD and Blu-ray are types of optical storage media.
Tick the most appropriate optical storage medium for each of the statements.
CD DVD Blu-ray
(3) (3) (3)
Stores lower quality audio files
Has the highest storage capacity
The RAM version of this medium is used to

record and play recorded images at the same
time
Stores high definition movies
[4]
© UCLES 2018 0417/12/F/M/18 [Turn over

4
5 Describe the following file formats.
(a) .css ...........................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[2]
(b) .htm ...........................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[2]
6 The Chennai Flood Defence Agency is concerned about the continued flooding of the Adyar river.
You have been asked to produce a flood defence model, using a spreadsheet, to show the normal
depth and the actual depth of the river.
Part of the flood defence model is shown.
A B C D
1 Chennai Flood Defence - Adyar River

2
Normal Actual
depth depth
3 Measurement point (m) (m) Warning
4 Thiru-Vi-Ka Bridge 0.5 3.9 Alert
5 Kotturpuram Bridge 0.5 1.6
6 Anna Salai Bridge 0.6 1.7
7 Alandur Road Bridge 0.65 2
8 Jawaharlal Bridge 0.7 2.6
9 River Bridge 0.75 2.7
10
In the Warning column the model will display:
• ‘Alert’ when the actual depth is above 2.5 m

• ‘Aware’ when the actual depth is between 1.5 m and 2.5 m
• ‘Safe’ when the actual depth is below 1.5 m
• ‘Error’ when abnormal data is entered.
© UCLES 2018 0417/12/F/M/18

5
(a) Test data is entered in cell C4.

Complete the following test plan for the warnings.
Test data Type of data Expected Result

3.4 Normal
Extreme Aware
1.9 Normal Aware
Extreme Aware
Normal Safe
Abnormal Error
[5]
(b) You need to enter a formula in cell D4. This formula will be replicated down to cell D9.
Complete the formula that would be used in cell D4.
=IF(C4>2.5, “Alert”, ...................................................................................................................
...................................................................................................................................................
[5]
(c) One of the users has incorrectly entered actual depth data into cells B4 to B9 rather than cells
C4 to C9.
Describe how you can amend the spreadsheet to prevent this from happening in the future.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[2]

6
(d) Part of the flood defence model is shown.
A B C D
1 Chennai Flood Defence - Adyar River

2
Normal Actual
depth depth
3 Measurement point (m) (m) Warning
4 Thiru-Vi-Ka Bridge 0.5 3.9 Alert
5 Kotturpuram Bridge 0.5 1.6
6 Anna Salai Bridge 0.6 1.7
7 Alandur Road Bridge 0.65 2
8 Jawaharlal Bridge 0.7 2.6
9 River Bridge 0.75 2.7
10
You have been asked to produce a graph or chart to show both the normal level and the
recorded actual level at each of the bridges along the river. Include a legend and the names
of each of the bridges.
(i) Name the most appropriate type of graph or chart to display this data.
.......................................................................................................................................[1]
(ii) Describe how you would use the spreadsheet software to create the graph or chart.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.......................................................................................................................................[4]
© UCLES 2018 0417/12/F/M/18

7
(e) The data will be collected from the river using a remote computer connected to sensors to
measure the data.
Explain why it is better to use this method rather than collecting the data manually.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[4]
7 Tick the three most accurate statements regarding computer hardware.
Tick
(3)
CPU means Computer Processing Unit
Data in RAM is not lost when the computer is turned off
ROM is Read Only Memory
A printer is an input device
A touch screen can be an input device and an output device
The control unit is part of the CPU
The CPU is stored on the hard disk
A pen drive is an example of internal memory
[3]

8
8 A company called HotHouse Design has produced the following on-screen data entry form to input
data into a customer database.
HotHouse Design
Ref. No.
Name of customer
Telephone number
Email address
Work to be carried out
Submit
(a) Describe the changes that HotHouse Design could make to their form in order to improve its
design and make it more user friendly.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[6]
© UCLES 2018 0417/12/F/M/18

9
Mail merged letters will be sent to customers.
(b) Describe how mail merge will be used to produce the letters.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[4]
9 Websites that start HTTPS are secure websites. They use encryption when the data is transferred.
Explain what is meant by encryption.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
......................................................................................................................................................[3]

10
10 The Mansa Cricket Club (MCC) is considering setting up an online forum to allow users to post
comments.
(a) Compare and contrast a moderated forum with an un-moderated forum.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[6]
(b) The cricket club considered other methods of allowing its spectators to comment on the
matches.
Tick the most appropriate method for each of these examples.
Blog Wiki Email

(3) (3) (3)
Interactive cricket club web page that can
be viewed and edited by users
An online journal written by the club
secretary
Transmission of messages sent directly to
the secretary of the cricket club
Club members cannot edit the comments
posted online
[4]
© UCLES 2018 0417/12/F/M/18

11
(c) The cricket club are designing a poster to publicise a match against a New Zealand XI. They
have produced the following poster. The space available for the image is 1.3 cm high by 1 cm
wide and the image is currently 26 cm high by 16 cm wide.
Mansa Cricket Club

Place
image
here
New Zealand XI
vs
Mansa Cricket Club
14th March 2018

at the Brabourne Stadium
The image on the right is to be used in the poster but it is too large.
Describe how to edit the image, without cropping, to fit into the space in the poster.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[3]
(d) The image used in the poster is copyright-free.
Explain why copyright legislation is needed for images.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[2]

12
11 There are two types of documentation, user and technical.
Tick the elements that are part of User documentation, Technical documentation or Both.
User Technical Both

documentation documentation (3)
(3) (3)
Purpose of the system
Program listing
Input format
Error messages
Hardware requirements
[5]
12 Ananya is a student who is considering buying a new laptop computer. She visits the local store
and is offered the choice of a laptop with an internal solid state drive (SSD) or a laptop where she
can store her data in the cloud.
(a) Describe the benefits and drawbacks of using an SSD rather than the cloud to store her data.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[6]
© UCLES 2018 0417/12/F/M/18

13
(b) Ananya is planning to invite her friends to the local cinema and is going to send them an
email.
Explain why she uses an email group to do this.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[3]
13 A school has a computer room containing some laptops and some desktop computers. The
headteacher must consider safety issues.
Identify three of these issues and for each one write down a method which would help the
headteacher minimise the risk. Each method must be different in each case.
Issue 1 ..............................................................................................................................................
..........................................................................................................................................................
Method 1 ...........................................................................................................................................
..........................................................................................................................................................
Issue 2 ..............................................................................................................................................
..........................................................................................................................................................
Method 2 ...........................................................................................................................................
..........................................................................................................................................................
Issue 3 ..............................................................................................................................................
..........................................................................................................................................................
Method 3 ...........................................................................................................................................
..........................................................................................................................................................
[6]

14
14 Ocean City is a port which handles a large number of shipping containers. Containers are
automatically transferred between ships, storage areas and lorries at the port. The whole system
is operated by robots.
Discuss the benefits and drawbacks of using robots in this type of operation.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
......................................................................................................................................................[8]
© UCLES 2018 0417/12/F/M/18

15
BLANK PAGE
© UCLES 2018 0417/12/F/M/18

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 International
Examinations Copyright Acknowledgements Booklet. This is produced for each series of examinations and is freely available to download at www.cie.org.uk after
the live examination series.
Cambridge International Examinations is part of the Cambridge Assessment Group. Cambridge Assessment is the brand name of University of Cambridge Local
Examinations Syndicate (UCLES), which is itself a department of the University of Cambridge.
© UCLES 2018 0417/12/F/M/18

* 5 1 5 5 9 3 2 1 2 9 *

Paper 1 Theory October/November 2018
2 hours
pages you use.
This document consists of 15 printed pages and 1 blank page.
DC (SR/SW) 150186/3
2
1 There are many types of input device. Complete the following sentences, using the most
appropriate item from the list below.
barcode reader chip reader graphics tablet keyboard microphone
mouse numeric keypad scanner sensor touch pad
(a) A device used to input sound is called a
.............................................................................................................................................. [1]
(b) A device used to enter a four-digit code when paying by debit card in a shop is called a
.............................................................................................................................................. [1]
(c) A pointing device commonly built into a laptop is called a
.............................................................................................................................................. [1]
(d) A device, used by designers and artists, which has a stylus for drawing applications is called a
.............................................................................................................................................. [1]
2 Tick whether the following activities relate to the use of email, electronic fax or both.
email electronic fax both

() () ()
Can be used as a legal document
Allows video attachments to be added to the message
Requires a telephone number
Messages can be sent to a computer
[4]
3 Tick whether the following is a method of validation, verification or proof-reading.
validation verification proof-reading

() () ()
Identifying spelling errors
Using a range check
Typing in data twice
Visually comparing data on screen with the
original source document
[4]
© UCLES 2018 0417/11/O/N/18

3
4 (a) Identify the paragraph formatting shown below
This is a compulsory paper consisting of

multiple choice, short answer
and structured questions. The
questions are set on all
sections of the syllabus
content.
.............................................................................................................................................. [1]
(b) Identify the paragraph formatting used for the second paragraph

multiple choice, short answer and
structured questions.
The questions are set on all
sections of the syllabus
content.
Each individual question is set within
separate contexts of ICT applications in
everyday life.
.............................................................................................................................................. [1]
(c) Identify the alignment used in this paragraph

structured questions. The questions are
set on all sections of the syllabus
content. Each individual question is set
within separate contexts of ICT
applications in everyday life.
.............................................................................................................................................. [1]
(d) Identify the alignment shown below

structured questions. The
questions are set on all sections of the
syllabus content.
.............................................................................................................................................. [1]
© UCLES 2018 0417/11/O/N/18 [Turn over

4
5 A music festival is attended by very large crowds each year. Large amounts of data are collected
by the organisers, who are planning to store it in the cloud.
(a) Give four advantages of storing the data in the cloud rather than using other storage methods.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
4 ................................................................................................................................................
...................................................................................................................................................
[4]
(b) The organisers are worried that there are drawbacks in storing data in the cloud.
Describe three disadvantages of using the cloud to store data rather than other storage
methods.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [3]
© UCLES 2018 0417/11/O/N/18

5
6 A soccer club uses ICT to help analyse its players’ performance in a soccer game. The players use
wearable technology with GPS tracking systems. The data collected from the GPS is analysed by
a computer which then displays the results on the monitor at pitch side.
(a) Describe, in detail, how this system could work.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [4]
(b) The wearable technology includes a number of sensors that continuously monitor the players.
Name two physical variables that could be monitored during the game.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
[2]
(c) After the soccer game the data is printed.
Name a suitable type of printer the soccer club could use and give a reason for your choice.
Printer .......................................................................................................................................
Reason .....................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
[2]

6
7 You have created a spreadsheet to display the Ultra Violet (UV) radiation level in Brazil, Argentina
and France for 2016.
A B C D E
1
2
3 Brazil Argentina France
4 Jan 12 9 1
5 Feb 11 9 1
6 Mar 9 7 3
7 Apr 7 4 4
8 May 5 3 6
9 Jun 5 2 7
10 July 5 2 7
11 Aug 7 4 6
12 Sept 9 5 4
13 Oct 10 7 2
14 Nov 12 9 1
15 Dec 12 10 0
16 Average 8.67
17
The following graph was produced from some of the data.
14
12
10
8
6
4
2
0
Jan Feb Mar Apr May Jun July Aug Sept Oct Nov Dec
(a) Describe how this graph was created.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [4]
© UCLES 2018 0417/11/O/N/18

7
(b) You are going to show the graph to a group of students in a Geography lesson.
Explain three improvements you could make to the graph to help it match the needs of the
audience.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
[3]
(c) Write down the formula that should be entered into cell B16 to calculate the average UV level
for Brazil.
= ................................................................................................................................................
.............................................................................................................................................. [2]

8
(d) The spreadsheet has been updated to show the danger levels of UV radiation in Brazil.
A B C D E F
1
2
Danger
Levels in
3 Brazil Brazil Argentina France
4 Jan 12 Extreme 9 1
5 Feb 11 9 1
6 Mar 9 7 3
7 Apr 7 4 4
8 May 5 3 6
9 Jun 5 2 7
10 July 5 2 7
11 Aug 7 4 6
12 Sept 9 5 4
13 Oct 10 7 2
14 Nov 12 9 1
15 Dec 12 10 0
16 Average 8.67
17
18 UV Index
19 1 Low
20 3 Moderate
21 6 High
22 8 Very High
23 11 Extreme
24
Using the table in cells A19 to B23, write down the formula entered in cell C4 to display the
corresponding danger levels in Brazil. This formula will be replicated down to cell C15.
= ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [5]
(e) The formula that has been written in part (d) needs to be replicated down to cell C15.
Describe how you could display the corresponding data for all the months for Brazil.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [3]
© UCLES 2018 0417/11/O/N/18

9
8 Discuss the advantages and disadvantages of social networking rather than email as a
means of communication.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [8]

10
9 A health authority is planning to centralise its medical booking system. This will allow all medical
bookings such as doctors’ appointments and hospital appointments to be made online.
The health authority is considering whether to implement the system using Pilot Running or Direct
Changeover.
(a) Discuss the advantages and disadvantages of implementing this system using these
methods. Include in your answer the method you think the health authority should use, giving
a reason for your choice.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [7]
© UCLES 2018 0417/11/O/N/18

11
(b) The health authority has implemented the system and it is now in full use. Evaluation now
needs to take place.
For each of the following, identify two questions that could be asked in order to evaluate the
new system.
Efficiency ..................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
Ease of use ...............................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
Appropriateness .......................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
[6]

12
The ambulances used by the health authority are fitted with RFID chips. These are
scanned when the ambulance approaches traffic signals. If the ambulance is on an
emergency call the lights automatically change to green.
(c) Describe, in detail, what happens when the ambulance approaches the traffic signals prior to
the computer instructing the traffic lights to change to green.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [4]
(d) The traffic controller is considering changing to a number plate recognition system on all
traffic lights.
State the advantages and disadvantages of using RFID technology rather than number plate
recognition in this scenario.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [4]
© UCLES 2018 0417/11/O/N/18

13
10 A company is setting up an online shopping website. Transactions using the website need to be
secure.
(a) Explain what is meant by Secure Socket Layer (SSL).
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [2]
(b) Describe the features that you would look for in a browser to indicate it has a secure
connection to a website.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [2]
11 Tick whether the following activities relate to an intranet, the internet or both.
intranet internet both

() () ()
This is a restricted access system.
This system can use email for communication.
This is a public system.
[3]

14
12 Robotic systems are now widely used in the production of cars.
Describe the effects this has had on job roles and working conditions in a car production factory.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [6]
13 Modern supermarkets have automated stock control systems, which use data from the checkouts.
Describe how food items can be ordered by an automated stock control system so they are
delivered before the stock in the supermarket runs out.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [4]
© UCLES 2018 0417/11/O/N/18

15
14 An author is writing a new textbook about ICT. He has used a large number of images in the
document and wishes to send the document as an email attachment to his publisher, but the file is
currently too large.
Describe how he could reduce the size of the document without reducing the number of images.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [4]
15 Web development layers are used when designing web pages. An example of one of the layers is
the presentation layer.
Name the other two web development layers.
1 .......................................................................................................................................................
2 .......................................................................................................................................................
[2]
© UCLES 2018 0417/11/O/N/18

16
BLANK PAGE
© UCLES 2018 0417/11/O/N/18

* 4 2 1 9 8 8 5 9 8 7 *

Paper 1 Theory October/November 2018
2 hours
pages you use.
This document consists of 13 printed pages and 3 blank pages.
DC (SC) 150187/3
2
1 Tick whether the following are examples of applications software or system software.
applications system
software software
(✓) (✓)
Control software
Compiler
Word processing
Device drivers
[2]
2 Complete the following sentences, using the most appropriate technology from the list.
a 3D printer a dot matrix printer a laser printer a light sensor
a magnetic ink character reader a microphone an optical mark reader
a speaker a web cam a wide format printer
(a) A device that is most suited to being used to produce hard copy output in a general office
environment is called
.............................................................................................................................................. [1]
(b) The input device that reads the cheque number from a bank cheque is called
.............................................................................................................................................. [1]
(c) A device that outputs hard copy large architectural drawings is called
.............................................................................................................................................. [1]
(d) A device that outputs sound is called
.............................................................................................................................................. [1]
© UCLES 2018 0417/12/O/N/18

3
3 Pupils working on a science project use the school network to store and retrieve files. They log
onto the network using individual passwords.
(a) Abisha is using his name as his password.
Give two reasons why this is not a good idea.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
[2]
(b) Give two other pieces of advice the teacher should give regarding the management of
passwords.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
[2]
4 A school is setting up a new computerised system to manage many aspects of the school
administration.
(a) Describe how this system can be used to manage student registration and attendance.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [3]
(b) Describe the benefits of using this system.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [2]

4
(c) The data from the registration system is saved in the school administration database.
The head teacher will need to check the attendance records for any student for any semester.
She will type in the Student_ID and the Semester (Autumn, Spring or Summer). After she has
done this the following data will appear on the same screen.
Field name
Student_name
Days_present
Number_of_lates
Number_absences
Parents_phone_number
Tutor_group
Design a suitable screen layout to display one record. It must have appropriate spacing for
each field, navigation aids and a space to type in search data. Do not include examples of
students.
[6]
© UCLES 2018 0417/12/O/N/18

5
A student record from the database is shown below.
Field name Example Data

Student_ID 8543
Semester Spring
Student_name Kannur Rahul
Days_present 180
Number_of_lates 4
Number_absences 6
Parents_phone_number 01244878387
Tutor_group 11ABC
(d) Name an appropriate validation check that could be used for each of the following fields,
based on the data shown in the record.
Field name Validation check

Semester
Number_of_lates
Parents_phone_number
[3]
5 Describe the benefits and drawbacks of using a Graphical User Interface (GUI) rather than a
Command Line Interface (CLI).
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [4]

6
6 A Medical Authority in a large city is planning to centralise its medical booking system. This
will allow patients to make all of their doctors’ appointments, dental appointments and hospital
appointments online.
(a) Discuss the benefits and drawbacks to both the patients and the medical staff of this type of
system.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [8]
(b) The Medical Authority creates many different types of documents including letters and
memos. Each of them is produced using its corporate house style.
Explain why corporate house styles are required.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [3]
© UCLES 2018 0417/12/O/N/18

7
7 A student is setting up a database of information about volcanoes for a Geography project. The
following is part of the database.
Name_of_volcano Country Height State Last_eruption Volcano_type

Usu Japan 731 Active 2001 Stratovolcano
Tor Zawar Pakistan 2237 Dormant 2010 Fissure
Datong China 1882 Extinct 450 Cinder Cone
Changbaishan China 2744 Active 1903 Stratovolcano
Stromboli Italy 926 Active 2016 Stratovolcano
Tengchong China 2865 Dormant 1609 Pyroclastic cone
Wudalianchi China 597 Dormant 1721 Multi-coned
Operators such as AND, OR, NOT, LIKE, >, >=, <, <=, =, < > can be used to search the volcano
database. The search criteria for all the dormant volcanoes with a height of less than 1000 metres
would look like this:
State = “Dormant” AND Height < 1000
Use only the given operators and data to:
(a) write down the search criteria that will produce a list of all the volcanoes that are not extinct in
China that also last erupted before the year 1900.
...................................................................................................................................................
.............................................................................................................................................. [6]
(b) write down the names of the volcanoes that match the requirements of part (a).
...................................................................................................................................................
.............................................................................................................................................. [2]
(c) The data is sorted into ascending order of height.
Write down the name of the volcano which would now be in the first record.
...................................................................................................................................................
.............................................................................................................................................. [1]

8
(d) Drones are remote-controlled flying devices. Data can be collected by drones that fly through
the gas cloud of the volcano. The drones have sensors attached to them which send the data
to a computer. The computer analyses the data.
Discuss the benefits and drawbacks of using this method of measurement.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [7]
(e) Explain why the data collected by the sensors cannot be read directly by the computer.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [2]
© UCLES 2018 0417/12/O/N/18

9
8 Spam emails are a problem for computer systems.
(a) Explain what is meant by a spam email.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [2]
(b) Explain why spam emails need to be prevented.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [2]
(c) Describe the methods which can be used to prevent spam emails.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [4]
9 Describe how a router forwards data packets from one network to another.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [3]

10
10 A local railway company is considering introducing a new system for its passengers using e-tickets
on a smart phone. Before introducing this new system, analysis of the current system is required.
(a) Describe the steps that would be carried out in the analysis of the current system.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [6]
The e-ticket will link to a database containing personal data.
(b) Give two examples of personal data that could be stored.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
[2]
(c) Details of each of the passengers have been entered into the database.
Give one reason why this data was verified on entry.
...................................................................................................................................................
.............................................................................................................................................. [1]
© UCLES 2018 0417/12/O/N/18

11
Proofreading is sometimes thought to be verification.
(d) Explain the difference between verification and proofreading.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [2]
11 .PDF and .RTF are two file formats used for storing documents.
Describe the file formats and explain the differences between them.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [5]

12
12 HotHouse Design is a large design company. It has recently created a new web address for their
design portfolios. The web address is:
https://www.hothouse-design.co.uk/portfolios
(a) Describe the following parts of the web address.
https:// .......................................................................................................................................
...................................................................................................................................................
hothouse-design .......................................................................................................................
...................................................................................................................................................
.uk .............................................................................................................................................
...................................................................................................................................................
/portfolios ..................................................................................................................................
...................................................................................................................................................
[4]
(b) Hyperlinks are widely used in web pages.
Explain what is meant by a hyperlink.
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [2]
13 Spreadsheets use functions, formulae and named ranges.
(a) Describe the term:
Function ....................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
Formula ....................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
[4]
© UCLES 2018 0417/12/O/N/18

13
(b) Explain why a named range is used in a spreadsheet.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [2]
14 Emails are a very popular way of communicating.
Tick four statements, relating to emails that are true.
Tick
(✓)
Emails can only be sent from a computer.
An email can be used to send a message to many

people at the same time.
It always takes a long time for an email to arrive.
All emails must have an attachment.
Attachments may have to be compressed to be

sent via email.
Emails can be used to send legal documents.
Every email has to be printed out.
In order to send an email back to the sender

without retyping the address, reply is used.
Email means extended mail.
Email attachments are always checked for viruses

before they are sent.
[4]
© UCLES 2018 0417/12/O/N/18

14
BLANK PAGE
© UCLES 2018 0417/12/O/N/18

15
BLANK PAGE
© UCLES 2018 0417/12/O/N/18

16
BLANK PAGE
© UCLES 2018 0417/12/O/N/18

Cambridge International General Certificate of Secondary Education

Uploaded by

Copyright:

Available Formats

Cambridge International General Certificate of Secondary Education

Uploaded by

Document Information

Original Title

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

Cambridge International General Certificate of Secondary Education

Uploaded by

Copyright:

Available Formats

Cambridge International Examinations

Cambridge International General Certificate of Secondary Education

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/12

READ THESE INSTRUCTIONS FIRST

Any businesses described in this paper are entirely fictitious.

This document consists of 14 printed pages and 2 blank pages.

Applications A bar code reader A compiler A CPU Hardware

A monitor A printer A scanner System USB

(a) ................................................ software is designed to manage computer hardware. [1]

(b) ................................................ software examples include word processing and spreadsheets.

(c) ................................................ produces output in the form of hard copy. [1]

Optical Magnetic Bar code Chip and

A candidate’s responses for

A label on a can of soup

© UCLES 2018 0417/12/F/M/18

4 CD, DVD and Blu-ray are types of optical storage media.

Stores lower quality audio files

Has the highest storage capacity

The RAM version of this medium is used to

Stores high definition movies

© UCLES 2018 0417/12/F/M/18 [Turn over

5 Describe the following file formats.

(a) .css ...........................................................................................................................................

(b) .htm ...........................................................................................................................................

Part of the flood defence model is shown.

1 Chennai Flood Defence - Adyar River

In the Warning column the model will display:

• ‘Alert’ when the actual depth is above 2.5 m

© UCLES 2018 0417/12/F/M/18

(a) Test data is entered in cell C4.

Test data Type of data Expected Result

Complete the formula that would be used in cell D4.

=IF(C4>2.5, “Alert”, ...................................................................................................................

© UCLES 2018 0417/12/F/M/18 [Turn over

(d) Part of the flood defence model is shown.

1 Chennai Flood Defence - Adyar River

© UCLES 2018 0417/12/F/M/18

7 Tick the three most accurate statements regarding computer hardware.

© UCLES 2018 0417/12/F/M/18 [Turn over

Work to be carried out

© UCLES 2018 0417/12/F/M/18

Mail merged letters will be sent to customers.

Explain what is meant by encryption.

© UCLES 2018 0417/12/F/M/18 [Turn over

(a) Compare and contrast a moderated forum with an un-moderated forum.

Tick the most appropriate method for each of these examples.

Blog Wiki Email

© UCLES 2018 0417/12/F/M/18

Mansa Cricket Club

14th March 2018

(d) The image used in the poster is copyright-free.

Explain why copyright legislation is needed for images.

© UCLES 2018 0417/12/F/M/18 [Turn over

11 There are two types of documentation, user and technical.

User Technical Both

© UCLES 2018 0417/12/F/M/18

Explain why she uses an email group to do this.

© UCLES 2018 0417/12/F/M/18 [Turn over

© UCLES 2018 0417/12/F/M/18