0417_w19_qp_11
A paper of Information and Communication Technology, 0417
Questions:
16
Year:
2019
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
2
The introduction of computers into the workplace has had an effect on working patterns. Name the most appropriate working pattern that matches the descriptions given below. Working fewer hours a week than full-time staff. Workers have some say in when they start and finish work but must work a full day. One full-time job is divided between two workers. A worker works the required hours but in a fewer number of days.
1. Types and components of computer systems  →  1.4. Types of computer
10. Communication  →  10.2. Effective use of the internet
Open
3
A manager of a company based in North America is planning a meeting with colleagues in Australia. He could hold a video-conference or a face-to-face meeting. A face-to-face meeting is when the colleagues attending the meeting are all together physically in one room. Give three advantages of holding a video-conference rather than a face-to-face meeting. Give three disadvantages of holding a video-conference rather than a face-to-face meeting.
4. Networks and the effects of using them  →  4.2. Network issues and communication
10. Communication  →  10.2. Effective use of the internet
Open
7
You have been asked by your teacher to use a word processor to create a brochure for a new intake of pupils. The brochure will consist of: • Images of the school taken from a digital camera. • Printed archive photographs. • Information about the school already stored as text files. • Information to be typed directly into the brochure. Describe the steps which you will need to take to create the brochure. When the brochure is being created, the word processing software automatically checks the spelling of the text as it is typed in and may suggest alternative words. Explain why the suggestions may not always be appropriate. The teacher wishes to send the brochure as an email attachment to all the head teachers of the local primary schools. Explain why she would create an email group to include all the email addresses of the head teachers. The head teacher has purchased a computer with a large monitor and speakers to display information about the school. It is placed in the entrance of the school where visitors wait. You have been asked to produce a set of presentation slides to show features of the school. The head teacher has recorded an audio message which is to be included in the presentation. Describe the steps that you would take to set up the audio message so that it plays as the presentation runs.
7. The systems life cycle  →  7.1. Analysis
10. Communication  →  10.1. Communication with other ICT users using email
10. Communication  →  10.2. Effective use of the internet
Open
8
A company is planning to improve its computer system. They have employed a systems analyst who is recording and analysing information about the current system. Describe why he needs to identify the inputs, processing and outputs of the current system. The systems analyst recommends that new software is required. The analyst could either write the software or purchase it off the shelf. Give two advantages to the company of purchasing off the shelf software for the new system.
7. The systems life cycle  →  7.1. Analysis
1. Types and components of computer systems  →  1.1. Hardware and software
Open
9
Fabian runs a film club. He has created a spreadsheet to display information about the films he shows. Part of the spreadsheet is shown. A B C D Searches Year =COUNTIF(B6:B11,C1) Director Film Type Film_Title Year_Released Director Film_Type La Ba Land David Challe Musical Wizard of Down under Stanley Leving Musical The Turfs 6 Jane Banbury Childrens Illusion 5 Jason Blair Action/Animation How to Train your Cat 3 Sean Bluel Action Lost City of C Steven Red Action Using the example of COUNTIF(B6:B11,C1), explain how a COUNTIF function works. There are more than 50 rows in the spreadsheet. Fabian needs to be able to see the top five rows at all times as he is scrolling down the spreadsheet. State the steps he needs to take to ensure this happens.
Open
10
E-safety is very important when using the internet. It is very easy to accidentally reveal personal data to others when using social networking sites. Describe three strategies, giving reasons for each one, which you would take to avoid revealing personal information when using social networking sites. Strategy 1 Reason 1 Strategy 2 Reason 2 Strategy 3 Reason 3 Confidential personal data is sensitive data. Name three items of personal data that could be sensitive data.
8. Safety and security  →  8.2. eSafety
Open
11
When a student has finished working on an existing file, the software gives her two options, Save and Save As. Explain two differences between Save and Save As. When files are saved on a computer they can be saved in other formats that can reduce their file size. Give reasons why file sizes may need to be reduced.
11. File management  →  11.2. Reduce file sizes for storage or transmission
18. Databases  →  18.1. Create a database structure
1. Types and components of computer systems  →  1.2. The main components of computer systems
Open