7.6. Evaluation
A subsection of Information and Communication Technology, 0417, through 7. The systems life cycle
Listing 8 of 8 questions
Alpine slalom skiing involves a number of skiers racing down a mountain negotiating obstacles. The time it takes each skier to complete the course is measured. The fastest skier is awarded first place. This involves the use of a number of different sensors to monitor variables. Using words from the list below, complete the following statements. pH Motion Light Humidity Turbidity Temperature Sunlight Pressure This sensor is used to measure how cold it is on the course. This sensor is used to stop the clock when a skier crosses the finish line. This sensor is used to measure the altitude (height above sea level) at the top of the course. [ 1 14 Skiers take part in two separate races. The fastest thirty skiers qualify for the second race. Thirty skiers have already completed the course. In order for the next skier to qualify he has to beat the race time of the skier currently in 30th place. Part of the spreadsheet showing the current standings is shown. Write a formula that can be entered in cell E36 to display Y if the skier has qualified by beating the time of the skier currently in 30th place. If the skier has not qualified then N is displayed. = 1 14 Just before the second run column E is deleted as it is no longer required. As the skiers in the second run complete the course their times are entered into the spreadsheet. The spreadsheet has been changed to display the second run times, as shown. The combined times for the first and second runs need to be added to the spreadsheet in a new column between columns E and F. Describe the steps you would take to add this new column with the heading Combined Time. Write a formula that can be entered in the new cell F3 that adds the time taken to complete the first run to the time taken to complete the second run. = [ 1 14 When the overall race is completed the data is sorted into order based on the combined times. The first place skier will be at the top of the list. Part of the final spreadsheet before the data is sorted is shown. The 30th place skier is on row 32. Describe the steps you would take to sort the data to show each skier in their correct position, without using functions. 1 14 Skiers throughout the season earn World Championship points. At the end of the race the points are calculated for each skier. The winner of the race gains 100 points. The other skiers have their points calculated by: • subtracting the combined time of the winner from the combined time of the skier • then subtracting this value from the winner’s points. Write a formula to be placed in cell G4 to show the skier’s points for the race. The formula will be replicated to G32. =
0417_s19_qp_12
THEORY
2019
Paper 1, Variant 2
View
A health authority is planning to centralise its medical booking system. This will allow all medical bookings such as doctors’ appointments and hospital appointments to be made online. The health authority is considering whether to implement the system using Pilot Running or Direct Changeover. Discuss the advantages and disadvantages of implementing this system using these methods. Include in your answer the method you think the health authority should use, giving a reason for your choice. The health authority has implemented the system and it is now in full use. Evaluation now needs to take place. For each of the following, identify two questions that could be asked in order to evaluate the new system. Efficiency Ease of use Appropriateness The ambulances used by the health authority are fitted with RFID chips. These are scanned when the ambulance approaches traffic signals. If the ambulance is on an emergency call the lights automatically change to green. Describe, in detail, what happens when the ambulance approaches the traffic signals prior to the computer instructing the traffic lights to change to green. The traffic controller is considering changing to a number plate recognition system on all traffic lights. State the advantages and disadvantages of using RFID technology rather than number plate recognition in this scenario.
0417_w18_qp_11
THEORY
2018
Paper 1, Variant 1
View
Questions Discovered
8