0417_s17_qp_11
A paper of Information and Communication Technology, 0417
Questions:
16
Year:
2017
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
5
There are a number of health and safety issues associated with the use of computers. Draw arrows from the terms Health or Safety to the matching issue. Use a maximum of four arrows. Tripping over loose wires. Heavy equipment falling off tables and injuring people. Health Clicking a mouse repetitively causing RSI. Safety Overloading sockets causing fire. [Turn over 1 3
5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment
8. Safety and security  →  8.1. Physical safety
Open
9
An automatic washing machine contains a device to read RFID chips sewn into clothing. When an item of clothing is placed in the washing machine it is scanned. Describe how the data is read from the RFID chip. Explain the benefits of using RFID technology in a washing machine. [Turn over 1 3
6. ICT applications  →  6.10. Recognition systems
2. Input and output devices  →  2.2. Direct data entry and associated devices
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
Open
10
The city of Venice is in danger of being damaged due to rising sea levels. A new computer controlled flood defence system is being planned. The developers of the system are using a spreadsheet to model the plan. Give three reasons why computer models are used to simulate the flood defence system. The city uses a manual system for detecting flood waters. This relies on people watching for the rising levels of water. Explain why creating a computerised system is better than using the manual system. 1 3 The developers have used the results from the model to choose a computer controlled flood defence system. It will have a barrier which can open or close. Describe the role of the microprocessor in such a system. [Turn over 1 3
7. The systems life cycle  →  7.1. Analysis
6. ICT applications  →  6.8. Expert systems
Open
11
Below is part of a spreadsheet of candidates’ examination grades. A teacher needs to create formulae to analyse these grades. There are 64 grades in the full list, in cells B6 to B69. A B C F D E G Results for Centre XX123 Qualification: IGCSE Cand. No ICT E C C D C C A E C E C D Totals A* A % A* - C % A* - G B C D E F G U X Write the most efficient formula that could be entered in cell E6 to display the number of A* grades for ICT in the full list. The formula must be easy to replicate for the other grades. 1 3 The teacher wants to copy the formula down to E15 without having to re-type any of the cells. Describe how he could achieve this. The teacher needs to calculate the percentage of students gaining A* to C grades. Write the most efficient formula to achieve this. [Turn over 1 3 The teacher wishes to create an appropriate chart or graph to be placed on a separate sheet. It will show the grades and the corresponding total number of students gaining those grades. Describe how the teacher could achieve this. 1 3
20. Spreadsheets  →  20.1. Create a data model
Open
12
The Staywell Community Centre has created a new database which stores the details of each of its members. Each member can choose either swimming or tennis as an activity. The fields in the database are name, address, contact number, gender and activity. When new members arrive at the centre they need to complete a paper-based form. Design a suitable paper-based form to collect the member’s details and the activity they wish to book for. [Turn over 1 3 Describe four changes which could be made to this paper-based form to make it into an online screen form.
18. Databases  →  18.1. Create a database structure
7. The systems life cycle  →  7.2. Design
Open
13
A picture is an element of a web page. Name three other elements that could be used in a web page. A student is designing a web page about herself which she plans to publish on the internet. The web page will contain a picture of herself as well as other details. She wants to place a picture ‘‘sport.jpg’’ on it. Write the line of HTML markup to display the picture or to display the words ‘‘play sport’’ if the browser cannot locate the picture. 1 3 She has been advised by her teacher that she needs to be aware of e-safety. Describe the e-safety issues that she should be aware of before she publishes this web page. [Turn over 1 3
21. Website authoring  →  21.2. Create a web page
21. Website authoring  →  21.1. Web development layers
Open
15
You use a computer to do your homework. You are concerned about the health issues of using a computer. Discuss the advantages and disadvantages of different methods you could use to help minimise the health problems of using the computer. [Turn over 1 3
5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment
1. Types and components of computer systems  →  1.4. Types of computer
6. ICT applications  →  6.3. Computer controlled systems
Open