---

---

1

Tick whether the following statements would apply to a LAN, a WAN or a WLAN. LAN (3) WAN (3) WLAN (3) The internet is an example of this type of network A wired network found within a single building This network uses wireless technology This network is spread over a large geographical area

4. Networks and the effects of using them  →  4.1. Networks

Open

2

Complete the following sentences, using the most appropriate technology from the list below. a 3D printer artificial intelligence batch processing biometrics a dot matrix printer a microphone a password a robot a scanner a speaker A printer that is capable of producing physical objects is called The use of a computer to perform tasks that mimic or duplicate the functions of the human brain is called A device used in a car production line to assemble a car is called Authentication techniques that use fingerprints or retina scans is called

6. ICT applications  →  6.10. Recognition systems

8. Safety and security  →  8.3. Security of data

Open

3

A school is holding an athletics competition. The timings of each running event will be measured electronically using sensors at the start and finish. Runners begin a race in starting blocks. When the starting pistol is fired the electronic timing starts. The winner of the race is the first to break the light beam at the end of the race. Complete the table using the most appropriate words from the list below. Infra-red sensor Light sensor Moisture sensor Motion sensor pH sensor Pressure sensor Sound sensor Temperature sensor Device Data from the starting pistol is read by this device This device detects that the athlete has left the starting block When the light beam is broken the data is read by this device A member of the sports department will use a computer to produce a magazine of the competition. He will include photographs stored in a digital camera as well as printed photographs. Identify the methods he would use to transfer the photographs to the computer. Digital camera photograph Printed photograph

7. The systems life cycle  →  7.1. Analysis

4. Networks and the effects of using them  →  4.2. Network issues and communication

Open

4

You have been asked to set up a hierarchical folder structure for your IGCSE ICT work directories so that you can easily locate certain files. Fill in the boxes and complete the most appropriate hierarchical folder structure, to store practical and theory work for both homework and classwork. ICT A Complete the file path for a document called input_devices.rtf stored in box A.

11. File management  →  11.1. Manage files effectively

7. The systems life cycle  →  7.5. Documentation

Open

5

Describe the processes a web browser has to go through to load a web page. An organisation is creating a company website and is deciding whether to make it available on the internet or create a company intranet. The website will contain confidential information. Explain why they should use an intranet rather than the internet.

4. Networks and the effects of using them  →  4.1. Networks

10. Communication  →  10.2. Effective use of the internet

Open

6

Using the images below write down the Safety issue referred to and a way of Minimising the risk. Image Safety issue Minimise the risk

8. Safety and security  →  8.1. Physical safety

8. Safety and security  →  8.2. eSafety

Open

7

One popular reason for young people using the internet is playing online games. One way of ensuring that young people are safe is to use fictional names to identify themselves. Describe other measures that should be taken to ensure that playing online games is safe for young people.

8. Safety and security  →  8.2. eSafety

10. Communication  →  10.2. Effective use of the internet

Open

8

Hot House Design keeps to a corporate house style when creating a website. Web page 1 Web page 2 Using examples from the two webpages, explain what is meant by house style.

14. Styles  →  14.1. Style management

21. Website authoring  →  21.3. Use stylesheets

21. Website authoring  →  21.2. Create a web page

Open

9

The internet is used as a method of communication. This includes Blogs, Wikis and VOIP. Describe the following ways of communicating. Blog Wiki VOIP The internet has a number of security issues. Tick whether the following statements would apply to Phishing, Pharming or Smishing. Phishing (3) Pharming (3) Smishing (3) The sending of fraudulent emails appearing to come from legitimate companies in order to steal passwords Redirecting users to a bogus website that looks authentic Security attack where a user is tricked into downloading a virus on to a cell phone As the user types details they are stored by the criminal

8. Safety and security  →  8.3. Security of data

10. Communication  →  10.2. Effective use of the internet

Open

10

The Ocean Sailing Company offers the experience of sailing on a yacht. Customers can choose which type of yacht they want to sail on. The owner keeps a spreadsheet to calculate the cost to customers. The owner allocates a loyalty code to each customer. Each code has a different discount. Holiday Cruises 0.05 0.1 0.125 Name of Yacht Number of days Percentage Discount Discount =VLOOKUP(A9,$A$4:$B$6,2) Ocean Speed Sealord Sunliner Pacifico Alexander Moonliner Coronia Voyager Code A B C D E Discount Cost per day Explain each element of the formula in cell D9. Identify the value you would expect to see in cell D9. The Discount is the cost per day multiplied by the number of days multiplied by the Percentage Discount. Write a formula that would be entered in cell E9 to calculate the Discount. The $ symbol is used in the formula in cell D9. Name this type of referencing and explain why it is used. The Ocean Sailing Company owns a number of yachts. Explain how you could replicate the formulae to calculate the Percentage Discount and the Discount for each yacht.

20. Spreadsheets  →  20.1. Create a data model

Open

11

A theatre manager wishes to introduce an online booking system. A programmer has been asked to write the software. She could continue on her own or discuss the ideas with the theatre manager. Explain why is it beneficial to discuss ideas with the theatre manager before writing the software. Give four advantages of using online booking systems for the customer rather than using manual systems.

6. ICT applications  →  6.5. Booking systems

10. Communication  →  10.2. Effective use of the internet

18. Databases  →  18.1. Create a database structure

Open

12

Contactless debit cards are replacing standard debit cards. Some countries are introducing contactless debit card transactions at ATM machines. Give three disadvantages to the customer of using these cards at an ATM.

6. ICT applications  →  6.6. Banking applications

6. ICT applications  →  6.9. Computers in the retail industry

Open

13

A travel agent specialising in adventurous holidays has asked a systems analyst to recommend a new computer system for their records. The systems analyst’s first task is to research the current system. Identify three methods of researching the current system. The company has decided to set up a website to publicise its holidays. Name three appropriate types of object that could be inserted into the web page.

7. The systems life cycle  →  7.1. Analysis

7. The systems life cycle  →  7.6. Evaluation

Open

14

A robot is used as a computerised postal delivery system. It drives around the corridors of a set of offices picking up and delivering post. If the robot is close to a worker it stops and waits until the worker moves away. A proximity sensor is used to detect how close to a worker the robot is. Describe the role of the microprocessor in stopping the robot. Robots are being used more and more in offices to carry out menial tasks, like delivering post. Describe the advantages and disadvantages of using robots in this way.

6. ICT applications  →  6.9. Computers in the retail industry

5. The effects of using IT  →  5.1. Microprocessor-controlled devices

Open

15

A word processing program uses a Graphical User Interface (GU. Using examples from the word processing program describe three features of a GUI.

1. Types and components of computer systems  →  1.1. Hardware and software

1. Types and components of computer systems  →  1.3. Operating systems

7. The systems life cycle  →  7.5. Documentation

Open

16

The banking industry has rapidly changed over the last few years as modern technology has developed. Discuss the advantages and disadvantages of using online banking rather than other banking methods to the customer.

6. ICT applications  →  6.6. Banking applications

4. Networks and the effects of using them  →  4.1. Networks

6. ICT applications  →  6.9. Computers in the retail industry

Open