Complete A practical

ICT
approach for
the updated
syllabus

for Cambridge IGCSE ®

Second edition

Teacher Resource Pack

Stephen Doyle

Oxford excellence for Cambridge IGCSE®

00 Contents
What's on the CD? 4 TOPIC 10 Communication
Worksheet 10.1: Can you work out what the word is? 81
TOPI C S Worksheet 10.2: Creating an evaluation checklist for
TOPIC 1 Types and components of computer systems web sites 83
Worksheet 1.1: What is being shown here? 6 Worksheet 10.3 Social networking and web log terms 85
Worksheet 1.2: Hardware or software? 9 Activity 10.1: Practising sending email 87
Activity 1.1: Wireless internet 10 Activity 9.2: Explaining the features of email 88
Answers 11 Answers 90
TOPIC 2 Input and output devices TOPIC 11 File management
Worksheet 2.1: Input and output crossword 16 Worksheet 11.1 File formats 92
Worksheet 2.2: Can you name the input or output Answers 93
devices shown? 18
TOPIC 11 Data manipulation
Answers 21
Answers 82
TOPIC 3 Storage devices and media TOPIC 12 Images
Worksheet 3.1: The differences between the two types of Worksheet 12.1 Understanding terms used when
memory ROM and RAM 26
manipulating images 94
Worksheet 3.2: Can you name the storage device/media Answers 95
shown? 27
Answers 29 TOPIC 13 Layout
Worksheet 13.1 Understanding layout 96
TOPIC 4 Networks and the effects of using them Answers 97
Worksheet 4.1: Networks wordsearch 31
Answers 33 TOPIC 14 Styles
Worksheet 14.1 Looking at house style 98
TOPIC 5 The effects of using ICT Answers 99
Worksheet 5.1: Can you work out what the word is? 40
Worksheet 5.2: The way ICT has changed TOPIC 15 Proofing
or even eliminated some jobs 42 Answers 100
Activity 5.1 Creating an interactive presentation on TOPIC 16 Graphs and charts
health and safety issues at work 43 Activity 16.1 Producing pie charts 101
Answers 44
TOPIC 17 Document production
TOPIC 6 ICT applications Worksheet 17.1 Document production 102
Worksheet 6.1 Applications crossword 48 Answers 103
Activity 6.1: Producing a spreadsheet model to
TOPIC 18 Data manipulation
simulate depreciation 50
Answers 104
Activity 6.2: Making the model more useful 52
Worksheet 6.2: Computers in control? 53 TOPIC 19 Presentations
Worksheet 6.3: Describing how control is used 54 Worksheet 19.1 106
Activity 6.3: Researching the use of robots 55 Answers 107
Answers 56 TOPIC 20 Data analysis
TOPIC 7 The systems life cycle Worksheet 20.1 108
Worksheet 7.1: Spreadsheet cell validation checks 65 Answers 110
Answers 68 TOPIC 21 Website authoring
TOPIC 8 Safety and security Worksheet 21.1 HTML 111
Worksheet 8.1 Can you work out what the word is? 72 Answers 113
Answers 74
Ca Se ST u d I e S 114
TOPIC 9 Audience
Activity 9.1 The legal, moral and ethical implications of e xa m Su PPOrT 127
software policy 79 r e v I SI On m aT e r I a l 166
Answers 80
 TO P I C 1 TYPES AN D COMP ON EN TS OF COMPUTER S YSTEMS

Types and components of

00
1 computer systems
Worksheet 1.1
What is being shown here?
Here are some pieces of computer hardware or types of computer. You have to decide
what name best describes the picture. To make things a little easier, here is a list of
devices/types of computer to choose from.
scanner laptop computer mouse sound card
desktop computer internal memory fixed hard disk motherboard
processor tablet

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

6 Complete ICt for CambrIdge IgCSe® teaCHer reSoUrCe paCk © Oxford University Press 2016
 00 TOPIC
TO PIC 1 TYPES A N D COMPONENTS TITLE GOES
OF COMPUTER HERE
S YSTEMS
Worksheet 1.1 (continued)

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

