0417_w19_qp_13
A paper of Information and Communication Technology, 0417
Questions:
15
Year:
2019
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
1
Complete the following sentences about input and output devices, using items from the list below. dot matrix printer driving wheel MICR motor speaker TFT monitor touchpad wide format printer An output device that is used to produce hard copy architectural drawings is a An input device that is used in a virtual reality system is a The inbuilt input device on a laptop is a An output device that is designed to output music is a
2. Input and output devices  →  2.3. Output devices and their uses
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
5
A student is using her computer to do her homework. For each of the statements below, identify the health problem most likely to be associated with the use of a computer and a possible solution to the problem. Your answers must be different in each case. Health problem Possible solution Reading from the monitor in poor lighting Using a mouse for prolonged periods of time Sitting too long in one position
5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment
1. Types and components of computer systems  →  1.4. Types of computer
Open
7
The following is an external stylesheet which contains a number of mistakes. body {background-image:url('Camblogo.jpg'); background-color:#7g7d76 h1 {text-weight:bold; font-size:42px text-align:centre} h2 {font-size:30px; text-align:right; text-decoration: underlined; font-family:"Times New Roman", Times, serif} Identify five errors which would prevent this stylesheet from working properly and, for each error, write down a possible correction.
14. Styles  →  14.1. Style management
21. Website authoring  →  21.3. Use stylesheets
Open
8
An examiner has created a spreadsheet to calculate his travel and hotel expenses when he attends meetings. Part of the spreadsheet that he has created is shown below. Departure date Return date ID Destination Distance Hotel per night Total cost for hotel Travel cost 2018/01 2018/02 2018/03 Cambridge Coventry Manchester Distance threshold greater than 400 400 or less Distance rate 10/01/2019 15/02/2019 20/02/2019 149.8 $196.40 $250.20 $196.40 $175.50 $180.00 $67.41 $98.20 $83.40 $98.20 $0.25 $0.45 12/01/2019 18/02/2019 22/02/2019 A B C D E F G H I J K If the car mileage is greater than 400 km he gets paid $0.25 per km for the whole distance otherwise he gets paid $0.45 per km for the whole distance. Write a formula, that is easy to replicate, to be placed in cell H2 that calculates the travel cost for the meeting. Your formula must work even when the distance rates change. = Write a formula, that is easy to replicate, to be placed in cell G2 that calculates the total cost for the hotel for the meeting. = When the spreadsheet is completed the examiner will need to list the details of all the meetings where the distance is 400 km or greater. Explain how the examiner would use a filter to achieve this. A computer can be used to model scenarios. Explain why computer models are used instead of creating the real thing.
20. Spreadsheets  →  20.1. Create a data model
Open
11
During the analysis stage for a new computer system, the systems analyst could examine existing documents. Name two other methods the systems analyst could use to research the current system. Give one benefit and one drawback of each. Method 1 Benefit Drawback Method 2 Benefit Drawback When the new computer system has been produced, it will need to be tested. There are three types of test data that can be used to test a system, normal, abnormal and extreme. Explain what is meant by normal, abnormal and extreme test data. Normal Abnormal Extreme Following testing and implementation, documentation needs to be produced. Tick three elements you would only find in technical documentation. Tick (3) Program name Glossary of terms Frequently asked questions Algorithm How to print data File structures Error messages List of variables
7. The systems life cycle  →  7.5. Documentation
7. The systems life cycle  →  7.1. Analysis
Open