0417_s21_qp_11
A paper of Information and Communication Technology, 0417
Questions:
14
Year:
2021
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
4
Many banks have reduced the number of staff in their branches and replaced them with automatic teller machines (ATMs). These ATMs, which can be located within the bank, can be used by customers to deposit and withdraw money from their bank accounts. ATMs can be used to deposit cheques. Describe the computer processing involved in depositing a cheque at an ATM. [Turn over 1 8 Customers can visit these banks or use internet banking. Discuss the advantages and disadvantages to a customer of visiting the bank rather than using internet banking.
6. ICT applications  →  6.6. Banking applications
6. ICT applications  →  6.9. Computers in the retail industry
Open
5
Tawara school has a shop that sells items needed by pupils in school. Part of a spreadsheet with details of the items is shown. Write down the number of rows that are shown in the spreadsheet that contain text. Write down the number of columns that are shown in the spreadsheet that contain text. 1 8 Tax is paid on certain items sold in the shop. The tax rate that has to be paid is 20% of the selling price. If tax is to be paid on an item, then ‘Y’ is placed underneath the Tax heading. The formula in I4 is: IF(F4=''Y'',($I$1*D4*G4),'''') Explain, in detail, what the formula does. Explain the steps that need to be taken to display cell H4 as US dollars. [Turn over 1 8
20. Spreadsheets  →  20.1. Create a data model
20. Spreadsheets  →  20.3. Present data
Open
6
You have been asked by the secretary of a soccer club to create a website to publicise its results, fixtures and other events. When the website has been created it has to be published on the internet. You plan to upload it onto the internet using FTP. Explain what is meant by FTP. Explain how to upload and publish the content of a website using FTP. 1 8 Before the website is published it needs to be tested. Write down three different features of the web pages that could be tested. For each feature, describe the method you would use to carry out the test. Feature 1 Method Feature 2 Method Feature 3 Method [Turn over 1 8
10. Communication  →  10.2. Effective use of the internet
7. The systems life cycle  →  7.6. Evaluation
Open
7
A systems analyst has created a new computer system to keep records in a medical centre. She has created a relational database to store the medical records of patients. The database uses primary and foreign keys. Describe what is meant by a relational database. Explain the difference between a primary key and a foreign key. 1 8 A dentist works at the medical centre. The dentist stores the medical records of his patients. Describe four other uses of the database software that the dentist can use to help him in his work. [Turn over 1 8 The data stored on the computer system needs to be protected from unauthorised access. Discuss the effectiveness of different methods of increasing security of this data. 1 8
8. Safety and security  →  8.3. Security of data
18. Databases  →  18.1. Create a database structure
Open
9
A company operates from 08:00 to 19:00, Monday to Friday. Full-time employees work a 40-hour week, starting at 09:00 and finishing work at 17:00. For each of the times worked by an employee, write down the most appropriate working pattern. An employee works from 09:00 to 13:00, Monday to Friday. An employee works from 09:00 to 19:00, Monday to Thursday. The work of two employees combined is a 40-hour week; each work for two full days and a half day. An employee works a full 8-hour day but has negotiated with his employer to complete this at some point between 08:00 and 19:00, each day. [Turn over 1 8
Open
13
RockIT Airlines representatives use a computer booking system to book flights for customers. A representative from the airline types in the customer reference number, the number of passengers, departure time, departure date, departure airport and the destination airport. A customer is planning to take a flight from London Heathrow Airport. The representative types in a code LHR for London Heathrow Airport. One of the reasons for using a code for the airport is to improve data accuracy. Describe two other advantages of using a code rather than typing out the full name. Describe the importance of data accuracy when making a booking. 1 8 Describe the processing and outputs involved in making the booking. Question 14 starts on page 16. [Turn over 1 8
6. ICT applications  →  6.5. Booking systems
7. The systems life cycle  →  7.1. Analysis
15. Proofing  →  15.2. Proofing techniques
Open
14
A road through a village has a speed limit of 45 kilometres per hour. The police are checking and recording the speed of vehicles passing through the village using measuring hardware and software, so they can produce a report of their findings. Explain the difference between measurement and control when using microprocessors. Describe the role of the microprocessor in this scenario.
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
7. The systems life cycle  →  7.1. Analysis
Open