0417_w21_qp_12
A paper of Information and Communication Technology, 0417
Questions:
14
Year:
2021
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
4
Write down the most appropriate network device to match the following statements. Your answers should be different in each part. This network device checks the data packet arriving from one computer and sends the data to a specific computer. This network device sends the data packet from a computer to all devices connected to it. This network device connects a LAN to the internet. This network device connects one LAN to another with the same protocol.
4. Networks and the effects of using them  →  4.1. Networks
4. Networks and the effects of using them  →  4.2. Network issues and communication
Open
6
As a student you often use a computer keyboard. This could be a virtual keyboard or a physical keyboard on a desktop computer, a laptop computer or even a smartphone. Evaluate your use of computer keyboards in terms of health risks, and explain any strategies you use to minimise these health risks.
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
2. Input and output devices  →  2.1. Input devices and their uses
Open
7
Rockit Motors recently created a new car sales website. The website uses internet shopping features. Customers can ask questions of the virtual salespeople on the website, and then purchase the car on the website. Describe two other features of internet shopping. Discuss the benefits and drawbacks of using internet shopping for Rockit Motors. Before the website became operational it needed to be tested. The web designer created a test plan including module and whole system testing. Explain the difference between module and whole system testing.
6. ICT applications  →  6.9. Computers in the retail industry
10. Communication  →  10.2. Effective use of the internet
Open
8
You are creating a presentation on the World Games. You have created a spreadsheet showing the number of gold, silver and bronze medals awarded to different countries. You are planning to create a graph in the presentation showing the country, the number of gold medals and the total number of medals. A B C D E F World Games Medals Country Gold Italy United States Germany Russia France China Great Britain Japan Ukraine Spain Silver Bronze Total Original data Explain how you would create a vertical bar chart, showing the name of the country, the number of gold medals and the total number of medals awarded to each country, on a new slide in the presentation. The total number of medals has been calculated manually and entered as a value. This could lead to errors. Explain how you could create a formula to calculate the total number of medals awarded for Italy, using only the mouse. Explain how the data could be sorted by the total number of medals won by each country. The country with the largest number of medals should be at the top of the list.
16. Graphs and charts  →  16.1. Graph and chart creation
20. Spreadsheets  →  20.3. Present data
Open
10
A school is planning to change the way it reports back to parents about their child’s academic progress. They plan to produce a mail merged document and then email this to parents. They have created a spreadsheet which shows the pupil’s name, target, attainment and effort levels for Maths and the Science subjects. Part of the spreadsheet is shown. A B C D E F Name Target level Maths Attainment Effort Attainment Effort Attainment Effort Attainment Effort Biology Chemistry Physics Ahmal Wulandan Nurul Prakoso G H I J K Design a suitable document layout to display the information of one pupil. The name of the pupil must be clearly shown separated from the rest of the data. It must have appropriate spacing. Do not include the pupil’s data. The attainment levels range from 1 to 9 and the effort levels range from 1 to 3. Before teachers are allowed to enter data, the spreadsheet needs to be tested. Write down one example of extreme data to test the attainment field and one example of abnormal data to test the effort field. Attainment – extreme data Effort – abnormal data Describe four advantages of using a mail merge for this document. When the mail merge is created, a special field containing the date needs to be added. This date will change automatically each time the merged document is sent or printed. Explain how the date field can be added.
18. Databases  →  18.3. Present data
7. The systems life cycle  →  7.2. Design
Open
11
An air-conditioning system has been fitted in a hotel bedroom. The air-conditioning system will contain fans which operate at varying speeds. Identify the devices used in the system from the descriptions given. This device captures the temperature from the room. This device changes the data from the microprocessor into a form that can change the speed of the fan. This output device operates the fan.
7. The systems life cycle  →  7.1. Analysis
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
Open