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

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

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

	ccea_gcse	+Fave Message
	Profile Timeline Uploads Q & A

Home > ccea_gcse >

Formatting page ...

Centre Number Candidate Number General Certificate of Secondary Education 2007 Information and Communication Technology Full Course Paper 2 Higher Tier G5804 [G5804] THURSDAY 24 MAY, AFTERNOON TIME 1 hour. 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. Answer all eleven questions. For Examiner s use only Question Number 1 2 3 4 5 INFORMATION FOR CANDIDATES 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. 6 7 8 9 10 11 QWC Total Marks Marks Answer all eleven questions Examiner Only Marks 1 Lycos and Altavista are both examples of websites with search engine facilities. (a) Place a tick ( ) beside the correct definition of a search engine. Tick Websites that search for Internet documents containing files of a certain type Websites that search for Internet documents by key words or phrases Computer programs that search for Internet documents containing les of a certain type Computer programs which search for Internet documents by keywords or phrases [1] Remark (b) Mark wants to search the Internet for government information on the Data Protection Act (1998) but not the Data Protection Act (1984). Complete the complex search below to help him find the correct information. [3] Examiner Only Marks Remark Mark is organising his Internet favourites. Examiner Only Marks (c) He has chosen to make the webpage with his GCSE syllabus available offline, as shown in the screen dump above. Give one advantage of doing this. _________________________________________________________ ______________________________________________________ [1] Remark 2 EnergyFlow Gas Company creates customer bills using batch processing. A master file with the following fields holds data on their customers. Customer Number Name Address Last Meter Reading Current Meter Reading Units Used Total Their transaction file has the following fields. Customer Number Current Meter Reading Examiner Only Marks (a) What is a master file? _________________________________________________________ ______________________________________________________ [2] (b) What is a transaction file? _________________________________________________________ ______________________________________________________ [2] (c) Customers Current Meter Readings are recorded on OMR sheets. Give one advantage to the company of using these. _________________________________________________________ ______________________________________________________ [1] Remark (d) Why must the transaction file be sorted into the same order as the master file before processing? _________________________________________________________ ______________________________________________________ [1] (e) List two outputs created in batch processing. 1. _______________________________________________________ 2. ____________________________________________________ [2] Examiner Only Marks Remark 3 Mobiles 4 Many cannot decide between a flat-file and a relational database system to keep track of customers and their mobile phone orders. (a) Explain to the company why data held in a relational database is generally more secure than in a flat file database. _________________________________________________________ ______________________________________________________ [2] (b) Relational databases help maintain data integrity and reduce data redundancy. Explain the terms data integrity and data redundancy. Data integrity: ____________________________________________ ______________________________________________________ [1] Data redundancy: _________________________________________ ______________________________________________________ [1] Examiner Only Marks Remark (c) The company have decided to use a relational database. They have created the following two tables, but cannot decide which field to use to link them together. Table 1 Customer Number Customer Name Address Home Telephone Number Mobile Telephone Number Make Model Table 2: Customer Number Date of Purchase Examiner Only Marks (i) Which of the above fields would you use to link the two tables together? ___________________________________________________ [1] (ii) Say why you chose this field. ______________________________________________________ ___________________________________________________ [1] Remark 4 Brenda s Bakery is expanding to include shops all over Northern Ireland. Brenda wants to link all her stores via the Internet. Explain the following Internet related terms to Brenda. (a) Bandwidth _________________________________________________________ ______________________________________________________ [2] (b) Optical fibre _________________________________________________________ ______________________________________________________ [2] (c) ADSL _________________________________________________________ ______________________________________________________ [2] (d) Brenda would like to be able to use videoconferencing, but cannot decide if she should use the PSTN or Broadband. Say which you would recommend and give two reasons for your answer. Recommend: ___________________________________________ [1] Reason 1: ________________________________________________ ______________________________________________________ [1] Reason 2: ________________________________________________ ______________________________________________________ [1] Examiner Only Marks Remark (e) (i) List two items of hardware Brenda would need to connect to the Internet. 1. ____________________________________________________ 2. _________________________________________________ [2] (ii) Name one item of software Brenda would need to connect to the Internet. ___________________________________________________ [1] (f) Why are Protocols important in network communication? _________________________________________________________ ______________________________________________________ [2] Examiner Only Marks Remark 5 A local school is expanding its Local Area Network (LAN) to include a wireless connection. Printer Computer Suite Router Wireless Connector Server Student Laptop Student Laptop Internet (a) Give one advantage to the pupils of being able to access the network using wireless connection. _________________________________________________________ ______________________________________________________ [1] (b) Apart from security give one disadvantage to the school of using a wireless connection. _________________________________________________________ ______________________________________________________ [1] Examiner Only Marks Remark (c) Why does the school need a router? Examiner Only Marks _________________________________________________________ ______________________________________________________ [1] (d) List one task carried out by the operating system on a network. _________________________________________________________ ______________________________________________________ [1] (e) What type of storage media should the school use to back up their server? ______________________________________________________ [1] (f) How often should they back up their server? ______________________________________________________ [1] (g) The school want to make their Intranet and the Internet available to pupils. Give two differences between the Internet and the Intranet. 1. _______________________________________________________ _________________________________________________________ 2. _______________________________________________________ ______________________________________________________ [2] Remark 6 Supermarkets use Barcode Scanners to enter product details at the Electronic Point of Sale (EPOS) Terminal. Examiner Only Marks (a) Circle two output devices in the EPOS system shown below. [2] (b) Barcodes contain a check digit. Name two other items of data held on a supermarket barcode. 1. _______________________________________________________ 2. ____________________________________________________ [2] Remark (c) Put the following processes in order using the numbers 1 6 to show what happens when an item is scanned at an EPOS. Process Order Till beeps if match Price retrieved from store database Barcode is scanned using laser scanner Receipt printed Check digit is calculated and compared to scanned one Price displayed [6] (d) Give two disadvantages of using barcodes in a supermarket. 1. _______________________________________________________ 2. ____________________________________________________ [2] Check digits help validate the data being entered at the POS. There are many other validation checks carried out in computer systems. (e) (i) Explain the purpose of each of the following validation checks. Lookup Table: _________________________________________ ___________________________________________________ [1] Type Check: __________________________________________ ___________________________________________________ [1] Length Check: ________________________________________ ___________________________________________________ [1] Examiner Only Marks Remark (ii) Select the most appropriate validation check for the following data items. Each check can be used once only. Lookup Table Type Check Length Check Field Headings Staff Number Staff Name Job Title Validation Check Examiner Only Marks [3] (f) Another method of data checking is verification. What happens during data verification? _________________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [2] Remark 7 Martin wants to buy a new entertainment PC and has found the following one in PC Universe. 2.8 GHz Processor 2 MB Cache Microsoft Windows XP Media Centre 1024 MB RAM 4 GB ROM 400 GB Hard Disk Drive Multi-Format Dual Layer DVD RW Drive Wireless Keyboard + Mouse 32 HD Ready LCD TV (a) Microsoft Windows is said to be a GUI. What does GUI stand for? ______________________________________________________ [1] (b) Name two features of Microsoft Windows that make it user friendly. 1. _______________________________________________________ _________________________________________________________ 2. _______________________________________________________ ______________________________________________________ [2] Examiner Only Marks Remark (c) Why would an entertainment PC need a 400 GB hard disk drive? Examiner Only Marks _________________________________________________________ ______________________________________________________ [1] (d) Look at the specification for the PC. Select all memory types and categorise them as volatile or non-volatile memory types in the table below. Volatile Memory Types Non-Volatile Memory Types [4] (e) Tick ( ) the correct definition of cache memory in the table below. De nition Tick Stores the largest instructions used in processing Stores most frequently used instructions Stores data currently being processed Stores recovered les when programs do not respond [1] (f) When Martin starts up his PC the boot-up program is loaded into main memory from ROM. What does the acronym ROM stand for? ______________________________________________________ [1] Remark 8 Sitting incorrectly at a computer can cause health problems. Examiner Only Marks (a) List two different problems with the way this pupil is sitting at his PC and name the injury each may cause. Problem 1. _______________________________________________ _________________________________________________________ Injury: _______________________________________________ [2] Problem 2. _______________________________________________ _________________________________________________________ Injury: ________________________________________________ [2] Remark (b) List three features of an ergonomic workstation. Examiner Only Marks 1. _______________________________________________________ _________________________________________________________ 2. _______________________________________________________ _________________________________________________________ 3. _______________________________________________________ ______________________________________________________ [3] Remark 9 David has built a new conservatory. His heating system uses an embedded computer to keep the temperature between 24 C and 28 C at all times. The diagram below shows the system he uses. Sensor Heater Embedded Computer (a) What type of sensor is used in this system? ______________________________________________________ [1] (b) Explain how this system uses feedback to control the temperature in the room. _________________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [2] (c) Name two other devices in the home that use embedded computers for control. 1. _______________________________________________________ 2. ____________________________________________________ [2] (d) Give two other examples where feedback is used to control a process outside the home. 1. _______________________________________________________ 2. ____________________________________________________ [2] Examiner Only Marks Remark 10 Chris is entering a movie making competition in school. He has to use a MIDI keyboard to record the movie theme tune. (a) Expand the acronym MIDI. ______________________________________________________ [1] (b) Give one advantage of using a MIDI keyboard to record the theme tune instead of a conventional keyboard. _________________________________________________________ ______________________________________________________ [1] (c) Chris has carried out lots of research watching old movies on video tape and DVD. Give two advantages of DVD over video tape. 1. _______________________________________________________ 2. ____________________________________________________ [2] Examiner Only Marks Remark 11 Richardson s School of Music are introducing an online course for pupils to study music from home. The course will provide sample music for pupils to listen to and play along to. Examiner Only Marks Remark Discuss the impact this might have on the school, staff and students of the school. Where staff and students may be located. Think about the technology they may require. How it might change how they work/study. _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ _____________________________________________________________ __________________________________________________________ [6] Quality of written communication

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: