---

---

1

For Examiner's Use Name the items A, B, C and D using the words from the list. C D A B digital camera flash memory card joystick magnetic disc magnetic stripe scanner touch pad web cam A B C D

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

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

3. Storage devices and media  →  3.2. Storage media

Open

2

Ring two items which are output devices. CRT monitor DVD ROM magnetic tape number pad plotter trackerball

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

3. Storage devices and media  →  3.1. Storage devices

Open

3

For Examiner's Use Tick True or False next to each of these statements. True False Control software is used to create slide shows. Palmtop computers do not have internal DVD drives. Presentation software can be used to produce databases. An internet browser uses an inference engine. Motors are output devices.

15. Proofing  →  15.1. Software tools

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

3. Storage devices and media  →  3.1. Storage devices

Open

4

Complete each sentence below using one item from the list. A bar code reader A dot matrix printer A graphics tablet A laser printer A microphone A multimedia projector A presence check A speaker A temperature sensor A magnetic tape produces hard copy in harsh conditions. inputs sounds. is used to show slideshows. is a validation rule. is used to create backups from a server’s hard disc.

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

5

For Examiner's Use The head teacher of a school wants to build a weather station. She wants to use a computer to collect the results. List three sensors that would be needed.

7. The systems life cycle  →  7.1. Analysis

Open

6

Draw four lines on the diagram to match the use to its most appropriate input device. Use Input device to select options from a list keyboard to type data into a database optical mark reader to input candidate examination answers chip reader to input data directly from a bank card mouse

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

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 72° 90° 50 mm 60 mm 80 mm Start NOT TO SCALE Complete the set of instructions to draw this shape by filling in the blank lines. PENDOWN BACKWARD PENDOWN REPEAT FORWARD RIGHT PENUP

Open

8

For Examiner's Use Tick True or False next to each statement describing encryption. True False Encryption prevents hackers from understanding the data. Encryption destroys viruses. Encryption prevents unauthorised access to computer systems. Encryption is the scrambling of data.

8. Safety and security  →  8.3. Security of data

Open

9

A group of car mechanics wants to have an expert system to help them with their work in diagnosing car engine faults. Describe how such a system would be created.

6. ICT applications  →  6.8. Expert systems

Open

10

For Examiner's Use 10 Describe online processing of data, using the booking of airline tickets as an example.

6. ICT applications  →  6.5. Booking systems

15. Proofing  →  15.2. Proofing techniques

Open

11

A manager of a new company has just purchased some computers. She wishes to connect these computers together to form a LAN. Name and describe three network devices she might need to have in order to achieve this. Device 1 Description Device 2 Description Device 3 Description

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

Open

12

For Examiner's Use 12 Chi has asked Toby, a systems analyst, to create a new database system for his property agency in France. He only deals with apartments and houses. Here are some of the questions customers ask: Have you got a house for less than €500 000? Have you got an apartment with three bedrooms? Have you got a house with more than 160 square metres floor space? Complete the design table below filling in the field names and the most appropriate data types to create a database which would answer these questions. Field name Data type Integer Price Compare and contrast parallel running and direct changeover as ways of implementing the new database system.

18. Databases  →  18.1. Create a database structure

Open

13

For Examiner's Use 13 A teacher has developed a new system for keeping a record of student examination marks on her laptop and wishes to test it. Each examination is marked out of 50. Identify three types of test data she could use and describe each type using an example. Type 1 Description Type 2 Description Type 3 Description

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

Open

14

Schools are concerned with the possibility that students are using the schools’ internet connections to access undesirable sites. Name and describe two security methods the schools could use to prevent this from happening. Method 1 Description Method 2 Description

8. Safety and security  →  8.3. Security of data

10. Communication  →  10.2. Effective use of the internet

8. Safety and security  →  8.2. eSafety

Open

15

For Examiner's Use 15 Paul, a manufacturer of goods, offers discounts. The discounts are coded D, N or P. Paul keeps the details on this spreadsheet. (Commas are used as delimiters in the formulae shown below.) A B C D Code Rate D 10% N 15% P 20% Code Price Discount Discounted Price D $4.00 =IF(A7="D",B7*$B$2,IF(A7="N",B7*$B$3,IF(A7="P",B7*$B$4))) P $2.85 =IF(A8="D",B8*$B$2,IF(A8="N",B8*$B$3,IF(A8="P",B8*$B$4))) D $1.55 =IF(A9="D",B9*$B$2,IF(A9="N",B9*$B$3,IF(A9="P",B9*$B$4))) N $0.98 =IF(A10="D",B10*$B$2,IF(A10="N",B10*$B$3,IF(A10="P",B10*$B$4))) D $4.05 =IF(A11="D",B11*$B$2,IF(A11="N",B11*$B$3,IF(A11="P",B11*$B$4))) D $10.00 =IF(A12="D",B12*$B$2,IF(A12="N",B12*$B$3,IF(A12="P",B12*$B$4))) P $11.95 =IF(A13="D",B13*$B$2,IF(A13="N",B13*$B$3,IF(A13="P",B13*$B$4))) D $5.15 =IF(A14="D",B14*$B$2,IF(A14="N",B14*$B$3,IF(A14="P",B14*$B$4))) D $5.25 =IF(A15="D",B15*$B$2,IF(A15="N",B15*$B$3,IF(A15="P",B15*$B$4))) N $4.50 =IF(A16="D",B16*$B$2,IF(A16="N",B16*$B$3,IF(A16="P",B16*$B$4))) N $7.25 =IF(A17="D",B17*$B$2,IF(A17="N",B17*$B$3,IF(A17="P",B17*$B$4))) N $14.50 =IF(A18="D",B18*$B$2,IF(A18="N",B18*$B$3,IF(A18="P",B18*$B$4))) Explain what the formula in cell C7 does. What value would you expect to see in cell C12? For Examiner's Use The formula was entered into cell C7 using a keyboard. Explain how to make this formula appear in cells C8 to C18 by just using a mouse. What formula should be typed into cell D7 to calculate the discounted price? Paul could extend this spreadsheet to calculate his total profit. He could then use it as a model. Give two reasons why financial models are used.

20. Spreadsheets  →  20.1. Create a data model

Open

16

Describe four features of a graphical user interface (GU.

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

7. The systems life cycle  →  7.5. Documentation

Open

17

For Examiner's Use 17 A head teacher wishes to publicise school activities to make his school better known in the neighbourhood. He could do this by using the school’s website or producing a magazine using DTP to be delivered by hand. Discuss the advantages and disadvantages of each method.

10. Communication  →  10.2. Effective use of the internet

7. The systems life cycle  →  7.1. Analysis

Open

18

For Examiner's Use 18 Robots are now used on many car production lines. Describe how their use has affected the nature of employment in the car industry.

6. ICT applications  →  6.3. Computer controlled systems

1. Types and components of computer systems  →  1.5. Emerging technologies

Open