0417_m19_qp_12
A paper of Information and Communication Technology, 0417
Questions:
18
Year:
2019
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
7
The Tawara Tea Company supplies tea to its customers. The company has created a spreadsheet to help its sales team to keep track of its orders. The spreadsheet has two worksheets, named Products and Orders. Part of the spreadsheet is shown below. All prices and costs are displayed in Indian Rupee ₹. Worksheet: Products A B C Tea code Product name Price per unit 9 8 7 6 5 3 349 348 347 Chamong Organic Bannockburn Makaibari Organic Risheehat Goomtee Phuguri Pussimbing Supreme Tumsong Supreme Phuguri Supreme Singbulli Champagne Oolong 272 ₹ 4.00 ₹ 5.00 ₹ 4.90 ₹ 6.40 ₹ 8.00 ₹ 8.50 ₹ 16.00 ₹ 16.00 ₹ 16.00 ₹ 16.00 11 10 9 8 7 6 5 4 3 2 1 Worksheet: Orders A C Quantity ordered B D Order ID Tea code Cost 200 220 225 30 120 105 25 24 125 125 125 124 124 124 124 124 6 5 3 349 9 6 348 272 9 8 7 6 5 4 3 2 1 A salesman needs to create a formula to be placed in cell D2, in the Orders worksheet, that finds the Price per unit of the tea, multiplies it by the Quantity ordered and then displays the result. Write a formula that needs to be entered in cell D2. This formula will be replicated down to cell D9. = The salesman has created a new worksheet called Receipt which automatically produces a receipt for each order. Worksheet: Receipt Risheehat Pussimbing Supreme Chamong Organic Tumsong Supreme Singbulli Champagne Oolong A D C Total Quantity ordered 30 120 105 25 24 Product name B Order ID Tea code 124 349 9 6 348 272 7 6 5 4 3 2 1 ₹ 2416 ₹ 480 ₹ 480 ₹ 672 ₹ 400 ₹ 384 E Cost Explain how he could format the Cost column (column E) to display the values in Indian Rupees as shown.
20. Spreadsheets  →  20.1. Create a data model
Open
8
A drone is a remote controlled flying vehicle. A drone is being used to monitor floods in Mumbai. Complete the following sentences, using the most appropriate word or words from the list below. buzzer joystick monitor pressure sensor ROM speaker temperature sensor video camera The drone is microprocessor controlled with input from a Images of the floods are captured using a The images sent from the drone are displayed on a Name three advantages of using a drone to monitor the floods rather than collecting the data manually. 1 2 3
7. The systems life cycle  →  7.1. Analysis
6. ICT applications  →  6.3. Computer controlled systems
1. Types and components of computer systems  →  1.1. Hardware and software
Open
10
An electric bus system is being considered for New Delhi. Passengers will use smart cards to travel on the bus. They will have to add money to their smart card before they can travel. Compare and contrast the use of smart cards rather than using cash to pay for a journey. The new electric bus system will help to reduce the air pollution in the city. Sensors are used in the system. Name a sensor that could be used to detect high levels of air pollution. The sensor monitors the air pollution. When the air pollution reaches a certain limit, a message is displayed on a street sign in the city to warn pedestrians and road users. Describe the computer processing involved in this system. Data from the sensor needs to be converted from analogue to digital before it is processed. Explain the need for this conversion.
7. The systems life cycle  →  7.1. Analysis
1. Types and components of computer systems  →  1.1. Hardware and software
Open
12
Tawara High School has developed a new computerised system to timetable lessons and examinations. The school needs the new system to be in use before the start of the new school year. The school is planning to implement the new system using either direct changeover or parallel running. Discuss the advantages and disadvantages of using direct changeover compared with parallel running as a method of implementing the system. In your answer name the method you would use, giving reasons for your choice. Describe four advantages of using computerised timetabling systems. 1 2 3 4
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.4. Implementation
Open
16
A programmer is developing a presentation of a new ICT solution for a conference and needs to consider the audience. Using examples, explain why presentations and ICT solutions have to take into account the type of audience. The programmer is concerned that the software used for the presentation will be copied by the participants during the conference. Describe how the software could be protected from illegal copying.
9. Audience  →  9.1. Audience appreciation
9. Audience  →  9.2. Copyright
Open