9626_m20_qp_12
A paper of Information Technology, 9626
Questions:
13
Year:
2020
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
Tick the most accurate statement referring to batch processing. ✓ The processing of data usually takes place when the computing resources are very busy It is used in the control of traffic lights It typically involves the use of sensors and control systems It is typically used in the printing of electricity bills Tick the most accurate statement referring to real time processing. ✓ It would be suitable for controlling a car park barrier It does not require an immediate response It is never used 24 hours a day for the same task It is where a group of transactions is collected over a period of time before being processed Theatres often use interactive processing to allow customers to book seats. Describe what is meant by the term interactive processing. Give reasons why interactive processing would be used instead of batch processing for booking seats in a theatre.
1. Data processing and information  →  1.5. Data processing
Open
2
For each of the two tables below, tick the most accurate statement referring to the use of simulation in pilot training. ✓ The running and maintenance costs of a flight simulator are far greater than those of an actual aircraft Dangerous situations can be simulated without putting the trainee pilot's life at risk It is more difficult to simulate adverse weather conditions in a flight simulator The level of noise in a flight simulator is far louder than in an aircraft ✓ The pilot has to be able to use spreadsheet software efficiently There is no limit to how many ‘g’ a simulator can subject a pilot to, and for how long The simulator response will always be exactly the same as an actual aeroplane, as there are so few variables Sometimes pilots become overconfident after training on the simulator
9. Modelling  →  9.1. Modelling and simulations
Open
3
Pardeep has a lot of confidential data on her desktop computer which she wishes to transfer to a backing storage device. She is not sure whether to buy an extra hard disk drive or a magnetic tape drive. Evaluate, by weighing up the advantages and disadvantages, the use of a hard disk drive compared with a magnetic tape drive.
10. Database and file concepts  →  10.4. File and data management
1. Data processing and information  →  1.1. Data and information
1. Data processing and information  →  1.5. Data processing
Open
7
Here is part of a spreadsheet showing the earnings of a selection of workers at a company. A Worker ID 42158P 63119M 63214P 89261N 97643M As As Se Se Se Cl Cl As Assistant Assistant Secretary Secretary Secretary Clerk Clerk Assistant $468 $800 $700 $540 $480 Job code Job type Hours worked this week Wage paid this week $12 B C D F E10 ✗ ✔ fx E Standard rate per hour $15 $20 =D10*VLOOKUP(B10,jobrate,3,0) The formula in cell E10 contains a named range, shaded in the spreadsheet. Describe, step by step, how the named range was created. Explain, step by step, what the formula in cell E10 does. Give two reasons why a named range is used. Explain, step by step, how to perform a filter on secretaries earning more than $750. Here is the same spreadsheet showing the formula in cell C7, VLOOKUP(B7,C$2:D$4,2,0). A Worker ID 42158P 63119M 63214P 89261N 97643M As As Se Se Se Cl Cl As Assistant Assistant Secretary Secretary Secretary Clerk Clerk Assistant $468 $800 $700 $540 $480 Job code Job type Hours worked this week Wage paid this week $12 B D F C7 ✗ ✔ fx E Standard rate per hour $15 $20 =VLOOKUP(B7,C$2:D$4,2,0) C By explaining what each part of the formula does, describe how it displays ‘Assistant’ in C7.
8. Spreadsheets  →  8.1. Creating a spreadsheet
Open