0417_s21_qp_13
A paper of Information and Communication Technology, 0417
Questions:
15
Year:
2021
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
3
A mobile phone is used for communications, either for making phone calls or text messaging. Chang is planning an expedition to the Southern Alps in New Zealand. There is often a limited mobile phone signal in these areas. He has set his phone up so that if there is an emergency he can communicate with the rescue teams using text messaging rather than making a phone call. Give two advantages of using text messaging in this way. 1 7
6. ICT applications  →  6.1. Communication
10. Communication  →  10.2. Effective use of the internet
4. Networks and the effects of using them  →  4.1. Networks
Open
4
Tick (✓) whether the following descriptions of analysing a system refer to Interviews, Observation or Questionnaires. Questionnaires (✓) Observation (✓) Interviews (✓) Description This method gives a more reliable overview of the whole system. This is more time-consuming than the other methods. Questions on this method cannot be expanded upon when being asked. With this method the worker cannot remain anonymous.
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.6. Evaluation
Open
6
Susan is creating a database about cars and needs to save it in the shared area (S:) on the school network. It will be stored in the folder ICT which is contained in the IGCSE folder. She needs to save the file with a file name that is different from file names used by other students in the group. Write down a suitable file name for the file so that the teacher can easily find Susan’s work and identify its contents. The file name should not contain spaces. Write down the file path which Susan would use to store the file in the correct folder. Susan plans to work on her database at home. However, the database is very large so her teacher has told her that it needs to be reduced in size. She will then be able to attach it to an email so she can send it home. Explain why the file size would need to be reduced. 1 7
11. File management  →  11.1. Manage files effectively
18. Databases  →  18.1. Create a database structure
11. File management  →  11.2. Reduce file sizes for storage or transmission
Open
7
A family has purchased a wireless router for use in their home to allow their devices to be connected via WiFi to form a wireless local area network (WLAN). When the family purchased the wireless router they were advised to change the default password. Explain why they should change the default password. Describe the process of using WiFi to connect to a WLAN. [Turn over 1 7 Their son produces large complex diagrams on his desktop computer at home. He needs to be able to access the diagrams when he is at university. Even if reduced in file size, the diagrams would be too large to send using email. Describe in detail how he could transfer the diagrams from his home desktop computer to be able to access them at university, without using additional hardware. One of the parents in the family works for a government department and sends sensitive data from their home computer to the office.The data is encrypted before being sent to ensure it is harder to understand if it is intercepted. Describe four other preventative measures that could be taken to avoid network security issues. 1 7
8. Safety and security  →  8.3. Security of data
4. Networks and the effects of using them  →  4.2. Network issues and communication
Open
10
Aimi works for a shop that sells toys. She is setting up a relational database of the stock in the shop. She has started designing the database. Aimi has written down the questions that are asked about each toy and needs to produce appropriate field names from them. An example of the type of data that is to be stored is shown. What is the toy? Tawara Doll Who manufactured the toy? Tinky What year was it manufactured? 2020 What price was it bought for? $12.99 Complete the design table below by filling in an appropriate field name for each question. Each field name must be different. Field names must not include spaces. Field name Question What is the toy? Who manufactured the toy? What year was it manufactured? What price was it bought for? [Turn over 1 7 When Aimi created the whole database one of the fields was set as integer. However, as data is entered Aimi realises that the field should have been set to two decimal places. Describe the steps that need to be taken, by Aimi, to change the field from an integer to a decimal. This field will be set to two decimal places. Aimi created a relational database but could have created a flat file database. Discuss the advantages and disadvantages of using a relational database rather than a flat file database. 1 7
18. Databases  →  18.1. Create a database structure
7. The systems life cycle  →  7.2. Design
Open
11
Tawara College is setting up a new website for its older students. The website will publicise the events in the college, as well as revision and sporting activities. The headteacher wants the website to be attractive to the older students and it must meet their needs. Before the website can be produced the needs of the audience have to be taken into account. Analyse the needs of this audience. [Turn over 1 7
9. Audience  →  9.1. Audience appreciation
21. Website authoring  →  21.2. Create a web page
Open
12
The director of a zoo is writing a document about wallabies. He has taken an image of some wallabies () and is planning the layout of the pages which will include part of the image. The image he plans to use is shown in . Name the editing technique that was used to change to . 1 7 The director will include images and information about the wallabies in the document. Each page will be set out in 2 columns with a line between them. Describe the steps taken to create the columns. Assume the software has been loaded and the text has been entered. [Turn over 1 7 Describe the steps taken to add the image as shown. 1 7 As the document is being written for the zoo it needs to conform to the corporate house style. Explain what is meant by corporate house style. [Turn over 1 7
14. Styles  →  14.1. Style management
20. Spreadsheets  →  20.3. Present data
13. Layout  →  13.3. Headers and footers
Open
13
A student is looking for information on the internet for his school project. He has found a number of web pages that are useful. Explain the following terms when referring to web pages: Bookmark Anchor Hyperlink The student has found a website that is very useful and is planning to bookmark it. Describe the steps he will need to take to set up a bookmark for the website. 1 7
21. Website authoring  →  21.2. Create a web page
10. Communication  →  10.2. Effective use of the internet
Open