---

---

1

A company secretary is creating a new database of workers to record: • their six digit ID number • the date they joined the company • their rate of pay per hour up to a maximum rate of $50 per hour. She has entered data from a source document into the database. There was an error in record 3 and an error in record 4 in the source document. The secretary also made an error when copying record 1. Source document Database Record ID number Date joined Rate of pay ID_number Date_joined Rate_of_ pay 13/06/2019 13/06/2020 09/10/2019 09/10/2019 15/08/2020 15/08/2020 23/12/2020 23/12/2020 27/07/2021 27/07/2021 Using this data, explain, in detail, the need for verification and validation when entering data into a database.

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

Open

2

Mainframe computers are used in banking. Supercomputers are used in climate research. Explain what is meant by a mainframe computer and by a supercomputer with reference to the types of processing and the processors they each use. Explain how supercomputers are used in climate research.

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

Open

3

Give brief descriptions of the following types of user interface. command line interface gesture based interface dialogue interface

2. Hardware and software  →  2.5. User interfaces

Open

4

Describe how touch sensors are used as part of a control system in nuclear power plants. Describe how infrared sensors are used in burglar alarm systems.

3. Monitoring and control  →  3.2. Control technologies

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

Open

5

Maria wants to use information about the families in her town for a study. She will get the information from an indirect data source, the town’s electoral register. This is kept at the local council office. She has decided not to use a questionnaire, which is a direct data source, to gather the information she needs. Describe the suitability of using the electoral register rather than a questionnaire.

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

Open

6

There can be a digital divide between people who live in rural areas and people who live in urban areas. The divide can be caused by the lack of fast broadband in rural areas, resulting in limited access to the web. Explain the effects on people who live in rural areas of having limited access to the web. Describe ways to reduce this digital divide.

6. The digital divide  →  6.1. The digital divide

Open

7

Louisa, a teacher with limited IT knowledge, has created a simple database of her students. The database contains the names of her students and the results of their latest test. She prints out the names of the students who have passed the latest test by gaining a mark of 40 or more. When she created the database, she considered creating a dynamic parameter query to produce her printout. However, she decided to create a static parameter query. Explain why this was a good decision.

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

Open

8

Students often transfer files between different word processing and database packages. Justify the need for generic file formats for the transfer of files between different packages.

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

Open

9

Sukhjinder, a mathematics student, has defined a procedure using pseudocode. It calculates the area of a parallelogram by multiplying the base by the height. All parallelograms will have an area of less than 1000. The procedure Sukhjinder has written is: PROCEDURE parallelogram(base,height) area base*height ENDPROCEDURE He has also begun writing an algorithm which calls the procedure and then passes back the area. The main algorithm accepts inputs of the base and the height of 10 parallelograms, one at a time. It will output the areas of the largest and smallest parallelograms. Complete the algorithm for Sukhjinder by filling in the missing lines. count smallest WHILE count IF area ENDIF

4. Algorithms and flowcharts  →  4.1. Algorithms

1. Data processing and information  →  1.5. Data processing

Open

10

Explain why the following techniques could be needed when making videos. trimming a video clip adding subtitles to a video adding sound to a video

11. Video and audio editing  →  11.1. Video editing

Open

11

When data is sent across the internet, it is usually encrypted. Discuss the benefits and drawbacks of encrypting data which is transmitted over the internet.

14. Communications technology  →  14.5. Data transmission across networks

1. Data processing and information  →  1.3. Encryption

Open