© Oxford University Press 2016 Complete ICt for CambrIdge IgCSe® teaCHer reSoUrCe paCk 7
 TO P I C 1 TYPES AN D COMP ON EN TS OF COMPUTER S YSTEMS
Worksheet 1.1 (continued)

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

10

Name:
——————————————————————————————————————————————————————————————————————————————————————————————

8 Complete ICt for CambrIdge IgCSe® teaCHer reSoUrCe paCk © Oxford University Press 2016
 TO PIC 1 TYPES A N D COMPONENTS OF COMPUTER S YSTEMS

Worksheet 1.2
Hardware or software?
Here are some items that are either hardware or software. You have to decide which
they are by putting a tick in the appropriate column.

Name of item Hardware Software

1 Processor

2 Operating system

3 Fixed hard disk

4 Memory chips (RAM and ROM)

5 Keyboard

6 Mouse

7 Word-processor

8 Search engine

9 Speakers

10 Microphone

11 DVD drive

12 Blank DVD

13 Database

14 Spreadsheet

15 Barcode reader

16 Printer

17 Web browser

18 Removable hard disk

19 Wireless router

20 Digital camera

© Oxford University Press 2016 Complete ICt for CambrIdge IgCSe® teaCHer reSoUrCe paCk 9
 TO P I C 1 TYPES AN D COMP ON EN TS OF COMPUTER S YSTEMS

Activity 1.1
Wireless internet
Many people who use the internet do not want to be restricted by cables. They want to
be able to access the internet wirelessly wherever they are.
Imagine that you are employed in a job where you have a very busy schedule and have
to do a lot of travelling.
For this activity you have to produce an advert which advertises a phone or notebook
computer which can be used for internet access. Your emphasis in your advert must
be those features that will make the device as portable as possible and give very fast
access to the internet.
Make sure that your advert targets the busy person who is always on the move.
You are free to choose whatever software you think would be best for this task.

10 Complete ICt for CambrIdge IgCSe® teaCHer reSoUrCe paCk © Oxford University Press 2016
 TO PIC 1 TYPES A N D COMPONENTS OF COMPUTER S YSTEMS

Topic 1 answers b One mark for each correctly placed item.

Internal hardware device external hardware device
Questions A Motherboard Mouse
Processor Keyboard
Student book page 3
ROM Printer
1 a One mark for:
Video card
Hardware – The physical parts of a computer that you can Internal hard disk drive
actually touch.
RAM
One mark for: Sound card
Software – The sets of instructions that you cannot touch 4 a One mark each for two reasons such as:
that tell the hardware how to operate.
To provide a user interface (i.e. a way for the user to
b One mark for two examples of hardware such as: interact with the computer)
Keyboard To control the system resources and the processing
Mouse To handle inputs and outputs
Hard disk drive To handle the storage of data
CD/DVD drive To maximise the use of computer memory
Internal memory (RAM and ROM) To handle interrupts and decide what action to take
Screen b i One mark for software.
Etc. ii Used to supply the instructions to the computer to
One mark for two examples of software such as: instruct it how to use the attached printer.
Systems software c One mark each for two of the following:
Applications software File maintenance tasks
Operating system software Compressing files
Device driver software Installing and uninstalling software
Word-processing software Compacting files on the hard disk
Database software Finding and removing viruses
Spreadsheet software Burning CDs and DVDs
Photo-editing software
Etc. Questions B
2 One mark for each answer. Student book page 4

a Operating system 1 a Input devices

b Utilities b Processor and internal memory devices

c Operating system C Output devices

d Operating system d Secondary storage devices

e Utilities 2 a i Read Only Memory

f Device drivers ii Random Access Memory

3 a One mark for each definition: b Contents are lost when the computer is turned off ram

Internal hardware is hardware situated inside the Contents are not lost when the computer is turned off rom
computer casing. Stores the programs needed to start up the computer rom
External hardware is hardware situated outside the Stores application programs and data when they are
computer casing. being used ram

