9626_w21_qp_11 - revisedeck

Consider supporting us on Patreon. Help us keep revisedeck free.

9626_w21_qp_11

A paper of Information Technology, 9626

Questions:

14

Year:

2021

Paper:

1

Variant:

1

Login to start this paper & get access to powerful tools

1

Phoebe is collecting data to find the level of pollution in a local river. Tick the most accurate statement regarding data. ü A group of facts which are used in context is called a set of data. Data can only consist of text and numbers. Understanding that Paris, London and Berlin are capital cities of countries in Europe makes this a set of data. Data cannot be interpreted until it has a context. Tick the most accurate statement regarding the relationship between data and information. ü Data without a context is called information. Data is the result of processing information, usually by computer. Data that has meaning becomes information. Information, when arranged to make meaningful output, becomes data. Phoebe will use sensors as direct data sources to collect the data. She will place sensors in the river and collect the readings from a computer. Describe the benefits of gathering data from direct data sources in this scenario. Describe the drawbacks of gathering data from direct data sources in this scenario.

1. Data processing and information → 1.1. Data and information

17. Data Analysis and Visualisation → 17.1. Data Analysis and Visualisation

Open

2

Tick the most accurate statement referring to the purpose of input devices. ü A sensor is used to store data for later use. A magnetic chip reader is used to enter text directly from a bank card. A bar code reader is used to read magnetic ink characters. A touchpad is used to simulate the behaviour of a mouse when using a laptop computer. Tick the most accurate statement referring to the purpose of output devices. ü A laser printer can only be used to output low volumes of high-quality documents. A dot matrix printer can use continuous stationery. A plotter is used to output multi-part stationery. An inkjet printer is used to output high volumes of low-quality documents.

16. System life cycle → 16.3. Design

3. Monitoring and control → 3.2. Control technologies

Open

3

Many online banking applications use the HTTPS protocol, involving encryption, for secure connections. Evaluate, by weighing up the advantages and disadvantages, the use of HTTPS and the need for encryption in banking websites.

1. Data processing and information → 1.3. Encryption

Open

4

Describe the differences between system software and application software. Include features and examples of each type of software in your answer.

2. Hardware and software → 2.2. System software

2. Hardware and software → 2.3. Utility software

Open

5

A company owner wishes to buy software to use to produce advertising materials for her company. She can either buy custom written software or off-the-shelf software. Describe three benefits of using custom written software. Describe three benefits of using off-the-shelf software.

2. Hardware and software → 2.4. Custom-written software and off-the-shelf software

Open

6

Computers are often used, together with sensors, to control devices in the home. Evaluate, by weighing up the advantages and disadvantages, the use of control technology in the home.

3. Monitoring and control → 3.2. Control technologies

Open

7

A company has several IT workers. To help reduce health issues the company encourages workers to take regular breaks. Describe, in detail, three different health issues that can affect these workers. For each issue give one method, other than taking regular breaks, of helping to prevent it. Each method must be different. Issue 1 Prevention Issue 2 Prevention Issue 3 Prevention

16. System life cycle → 16.5. Implementation

14. Communications technology → 14.9. Network security

16. System life cycle → 16.10. Maintenance

Open

8

Many companies have branches in different cities. Branch workers can connect to the main office using the company’s virtual private network (VPN) connection. Describe the characteristics of this type of VPN.

14. Communications technology → 14.1. Networks

14. Communications technology → 14.5. Data transmission across networks

Open

9

Video-conferencing is one use of the internet. Describe what is meant by the internet. Explain why members of the general public use video-conferencing more now than when it was first introduced.

14. Communications technology → 14.5. Data transmission across networks

14. Communications technology → 14.6. Network protocols

Open

10

The spreadsheet below shows the estimated number of visitors to the different countries in the United Kingdom. The figures shown relate to the months of July and August 2019. The formulae used in column D, to add up the number of visitors to each country, are also shown. A B C D E F G H D Country CCode1 CCode2 Date =SUMIF($G$4:$G$11,B4,$H$4:$H$11) =SUMIF($G$4:$G$11,B5,$H$4:$H$11) =SUMIF($G$4:$G$11,B6,$H$4:$H$11) =SUMIF($G$4:$G$11,B7,$H$4:$H$11) Total number of visitors Number of visitors Total number of visitors England Northern Ireland Scotland Wales Wa Sc NI En NI En Sc Wa En NI Sc 10.56 0.53 5.10 0.62 0.43 5.46 0.61 0 63 July 2019 July 2019 July 2019 July 2019 August 2019 August 2019 August 2019 1.14 1.25 0.81 UK Tourism Figures UK Tourism Figures

8. Spreadsheets → 8.1. Creating a spreadsheet

9. Modelling → 9.1. Modelling and simulations

Open

11

Sc Wa 0.63 0.38 August 2019 August 2019 Spreadsheet Column D Formulae Using this spreadsheet as an example, explain, in detail, what is meant by absolute and relative cell referencing and explain why both are used. Describe, in detail, how other characteristics of spreadsheet software would enable this spreadsheet to be used for modelling purposes. Each characteristic must be different. 11 Normalisation is often used to refine the structure of a relational database. Describe four advantages of using normalisation.

8. Spreadsheets → 8.1. Creating a spreadsheet

10. Database and file concepts → 10.2. Normalisation to third normal form (3NF)

9. Modelling → 9.1. Modelling and simulations

Open

12

A computer repair company employs a technician who uses an expert system to diagnose problems with printers. The company also employs a knowledge engineer. Explain how the technician would interact with the expert system. Explain the role of the knowledge engineer.

7. Expert systems → 7.1. Expert systems

Open

13

Here is an extract from a table which is part of a relational database. It requires the use of a compound key. Studentid Second_name Coursecode L03127 Gimenez MAT L03218 Driscoll CHE L03313 De Silva PHY L03214 Alicante BIO L03127 Gimenez CHE Analyse, including its effectiveness, the function of a compound key. Refer to the extract in your answer. Please turn over for Question 14.

10. Database and file concepts → 10.1. Creating a database

Open

14

A manager has produced a training video. It has been given to the IT department to edit. Describe the purpose of the following features of video editing software and how each could be used. Trimming Adding captions

11. Video and audio editing → 11.1. Video editing

11. Video and audio editing → 11.2. Audio editing

Open