0417_w20_qp_13
A paper of Information and Communication Technology, 0417
Questions:
13
Year:
2020
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
2
A computer system uses two types of documentation: technical and user. Some items only appear in the technical documentation and other items only in the user documentation, whereas some items appear in both. Tick (3) whether the following items appear only in Technical documentation, only in User documentation or in Both. Item Technical documentation (3) User documentation (3) Both (3) Algorithms File structures Error messages Limitations of the system Hardware requirements Glossary of terms
7. The systems life cycle  →  7.5. Documentation
Open
3
A student has produced a document for her biology project. Part of the project is shown. Answer the questions relating to the document. Biology Project 16/02/2019 making it an omnivore. Biology Project 16/02/2019 The Kiwi Apteryx is the scientific name for the Kiwi. The Kiwi is a burrowing bird and is the oldest of New Zealand’s birds, having evolved 70 million years ago from a flightless ancestor from the great southern continent of Gondwana. It is related to the Ostrich, Emu and Rhea as well as the now extinct New Zealand Moa, all of which are much taller than the Kiwi. The Kiwi is a very secretive, nocturnal bird which is seldom seen in the wild. There are two species of Kiwis in New Zealand. Brown Kiwis are found in forested areas in the North Island, Fiordland, South Westland and Stewart Island. Spotted Kiwis are found on offshore islands and forests in the north of the South Island. The Kiwi is a tailless and flightless bird. It feeds on insects, grubs and spiders which it locates by sniffing among the leaves and rotting wood on the forest floor using its external nostrils. It is the only bird to have external nostrils. The Kiwi also eats berries, Give the name of the extra margin between the two pages of the document. Give the name of the space above the document, containing ‘Biology Project’ and the date. Name the term given to the single line of text that has overflowed on to the next page. Name the type of alignment used for the body text. The student has placed an image in the document. Name the type of formatting used to allow the text to flow around the image.
Open
6
The manager of a company is planning to create a computerised system and has asked a systems analyst to research the current system. The systems analyst could do this by using a number of different methods, but has chosen to create and send out a questionnaire to members of the company. Discuss the benefits and drawbacks of sending out questionnaires to members of the company. The system has been created. As the data is entered into the system it is verified. Give two methods of verification. Explain why data still needs to be validated even though it has been verified.
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.6. Evaluation
Open
8
A spreadsheet has been produced showing the final places in one of the events in the 2018 Winter Olympic Games. A B C D E F G H I J Country Name Heat1 KOR LAT GBR OAR LAT KOR GER Yun Sungbin Martins Dukurs Dom Parsons Nikita Tregubov Tomass Dukurs Kim Jisoo Axel Jungk 50.28 50.85 50.85 50.59 50.88 50.80 50.77 Heat2 50.07 50.38 51.41 50.50 50.58 50.86 51.01 Heat3 50.18 50.32 49.33 50.50 50.65 50.51 50.83 Heat4 Min Total Time 50.02 50.76 50.62 50.59 50.63 50.81 50.99 200.6 202.3 202.2 202.2 202.7 203.0 203.6 Seconds 20.6 22.3 22.2 22.2 22.7 23.0 23.6 20.55 22.31 22.21 22.18 22.74 22.98 23.60 The event consists of four heats. The times taken to complete each heat are added together to give the Total Time, in seconds. This is then displayed as minutes and seconds. Two formulae form this calculation; they are stored in column H and column J. The formula in cell H3 is: =INT(G3/60) Explain what the formula in cell H3 does. The formula in cell J3 is: =ROUND(I3,1) Explain what the formula in cell J3 does. At the end of the competition, the table must be sorted into ascending order of Total Time. The top athlete would be in the gold medal position, the second in silver medal position and the third in bronze medal position. The Medal and Rank columns must be added. This display should look like this: A B C D E F G H I Medal Rank Country KOR OAR GBR LAT LAT KOR GER Yun Sungbin Nikita Tregubov Dom Parsons Martins Dukurs Tomass Dukurs Kim Jisoo Axel Jungk Name Heat1 50.28 50.59 50.85 50.85 50.88 50.80 50.77 Heat2 Heat3 50.07 50.50 51.41 50.38 50.58 50.86 51.01 50.18 50.50 49.33 50.32 50.65 50.51 50.83 Heat4 50.02 50.59 50.62 50.76 50.63 50.81 50.99 Total Time 200.55 202.18 202.21 202.31 202.74 202.98 203.60 Gold Silver Bronze Explain the steps that must be taken to amend the spreadsheet and to display the data in this way. The heat times are measured by a computer system, but could be measured by officials with stopwatches. Discuss the advantages and disadvantages of using computers in measurement rather than humans.
20. Spreadsheets  →  20.1. Create a data model
Open
9
Legal documents can be sent by email, as a file attachment, or by physical fax. Describe the advantages of using emails compared with physical faxing. A legal document is sent as a file attachment. Explain the steps that need to be taken to ensure that if a virus is attached to the file, it cannot infect the computer. A computer virus has been downloaded from an infected file. Describe three effects this could have on a computer.
8. Safety and security  →  8.3. Security of data
10. Communication  →  10.1. Communication with other ICT users using email
Open
12
Autonomous vehicles such as taxis are being tested on the world’s roads. This type of taxi is able to drive between two points without the driver having control of the vehicle. The vehicles use satellite navigation and wireless technology with sensors to navigate and control the vehicle. Evaluate the use of these technologies when navigating and controlling vehicles in this way.
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
6. ICT applications  →  6.3. Computer controlled systems
Open