© Oxford University Press 2016 Complete ICt for CambrIdge IgCSe® teaCHer reSoUrCe paCk 11
 TO P I C 1 TYPES AN D COMP ON EN TS OF COMPUTER S YSTEMS

3 a One mark each for two of the following: 3 a One mark each for two user interfaces:
Applications will run faster Graphical user interface
More applications can be opened and run at the same time Command line interface
Users are able to move more quickly between applications Touch screen interface
b Two marks for a correct use for ROM and two marks each Voice driven interface
for a correct use for RAM. b benefits of a gUI:
ROM: Stores the boot program (1) which is the program Considered to be more user friendly compared to a CLI
needed to start up the computer (1). No commands to remember
RAM: Stores the systems software/operating system/ Easier to find programs that are running by opening
applications software (1) along with the user’s files (1). separate windows
Easier to pass data from one program to another
Questions C drawbacks of a gUI:
Student book page 6 Can be faster to type in commands rather than move the
mouse and click
1 a Any three from the following (one mark each):
Needs a lot of memory for its operation
Windows
GUI needs a lot of hard disk space for its storage
Icons Needs a powerful processor to use it
Menus/Pull-down menus benefits of a ClI:
Pointers CLI can be faster to use as you only have to type in a
Online help/Office assistants short command
b One mark for one of the following: Does not need as much memory compared to a GUI
Does not need as much hard disk space when being used
Menu driven interface
You do not need the latest processor to run a CLI
Command line interface
drawbacks of a ClI:
Voice driven interface Hard to learn as there are lots of commands to remember
Touch screen interface Commands have a certain syntax which must be used so
2 a Two marks for two points similar to the following: you need to be very precise
Programs used to control the hardware directly benefits of a touch screen interface:
Manages the system resources Very little training is needed to use the software
You do not need a flat surface on which to move a mouse
b One mark each for three of the following:
drawbacks of a touch screen interface:
Handles the inputs and outputs – controls the operation
Dirty screens can make the screen hard to read
of input and output devices such as the keyboard, mouse,
printer, screen, etc. If lots of people use them then they can pass on germs
benefits of a voice driven interface:
Recognises hardware attached to the computer –
recognises that a device such as a pen drive has been Safer to give verbal commands such as when driving
attached and loads the software needed to control it. Can issue commands in the same way humans
communicate with each other
Supervises the running of other programs – it provides a
way for the applications software such as word-processing drawbacks of a voice driven interface:
software to work with the hardware. Background noise can confuse the software
Handles the storage of data – decides where to store data Commands have to be spoken precisely
in the memory and allows the user to create folders and
sub-folders, etc. Revision questions
Maximises the use of computer memory – decides where Student book page 10
in memory the program instructions are placed. 1 One mark each for:
Handles the interrupts and decides what action to take – Hardware – the physical components of a computer system
a paper jam will stop the printer and alert the user with a (e.g. keyboard, mouse, printer, etc.)
message on the screen. Software – the set of instructions/programs that allows the
hardware to do a useful task

12 Complete ICt for CambrIdge IgCSe® teaCHer reSoUrCe paCk © Oxford University Press 2016
 TO PIC 1 TYPES A N D COMPONENTS OF COMPUTER S YSTEMS

2 a One mark for: 6 a One mark for a difference such as:

Processes the raw data by performing searching, sorting, Main memory is internal hardware whereas backing
calculating and decision making storage is external hardware
b One mark for: Backing storage is removable
Stores program instructions and data that are needed Main memory usually offers faster retrieval compared to
immediately by the processor backing storage
c One mark for: b One mark for an answer similar to the following:
Used to hold programs and data that are not needed Data currently being processed
instantly by the computer Current program instructions
Used for long-term storage of programs and data
Programs and data (i.e. stored on hard disk)
Used for backup copies in case the original data is
c One mark for an answer similar to the following:
damaged or lost
Data and programs for later use
3 a One mark each for two input devices such as:
Backups which need to be stored off-site
Keyboard
Mouse Programs which need to be installed
Touch screen 7 a One mark for:
Microphone An internal hardware device is situated within the
Barcode reader computer casing whereas an external hardware device
is outside
Etc.
b One mark each for two examples of internal hardware
b One mark for two output devices such as:
devices such as:
Printer
Motherboard
Screen/Monitor
RAM
Loudspeaker
ROM
Etc.
Video card
c One mark for two backing storage devices such as:
Sound card
Magnetic hard drive
Network interface card
Flash memory/Pen drive
Internal hard disk drive
CD drive
DVD drive One mark each for two examples of external hardware
devices such as:
Etc.
Monitors/Screens
4 a One mark for each point to a maximum of three marks:
Keyboard
Desktop much larger in size or laptop much smaller
Mouse/Mice
Desktop designed to be used in one place or laptop is
portable External hard disk drive
Desktop has full-sized screen/keyboard Memory stick
Laptop is much lighter compared to a desktop Scanner
Laptop is sometimes operated by battery away from the Speaker
mains power supply Microphone
b One mark for each point to a maximum of two marks: 8 a One mark each for Random Access Memory and Read
Smaller than a laptop Only Memory.
Usually less memory b One mark for each difference:
Mainly aimed at accessing the internet ROM – the contents remain when the power is removed
Does not usually have a CD/DVD drive to reduce weight RAM – the contents are lost when the power is removed
5 One mark for one of the following: ROM – stores the programs and instructions needed to
Easier to use whilst standing up start up the computer
Lighter so easier to transport RAM – stores the programs and data currently being used

© Oxford University Press 2016 Complete ICt for CambrIdge IgCSe® teaCHer reSoUrCe paCk 13
 TO P I C 1 TYPES AN D COMP ON EN TS OF COMPUTER S YSTEMS

9 One mark for the name of the emerging technology, two K ROM
marks for a description of what the technology is and two L ROM
marks for explaining how it is likely to change lives.
M RAM
This is just one of the many answers you could have:
Vision enhancement Exam-style questions
Used to enhance vision to make it easier to see Student book page 11
Uses special sensors (which are usually special cameras) 1 One mark for each of the following:
that detect information from images outside the visible Renaming a file
spectrum
Deciding where to store data on a hard disk drive
This information is then put together with the ordinary
image to make it clearer Loading a file from the disk drive

People with low vision can use vision enhancement to 2 a One mark for each one such as:
enable them to see using their remaining sight To provide a user interface (i.e. a way for the user to
10 a One mark for: interact with the computer)

Using ICT and a unique property of the human body To control the system resources and the processing
(fingerprints, face, iris and retina) to identify a person To handle outputs
b One mark each for two of the following: To maximise the use of computer memory
Iris pattern To handle interrupts and decide what action to take
Retina pattern b One mark for an answer such as:
Face measurements Used to supply the instructions to the computer to instruct
Fingerprints it how to use the attached device

c Two marks for explanation of the uses: 3

Iris pattern – uses the unique pattern on the iris to identify Description Name
a person to allow them access to a room a Deals with errors that occur when the Operating system
computer is working on tasks.
Retina pattern – uses the unique pattern on the back
b Software needed when a new piece of Device driver
of the eye (i.e. the retina) to allow a person access to a hardware is attached to the computer.
country at border control
c Scans the hard disk drive to detect and Utility
Face measurements – uses measurements from a CCTV remove viruses.
camera to make a match with the measurements stored in 4
a passport to allow a person entry into a country or not
true false
Fingerprints – uses the unique pattern on a fingerprint
Computer programs are examples of software. √
to identify a pupil in a registration system in a school.
Creating a new folder would be performed by a √
The pupil puts their finger into a reader and the system
device driver.
identifies them.
A compiler is an example of an operating system. √

Test yourself Word-processing software is an example of

applications software.
√

Student book page 10

5 One mark for each task:
A software
a Transferring data to a printer
B hardware
b Allocating storage space on a disk
C CPU information
c Accepting keyboard input
D software
6 One mark for each of three functions such as:
E applications
Handles inputs and outputs
F desktop
Supervises the running of other software
G input
Handles the storage of data
H output
Maximises the use of computer memory
I backing storage
Handles the interrupts and decides what action to take
J RAM
14 COMPLETE ICT FOR CAMBRIDGE IGCSE® TEACHER RESOURCE PACK © Oxford University Press 2016
 TO PIC 1 TYPES A N D COMPONENTS OF COMPUTER S YSTEMS

