9626_m17_qp_12
A paper of Information Technology, 9626
Questions:
11
Year:
2017
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
Tick the four most accurate statements regarding the quality of information. P The more information that is collected the higher its quality. Data collected from a third party always becomes high quality information. The accuracy of the information collected affects its quality. Information which costs a lot to collect is always high quality information. A great deal of detail can sometimes lead to poor quality information. Irrelevant information leads to poor quality information. The problems arising from a lack of good quality information can be overcome by making your filters more refined. Good quality of information is always obtained from small groups of people. Information collected 100 years ago is always good quality information. The more complete the collected information is, the better its quality.
1. Data processing and information  →  1.2. Quality of information
1. Data processing and information  →  1.1. Data and information
17. Data Analysis and Visualisation  →  17.1. Data Analysis and Visualisation
Open
2
Tick the four statements which most accurately refer to encryption. P Encryption is used by hackers to discover passwords. Encrypting a hard disk prevents viruses from deleting the information. Encryption always makes use of a public key and a private key. Encryption is the scrambling of the text in a message. Encryption is the process of encoding messages in such a way that only authorised parties can understand them. Encryption prevents messages from being intercepted. Encrypted information can only be understood if decrypted. Encryption has speeded up internet browsing by using secure sites. The recipient can only decrypt the message with the key provided by the originator. All memory sticks are encrypted.
1. Data processing and information  →  1.3. Encryption
Open
5
Avtar is a recently appointed network manager in a school. In his role he will need to use a variety of utility software. Describe, in detail, each of the following utilities. anti-virus software: data compression: disk defragmentation: disk formatting: There are a number of computers in the school which are not networked at the moment. Discuss the advantages and disadvantages of creating a new network using these computers.
2. Hardware and software  →  2.3. Utility software
14. Communications technology  →  14.9. Network security
Open
7
Atat Iron Ltd uses computers to process its payroll. The company pays its workers weekly which involves the updating of a master file. Two sets of data are shown below. The first set represents part of a transaction file containing workers’ ID numbers and the hours worked by those workers in a particular week. The second set represents part of the master file used by the company. This shows the workers’ ID numbers, departments they work in and the rate per hour at which they are paid in Indian Rupees ( ). Transaction file Master file Workers_ID_number Hours_worked Workers_ID_number Department Hourly_rate ( ) Extrusion Cold rolling Extrusion Foundry Foundry Hot rolling Cold rolling Tube production Extrusion Tube production Foundry Tube production Extrusion Hot rolling Describe what processes must happen before the updating can begin. Using this data, explain how a transaction file is used to update a master file in a payroll system. You may assume that the only transaction being carried out is the calculation of the weekly pay before tax and insurance deductions. When a new worker is added to the master file, the data must be validated. His hourly rate will be 50 Rupees. Without using a type check, describe three other validation checks you would develop to make sure all the data entered is sensible. 1. 2. 3.
1. Data processing and information  →  1.5. Data processing
1. Data processing and information  →  1.4. Checking the accuracy of data
Open
8
Below is part of a spreadsheet Jose has created to model his personal finances.  A B 1 $2,600 Wages/salary 3 $120 Utilities 4 $100 Satellite/TV 5 $80 Phone 6 $30 Pet food 7 $1,000 Mortgage/rent 8 $80 Internet 9 $100 Insurance 10 $75 Hair/beauty 11 $550 Groceries 12 $150 Eating out 13 $100 Clothing 14 $40 Cinema 15 $160 Car/travel 17 $2,585 Total outgoings 19 $15 Balance Using only the sort feature explain how you would be able to get the following values in the given cells. $80 in cell A11 with Internet in cell B11 and $1,000 in cell A3. $100 in cell A8 with Clothing in cell B8.
8. Spreadsheets  →  8.3. Using a spreadsheet
8. Spreadsheets  →  8.1. Creating a spreadsheet
Open
10
Below is an extract from a database of students who have chosen to study Maths at AS Level. The database is in unnormalised (0NF) form. Student number Name Second subject Third subject Eashan Wadhwa Chemistry Physics Karan Bansal Physics Chemistry Manan Malik Chemistry Biology Neel Bhatia Biology Chemistry Ridhima Shekhar History Biology Rohin Pannu Geography History Saransh Anand History Geography Shraddha Aggarwal Biology Chemistry Rekha Pooja Physics Chemistry Sundar Rakshana Physics Chemistry Describe the characteristics of the data above which make it unnormalised and explain how it can be transformed into first normal form (1NF).
10. Database and file concepts  →  10.2. Normalisation to third normal form (3NF)
Open
11
Below is an extract from a spreadsheet showing the wages paid in one week to a group of workers. Their wages depend on the type of job they do as well as the number of hours worked. Cells C2 to E4 contain the data which is referred to in the lower part of the spreadsheet.  A B C D E F G Standard rate per hour L Labourer Se Semi-skilled Sk Skilled Worker ID Job Code Job type Hours worked this week Rate per hour paid Wage paid this week 8 12478L L Labourer 9 13691R Se Semi-skilled 10 21463R Se Semi-skilled 11 29816M L Labourer 12 36479L Sk Skilled 13 49786R Sk Skilled 14 52376M Se Semi-skilled 15 18964L L Labourer 16 13578R L Labourer 17 38945M L Labourer 18 36249M Se Semi-skilled Write down the formula which should be used in cell C8 in order to display the Job type using the Job Code in the preceding column. The formula should be in a form that can be easily replicated. = You can use the space below for any working you need. The spreadsheet contains different formulae in different columns. Explain the other formulae used in the spreadsheet which enable the data in the Wage paid this week column to be displayed. The formulae should be in a form so that they can be easily replicated.
8. Spreadsheets  →  8.1. Creating a spreadsheet
9. Modelling  →  9.1. Modelling and simulations
Open