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

UK GCSE 2008 : ICT - Short Course, Foundation Tier

24 pages, 73 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 Foundation Tier G5301 Short Course [G5301] TUESDAY 20 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 twelve 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 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. 6 7 8 9 10 11 12 QWC Total Marks 4543 Marks Answer all twelve questions Examiner Only Marks Remark For question 1 insert the appropriate letter in the space provided. 1 (a) ROM stands for: A Real Ordinary Memory B Read Ordinary Memory C Real Only Memory D Read Only Memory Answer ___________ [1] (b) WAN stands for: A Wide Area Network B Wide Actual Network C Wired Area Network D Wired Actual Network Answer ___________ [1] (c) Cache is: A Slow memory close to the processor B Slow memory on the hard disk C Fast memory close to the processor D Fast memory on the hard disk Answer ___________ [1] 4543 2 [Turn over (d) ISP stands for: Examiner Only Marks A Internet Service Protocol B Internet System Protocol C Internet System Provider D Remark Internet Service Provider Answer ___________ [1] (e) An ISP provides: A Webspace, email addresses, web filtering B Webspace, popups, email addresses C Popups, Webspace, web filtering D Web filtering, email addresses, popups Answer ___________ [1] (f) An Intranet is: A A protected network B A protected file C A website available from within an organisation D A website available to all users on the World Wide Web Answer ___________ [1] 4543 3 [Turn over (g) A presentation package provides features for: Examiner Only Marks A Text formatting, performing calculations B Performing calculations, including multimedia C Including multimedia, text formatting D Remark Storing records, performing calculations Answer ___________ [1] (h) Virtual reality is most likely to be used for: A Training pilots, sending emails B Sending emails, playing games C Training pilots, playing games D Using the Internet, playing games Answer ___________ [1] (i) Hacking breaks the: A Computer Messaging Act B Computer Misuse Act C Communications Misuse Act D Communications Messaging Act Answer ___________ [1] 4543 4 [Turn over (j) A FAX is better than email because: Examiner Only Marks A Faxes can be received at any time B Documents received by fax can be edited on a computer C Faxes can transmit handwritten messages D Remark Faxing documents is free Answer ___________ [1] 4543 5 [Turn over 2 Below is part of a spreadsheet which contains data about the sales of sandwiches in Hilltop High School. A 1 B C D E F FAVOURITE LUNCHTIME SANDWICHES 2 Filling Sandwich Cost Selling Price Predicted Sales Actual Sales Total Income 3 Bacon 0.40 0.60 18 12 7.20 4 Bacon and Cheese 0.52 0.78 12 40 31.20 5 Cheese 0.32 0.48 44 52 24.96 6 Chicken Plain 0.50 0.75 31 36 27.00 7 Chicken Spicy 0.55 0.83 28 19 15.68 8 Ham and Cheese 0.57 0.86 51 55 47.03 9 Salad 0.45 0.68 55 50 33.75 10 Tomato 0.30 0.45 32 44 19.80 11 Tuna 0.50 0.75 35 30 22.50 12 Tuna and Onion 0.60 0.90 44 12 10.80 350 350 239.92 13 14 Totals (a) List two ways in which the cells in the first row have been formatted. Examiner Only Marks Remark 1. ________________________________________________________ 2. _____________________________________________________ [2] (b) Write down the cell reference which contains the biggest Total Income. _______________________________________________________ [1] (c) What formula would you expect to find in cell F14? _______________________________________________________ [1] 4543 6 [Turn over (d) Sandwich costs have been calculated using the data shown below. Sandwich prices include the price of bread and their fillings. H I J K L 22 Filling Bacon Cheese Chicken 23 Cost 0.20 0.12 0.30 M N Spicy Ham Salad Chicken 0.35 0.25 0.25 O P Tomato 0.10 Q R Tuna Onion Bread 0.30 0.10 0.20 Write down the formula you would expect to find in the cells labelled 1, 2 and 3 below. A 1 B C D E F Predicted Sales Actual Sales Total Income = B3 + 0.5*B3 18 12 = E3*C3 FAVOURITE LUNCHTIME SANDWICHES 2 Food Filling Cost Selling Price 3 Bacon = I23 + R23 4 Bacon and Cheese = I23 + J23 + R23 = B4 + 0.5*B4 12 40 = E4*C4 5 Cheese = J23 + R23 = B5 + 0.5*B5 44 52 = E5*C5 6 Chicken Plain = K23 + R23 = B6 + 0.5*B6 31 36 = E6*C6 7 Chicken Spicy = L23 + R23 = B7 + 0.5*B7 28 19 = E7*C7 8 Ham and Cheese = M23 + J23 + R23 = B8 + 0.5*B8 51 55 = E8*C8 9 Salad = N23 + R23 = B9 + 0.5*B9 55 50 = E9*C9 10 Tomato = B10 + 0.5*B10 32 44 = E10*C10 11 Tuna = P23 + R23 = B11 + 0.5*B11 35 30 = E11*C11 12 Tuna and Onion = P23 + Q23 + R23 1 44 12 2 3 Examiner Only Marks Cell 1 [1] 2 [1] 3 4543 Remark Formula [1] 7 [Turn over (e) The graph below has been produced using the data on the spreadsheet. Examiner Only Marks Remark Total Income 50.00 45.00 40.00 35.00 30.00 25.00 20.00 15.00 10.00 5.00 0.00 Ba co Tu n Tu na aa nd O ni on Sa la d To m at o n Ba co n an d Ch ee se Ch Ch ee ic se ke n Ch Pl ic ai ke n n H am Sp icy an d Ch ee se Total Income (i) List the two cell ranges which have been used to create this graph. 1. ____________________________________________________ 2. _________________________________________________ [2] (ii) Why is it better to view this information on a graph rather than a spreadsheet? ______________________________________________________ ___________________________________________________ [1] 4543 8 [Turn over 3 J and S Sweeney Accountants have installed a Local Area Network (LAN). Examiner Only Marks Remark (a) What is a Local Area Network? _________________________________________________________ _______________________________________________________ [1] (b) The managing director feels that the cost of the network is too high. List two advantages of having a network in any organisation. 1. _______________________________________________________ 2. _____________________________________________________ [2] (c) Each employee has been given a username and password. Explain the terms username and password. Username: ________________________________________________ _______________________________________________________ [1] Password: ________________________________________________ _______________________________________________________ [1] (d) Data on the network must be backed up. Why is this important? _________________________________________________________ _______________________________________________________ [2] 4543 9 [Turn over 4 A computer system is made up of input, processing, output and storage devices. (a) Select the output device most appropriate for the task. Dot Matrix Laser Jet Plotter Inkjet Task Output device Producing 1000 letters quickly, to be sent to members of a swimming club Producing an invoice on multipart stationery Producing a graph of a patient s heart beat in a hospital Printing a coloured copy of a project for coursework Examiner Only Marks Remark [4] (b) Select the input device most appropriate for the task. Mouse Keyboard Scanner Midi Keyboard Task Input device Reading data from a paper based document so that it can be edited Entering large quantities of text into a word processor Operating a graphical user interface Entering music onto the computer Examiner Only Marks Remark [4] (c) Complete the table below, the first one has been done for you. Device Floppy Disk Optical/Magnetic Magnetic Hard Disk Backup Tape DVD-R CD-RW 4543 [4] 10 [Turn over 5 Bob has a butcher s shop and wants to advertise his special offers. Examiner Only Marks Remark He is going to use the template below, from a desktop publisher to design a flyer. (a) What is a template? _________________________________________________________ _______________________________________________________ [2] (b) Bob is going to use the desktop publisher to produce business cards. List three features of a desktop publisher which makes it suitable for this task. 1. _______________________________________________________ 2. _______________________________________________________ 3. _____________________________________________________ [3] 4543 11 [Turn over 6 A local flower shop keeps a database of customers interested in taking different gardening courses. Below is a letter which will be sent to customers to let them know when their course begins. Examiner Only Marks Remark Title Forename Surname House_Number S t r e e t Town Postcode 17/5/2008 Dear Title Surname I wish to inform you that the Interest club will start on July 25th 2008. It will last for two weeks and costs 30.00. Error Error I hope to hear from yu soon. Mrs Sue Greene Managing Director ) Th l i h Wh f f d ld h (a) The letter contains an error as shown. What feature of a word processor could have helped Sue identify this error? _______________________________________________________ [1] (b) The letter is part of a mail merge. What is a mail merge? _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] 4543 12 [Turn over (c) Sue has decided to create special notepaper containing her own logo. Place a tick ( ) beside the type of package she is most likely to use to create this logo. Package Examiner Only Marks Remark Tick ( ) Word processor Database Spreadsheet Graphics Presentation [1] (d) Sue stores the customer details in a database. She must apply the principles of the Data Protection Act. List two principles of this Act. 1. _______________________________________________________ _________________________________________________________ 2. _______________________________________________________ _______________________________________________________ [2] (e) The data capture form below has been created using a wizard in the database package. What is the purpose of the data capture form? _________________________________________________________ _______________________________________________________ [2] 4543 13 [Turn over (f) Below is a section of the Customer database. Customer House Title Forename Surname Number Number Street Town County Interest Flower Arranging 1000 Mrs Anne Doherty 1 Bishop Street Bangor Co. Down 1001 Miss Ellen Harding 23 Front Gate Belfast Co. Antrim Small Gardens 1002 Miss Christina Mclntyre 11 Long Avenue Glengormley Co. Antrim Small Gardens 1003 Mr Charles Foley 12 Broad Street Glengormley Co. Antrim Shrubs 1004 Mrs April Walls 34 Templeton Road Templepatrick Co. Antrim Flower Arranging (i) What feature of a database could Sue use to produce formatted lists of customers and their details? Examiner Only Marks Remark ____________________________________________________ [1] (ii) Complete the sentence. The database above has _____________ records and ______________ fields. [2] (iii) Which field is most likely to be the key field? ______________________________________________________ [1] 4543 14 [Turn over 7 Alan is carrying out data logging in the ICT room at school. Examiner Only Marks Remark (a) What is data logging? _________________________________________________________ _________________________________________________________ _______________________________________________________ [2] (b) How could Alan present the data collected to his teacher? _______________________________________________________ [1] (c) The school have decided to install air conditioning in the ICT room. List one sensor that the air conditioning system would use. _______________________________________________________ [1] 4543 15 [Turn over 8 ABC Cinema has just created a new website. Customers can: view the timetable for films up to 2 months in advance pre-book seats for films Examiner Only Marks Remark (a) Anna wants to pre-book seats for a film. List two pieces of data that she will have to enter before booking seats. 1. _______________________________________________________ 2. _____________________________________________________ [2] (b) After Anna has selected her seats she will have to pay for them using a credit card. How will she know that the website is secure? _________________________________________________________ _______________________________________________________ [1] (c) Anna also uses her credit card at an ATM. What do the letters ATM stand for? ATM __________________________________________________ [1] (d) Apart from withdrawing cash, list two other things that Anna can do at the ATM. 1. _______________________________________________________ 2. _____________________________________________________ [2] (e) Most banks provide on-line banking facilities. (i) Explain what is meant by on-line banking. ______________________________________________________ ___________________________________________________ [2] (ii) Give one advantage of on-line banking to the bank. ___________________________________________________ [1] 4543 16 [Turn over 9 John s new computer has a Windows Vista operating system. Examiner Only Marks Remark (a) List one task carried out by the operating system. _________________________________________________________ _______________________________________________________ [1] (b) John wants to protect his computer from viruses. Which of the following tasks could introduce viruses to John s computer? (Tick ( ) all that apply) Tick ( ) Tasks Printing a document Reading emails Copying a file from memory stick Using a microphone [2] (c) John s friend has copied his favourite song from a CD and sent it to him by email. In which file format will the song be stored? (Tick ( ) the correct file format) File Format Tick ( ) .gif .jpg .mp3 .bmp .doc [1] 4543 17 [Turn over 10 Emily, a GCSE student, has designed a website as part of her coursework. Examiner Only Marks Remark (a) (i) What software will Emily need in order to view her website? ___________________________________________________ [1] (ii) Emily s website contains hyperlinks. What is a hyperlink? ______________________________________________________ ___________________________________________________ [1] (iii) Apart from hyperlinks, list three features of web design software that Emily could use when creating her website. 1. ____________________________________________________ 2. ____________________________________________________ 3. _________________________________________________ [3] (b) All pupils have access to the school network through the WAN and every pupil has email. (i) What feature of email can be used to send to many people at once? ___________________________________________________ [1] (ii) Why should the school filter email? ______________________________________________________ ___________________________________________________ [1] 4543 18 [Turn over 11 Ellen has found an old black and white photograph of her grandmother. Examiner Only Marks Remark (a) How can she convert the photograph to a digital image? _______________________________________________________ [1] (b) She is going to send the photograph to her aunt in Australia by email. (i) Apart from a computer, list two items of hardware Ellen will need to connect to the Internet. 1. ____________________________________________________ 2. _________________________________________________ [2] (ii) What feature of email will she use to send the photograph? ___________________________________________________ [1] (iii) Tick one statement which explains why it might be better to email the photograph instead of fax it. Tick ( ) Statement Fax machines cut down on paper usage Email can be sent without the receiver having to wait at the other end Fax machines cannot print in black and white Email cannot be sent unless the receiver is waiting at the other end [1] 4543 19 [Turn over 12 Using the terms in the list below choose one term that best matches the definition in the left-hand column. Search Engine Online Pixel Barcode Smart Card HTML Database Hard Copy Definition Examiner Only Marks Remark Simulation Peripheral Device Term A pattern of thick and thin vertical lines used to store data about products A credit card containing a re-writeable chip Connected to the Internet A program used to find information on the Internet A permanent copy of information usually in the form of a printout A computer program used to model a real life situation A collection of data made up of fields and records The smallest area on a VDU that can be edited The language used to construct web pages A hardware component connected to the computer [10] Quality of Written Communication [5] 4543 20 [Turn over THIS IS THE END OF THE QUESTION PAPER 529-006-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: