9626_s18_qp_13
A paper of Information Technology, 9626
Questions:
11
Year:
2018
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
1
Tick the four most accurate statements referring to hardware and software. Operating systems are examples of hardware. An Optical Mark Reader and a Magnetic Ink Character Reader are types of storage device. A scanner is a type of software. Hardware is another name for the physical parts of a computer system. A bar code reader is an example of an input device. The CPU of a computer is considered to be hardware. A device driver is a type of hardware. System and application are the names of two types of software. A dot matrix printer is an example of software. Applets and apps are examples of hardware.
2. Hardware and software  →  2.2. System software
Open
2
Tick the four most accurate statements referring to protecting the confidentiality of personal data. You should use different passwords and PINs for different accounts. Storing personal data on removable media only and locking them away when not in use, is a good form of protection. Encryption prevents data from being accessed. A firewall always prevents unauthorised users from accessing confidential data. Installing spyware helps protect confidential data from unauthorised access. Banks are allowed to share personal data of customers with other customers. Confidential personal data is usually stored on DVD ROMs as this prevents it from being accessed. TLS is a cryptographic protocol used to protect personal data transmitted across a network. Users should always log off immediately after using a site where personal data has been typed in. Using public computers to access personal information is good practice as they usually have plenty of security.
5. eSecurity  →  5.1. Personal data
Open
8
Here is a section of a database showing the wages paid and hours worked by some workers in a company. New data is about to be entered but it will need to be validated. Validation rules will need to be created to make sure the data is sensible. Two validation rules would be appropriate for the Telephone field and one for the Weekly wage field. You can assume the wages shown include the minimum and maximum that the company pays. Smith Prudhomme Gonzales Signusson Thorsvald Mueller Lucio Boko Ndlovu James Gordon McDonnell Kelly Family name J215VENUES First name Telephone Weekly wage Hours worked John Pierre Jose Lars Olaf Dieter Silvio Peter Joseph Peter James Jamie Peter 01632 267145 01632 342016 01632 941368 01632 643821 01632 811276 01632 351156 01632 281146 01632 444707 01632 319249 01632 860787 01632 205775 01632 430332 01632 832287 Describe, using examples from the data shown, the validation rules that will be created. For each one, give examples of test data (do not include normal data) that would test the validation rule works and give reasons for each choice. Telephone: Validation rule 1 Test data Reason Validation rule 2 Test data Reason Weekly wage: Validation rule Test data Reason Select an appropriate data type for the Telephone field, explaining why you have chosen it. The data from this section of the database has been imported into a spreadsheet. This is because the manager wants to calculate the average wage earned by the workers who work more than 40 hours a week but less than 50 hours a week. Smith Prudhomme Gonzales Signusson Thorsvald Mueller Lucio Boko Ndlovu James Gordon McDonnell Kelly A B C D E F Family name First name Telephone Weekly wage Hours worked John Pierre Jose Lars Olaf Dieter Silvio Peter Joseph Peter James Jamie Peter 01632 267145 01632 342016 01632 941368 01632 643821 01632 811276 01632 351156 01632 281146 01632 444707 01632 319249 01632 860787 01632 205775 01632 430332 01632 832287 Average Write down the formula which should go in cell D16. = You may use the space below for any working out. Describe how the spreadsheet could be sorted so that Dieter Mueller is the first worker in the list and Pierre Prudhomme is the seventh. The manager has decided that the name fields should be combined. He wants a name field containing the first name initial and the family name. Write down the formula that would give Jamie McDonnell’s name as J McDonnell. = You may use the space below for any working out.
1. Data processing and information  →  1.4. Checking the accuracy of data
8. Spreadsheets  →  8.1. Creating a spreadsheet
Open