---

---

1

For Examiner's Use Name the devices A, B, C and D using the words from the list. A B C D CRT Monitor desktop computer laptop computer mainframe computer microphone multimedia projector personal digital assistant printer 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

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

Open

2

Ring two items which are used to store data. buzzer DVD R fixed hard disc joystick plotter touch pad

3. Storage devices and media  →  3.1. Storage devices

3. Storage devices and media  →  3.2. Storage media

Open

3

For Examiner's Use Tick True or False next to each of these statements. True False Database software is the best software to use to write letters. DTP software is used to create models. Palmtop computers are bigger than PCs. Graph plotters are used to output car designs. A dot matrix printer is used to print magazines.

15. Proofing  →  15.1. Software tools

Open

4

An examination mark is recorded as an integer in a database. The marks are between 0 and 100. Name and describe two validation checks which would be used to check the marks as they are entered.

7. The systems life cycle  →  7.2. Design

15. Proofing  →  15.2. Proofing techniques

15. Proofing  →  15.1. Software tools

Open

5

Tick whether the following statements apply to RAM or apply to ROM. RAM ROM This memory can only be read from not written to. This memory is not volatile. This memory is used to store the data the user is currently working on. This memory is used to store the startup instructions of a computer.

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

6

For Examiner's Use Draw four lines on the diagram to match the use to its most appropriate input device. Use Input device To input details from a bank card Joystick To input data from a school register Chip reader To input details of a product in a supermarket Optical mark reader To control an object in a computer game Bar code reader

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

A student wishes to use a floor turtle to draw this shape which has no two lines the same length: Name four different instructions which the turtle graphics software could use in order to draw the shape. For each one explain the meaning of the instruction. Instruction 1 Meaning Instruction 2 Meaning Instruction 3 Meaning Instruction 4 Meaning

20. Spreadsheets  →  20.1. Create a data model

Open

8

For Examiner's Use Explain what is meant by OCR and give one example of its use.

6. ICT applications  →  6.10. Recognition systems

Open

9

A head teacher has decided that the school magazine will now be included in the school’s website. Tick three features of a website which would not be found in a magazine printed on paper.
Hyperlinks Colour Large font size Photos Sound Video Give three other reasons why the head teacher thinks it is a good idea to replace the paper version with a website version.

10. Communication  →  10.2. Effective use of the internet

21. Website authoring  →  21.2. Create a web page

Open

10

For Examiner's Use 10 Describe what is meant by a blog.

10. Communication  →  10.2. Effective use of the internet

Open

11

Car mechanics often use an expert system to help them with their work in diagnosing car engine faults. Describe how this system would work.

6. ICT applications  →  6.8. Expert systems

Open

12

For Examiner's Use 12 A house has a microprocessor controlled central heating system. Describe the use of the following input devices in such a system. Keypad Sensor Describe how the microprocessor would use the data from these devices to control the system.

7. The systems life cycle  →  7.1. Analysis

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

Open

13

For Examiner's Use 13 Davina has asked Boris, a systems analyst, to create a new database system for her zoo. She keeps animals of all types. Here are some of the questions that visitors to the zoo ask: What is the name of the female lion you have? How heavy is Jumbo the elephant? How much does it cost to adopt a tiger? Complete the data dictionary below filling in the field names and most appropriate data type to create a database which would answer these questions. Field name Data type Name Text Species Weight Currency Boris will provide two types of documentation when the system is implemented. Name each type of documentation and for each one give two items which would be included. Name Item 1 Item 2 Name Item 1 Item 2

7. The systems life cycle  →  7.2. Design

18. Databases  →  18.1. Create a database structure

Open

14

For Examiner's Use 14 Mobile phones are used for accessing the Internet. Give two advantages and two disadvantages of using a mobile phone rather than using a desktop computer to access the Internet. Advantage 1 Advantage 2 Disadvantage 1 Disadvantage 2

10. Communication  →  10.2. Effective use of the internet

6. ICT applications  →  6.1. Communication

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

Open

