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

UK GCSE 2009 : ICT - Full Course, Foundation Tier, Paper 1

28 pages, 74 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 2009 Information and Communication Technology Paper 1 Foundation Tier G5801 Full Course [G5801] TUESDAY 19 MAY, AFTERNOON For Examiner s use only 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 fourteen questions. Question Number 1 2 3 4 5 6 7 INFORMATION FOR CANDIDATES The total mark for this paper is 100, including a maximum of 5 marks for the 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. 8 9 10 11 12 13 14 QWC Total Marks 4547 Marks Answer all fourteen questions Examiner Only Marks Remark For question 1 insert the appropriate letter in the space provided. 1 (a) Select the most appropriate input device for free-hand drawing on a graphics package. A Mouse B Keyboard C Light Pen D Hand-held Scanner Answer ___________ [1] (b) Select the most appropriate output device for creating a hard copy of a receipt at a supermarket till. A Printer B LCD C Plotter D VDU Answer ___________ [1] (c) Select the most appropriate storage device for storing pictures on a mobile phone. A SIM Card B Network Card C Memory Card D Graphics Card Answer ___________ [1] 4547 2 [Turn over (d) Select one task that cannot be carried out when banking online. Examiner Only Marks A Depositing money B Ordering a new cheque book C Paying bills D Remark Cancelling direct debits Answer ___________ [1] (e) Select one advantage of storing graphics in bitmap format. A Images are built up in layers B Image quality is good C Images can be edited at pixel level D Images take up very little storage space Answer ___________ [1] (f) A web browser: A Allows users to enlarge text, cannot be used without being connected to the Internet B Allows users to enlarge text, can be used without being connected to the Internet C Does not allow users to enlarge text, allows users to enter URLs D Does not allow users to enlarge text, does not allow users to enter URLs Answer ___________ [1] 4547 3 [Turn over (g) To perform a mail merge means: Examiner Only Marks A To merge data from a database onto a letter and produce personalised letters B To merge text from two letters to produce personalised letters C To use a database to send a personalised letter to a group of people D Remark To send a personalised letter Answer ___________ [1] (h) An ATM: A Is an Automatic Teller Machine and can be used to top up some mobile phones B Is an Automatic Teller Machine and can be used to open a bank account C Is an Automatic Technical Machine and can be used to top up some mobile phones D Is an Automatic Technical Machine and can be used to open a bank account Answer ___________ [1] (i) The operating system of a computer: A Is hardware which helps to manage the computer system B Is software which helps to manage the computer system C Is hardware which creates programs for use by the computer system D Is software which creates programs for use by the computer system Answer ___________ [1] 4547 4 [Turn over (j) A csv file is a: Examiner Only Marks A completely separated variable file B comma separated variable file C comma sequenced variable file D Remark completely sequenced variable file Answer ___________ [1] 4547 5 [Turn over 2 Computers are used to control traffic light systems. An interface is also used to help process the data. Examiner Only Marks Remark (a) From the table below, tick ( ) two sensors which could be used in the traffic light system. Tick ( ) Sensor Heat Light Pressure Motion [2] (b) What does the interface do in the control system? _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] 3 Mark is a music teacher. He wishes to use a computer to help him to create training material. (a) From the list below, select the most appropriate file format for each output which Mark is going to produce. (Use each file format only once) jpeg mp3 doc Output File Format Printed copies of instructions on how to play his music Sound files of him playing his music Images of the instruments he teaches 4547 [3] 6 [Turn over Mark has decided to set up a website to promote his business. Examiner Only Marks Remark (b) Give two advantages to Mark to encourage him to do this. 1. _______________________________________________________ _________________________________________________________ 2. _______________________________________________________ _______________________________________________________ [2] Mark will need equipment to connect to the Internet. (c) From the list he has written below, select using a tick ( ), the two items he will require to connect to the Internet. Tick ( ) Equipment Word processor Browser MODEM Telecommunications link [2] Mark decides to sell his products on DVD from a stand in the local shopping centre. (d) What do the letters DVD stand for? _______________________________________________________ [1] 4547 7 [Turn over 4 A local solicitors office has installed a new LAN with 30 computers and a server. The LAN also provides Internet access for the solicitors. Examiner Only Marks Remark (a) (i) What do the letters LAN stand for? ___________________________________________________ [1] (ii) Give one advantage of having a network in the solicitors office. _____________________________________________________ ___________________________________________________ [1] (iii) Give one disadvantage of having a network in the office. _____________________________________________________ ___________________________________________________ [1] (b) The solicitors are going to set up a video conference with another office in France. (i) What is video conferencing? _____________________________________________________ ___________________________________________________ [1] (ii) List three devices which would be required to provide video conferencing in the office. 1. ___________________________________________________ 2. ___________________________________________________ 3. _________________________________________________ [3] (iii) Give one advantage to the solicitors of using video conferencing instead of a telephone to talk to solicitors in other countries. _____________________________________________________ ___________________________________________________ [1] 4547 8 [Turn over The company have had a fax machine for many years. Examiner Only Marks Remark (iv) Give one disadvantage of using a fax machine instead of email. _______________________________________________________ [1] (v) Give one use for the fax machine where email is unlikely to be used in the solicitors office. _______________________________________________________ [1] 4547 9 [Turn over 5 (a) A company, GAMESTATION LTD, which develops games software, cannot find people with the correct skills in the local area. They have decided to offer teleworking contracts. Examiner Only Marks Remark (i) What is teleworking? _____________________________________________________ _____________________________________________________ ___________________________________________________ [2] (ii) Give two advantages to the company of using teleworking. _____________________________________________________ ___________________________________________________ [2] 4547 10 [Turn over GAMESTATION LTD are developing a driving simulation game for the PC. Examiner Only Marks Remark (b) A lot of RAM and a high resolution monitor is needed to run the new game. (i) What do the letters RAM stand for? ___________________________________________________ [1] (ii) What does high resolution mean when referring to the monitor? _____________________________________________________ ___________________________________________________ [1] GAMESTATION LTD have decided to make the game available online. Players must fill out the online form below. (c) Which law must GAMESTATION LTD uphold when managing personal data? _______________________________________________________ [1] 4547 11 [Turn over 6 (a) Holiday Villa Hotels allow reservations to be made online, by email, by telephone, or by faxing the central reservations. Examiner Only Marks Remark Holiday Villa Hotels give special offers online. (i) Give one other advantage to the customer of booking a hotel online. ___________________________________________________ [1] (ii) State one reason why a customer may still choose to book by telephone. ___________________________________________________ [1] As well as using the (World Wide Web) WWW and Internet for business, the company provide an Intranet for employees. (b) (i) From the table below tick ( ) which two of the following statements are true about the WWW and the Internet. Tick ( ) Statement The WWW is the information stored on the Internet The Internet is a set of web addresses The Internet is a network of computers and communication links The WWW is a set of web addresses [2] (ii) What is an Intranet? _____________________________________________________ ___________________________________________________ [1] 4547 12 [Turn over 7 Barry runs a small printing company. He wants to store details about his clients and when they first ordered from him, in a database. Examiner Only Marks Remark (a) Complete the following paragraph using the words provided. Use each word only once. RECORDS FORMS FIELDS Data is stored in tables of ________________. Each record is made up of ________________. ________________ can be used to capture data on screen. [3] (b) List two features of a database which Barry could use to provide his business with information. 1. ______________________________________________________ 2. ____________________________________________________ [2] 4547 13 [Turn over 8 Clarendon Limos are a small Limousine hire company. They have four cars for hire. Below is a spreadsheet with their car hire information for the month of November 2008. A B C D E F G Fuel Cost Per Hour Total Fuel Cost Total Pro t for each Car Clarendon Limos Income November 2008 1 Cost Per Hour Number of Hours Hired Total Income 2 Car 3 Yellow Hummer Vehicle 400.00 35 14 000.00 100.00 3 500.00 10 500.00 4 Stretch Limousine 500.00 19 9 500.00 120.00 2 280.00 7 220.00 5 Stretch Hummer Vehicle 550.00 9 4 950.00 115.00 1 035.00 3 915.00 6 Pink Cadillac 700.00 10 7 000.00 140.00 1 400.00 5 600.00 7 8 Total Pro t 27 235.00 Examiner Only (a) Cells A8:F8 have been: (circle the correct answer from the list below) Cleared Merged Pasted Marks Remark [1] (b) Using cell references, write down the formula used in each of the following cells. (i) D6 ________________________________________________ [1] (ii) G6 ________________________________________________ [1] The Cost Per Hour for the Stretch Limousine has been changed to 600.00. (c) List three other cells that change as a result of this. 1. _______________________________________________________ 2. _______________________________________________________ 3. _____________________________________________________ [3] 4547 14 [Turn over The chart below has been produced from the spreadsheet data. Examiner Only Marks Remark Clarendon Limos Yellow Hummer Vehicle 5600.00 10 500.00 Stretch Limousine Stretch Hummer Vehicle 3915.00 Pink Cadillac 7220.00 (d) (i) What type of chart is this? ___________________________________________________ [1] (ii) List the cell references of the two cell ranges used to produce this chart. Cell range 1: __________________________________________ Cell range 2: ________________________________________ [2] (iii) Name one other chart type which can be produced using data from cells on a spreadsheet. ___________________________________________________ [1] (iv) Give one advantage to Clarendon Limos of viewing information in chart form. _____________________________________________________ ___________________________________________________ [1] (v) Give one piece of information that Clarendon Limos can see by examining the chart. _____________________________________________________ ___________________________________________________ [1] 4547 15 [Turn over 9 Arlene is word processing her Chemistry coursework. Examiner Only Marks Remark She wishes to include her candidate number in a header and page numbers in a footer. (a) What is a footer? _________________________________________________________ _______________________________________________________ [1] After she has added her page numbers to the document she chooses to look at a print preview of the document. (b) Give one reason why she might do this. _________________________________________________________ _______________________________________________________ [1] Arlene has copied a graphic from the Internet. When it is clicked she is automatically taken to the original website. (c) Why does this happen? _________________________________________________________ _______________________________________________________ [1] When she runs the spellchecker it highlights a lot of words that Arlene knows are spelt correctly. (d) Give one reason why the spellchecker might still highlight these. _________________________________________________________ _______________________________________________________ [1] (e) Give one example when the spellchecker may not highlight a word when it is spelt incorrectly. _________________________________________________________ _______________________________________________________ [1] 4547 16 [Turn over BLANK PAGE (Questions continue overleaf) 4547 17 [Turn over 10 SunShine Properties sell houses all around the world. One of their employees wants to send an email to their manager at manager@sunshineproperties.co.uk. Examiner Only Marks Remark (a) Read and complete the following email to the manager so that: (i) The employee is sending the email to the correct person and [1] (ii) The person receiving the email knows what it relates to before they open it [1] Examiner Only The warning shown on the email tells the employee that Attachments may not display correctly. Marks Remark (b) Give one reason why attachments may not display correctly when they are opened by the recipient. _________________________________________________________ _______________________________________________________ [1] 4547 18 [Turn over The agent needs to send a copy of the email to Mr and Mrs Reain as well as their manager, but does not want them to see the email address for their manager. Examiner Only Marks Remark (c) Write the manager s address into the correct place in the section of the email shown below. [1] 4547 19 [Turn over 11 Mr J. Brown is opening a new corner shop. He wants an Electronic Funds Transfer Point of Sale (EFTPOS) system in his store. Examiner Only Marks Remark (a) Complete the following sentences using the words below to help explain how EFTPOS systems operate. (Use each word only once) beep database description scanner Barcodes on products are read by a _____________________. [1] The barcode is used to search a __________________ for the item. [1] When the product is found a ________________ is output. [1] The price and _______________ are added to an itemised receipt. [1] (b) List two items of data stored on a product barcode. 1. _______________________________________________________ 2. _____________________________________________________ [2] 4547 20 [Turn over 12 June is designing a website for her son s sports club. The site she created has the following pages: Examiner Only Marks Remark June is not sure what format she should use when she is saving the web pages. (a) Tick ( ) one option below that is not an appropriate file format to use when saving web pages. File Format Tick ( ) .htm .http .html [1] June wants to add video footage of a training session to the Welcome Page of the website. (b) Give one disadvantage of adding videos to a web page. _________________________________________________________ _______________________________________________________ [1] 4547 21 [Turn over 13 Page orientation can be portrait or landscape. Examiner Only Marks Remark (a) The page orientation of the calendar below is (circle the correct answer from the words below): PORTRAIT LANDSCAPE [1] (b) State two features available within Desktop Publisher which will make it easier for users to produce publications like this. 1. ______________________________________________________ 2. ____________________________________________________ [2] (c) The page orientation of the calendar below is (circle the correct answer from the words below): PORTRAIT 4547 LANDSCAPE 22 [1] [Turn over (d) (i) The title NOVEMBER 2008 on the calendar below has been (circle the correct answer from the words below): CENTRED LEFT JUSTIFIED RIGHT JUSTIFIED Examiner Only Marks Remark [1] (ii) Look at the table below. Tick ( ) the two features which have been included on the calendar above. Feature Tick ( ) Right Justify Underline Table Left Justify Italics 4547 [2] 23 [Turn over 14 Using the terms in the list below, choose one term that best matches the definition in the left-hand column (not all words in the list will be used). Virus Protocol Bandwidth CD-Rom Resolution Scanner Examiner Only Marks Remark Encryption Check Digit Digital ISP Definition Term A program designed to damage a computer system. A digit added to the beginning or end of a number to verify that the number entered is an authentic code. A way of encoding data before transmitting it on a network. A company which provides the user with a connection to the Internet. A measure of the quality of an image. A device used to capture data by passing light over the image. An optical storage device. A measure of the amount of data which can travel along a communication cable. A set of rules used for communicating over networks. A name used to describe data held as 1s and 0s. [10] Quality of written communication 4547 24 [Turn over THIS IS THE END OF THE QUESTION PAPER 4547 25 937-049-1

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: