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

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

20 pages, 61 questions, 0 questions with responses, 0 total responses,

	ccea_gcse	+Fave Message
	Profile Timeline Uploads Q & A

Home > ccea_gcse >

Formatting page ...

Centre Number 71 Candidate Number General Certificate of Secondary Education 2008 Information and Communication Technology Paper 2 Higher Tier G5804 Full Course [G5804] FRIDAY 6 JUNE, MORNING TIME 1 hour. For Examiner s use only 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. Question Number 1 2 3 4 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. 5 6 7 8 9 10 11 QWC Total Marks G584S8 3861 Marks Answer all eleven questions Examiner Only Marks 1 Remark Gerald wants to get a new mobile phone. He wants to use his phone to take pictures and video clips to upload on to his skateboarding website. He cannot decide between these two phones. PHONE A Includes . . . 2 Megapixel camera Video MP3 GPRS Email Bluetooth 256k colour screen PHONE B Includes . . . 3 Megapixel camera Video MP3 GPRS Email Bluetooth Quadband 256k colour screen (a) Which phone would you recommend he uses (A or B) and why? Phone: _______________________________________________________ [1] Reason: __________________________________________________________ _______________________________________________________ [1] G584S8 3861 2 [Turn over (b) Gerald can use Bluetooth to send video clips to his friends. Give one reason why he would use Bluetooth instead of a multimedia text message. Examiner Only Marks Remark _______________________________________________________ [1] (c) Apart from transferring files to another phone, give one other use Gerald might have for a Bluetooth connection. _______________________________________________________ [1] (d) If he wanted to access the Internet using his mobile phone Gerald would have to make sure he had WAP. Expand the acronym WAP. _______________________________________________________ [1] G584S8 3861 3 [Turn over 2 MegaMovies wants to create a database to store information on the movies they sell online. They cannot decide between a flat file or a relational database. Examiner Only Marks Remark (a) List two differences between a flat file and a relational database. 1. ________________________________________________________ _____________________________________________________ [1] 2. ________________________________________________________ _____________________________________________________ [1] They decide to create a relational database with the following tables. Customer Table Customer number Surname Forename Address 1000 King Margaret 21 Blacks Belfast Road BT11 8UJ 02890876542 1001 Small Jack 14 Simons Court Newry BT34 9IK 0289745109 1002 Briggs John 13 Railway Road Armagh BT67 9AS 02835472157 1004 Walsh Lex 11 Park Lane Belfast BT12 8IK 02890762541 1005 Templeton Andy Omagh 34 Robinson Drive BT79 9CS 02876120984 Town/City Postcode Telephone number Order Table Order number Customer number Movie title Movie price Date posted 9000 1001 Ice Age 3 9.99 12/01/07 9001 1005 Shrek 3 8.99 14/01/07 9002 1004 Spider Man 3 7.99 16/02/07 9003 1004 The Break Up 6.99 16/02/07 Examiner Only (b) What is a key field? Marks Remark _______________________________________________________ [1] G584S8 3861 4 [Turn over (c) Why does the Customer number appear in both tables? Examiner Only Marks Remark _______________________________________________________ [1] (d) Suggest one reason why there is no Customer number 1003 in the Customer Table. _______________________________________________________ [1] (e) Highlight one complete record on the copy of the Order Table shown below. Order Table Order number Customer number Movie title Movie price Date posted 9000 1001 Ice Age 3 9.99 12/01/07 9001 1005 Shrek 3 8.99 14/01/07 9002 1004 Spider Man 3 7.99 16/02/07 9003 1004 The Break Up 6.99 16/02/07 [1] (f) Suggest suitable data types for each of the fields listed below. The first one is completed for you. Field name Customer number Data type Numeric Order number Movie title Movie price Date posted [4] (g) When setting up the Customer Table the Surname field size was changed from 50 to 25. Suggest one reason for this. _______________________________________________________ [1] G584S8 3861 5 [Turn over The Customer and Order tables are linked as shown below. Examiner Only Marks Customer Table Remark Order Table (h) (i) Place a tick ( ) beside the type of relationship that has been created. Relationship type Tick One-to-One One-to-Many Many-To-Many [1] The company use the following flat file to keep track of their staff sales. Staff number Staff surname Staff forename Job Movie 1 Little Patrick Sales Shrek 3 2 Steele Mervyn Sales The Break Up 3 Kidd Stuart Manager Spider Man 3 1 Little Patrick Sales Rocky V The use of a flat file database can lead to data redundancy and loss of data integrity. (ii) Use one example from the table above to explain the term data redundancy. ______________________________________________________ ______________________________________________________ ____________________________________________________ [2] (iii) Explain what is meant by data integrity. ______________________________________________________ ____________________________________________________ [2] G584S8 3861 6 [Turn over 3 Peter has just started a web design company in Armagh. He employs two other members of staff. One lives in Dublin, the other lives in Belfast. Examiner Only Marks Remark (a) Peter and his staff use teleworking to share ideas, develop web sites and transfer high quality graphics. (i) Give two advantages to Peter of his staff using teleworking. 1. __________________________________________________ [1] 2. __________________________________________________ [1] (ii) Give two advantages to the staff of using teleworking. 1. __________________________________________________ [1] 2. __________________________________________________ [1] (b) Peter has recommended that his staff have access to an ADSL line as opposed to a dial-up connection for Internet communication. (i) Expand the acronym ADSL. ____________________________________________________ [1] (ii) Why would a dial-up connection not be suitable for this type of work? ______________________________________________________ ____________________________________________________ [1] (c) Peter is concerned about the health and safety of his staff. List two pieces of advice he could give to his staff to help reduce RSI. 1. _____________________________________________________ [1] 2. _____________________________________________________ [1] (d) Peter emails graphics and video clips to his staff. Give one advantage of email over traditional postage. _______________________________________________________ [1] G584S8 3861 7 [Turn over 4 Ruth s ICT teacher uses OCR to make electronic copies of past papers so they can be uploaded on to the school Intranet for pupils to revise from. Examiner Only Marks Remark (a) Expand the acronym OCR. _______________________________________________________ [1] (b) Number each step 1 4 to illustrate the order of processing when converting a document into text using OCR. Page of text Scanner Step Process Special software converts the graphic to text A text-based version of the document is stored on the computer OCR A page of information is input using a scanner A graphic image of the page is stored on the computer [4] (c) Give one advantage to the teacher of using OCR technology to scan the document. _______________________________________________________ [1] (d) Ruth suggests that her teacher converts the document into PDF format. Give one way a PDF document is different from a text-based file. _______________________________________________________ [1] (e) List one other possible use of OCR technology. _______________________________________________________ [1] G584S8 3861 8 [Turn over (f) The school also uses OMR technology for marking the morning register. Some staff would prefer to mark the registers directly on to the school computer system. Examiner Only Marks Remark (i) Give one advantage of using OMR over entering data directly on to the computer system. ____________________________________________________ [1] (ii) Give one advantage of entering the marks directly on to the computer system over using OMR. ____________________________________________________ [1] G584S8 3861 9 [Turn over 5 Two schools are working together on a project using video conferencing and a WAN (Wide Area Network). Examiner Only Marks Remark (a) Apart from a computer list two items of hardware the schools would need for video conferencing. 1. _____________________________________________________ [1] 2. _____________________________________________________ [1] (b) Say whether they would require an ADSL or a PSTN communication link before they could use video conferencing. Give one difference between ADSL and PSTN. Link: __________________________________________________ [1] Difference: _____________________________________________ [1] (c) The schools would like to publish the project on a website so they can get feedback from others. List two ways information can be submitted via a website. 1. _____________________________________________________ [1] 2. _____________________________________________________ [1] (d) Before the schools can publish their information on the Internet they must know the URL of the site they are going to use. Expand the acronym URL. _______________________________________________________ [1] G584S8 3861 10 [Turn over The school uses the Internet and the Intranet to provide students with information. Examiner Only Marks Remark (e) List two ways teachers might use the Intranet to share information with pupils. 1. _______________________________________________________ _______________________________________________________ [1] 2. ______________________________________________________ ______________________________________________________ [1] (f) Explain the difference between the WWW (World Wide Web) and the Internet. __________________________________________________________ _______________________________________________________ [2] (g) Network protocols are used when data is being transferred between various users. Tick ( ) two statements that are true about network protocols. Statement True They are used to determine the bandwidth of a communication link. They are a set of rules that govern network communication. They are used to calculate the cost of your monthly Internet subscription. They allow data to be sent between computers of different types. [2] G584S8 3861 11 [Turn over 6 Ashlinn is using data logging to record information on cooling rates for a science experiment. The data logging software is set to take readings every 15 seconds for 30 minutes. Sensor Examiner Only Marks Remark Computer Interface (a) Why does she require an interface? __________________________________________________________ _______________________________________________________ [2] (b) From the information given, identify the data logging period and the recording time intervals in this experiment. Data logging period: ______________________________________ [1] Recording time intervals: __________________________________ [1] (c) Ashlinn stores the results in a spreadsheet. It is laid out without any formatting. Give one way she could format the headings in the spreadsheet to make them stand out from the data she has recorded. _______________________________________________________ [1] (d) She then wants to import the results into a word processing document. What does the word import mean? _______________________________________________________ [1] (e) Give two advantages of using a data logging system to record the data over manual recording. 1. _____________________________________________________ [1] 2. _____________________________________________________ [1] (f) As part of her technology coursework, Ashlinn is also looking at the use of control systems used in traffic lights. Explain one difference between data logging and control. _________________________________________________________ _______________________________________________________ [1] G584S8 3861 12 [Turn over 7 A photographer is setting up a new studio in Belfast and cannot decide if he should use digital or traditional film cameras. Examiner Only Marks Remark (a) Give two advantages of using digital photography over traditional photography. 1. _____________________________________________________ [1] 2. _____________________________________________________ [1] (b) He also needs to be able to communicate with staff in another studio in London but cannot decide if he should use email or fax communication. (i) Give two advantages of email communication over fax or telephone communication. 1. __________________________________________________ [1] 2. __________________________________________________ [1] (ii) Give one advantage of telephone communication over email communication. ____________________________________________________ [1] G584S8 3861 13 [Turn over 8 Simon is creating a website for his ICT coursework. He includes video clips and animated graphics as well as photographs on his website. Examiner Only Marks Remark (a) From the words below, circle the file type Simon would use to save his video clip. mpeg tiff gif csv [1] (b) Simon has been advised not to use bitmap graphics when inserting graphics into his website. (i) Why is this file format not appropriate? ____________________________________________________ [1] (ii) Circle one suitable alternative from the list below. mpeg tiff gif csv [1] (c) Simon has included a photo gallery where all of his graphics are displayed as thumbnail images. What is a thumbnail image? __________________________________________________________ _______________________________________________________ [1] (d) Simon has included an email hyperlink on his Home Page. What is an email hyperlink? __________________________________________________________ _______________________________________________________ [1] G584S8 3861 14 [Turn over 9 MiniMart have introduced a new EFTPOS (Electronic Funds Transfer Point of Sale) terminal to allow them to process customers purchases. Examiner Only Marks Remark (a) Give two advantages of EFTPOS to the customer. 1. _____________________________________________________ [1] 2. _____________________________________________________ [1] (b) Give one disadvantage of EFTPOS to the owner of MiniMart. _______________________________________________________ [1] (c) Name one input device and one output device needed at the EFTPOS. Input Device: ____________________________________________ [1] Output Device: __________________________________________ [1] One EFTPOS terminal allows customers to scan their own products and pay for their goods. (d) Give one advantage to MiniMart of using this type of EFTPOS. __________________________________________________________ _______________________________________________________ [1] G584S8 3861 15 [Turn over 10 A new call centre is setting up a batch processing system for managing payroll. Examiner Only Marks Remark (a) Explain the term batch processing. __________________________________________________________ _______________________________________________________ [2] (b) Name one other application where batch processing is used. _______________________________________________________ [1] (c) Some computer systems use real-time processing. (i) What is real-time processing? ______________________________________________________ ____________________________________________________ [2] (ii) Give one example where real-time processing might be used. ____________________________________________________ [1] G584S8 3861 16 [Turn over Data being input to a computer system is often validated. (d) (i) Describe the purpose of each of the following validation checks, and give one example of how they might be used. The first one is completed for you. Validation check Type check Purpose To ensure only certain data types are entered into a field Example To make sure only numbers are typed into a telephone number field in a database. Presence check Range check Examiner Only [4] Marks Remark (ii) Why is it important that the master file and the transaction file are sorted into the same order before data can be processed using batch processing? _____________________________________________________ __________________________________________________ [1] G584S8 3861 17 [Turn over 11 Information and Communication Technology has had an impact on the type of jobs available in today s society. Examiner Only Marks Remark (a) Identify two jobs that have been completely replaced by ICT. Say whether you think these jobs are carried out more efficiently by ICT and why. 1. ______________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ 2. ______________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [4] (b) ICT has improved the way we work in today s society. Give two reasons to back up this statement. 1. ______________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ 2. ______________________________________________________ _________________________________________________________ _________________________________________________________ ______________________________________________________ [2] Quality of written communication [5] G584S8 3861 18 [Turn over THIS IS THE END OF THE QUESTION PAPER G583H8 G583H8 0000 19 [Turn [Turn over S 9/07 529-011-1 0

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: