---

---

1

Different symbols are used in program flowcharts. Draw, in the spaces provided, four different program flowchart symbols and for each one, state its purpose. Symbol 1 Purpose Symbol 2 Purpose Symbol 3 Purpose

4. Algorithms and flowcharts  →  4.2. Flowcharts

Open

2

Describe the features of a management information system (MIS).

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

2. Hardware and software  →  2.2. System software

Open

3

Normalisation is used in a relational database. State what is meant by the term second normal form (2NF). Discuss the benefits and drawbacks of normalising data.

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

Open

4

Validation and verification can be used to check the accuracy of data. Describe the differences between validation and verification. Your answer must explain the purpose of each. Describe each of the following: range check double data entry

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

Open

5

Describe the use of a public key and a private key in asymmetric encryption.

1. Data processing and information  →  1.3. Encryption

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

Open

6

In a spreadsheet, a user has entered the following formula into a cell: =IF(NOT(OR(B68)),"4th Quarter","") Describe how the spreadsheet will calculate the result to be displayed.

8. Spreadsheets  →  8.1. Creating a spreadsheet

8. Spreadsheets  →  8.2. Testing a spreadsheet

Open

7

Describe the term goal driven as used in expert systems.

7. Expert systems  →  7.1. Expert systems

Open

8

Describe how access to information technology has created the digital divide.

6. The digital divide  →  6.1. The digital divide

Open

9

Describe the following types of malware: spyware worm

5. eSecurity  →  5.2. Malware

Open

10

Justify the use of online processing in stock control.

1. Data processing and information  →  1.5. Data processing

3. Monitoring and control  →  3.2. Control technologies

Open

11

It is important that sensors are calibrated to ensure their readings are accurate. Describe one point calibration.

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

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

Open