0417_s20_qp_13
A paper of Information and Communication Technology, 0417
Questions:
13
Year:
2020
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
2
Write down the type of interface shown. File Edit View Insert Format Tools Actions Help Reply Forward Reply to All Files - Message From: dave@testpro.com To: cheryl@testpro.com Subject: Files Date: 26 March 2020 Time: 14:22 Artwork - Notepad File Edit View Format Help Working_file memo notes template3 photos Miscellaneous Project1 m 1 13 Write down two advantages of using this type of interface.
11. File management  →  11.1. Manage files effectively
7. The systems life cycle  →  7.5. Documentation
Open
4
Mason is the head of a year group at a school. Every term he needs to send to parents a report on their child’s progress. This will include a written report and the percentage attendance over the term. Each term he loads the comments from his tutors into the word processing software. He then adds the attendance data from the database. The report is then printed and sent to parents. He has decided that in future he will use mail merge to print the reports. Give four advantages of using mail merge instead of typing the reports. As it is entered, the data on the database is checked using validation routines. The percentage attendance field uses a range check. Describe, using the percentage attendance field, the steps that need to be taken to create this validation routine. 1 13 Before the database can be implemented the validation routines need to be tested. Describe, using the percentage attendance field, how the validation routine will be tested by Mason.
15. Proofing  →  15.2. Proofing techniques
7. The systems life cycle  →  7.2. Design
Open
6
The secretary of the Tawara Rowing Club is organising a presentation evening for its members. A systems analyst is creating a database for the club to store the details of the members. She is also creating a spreadsheet to show who is attending the presentation evening. The systems analyst has set up the following fields for the database. Gender Year _joined Contact_phone_no Contact_email Membership _type Date_of_birth Name_of_person F 03 2453 5673 n.kwa@rockict.com Social 2/4/2005 Nor Kwa M 082 25 4689 AdamM@abc.co.my Social 23/5/2003 Adam Mazian M 01223 432678 AOthman@cie.org Junior 12/03/2006 Ahmed Othman F 123 3267 9999 Zara@cbc.cn Senior 1/12/1997 Zara Png For the following fields write down the most appropriate data type. Each data type must be different. For any numeric field, specify the type of number. Gender Membership_type Year_joined 1 13 Design an online data entry form which could be used to enter the details of one member, using all the fields shown in the table. In your design include appropriate spacing for each field and navigational aids. Do not include data in the form. [Turn over 1 13 A spreadsheet has been created to show which members are attending the presentation evening and who has paid. Part of the spreadsheet is shown. K J I H G F E D C B A Tawara Rowing Club $ Cost Paid Total owed Number attending Attending Type of member Full name Family name Name Junior Y Y Social Nor Kwa Kwa Nor Senior Y Y Junior Ahmed Othman Othman Ahmed Social N Y Senior Zara Png Png Zara N N Social Adam Mazian Mazian Adam Write down three of the formatting features that have been used in the part of the spreadsheet shown. 1 13 A formula has been created and placed in cell G3. The formula is: IF(E3=''Y'',VLOOKUP(D3,J$3:K$5,2)*F3,0) Explain what the formula does. The secretary needs to identify different types of members in the club. Describe the steps he would take to sort the data by type of member so that Junior members are at the top of the list. [Turn over 1 13
18. Databases  →  18.1. Create a database structure
7. The systems life cycle  →  7.2. Design
Open
7
A train company is improving security on its journeys. They are planning to introduce a facial recognition system for passengers using their trains. Discuss the advantages and disadvantages of using facial recognition systems rather than manually checking tickets. 1 13 Facial recognition is an example of biometrics. Direct data entry devices can be in three forms. One is biometrics. The second is contactless where the item being read does not touch the reader. The third is physical where the item being read does touch the reader. Tick (✓) whether the following are the most appropriate examples of biometrics or contactless or physical direct data entry. physical (✓) contactless (✓) biometrics (✓) RFID Magnetic stripe Retina scan Voice recognition
8. Safety and security  →  8.3. Security of data
6. ICT applications  →  6.10. Recognition systems
Open
8
One implication of using a computer system is that people can break the law by hacking into other computer systems. Cultural, Ethical and Moral implications can also be issues. Tick (✓) the most appropriate implication for each of the following statements. Moral (✓) Ethical (✓) Cultural (✓) A student has changed the contents of a company website without permission Writing computer games that make fun of a country’s religion Using pictures in a document without acknowledging copyright Passing information to a rival company [Turn over 1 13
8. Safety and security  →  8.3. Security of data
10. Communication  →  10.2. Effective use of the internet
Open
10
The modern home relies heavily on microprocessor-controlled devices. One of the benefits is that a worker is able to return home to a warm house having set the heater control to switch on at a certain time. Describe four benefits in terms of lifestyle changes that this has produced for the users of such devices. [Turn over 1 13 The worker has set the heater control to switch on at 16:00 for two hours. Explain how the microprocessor can operate the automatic heater to turn on and off at the correct times. 1 13
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
6. ICT applications  →  6.3. Computer controlled systems
Open
11
Parallel running is a type of implementation. Name and describe two other methods of implementing a new computer system. For each one give an advantage and a disadvantage of this method. Your answers must be different in each case. Method 1 Advantage 1 Disadvantage 1 Method 2 Advantage 2 Disadvantage 2 [Turn over 1 13
7. The systems life cycle  →  7.4. Implementation
7. The systems life cycle  →  7.1. Analysis
1. Types and components of computer systems  →  1.3. Operating systems
Open