0417_w15_qp_12
A paper of Information and Communication Technology, 0417
Questions:
19
Year:
2015
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
4
Tick the most appropriate method of implementing a new system for each company. Company Parallel running ✓ Pilot running ✓ Direct changeover ✓ A company with several branches wishes to test the new system in one branch only. A small company that can only afford to spend a small amount of money on implementing the new system. If the whole system fails, the company wishes to return to the original existing system. A company that wants the quickest method of implementation.
7. The systems life cycle  →  7.4. Implementation
7. The systems life cycle  →  7.1. Analysis
Open
5
There are a number of methods of direct data entry. Complete each sentence using the most appropriate words from the following list. a bar code reader a touch pad OCR a magnetic stripe reader a trackerball a graphics tablet a touch screen a PIN pad The inbuilt device which moves the cursor when using a laptop is called The device used for selecting an icon so a bar code label can be printed in a supermarket is called The device used for controlling a pointer on a screen when the user has limited motor skills is called
2. Input and output devices  →  2.2. Direct data entry and associated devices
2. Input and output devices  →  2.1. Input devices and their uses
1. Types and components of computer systems  →  1.1. Hardware and software
Open
7
Scientists want to find the level of pollution in a river running past a chemical factory. They will use sensors connected to a computer to do this. Name three sensors that the scientists would place in the river. Explain why it is so important to carefully consider the position of sensors placed in the river. Describe how the computer would monitor the level of pollution in the river.
7. The systems life cycle  →  7.1. Analysis
1. Types and components of computer systems  →  1.1. Hardware and software
1. Types and components of computer systems  →  1.2. The main components of computer systems
Open
8
A school has introduced a system so that parents of its students can access data about their children. Give three reasons why the school has introduced this system. In order to access this data, parents will need to log on to the school’s website. Describe the purpose of the following two items of data they will need to enter. User id Password
8. Safety and security  →  8.3. Security of data
8. Safety and security  →  8.2. eSafety
7. The systems life cycle  →  7.1. Analysis
Open
10
A video shop owner uses a spreadsheet to calculate his costs. This is part of the spreadsheet. A B C D Book title Number in stock Cost price Total cost The Wolf Of Wall Street $18 $72 Thinking Fast And Slow $17 $85 Be Careful What You Wish For $15 $120 The Fell Sword $20 $80 Metro 2034 $15 $30 Overall cost $387 Give the cell reference of the cell that contains $20. Give the number of rows shown in the spreadsheet. Write down the formula which should go in cell D2. Write down the formula which should go in cell D8. Make the most efficient use of a function. Explain why financial models are often used to predict future profitability.
20. Spreadsheets  →  20.1. Create a data model
Open
12
Many database software packages have a report generation feature. The following is part of a video hire shop database showing films available in Blu-ray format. Film_name Director Price ($) Regions Length Rush Ron Howard 12.99 A Last Vegas Jon Turtletaub 17.72 B Captain Phillips Paul Greengrass 14.99 Free Saving Mr Banks John Lee Hancock 15.00 C Each of the following fields contains data that is numeric. Give a more precise data type for each of these fields. Price Length Blu-ray discs have one of three region codes or are region-free. Describe how the field Regions could be set up to reduce the possibility of inaccurate data entry. Describe, in detail, how you would create a formatted report which does not show regions and only shows films which are longer than 110 minutes.
18. Databases  →  18.3. Present data
20. Spreadsheets  →  20.3. Present data
18. Databases  →  18.1. Create a database structure
Open