9626_w18_qp_11
A paper of Information Technology, 9626
Questions:
12
Year:
2018
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Tick the four most accurate statements regarding peer-to-peer and client-server networks.  Peer-to-peer networks must have a central server. Client-server networks generally offer greater security than peer-to-peer networks. Peer-to-peer networks can support millions of users with no loss of performance. The server will determine which users can access the files on a client-server network. In a client-server network each client functions both as a client and as a server simultaneously. If one computer crashes it has no effect on the other users in a client-server network. A client-server network is cheaper to set up than a peer-to-peer network. Peer-to-peer networks always require an employee to manage the network. In a peer-to-peer network only one computer is allowed to use the printer. In a peer-to-peer network computers can communicate and share files with every other computer on the network.
14. Communications technology  →  14.3. Network servers
14. Communications technology  →  14.1. Networks
Open
2
Tick the four statements which are true regarding user interfaces.  The colours used in a dialogue interface are of key importance. A mouse is an essential input device when using a command line interface. A graphical user interface requires you to type in a large number of instructions. A command line interface is mainly used by more advanced computer users. A gesture based interface allows users to point with their fingers as a method of input. A command line interface needs menus and icons to operate it. A dialogue interface can interpret hand movements to carry out commands. A gesture based interface is very reliable as most users have similar gestures for communicating. The font size is the most important feature of a command line interface. A graphical user interface involves the use of windows and pointers.
2. Hardware and software  →  2.5. User interfaces
Open
9
Schmidt and Partners own a chain of shoe shops. They pay their workers a weekly wage consisting of a basic wage plus commission. Workers only get paid commission if they have made $500 worth of sales in that week. The commission is paid at the rate of 10% of the amount of sales made over $500. Below is a spreadsheet showing some of the workers and the wages they were paid in one week. Sales person Li Chung Graham Phillips Karl Gustaph Paula Meldrew Shen Bin Ram Babu Joan Adams Hu Zheng Louis Raphael Ambrin Satem Tong Mu Malcolm Novak Department Childrens Adults Childrens Childrens Adults Childrens Childrens Adults Adults Childrens Adults Adults Value of sales $550 $450 $700 $850 $1,000 $350 $780 $620 $420 $900 $940 $870 Basic wage $50 $60 $55 $60 $55 $45 $55 $65 $45 $50 $60 $70 Commission $5 $20 $35 $50 $28 $12 $40 $44 $37 $131 Total wage $55 $60 $75 $95 $105 $45 $83 $77 $45 $90 $104 $107 A B C D E F G Fig. 1 Write down the formula which should go in cell E4 which is easily replicable. It should calculate the commission earned but leave the cell blank if no commission is earned. = You can use the space below for any working you need. The shop manager wants to know the total commission the shop is paying to those workers in the Adults department who sold over $800 worth of shoes. Write down a conditional formula which should go in cell E16. = You can use the space below for any working you need. The manager wishes to know the number of workers who did not earn any commission. Write down the formula he would enter into cell E18 to obtain this value. The formula must work even if the data in the spreadsheet changes in the future. = When the manager was originally given the spreadsheet by the IT technician it looked as shown in Fig. 2 below: 550.00 450.00 700.00 850.00 1000.00 350.00 780.00 620.00 420.00 900.00 940.00 870.00 50.00 60.00 55.00 60.00 55.00 45.00 55.00 65.00 45.00 50.00 60.00 70.00 55.00 60.00 75.00 95.00 105.00 45.00 83.00 77.00 45.00 90.00 104.00 107.00 5.00 20.00 35.00 50.00 28.00 12.00 40.00 44.00 37.00 131.00 Commission Value of A B C D E F G H Sales pers Li Chung Graham P Karl Gusta Paula Mel Shen Bin Ram Babu Joan Adam Hu Zheng Louis Rap Ambrin Sa Tong Mu Malcolm N Departmen Childrens Adults Childrens Childrens Adults Childrens Childrens Adults Adults Childrens Adults Adults Basic Wag Total wage Fig. 2 Explain, in detail, the features of spreadsheet software he had to use to change its appearance as shown in Fig. 2 to that shown in Fig. 1 (page 8), using the shortest number of steps. The larger column widths became 20 points wide and the narrower one (column F) 12 points.
8. Spreadsheets  →  8.1. Creating a spreadsheet
9. Modelling  →  9.1. Modelling and simulations
Open
10
Below is a database showing a list of details about cars in a showroom. L456 SRA B648 MAV M452 DQY M846 RCA L678 RTS B358 FCD F692 TEC S492 LZR N671 SAE R762 VDA F457 REW K789 KNM X236 BEC Z341 TYU J456 REA L423 FRO L567 APQ Reg_No Make Model Doors Colour BMS Opla BMS BMS Frod Opla Opla Opla Vellox Frod Opla Opla Opla Opla Vellox Vellox Vellox Valiant Vic Eagle Eagle Artsa Lemming Leo Eagle Artsa Eagle Eagle Kestrel Lemming Kestrel Green Green Red Blue Red Green Red Black Black Blue Blue Blue Black Green Black Blue Green To find all Eagle models the search conditions would be Model = “Eagle”. Using only Boolean operands, comparison operators and wild cards, write down the most efficient search conditions which would produce lists of: Reg_Nos beginning with the letter ‘L’. Frod cars which are Blue. Eagles which are Red, Blue or Green. Describe how the database has been sorted to produce the one shown. Identify, giving reasons, the key field in the database. Give reasons why the other fields are not suitable.
10. Database and file concepts  →  10.1. Creating a database
8. Spreadsheets  →  8.3. Using a spreadsheet
Open
12
Encoding of data can be thought of as applying a code such as letters, symbols and numbers to data for conversion into a cipher. It can also be thought of as a form of analogue to digital conversion such as used by codec software. At times it is the term applied to the coding of data. Evaluate the need for encoding data and analyse the different methods that can be used to encode data.
1. Data processing and information  →  1.3. Encryption
1. Data processing and information  →  1.5. Data processing
Open