7 One mark for each of four differences such as: Using a CLI to run a program you have to remember the path
ROM – the contents remain when the power is removed where the program file is located
RAM – the contents are lost when the power is removed 13 One mark each for four points similar to the following:
ROM – stores the programs and instructions needed to start Stand-alone computers: are not connected to a network;
up the computer they do not share resources or files with other computers;
all the programs and data files needed for the applications
RAM – stores the programs and data currently being used
are stored locally (i.e. on one of the drives or memory in the
8 One mark each: computer itself).
a Software , b Input, c Output, d ROM, e RAM. Networked computers: are linked to a network or other computers;
9 a One mark each for two advantages such as: are able to share files, an internet connection and devices such
Easier to use standing up as printers and scanners; programs are stored on the internet (i.e.
Lighter and so more portable cloud storage) rather than locally on the computer.

Can be used to take photographs

Worksheet 1.1: What is being
b One mark each for two disadvantages such as:
Usually only an onscreen keyboard is provided which
shown here?
makes it hard to type long documents Teacher resource pack page 6

No CD/DVD drive so films and music have to be 1 Desktop computer 6 Scanner

downloaded 2 Processor 7 Internal memory
Small screen makes it more difficult for people with poor 3 Fixed hard disk 8 Motherboard
eyesight to use 4 Mouse 9 Laptop computer
c One mark for each of three features such as: 5 Tablet 10 Sound card
Windows
Icons Worksheet 1.2: Hardware or software?
Menus/Pull-down menus Teacher resource pack page 9
Pointers Name of item Hardware Software
Online help/Office assistants 1 Processor √
10 One mark each for two tasks such as: 2 Operating system √

Vacuuming carpets in a house 3 Fixed hard disk √

4 Memory chips (RAM √
Assembling components in a factory and ROM)
Paint spraying in a car factory 5 Keyboard √
Welding panels in a car factory 6 Mouse √
11 One mark for each correct tick. 7 Word-processor √

Robots are more intelligent than humans. 8 Search engine √

Robots are cheap to buy and maintain. 9 Speakers √

Robots can work 24 hours a day. √ 10 Microphone √

Robots always assemble the parts correctly. √ 11 DVD drive √

Robots need to be programmed to perform a task. 12 Blank DVD √

It is cheaper as robots are not paid wages. √ 13 Database √

14 Spreadsheet √
12 One mark each for four differences such as:
15 Barcode reader √
With a CLI you have to type in the instructions
16 Printer √
With a GUI you can just click on an icon 17 Web browser √
There is a lot more to learn in order to use a CLI 18 Removable hard disk √
With a CLI the instructions must be entered precisely (e.g. in 19 Wireless router √
a certain order) 20 Digital camera √
A GUI uses Windows, Icons, Menus and Pointers to allow users
to accomplish tasks

© Oxford University Press 2016 Complete ICt for CambrIdge IgCSe® teaCHer reSoUrCe paCk 15
Complete
ICT
Author
for Cambridge IGCSE Second edition ®
Stephen Doyle

Teacher Resource Pack

Complete ICT for Cambridge IGCSE directly matches the latest Cambridge IGCSE ICT
syllabus, using plenty of practical guidance to develop understanding. A stretching,
skills-based approach progressively strengthens student ability, enabling confident exam
performance.

This Teacher Resource Pack directly supports teachers in building student understanding.

• Fully prepare for exams – comprehensive coverage of the course

• Develop advanced skills – applying skills in context extends performance
• Progress to the next stage – differentiated extension material eases the
transition to 16-18 study

Empowering every learner to succeed and progress

Complete Cambridge syllabus match

Comprehensive exam preparation
Reviewed by subject specialists
Embedded critical thinking skills
Progression to the next educational stage

Also available:
978 0 19 835782 7 978 0 19 835783 4