0417_w14_qp_12
A paper of Information and Communication Technology, 0417
Questions:
17
Year:
2014
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
7
Below is a spreadsheet containing data about a snack shop. A B C D E Snack shop Item Number in stock at start of week Number sold Number in stock at end of week Sold more than 150? Fruity bars No Cheesy chips Yes Muesli dips No Choco Lols Yes Write down the number of columns shown in this spreadsheet. Write down the cell reference of a cell containing an integer. Write down one cell containing a label. Write down the formula that should go in D4. Write down the formula that should go in E5.
20. Spreadsheets  →  20.1. Create a data model
Open
8
A floor turtle can use the following instructions: INSTRUCTION MEANING FORWARD n Move n mm forward BACKWARD n Move n mm backward LEFT t Turn left t degrees RIGHT t Turn right t degrees PENUP Lift the pen PENDOWN Lower the pen 20 mm 40 mm 40 mm 25 mm 25 mm 10 mm 30 mm Start Finish NOT TO SCALE Complete the set of instructions to draw this shape by filling in the blank lines. The turtle is facing up at the start. PEN DOWN FORWARD 10 LEFT 90 FORWARD 25 RIGHT 90 FORWARD 25 FORWARD 30 RIGHT 90 RIGHT90
Open
9
A number of schools have Local Area Networks (LANs) in their buildings. The LANs are used to share software and for students to save their work. Describe two ways that students can prevent the work they save from being edited by others. The schools want to connect their LANs to the Internet. Name the device they will need. As a result of all the schools having access to the Internet, students will be able to communicate with students at other schools in a number of ways. Give two examples of these ways. The headteachers of the schools will want to send confidential data to each other. Give one advantage and one disadvantage of encryption. Advantage Disadvantage
8. Safety and security  →  8.3. Security of data
Open
10
A school is going to install a new computer system that uses WiFi. The headteacher is very concerned about the problems that the introduction of such a system will cause. The safety issue of students tripping over trailing cables has been minimised by using WiFi, and the risk of electrocution has been minimised by the use of automatic circuit breakers. Give two other safety issues which might occur and for each one describe a method of preventing it. Safety issue 1 Prevention Safety issue 2 Prevention Describe what a virus is and explain how viruses cause problems for computer users. If hackers get into the system, they may plant spyware. Describe what is meant by spyware.
8. Safety and security  →  8.1. Physical safety
10. Communication  →  10.2. Effective use of the internet
4. Networks and the effects of using them  →  4.2. Network issues and communication
Open
11
The owner of a shop wants a new computer system to store the records of all the stock and customers. The systems analyst will need to find out how the existing system works. Describe, in detail, two out of the four possible ways she could find out this information. Way 1 Way 2 After analysing the existing system, the systems analyst will design a database. Identify four items that the systems analyst will need to design for the database. After the system is designed, it will be developed, then implemented. Name two methods, other than direct changeover, that could be used to implement the system and give an advantage for each method compared to direct changeover. Method 1 Advantage Method 2 Advantage
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.3. Development and testing
Open
13
Tick three benefits of using computers to store patient records in hospitals.  Patients are always cured. Patient records can be sorted into order more easily. Doctors can find patient records more quickly. Patients’ medicines are never lost. Fewer doctors are needed. Nurses don’t have to be paid as much. Takes up less filing space.
6. ICT applications  →  6.7. Computers in medicine
5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment
6. ICT applications  →  6.3. Computer controlled systems
Open
15
A supermarket uses a computerised stock control system. This is part of the supermarket’s stock file. Product number Product name Number_in_stock Reorder_level Wheaters Cricket Tea Geo garden peas It has EFTPOS terminals at each of its checkouts. Write down the input devices used to read: The product numbers of the goods bought by customers The customer’s credit card details Name the validation check that would be carried out on the product number. Describe the computer processing involved in updating the stock file every time a product is sold and checking whether it needs re-ordering. The customer has to type in the PIN to authorise the transaction. Describe the check that is carried out by the EFTPOS terminal. After the checks on the customer’s card have been completed, the supermarket computer contacts the customer’s bank. Describe the computer processing involved in taking payment from the customer’s bank.
6. ICT applications  →  6.9. Computers in the retail industry
Open
17
Many bank customers do their banking using the Internet at home. Many transactions can now be done without having to travel to the bank. Describe three types of transaction which they can do from home. Identify one type of transaction which they cannot do from home. Give three benefits to the bank of internet banking. Give three drawbacks to the bank of internet banking.
6. ICT applications  →  6.6. Banking applications
10. Communication  →  10.2. Effective use of the internet
6. ICT applications  →  6.9. Computers in the retail industry
Open