0417_w16_qp_11
A paper of Information and Communication Technology, 0417
Questions:
18
Year:
2016
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
There are a number of different internal hardware devices. Write down the most appropriate type of internal hardware that fits the following descriptions: A volatile device that is used to store data. This is the main printed circuit board found in computer systems. A non-volatile chip that stores the start-up commands. This electronic device provides a computer with the ability to produce sounds.
1. Types and components of computer systems  →  1.2. The main components of computer systems
1. Types and components of computer systems  →  1.1. Hardware and software
Open
4
Tick whether the following statements are true or false, when word processing a document. true (✓) false (✓) To set the page to landscape you select page orientation. The gutter margin is only on the left hand side of the page. A widow is where the last line of a paragraph appears as the first line of text on a new page. When you lock aspect ratio the width changes automatically as the height is increased.
17. Document production  →  17.1. Document layout
20. Spreadsheets  →  20.3. Present data
Open
5
John is working on a school History project and saves his work. He is told by one of his teachers that the school network has been infected by a computer virus. Explain what is meant by a computer virus and give examples of how a computer virus can affect a computer. John copies his History project from the school network onto his home computer using a pen drive. There are many ways his home computer can become infected by a computer virus. Describe three ways in which John could protect his home computer from being infected. The computer virus has attached itself to a file that John does not want to delete. Describe what John should do to remove the threat of the computer virus infecting other files.
8. Safety and security  →  8.3. Security of data
4. Networks and the effects of using them  →  4.2. Network issues and communication
Open
8
A soccer club is sending out renewal letters to all its members. The secretary of the club plans to write a standard letter and then mail merge this with the club’s database. Describe the process of mail merging. Having created the mail merge, the letters are sent out to the members. When the members received the letters, they noticed there were a number of errors. Give two precautions that the club should have taken to avoid these errors occurring. The soccer club wishes to publish player information on its website, but one of the members has pointed out that in a typical data protection act, personal data must be kept confidential and secure. Explain what is meant by personal data and why it should be kept confidential and secure.
8. Safety and security  →  8.3. Security of data
8. Safety and security  →  8.2. eSafety
Open
9
Virtual reality has an impact on everyday life. Name two devices that could be used with a virtual reality system. Virtual reality systems tend to be associated with gaming, but they are used in many different areas in everyday life. Give two uses for virtual reality in everyday life.
1. Types and components of computer systems  →  1.5. Emerging technologies
5. The effects of using IT  →  5.1. Microprocessor-controlled devices
2. Input and output devices  →  2.1. Input devices and their uses
Open
11
Users of a weather station launch a weather balloon into the upper atmosphere. An example of a sensor attached to the weather balloon would be a pressure sensor. Name one other sensor that should be attached to the balloon. The weather station continuously monitors the sensors on the weather balloon. Describe the monitoring process. The weather station could attach sensors to an aircraft and monitor the data as the aircraft flies through the upper atmosphere. Give three advantages of using the weather balloon rather than an aircraft.
Open
15
Blue Screen is a music band which is rapidly gaining success. They are planning a world tour and wish to organise their concerts efficiently. Two tables have been created in a database. One table contains details of the venues and another table contains details of the concerts. Table A: Venue details Venue ID Venue Name City Website Capacity WT1 Cambridge Open Air Arena Cambridge www.COAarena.com 12 500 WT2 Holmes Arena Auckland www.holmesarena.co.nz 12 500 WT3 Centinnel Stadium Beijing www.centinnel.com 17 000 WT4 Western Stadium California www.westernus.com 18 000 WT5 Pembroke Theatre Cambridge www.PCT.co.uk 15 000 Table B: Concert details Concert ID Location ID Date of concert Number of special tickets WT1 01/11/2016 WT2 01/12/2016 WT3 05/12/2016 WT2 02/12/2016 WT5 02/11/2016 WT1 03/11/2016 WT3 06/12/2016 Describe how a relational database can be created using tables A and B. Flat file databases are far less efficient than relational databases but they are still used. Describe the advantages of using a flat file database compared to a relational database.
18. Databases  →  18.1. Create a database structure
Open
17
A school is considering an educational trip to Iceland. There has been a meeting of parents and the school now requires that you set up a web page for inclusion on the school website. Use the following data provided by the parents’ committee to design a suitable web page for use by parents. Indicate the features that you would like to include to make it more interesting. Students depart from the school at 7:30 am on Saturday 15 November 2016. The hotel is the Excelsior Hotel in Reykjavik. A trip to watch whales off Greenland has been arranged. Students will return to the school on Saturday 22 November 2016. If you have any concerns contact the school.
10. Communication  →  10.2. Effective use of the internet
21. Website authoring  →  21.2. Create a web page
Open