0417_s18_qp_12
A paper of Information and Communication Technology, 0417
Questions:
16
Year:
2018
Paper:
1
Variant:
2

Login to start this paper & get access to powerful tools

1
2
4
6
7
8
13
608h Fairground Attraction 3 € 40.00 € 50.00 The Buyer’s premium is 20% of the Selling price. Write a formula to display the Buyer’s premium in cell E6. = The person selling the item pays a Seller’s commission on any item sold. This is calculated using the Selling price and finding a match or the next value below in the table, in cells I6 to J11. Write a formula to display in cell F6, the Seller’s commission on the Double Decker bus toy. This formula will be replicated down to cell F13. = 1 18 Describe how you could replicate the formula in cell F6 for each item. Before the auction begins, a hard copy brochure is produced showing information about the items, data from the spreadsheet and images of some of the items. Describe how this brochure is created. [Turn over 1 18 Automatic car parking systems built into cars are becoming more common. They allow the car to park safely in a parking bay unaided. The car uses proximity sensors fitted to the front and rear of the car to help it park. There are many advantages to using these sensors. State three disadvantages of using proximity sensors in this way. Modern-day drivers rely less on paper maps and more on satellite navigation systems . Describe the inputs, outputs and processing of a satnav when used by a driver to reach a destination. 1 18 The European Space Agency (ESA) is building a new space telescope to orbit the Earth and search for distant galaxies. The ESA is using computer controlled robots to build the lens of the telescope. Discuss the advantages and disadvantages of using computer controlled robots rather than humans to build the lens. A new computer system will operate the space telescope; the new computer system is made up of a number of modules. Describe how the new computer system is to be tested before it is fully operational. [Turn over 1 18 When the new system has been developed, both user and technical documentation have to be written. Name three components that are found in both technical and user documentation. When people use the internet they run the risk of their computers being infected by viruses. A file, containing a virus, is downloaded from the internet. Describe the effects the virus could have on their computer’s hard disk. Explain another way the computer could have become infected with a virus. 1 18 An antivirus program is set to fully scan a computer for viruses once a day. Describe how the antivirus software works during the scan. A company used to have video-conferences with its suppliers, but due to technical problems they are considering running an audio-conference. Describe the advantages of using audio-conferencing rather than video-conferencing. [Turn over 1 18
14
15