---

---

1

Tick the four most accurate statements referring to dynamic and static data. Dynamic data is data that does not change. Data that is read from and not written back to a file is called static data. Data stored on a CD ROM is an example of dynamic data. Data on a web page that is updated from time to time is an example of dynamic data. It is very difficult to add information to a static information source after it has been created. There is a limited amount of information in a dynamic information source compared to a static one. Dynamic information sources are never checked for accuracy. A static information source can have information updated quickly. The data in a static data source is always up to date. There can be many contributors to a dynamic data source so the information can be inaccurate.

1. Data processing and information  →  1.1. Data and information

Open

2

Tick the four most accurate statements referring to hardware and software. Compilers and linkers are examples of system software. Device drivers and interpreters are examples of application software. Word processing and spreadsheets are examples of hardware. Software is another name for computer programs. Software is written in machine code before being converted to high-level language. Viruses are a type of software. Malicious bots are a type of hardware. System software directly operates the computer hardware. Operating systems are types of hardware. A mouse and keyboard are the basic software components of a computer.

2. Hardware and software  →  2.2. System software

Open

3

The secretary of a company is transferring workers’ records from paper to a new computer database. She wishes to make sure the data in the database is accurate. To check the data she is using verification and validation. Using an example, or otherwise, explain why she is using validation as well as verification.

1. Data processing and information  →  1.4. Checking the accuracy of data

Open

4

Many personal computers are bought with certain types of software already installed. This includes a number of items of utility software. Describe how each of the following utilities carries out its function. Anti-virus software Backup software Disk defragmentation software

2. Hardware and software  →  2.3. Utility software

Open

5

Computer controlled traffic lights are used to control traffic flow in major cities. Identify three input devices which could be used and describe their use in such a system. Device 1 Use Device 2 Use Device 3 Use

3. Monitoring and control  →  3.2. Control technologies

1. Data processing and information  →  1.5. Data processing

Open

6

Many computer users often confuse the terms the ‘internet’ and the ‘World Wide Web’. Explain what is meant by the term the ‘World Wide Web’.

14. Communications technology  →  14.6. Network protocols

Open

7

A managing director of a company supervises other directors. Each director has three departments they are responsible for. Each department has several workers. The company stores information about all its workers in a hierarchical database. Explain what is meant by a hierarchical database management system and describe how such a system would be used to store the workers’ data.

10. Database and file concepts  →  10.4. File and data management

Open

8

Here is a spreadsheet showing the prices of various toys in a shop. The discounted price is found by using a VLOOKUP formula in cells E8:E13. Discount code A 20% 15% 10% Price Discounted price Number sold $45 $35 $55 $50 $40 $30 $36.00 $28.00 $49.50 $42.50 $32.00 $25.50 B C A A C B A B Elephant Cheetah Giraffe Lion Leopard Zebra A B C D E F E G H Toy E8 fx ✘ =D8-(VLOOKUP(C8,$C$3:$D$5,2,FALSE)*D8) By describing what the formula in cell E8 does, explain the need for absolute and relative cell referencing. The owner of the shop wants to see which toys have a Discounted price that could be considered cheap and those that could be considered expensive. He would like to see all the cells with toys which are more than $40 shaded blue, all those that are less than $30 shaded yellow and the remainder shaded green. Describe how this could be achieved without each individual cell having to be changed. The owner wants a chart showing the Number sold of each toy as a proportion of the total number of toys sold. Identify the most suitable type of chart which would be used to show this information and describe how it would be produced.

8. Spreadsheets  →  8.1. Creating a spreadsheet

8. Spreadsheets  →  8.3. Using a spreadsheet

Open

9

A medical centre uses expert systems to help diagnose illnesses. Explain how the components of an expert system would be used to produce the diagnosis of an illness.

7. Expert systems  →  7.1. Expert systems

Open

10

A car salesroom has a relational database which stores details of the cars and the customers who have purchased a car. The manager uses it to search for information about the cars and the customers. She also produces reports based on these searches. Tables Queries Forms Customers second names beginning with Customers Reports All cars in stock Price less than $20000 Price of car She wants to have an easier way of accessing the queries, forms and reports. Design a switchboard for her which will allow her to go to any of the reports, forms or queries already set up as shown in the image above. Referring to any four interactive items on your switchboard explain what will happen if they are selected. Item 1 Item 2 Item 3 Item 4 Below is a diagram showing the tables in the database. Cars Car–Code Make Model Price Orders ID Order–No Customer–code Car–Code Customers Customer–code First Name Second Name Address–1 Address–1 The car salesroom manager wanted a list of cars made by Frod as well as, in the same list, any cars ordered by customers whose second name begins with B. The printout shows the makes and models of cars, first and second customer names who have ordered them and the order number. Make Model First Name Second Name Order_No Frod Deomon Alan Sutton Frod Deomon Bruce Silversmith Frod Deomon Johann Schmidt Frod Deomon Brian Biggins Olap Azum George Babak Yatoya Yangtse Kulvir Bains

10. Database and file concepts  →  10.1. Creating a database

Open

11

Many major supermarkets now use a variety of monitoring technologies to check the work of their employees. Evaluate the use of technology to monitor employees in the workplace.

3. Monitoring and control  →  3.1. Monitoring and measurement technologies

12. IT in society  →  12.4. The impact of IT

Open

12

Financial models are often created using spreadsheet software rather than using manual methods. Evaluate the use of spreadsheet models for this purpose.

9. Modelling  →  9.1. Modelling and simulations

8. Spreadsheets  →  8.1. Creating a spreadsheet

Open