0417_w17_qp_11
A paper of Information and Communication Technology, 0417
Questions:
16
Year:
2017
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
There are many types of printer. Name the printer which best fits the descriptions given below. A printer that prints by pressing metal pins against an ink ribbon onto the paper A printer that sprays tiny droplets of ink directly onto the paper A printer that uses toner to transfer the print image to plain paper A printer that uses resin to create solid objects
2. Input and output devices  →  2.3. Output devices and their uses
1. Types and components of computer systems  →  1.4. Types of computer
Open
2
Complete each sentence below using the most appropriate item from the list. a bridge a hub a keyboard a microphone a mouse a printer a router a scanner a sensor a switch A network device which broadcasts data passing through it is called A network device that connects a LAN with the internet is called A network device that connects a LAN to another LAN using the same protocol is called A network device that learns which devices are connected to which ports is called
4. Networks and the effects of using them  →  4.1. Networks
Open
4
Tick whether the following activities are part of the Design or the Implementation or the Evaluation of a system. Design (3) Implementation (3) Evaluation (3) Comparing the outcomes with the original task requirements Changing over to the new system Identifying any limitations and necessary improvements to the system Selecting validation routines
7. The systems life cycle  →  7.6. Evaluation
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.3. Development and testing
Open
7
A city hospital has decided to use emerging technology to automate its packaging and dispensing of medicines to patients. It has decided to use a robotic system which identifies the medicine using bar codes. Discuss the advantages and disadvantages to the hospital of using robots within this environment rather than using humans to carry out the task. The system currently uses bar codes to read the data on the medicine packets as well as the shelf that the medicine packets are located on. The hospital is considering using embedded RFID chips in the packaging rather than bar codes. Explain the advantages of using RFID chips in this scenario.
6. ICT applications  →  6.3. Computer controlled systems
6. ICT applications  →  6.9. Computers in the retail industry
6. ICT applications  →  6.7. Computers in medicine
Open
10
A new employee of a company is required to log on to the company’s computer system and will need to create a suitable password. Give three rules that the company would have in place, to help the employee choose a password. He changes his password to R4hB5&Fg1 Explain why he has chosen this password. When a password is changed it is verified. Identify the type of verification which is carried out.
4. Networks and the effects of using them  →  4.2. Network issues and communication
8. Safety and security  →  8.3. Security of data
Open
11
You have created a spreadsheet to help your teacher to show progress in a series of tests. Student A A B C D Test mark Progress Write a formula to be placed in cell C2 to produce the following: “Making progress” if the mark is 75 or more “Satisfactory” if the mark is 50 to 74 marks “Needs improvement” if the mark is 0 to 49 marks Having created the formula, it needs to be tested to show that it displays the correct comment for each mark. Suggest an item of test data that would satisfy each of the following tests. Each item of test data must be different. Test data Expected output Type of test Making progress Test using normal data Satisfactory Test using normal data Needs improvement Test using extreme data Satisfactory Test using extreme data Explain why testing is important. You are now asked to enter the marks for an additional 19 students into the spreadsheet and to produce a bar chart showing the student names and their test marks. Describe how you would create the bar chart.
7. The systems life cycle  →  7.3. Development and testing
20. Spreadsheets  →  20.1. Create a data model
Open
13
For each of the statements below, identify the health problem most likely to be associated with them and a possible solution to the problem. Your answers should be different in each case. Health problem Possible solution Prolonged use of the keyboard Looking at a monitor for a long period of time Sitting too long in one position
5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment
8. Safety and security  →  8.1. Physical safety
Open
14
A library has a relational database consisting of two tables – one containing information about its books and the other containing information about borrowers. Below are two lists showing the field names for each table. A borrower can borrow several books at a time. Book table Borrowers table Book_ID Borrower_ID Book_title Borrower_name Book_author Telephone_contact Year_published Borrower_address Cost_of_book Borrower_email Borrower_ID Date_due_back Identify the primary key in the Book table. Identify the foreign key in the Book table. Identify the type of relationship that exists between the tables. Describe two advantages of using a relational database rather than a flat file database. When the systems analyst was creating the new system she had to produce appropriate data types for each field. Write down the most appropriate data type for each field. Field name Data type Cost_of_book Borrower_name Telephone_contact Date_due_back
18. Databases  →  18.1. Create a database structure
Open