0417_w19_qp_12 - revisedeck

0417_w19_qp_12

A paper of Information and Communication Technology, 0417

Questions:

14

Year:

2019

Paper:

1

Variant:

2

Login to start this paper & get access to powerful tools

1

A student is creating a test plan for a validation routine. The input to be tested is an integer between 1 and 10. Tick whether the following are the most appropriate examples of normal data, abnormal data or extreme data. normal (✓) abnormal (✓) extreme (✓) one 3.2

7. The systems life cycle → 7.3. Development and testing

7. The systems life cycle → 7.2. Design

Open

2

Tick whether the following statements relate to a command line interface (CLor a graphical user interface (GU. CLI (✓) GUI (✓) This interface does not need a pointing device This is an example of a WIMP interface The user has to type in instructions This interface takes up more memory in the computer

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

7. The systems life cycle → 7.5. Documentation

Open

3

Complete the following sentences, using the most appropriate items from the list. An app Coding A data projector A linker Pen drive Quantum A TFT monitor A touch screen Vision Web cam cryptography enhancement is an example of system software. is an example of an output device that can also act as an input device. projects an image inside the headset of the user. is a form of encryption of data.

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

Open

4

This diagram shows a smartphone. Name three input devices found on a smartphone. Name one storage device which is available in a smartphone. Name two output devices found in a smartphone.

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

5

People are buying laptop computers rather than desktop computers. Give four advantages of using a laptop computer rather than a desktop computer.

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

Open

6

The computer technician at Tawara School is planning to set up ten new computers to be placed in the staffroom to form a network. The network will not be connected to the internet. Assume the school currently has no hardware or software for this network. State the steps that the technician would need to take to set up this network. The teachers have asked the head teacher if they can access the internet. The computer technician will need to attach a router to the network. Explain how a router works. The school plans to connect some teachers’ laptops to this new network using WiFi. Describe, in detail, how data is transmitted from the laptops to the new network.

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

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

Open

7

C B A Describe the steps required to transform shape A into shape B. Describe the steps required to transform shape A into shape C.

Open

8

Files can be saved in a generic file format. Explain why generic file formats are needed. Complete the following sentences, using the most appropriate file format from the list below. .css .csv .doc .gif .htm .pdf .png .rar .sdb .xls is a stylesheet used in the creation of web pages. is a generic archive file format. is a generic file format that stores still and moving images. takes data in the form of tables and saves it as text.

11. File management → 11.1. Manage files effectively

Open

9

The director of a small airport has asked his airport manager to look into the punctuality of departures. The manager obtained details of some of the departures on one day. He has created a spreadsheet, which contains both the airport data and the times of departure. Part of the spreadsheet is shown. Scheduled departure time Airport code Airport name Actual time of departure Minutes late Airport code Destination Late / on time 14:00 14:15 14:45 14:45 14:50 14:50 14:50 15:13 17:40 14:58 14:48 15:05 14:50 14:59 ALG BKK BXW DEL DOH CPH GVA CPH ALG DOH DOH BKK GVA BXW L L L L L OT L Copenhagen Algiers Doha Doha Bangkok Geneva Bawean Algiers Bangkok Bawean Delhi Doha Copenhagen Geneva A B C D E F Write a formula that would be entered in cell F11 to display the letter L if the value in C11 is greater than 0 or the letters OT if it is not. = Write a formula, without using named ranges, that would be entered in cell E11. The formula must be easy to replicate. It should display the name of the airport, using the Airport code from cell D11 and the list of Airport names. = The airport manager is producing a report of his findings to present to the director. The data will change from day to day. Before he can produce the findings he needs to enter a formula in cell F19 to count the number of late departures from the airport. Scheduled departure time Actual time of departure Minutes late Airport code Destination Late / on time 14:00 14:15 14:45 14:45 14:50 14:50 14:50 15:13 17:40 14:58 14:48 15:05 14:50 14:59 CPH ALG DOH DOH BKK GVA BXW L L L L L OT L Copenhagen Algiers Doha Doha Bangkok Geneva Bawean Late On Time A B C D E F Write the formula, without using a named range, to be entered in cell F19. = Name the most appropriate type of chart/graph he could produce to show the proportion of late departures and those that leave on time.

20. Spreadsheets → 20.1. Create a data model

Open

10

A company is purchasing a new printer. A choice has to be made between using a laser printer or a dot matrix printer. Discuss the advantages and disadvantages of using dot matrix printers rather than laser printers.

2. Input and output devices → 2.3. Output devices and their uses

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

6. ICT applications → 6.3. Computer controlled systems

Open

11

Microprocessor-controlled devices in the home have had positive effects on people’s lifestyles. One of the advantages of using these devices is that we can now set a cooker to switch on whilst we are out so that we arrive home to a cooked meal. Apart from the use of cookers, describe the advantages of using microprocessor-controlled devices in the home. Some home devices can be controlled remotely when away from home. These home devices need to be connected to the internet. Describe the disadvantages of connecting home devices to the internet.

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

6. ICT applications → 6.3. Computer controlled systems

Open

12

A sports club is planning a new computerised record keeping system to replace their manual system. A systems analyst recommends that new software is required. The analyst could either write the software or purchase it off the shelf. Give two advantages to the sports club of the analyst writing the software. Explain why it is better to use a computer to store the records rather than the manual system. The systems analyst recommends that the system is implemented using direct changeover, but the sports club feel that parallel running should be used. Describe direct changeover and parallel running, giving a different benefit and drawback of using each method of implementation. Direct changeover Benefit Drawback Parallel running Benefit Drawback

7. The systems life cycle → 7.1. Analysis

7. The systems life cycle → 7.4. Implementation

Open

13

Many companies that make microprocessors use robots to carry out the task rather than using humans. Give three advantages of using robots to carry out the task. Give three disadvantages of using robots to carry out the task.

6. ICT applications → 6.3. Computer controlled systems

6. ICT applications → 6.2. Modelling applications

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

Open

14

The internet is not controlled by any one single country. The internet is a very good communication system, but it can also be seen as a security problem. Discuss the benefits and drawbacks of policing the internet.

10. Communication → 10.2. Effective use of the internet

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

Open