0417_s14_qp_13
A paper of Information and Communication Technology, 0417
Questions:
19
Year:
2014
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
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 REPEAT n Repeat the following instructions n times END REPEAT Finish the REPEAT loop 72° Start Finish 50 mm 60 mm 120 mm NOT TO SCALE Complete the set of instructions to draw these regular shapes by filling in the blank lines. The turtle is facing up. PENDOWN PENUP LEFT BACKWARD REPEAT FORWARD FORWARD END REPEAT
Open
7
A systems analyst has designed a new computer system for the payroll of a large organisation. The system needs to be tested. Using examples of workers pay, which must not be lower than $200 and no more than $800, explain what is meant by normal test data, abnormal test data and extreme test data. Normal Abnormal Extreme The systems analyst produces documentation for the system. Give four reasons why both user and technical documentation are needed.
7. The systems life cycle  →  7.3. Development and testing
7. The systems life cycle  →  7.1. Analysis
Open
10
Complete each sentence below using one item from the list. a bar code reader a data logger a chip reader MICR OMR a robot a simulation validation verification Data from a bank card is input using Data from a product in a supermarket is input using Data from a cheque is input using Fixing wheels to a car on a production line would be done by
2. Input and output devices  →  2.2. Direct data entry and associated devices
2. Input and output devices  →  2.1. Input devices and their uses
1. Types and components of computer systems  →  1.1. Hardware and software
Open
11
Computers are used in libraries to keep records of books and borrowers. This is part of the database of books in a library: ISBN Title Name of Author Paperback or Hardback Borrower number Gone Tomorrow Lee Child P 9781858683416 The World of the Brontës Jane O’Neill H Harry Potter and the Deathly Hallows J K Rowling H Old Bear stories Jane Hissey H This is part of the borrower’s database: Borrower number Name of borrower e-mail of borrower Borrower phone number Giovanni Benitez benitez.g@fmail.fr 02 34 45 67 Sarbjit Chandra sarb@goofie.es 24 17 39 81 Individual records in the data files need to be retrieved quickly. Write down the name of the most suitable storage medium for this purpose. The records in the book file are to be sorted in descending order of ISBN. What will be the title of the book in the first record in the database after it has been sorted? Give the name of a field that contains a Boolean data type. Identity the data type of the borrower phone number field. Why would the borrower number in the borrower’s database be used as a key field? Write down the author of the book that Giovanni Benitez has borrowed. The final digit in the ISBN is used for validation purposes. Write down the name of this digit. Describe two suitable validation checks, other than limit or range checks, that could be carried out on the borrower number field. Describe three advantages and one disadvantage of the library using email rather than a phone call to contact borrowers. Advantage 1 Advantage 2 Advantage 3 Disadvantage When a book is borrowed the borrower presents the book and library card to the librarian. Discuss the advantages and disadvantages of different input devices which could be used by the librarian. Libraries often let borrowers access their own records at home. One method the library uses to make sure that each borrower only accesses their own records is by using a User ID and password. Describe the purpose of each. User ID Password
8. Safety and security  →  8.3. Security of data
18. Databases  →  18.1. Create a database structure
Open
14
Complete the sentences using words from the list below. OMR CAD/CAM a disc a tape an icon a keyboard Pupil exam answers can be read using In a Graphical User Interface, to select an application you click on To enter an instruction into a Command Line Interface you would use
1. Types and components of computer systems  →  1.1. Hardware and software
1. Types and components of computer systems  →  1.3. Operating systems
2. Input and output devices  →  2.1. Input devices and their uses
Open
15
Computer controlled traffic lights are used at busy road junctions. Light sensors and sound sensors are not used to measure traffic flow. Giving a different reason for each, explain why these sensors are unsuitable. Sound Light Explain the difference between measurement and control when using microprocessors.
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
2. Input and output devices  →  2.1. Input devices and their uses
6. ICT applications  →  6.3. Computer controlled systems
Open