---

---

1

For Examiner's Use Name the input devices A, B, C and D using the words from the list. A B C D Bar code reader Chip reader Graphics tablet Laser printer Magnetic Stripe Reader Numeric keypad Remote control Trackerball A B C D

2. Input and output devices  →  2.1. Input devices and their uses

2. Input and output devices  →  2.2. Direct data entry and associated devices

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

Open

2

Ring two network devices. Bridge DVD R Light pen Magnetic tape Printer Switch

Open

3

Tick True or False next to each of these statements. True False Withdrawing money from an ATM is an example of batch processing. The processing of bank cheques is an example of batch processing. Booking a theatre ticket is an example of online processing. Producing utility bills is an example of online processing.

Open

4

For Examiner's Use Complete each sentence below using one item from the list. a bar code a chip a dot matrix printer a DVD RW an inference engine an inkjet printer The most suitable storage medium for storing data on a bank card is The tool which searches for matches in a knowledge base is An optical disc which can have data updated is Multipart stationery is used with

3. Storage devices and media  →  3.1. Storage devices

3. Storage devices and media  →  3.2. Storage media

Open

5

Draw five lines on the diagram to match the input device to its most appropriate use. Input device Use Bar code reader to enter hard copy images into a computer Microphone creating a piece of text Scanner selecting items from a menu Keyboard inputting data from a food item at a POS Mouse creating a voice over for a presentation

2. Input and output devices  →  2.1. Input devices and their uses

2. Input and output devices  →  2.2. Direct data entry and associated devices

7. The systems life cycle  →  7.2. Design

Open

6

For Examiner's Use As well as PCs, mobile phones can be used to access the Internet. Give two advantages of using a PC rather than a mobile phone for this purpose. Give two disadvantages of using a PC rather than a mobile phone for this purpose.

10. Communication  →  10.2. Effective use of the internet

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

Open

7

Tick Internet or intranet, next to each statement, as appropriate. Internet intranet is a network of computer networks exists usually within one organisation anybody can access it can be expanded to become an extranet

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

10. Communication  →  10.2. Effective use of the internet

Open

8

Tick spam or pharming, next to each statement, as appropriate. spam pharming is the sending of several emails at once requires malicious code to be downloaded re-directs the user to a fake website is the sending of unsolicited messages

10. Communication  →  10.1. Communication with other ICT users using email

Open

9

For Examiner's Use A student wishes to use a floor turtle to draw this shape: Start Finish a b c Name and explain the meaning of four instructions that the turtle graphics software would contain in order to draw the shape. Note: a, b and c are the same length. Instruction 1 Meaning Instruction 2 Meaning Instruction 3 Meaning Instruction 4 Meaning

Open

10

Tick whether the following statements are true or false about student records in a database. True False A file is a collection of related records. A field is one item of data such as name or address. The same value can occur several times within a key field. A record is the complete data about one student.

18. Databases  →  18.1. Create a database structure

8. Safety and security  →  8.2. eSafety

7. The systems life cycle  →  7.2. Design

Open

11

For Examiner's Use 11 Hospitals often use computers to continuously monitor patients. Describe the monitoring process. Give four advantages of using a computer rather than nurses to monitor patients.

6. ICT applications  →  6.7. Computers in medicine

6. ICT applications  →  6.3. Computer controlled systems

6. ICT applications  →  6.2. Modelling applications

Open

12

For Examiner's Use 12 A shop owner uses a spreadsheet to calculate his profits. This is part of the spreadsheet. A B C D E F G Producer Food type Number in stock Cost Price Selling Price Profit Total profit Logekks Potato flakes $1.80 $1.90 $0.10 $16.80 Squarebranch Chocolate bar $0.75 $0.80 $0.05 $10.10 Roofs Beefburgers $2.05 $2.25 $0.20 $17.60 Kapats Gravy $3.20 $3.45 $0.25 $30.00 Startle Yoghurt cream $1.50 $1.65 $0.15 $18.30 Total in stock Overall profit $92.80 Give the cell reference of the cell that contains $3.45. Give the cell reference of a cell that contains a label. How many columns are shown in the spreadsheet? Write down the formula which should go in cell G2. = Formulae similar to that used in cell F2, that is to say = E2 – D2, have been used in cells F3 to F6. These were not typed. Describe how these were entered. For Examiner's Use Spreadsheets can be used for modelling. Give three reasons why computer models are used rather than the real thing.

20. Spreadsheets  →  20.1. Create a data model

Open

13

Describe the differences between a CLI (Command Line Interface) and a GUI (Graphical User Interface).

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

1. Types and components of computer systems  →  1.2. The main components of computer systems

Open

14

For Examiner's Use 14 The head teacher of a school has employed Pierre, a systems analyst, to create a new database system to keep details of all students. Each student will be allocated a unique ten digit reference number. Pierre has written out some of the questions that the head teacher might ask. He can then analyse these in order to design a database which may answer these questions. Some are: Which year is Johann Schmidt in? (the school has students in years 7 to 13) Does Anita Nash have a sibling (brother or sister) in the school? Complete the data dictionary table below giving the field names which would be used in the database and identifying a validation check for each field. Field name Validation check Reference_number Year First_name None Explain the differences between verification and validation giving reasons why both are needed when data is entered into a database.

15. Proofing  →  15.2. Proofing techniques

7. The systems life cycle  →  7.2. Design

Open

15

For Examiner's Use 15 Floyd has purchased a laptop computer. He wants to use it for Internet banking. Explain why Floyd would need the following two items. Browser ISP Discuss the advantages and disadvantages to customers of using Internet banking rather than visiting the bank.

10. Communication  →  10.2. Effective use of the internet

6. ICT applications  →  6.6. Banking applications

6. ICT applications  →  6.9. Computers in the retail industry

Open

16

For Examiner's Use 16 Describe what is meant by a Wiki.

10. Communication  →  10.2. Effective use of the internet

7. The systems life cycle  →  7.5. Documentation

Open

17

There are a number of health and safety risks associated with using computers. For the three safety risks given below, describe a way in which each can be minimised. Electrocution Fire Tripping

5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment

8. Safety and security  →  8.1. Physical safety

Open

18

For Examiner's Use 18 There are many microprocessor-controlled devices in the modern home. Describe five effects of these devices on people’s lifestyles.

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

5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment

Open

19

Describe encryption and discuss the benefits and drawbacks of using it to make data secure.

8. Safety and security  →  8.3. Security of data

Open