0417_w20_qp_12
A paper of Information and Communication Technology, 0417
Questions:
12
Year:
2020
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
2
A website can have three web development layers. Tick (3) whether the following statements refer to the behaviour layer, content layer or presentation layer. behaviour (3) content (3) presentation (3) This layer is used to display and format elements within the web page This layer includes the hyperlinks to navigate around the website This layer is used to enter scripting language to elements within a web page This layer is used to create the structure of a web page
21. Website authoring  →  21.1. Web development layers
Open
4
The temperature in a glasshouse is controlled by a computer. A program is being designed to open and close the glasshouse windows. If the temperature is too hot, then the windows will open; otherwise the windows will close. The systems analyst has produced a number of different instructions to show how the system works. Part of the instructions are shown. Complete the instructions by writing the most appropriate technical terms to explain how the windows are operated. • Data is read by the sensor. • data is output from the sensor. • Data from the sensor is sent to the microprocessor via the • If the temperature is greater than the • The microprocessor sends a signal to the Circle the two most appropriate input devices associated with the computerised glasshouse. Chip and PIN reader Hard Disk Drive Laser printer LED monitor Moisture sensor Numeric keypad Another use of computer control is in the manufacture of cars. Discuss the benefits and drawbacks of using computer-controlled systems rather than humans to build a car.
7. The systems life cycle  →  7.1. Analysis
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
Open
6
Khalid keeps a spreadsheet to record his expenses and to plan for future spending. This spreadsheet is split into two separate sheets, which he has named Plan and Model. Plan contains details of his future spending. Model contains a model of his income and expenses. Plan A Income Statement Income Expenditure items Taxes Housing Food Transportation Entertainment / Other Healthcare Investment return Income Growth Expense Ratio % % of spending 63,784 12,757 19,135 6,378 9,568 6,378 3,189 4% 2.5% 90% 22.22% 33.33% 11.11% 16.67% 11.11% 5.56% 20% 30% 10% 15% 10% 5% % of income B C D Housing Food Transportation Model A Model Income Investment Income Total Income Taxes Entertainment / Other Can I afford a car? Savings Balance Sheet Net Income (Savings) Total Expenses Healthcare 72,166 70,406 68,688 67,013 1,450 1,123 65,379 73,616 71,529 69,504 67,540 65,634 64,950 63,366 61,820 60,312 58,842 57,405 63,784 63,784 14,433 14,081 13,738 13,403 13,076 12,757 21,650 21,122 20,607 20,104 19,614 19,135 10,825 10,561 10,303 10,052 9,807 9,568 7,217 7,041 6,869 6,701 6,538 3,608 3,520 3,434 3,351 3,269 3,189 7,217 7,041 6,869 6,701 6,538 44,912 36,246 28,083 20,399 13,171 8,666 8,163 7,684 7,228 6,792 Y Y N N N N 6,379 6,379 6,378 6,378 B C G F E D Khalid has entered a formula in cell C4 of the Model sheet. The formula is B4+(B4*Plan!$B13) Explain, in detail, what the formula does. Include in your answer an explanation of why the $ and the ! are used in the formula. He is saving up to buy a new car; this will cost at least $35,000. Khalid has entered a formula in cell B21 of the Model sheet. The formula is IF(B20>35000,"Y","N") Explain, in detail, what the formula does. Plan A Income Statement Income Expenditure items Taxes Housing Food Transportation Entertainment / Other Healthcare Investment return Income Growth Expense Ratio % % of spending 63,784 12,757 19,135 6,378 9,568 6,378 3,189 4% 2.5% 90% 22.22% 33.33% 11.11% 16.67% 11.11% 5.56% 20% 30% 10% 15% 10% 5% % of income B C D Khalid is planning to create an appropriate graph/chart to be placed in a new sheet. The graph/chart will display the % of income and the names of the expenditure items from the Plan sheet. Identify the most appropriate graph/chart he could use and describe the steps he needs to take to produce this graph/chart in a new sheet.
20. Spreadsheets  →  20.1. Create a data model
Open
7
The owner of a soccer club has employed a systems analyst to create a new computerised system to store details of club members. The systems analyst starts by researching the existing system. One way he could do this is to interview members of the soccer club. Discuss the benefits and drawbacks of individually interviewing the members. When the systems analyst created the new system, he had to choose data types for each field. Write down the most appropriate data type for each field. The answers in the table must be different in each case. The data type for one field has already been identified; this data type must not be used for the other fields. For any numeric field specify the type of number. Field name Data type Example data Year_joined Gender F Date_of_birth 04/11/2000 Membership_number Text Cost_of_membership $10.50 The systems analyst has set the data type for the Membership_number field as text. Explain why this field has been set for a text data type rather than a numeric data type. The owner of the soccer club is planning to create membership cards for all its members using mail merge. The membership card will include personal data from the new system. Describe the steps required to perform the mail merge.
7. The systems life cycle  →  7.2. Design
18. Databases  →  18.1. Create a database structure
7. The systems life cycle  →  7.1. Analysis
Open
8
Many supermarkets now use the internet and allow customers to buy their products online. Explain, in detail, the effects that online shopping has had on supermarkets. When customers shop online, they can pay using a debit card. Describe measures that customers could use to reduce fraud when using a debit card online. Smishing, pharming and phishing are three security threats that can occur when using the internet for shopping. Tick (3) whether the following statements refer to pharming, phishing or smishing. pharming (3) phishing (3) smishing (3) Fake emails are sent to target users When the user types in a URL they are directed to a fake website Malicious code is installed on the user’s computer Fake text messages are sent to the user’s phone
8. Safety and security  →  8.3. Security of data
6. ICT applications  →  6.9. Computers in the retail industry
Open