0417_s15_qp_12
A paper of Information and Communication Technology, 0417
Questions:
16
Year:
2015
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
2
Below is a list of statements. Each statement is true for only one of the given methods of implementation. Tick the method which matches the statement. Parallel running ✓ Direct Changeover ✓ Pilot running ✓ All of the old and new systems run at the same time. If the system fails in one branch, the rest of the company is not affected. The new system has to be completely free of errors before implementation. The benefi ts of the new system are available immediately.
7. The systems life cycle  →  7.4. Implementation
7. The systems life cycle  →  7.1. Analysis
Open
5
There are a number of methods of direct data entry. Complete the sentences using words from the list below. The method of inputting bank codes from the bottom of a cheque is called The device used for inputting details from a label on a product is called The device used for inputting data directly from a bank card is called a bar code reader a PIN pad OMR MICR a keyboard a graphics tablet a mouse a chip reader
2. Input and output devices  →  2.2. Direct data entry and associated devices
6. ICT applications  →  6.9. Computers in the retail industry
2. Input and output devices  →  2.1. Input devices and their uses
Open
6
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 35 mm 20 mm 15 mm 10 mm 10 mm Start Finish The turtle is facing up the page and the pen is up. A student has written the following set of instructions to make the floor turtle draw the above shape. 1. PENDOWN 2. LEFT 90 3. FORWARD 15 4. RIGHT 90 5. PENUP 6. FORWARD 20 7. RIGHT 90 8. PENUP 9. FORWARD 90 10. RIGHT 35 11. FORWARD 20 Although the first four instructions are correct, this set of instructions would not draw the shape exactly as shown. One instruction has been missed out and four are incorrect. Write down the missing instruction and indicate where it should be positioned in the list of instructions provided. Identify the four incorrect instructions and state the correct instructions to be used.
Open
7
A microprocessor controlled washing machine is fitted with a number of sensors. Tick three sensors which would be used in such a system. ✓ Pressure sensor Height sensor Wind speed sensor Sound sensor Temperature sensor Moisture sensor Cold sensor Detergent sensor Describe the actions taken by a microprocessor during a wash cycle, based on the readings from those sensors identified in part .
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
7. The systems life cycle  →  7.1. Analysis
Open
9
Explain how a VLOOKUP function works, using the example of VLOOKUP(38,A2:C10,3,FALSE). A spreadsheet contains the following data and formula. Months in employment :ŽďĚĞƐĐƌŝƉƟŽŶ Name D E F G H I Teacher Chemist Engineer Lecturer Bricklayer Manager Shopkeeper Zoo owner Explorer John Avtar Ahmed Ho David Jose Simon James /ŶƟŬŚĂď =VLOOKUP(33,D2:F10,3) Explain why the cell H2 might not contain James. Suggest the value that would be contained in that cell, giving reasons why.
20. Spreadsheets  →  20.1. Create a data model
Open
11
Aftab wants to create a network using a PC and two laptop computers he has bought for his family. All have network cards fitted. He has already purchased network protection software. He wishes to use them for online banking. Name and describe the use of four additional items, apart from cables, he would need in order to set up this network. Item 1 Use Item 2 Use Item 3 Use Item 4 Use
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
13
Tick three drawbacks in terms of costs to banks of introducing online banking. ✓ Initial purchase of hardware and software is expensive Bank workers will have to be paid more Extra buildings will be need to be rented System maintenance costs may be high Cost of lighting and electricity will be higher More cashiers will need to be employed More security staff will need to be employed Redundancy payments will need to be made to cashiers who are now unemployed
6. ICT applications  →  6.6. Banking applications
6. ICT applications  →  6.9. Computers in the retail industry
Open
14
A headteacher wishes to store details of her students in a computer database. She has been given an example of one student record by the school secretary: Strauss, Johann, SR132516, 83, 01/09/2011 This corresponds to family_name, first_name, Student_Id, Maths_test_score, joined_the_school. The file is currently stored in the form of plain text with each record separated by a line break. Give a file extension which is appropriate for this file. For each field identify the most appropriate data type. The Maths_test_score is used in calculations. Field name Data type family_name fi rst_name Student_Id Maths_test_score joined_the_school Identify the two fields for which a format check would be the most appropriate validation check. In each case describe how the format check would work. The school secretary will use a screen input form to make it easier to enter data on the new system. Design a suitable screen input form to enter the details of one student using the fields given in part but leaving the field contents blank. It should contain appropriate spacing for each field, as well as navigation aids and other appropriate features of a screen input form.
7. The systems life cycle  →  7.2. Design
18. Databases  →  18.1. Create a database structure
Open