0417_m21_qp_12
A paper of Information and Communication Technology, 0417
Questions:
12
Year:
2021
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
3
Falyaz has created a diary using word processing software. The diary entry for 17th May 2020 is shown. Write down four formatting features of the word processing software used to make this diary entry. Feature 1 Feature 2 Feature 3 Feature 4 1 10 The original diary entry typed into the word processing software did not include an image. Describe the steps that would be carried out by Falyaz to include in his diary entry an image taken from his digital camera. Name two other sources of digital images apart from using a digital camera. Source 1 Source 2 [Turn over 1 10 Tick (✓) whether the following statements about generic image files refer to jpg, png or gif file types. gif (✓) png (✓) jpg (✓) This file type stores still or moving images This file type uses lossy compression This file type is used for storing photographs on a digital camera This file type is limited to 256 colours Falyaz wants to add a header in his word processed diary. Explain what is meant by a header and why it is needed. 1 10
11. File management  →  11.1. Manage files effectively
7. The systems life cycle  →  7.5. Documentation
Open
4
The table shows a comparison of two different types of fitness tracker. A fitness tracker contains a microprocessor, is worn around the wrist and monitors physical readings of the wearer. FitB 4 Flexi-byt 6 Name of fitness tracker 7 days 20 days Battery life in days WiFi Bluetooth Method of internet connection 10m 100m Water resistant N Y GPS INR 10700 INR 22855 Cost You have been asked to design a poster to show this data for the two fitness trackers. Describe how you would use six different design features to enhance the data in this poster. The poster must be suitable for an audience of adult customers. [Turn over 1 10 Describe the computer processing involved in the use of a microprocessor-controlled fitness tracker when displaying and monitoring the blood pressure of the user.
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.6. Evaluation
Open
6
Complete the following sentences, using the most appropriate direct data entry device. a magnetic stripe reader MICR a chip reader a bar code reader RFID reader PIN pad OMR OCR The device that reads data from a card in a contactless card system is called The device that reads scanned text and converts it into a readable form is called The device that reads the data made up of black lines and spaces on household goods is called [Turn over 1 10
2. Input and output devices  →  2.2. Direct data entry and associated devices
6. ICT applications  →  6.10. Recognition systems
Open
7
A school is planning to introduce a contactless card system for pupils to pay for school meals. Each card contains an amount of money which is topped up by parents. Parents transfer amounts of money into the school system and pupils place the card close to a reader to upload the money onto the card. Discuss the benefits and drawbacks, to the pupils, of using a contactless card system rather than paying by cash. 1 10 The terminals in the school use electronic funds transfer at point of sale (EFTPOS). Describe the computer processing that takes place to pay for a meal at the EFTPOS terminal using the card. [Turn over 1 10
6. ICT applications  →  6.9. Computers in the retail industry
6. ICT applications  →  6.6. Banking applications
Open
8
A computer system is being created to calculate the scores in a diving competition. Every dive by an athlete is awarded a score out of 10 by each judge. The system is being tested using live data. An athlete completes his dive with a difficulty of 3.4 and achieves the following scores, which are displayed in a spreadsheet. Before the overall score is calculated the judges’ scores need to be sorted into ascending order. Describe the steps that would be carried out to sort the data into ascending order. 1 10 Cell B12 contains the formula, ROUND((SUM(B5:B9)*D1),1). Explain what the formula in cell B12 does. The judges’ score column will be tested using normal, abnormal and extreme data. Explain, giving examples of test data which would be used, what is meant by: Abnormal test data Extreme test data [Turn over 1 10
18. Databases  →  18.2. Manipulate data
20. Spreadsheets  →  20.1. Create a data model
20. Spreadsheets  →  20.2. Manipulate data
Open
9
Tawara school uses an optical mark recognition (OMR) system for its school register. An example of the register is shown. For each session of the school there are two lozenges to be shaded in. At the start of the registration period the teacher shades in a lozenge [P] on the register to show that a pupil is present and shades in a lozenge [A] for each pupil who is absent. If a pupil is late then the teacher shades in both the [P] and the [A] lozenges. The register sheets are sent to the school office to be processed and the data from them is stored in the computer’s database. Describe the inputs and computer processing of the registers when they are sent to the school office, prior to them being stored on the computer’s database. 1 10 The headteacher of the school is considering modernising the registration system so that pupils can register using a facial recognition system. Discuss the advantages and disadvantages of using a facial recognition registration system rather than the OMR system they currently use. [Turn over 1 10 Biometric data, like facial recognition, is an example of personal data. Give two other examples of personal data that could be stored on the school registration database. 1 10
6. ICT applications  →  6.10. Recognition systems
8. Safety and security  →  8.3. Security of data
Open
10
Computer data can be stored on physical storage devices. Data can also be stored in the ‘cloud’. Explain what is meant by the cloud, giving two advantages of storing data in the cloud compared with physical storage devices. Explanation Advantage 1 Advantage 2 Tick (✓) whether the following storage devices are examples of optical, magnetic or solid state storage. solid state (✓) magnetic (✓) optical (✓) Flash drive Hard disk drive Blu-ray disc drive SSD [Turn over 1 10
3. Storage devices and media  →  3.1. Storage devices
3. Storage devices and media  →  3.2. Storage media
4. Networks and the effects of using them  →  4.1. Networks
Open
11
The owner of a bookshop has a database of all the books she has in stock. As some of the data is being entered into the database it is checked using validation checks. An example of some of the records in the database is shown. Example data Field name Brotherhood of Wisdom Name of book Colin Turner Name of author ISBN 25/02/2021 Date of purchase Number of copies E Type of book The Fourth Man Name of book Aadha Khatri Name of author ISBN 18/03/2019 Date of purchase Number of copies H Type of book Indian Temples Name of Book Vihaan Laghan Name of author ISBN 12/02/2019 Date of purchase Number of copies H Type of book 1 10
7. The systems life cycle  →  7.2. Design
15. Proofing  →  15.1. Software tools
15. Proofing  →  15.2. Proofing techniques
Open