0417_w18_qp_12
A paper of Information and Communication Technology, 0417
Questions:
14
Year:
2018
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
2
Complete the following sentences, using the most appropriate technology from the list. a 3D printer a dot matrix printer a laser printer a light sensor a magnetic ink character reader a microphone an optical mark reader a speaker a web cam a wide format printer A device that is most suited to being used to produce hard copy output in a general office environment is called The input device that reads the cheque number from a bank cheque is called A device that outputs hard copy large architectural drawings is called A device that outputs sound is called
2. Input and output devices  →  2.3. Output devices and their uses
2. Input and output devices  →  2.1. Input devices and their uses
1. Types and components of computer systems  →  1.2. The main components of computer systems
Open
4
A school is setting up a new computerised system to manage many aspects of the school administration. Describe how this system can be used to manage student registration and attendance. Describe the benefits of using this system. The data from the registration system is saved in the school administration database. The head teacher will need to check the attendance records for any student for any semester. She will type in the Student_ID and the Semester (Autumn, Spring or Summer). After she has done this the following data will appear on the same screen. Field name Student_name Days_present Number_of_lates Number_absences Parents_phone_number Tutor_group Design a suitable screen layout to display one record. It must have appropriate spacing for each field, navigation aids and a space to type in search data. Do not include examples of students. A student record from the database is shown below. Field name Example Data Student_ID Semester Spring Student_name Kannur Rahul Days_present Number_of_lates Number_absences Parents_phone_number Tutor_group 11ABC Name an appropriate validation check that could be used for each of the following fields, based on the data shown in the record. Field name Validation check Semester Number_of_lates Parents_phone_number
6. ICT applications  →  6.4. School management systems
7. The systems life cycle  →  7.2. Design
Open
6
A Medical Authority in a large city is planning to centralise its medical booking system. This will allow patients to make all of their doctors’ appointments, dental appointments and hospital appointments online. Discuss the benefits and drawbacks to both the patients and the medical staff of this type of system. The Medical Authority creates many different types of documents including letters and memos. Each of them is produced using its corporate house style. Explain why corporate house styles are required.
14. Styles  →  14.1. Style management
10. Communication  →  10.2. Effective use of the internet
7. The systems life cycle  →  7.1. Analysis
Open
7
A student is setting up a database of information about volcanoes for a Geography project. The following is part of the database. Name_of_volcano Country Height State Last_eruption Volcano_type Usu Japan Active Stratovolcano Tor Zawar Pakistan Dormant Fissure Datong China Extinct Cinder Cone Changbaishan China Active Stratovolcano Stromboli Italy Active Stratovolcano Tengchong China Dormant Pyroclastic cone Wudalianchi China Dormant Multi-coned Operators such as AND, OR, NOT, LIKE, >, >=, can be used to search the volcano database. The search criteria for all the dormant volcanoes with a height of less than 1000 metres would look like this: State = “Dormant” AND Height write down the names of the volcanoes that match the requirements of part . The data is sorted into ascending order of height. Write down the name of the volcano which would now be in the first record. Drones are remote-controlled flying devices. Data can be collected by drones that fly through the gas cloud of the volcano. The drones have sensors attached to them which send the data to a computer. The computer analyses the data. Discuss the benefits and drawbacks of using this method of measurement. Explain why the data collected by the sensors cannot be read directly by the computer.
20. Spreadsheets  →  20.2. Manipulate data
18. Databases  →  18.2. Manipulate data
20. Spreadsheets  →  20.1. Create a data model
Open
10
A local railway company is considering introducing a new system for its passengers using e-tickets on a smart phone. Before introducing this new system, analysis of the current system is required. Describe the steps that would be carried out in the analysis of the current system. The e-ticket will link to a database containing personal data. Give two examples of personal data that could be stored. Details of each of the passengers have been entered into the database. Give one reason why this data was verified on entry. Proofreading is sometimes thought to be verification. Explain the difference between verification and proofreading.
7. The systems life cycle  →  7.1. Analysis
15. Proofing  →  15.2. Proofing techniques
Open
14
Emails are a very popular way of communicating. Tick four statements, relating to emails that are true. Tick (✓) Emails can only be sent from a computer. An email can be used to send a message to many people at the same time. It always takes a long time for an email to arrive. All emails must have an attachment. Attachments may have to be compressed to be sent via email. Emails can be used to send legal documents. Every email has to be printed out. In order to send an email back to the sender without retyping the address, reply is used. Email means extended mail. Email attachments are always checked for viruses before they are sent.
10. Communication  →  10.1. Communication with other ICT users using email
8. Safety and security  →  8.2. eSafety
Open