0417_s19_qp_12
A paper of Information and Communication Technology, 0417
Questions:
15
Year:
2019
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
2
There are many types of data storage. Tick whether the following statements are examples of read-only memory (ROM), random access memory (RAM) or a hard disk drive (HDD). HDD (✓) RAM (✓) ROM (✓) It loses its data when the computer is switched off. It is classed as backing storage. It stores the start-up instructions of the computer. It temporarily stores the current work of the current user. 1 14
1. Types and components of computer systems  →  1.1. Hardware and software
1. Types and components of computer systems  →  1.2. The main components of computer systems
Open
4
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. [Turn over 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. = [Turn over 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. =
7. The systems life cycle  →  7.6. Evaluation
20. Spreadsheets  →  20.1. Create a data model
Open
5
Adinda is a marathon runner. She uses a smartwatch which is a smaller version of her smartphone. She trains by running in areas near her home. She uses a smartwatch with an in-built GPS system to navigate the route she is running. Describe the disadvantages of using a smartwatch in this way. Name two other uses of GPS systems. [Turn over 1 14 Adinda also carries a smartphone strapped to her arm but finds this is difficult to use when running. A smartphone can be used for communication, either for making phone calls or text messaging. Adinda stops part way through her run for a rest and wishes to communicate with her friend using the smartphone. Describe why text messaging is a better way for Adinda to communicate with her friend rather than making a phone call.
6. ICT applications  →  6.1. Communication
4. Networks and the effects of using them  →  4.1. Networks
10. Communication  →  10.2. Effective use of the internet
Open
7
The introduction of computers into an organisation’s payroll department has affected employees’ working patterns. Two examples of this are part-time working and job sharing. Describe what is meant by part-time working. Describe what is meant by job sharing. The introduction of these computers has had positive and negative effects on the payroll department’s workers. Describe the benefits to workers of introducing computers into this department. 1 14
6. ICT applications  →  6.9. Computers in the retail industry
10. Communication  →  10.1. Communication with other ICT users using email
Open
10
The systems life cycle is followed when a new computer system is being created. Tick whether the following statements are examples of the Analysis stage, the Design stage or the Evaluation stage of the systems life cycle. Evaluation (✓) Design (✓) Analysis (✓) Identifying the problems with the current system Deciding on testing strategies Observation of workers using the current system Comparing the solution with the original task requirements 1 14
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.6. Evaluation
Open