0417_s16_qp_11
A paper of Information and Communication Technology, 0417
Questions:
20
Year:
2016
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Data can be input to a computer using direct data entry methods. Write down the most appropriate device to input the following: information from the chip in an electronic passport text from an id card account details from the front of a credit card at an EFTPOS terminal account details from the back of a credit card at an EFTPOS terminal
2. Input and output devices  →  2.2. Direct data entry and associated devices
6. ICT applications  →  6.9. Computers in the retail industry
7. The systems life cycle  →  7.2. Design
Open
4
Complete the following sentences. The action of sending emails to fraudulently obtain another person’s bank details is called The action of illegally installing malicious code which redirects a person to a fraudulent website with the purpose of obtaining that person’s bank details is called Unsolicited bulk emails are called The action of sending text messages to fraudulently obtain another person’s bank details is called
8. Safety and security  →  8.3. Security of data
8. Safety and security  →  8.2. eSafety
Open
10
A ferry connects two countries. When car drivers approach the ferry they have to check in to confirm the details they have already booked. If they drive in to the self check-in lane, details of the car are automatically input to a computer. The terminal which is used for the driver to identify themselves produces a personalised welcome message on a screen. There is a database which contains details of the driver and the car. Write down the data which is automatically input to the computer. Other than your answer to give two items of data stored in the computer database. Explain how Optical Character Recognition is used before the computer processes the data. Explain the computer processing which takes place to produce the personalised message. 1 17
6. ICT applications  →  6.10. Recognition systems
8. Safety and security  →  8.3. Security of data
Open
11
Justdiscs Limited stocks many music CDs. Below is a small selection of CDs stored on their database. The data has been sorted on two fields. Number_of_tracks Year_released Price CD_title Artist_name $10.99 Let Em Ave It Giggs $9.99 Heroes Sabiton $8.99 Alright on Top Luke Slater $8.99 Humbug Arctic Monkeys $8.99 Definitely Maybe Oasis $7.99 Erasure Erasure $4.99 Cool Blues Jimmy Smith Write down the field which was used as the primary sort in the database and the order in which it was sorted. Write down the field which was used as the secondary sort in the database and the order in which it was sorted. Peter is the owner of the shop. He receives requests from customers about the CDs he has in stock. He converts these requests into search criteria using comparison and Boolean operators. For example, one customer might ask for CDs which were released after 2002 and also those that have at least 11 tracks. Peter would write this down as: Year_released > 2002 OR Number_of_tracks >= 11 Write down the search criteria for a customer who wants a list of all the CDs which were released before 2010 but only if they cost less than $8.99 Write down the names of the artists whose records match the requirements of part . [Turn over 1 17
20. Spreadsheets  →  20.2. Manipulate data
18. Databases  →  18.2. Manipulate data
Open
12
An airline company allows customers to book flights online. Here is an example of the data a customer is asked to type in when they search for a suitable flight, together with a typical entry. There are three types of class: Economy, Business and First. LHR Departure airport DXB Arrival airport 21/9/2016 Date of departure 8/10/2016 Date of return Economy Class Number of adults Number of children Number of infants Below is an input screen designed to help this data to be entered. Departure airport Arrival airport Date of departure Date of return Class Number of adults Number of children Number of infants 1 17 Evaluate this form regarding the ease of entering data Explain why it would not be appropriate for a format check to be used on the dates as given in the example data.
18. Databases  →  18.1. Create a database structure
7. The systems life cycle  →  7.2. Design
Open
16
Nicholas is the manager of a sports club. The club has football, cricket, netball and hockey teams. When he needs to send a letter to members of a team he types out the letter, prints it and makes several photocopies of it to send to members. He has a database of members and has decided that in future he will use mail merge to print the letters. Give the advantages of using mail merge instead of photocopying the letters. [Turn over 1 17
10. Communication  →  10.2. Effective use of the internet
18. Databases  →  18.1. Create a database structure
10. Communication  →  10.1. Communication with other ICT users using email
Open
17
Below is a spreadsheet showing the countries which have hosted the Commonwealth Games. Canada England Australia New Zealand Canada Wales Australia Jamaica Scotland New Zealand Canada Australia Scotland New Zealand Canada Malaysia England Australia India Scotland Canada England Australia New Zealand Wales Jamaica Scotland Malaysia India Venues for the Commonwealth Games A B C D E F G H I Canada England Australia Wales Jamaica Scotland Malaysia India New Zealand Write down suitable titles for: The category axis The value axis The chart What is this type of chart called? 1 17
16. Graphs and charts  →  16.1. Graph and chart creation
Open
20
Here is some text taken from the CIE website. Cambridge Primary Checkpoint is designed to help students learn by providing comprehensive feedback on their strengths and weaknesses in the key curriculum areas - English, mathematics and science. The tests are exclusively available to schools that offer Cambridge Primary and are generally taken at the end of the final year of the programme. They are marked by Cambridge and provide schools with an international benchmark for learner performance. Each learner receives a statement of achievement and a diagnostic feedback report, giving schools invaluable information and parents extra trust in the feedback they receive. We hold two Cambridge Primary Checkpoint test series each year, covering all major areas of learning in the Cambridge Primary curriculum frameworks for English, mathematics and science. Schools teaching Cambridge Primary English as a Second Language curriculum can enter learners for tests provided by our sister organisation, Cambridge English Language Assessment. Here is the same text after it has been reformatted. Cambridge Primary Checkpoint is designed to help students learn by providing comprehensive feedback on their strengths and weaknesses in the key curriculum areas - English, mathematics and science. The tests are exclusively available to schools that offer Cambridge Primary and are generally taken at the end of the final year of the programme. They are marked by Cambridge and provide schools with an international benchmark for learner performance. Each learner receives a statement of achievement and a diagnostic feedback report, giving schools invaluable information and parents extra trust in the feedback they receive. We hold two Cambridge Primary Checkpoint test series each year, covering all major areas of learning in the Cambridge Primary curriculum frameworks for English, mathematics and science. Schools teaching Cambridge Primary English as a Second Language curriculum can enter learners for tests provided by our sister organisation, Cambridge English Language Assessment. Describe the four formatting techniques which have been used. 1 17
6. ICT applications  →  6.4. School management systems
Open