---

---

1

For Examiner's Use Name the methods used to represent information on A, B, C and D using the words from the list. A B D C SECTION 1 A B C D E A B C D E A B C D E A B C D E A B C D E SECTION 2 A B C D E A B C D E A B C D E A B C D E A B C D E Bar code Chip DVD ROM Flash memory Graphics tablet Light pen Magnetic stripe Optical marks A B C D

6. ICT applications  →  6.10. Recognition systems

7. The systems life cycle  →  7.2. Design

15. Proofing  →  15.2. Proofing techniques

Open

2

Ring two items which are output devices. Buzzer Graphics tablet Joystick Monitor Optical character reader Web cam

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

1. Types and components of computer systems  →  1.1. Hardware and software

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

Open

3

Tick TRUE or FALSE next to each of these statements. TRUE FALSE Computer programs are examples of hardware An internet browser is an example of software A pointer is used to select items in a command line interface A PDA is larger than a desktop computer

1. Types and components of computer systems  →  1.1. Hardware and software

Open

4

For Examiner's Use Complete the following sentences using the most appropriate device from this list. A remote control A joystick A keyboard A chip reader A graphics tablet A microphone is used in the recording of voices for presentation software. is used to control a multimedia projector. is used to write a letter. is used to read information from a bank card. is used in a flight simulator.

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

1. Types and components of computer systems  →  1.1. Hardware and software

Open

5

Describe the role of a proxy server when a LAN is connected to the internet.

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

10. Communication  →  10.2. Effective use of the internet

Open

6

Susan uses a memory stick to transfer her work from school to home. Give three reasons why memory sticks are often preferred to CDs for storing work.

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

3. Storage devices and media  →  3.1. Storage devices

3. Storage devices and media  →  3.2. Storage media

Open

7

For Examiner's Use A floor turtle can use the following instructions: INSTRUCTION MEANING FORWARD n Move n mm forward BACKWARD n Move n mm backward LEFT t Turn left t degrees RIGHT t Turn right t degrees PENUP Lift the pen PENDOWN Lower the pen Start Finish Complete the set of instructions to draw this shape by filling in the blank lines. PEN UP FORWARD 50 RIGHT 90

Open

8

For Examiner's Use Describe what is meant by a blog and a wiki. Blog Wiki

10. Communication  →  10.2. Effective use of the internet

7. The systems life cycle  →  7.5. Documentation

Open

9

Tick TRUE or FALSE next to each statement to indicate if it is an example of online processing. TRUE FALSE Withdrawing money from an ATM Producing utility bills Booking a plane ticket Producing payslips

18. Databases  →  18.1. Create a database structure

Open

10

Describe the three types of test data: Normal Abnormal Extreme

7. The systems life cycle  →  7.3. Development and testing

Open

11

For Examiner's Use 11 The head teacher of a school wants to build a weather station. She wants to use a computer to collect the results Describe three reasons why she wants to use a computer rather than allow students to collect the results. The results will be stored in a spreadsheet. The head teacher wants a word processed report. The report will contain a description of the weather and will use the spreadsheet results. Describe how the report will be created. For Examiner's Use Spreadsheet data is often used for modelling purposes. Give three reasons other than reducing danger why computer models are sometimes used rather than the real thing.

6. ICT applications  →  6.2. Modelling applications

7. The systems life cycle  →  7.6. Evaluation

Open

12

For Examiner's Use 12 A supermarket uses POS terminals. The stock levels in the supermarket are updated automatically. Describe the steps involved in updating the stock level of a product when the bar code is read.

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

Open

13

For Examiner's Use 13 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 $2.30 $2.90 $0.60 $73.80 Squarebranch Chocolate bar $0.75 $0.95 $0.20 $31.60 Roofs Beefburgers $1.25 $1.55 $0.30 $40.50 Kapats Gravy $3.20 $3.95 $0.75 $66.75 Startle Yoghurt cream $1.50 $1.85 $0.35 $41.65 Total in stock Overall profit $254.30 Give the cell reference of the cell that contains 158. Give the cell reference of a cell that contains a label. Write down the formula in cell F5. Write down the formula in cell G2. Formulae similar to that used in cell G2 have been used in cells G3 to G6. These were not typed. Describe how these were entered.

20. Spreadsheets  →  20.1. Create a data model

Open

14

For Examiner's Use 14 John owns a small company. He wishes to replace the existing computerised system with a new one. He has employed a systems analyst, Iqbal, to plan this. Iqbal will need to collect information about the existing system. Describe three methods he could use to do this. Iqbal has completed the Analysis of the existing system. Describe three items of file structure which he would need to design for the new system. For Examiner's Use After a system is designed it will be implemented. Describe each of the following methods of implementation. Direct changeover Parallel running Phased implementation Pilot running

7. The systems life cycle  →  7.1. Analysis

7. The systems life cycle  →  7.4. Implementation

Open

15

For Examiner's Use 15 OMR, OCR and MICR are methods of direct data entry. Describe each method, giving an example of an application where each might be used. OMR OCR MICR

6. ICT applications  →  6.10. Recognition systems

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

Open

16

For Examiner's Use 16 A company uses robots to manufacture cars. Give three advantages to the company of using robots rather than humans to manufacture cars. Give three disadvantages to the company of using robots rather than humans to manufacture cars.

6. ICT applications  →  6.3. Computer controlled systems

6. ICT applications  →  6.2. Modelling applications

10. Communication  →  10.2. Effective use of the internet

Open

17

Jasvir and her family have three computers in their home. She wants to connect the computers to create a network and access the internet. List four additional items she would need to set up this system. Your answers must include hardware and software.

4. Networks and the effects of using them  →  4.2. Network issues and communication

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

7. The systems life cycle  →  7.1. Analysis

Open

18

For Examiner's Use 18 An automatic washing machine is controlled by a microprocessor. Other than a temperature sensor, name two sensors used in the machine. Explain why computers are unable to read the data directly from these sensors and name the device which would enable them to do so. Describe how the microprocessor uses data from the temperature sensor.

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

1. Types and components of computer systems  →  1.1. Hardware and software

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

Open

19

For Examiner's Use 19 Describe two methods of data verification.

15. Proofing  →  15.2. Proofing techniques

Open