0417_s14_qp_12
A paper of Information and Communication Technology, 0417
Questions:
19
Year:
2014
Paper:
1
Variant:
2
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 Start 60° 100 mm NOT TO SCALE Complete the set of instructions to draw this shape by filling in the blank lines. All the sides are the same length. The turtle is facing up the page and the pen is up. You must use the REPEAT instruction. RIGHT 90
Open
7
The table shows part of a spreadsheet file. A B C D E Sweet shop Item Cost price Selling price Profit Amount sold Nutty bar $1.10 $1.30 $0.20 Choco bar $0.95 $1.10 $0.15 Cocoa bar $1.05 $1.30 $0.25 Chocolate digits $0.80 $0.90 $0.10 Give the cell reference of one cell containing a label. Give the cell reference that contains $0.15. Write down how many columns are shown in the spreadsheet. Give the cell reference for a cell that should be formatted as currency. State the formula that should be in cell D5. =
20. Spreadsheets  →  20.1. Create a data model
Open
8
The chemistry department in a school keeps its stock records on computer. The stock for any item is not allowed to fall below 10 or go above 100. Here are examples of records from the suggested database. Description Serial_number Number_in_stock Name_of_supplier Area_code Flask Patels Beaker Smithsons As the data is entered it will need to be verified. Name two ways in which the data could be verified. For each of these validation checks write down the field that would be best suited to it. You must name three different fields. Range Length Check digit
7. The systems life cycle  →  7.2. Design
18. Databases  →  18.1. Create a database structure
Open
10
A video-conference is being set up. Complete each sentence below using the most appropriate device from the list. MICR OCR router web cam scanner printer keyboard microphone speaker Moving images are input using a Sound is input using a Sound is output using a Connection to the Internet is made using a
4. Networks and the effects of using them  →  4.2. Network issues and communication
1. Types and components of computer systems  →  1.1. Hardware and software
2. Input and output devices  →  2.1. Input devices and their uses
Open
11
A library has decided to update its computer system. The details of each book are typed into a screen input form. Design a suitable screen input form for inputting the details of one book. The form must have appropriate spacing for each field, and navigation aids. As the data is typed in, it is stored in a database. Name the medium which would be most suitable for storing the data and having direct access to records. Give two reasons for your choice. Name Reason 1 Reason 2 The library wants to include the new computerised borrowing system on its website. Borrowers will be able to reserve or renew books using the Internet. Some people are concerned about this because there is a risk that their data may be accessed by unauthorised people. Describe three ways that the library could try to prevent unauthorised access to their system. The new system will be implemented. Describe three different ways in which the system could be implemented. After the system is implemented the library will be given two types of documentation. One type will help people use the new system. Give two examples of the contents of this type of documentation. The other type will help a programmer or systems analyst who wants to upgrade the system. Give two examples of the contents of this type of documentation.
8. Safety and security  →  8.3. Security of data
7. The systems life cycle  →  7.1. Analysis
Open
12
A school is going to introduce an automatic registration system controlled by computer. Students will carry a card which will be read automatically by an input device every session so that the school office will know that they are present. Name a suitable input device to read the card. Instead of using this system the school ICT teacher suggests using student fingerprints. Describe two advantages and two disadvantages of such a system. Advantage 1 Advantage 2 Disadvantage 1 Disadvantage 2
6. ICT applications  →  6.10. Recognition systems
6. ICT applications  →  6.4. School management systems
2. Input and output devices  →  2.1. Input devices and their uses
Open
15
A word-processed school newsletter contains only text. The head teacher wants to add images to the newsletter. Describe how he could include photographs, taken using a digital camera, in the newsletter. Name two other suitable sources of digital images. The head teacher needs one thousand copies of this newsletter. Give four reasons why a laser printer should be used rather than an inkjet or a dot matrix printer.
2. Input and output devices  →  2.3. Output devices and their uses
6. ICT applications  →  6.1. Communication
7. The systems life cycle  →  7.5. Documentation
Open
18
A theatre has an on-line booking system. Customers can reserve seats using the Internet with a credit card. The theatre’s computer keeps records of which seats are available. When the customer pays for a seat the theatre’s computer communicates with the credit card company’s computer. Describe three checks that the credit card computer will make on the customer’s credit card account. Describe the processing carried out by the theatre’s computer when the credit card company’s computer authorises the transaction.
6. ICT applications  →  6.6. Banking applications
6. ICT applications  →  6.9. Computers in the retail industry
6. ICT applications  →  6.5. Booking systems
Open