
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

UK GCSE 2010 : ICT - Full Course, Higher Tier, Paper 2

24 pages, 58 questions, 0 questions with responses, 0 total responses,

	ccea_gcse	+Fave Message
	Profile Timeline Uploads Q & A

Home > ccea_gcse >

Formatting page ...

Centre Number 7 1 Candidate Number General Certificate of Secondary Education 2010 Information and Communication Technology Full Course Paper 2 Higher Tier G5804 [G5804] THURSDAY 24 JUNE, MORNING For Examiner s use only Question Marks Number TIME 1 1 hour. 2 3 INSTRUCTIONS TO CANDIDATES Write your Centre Number and Candidate Number in the spaces provided at the top of this page. Write your answers in the spaces provided in this question paper. Complete in blue or black ink only. Do not write in pencil or with a gel pen. Answer all twelve questions. 4 5 6 7 8 INFORMATION FOR CANDIDATES 9 The total mark for this paper is 100, including a maximum of 5 marks for quality of written communication. Figures in brackets printed down the right-hand side of pages indicate the marks awarded to each question or part question. 10 11 12 QWC Total Marks 6273 (jun10G5804) Examiner Number 2 1 Leisa wants to buy a digital photo frame but needs help with some of the technical description. 320 234 Resolution Stand for landscape or portrait mode Single image or slideshow mode 128 MB ROM SD memory card expansion slot Wireless connectivity PC World/DSGI PLC (a) Explain the term resolution and say why it is important when displaying graphic images. _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ ______________________________________________________ [2] (b) Draw two diagrams in the space below to show what is meant by landscape and portrait modes. [1] 6273 (02) Examiner Only Marks Remark 3 (c) The picture frame has ROM memory and accepts an SD memory card. State which is volatile and which is non-volatile. Storage Device Examiner Only Marks Remark Volatile/Non-volatile? ROM Chip SD Memory Card [2] (d) Give ONE reason why the picture frame shown above would need expansion slots for memory cards when it already has its own memory chip. _______________________________________________________________ ______________________________________________________ [1] (e) Give TWO advantages of the picture frame having wireless connectivity. 1. ______________________________________________________ _______________________________________________________________ 2. ______________________________________________________ ______________________________________________________ [2] Total Question 1 6273 (03) [Turn over 4 2 Verification and validation help reduce errors when data is being entered into a computer system. Examiner Only Marks (a) Complete the table below by stating which definition is data validation and which is data verification. Definition Validation/Verification? Helps guarantee the accuracy of data being entered into a computer system Helps ensure that data being entered into the system is correct [2] (b) Complete the table below stating what type of validation check is being carried out on the Data Items shown. (The first is completed for you.) Data Item Error Message 2001 Membership number must be between 1 and 2000 @lexander Member name must contain text only 18/05/2000 Date of birth must be entered dd/mm/yy PT Membership type must be 3 characters long Field is left blank Validation check Range check Membership number cannot be left blank [4] 6273 (04) Remark 5 (c) Proof reading is one method of data verification. Describe ONE other method. Examiner Only Marks Remark _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ ______________________________________________________ [2] Total Question 2 6273 (05) [Turn over 6 3 Ticketmaster have stores all over the UK and Ireland in addition to their online store. To prevent double booking of tickets all of their stores are connected via a WAN (Wide Area Network). ADSL and ISDN can be used to provide WAN communication links. (a) Expand the acronym ISDN. ______________________________________________________ [1] (b) Give ONE advantage of using an ADSL over a traditional telephone line. _______________________________________________________________ ______________________________________________________ [1] (c) Give ONE disadvantage of using fibre optic cable for connecting stores via a WAN. _______________________________________________________________ ______________________________________________________ [1] Communication protocols are needed on networks. (d) What is a communications protocol? _______________________________________________________________ _______________________________________________________________ ______________________________________________________ [2] 6273 (06) Examiner Only Marks Remark 7 Customers personal data is often transmitted across WAN links by Ticketmaster. To keep their data secure they use encryption. Examiner Only Marks Remark (e) Explain the term encryption. _______________________________________________________________ _______________________________________________________________ ______________________________________________________ [2] Ticketmaster also use routers on their WAN. (f) Explain the purpose of a router on a network. _______________________________________________________________ ______________________________________________________ [2] Inside the stores a combination of cables and wireless connections are used to link the company s computers. (g) Give ONE advantage and ONE disadvantage of using wireless connections in a LAN. Advantage _______________________________________________________________ ______________________________________________________ [1] Disadvantage _______________________________________________________________ ______________________________________________________ [1] Total Question 3 6273 (07) [Turn over 8 4 Neil has started a new taxi firm and wants to create a database to keep records of his staff and bookings. He sets up the following tables in a relational database. Examiner Only Marks tblDriver Driver ID Driver Name Tel Num Car Reg Car capacity 100 N McFall 07766872363 UHY 8798 5 101 J McMasters 07712398762 JTG 9801 8 102 A McAllister 07712366177 CLZ 2290 5 103 R Jones 07799982771 OIL 2065 15 tblBooking Booking ID Driver ID Booking Name Date Time Pick-up Setdown Num Passengers 200 102 Cowden 01/05/10 12:00 Castlecourt Green Road 1 201 102 Brown 01/05/10 12:15 City Hall Lisburn Road 3 201 101 Gribben 01/05/10 12:15 Victoria Sq Ormeau Road 2 203 102 Ward 02/05/10 12:20 12 Belmont Road City Centre 2 205 100 Forrester 02/05/10 13:00 Forestside Belmont Road 1 206 102 Oswald 02/05/10 13:20 Belmont Road City Centre 1 (a) Identify ONE error Neil has made entering data into the Booking ID field in tblBooking. ______________________________________________________ [1] 6273 (08) Remark 9 Driver ID is the key field in tblDriver. Examiner Only Marks Remark (b) Why can Driver ID not be used as the key field in tblBooking? _______________________________________________________________ ______________________________________________________ [1] (c) Give ONE reason why Neil would not be able to add the following booking to tblBooking. Booking ID Driver ID Booking Name Date Time Pick-up Setdown Num Passengers 207 105 Grant 02/05/10 13:00 Castlecourt Boucher Road 3 _______________________________________________________________ ______________________________________________________ [1] Use the data in the tables shown to answer the following questions. (d) How many records will each of the following queries return for Neil? (i) __________________________________________________ [1] 6273 (09) [Turn over 10 (ii) Examiner Only Marks __________________________________________________ [1] (iii) __________________________________________________ [1] (e) Name ONE feature of a database application Neil might use to display the results of each query. ______________________________________________________ [1] He uses the following form to add details of new drivers to the database. 6273 (10) Remark 11 (f) Give TWO ways he could improve the appearance of the form. Examiner Only Marks Remark 1. ___________________________________________________ [1] 2. ___________________________________________________ [1] Relational databases are designed to help reduce data redundancy and improve data integrity. (g) (i) Place a tick ( ) beside the correct definition of data integrity in the table below. Tick ( ) Definition Data integrity refers to how correct and relevant the data is Data integrity refers to how correct and reliable the data is Data integrity refers to how accurate and normal the data is Data integrity refers to how accurate and irrelevant the data is [1] (ii) Explain what is meant by data redundancy. _____________________________________________________ _____________________________________________________ __________________________________________________ [1] (iii) Give ONE effect of data redundancy on the database. _____________________________________________________ __________________________________________________ [1] Total Question 4 6273 (11) [Turn over 12 5 Patrick manages a call centre. The computers in the call centre are linked via a LAN (Local Area Network). Examiner Only Marks Remark (a) Other than communication give TWO advantages of using a LAN in an office. 1. ______________________________________________________ ______________________________________________________ [1] 2. ______________________________________________________ ______________________________________________________ [1] (b) The network is backed up daily. Tick ( ) TWO storage media in the table below that are suitable for backing up a computer network. Storage media Tick ( ) Memory Stick DVD ROM Magnetic Tape External Hard Drive CD ROM [2] (c) Other than usernames and passwords and back up. Give ONE other method of providing security on a network. _______________________________________________________________ ______________________________________________________ [1] (d) Give TWO differences between a LAN and a WAN. 1. ______________________________________________________ _______________________________________________________________ 2. ______________________________________________________ ______________________________________________________ [2] 6273 (12) Total Question 5 13 6 Health and safety is important when working on a computer. Examiner Only Marks Remark (a) Finish labelling the diagram below to give advice to someone who will be working for long periods of time on a computer. Two labels have been completed for you. (i) Advice: ___________________ ________________________[1] Reason: ___________________ ________________________[1] (ii) Advice: ___________________ ________________________[1] Reason: ___________________ ________________________[1] Advice: Chairs should have lower back support Reason: Helps to reduce back strain (http://www.codinghorror.com/blog/images/computing-ergonomics-monitor-position.png) Electrical sockets in the workplace should not be overloaded to reduce the chance of fire occurring. (b) Give TWO other precautions that should be taken in the workplace to help reduce the likelihood of accidents occurring. 1. ______________________________________________________ ______________________________________________________ [1] 2. ______________________________________________________ Total Question 6 ______________________________________________________ [1] 6273 (13) [Turn over 14 7 Web browser software allows users to display HTML web pages they have retrieved from the Internet. (a) Expand the acronym HTML. ______________________________________________________ [1] (b) On the web page displayed below circle the navigation bar. [1] c2kni (c) Give ONE advantage of being able to display the browsing history when using a web browser. _______________________________________________________________ ______________________________________________________ [1] 6273 (14) Examiner Only Marks Remark 15 (d) Explain the function of the button labelled Home on a web browser. Examiner Only Marks Remark _______________________________________________________________ ______________________________________________________ [1] Web pages can be accessed by typing their URL into the address bar. (e) Expand the acronym URL. ______________________________________________________ [1] Total Question 7 6273 (15) [Turn over 16 8 Electricity, gas and telephone bills are all produced using batch processing. Examiner Only Marks Remark (a) Name ONE other application that uses batch processing. ______________________________________________________ [1] (b) Use the words below to complete the following sentences to describe the steps involved in creating electricity bills using batch processing. (note: not all words will be used) Master File Batch Error Report Bill Transaction File Turnaround Document Details of current meter readings are entered onto the system in one __________________ . Problem data results in an __________________ . Current meter readings are then stored on a __________________ which is then merged with the old __________________ so the customer s __________________________ can be calculated. [5] (c) In most batch processing systems the data is processed overnight. Give ONE advantage to the organisation of processing data at this time. _______________________________________________________________ ______________________________________________________ [1] (d) Give ONE reason why batch processing is not a suitable method for processing flights on an Internet-based booking system. _______________________________________________________________ Total Question 8 ______________________________________________________ [1] 6273 (16) 17 BLANK PAGE (Questions continue overleaf) 6273 (17) [Turn over 18 9 Computer control systems are widely used in the home and in society today. Examiner Only Marks (a) (i) Give TWO examples where computer control is used in traffic control systems. For each example list the sensor used to record data for the system. Example 1 ________________________________________ [1] Sensor 1 __________________________________________ [1] Example 2 ________________________________________ [1] Sensor 2 __________________________________________ [1] (ii) Give ONE advantage and ONE disadvantage of this application of computer control in society today. Advantage: _____________________________________________________ __________________________________________________ [1] Disadvantage: _____________________________________________________ __________________________________________________ [1] 6273 (18) Remark 19 (b) Feedback is an essential part of all control systems. Examiner Only Marks Remark Complete Step 5 in the following sequence for a feedback system to help illustrate how feedback is used to keep the temperature in a greenhouse between 20 C and 30 C. Step 1: The temperature is recorded using a thermometer. Step 2: The temperature reading is compared to see if it is below 20 C or above 30 C. Step 3: If the temperature is below 20 C the heating system is switched on. Step 4: If the temperature is above 30 C the windows are opened. Step 5: __________________________________________________ Step Step 5: _______________________________________________ [1] (c) Give ONE example of a computer control system used in the home. ______________________________________________________ [1] Total Question 9 6273 (19) [Turn over 20 10 Digital technology has altered the way we record, distribute and listen to music. Examiner Only Marks Remark (a) Digital recordings take sound waves in analogue format and converts them to digital using an ADC (Analogue to Digital Converter). Give ONE reason why this conversion is necessary. _______________________________________________________________ ______________________________________________________ [1] (b) Label the diagram below using the following terms Computer Speaker Microphone DAC ADC (i) ____________ (ii) ____________ (iii) __________ (iv) ____________ [4] (c) Tick ( ) TWO advantages of digital music recordings for the listener. Advantage Tick ( ) The file quality will remain the same at all times The file can be played on any audio device The file can be stored on a computer and played back The file quality deteriorates over time [2] 6273 (20) 21 (d) Other than improved sound quality, list TWO advantages of using MIDI technology to create music files. Examiner Only Marks Remark 1. ______________________________________________________ ______________________________________________________ [1] 2. ______________________________________________________ ______________________________________________________ [1] Total Question 10 6273 (21) [Turn over 22 11 Games consoles such as Xbox 360, Playstation 3, Nintendo Wii, Nintendo DS are widely available to teenagers today. Examiner Only Marks Remark (a) Tick ( ) THREE statements that are TRUE about gaming technology today. Statement Tick ( ) Some games consoles can be connected to the Internet for interactive gaming Virtual reality games are available for play via mobile phone technology All computer games are available for purchase in CD format Virtual reality games can now be found in some gaming arcades Games consoles now come with a variety of peripherals to allow interaction with the game [3] (b) State TWO advances in technology that have helped improve the quality of computer gaming today. 1. ______________________________________________________ ______________________________________________________ [1] 2. ______________________________________________________ ______________________________________________________ [1] (c) Computer gaming has also had a negative impact on society. Give TWO health problems that have developed as a result of long term gaming. 1. ______________________________________________________ ______________________________________________________ [1] 2. ______________________________________________________ ______________________________________________________ [1] 6273 (22) Total Question 11 23 12 Mobile phones have a variety of uses including making voice calls and messaging. They can also be used as entertainment devices. Examiner Only Marks Remark (a) Identify TWO ways a mobile phone can be used as an entertainment device and give TWO pieces of advice to someone who wants to use a mobile phone in this way. _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ (b) Identify TWO ways in which the increased use of mobile phones has impacted on society. _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ ______________________________________________________ [6] Total Question 12 THIS IS THE END OF THE QUESTION PAPER 6273 (23) Quality of Written Communication [Turn over Permission to reproduce all copyright material has been applied for. In some cases, efforts to contact copyright holders may have been unsuccessful and CCEA will be happy to rectify any omissions of acknowledgement in future if noti ed. 110041 (24)

Formatting page ...

Tags : united kingdom (ccea - gcse), council for the curriculum, examinations and assessment - general certificate of secondary education, gcse past papers, gcse question papers, gcse exam, gcse old exam papers, gcse exam boards, gcse practice question papers.

ccea_gcse chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: