---

---

1

When a person buys goods in a supermarket they have to pay at the checkout. Identify two input devices used at the checkout. Identify two output devices used at the checkout.

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

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

Open

2

Tick whether the following statements are true or false. false (✓) true (✓) A router is required to allow a LAN to connect to the internet A web browser displays a web page An intranet has restricted access ISP means Internal Service Provider 1 2

10. Communication  →  10.2. Effective use of the internet

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

18. Databases  →  18.1. Create a database structure

Open

3

Tick whether the following items are found in technical documentation or user documentation or both. both (✓) user (✓) technical (✓) Error messages Hardware requirements Program listing Purpose of the system

7. The systems life cycle  →  7.5. Documentation

Open

4

Identify the image editing techniques described in the following statements. Remove unwanted parts of an image. Make an image larger or smaller. Format the text so that it flows around an image. Turn an image a number of degrees clockwise or anti-clockwise. [Turn over 1 2

12. Images  →  12.1. Image manipulation

Open

5

The managers of a nuclear power plant need to check the radioactivity levels in a chimney stack which needs to be demolished. They intend to use a robot. This device has sensors to read the radioactivity levels. Explain why the data from the sensors cannot be read directly by the microprocessor and name the device needed to change the data into a form that the microprocessor can understand. The managers have been told they can use this robot for other tasks by replacing the existing sensors with different ones. Give three advantages of using an existing robot device rather than developing a new one.

7. The systems life cycle  →  7.1. Analysis

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

Open

6

A student has completed some work at school and wishes to take it home. He could use a pen drive or a CD R disc to transport the files. Give two error messages that could appear to stop him saving his work. 1 2 Compare and contrast the use of a pen drive rather than a CD R.

3. Storage devices and media  →  3.1. Storage devices

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

Open

7

Driverless automobiles use a number of different methods to drive between two points. Name a sensor that could be used on the automobile to detect a person walking in front of it. Modern automobiles contain electronic devices designed to help the driver. Suggest three examples of labour-saving or safety devices in a modern automobile that use sensors. [Turn over 1 2 Discuss the advantages and disadvantages of these devices in relation to automobile journeys.

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

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

Open

8

Expert systems are used in medical applications. From the list below, tick two components of an expert system. tick (✓) Control unit Graphics program Inference engine RFID Rules base Search engine 1 2 Describe three benefits of the doctor using an expert system to help diagnose a patient’s illness.

6. ICT applications  →  6.8. Expert systems

Open

9

A school’s examinations officer has decided to develop a database to store pupil details and the examinations they are due to sit next summer. They are going to use a relational database. Describe the steps involved in creating the database. [Turn over 1 2 Some of the records stored in the database are given below. Date_of_exam Examination_level Name_of_subject Examination_ID 12/04/2018 IGCSE ICT 11/06/2018 IGCSE Computer Science 01/06/2018 O Level Design and Technology 28/06/2018 O Level French Based only on the examination details above, complete the table below, stating the most appropriate data type for each field. Data type Field name Examination_ID Name_of_subject Examination_level Date_of_exam Write the search criteria to search for all examinations which will be sat after 26/06/2018, using at least one of the following operators >, >=, Apart from presence check, name and describe a suitable validation check for each of the following fields in the database, based on the data shown in part . Examination_ID Date_of_exam 1 2

18. Databases  →  18.1. Create a database structure

Open

10

A leisure centre is creating membership cards for all its members. The membership card must include a photograph of the member, the member’s name and membership number, the type of member (Senior or Junior), their date of birth and gender. Use the space below to design the membership card. Describe all the steps involved in carrying out a mail merge to create the membership cards. [Turn over 1 2

Open

11

The Xtreme Adventure Holiday Company are setting up a spreadsheet for their payroll. They have job codes for each of their employees. Below is part of the payroll spreadsheet. A B C F D E G The Xtreme Adventure Holiday Company Job codes A B H S SA TA TB TM TS Employees Name Luca Gisi Livio Stager Nico Gantert Fabian Ging Mattia Polt Sofia Walp Laura Haener Alessandro Messerli Lara Forrer Arda Hegler Simone Aebi Administration/Office Snowboard Instructor Host/Hostess Ski Instructor Senior Administrator Transport Assistant Trainee Snowboard Instructor Transport Manager Trainee Ski Instructor Job code B S B S S H S S B S B Job description Describe, giving a suitable name for the range (A6:B14), how the payroll manager could name this range. 1 2 Write a formula for cell C18 to display the job description, using the named range from part .

20. Spreadsheets  →  20.1. Create a data model

Open

12

When a new system is being developed analysis takes place. One method of researching the current system is interviewing. List three other methods of researching the current system. Describe two drawbacks of using interviews. [Turn over 1 2

7. The systems life cycle  →  7.1. Analysis

Open

13

The introduction of computers in an organisation can both increase or decrease employment. Tick the jobs below for which the introduction of computers will increase the number of workers. tick (✓) Job description Car production workers Delivery drivers Payroll workers Programmers Typists Website designers Describe what is meant by the following types of working. Compressed hours Flexible hours

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

Open

14

There are different ways to check the data that you have entered into a computer system. One of these ways is verification. Name two types of verification. 1 2 Proofreading is sometimes thought to be verification. Explain the differences between verification and proofreading.

15. Proofing  →  15.2. Proofing techniques

7. The systems life cycle  →  7.2. Design

Open

15

Email systems can receive spam emails. Explain why spam should be prevented. [Turn over 1 2

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

8. Safety and security  →  8.3. Security of data

Open

16

Bluetooth and WiFi can connect devices together. Discuss the advantages and disadvantages of using Bluetooth or WiFi. 1 2

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

Open