Cambridge International General Certificate of Secondary Education

Cambridge International Examinations
Cambridge International General Certificate of Secondary Education

* 6 0 2 1 8 2 3 5 1 7 *
INFORMATION AND COMMUNICATION TECHNOLOGY 0417/12

Paper 1 February/March 2015
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 on all the work you hand in.
Write in dark blue or black pen.
You may use an HB pencil for any diagrams, graphs or rough working.
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.
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.
For Examiner’s Use
This document consists of 15 printed pages and 1 blank page.
DC (LK/FD) 101312/3
© UCLES 2015 [Turn over
2
1 This diagram shows a computer controlled greenhouse.
/LJKW
&RPSXWHU 0RWRU
6SULQNOHU
+XPLGLW\VHQVRU
7HPSHUDWXUH
VHQVRU 1XPEHUSDG
+HDWHU
/LJKWVHQVRU
(a) Identify three input devices which are shown in the diagram above.
1 ................................................................................................................................................
2 ................................................................................................................................................
3 ................................................................................................................................................
[3]
(b) Identify three output devices which are shown in the diagram above.
1 ................................................................................................................................................
2 ................................................................................................................................................
3 ................................................................................................................................................
[3]
© UCLES 2015 0417/12/F/M/15

3
2 Tick the most appropriate method of storing data for each of the following uses.
Memory Magnetic Blu-ray

Use card Tape Disc
✓ ✓ ✓
Storing photos in a camera
Storing file server backups
Storing high definition movies
Storing large numbers of payroll records
[4]
3 Complete the table by identifying the most appropriate input device for each type of application.
Application Device
Inputting diagrams as they are being drawn

Inputting printed text to a computer to be processed by another
software package
Inputting moving pictures, often pre-recorded, into a computer
Used by a pilot to control a flight simulator
[4]
4 There are a number of different types of area networks.

Tick whether the following statements apply to a WAN, LAN, or a WLAN.
WAN LAN WLAN

✓ ✓ ✓
This type of network usually requires the use of WiFi
Usually is cabled and often housed in a single building
Covers a large area and is often connected using a router
Requires the use of Wireless Access Points (WAPs)
[4]
© UCLES 2015 0417/12/F/M/15 [Turn over

4
5 Complete the sentences using words from the list below.
(a) The device used for switching channels on a

television is called
................................................................
[1]
(b) A method of inputting answers from a

candidate’s exam paper is called
................................................................
[1]
(c) A printer which is suitable for producing large

volumes of high quality printout is called
................................................................
[1]
ROM a remote control RAM
a dot matrix printer a trackerball OMR
a laser printer an inkjet printer
© UCLES 2015 0417/12/F/M/15

5
6 Describe how a microprocessor uses the data from input devices to control an automatic cooker.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
......................................................................................................................................................[6]

6
7 A floor turtle can use the following instructions:
INSTRUCTION MEANING
FORWARD n Move n mm forward
BACKWARD n Move n mm backward
LEFT t Turn left t degrees
RIGHT t Turn right t degrees
PENUP Lift the pen
PENDOWN Lower the pen
REPEAT n Repeat the following instructions n times
END REPEAT Finish the REPEAT loop
NOT TO
SCALE
60° 120°
40 mm 100 mm 50 mm
Start
A student has written the following set of instructions to make the floor turtle draw these shapes.
The turtle is facing up at the start.
1. PENDOWN
2. LEFT 90
3. REPEAT 5
4. FORWARD 50
5. RIGHT 60
6. PENUP
7. PENDOWN
8. RIGHT 120
9. FORWARD 50
10. END REPEAT
Although the first two instructions are correct, this set of instructions would not draw the shapes
exactly as shown. Three instructions have been missed out and two are incorrect.
© UCLES 2015 0417/12/F/M/15

7
(a) Write down the three missing instructions and indicate where they should be positioned in
the list of instructions provided.
1. ...............................................................................................................................................
...................................................................................................................................................
2. ...............................................................................................................................................
...................................................................................................................................................
3. ...............................................................................................................................................
...................................................................................................................................................
[3]
(b) Identify the two incorrect instructions and for each, state the correct instruction to be used.
1. ...............................................................................................................................................
...................................................................................................................................................
2. ...............................................................................................................................................
...................................................................................................................................................
[2]

8
8 (a) Identify five different items of data that are input at an ATM when cash is withdrawn by a
customer or read from the card.
1 ................................................................................................................................................
2 ................................................................................................................................................
3 ................................................................................................................................................
4 ................................................................................................................................................
5 ................................................................................................................................................
[5]
(b) Discuss the advantages and disadvantages of the use of a local ATM to withdraw cash rather
than travelling to a bank.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[6]
© UCLES 2015 0417/12/F/M/15

9
9 WBA is a company that makes little profit. Its newly commissioned ICT system is ready to be
implemented. It needs the new system to be in use as soon as possible.
Describe the advantages and disadvantages of using parallel running compared with direct
changeover as a method of implementing the system. Choose which of these two methods of
implementation WBA should use, giving reasons for your choice.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
......................................................................................................................................................[8]

10
10 Most smart phones can carry out many functions which, until recently, only a computer could
perform.
Explain why computers of all types are still needed.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
......................................................................................................................................................[7]
11 Most computers have backing storage as well as main/internal memory (RAM/ROM).
(a) Explain why backing storage is needed.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[4]
© UCLES 2015 0417/12/F/M/15

11
(b) Describe why main/internal memory is needed.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[4]
12 A headteacher has decided to arrange delivery of hard copy versions of the school magazine as
well as placing it on the school website.
(a) Give two reasons why he has chosen to do this.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
[2]
(b) Give three disadvantages of producing the hard copies.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
[3]

12
13 (a) Using the example of COUNTIF(A2:A10,”<31”), explain how the COUNTIF function works.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[4]
(b) Rupinder has created a spreadsheet showing the following data and formula.
' ( ) *
1DPH 0RQWKVLQHPSOR\PHQW
$YWDU.KROL &2817,)((µ µ
6XUMHHW6LQJK
-DZDKDU1HKUX
6XQLO.DSRRU
-DVYLU6KHUJLOO
,VKLWD'XWWD
1LNKLO%DQHUMHH
$QLWD0HUFKDQW
6DQMLYH.XPDU
(i) Write down the value that would be contained in cell G2.
.......................................................................................................................................[1]
(ii) Rupinder subtracts the value in part (i) from 9 (the number of workers). He thinks this will
tell him the number of workers who have been in employment for more than 33 months.
Explain why his reasoning does not work.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.......................................................................................................................................[2]
© UCLES 2015 0417/12/F/M/15

13
14 The doctors at the Mumbai Clinic have commissioned a knowledge engineer to create an expert
system to help them with their diagnoses of patient illnesses.
(a) Describe how such a system would be created.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[5]
(b) Give two other applications apart from diagnostic systems which make use of expert systems.
1 ................................................................................................................................................
2 ................................................................................................................................................
[2]

14
15 Recaud Inc. stock many CDs. Below is a small selection of CDs stored on their database.
ID Artist_name CD_title Price Year_released Number_of_tracks

number (Rs)
Maa Na
1 Nayan Pancholi 249.00 2012 29
Nayan
Nayan Pancholi,
2 Maa Amba 145.00 2013 7
Gargi Vora
3 Lakshmi Shankar Ecstasy 120.00 2012 2
Anindo and
4 Anindo Chatterjee 230.00 1991 7
His Tabla
5 Jagjit Singh Greatest Hits 255.00 2011 24
(a) Write down the most suitable data type for the following fields.
CD_title ..........................................................................................................
Price (Rs) ..........................................................................................................
Year_released ..........................................................................................................
Number_of_tracks ..........................................................................................................
[4]
(b) Describe the range check which could be carried out on the Price (Rs) field. The maximum
price and the minimum price are shown in the table above.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[2]
© UCLES 2015 0417/12/F/M/15

15
(c) The owner of the shop, Alam, receives requests from customers about the CDs he has in
stock. He makes a note of these requests using comparison and Boolean operators. For
example, a customer might ask for a CD which was released after 2002 and has at least 7
tracks. Alam would write this down as:
Year_released > 2002 AND Number_of_tracks >= 7
(i) Write down a request for a customer who wants a list of all the CDs which were released
before 2007. This list must also contain all the CDs which cost at least 145 rupees.
.......................................................................................................................................[5]
(ii) Write down the ID numbers of those records which would match your criteria in (i).
.......................................................................................................................................[2]
16 Explain what is meant by copyright.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
......................................................................................................................................................[2]
© UCLES 2015 0417/12/F/M/15

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 2015 0417/12/F/M/15

* 7 3 5 1 2 0 3 6 8 0 *

Paper 1 October/November 2015
2 hours
Candidates answer on the Question Paper
No additional materials are required.
Do not use staples, paper clips, glue or correction fluid.
The syllabus is approved for use in England, Wales and Northern Ireland as a Cambridge International Level 1/Level 2 Certificate.
This document consists of 12 printed pages.
DC (AC/SG) 101064/4
2
1 This picture shows a part of a web page.
1 2 3
4 5 6
There are six numbered icons in the picture.
Write down what happens when you click each of the six numbered icons.
icon 1 ................................................................................................................................................
..........................................................................................................................................................
icon 2 ................................................................................................................................................
..........................................................................................................................................................
icon 3 ................................................................................................................................................
..........................................................................................................................................................
icon 4 ................................................................................................................................................
..........................................................................................................................................................
icon 5 ................................................................................................................................................
..........................................................................................................................................................
icon 6 ................................................................................................................................................
..........................................................................................................................................................
[6]
© UCLES 2015 0417/11/O/N/15

3
2 Tick the most appropriate output device for each of the following applications.
Graph Laser Dot matrix

Application plotter printer printer
✓ ✓ ✓
Rapid, high quality and high volumes of output
CAD, where large printouts are required such as A0
Industrial environments such as car repair companies
Printing on multipart forms

[4]
3 Complete the table by identifying the most appropriate storage method for each type of application.
Application Storage method
Theatre booking systems
Storing photographs in a camera for printing at a later time

The most portable device used to transport data from
computer to computer
A disc used to sell music albums without video
[4]
4 Tick whether the following are uses of modelling, control or measurement.
Modelling Control Measurement

Use
✓ ✓ ✓
The maintaining of growing conditions in a greenhouse
Simulating car driving
Monitoring the environment
Using what ifs
[4]
© UCLES 2015 0417/11/O/N/15 [Turn over

4
5 Complete each sentence using words from the following list.
ROM a bar code reader RAM
magnetic tape a joystick OCR
a chip reader MICR
(a) The input device used in flight simulation is
........................................................... [1]
(b) The type of memory used to store the work that the user is currently working on is
........................................................... [1]
(c) A medium used to backup data is
........................................................... [1]
6 A student wishes to use a floor turtle to draw this shape. All lines are of different lengths.
Give three different instructions other than PENUP and PENDOWN which the turtle graphics
software could use in order to draw the shape. For each one, explain the meaning of the instruction.
Instruction 1 .....................................................................................................................................
Meaning ...........................................................................................................................................
..........................................................................................................................................................
Instruction 2 .....................................................................................................................................
Meaning ...........................................................................................................................................
..........................................................................................................................................................
Instruction 3 .....................................................................................................................................
Meaning ...........................................................................................................................................
..........................................................................................................................................................
[6]
© UCLES 2015 0417/11/O/N/15

5
7 Students are investigating the behaviour of a colourless liquid in a beaker. As the colourless liquid
heats up, it becomes cloudy.
(a) Name two sensors that would be connected to a computer in such an experiment.
1 ................................................................................................................................................
2 ................................................................................................................................................
[2]
(b) Describe how the student would set up the equipment in the experiment and how the computer
would monitor and present the change in readings produced by the experiment.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [5]

6
8 Describe each of the following types of network.
LAN ..................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
WAN ..................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
WLAN ...............................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
[6]
9 Tick three benefits to workers of the introduction of robots into car manufacture.
Once bought robots do not have to be paid
They have to do less hazardous jobs
They don’t need to lift heavy loads
They can become deskilled
It can lead to unemployment
They work in a cleaner/healthier working environment
They can work whenever they want
They get a massive pay rise

[3]
© UCLES 2015 0417/11/O/N/15

7
10 A bank customer wishes to withdraw cash from an ATM.
Describe the computer processing which takes place in the ATM device itself.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [7]
11 Describe what is meant by a microblog.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [3]

8
12 The manager of a computer shop uses a database to store data about the computers he sells.
This is part of the database.
Makers_name Computer_ type Processor_type RAM (Gb) Hard disk (Tb)
Never-never Laptop G4000 4 0.5
Johnsang PC L5000 8 1.0
Rany PC E3000 6 1.0
Hello-John PC F3500 8 2.0
Never-never PC A1000 4 1.0
Johnsang Laptop C2000 4 0.5
Hello-John Laptop D2500 6 1.0
Rany Laptop B1500 6 0.5
(a) Write down the number of records shown in this part of the database.
.............................................................................................................................................. [1]
(b) Write down the number of fields shown in this part of the database.
.............................................................................................................................................. [1]
(c) The records shown are to be sorted in ascending order of Makers_name then ascending
order of Processor_type.
Give the Processor_type of the last record in the database after it has been sorted.
.............................................................................................................................................. [1]
(d) Give the field that could be amended to contain Boolean data.
.............................................................................................................................................. [1]
(e) Name and describe the most appropriate validation check other than a length check which
would be carried out on the Processor_type field.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [3]
© UCLES 2015 0417/11/O/N/15

9
(f) Data in RAM is accessed more quickly than from a fixed hard disk.
Give two reasons why fixed hard disks are still necessary.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
[2]
13 A company has decided to introduce a new computer system. It has employed a systems analyst
to oversee this. Her first task is to research the current system.
(a) Identify three methods of carrying out this research other than by observation. For each
method, give an advantage compared to the other methods.
Method 1 ...................................................................................................................................
Advantage .................................................................................................................................
...................................................................................................................................................
Method 2 ...................................................................................................................................
Advantage .................................................................................................................................
...................................................................................................................................................
Method 3 ...................................................................................................................................
Advantage .................................................................................................................................
...................................................................................................................................................
[6]
(b) The new system will be designed after the current system is analysed.
Identify three items which will be part of the design.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
[3]

10
(c) Once the system is implemented, the systems analyst will provide documentation for the new
system.
Explain why two types of documentation are needed.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [5]
14 Smart phones are used to send and receive emails with and without attachments.
Describe four other ways in which emails can be managed on a smart phone.
1 .......................................................................................................................................................
..........................................................................................................................................................
2 .......................................................................................................................................................
..........................................................................................................................................................
3 .......................................................................................................................................................
..........................................................................................................................................................
4 .......................................................................................................................................................
..........................................................................................................................................................
[4]
© UCLES 2015 0417/11/O/N/15

11
15 Identify three network devices, other than a router or modem, which are used to connect computers
together in a network. For each one, describe how it uses the data it receives.
1 .......................................................................................................................................................
Use ...................................................................................................................................................
..........................................................................................................................................................
2 .......................................................................................................................................................
Use ...................................................................................................................................................
..........................................................................................................................................................
3 .......................................................................................................................................................
Use ...................................................................................................................................................
..........................................................................................................................................................
[6]
16 Discuss the advantages and disadvantages to a teacher of using a tablet computer instead of
another type of computer.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [6]

12
17 Describe the characteristics and uses of different types of DVD.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [8]
© UCLES 2015 0417/11/O/N/15

* 4 5 9 4 1 0 0 7 6 8 *

2 hours
This document consists of 13 printed pages and 3 blank pages.
DC (ST/FD) 101066/3
2
1 These printouts show a document before and after it was finalised.
Write down six editing techniques which have been used on the image and the text.
This is a flower pot with two

flowers. One is growing
Printout before
Printout after
This is a flower pot with two flowers. One
is growing straight up and the other is
growing at an angle.
straight up and the other is

growing at an angle.
1 ........................................................................................................................................................
2 ........................................................................................................................................................
3 ........................................................................................................................................................
4 ........................................................................................................................................................
5 ........................................................................................................................................................
6 ........................................................................................................................................................
[6]
2 For each use, tick the most appropriate type of application software.
Modelling Database Word processing

Use
✓ ✓ ✓
Writing a letter
Flight simulation
Storing student records in a school
Producing a business card

[4]
© UCLES 2015 0417/12/O/N/15

3
3 Tick the type of computer which would be most appropriate for each use of ICT.
Mainframe Laptop Desktop

Use
✓ ✓ ✓
Entering data from a Biology survey while out of

school
Massive transactions which need the use of many

CPUs
Students who need to transport their computer

from home to use in school
Personal use with better performance at lower cost
[4]
4 Tick the most appropriate method of implementing a new system for each company.
Parallel Pilot Direct

Company running running changeover
✓ ✓ ✓
A company with several branches wishes to test

the new system in one branch only.
A small company that can only afford to spend a

small amount of money on implementing the new
system.
If the whole system fails, the company wishes to

return to the original existing system.
A company that wants the quickest method of

implementation.
[4]

4
5 There are a number of methods of direct data entry.
Complete each sentence using the most appropriate words from the following list.
a bar code reader a touch pad OCR
a magnetic stripe reader a trackerball a graphics tablet
a touch screen a PIN pad
(a) The inbuilt device which moves the cursor when using a laptop is called
............................................................[1]
(b) The device used for selecting an icon so a bar code label can be printed in a supermarket is
called
............................................................[1]
(c) The device used for controlling a pointer on a screen when the user has limited motor skills is
called
............................................................[1]
© UCLES 2015 0417/12/O/N/15

5
6 A student wishes to use a floor turtle to draw this regular shape.
The pen is already lowered and does not need to be lifted.

This turtle can only move in one direction and turn one way.
Give three instructions which the turtle graphics software could use to draw the shape. For each
one, explain the meaning of the instruction.
Instruction 1 ......................................................................................................................................
Meaning ............................................................................................................................................
..........................................................................................................................................................
Instruction 2 ......................................................................................................................................
Meaning ............................................................................................................................................
..........................................................................................................................................................
Instruction 3 ......................................................................................................................................
Meaning ............................................................................................................................................
..........................................................................................................................................................
[6]

6
7 Scientists want to find the level of pollution in a river running past a chemical factory. They will use
sensors connected to a computer to do this.
(a) Name three sensors that the scientists would place in the river.
1 ................................................................................................................................................
2 ................................................................................................................................................
3 ................................................................................................................................................
[3]
(b) Explain why it is so important to carefully consider the position of sensors placed in the river.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[2]
(c) Describe how the computer would monitor the level of pollution in the river.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[5]
© UCLES 2015 0417/12/O/N/15

7
8 A school has introduced a system so that parents of its students can access data about their
children.
(a) Give three reasons why the school has introduced this system.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
[3]
(b) In order to access this data, parents will need to log on to the school’s website.
Describe the purpose of the following two items of data they will need to enter.
User id .......................................................................................................................................
...................................................................................................................................................
Password ...................................................................................................................................
...................................................................................................................................................
[2]
9 Describe four items which can be provided by an ISP.
1 .......................................................................................................................................................
..........................................................................................................................................................
2 .......................................................................................................................................................
..........................................................................................................................................................
3 .......................................................................................................................................................
..........................................................................................................................................................
4 .......................................................................................................................................................
..........................................................................................................................................................
[4]

8
10 A video shop owner uses a spreadsheet to calculate his costs.
This is part of the spreadsheet.
A B C D
1 Book title Number in stock Cost price Total cost
2 The Wolf Of Wall Street 4 $18 $72
3 Thinking Fast And Slow 5 $17 $85
4 Be Careful What You Wish For 8 $15 $120
5 The Fell Sword 4 $20 $80
6 Metro 2034 2 $15 $30
8 Overall cost $387
(a) Give the cell reference of the cell that contains $20.
...............................................................................................................................................[1]
(b) Give the number of rows shown in the spreadsheet.
...............................................................................................................................................[1]
(c) Write down the formula which should go in cell D2.
...............................................................................................................................................[1]
(d) Write down the formula which should go in cell D8. Make the most efficient use of a function.
...............................................................................................................................................[2]
(e) Explain why financial models are often used to predict future profitability.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[3]
© UCLES 2015 0417/12/O/N/15

9
11 Explain why encryption is needed when transmitting data.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
......................................................................................................................................................[3]
12 Many database software packages have a report generation feature.
The following is part of a video hire shop database showing films available in Blu-ray format.
Film_name Director Price ($) Regions Length (min)
Rush Ron Howard 12.99 A 122
Last Vegas Jon Turtletaub 17.72 B 105
Captain Phillips Paul Greengrass 14.99 Free 134
Saving Mr Banks John Lee Hancock 15.00 C 125
(a) Each of the following fields contains data that is numeric. Give a more precise data type for
each of these fields.
Price .........................................................................................................................................
Length .......................................................................................................................................
[2]
(b) Blu-ray discs have one of three region codes or are region-free.
Describe how the field Regions could be set up to reduce the possibility of inaccurate data
entry.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[2]

10
(c) Describe, in detail, how you would create a formatted report which does not show regions
and only shows films which are longer than 110 minutes.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[6]
13 (a) Tick three components of an expert system.
Word processor
Spreadsheet
Rules base
Search engine
Inference engine
Control software
Knowledge base
Presentation software
[3]
(b) Give three examples of applications which use expert systems other than diagnosis systems.
1 ................................................................................................................................................
2 ................................................................................................................................................
3 ................................................................................................................................................
[3]
© UCLES 2015 0417/12/O/N/15

11
14 A large company has asked a systems analyst to research the current system.
(a) Describe how this will take place.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[4]
(b) Describe what information will be identified as a result of this research.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...............................................................................................................................................[4]
15 There are many safety issues associated with the use of computers.
Describe three of these issues.
1 .......................................................................................................................................................
..........................................................................................................................................................
2 .......................................................................................................................................................
..........................................................................................................................................................
3 .......................................................................................................................................................
..........................................................................................................................................................
[3]

12
16 Ajit has been set homework by her Geography teacher. She has the choice of using her text book
or the internet to find the necessary information.
Discuss the advantages and disadvantages to Ajit using the text book rather than the internet.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
......................................................................................................................................................[7]
17 Give three reasons why some companies have intranets.
1 .......................................................................................................................................................
..........................................................................................................................................................
2 .......................................................................................................................................................
..........................................................................................................................................................
3 .......................................................................................................................................................
..........................................................................................................................................................
[3]
© UCLES 2015 0417/12/O/N/15

13
18 Give three reasons why files are backed up.
1 .......................................................................................................................................................
..........................................................................................................................................................
2 .......................................................................................................................................................
..........................................................................................................................................................
3 .......................................................................................................................................................
..........................................................................................................................................................
[3]
19 Give three specific examples of work that are carried out by a robot in the car industry.
1 .......................................................................................................................................................
..........................................................................................................................................................
2 .......................................................................................................................................................
..........................................................................................................................................................
3 .......................................................................................................................................................
..........................................................................................................................................................
[3]
© UCLES 2015 0417/12/O/N/15

14
BLANK PAGE
© UCLES 2015 0417/12/O/N/15

15
BLANK PAGE
© UCLES 2015 0417/12/O/N/15

16
BLANK PAGE
© UCLES 2015 0417/12/O/N/15

* 9 9 8 2 2 2 3 4 2 0 *

2 hours
This document consists of 12 printed pages.
DC (LK) 101049/3
2
1 Many word processing packages have a number of formatting features.
Write down six of these features which have been used in the following passage.
The boiling point of water, H2O, at normal atmospheric pressure is 100° C. The two
elements which make up water are Hydrogen and Oxygen. Water covers seventy percent of
the surface of the earth. In different parts of the world, water can be found in liquid, solid, and
gaseous forms. In its liquid form it is tasteless and odourless and more or less colourless. Many
substances dissolve in water and because of this it is commonly referred to as the universal
solvent.
1 .......................................................................................................................................................
2 .......................................................................................................................................................
3 .......................................................................................................................................................
4 .......................................................................................................................................................
5 .......................................................................................................................................................
6 .......................................................................................................................................................
[6]
2 Tick the most appropriate method of inputting data for the following uses.
Web cam Keyboard Scanner

Use
  
Applications where text has to be created rather than
copied
Inputting hard copy documents directly into a computer
Inputting moving pictures from a fixed position into a

computer
Entering text directly into a word processing document
[4]
© UCLES 2015 0417/13/O/N/15

3
3 Explain what is meant by the following terms, giving examples of their use.
MICR ................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
OMR ..................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [4]
4 When creating a database, it is important to assign the correct data type to each field.
Tick the most appropriate data type for each of the following items of data.
Text
Numeric Date
(alphanumeric)
 

A student’s name
How many times a student has been late to a lesson
The amount of money it costs to travel to school
When the end of term is
[4]
5 Complete each sentence using the most appropriate words from the following list.
a word processor a control program a spreadsheet
an inference engine a web authoring package a search engine
a measuring program a DTP package
(a) The software used to find information on the internet is ............................................................

[1]
(b) The software which is a component of an expert system is .....................................................

[1]
(c) The type of software used to create financial models is ...........................................................

[1]

4
6 Explain, using examples, what is meant by authentication techniques.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [3]
7 Give three reasons why it would not be sensible to use batch processing in an online theatre
booking system.
1 ........................................................................................................................................................
..........................................................................................................................................................
2 ........................................................................................................................................................
..........................................................................................................................................................
3 ........................................................................................................................................................
..........................................................................................................................................................
[3]
© UCLES 2015 0417/13/O/N/15

5
8 A floor turtle can use a number of instructions.
For each of the following instructions give the correct meaning.
FORWARD n .....................................................................................................................................
..........................................................................................................................................................
REPEAT n .........................................................................................................................................
..........................................................................................................................................................
LEFT t ...............................................................................................................................................
..........................................................................................................................................................
RIGHT t .............................................................................................................................................
..........................................................................................................................................................
PENUP ..............................................................................................................................................
..........................................................................................................................................................
PENDOWN .......................................................................................................................................
..........................................................................................................................................................
[6]

6
9 A chemistry student wants to measure how quickly a liquid cools after it has boiled. She will use a
sensor connected to a computer to do this.
(a) Identify two variables which will need to be recorded.
1 .................................................................................................................................................
2 .................................................................................................................................................
[2]
(b) Describe how the computer would process the data into a form the student could use to
analyse the results.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
[5]
10 Describe the differences in use between WiFi and Bluetooth.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
[4]
© UCLES 2015 0417/13/O/N/15

7
11 Compare and contrast the use of optical discs and the use of fixed magnetic disks to store data.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [6]
12 Most supermarkets now operate online shopping.
Discuss the advantages and disadvantages to supermarkets of this development.
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..................................................................................................................................................... [6]

8
13 A company is going to introduce a new computer system.

The company employs drivers to deliver orders and they are rarely in the office for more than a few
minutes. The office secretaries process the orders and dislike being interrupted. A manager is in
charge of the current system and appointments can be made to see her.
(a) Name three methods of researching the current system other than from examining documents.
Identify the workers that each method would be most suitable for. Each method will be used
with a different type of worker.
1 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
[6]
(b) After the current system has been researched, the new system will be designed. This means
that the file structure will be designed.
Identify three items of a flat file structure which will form part of this activity.
1 ................................................................................................................................................
2 ................................................................................................................................................
3 ................................................................................................................................................
[3]
© UCLES 2015 0417/13/O/N/15

9
14 A student types in the formula =IF(A1>12,"strong",IF(A1>6,"medium","weak")) into a spreadsheet.
(a) Explain, using the terms ‘condition’, ‘true’, ‘false’, how this nested IF function works.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [4]
(b) Another student wishes to reverse the formula to get the same result.
She types in the formula IF(A1<6,"weak",IF(A1<12,"medium","strong)
Identify four errors she has made.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
4 ................................................................................................................................................
...................................................................................................................................................
[4]

10
(c) Financial models and scientific experiments are examples of different types of modelling
applications.
Give three other examples of types of modelling.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
[3]
15 Students at a school visit a variety of websites on the internet to get information about a topic.
(a) Describe four features of a website that will prove that the information found on it is reliable.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
4 ................................................................................................................................................
...................................................................................................................................................
[4]
(b) Describe three other features of a website that may indicate that the information found on it is
not likely to be reliable.
1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
[3]
© UCLES 2015 0417/13/O/N/15

11
(c) In order to make reliable information available to all students, schools often put the information
on their intranet.
Describe what is meant by an intranet.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................. [4]
16 Give four benefits of using social networking sites.
1 .......................................................................................................................................................
..........................................................................................................................................................
2 .......................................................................................................................................................
..........................................................................................................................................................
3 .......................................................................................................................................................
..........................................................................................................................................................
4 .......................................................................................................................................................
..........................................................................................................................................................
[4]

12
17 There are many health issues associated with the use of computers.
Name three of these health issues and for each one describe, in detail, a different cause.
Health issue 1 ..................................................................................................................................
Cause ...............................................................................................................................................
..........................................................................................................................................................
Health issue 2 ..................................................................................................................................
Cause ...............................................................................................................................................
..........................................................................................................................................................
Health issue 3 ..................................................................................................................................
Cause ...............................................................................................................................................
..........................................................................................................................................................
[6]
18 Tick three features of wikis.
A wiki is an example of a spreadsheet.
A wiki is quicker to search than a database.
Wiki entries are in chronological order.
A wiki can have several contributors.
Wikis are always a reliable source of information.
Wikis can be edited using a web browser.
Anybody can create a wiki.
Wikis never contain hyperlinks.

[3]
© UCLES 2015 0417/13/O/N/15

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

Answer all questions.

For Examiner’s Use

This document consists of 15 printed pages and 1 blank page.

1 This diagram shows a computer controlled greenhouse.

© UCLES 2015 0417/12/F/M/15

Memory Magnetic Blu-ray

Storing file server backups

Storing high definition movies

Storing large numbers of payroll records

Inputting diagrams as they are being drawn

Used by a pilot to control a flight simulator

4 There are a number of different types of area networks.

WAN LAN WLAN

Usually is cabled and often housed in a single building

Covers a large area and is often connected using a router

Requires the use of Wireless Access Points (WAPs)

© UCLES 2015 0417/12/F/M/15 [Turn over

5 Complete the sentences using words from the list below.

(a) The device used for switching channels on a

(b) A method of inputting answers from a

(c) A printer which is suitable for producing large

ROM a remote control RAM

a dot matrix printer a trackerball OMR

a laser printer an inkjet printer

© UCLES 2015 0417/12/F/M/15

© UCLES 2015 0417/12/F/M/15 [Turn over

7 A floor turtle can use the following instructions:

BACKWARD n Move n mm backward

LEFT t Turn left t degrees

RIGHT t Turn right t degrees

PENUP Lift the pen

PENDOWN Lower the pen

REPEAT n Repeat the following instructions n times

END REPEAT Finish the REPEAT loop

10. END REPEAT

© UCLES 2015 0417/12/F/M/15

© UCLES 2015 0417/12/F/M/15 [Turn over

© UCLES 2015 0417/12/F/M/15

© UCLES 2015 0417/12/F/M/15 [Turn over

Explain why computers of all types are still needed.

11 Most computers have backing storage as well as main/internal memory (RAM/ROM).

(a) Explain why backing storage is needed.

© UCLES 2015 0417/12/F/M/15

(b) Describe why main/internal memory is needed.

(a) Give two reasons why he has chosen to do this.

(b) Give three disadvantages of producing the hard copies.

© UCLES 2015 0417/12/F/M/15 [Turn over

© UCLES 2015 0417/12/F/M/15

(a) Describe how such a system would be created.

© UCLES 2015 0417/12/F/M/15 [Turn over

ID Artist_name CD_title Price Year_released Number_of_tracks

Price (Rs) ..........................................................................................................

© UCLES 2015 0417/12/F/M/15

Year_released > 2002 AND Number_of_tracks >= 7

16 Explain what is meant by copyright.