0417_s18_qp_11
A paper of Information and Communication Technology, 0417
Questions:
17
Year:
2018
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Complete the following sentences, using the most appropriate items from the list below. A microphone An interpreter A compiler An ADC A 3D printer A USB A switch A speaker A numeric keypad A monitor is a device used to input a PIN. analyses and executes a program line by line. produces output in the form of solid objects. produces output in the form of sound.
2. Input and output devices  →  2.3. Output devices and their uses
1. Types and components of computer systems  →  1.2. The main components of computer systems
Open
3
A media company with branches around the world has recently opened a new branch in London. The branch includes a number of different computer networks. Identify the most appropriate type of network to answer each of the questions. The type of network used to connect the branch to its head office in New York is called a The type of cabled network used to connect computers together in one of the offices is called a
4. Networks and the effects of using them  →  4.2. Network issues and communication
4. Networks and the effects of using them  →  4.1. Networks
Open
5
A geyser is a hot spring in which water occasionally boils, sending a tall column of water and steam into the air. A temperature sensor is used to monitor the temperature near the geyser. The data from the sensor is sent to a microprocessor. Explain why the data from the sensor has to be changed before it is read by the microprocessor. Describe five advantages of using sensors and microprocessors to monitor the temperature in geysers rather than using manual methods. [Turn over 1 18
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
Open
7
A student is producing a website for his history course. He has produced the following CSS. However, he has made some mistakes in the coding. h1 {color: #ff0000; font-family: "Times New Roman", Times, serif font-size: 30pt; text-weight: bold; text-align: centre;} h2 {color: #000000; font-family: Courier, Times, serif; font-size: 14pt; text-decoration: underlined; text-align: justify;} body [background-color: #ad88e6;] table {border-color: #000000; border-style: dot; border width: 3px;} tbody{background-color: #c6dde8;} Write down six mistakes that have been made in the CSS and for each, give the correction. Your answers should be different in each case. [Turn over 1 18
21. Website authoring  →  21.3. Use stylesheets
14. Styles  →  14.1. Style management
Open
9
A farmer has purchased a computerised milking system for her cows. She has asked a systems analyst to create a database to store details of the cows being milked. Examples of the details of the cows which will be stored are: Animal_passport_number Average_milk_yield Weight_of_cow Date_of_birth Breed_of_cow 998/2017 24.5 725.9 25/02/2017 Holstein 972/2016 20.1 715.0 15/03/2016 Ayrshire 971/2016 25.0 732.7 25/02/2017 Jersey 765/2016 25.0 715.0 10/10/2016 Holstein Complete the following table by entering the most appropriate data type for each field. For any numeric field, specify the type of number. Data type Field name Breed_of_cow Date_of_birth Weight_of_cow Average_milk_yield Animal_passport_number State which field would be the most appropriate for the primary key. A validation check is used when entering the animal passport number into the database. Name and describe the most appropriate validation check that could be applied to this field. [Turn over 1 18 The amount of milk each cow produces is currently recorded daily in a spreadsheet. This is part of the spreadsheet. A B C D Daily Milk Yield Animal Passport Number 971/2016 Date of milking Amount produced 26/04/2018 27/04/2018 28/04/2018 29/04/2018 30/04/2018 01/05/2018 02/05/2018 03/05/2018 04/05/2018 05/05/2018 Litres 24.5 23.2 22.1 25.1 24.9 24.7 24.6 23.9 23.9 23.8 You have been asked to produce a graph or chart to show the amounts of milk for the cow with Animal Passport Number 971/2016. Describe the steps you would use to produce a graph or chart of this data as a separate sheet. Include in your answer the name of the new sheet. 1 18
20. Spreadsheets  →  20.1. Create a data model
7. The systems life cycle  →  7.2. Design
7. The systems life cycle  →  7.1. Analysis
Open
10
Carlos is designing a new computer system to replace an existing system. Tick four items which will need to be designed. Tick (✓) Inputs to the current system. Data capture forms. Report layouts. Limitations of the system. Observation methods. Improvements to the system. User and information requirements. Validation routines. Problems with the current system. File structure. Before the system is implemented it needs to be tested. Different types of test data are used to test the system. An example of test data is live data. Describe what is meant by live data. Following the implementation of the system, technical documentation needs to be written. Identify three components of technical documentation which are not found in user documentation. [Turn over 1 18
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.5. Documentation
Open
12
A motor car company has some designers based in London and some in Beijing. The cost of travel between the two cities is very high, so when they wish to meet to discuss new products they use video-conferencing. The designers all have PCs with a keyboard and a mouse in order to take part in video-conferencing. Name three other devices used to input or output data which would be needed to take part in the video-conference. 1 18 Describe three potential problems of the designers using video-conferencing systems rather than meeting in either London or Beijing. Documents that are sent between the two cities are encrypted. Explain what encryption is and why it is used. [Turn over 1 18
4. Networks and the effects of using them  →  4.2. Network issues and communication
Open