9626_s20_qp_11 - revisedeck

9626_s20_qp_11

A paper of Information Technology, 9626

Questions:

13

Year:

2020

Paper:

1

Variant:

1

Login to start this paper & get access to powerful tools

1

For each of the two tables below, tick the most accurate statement referring to the use of the internet for communication. ✓ Instant messaging is a service similar to SMS provided by the internet Social networking sites allow messages to be posted, but not pictures or videos A blog allows anybody who reads it to also be able to edit it Chat rooms only allow one person to communicate with one other person ✓ Emails allow people to see each other when communicating Emails can be sent with somebody copied in without the other recipients knowing Emails always get an immediate response Instant messaging never results in the IM providers sending adverts to users Video-conferencing is another way of using the internet for communication. Describe how a manager in one branch of a company would set up a video-conference to communicate with managers in other branches. You can assume that the hardware and software required has already been purchased. In your description you will need to identify what each manager would need to do.

14. Communications technology → 14.5. Data transmission across networks

Open

2

Tick the most accurate statement referring to the use of compilers and interpreters. ✓ An interpreter creates a single executable file that runs directly on the CPU It is easier to debug compiled code rather than interpreted code With a compiler it is harder to protect intellectual property as machine code is easy to understand It is more difficult for hackers to modify compiled code Tick the most accurate statement referring to the use of disk formatting. ✓ Disk formatting increases the number of fragments in a hard disk Disk formatting never removes viruses from a hard disk Disk formatting increases the storage capacity of a blank disk Disk formatting is used to fully prepare a hard disk for initial use

2. Hardware and software → 2.3. Utility software

10. Database and file concepts → 10.4. File and data management

Open

3

Static information sources and dynamic information sources are often used for different purposes. Define what is meant by static and dynamic data. Using a school or college as an example, describe situations which could use a dynamic information source and those where a static information source could be used.

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

Open

4

The digital divide often exists between people in developed countries and those in developing countries. Describe what is meant by the digital divide and how it affects these countries.

6. The digital divide → 6.1. The digital divide

Open

5

A sports club keeps records in a database of its members and the individual sports they play. It has the following tables of data: Members’ names Members’ contact details Details of when they started playing the sport All the possible sports which can be played by the members. Contact_details Names Started_sport Sports Complete the tables shown above, writing down examples of the field names for three of the fields in each table. Indicate the key fields in each table and the relationships that exist between each adjacent table. Indicate the type of each relationship. Some tables have one relationship and others have a maximum of two relationships. Two of the tables could possibly be regarded as having a many-to-many relationship. Using the example of the tables shown above, explain what is meant by a many-to-many relationship.

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

Open

6

Many companies use batch processing for producing workers’ payslips. Describe, using payroll as an example, what is meant by batch processing. Explain why batch processing is used instead of real-time processing for an application such as payroll.

1. Data processing and information → 1.5. Data processing

Open

7

Designers of user interfaces tend to base their designs on what they interpret to be a user’s mental model. Evaluate, by weighing up the advantages and disadvantages, the use of a mental model to design a user interface.

2. Hardware and software → 2.5. User interfaces

Open

8

Explain how encryption protects data stored on a hard disk.

1. Data processing and information → 1.3. Encryption

Open

9

By explaining what the purpose of each is, describe the differences between verification and validation.

1. Data processing and information → 1.4. Checking the accuracy of data

Open

10

A researcher is interviewing some people. To begin with, she wants to record their personal details using a six-character code. For example, 47FT12 means the person is 47 years old, in full-time employment and left school after year 12. Explain what the code 34PT10 means and why there may be problems with coding other people in this way. Include in your explanation ways of improving this method.

5. eSecurity → 5.1. Personal data

Open

11

Mary has been put in charge of the computerised school weather station. At the moment the system has a monitor to show the outputs. She wants to replace the monitor with a printer. By weighing up the advantages and disadvantages, evaluate the system having a monitor rather than a printer.

2. Hardware and software → 2.2. System software

16. System life cycle → 16.7. Evaluation

14. Communications technology → 14.3. Network servers

Open

12

Here is part of a spreadsheet showing the wages earned by a group of workers in a company. A J51549 P30731 C41827 E41231 Workers Number Hours worked this week Hours overtime worked Rate per hour paid Wage paid this week Overtime earned this week P77168 C43839 E34572 E48505 P40813 C32408 C69848 $14.00 $17.50 $12.50 $14.00 $12.50 $14.00 $17.00 $17.00 $12.50 $12.50 $14.00 $93.75 $252.00 $75.00 $42.00 $204.00 $112.50 $21.00 $532.00 $700.00 $593.75 $812.00 $575.00 $602.00 $612.00 $884.00 $612.50 $487.50 $581.00 B C F E3 ✗ ✔ fx D E F =IF(B3>40,C3*D3*1.5," ") Without referring to other cell references, explain, in detail, what every part of the formulae in cells E3 and E5 do. You may assume that the formula has been replicated down for all workers. This spreadsheet has not been tested. Describe the test plan you would use to make sure there are no errors in the formulae in column E of this spreadsheet. You can assume that the formula in column C works perfectly and does not need changing. Using only the sort feature explain how you would be able to make the spreadsheet used in part produce this display. A C32408 P77168 C41827 P40813 Workers Number Hours worked this week Hours overtime worked Rate per hour paid Wage paid this week Overtime earned this week E41231 C43839 C69848 J51549 E48505 E34572 P30731 $12.50 $12.50 $12.50 $12.50 $14.00 $14.00 $14.00 $14.00 $17.00 $17.00 $17.50 $93.75 $75.00 $112.50 $252.00 $42.00 $21.00 $204.00 $487.50 $575.00 $593.75 $612.50 $812.00 $602.00 $581.00 $532.00 $884.00 $612.00 $700.00 B C D E F

8. Spreadsheets → 8.1. Creating a spreadsheet

9. Modelling → 9.1. Modelling and simulations

Open

13

Computers are often used for environmental monitoring applications such as pollution in rivers. Evaluate, by weighing up the advantages and disadvantages, the use of computers rather than humans in such scenarios.

3. Monitoring and control → 3.1. Monitoring and measurement technologies

1. Data processing and information → 1.5. Data processing

2. Hardware and software → 2.1. Mainframe computers and supercomputers

Open