---

---

1

For Examiner's Use Name the input devices A, B, C and D using the words from the list. A B C D TOTAL ENTER keyboard microphone remote control scanner sensor touch pad touch screen video camera A B C D

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

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

Open

2

Ring two output devices. buzzer DVD R joystick magnetic tape plotter touch pad

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

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

Open

3

For Examiner's Use Tick True or False next to each of these statements. True False A numeric keypad is used to type a letter. Word processing software is used to monitor physical variables. A laser printer works best in an industrial environment. A palmtop computer is easier to carry than a laptop computer. Sensors are used to input data to a microprocessor.

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

6. ICT applications  →  6.10. Recognition systems

6. ICT applications  →  6.7. Computers in medicine

Open

4

Tick four devices which are used to connect networks together.
Hub Printer Bridge Router Scanner Passwords Monitor Switch

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

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

Open

5

Microprocessors are used in different applications to control the process or to simply gather data (measurement only). Tick which of the following applications are examples of control or of measurement only. Control Measurement only Automatic cookers Weather stations Microwave ovens Automatic washing machines

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

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

Open

6

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 REPEAT n Repeat the following instructions n times END REPEAT Finish the REPEAT loop Start Finish 40 mm 70 mm 50 mm 80 mm 60° NOT TO SCALE Using only the following commands, complete the set of instructions to draw this shape by filling in the blank lines. PENDOWN FORWARD REPEAT RIGHT FORWARD FORWARD

Open

7

For Examiner's Use Use the most appropriate phrase from the list below to complete each sentence. store data in real time applications store high definition films store backups of file servers store music for sale store photographs in a digital camera A CD ROM is used to A blu-ray disc is used to A magnetic tape is used to A flash memory card is used to

3. Storage devices and media  →  3.2. Storage media

3. Storage devices and media  →  3.1. Storage devices

Open

8

Describe four features of ROM.

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

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

Open

9

For Examiner's Use Robots are now used on many car production lines. Describe three advantages of this to a car company.

6. ICT applications  →  6.3. Computer controlled systems

Open

10

Car mechanics often use expert systems to help them to diagnose faults with car engines. Tick four components of a typical expert system.
Graph plotter Inference engine Interactive input screen Knowledge base Rules base Scanner Spreadsheet Web cam Name two other applications which involve the use of expert systems.

6. ICT applications  →  6.8. Expert systems

Open

11

For Examiner's Use 11 Give three advantages of using a graphical user interface (GUrather than a command line interface (CL.

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

6. ICT applications  →  6.3. Computer controlled systems

Open

12

For Examiner's Use 12 A company wishes to replace its current system with a new computerised system. It has employed a systems analyst to investigate the current system. Describe three methods the systems analyst could use to research the current system. When large volumes of data are input to a new system it is usual to carry out verification and validation on this data. Name and describe two methods of verification which could be used. Name Description Name Description Explain why it is necessary to carry out validation even though the data has been verified.

7. The systems life cycle  →  7.1. Analysis

7. The systems life cycle  →  7.6. Evaluation

Open

13

For Examiner's Use 13 A bank is looking into a variety of security measures to protect its customers’ data. It is worried that hackers may gain access and cause viruses to infect the system. Explain what is meant by a virus and what it does. Describe three ways in which a bank customer could protect their computer from becoming infected. Way 1 Way 2 Way 3

8. Safety and security  →  8.3. Security of data

Open

14

For Examiner's Use 14 The manager of a travel company asked her secretary to look into the reliability of trains in Birmingham. The secretary obtained the details of some of the trains. He created two spreadsheets to help him do this. Sheet 1 is a list of some of the UK stations that trains from Birmingham go to. Sheet 2 consists of the train details he looked at. A B Code Station E Edinburgh LB Longbridge B Bournemouth LI Lichfield S Shrewsbury W Wolverhampton LO London P Plymouth Sheet 1 (Commas are used as delimiters in the functions shown below.) A B C D Arrival Station Code Number =VLOOKUP(B2,Sheet1!$A$2:$B$9,2) E =COUNTIF($C$9:$C$18,B2) =VLOOKUP(B3,Sheet1!$A$2:$B$9,2) LO =COUNTIF($C$9:$C$18,B3) =VLOOKUP(B4,Sheet1!$A$2:$B$9,2) S =COUNTIF($C$9:$C$18,B4) =VLOOKUP(B5,Sheet1!$A$2:$B$9,2) LI =COUNTIF($C$9:$C$18,B5) =VLOOKUP(B6,Sheet1!$A$2:$B$9,2) W =COUNTIF($C$9:$C$18,B6) Arrival time Minutes late Arrival code Late Y/N 11:03 E =IF(B9>0,"Y","N") 11:05 LO =IF(B10>0,"Y","N") 11:07 -4 W =IF(B11>0,"Y","N") 11:10 LO =IF(B12>0,"Y","N") 11:12 S =IF(B13>0,"Y","N") 11:14 -2 LI =IF(B14>0,"Y","N")

20. Spreadsheets  →  20.1. Create a data model

Open

15

( 0, , ) 11:16 W =IF(B15>0,"Y","N")

Open

16

( 5 0, , ) 11:19 -3 LO =IF(B16>0,"Y","N")

Open

17

O ( 6 0, , ) 11:22 LI =IF(B17>0,"Y","N")

Open

18

( 0, , ) 11:25 E =IF(B18>0,"Y","N") Sheet 2 For Examiner's Use Explain what the function in cell A2 in Sheet 2 does. What station would you expect to see in cell A3 in Sheet 2? Explain what the function in cell C2 in Sheet 2 does. What value would you expect to see in cell C4 in Sheet 2? Explain what the function in cell D9 in Sheet 2 does. What value would you expect to see in cell D11 in Sheet 2? For Examiner's Use 15 Chi has employed Sarbjit, a systems analyst, to create a new database system for his mobile telephone business. • He keeps a number of different models in stock. • Most of the phones have a camera but some do not. • The rental plans have 100, 200 or 500 free texts depending on the amount the customer pays per month. • The minimum monthly payment is $10 and the maximum is $100. Complete the data dictionary below filling in the field names and the most appropriate data types to create a database using only the above information. Field name Data type Model Monthly payment Name and describe three different validation checks that could be used on the data in this database.

20. Spreadsheets  →  20.1. Create a data model

Open