---

---

1

For Examiner's Use Name the input devices A, B, C and D using the words from the list. A B C D digital camera microphone number pad remote control scanner touch pad trackerball web cam 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 items which are used for storing data. buzzer DVD R joystick magnetic tape plotter touch pad

3. Storage devices and media  →  3.2. Storage media

3. Storage devices and media  →  3.1. Storage devices

Open

3

Tick True or False next to each of these statements. True False A scanner is used to enter a PIN Word processing software is used to write letters Database software is used to create newspapers A command line interface uses icons to represent applications Sensors are used to monitor physical variables

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

18. Databases  →  18.1. Create a database structure

15. Proofing  →  15.1. Software tools

Open

4

For Examiner's Use A test is marked out of 20 and recorded as an integer. Tick whether each of the following marks is an example of abnormal data or extreme data. Abnormal Extreme twenty

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

20. Spreadsheets  →  20.3. Present data

18. Databases  →  18.3. Present data

Open

5

Name three network devices and for each one describe what it does. Name Description Name Description Name Description

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

6

Tick which of the following statements apply to traditional LANs and which apply to WLANs. LANs WLANs Uses wireless technology to transmit data Faster transmission of data Greater security Is cheaper as there is less cabling

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

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 REPEAT n Repeat the following instructions n times END REPEAT Finish the REPEAT loop 60° 45° 80 mm 100 mm 200 mm Start NOT TO SCALE Complete the set of instructions to draw this shape by filling in the blank lines. PENDOWN FORWARD RIGHT PENDOWN REPEAT REPEAT LEFT PENUP

Open

8

For Examiner's Use Use the most appropriate phrase from the list below to complete the sentences. retouch photographs. print out photographs. input candidate examination answers. input data from a magnetic stripe. store high definition copies of movies. open windows in a greenhouse. input data from a chip. input temperature in a microprocessor controlled greenhouse. A blu-ray disc is used to A graphics tablet is used to An inkjet printer is used to A motor is used to An Optical Mark Reader is used to

7. The systems life cycle  →  7.2. Design

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

7. The systems life cycle  →  7.1. Analysis

Open

9

Explain why computer systems have both backing storage and RAM.

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

Open

10

For Examiner's Use 10 Below is a diagram of a river running past a chemical factory. The same types of sensor, connected to a computer in the factory are placed at A and B to monitor pollution of the river by the factory. A B Factory Name three sensors which would need to be placed at both A and B. Describe how the computer would monitor the level of pollution in the river.

7. The systems life cycle  →  7.1. Analysis

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

Open

11

For Examiner's Use 11 Doctors often use expert systems to help them to diagnose illnesses. Name four components of a typical expert system. Name two other applications which involve the use of expert systems.

6. ICT applications  →  6.8. Expert systems

Open

12

Name and describe three validation checks which could be carried out on a 16-digit credit card number when it is typed into a computer. Name Description Name Description Name Description

7. The systems life cycle  →  7.2. Design

15. Proofing  →  15.2. Proofing techniques

Open

13

For Examiner's Use 13 Describe how the following health problems can arise due to the use of computers. Give a different cause for each. RSI in the wrists RSI in the fingers Headaches Back pain

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

6. ICT applications  →  6.7. Computers in medicine

Open

14

For Examiner's Use 14 A bank is looking into a variety of security measures to protect its customers’ data. Describe three types of authentication technique they could use and for each give a benefit and a drawback. Technique 1 Benefit Drawback Technique 2 Benefit Drawback Technique 3 Benefit Drawback

8. Safety and security  →  8.3. Security of data

Open

15

For Examiner's Use 15 Gita has employed Johann, a systems analyst, to create a new database system for her car sales business. She only sells cars made by Rock and only the models Feisty, Mendo and Galactica in red, blue or gold. Most of the cars have air conditioning but some do not. She sells 3, 4 and 5 door cars. Give a reason why would it not be sensible to have a Make field in the database. Complete the design table below giving the field names which would be used in the database and describing the most appropriate validation check which could be carried out on each field. Field name Validation check Model For Examiner's Use Discuss verification and validation.

7. The systems life cycle  →  7.2. Design

15. Proofing  →  15.2. Proofing techniques

15. Proofing  →  15.1. Software tools

Open

16

For Examiner's Use 16 A travel agent keeps a spreadsheet record of his customers’ holiday bookings to various destinations. This is split into two sheets. Sheet 1 contains the Code for each destination. Sheet 2 contains a list of his customer bookings so far. A B Code Destination BAH Bahamas COZ Cozumel EGY Egypt IND India MAL Maldives MEX Mexico Sheet 1 (Commas are used as delimiters in the functions shown below.) A B C Destination Code Trips =VLOOKUP(B2,Sheet1!$A$2:$B$7,2,0) BAH =COUNTIF($A$8:$A$18,B2) =VLOOKUP(B3,Sheet1!$A$2:$B$7,2,0) EGY =COUNTIF($A$8:$A$18,B3) =VLOOKUP(B4,Sheet1!$A$2:$B$7,2,0) MAL =COUNTIF($A$8:$A$18,B4) =VLOOKUP(B5,Sheet1!$A$2:$B$7,2,0) MEX =COUNTIF($A$8:$A$18,B5) Destination code of holidays booked so far this year EGY MAL BAH MEX MAL BAH EGY EGY MAL EGY BAH Sheet 2 For Examiner's Use Explain what the function in cell A2 in Sheet 2 does. What destination would you expect to see in cell A4 in Sheet 2? Explain what the function in cell C2 in Sheet 2 does. What value would you expect to see in cell C3 in Sheet 2? For Examiner's Use Spreadsheets are often used to produce computer models. Discuss the benefits and drawbacks of computer modelling.

20. Spreadsheets  →  20.1. Create a data model

Open