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

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

24 pages, 51 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 Foundation Tier G5802 [G5802] 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 80, including a maximum of 4 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 6279 (jun10G5802) Examiner Number 2 1 Leisa wants to buy a digital photo frame but needs help with some of the technical description. PC W orld/D 320 234 Resolution Stand for landscape or portrait mode Single image or slideshow mode 128 MB ROM Memory card expansion slot Wireless connection SGI PL C (a) (i) What does the term resolution mean? _____________________________________________________ ___________________________________________________[1] (ii) Why is resolution important when displaying computer graphics? _____________________________________________________ ___________________________________________________[1] (b) Draw a diagram in the space below to show what is meant by landscape mode. [1] 6279 (02) Examiner Only Marks Remark 3 (c) Draw a diagram in the space below to show what is meant by portrait mode. Examiner Only Marks Remark [1] (d) Give ONE way Leisa could use the wireless connection on the picture frame. _______________________________________________________________ _______________________________________________________[1] (e) Give ONE reason why she might need a memory card with the picture frame. _______________________________________________________________ _______________________________________________________[1] (f) The picture frame has ROM and accepts an SD memory card. State which is volatile and which is non-volatile. Storage Device Volatile/Non-volatile? ROM Chip SD Memory Card [2] (g) Leisa wants to print some of her photographs. Suggest a suitable printer for her. Total Question 1 _______________________________________________________[1] 6279 (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 circling the validation check which is being carried out on the Data Items shown. (The first is completed for you.) Data Item 2001 Error Message Validation check Membership number must be between 1 and 2000 Range check Type check Format check Length check @lexander Member name must contain text only Range check Type check Format check Length check 18th May 2010 Date of birth must be entered dd/mm/yy Range check Type check Format check Length check Part-time Membership type must be 3 characters long Range check Type check Format check Length check 30 Members should be over 16 and under 25 Range check Type check Format check Length check [4] 6279 (04) Remark 5 (b) Proof reading is one method of data verification. Describe ONE other method of data verification. Examiner Only Marks Remark _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________[2] Total Question 2 6279 (05) [Turn over 6 3 Ticketmaster have stores all over the UK and Ireland linked by a WAN. Computers inside the stores are linked by LANs. ADSL and ISDN can be used to provide communication links. (a) What do the following stand for? ADSL ________________________________________________ [1] ISDN ________________________________________________ [1] (b) Ticketmaster sometimes use Fax machines. Give ONE advantage and ONE disadvantage of using Fax machines to communicate. Advantage _______________________________________________ _______________________________________________________________ Disadvantage ____________________________________________ _______________________________________________________[2] 6279 (06) Examiner Only Marks Remark 7 (c) Ticketmaster need to keep customer data secure when it is being transmitted across the Internet. Examiner Only Marks Remark On the web page shown below circle TWO ways the customer can tell that the page is secure. https://www.ticketmaster.ie [2] (d) Give ONE advantage and ONE disadvantage of using wireless connections in the store s LAN. Advantage _______________________________________________________________ _______________________________________________________[1] Disadvantage _______________________________________________________________ Total Question 3 _______________________________________________________[1] 6279 (07) [Turn over 8 4 Neil has started a new taxi company and wants to create a database to keep records of his staff and bookings. He sets up the following tables in a relational database. 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 6279 (08) 9 (a) How many records will these queries return for Neil? Examiner Only Marks Remark (i) ___________________________________________________[1] (ii) ___________________________________________________[1] Use the data in the tables above to answer these questions. (b) Driver ID and Booking ID are set up as the key fields. What is meant by the term key field? _______________________________________________________[1] (c) Driver ID is used to link the two tables. Give ONE advantage of using a relational database to store data. _______________________________________________________________ _______________________________________________________[1] 6279 (09) [Turn over 10 Neil could use a flat file database to hold the data. Examiner Only Marks Remark (d) Explain what is meant by a flat file database. _______________________________________________________________ _______________________________________________________[1] Neil uses the following form to add details of new drivers to the database. (e) Give TWO ways Neil could improve the appearance of the form. 1. ___________________________________________________ [1] 2. ___________________________________________________ [1] Total Question 4 6279 (10) 11 5 The computers in the call centre that Patrick manages are linked via a LAN. Examiner Only Marks Remark (a) What do the letters LAN stand for? _______________________________________________________[1] (b) Give TWO advantages of using a LAN in an office. 1. ______________________________________________________ _______________________________________________________[1] 2. ______________________________________________________ _______________________________________________________[1] (c) The network is backed up each day. (i) 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 [2] Backups allow data to be restored if deleted accidentally. (ii) State TWO other hazards data on a computer network should be protected against. 1. ___________________________________________________ 2. ________________________________________________ [2] 6279 (11) [Turn over 12 (d) Why are different Levels of access needed on the network? Examiner Only Marks Remark _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________[2] Total Question 5 6279 (12) 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. (i) Advice: ___________________ ______________________________ (ii) Advice: ___________________ ___________________________ [1] ______________________________ ___________________________ [1] Advice: Chairs should have lower back support (http://www.codinghorror.com/blog/images/computing-ergonomics-monitor-position.png) To prevent fires it is important that electrical sockets in the workplace should not be overloaded. (b) Give TWO other safety measures that can help reduce the chance of accidents happening. 1. ______________________________________________________ _______________________________________________________[1] 2. ______________________________________________________ Total Question 6 _______________________________________________________[1] 6279 (13) [Turn over 14 7 Web browser software allows users to display HTML web pages they have retrieved from the Internet. (a) What do the letters HTML stand for? _______________________________________________________[1] (b) On the web page shown below (i) Circle the button you use to reload web pages. [1] (ii) Circle the button you use to view web pages you have visited. [1] c2kni (iii) Explain the function of the button labelled HOME on a web browser. _____________________________________________________ ___________________________________________________[1] 6279 (14) Examiner Only Marks Remark 15 Web pages can be accessed by typing their URL into the address bar. Examiner Only Marks Remark (c) What do the letters URL stand for? _______________________________________________________[1] Total Question 7 6279 (15) [Turn over 16 8 Electricity, gas and telephone bills are all produced using batch processing. Examiner Only Marks Remark (a) Use the words below to complete the following sentences to describe some of the steps involved in creating electricity bills using batch processing. Master File Transaction File Bill Details of current meter readings are entered onto the system in one batch. The current meter readings are then stored on a __________________ . This file is then merged with the old __________________ and the customer s __________________________ is printed. [3] (b) Batch processing systems normally process data outside normal work hours. Give ONE advantage of processing data at this time. _______________________________________________________________ _______________________________________________________[1] (c) Give ONE reason why batch processing is not used for online booking of flights. _______________________________________________________________ _______________________________________________________[1] Total Question 8 6279 (16) 17 9 Computer control systems are widely used in the home and in society today. Examiner Only Marks Remark (a) For each computer control system name the sensor used to record data. (i) Speed cameras: ___________________________________________________[1] (ii) Controlling a central heating system in the home: ___________________________________________________[1] (b) Use the words below to complete the sentences describing a greenhouse control system. Input Thermometer Processed Output The temperature is recorded using a __________________ . The temperature reading is __________________ into the system and __________________ to see if it is below 20 C or above 30 C. If the temperature is outside this range a signal is __________________ to turn the heating on or off. [4] (c) Give ONE other example of a computer control system used in the home. _______________________________________________________[1] Total Question 9 6279 (17) [Turn over 18 10 MIDI files are often used in digital recordings. Examiner Only Marks Remark (a) What do the letters MIDI stand for? _______________________________________________________[1] (b) 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 edited with the correct software The file quality deteriorates over time [2] (c) Digital recordings take sound waves in analogue format and convert them to digital using an ADC (Analogue to Digital Converter). Give ONE reason why this conversion is necessary. _______________________________________________________________ _______________________________________________________[1] Total Question 10 6279 (18) 19 11 Games consoles such as Xbox 360, Playstation 3, Nintendo Wii, Nintendo DS are widely available today. Examiner Only Marks Remark (a) Tick ( ) TWO statements that are TRUE about gaming technology today. Statement Tick ( ) Some games consoles can be connected to the Internet Virtual reality games are available on mobile phones All computer games can be bought in CD format Virtual reality games can now be found in some gaming arcades [2] (b) List TWO ways modern technology has helped improve the quality of gaming technology available today. 1. ______________________________________________________ _______________________________________________________[1] 2. ______________________________________________________ _______________________________________________________[1] (c) Identify TWO health problems that have developed as a result of people playing games for very long periods of time. 1. ______________________________________________________ _______________________________________________________[1] 2. ______________________________________________________ _______________________________________________________[1] 6279 (19) Total Question 11 [Turn over 20 12 Mobile phones have a variety of uses including making voice calls and messaging. (a) Identify TWO ways mobile phones can also be used as an entertainment device 1. ______________________________________________________ _______________________________________________________________ _______________________________________________________________ 2. ______________________________________________________ _______________________________________________________________ _______________________________________________________[2] (b) List TWO pieces of advice you would give to someone who wanted to purchase a mobile phone for use as an entertainment device. 1. ______________________________________________________ _______________________________________________________________ _______________________________________________________________ 2. ______________________________________________________ _______________________________________________________________ _______________________________________________________[2] 6279 (20) Examiner Only Marks Remark 21 (c) Identify TWO social problems that the increased use of mobile phones has brought about. Examiner Only Marks Remark 1. ______________________________________________________ _______________________________________________________________ _______________________________________________________________ 2. ______________________________________________________ _______________________________________________________________ _______________________________________________________[2] THIS IS THE END OF THE QUESTION PAPER Total Question 12 Quality of Written Communication 6279 (21) [Turn over (22) (23) 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. 110039 (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: