9626_w22_qp_12
A paper of Information Technology, 9626
Questions:
10
Year:
2022
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
4
Here is a spreadsheet created by the organisers of a concert. They have assumed that 400 people will attend the concert. They have also assumed that each member of the audience will purchase 2 snacks and 2 drinks during the concert. If these assumptions are correct, their profit will be $710. A B C D Tickets Drinks Snacks Souvenirs Programmes Electricity $20 $15 $3 $2 $40 Price Quantity per concert goer Total income $16,000 Income $1,600 $2,400 $8,000 $6,000 $34,000 $650 Paid out $22,000 $860 $880 $5,000 $2,400 $1,500 $33,290 Total outgoings $710 Profit/Loss Estimated audience size Performers Drink supplies Snack supplies Venue hire Souvenir supplies Programme supplies A number of factors could affect the amount of profit. • The audience size might be higher than the organisers estimated. • Members of the audience might not buy 2 snacks and 2 drinks. • The cost of souvenir supplies might change. Explain how the organisers could use what-if analysis to see the effects of these three factors on their profit. You should refer to specific cells from the spreadsheet in your answer. The organisers wish to achieve a larger profit. By explaining what each step requires them to do, describe how the organisers would use goal seek to find the size of the audience needed to make a profit of $5000. You should refer to specific cells from the spreadsheet in your answer. Include in your answer a reason why the result might not be satisfactory.
8. Spreadsheets  →  8.1. Creating a spreadsheet
Open
5
The owner of a book shop has created a database of her books. She will now test that it works. Some of the records are shown. The data shown contains the maximum and minimum values. There are only two types of book. ISBN Title Author Book_type Copies H P H P H Lee Child Isaac Asimov Dan Brown James Patterson David Baldacci Blue Moon Prelude to Foundation Inferno Revenge One Good Deed Describe, in detail, the three most appropriate validation checks, apart from a check digit, type check or presence check, that could be used to validate the data. For each validation check, your description should include the field it could be used for. Each validation check and each field must be different. The owner will also need to verify the data in her database. Using examples from the three fields you used in part , explain why verification is needed in addition to validation.
1. Data processing and information  →  1.4. Checking the accuracy of data
10. Database and file concepts  →  10.1. Creating a database
Open
9
A programmer is writing an algorithm in pseudocode to represent a company’s payroll system. The system calculates a worker’s wages before tax by multiplying the number of hours worked by the rate of pay per hour. A procedure within the main algorithm representing this could be: PROCEDURE BeforeTax(Hours, Rate) WagesBeforeTax Hours * Rate ENDPROCEDURE There are two stages involved in calculating the wages after tax: • the amount of tax paid by the worker is calculated by multiplying the WagesBeforeTax by the rate of tax (35%); • the amount of tax paid is then subtracted from the WagesBeforeTax. Write a procedure for calculating the wages after tax, assuming the value of WagesBeforeTax is passed to it. The programmer’s algorithm will use the BeforeTax() procedure and the procedure created in part to calculate and output the wage after tax for each worker. Complete the algorithm. The statements have been numbered to help you. count INPUT NumberOfWorkers REPEAT UNTIL
4. Algorithms and flowcharts  →  4.1. Algorithms
1. Data processing and information  →  1.5. Data processing
3. Monitoring and control  →  3.2. Control technologies
Open