0417_w23_qp_13 - revisedeck

0417_w23_qp_13

A paper of Information and Communication Technology, 0417

Questions:

10

Year:

2023

Paper:

1

Variant:

3

Login to start this paper & get access to powerful tools

1

Peter needs to create a validation check for product numbers. Three examples of product numbers he needs to check are: Identify two validation checks he could use to check the numbers.

7. The systems life cycle → 7.2. Design

15. Proofing → 15.1. Software tools

15. Proofing → 15.2. Proofing techniques

Open

2

A student has created a document with images for her geography project. The layout of page one is portrait orientation. The student needs to set page two as landscape orientation. Before she can set the landscape orientation she needs to insert a break. State the type of break that is needed. The student has placed images in the document. State two file formats she could have used for the images. Each page of the document includes a footer. Explain why a footer is used. 1 10

20. Spreadsheets → 20.3. Present data

13. Layout → 13.3. Headers and footers

17. Document production → 17.1. Document layout

Open

3

A teacher is setting up a school shop. The teacher is setting up a spreadsheet to keep the accounts of the shop. shows a box containing 50 Choco Bars to sell in the shop. The information on the box will be entered into the spreadsheet. Contains: Sell by: 1/4/2025 Special Price Only $1.20 Choco Bars D A B C State the most appropriate display format in the spreadsheet for each piece of data shown on the box. Your answer must be different in each case. A B C D Each box delivered to the school shop includes a QR code. Explain why QR codes are used. [Turn over 1 10 The teacher has created a formula in the spreadsheet that calculates the cost of purchasing a number of different items. She has created a formula that: • subtracts the discount per item from the price of the item to find the cost of the item • then multiplies the cost of the item by the quantity. Product A Choco Bar Quantity D Price of item B $1.20 Total E –$1.80 F Discount per item C $0.20 The formula she enters into cell E2 is: =B2-C2*D2 When this formula is entered into cell E2 the result is not what she expected. The result should be $15.00 Explain why the result was not $15.00 1 10

20. Spreadsheets → 20.1. Create a data model

20. Spreadsheets → 20.3. Present data

Open

4

A company’s computer system is protected by both a user ID and a password. Explain how a user ID and a password are used to increase the security of data. The company plans to improve the security of its computer system by using biometric methods. Describe what is meant by biometric methods. Give two examples of biometrics. Description Example 1 Example 2 [Turn over 1 10

8. Safety and security → 8.3. Security of data

Open

5

A student needs to purchase a new computer for use on his university course. The laptop computers available to him are one that contains a solid-state drive (SSD) or one that only stores data on the internet, using the cloud. Evaluate these two types of laptop computer. 1 10

1. Types and components of computer systems → 1.4. Types of computer

Open

6

A computer model can be used to design and test a bridge before it is built. Discuss the benefits and drawbacks of using a computer model before building a bridge.

6. ICT applications → 6.2. Modelling applications

6. ICT applications → 6.3. Computer controlled systems

Open

7

Rockit Aircraft manufactures and flies aeroplanes. The pilots at Rockit Aircraft are trained using extended reality. Describe what is meant by extended reality. [Turn over 1 10 Some of the components used in the manufacture of aircraft are produced using a 3D printer. Analyse the use of a 3D printer to make the components rather than making the components by hand.

Open

8

Many devices in the home can be connected to the internet so they can be controlled remotely. These devices are called smart devices. A house contains a smart security system. Describe the benefits and drawbacks of using a smart security system. 1 10 Identify two sensors that could be used with the smart security system. Part of the smart security system involves an automatic gate for vehicles approaching the house. There is a CCTV camera at the gate and the smart security system has software for recognising each vehicle’s number plate. Explain how automatic number plate recognition (ANPR) systems work. Describe three problems that could occur when the ANPR system reads a vehicle number plate. [Turn over 1 10

5. The effects of using IT → 5.1. Microprocessor-controlled devices

6. ICT applications → 6.10. Recognition systems

Open

9

The secretary of Tawara University has created web pages for former students. The former students are adults. State the design features of the web pages that would meet the needs of this target audience. The web pages conform to the university’s corporate house style. Describe why a corporate house style is used. Give four design features of a corporate house style. 1 10

14. Styles → 14.1. Style management

21. Website authoring → 21.2. Create a web page

10. Communication → 10.2. Effective use of the internet

Open

10

A school has employed a systems analyst to help update its computerised examination system. The systems analyst researches the current system to see what will be required in the new system. State the methods of researching the current system that are described: talking to the network manager and examinations officer about the current system watching the users operating the current system forms sent out to all users to complete and return. After completing the analysis, the new system needs to be designed. One item that needs to be designed is a file structure. Identify three other items that would need to be designed. 1 10

7. The systems life cycle → 7.1. Analysis

7. The systems life cycle → 7.3. Development and testing

Open