7.1. Analysis
A subsection of Information and Communication Technology, 0417, through 7. The systems life cycle
Listing 10 of 68 questions
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. [ 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. [ 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. [ 1 18
0417_s18_qp_12
THEORY
2018
Paper 1, Variant 2
Tawara Health Centre is creating a new online appointment system for its patients. The developer has created a table showing part of the file structure of the new database. Comment Field length Data type Field name 12-digit unique number Numeric: integer Medical_ID_number dd/mmm/yyyy Date/Time Date_of_birth Text Family_name Text Doctor_name hh:mm Date/Time Appointment_time Text Contact_telephone_number Text Current_medication A, O, AB, B Each can be + or – Text Blood_type Apart from presence check, for each field, name an appropriate validation check that could be used. Your answer should be different in each case. Validation check Field name Medical_ID_number Blood_type Date_of_birth Contact_telephone_number Referring to the fields in the table, name the most appropriate field that could be used as a primary key. 1 15 Using the fields given in the database complete the design below showing a suitable online data entry form for the receptionist to fill in. [ 1 15 The health centre has a new logo that appears on their online data entry form. The developers originally produced a logo and then had to change it so that it could be used appropriately on the online data entry form. The original logo is shown before the changes and the new logo after the changes. Before After Describe the changes that have been made to the original logo to create the new logo. 1 15 The doctors in the health centre use an expert system to help them diagnose illnesses. The symptoms of the patient’s illness are typed in by the doctor. Describe the processing that the system uses so that it can suggest possible illnesses. [ 1 15
0417_s19_qp_13
THEORY
2019
Paper 1, Variant 3
Humans can send unmanned aircraft into storms to collect wind speeds and temperature data. The unmanned aircraft have sensors attached to them which send the data back to computers at the weather station. The computers analyse the data. Previously the aircraft was manned and all the data was collected and flown back to the weather station. Discuss the advantages and disadvantages of using the unmanned aircraft rather than using the manned aircraft. 1 2 The owner of Tawara Hotels is planning a new computerised booking system. There are ten Tawara Hotels throughout the world. The current booking system allows people to book rooms in any of the Tawara Hotels. He has employed a systems analyst to research the current system and then install the new system. When analysing the current booking system, the systems analyst must identify the user requirements. Explain why it is important for the systems analyst to do this. Tick (✓) the relevant stage of the systems life cycle for each of the following activities. Evaluation (✓) Development and testing (✓) Analysis (✓) Activity Identifying the problems with the current system Comparing the solution with the original task requirements Create the file structure Identify limitations to the new system and improvements to be made [ 1 2 Before the new booking system is installed, the systems analyst has to decide on a method of implementation. One method of implementation is pilot running. Name two other methods of implementation and describe two benefits of each. Name Benefit 1 Benefit 2 Name Benefit 1 Benefit 2 1 2
0417_s21_qp_12
THEORY
2021
Paper 1, Variant 2
Questions Discovered
68