---

---

1

Name the items A, B, C and D using the words from the list. A B C D Desktop computer Dot matrix printer Graph plotter Hard disc Inkjet printer Laptop computer Optical disc Trackerball A B C D

1. Types and components of computer systems  →  1.4. Types of computer

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

Open

2

Identify two devices which are used in control systems to output data.

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

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

Open

3

Give two advantages of a fixed magnetic hard disc compared to an optical disc to store data.

3. Storage devices and media  →  3.1. Storage devices

3. Storage devices and media  →  3.2. Storage media

Open

4

Tick True or False next to each of these statements. True False OMR is used to read data from multi choice question papers. OCR is used to read data from word processed documents. DTP is used to create financial models. Regular use of computers improves your eyesight.

6. ICT applications  →  6.10. Recognition systems

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

Open

5

Tick two changes which have occurred in libraries due to the introduction of computers.
Fewer books can be borrowed. Libraries can stay open longer. Information about books is more easily available to borrowers. More people work at the library. Nobody borrows books any more. The librarian is automatically notified when books are late.

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 Start Finish 15 mm 15 mm 15 mm 50 mm 65 mm 65 mm NOT TO SCALE Complete the set of instructions to draw this shape by filling in the blank lines. The turtle is facing up at the start. PENDOWN LEFT 90 FORWARD 15

Open

7

A History teacher uses a spreadsheet to record the exam scores of her students. The spreadsheet below shows the exam scores of some of those pupils. A B C D E F Exam 1 Exam 2 Exam 3 Total Joanne Iqbal Rajvinder Sven Highest mark Write down the formula which should go in cell E3. = Write down the formula which should go in cell B8. =

20. Spreadsheets  →  20.1. Create a data model

Open

8

Many homes in cold climate areas use microprocessor controlled central heating systems. Name two input devices used in such a system. Input device 1 Input device 2 Describe the processing which takes place.

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

9

Students are using questionnaires to find information about workers at a company. They are going to construct a database to store the results. Each worker at the company has an individual works number which starts with a letter and has 6 digits e.g. A123456. Below is part of a questionnaire which some students have created to collect the results. 1. What is your works number? Company survey 2. Do you use a car to drive to work? YES/NO 3. How many hours per week do you work? Name a suitable data type for the answer to: Question 1 Question 2 Question 3 Name the validation check which would be most suitable to ensure that data entered for question 1 of the questionnaire is acceptable.

7. The systems life cycle  →  7.2. Design

15. Proofing  →  15.1. Software tools

Open

10

The Geography teacher in a school has set up an automatic weather station connected to a computer. Name three physical variables which will be measured by sensors. Explain why the computer is unable to read the data directly from the sensors. Name the device that is needed to enable it to do so. Give three advantages to the Geography department of having a computerised weather system rather than a manual weather system.

7. The systems life cycle  →  7.1. Analysis

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

Open

11

A company is going to replace its existing computer system with a new one. Put the following steps into the correct order that the systems analyst would follow. Implement the new system. Develop the new system. Collect information about the existing system. Evaluate the new system. Design a file structure.

7. The systems life cycle  →  7.1. Analysis

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

Open

12

Some students at a school want to produce a multimedia presentation to advertise a school play. Tick two types of data which can be used in a multimedia presentation that cannot be used in a hard copy document.
Text Integers Sound Decimal numbers Video Graphics The pupils want to record themselves speaking. Their voices will be added to the presentation. They will need to listen to their voices to make sure the presentation is of good quality. Name two devices which they will need to use to do this. Another group of students are producing a hard copy brochure for the event. These students will need to prepare material to include in this document. Name two types of software they might use and for each, write down what they would use it for. Software 1 Use Software 2 Use

19. Presentations  →  19.1. Presentation creation

Open

13

Most school computer networks have a router and switches. Explain what is meant by a switch. Describe the purpose of a router.

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

Open

14

Banks keep their customer account records on their file servers. Describe three ways in which hackers could misuse this data. Describe the purpose of three different authentication techniques.

8. Safety and security  →  8.3. Security of data

Open

15

A school wants to buy some new computers. Some of the computers they buy will be networked and others will be standalone computers which will not be networked. Describe two advantages of using networked computers. Describe three disadvantages of using networked computers. Eventually the school will use sets of networked Wifi laptops and cabled desktop computers which will also be networked. Discuss the advantages and disadvantages of using these laptop computers compared with using cabled desktop computers.

1. Types and components of computer systems  →  1.4. Types of computer

10. Communication  →  10.2. Effective use of the internet

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

Open

16

Discuss the advantages and disadvantages to customers of Internet shopping compared to visiting stores to do their shopping.

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

10. Communication  →  10.2. Effective use of the internet

Open

17

A car company has decided to develop an expert system to help mechanics with their diagnoses of car faults. Describe steps required in the analysis and design of such a system. Name two other applications which involve the use of expert systems.

6. ICT applications  →  6.8. Expert systems

Open

18

Many workers now use computers a lot in their work and this can cause them to suffer from RSI. Name two other possible health problems and for each one describe a different precaution which could be taken to help prevent it. Health problem 1 Precaution Health problem 2 Precaution

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

8. Safety and security  →  8.1. Physical safety

Open

19

Paula, a systems analyst, has created a computer system to keep records in a small pharmacy. Identify three types of test data she could use to test the system. The system will now be implemented. Apart from speed of implementation, describe one benefit and one drawback of using the direct changeover method for the pharmacy. Benefit Drawback The pharmacist will be able to search for details of medicines using the database software. Describe four other database features which will help the pharmacist.

7. The systems life cycle  →  7.1. Analysis

6. ICT applications  →  6.7. Computers in medicine

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

Open