15

For Examiner's Use 15 A Sports Science student had to analyse the performance of athletes prior to the 2012 Olympic Games. He created a spreadsheet to do this. Below is his analysis of the javelin event. It is split into two sheets. Sheet 1 contains the Code for each nationality. Sheet 2 contains a list of athletes and the results they achieved in a pre-Olympic event. A B Code Country AUS Australia FRA France GHA Ghana RUS Russia THA Thailand TUN Tunisia TUR Turkey USA America Sheet 1 (Commas are used as delimiters in the functions shown below.) Because athletes sometimes miss a throw or throw outside the area, this is recorded in the spreadsheet as a no throw using the letters NT. A B C D E F G H Country Athlete Code Throw Throw Throw Total Number thrown of throws =LOOKUP(C3,Sheet1!$A$2:$B$9) Chevonne Baines USA 85.02 73.29 76.9 =SUM(D3:F3) =COUNTIF(D3:F3,”<>NT”) =LOOKUP(C4,Sheet1!$A$2:$B$9) Mary Bempe GHA NT 66.64 70.61 =SUM(D4:F4) =COUNTIF(D4:F4,”<>NT”) =LOOKUP(C5,Sheet1!$A$2:$B$9) Rhiannon Jones USA 81.22 68.4 71.18 =SUM(D5:F5) =COUNTIF(D5:F5,”<>NT”) =LOOKUP(C6,Sheet1!$A$2:$B$9) Abhasra Boonme THA 83.04 76.43 60.35 =SUM(D6:F6) =COUNTIF(D6:F6,”<>NT”) =LOOKUP(C7,Sheet1!$A$2:$B$9) Jean Claude Devandre FRA 68.04 45.98 62.62 =SUM(D7:F7) =COUNTIF(D7:F7,”<>NT”) =LOOKUP(C8,Sheet1!$A$2:$B$9) Brett Lewis AUS 79.98 68.78 NT =SUM(D8:F8) =COUNTIF(D8:F8,”<>NT”) =LOOKUP(C9,Sheet1!$A$2:$B$9) Vera Stepanov RUS 70.42 49.88 90.18 =SUM(D9:F9) =COUNTIF(D9:F9,”<>NT”) =LOOKUP(C10,Sheet1!$A$2:$B$9) Murat Mehmet TUR 49.81 67.51 53.66 =SUM(D10:F10) =COUNTIF(D10:F10,”<>NT”) =LOOKUP(C11,Sheet1!$A$2:$B$9) Joan Lewington USA 88.85 NT 69.44 =SUM(D11:F11) =COUNTIF(D11:F11,”<>NT”) =LOOKUP(C12,Sheet1!$A$2:$B$9) Youssef Ibrahim TUN 93.39 63.1 47.14 =SUM(D12:F12) =COUNTIF(D12:F12,”<>NT”) =LOOKUP(C13,Sheet1!$A$2:$B$9) Laura Bennett AUS 55.97 49.45 70.07 =SUM(D13:F13) =COUNTIF(D13:F13,”<>NT”) Sheet 2 Explain what the function in cell A3 does. For Examiner's Use What value would you expect to see in cell A6? Explain what the function in cell G3 does. Explain what the function in cell H4 does. What value would you expect to see in cell H6? Spreadsheets are often used to produce computer models. There are however, other forms of models such as simulations. Explain, using air pilot training as an example, what is meant by simulation.

20. Spreadsheets  →  20.1. Create a data model

Open

16

For Examiner's Use 16 School networks often contain a router and a proxy server. Describe the role of a proxy server in such a network. Explain the purpose of a router.

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

Open

17

Explain what is meant by software copyright. Explain how software manufacturers attempt to prevent copyright being broken.

9. Audience  →  9.2. Copyright

8. Safety and security  →  8.3. Security of data

Open

18

For Examiner's Use 18 Robots are now used on many car production lines. Discuss the benefits and drawbacks to the car company of using robots.

6. ICT applications  →  6.3. Computer controlled systems

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

Open