---

---

1

This diagram shows a desktop computer. microphone mouse keyboard internal hard disk drive DVD drive pen drive screen speaker Name two input devices shown in the diagram above. Name two output devices shown in the diagram above. Name two storage devices shown in the diagram above.

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

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

Open

2

Tick the most appropriate method of inputting data for the following applications. Applications OMR  OCR  MICR  Reading data from bank cheques Reading data from candidate exam answer papers Inputting data ready for processing by a word processor Inputting pencil mark data from a school register

7. The systems life cycle  →  7.2. Design

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

6. ICT applications  →  6.10. Recognition systems

Open

3

Complete the table by identifying the most appropriate device for each use. Device Use printing on multipart stationery reading information from the front of bank cards making fileserver backup copies to read data from a product at a POS terminal

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

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

Open

4

Many young people use social networking sites. Tick whether the following statements are true or false. TRUE  FALSE  It is easy to keep in immediate contact with friends You can share photographs with friends You can do internet banking using a social networking site You can access everybody’s personal details

8. Safety and security  →  8.2. eSafety

10. Communication  →  10.2. Effective use of the internet

Open

5

Complete the sentences using words from the list below. The type of processing used when booking an airline ticket is called The type of access used on a magnetic tape is called An item of hardware which can read temperatures is called a online sensor OCR MICR serial batch motor

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

7. The systems life cycle  →  7.1. Analysis

Open

6

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 70 mm 20 mm 20 mm 35 mm 35 mm 15 mm NOT TO SCALE Start Finish Complete the set of instructions to draw this shape by filling in the blank lines. You will need to use a REPEAT loop after the turtle has moved the 70 mm. PEN DOWN FORWARD 20 LEFT 90 RIGHT 90 FORWARD 20 RIGHT 90 RIGHT 90 FORWARD 35

Open

7

A meal is to be cooked using a microprocessor controlled oven. Identify two variables which have to be pre-set before the cooking begins. Describe the role of the microprocessor in controlling the oven.

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

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

7. The systems life cycle  →  7.1. Analysis

Open

8

The English teacher stores details of her students’ exam scores in a spreadsheet. The exam is marked out of 80 and the results are typed into the Exam result column. A B C D Name Form Exam result Pass/Fail The teacher wants to use a validation check which only allows numbers between 0 and 80 to be typed in. What is the name of this type of validation check? She types in the following exam results to test that the validation works: 0, 25, 80 and 87. Using the data above write down one example of: normal data extreme data abnormal data The teacher decides that the pass mark for the exam should be 45. Depending on the number of marks each pupil gets, the word ‘Pass’ or the word ‘Fail’ will appear in the Pass/Fail column. Write down the formula which should appear in cell D2. Explain how she can replicate the formula in the 30 cells below D2. Give two reasons, apart from safety, why computer models are often used rather than the real thing.

20. Spreadsheets  →  20.1. Create a data model

7. The systems life cycle  →  7.2. Design

Open

9

Complete each sentence below using one item from the list. analysis a flowchart hacking a virus implementation data logging encryption a password the world wide web A program can be designed using Observing the current system in use is part of Gaining access to somebody else’s work without permission is called Reducing unauthorised access can be achieved by asking for

8. Safety and security  →  8.3. Security of data

7. The systems life cycle  →  7.1. Analysis

Open

10

Tick four benefits to banks of using ICT.  Higher charges can be made They have fewer bad risks Less paid out in wages as fewer staff need to be employed Lower costs as fewer buildings need to be rented A wider customer base is available Mistakes are never made Less actual cash handled so there are fewer robberies The initial cost of hardware is cheap

6. ICT applications  →  6.6. Banking applications

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

Open

11

A car manufacturer uses robots on its production line. Describe four disadvantages to the company of using robots to build cars. Identify two changes to the workers’ working environment that the use of robots has brought about.

6. ICT applications  →  6.3. Computer controlled systems

6. ICT applications  →  6.2. Modelling applications

Open

12

Tick two applications which use on-line processing.  Producing the payroll Producing utility bills Printing credit card statements Paying for goods using EFTPOS Processing bank cheques overnight A microprocessor controlled greenhouse

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

Open

13

A sports club uses a computer database to keep records of members in one file and records of the sport bookings in another file. Here is a record in the sport bookings file. Sport Venue Sport code Member number Football Sports Hall SHF10 The members file and the sport bookings file will be saved as separate tables. Describe other steps which would be required in order to create a relational database. Give two advantages of creating and using a relational database compared to using two flat files. Explain why a hard disk is used to store the data files. The member number varies between 500000 and 549999. All sport codes consist of three letters followed by two numbers. Name an appropriate validation check for each of the member number and the sport code. Do not use the same check twice. Member number Sport code When members make a booking, they will show their membership card which holds their details electronically. Name the device which will be used to input their details from the card. Give two reasons why this method is better than typing the number in. When the system was implemented the systems analyst gave some documentation to the sports club owner. Name three different items found in the user documentation. Name three different items in the technical documentation which are not present in the user documentation.

18. Databases  →  18.1. Create a database structure

7. The systems life cycle  →  7.1. Analysis

7. The systems life cycle  →  7.2. Design

Open

14

Describe the differences between an intranet and the Internet.

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

10. Communication  →  10.2. Effective use of the internet

Open

15

The use of microprocessor-controlled devices in the home affects an individual’s leisure time, social interaction and the need to leave the home. Give three advantages to the individual when microprocessor-controlled devices are used in the home. Give three disadvantages to the individual when microprocessor-controlled devices are used in the home.

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

6. ICT applications  →  6.3. Computer controlled systems

10. Communication  →  10.2. Effective use of the internet

Open

16

Describe three ways in which personal data held on computers can be misused. For each way explain a different method for helping to prevent it. Way 1 Method 1 Way 2 Method 2 Way 3 Method 3

8. Safety and security  →  8.3. Security of data

Open

17

RAM and ROM are part of Immediate Access Memory. Explain why computer systems have both backing storage and Immediate Access Memory.

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