---

---

1

Write down the most appropriate input device which matches the following descriptions: This is provided with a laptop to imitate the functions of a mouse. This is not a mouse but is used to manoeuvre objects around the screen in computer video games. This is used to type in text. This is used for direct input of hard copy images.

2. Input and output devices  →  2.1. Input devices and their uses

1. Types and components of computer systems  →  1.2. The main components of computer systems

1. Types and components of computer systems  →  1.4. Types of computer

Open

2

Tick whether the following statements are true or false. false (✓) true (✓) A microphone is an output device. The Control Unit is part of the Central Processing Unit. The Arithmetic and Logic Unit is part of the Central Processing Unit. A temperature sensor is an input device.

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

1. Types and components of computer systems  →  1.2. The main components of computer systems

Open

3

Tick whether the following statements would most appropriately apply to the internet or an intranet. intranet (✓) internet (✓) A public computer network. Is easier to protect sensitive data from hackers. The content is more easily controlled. Exists within a single organisation only. 1 19

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

10. Communication  →  10.2. Effective use of the internet

Open

4

Complete the following sentences. A piece of programming code which maliciously deletes files is called The scrambling of data to make it unreadable by unauthorised users is called An internet protocol for delivering private messages using cryptography is called An attachment to an electronic message used to verify the identity of the sender is called

8. Safety and security  →  8.3. Security of data

8. Safety and security  →  8.2. eSafety

Open

5

Describe four methods you could use to minimise the likelihood of receiving spam emails. [Turn over 1 19

10. Communication  →  10.1. Communication with other ICT users using email

8. Safety and security  →  8.3. Security of data

Open

6

A school’s Science department has a network which uses WiFi. A teacher has a laptop computer and whilst in school wishes to connect to this network. Write down the name of this type of network. In order to access the network the laptop must be within range of a type of WiFi network device. Write down the name of this type of device. Describe how this device is connected to the network using an ethernet cable. WiFi networks can be limited in their range. Describe one other disadvantage of a WiFi network compared to a cabled network.

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

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

Open

7

Explain what is meant by VOIP. Name two items of computer hardware that are needed in order to make a VOIP phone call from one computer to another. 1 19

1. Types and components of computer systems  →  1.4. Types of computer

6. ICT applications  →  6.1. Communication

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

Open

8

There are many microprocessor controlled devices used in the modern home. Describe two drawbacks in terms of lifestyle changes this has produced for the users of such devices.

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

6. ICT applications  →  6.3. Computer controlled systems

Open

9

A customer wishes to check the balance of their bank account and inserts their card into the ATM. Describe the computer processing which takes place at the ATM. Describe the computer processing which takes place at the bank’s computer. [Turn over 1 19

6. ICT applications  →  6.6. Banking applications

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

Open

10

When a bank cheque is presented to a bank it is sent off to a cheque clearing centre. Give three items of information that are pre-printed on the cheque in magnetic ink. Describe how MICR is used to read these details from the cheque. Explain why magnetic ink is used rather than bar codes on a cheque. 1 19

6. ICT applications  →  6.6. Banking applications

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

6. ICT applications  →  6.10. Recognition systems

Open

11

Name and describe three methods of implementing a new computer system. For each one describe the type of situation where each method might be used. [Turn over 1 19

7. The systems life cycle  →  7.1. Analysis

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

Open

12

Maria is the principal of the International Municipal school. She has employed Paulo, a systems analyst, to create a new database system to store records of her final year IGCSE students. Examples of the details of the students which will be stored are: Velia Grimaldi, A3058, Female, 161, Leaving Giuseppe Campo, A3072 , Male, 177, Staying on to 6th form Nicola Donati, B3085, Female, 173, Staying on to 6th form Giovanni Agnelli, C3102, Male, 172, Leaving Complete the following table by entering the field names and most appropriate data type for each field. For any numeric field, specify the type of number. Data type Field name Name Boolean Height Paulo wishes to save storage space. He does not change the Name field, but decides that two other fields could have their data shortened. Apart from the Name field, identify the two other fields and describe how the contents will be shortened. Field 1 Shortened form 1 Field 2 Shortened form 2 1 19 There is no key field set. Maria’s secretary typed in the data to the database in this order: Giuseppe Campo, A3072, Male, 177, Staying on to 6th form Giovanni Agnelli, C3102, Male, 172, Leaving Nicola Donati, B3085, Female, 173, Staying on to 6th form Velia Grimaldi, A3058, Female, 161, Leaving Maria can get the database back in to the original order by sorting the data using one field. Write down the name of this field and the order in which it will need to be sorted. Field Order

7. The systems life cycle  →  7.2. Design

18. Databases  →  18.1. Create a database structure

Open

13

FTP is an internet protocol. Explain what is meant by FTP and how it differs from HTTP. [Turn over 1 19

10. Communication  →  10.2. Effective use of the internet

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

Open

14

Below is a spreadsheet showing contributions to a charity from different regions. Regional analysis Region Africa Asia Australasia Europe North America South America RCode AF AS AU EU NA SA Currency Rand Yuan Dollar Euro Dollar Real ZAR 65.00 ¥3,752.50 $142.50 €1,076.00 $2,240.50 R$75.75 20/01/2016 20/01/2016 20/01/2016 20/01/2016 21/01/2016 21/01/2016 21/01/2016 21/01/2016 21/01/2016 22/01/2016 22/01/2016 22/01/2016 23/01/2016 23/01/2016 23/01/2016 23/01/2016 24/01/2016 25/01/2016 25/01/2016 26/01/2016 26/01/2016 AF AS NA EU NA SA AF AS EU AU EU NA SA EU NA AS AS AS AU EU AS 15.00 150.00 2000.00 25.00 120.50 50.00 50.00 25.00 15.00 140.00 1000.00 20.00 25.75 16.00 100.00 55.00 12.50 10.00 2.50 20.00 3500.00 Regional income Date Rcode Amount The Manta Conservaon Project A B C D E F G H I Number of donaons Cell E4 contains the formula =SUMIF($H$4:$H$24,B4,$I$4:$I$24) Using cell references explain what this formula does. What formula would you expect to see in cell E8? The formula in I26 only refers to the values in column I. Write down the formula you would expect to see in cell I26 1 19

20. Spreadsheets  →  20.1. Create a data model

Open

15

Information on the internet can sometimes be unreliable. Discuss ways you could minimise the chance of finding unreliable information when searching the internet. [Turn over 1 19

10. Communication  →  10.2. Effective use of the internet

Open

16

Describe what is meant by the following file formats. .txt .gif .pdf 1 19

11. File management  →  11.1. Manage files effectively

Open

17

The following is an external stylesheet which contains a number of mistakes. h1 { colour: #000040; font-family: Arial, sans serif; font-size: 18 px; text-align: center; } h2 { color: 000000; font-family: Times New Roman, serif; font-size: 15px; text-align: centre; } body { background-image: url('j12backgd2.jpg'); background-color: #025fb4; } table { border-collapse: collapse; border-width: 4px; border-style: solid; border-color: #000000; } td { border-width: 2px; border-style: solid; border-color: #000000; } Write down five mistakes which would prevent this stylesheet from working properly and, for each, give the correction. [Turn over 1 19

21. Website authoring  →  21.3. Use stylesheets

Open

18

Discuss why different user interfaces require the use of different types of input device. 1 19

2. Input and output devices  →  2.1. Input devices and their uses

1. Types and components of computer systems  →  1.4. Types of computer

1. Types and components of computer systems  →  1.2. The main components of computer systems

Open