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

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

28 pages, 82 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 1 Higher Tier G5803 Full Course [G5803] TUESDAY 20 MAY, AFTERNOON TIME 1 hour 30 minutes. 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 140, including a maximum of 7 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 G583S8 3859 Marks BLANK PAGE G583S8 3859 2 [Turn over Answer all eleven 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] G583S8 3859 3 [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] G583S8 3859 4 [Turn over (g) A presentation package provides features for: Examiner Only Marks A Text formatting, creating master slides, performing calculations B Performing calculations, text formatting, including multimedia C Including multimedia, creating master slides, text formatting D Remark Including multimedia, creating master slides, performing calculations Answer ___________ [1] (h) Virtual reality is most likely to be used for: A Training pilots, using the Internet, playing games B Playing games, training doctors, using the Internet C Training pilots, sending emails, training teachers D Training pilots, playing games, training doctors Answer ___________ [1] (i) Hacking breaks the: A Computer Messaging Act B Computer Misuse Act C Communications Misuse Act D Communications Messaging Act Answer ___________ [1] G583S8 3859 5 [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] G583S8 3859 6 [Turn over 2 Below is 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 Examiner Only (a) How have the cells in B3 to B12 been formatted? Marks Remark _______________________________________________________ [1] (b) Write down the cell reference which contains the maximum Total Income. _______________________________________________________ [1] (c) What formula would you expect to find in cell F14? _______________________________________________________ [1] G583S8 3859 7 [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 (i) 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 Favourite Lunchtime Sandwiches 2 Food Predicted Actual Sales Sales Total Income Filling Cost Selling Price = I23 + R23 = B3 + 5*B3 18 12 = E3*C3 = 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 = O23 + R23 = B10 + 0.5*B10 32 44 = E10*C10 11 Tuna =P23 + R23 = B11 + 0.5*B11 35 30 = E11*C11 1 2 44 12 = E12*C12 3 Bacon 4 Bacon and Cheese 12 Tuna and Onion 13 14 Total Predicted Sales 3 Examiner Only Marks Cell Formula 1 [2] 2 [1] 3 G583S8 Remark [1] 3859 8 [Turn over This section of the spreadsheet could be used as a Lookup table. H I J K L 22 Filling Bacon Cheese Chicken Cost 23 0.20 0.12 0.30 M N Spicy Ham Salad Chicken 0.35 0.25 0.25 O Tomato 0.10 P Q R Tuna Onion Bread 0.30 0.10 0.20 Examiner Only Marks Remark (ii) What is a lookup table? ______________________________________________________ ____________________________________________________ [2] (e) The graph below has been produced using the data on the spreadsheet. Sales Pattern 60 50 40 30 20 10 ion On nd Tu na Tu n aa To ma to lad Sa Ch ee Ch ee ick se en P Ch lai ick n en S Ha pic m an y dC he es e Ba co na nd Ch Ba co n se 0 (i) List the cell references of the three cell ranges which have been used to create this graph. 1. ____________________________________________________ 2. ____________________________________________________ 3. _________________________________________________ [3] G583S8 3859 9 [Turn over (ii) List two sandwiches which have undersold. Examiner Only Marks Remark 1. ____________________________________________________ 2. __________________________________________________ [2] (iii) Why is it better to view this information on a graph rather than a spreadsheet? ______________________________________________________ ____________________________________________________ [1] (f) A spreadsheet can be used for data modelling. (i) What is data modelling? ______________________________________________________ ____________________________________________________ [1] (ii) Give two features of spreadsheet software which make it suitable for data modelling. 1. ____________________________________________________ ______________________________________________________ 2. ____________________________________________________ ____________________________________________________ [2] G583S8 3859 10 [Turn over 3 J and S Sweeney Accountants have installed a LAN. Examiner Only Marks Remark (a) Expand the acronym LAN. _______________________________________________________ [1] (b) List three advantages of having a network in any organisation. 1. ________________________________________________________ __________________________________________________________ 2. ________________________________________________________ __________________________________________________________ 3. ________________________________________________________ ________________________________________________________ [3] (c) Each employee has been given a username and password for logging on to the network. (i) Why should passwords be changed regularly? ______________________________________________________ ____________________________________________________ [1] (ii) Explain how verification is used when a user changes a password. ______________________________________________________ ______________________________________________________ ____________________________________________________ [2] (d) List three other ways in which the network provides security for user s data. 1. ________________________________________________________ 2. ________________________________________________________ 3. _____________________________________________________ [3] G583S8 3859 11 [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 Printer Laser Jet Printer Inkjet Printer Plotter Speakers 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 Producing a warning signal when a barcode is not scanned Examiner Only Marks Remark [4] (b) Select the input device most appropriate for the task. Mouse Keyboard Scanner Midi Keyboard Task Microphone 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 directly onto the computer Examiner Only Marks Remark [4] G583S8 3859 12 [Turn over (c) Complete the table below about storage devices. The first one has been done for you. Device Floppy Disk Optical/Magnetic Magnetic Typical Storage Capacity 256 K 1.44 Mb 256 Mb 80 Gb Hard Disk 256 K 1.44 Mb 256 Mb 150 Gb Backup Tape 256 Mb 700 Mb 16 Gb 80 Gb DVD-R 256 K 10 Mb 700 Mb 4 Gb CD-RW 256 Mb 700 Mb 1 Gb 80 Gb Examiner Only Marks Remark [8] (d) Complete the sentence below using two of the words provided. Volatile Hard disk Non Volatile CD-ROM There are two types of storage, one retains data when the power is turned off and is _____________________. The other loses data when the power is turned off and is ________________. G583S8 3859 13 [2] [Turn over 5 Bob has a butcher s shop and wants to advertise his special offers. He is going to use the template below, from a desktop publisher to design a flyer. Examiner Only Marks Remark (a) (i) What is a template? ______________________________________________________ ____________________________________________________ [2] (ii) Use examples from the layout above to show two ways in which Bob will make use of this template. 1. ____________________________________________________ ______________________________________________________ 2. ____________________________________________________ ____________________________________________________ [2] G583S8 3859 14 [Turn over (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. Examiner Only Marks Remark 1. ________________________________________________________ 2. ________________________________________________________ 3. _____________________________________________________ [3] G583S8 3859 15 [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 Street 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 I hope to hear from yu soon. Mrs Sue Greene Managing Director (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] G583S8 3859 16 [Turn over (c) Sue wants to send this letter only to customers who are interested in Flower Arranging . How can she do this? Examiner Only Marks Remark __________________________________________________________ __________________________________________________________ _______________________________________________________ [2] (d) 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. Tick ( ) Package Word processor Database Spreadsheet Graphics Presentation [1] (e) 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] G583S8 3859 17 [Turn over (f) The data capture form below has been created using a wizard in the database package. Examiner Only Marks Remark (i) What is this data capture form likely to be used for? ______________________________________________________ ____________________________________________________ [2] (ii) Give one advantage to the user of using a wizard to create the data capture form. ______________________________________________________ ____________________________________________________ [1] (g) Below is a section of the Customer database. Customer Number 1000 1001 1002 1003 1004 House Title Forename Surname Number Mrs Anne Doherty 1 Miss Ellen Harding 23 Miss Christina McIntyre 11 Mr Charles Foley 12 Mrs April Walls 34 Street Town County Interest Bishop Street Front Gate Long Avenue Broad Street Templeton Road Bangor Belfast Glengormley Glengormley Templepatrick Co. Down Co. Antrim Co. Antrim Co. Antrim Co. Antrim Flower Arranging Small Gardens Small Gardens Shrubs Flower Arranging Examiner Only What feature of a database could Sue use to complete each of the following tasks? Marks Remark (i) Select customers according to their interests. ____________________________________________________ [1] (ii) Produce printed lists of customers and their details. ____________________________________________________ [1] G583S8 3859 18 [Turn over (iii) Complete the sentence. Examiner Only Marks The table has ___________ records and ___________ fields. Remark [2] (iv) Which field is most likely to be the key field? ____________________________________________________ [1] G583S8 3859 19 [Turn over 7 Alan is using a data logger to collect data on the temperature changes in the ICT room at school over four days. Examiner Only Marks Remark (a) Alan analyses the data and presents it to his teacher. (i) What software could Alan use to help him analyse the data? ____________________________________________________ [1] (ii) In what form could Alan present the data and results to his teacher, so that she can easily understand them? ____________________________________________________ [1] (b) Based on the readings taken, the school have decided to install air conditioning in the ICT room. (i) List one sensor that the air conditioning system would use. ____________________________________________________ [1] (ii) Describe how the air conditioning system would work to keep the room at 20 degrees Celsius, using the headings provided. Input __________________________________________________ ____________________________________________________ [1] Process ________________________________________________ ______________________________________________________ ____________________________________________________ [2] Output ________________________________________________ ____________________________________________________ [1] Feedback ______________________________________________ ______________________________________________________ ____________________________________________________ [2] G583S8 3859 20 [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 join the Film Watchers Club and exchange views about films online. Examiner Only Marks Remark (a) Anna wants to pre-book seats for a film. She will input her personal details and her credit card details. (i) List three other pieces of data that she will have to input before booking seats. 1. ____________________________________________________ 2. ____________________________________________________ 3. _________________________________________________ [3] (ii) The website will have to process the data she has provided. List two processes that will take place before she can pay for the tickets. 1. ____________________________________________________ 2. _________________________________________________ [2] (b) After Anna has selected her seats she will have to pay for them using a credit card. List two ways in which data transfer can be kept secure on the Internet. 1. ________________________________________________________ 2. _____________________________________________________ [2] (c) Anna also uses her credit card at an ATM. Expand the acronym ATM. _______________________________________________________ [1] (d) Apart from withdrawing cash, list two other things that Anna can do at the ATM. 1. ________________________________________________________ 2. _____________________________________________________ [2] (e) What security is provided by banks for ATM users? __________________________________________________________ _______________________________________________________ [1] G583S8 3859 21 [Turn over 9 John s new computer has a Windows Vista operating system. Examiner Only Marks Remark (a) What is an operating system? __________________________________________________________ _______________________________________________________ [2] (b) List three steps in the boot up sequence of a typical computer. 1. ________________________________________________________ 2. ________________________________________________________ 3. _____________________________________________________ [3] (c) John wants to protect his computers from viruses. Which of the following tasks could introduce viruses to John s computer? (Tick ( ) all that apply) Tick ( ) Task Printing a document Attaching a document to an email Reading emails Copying a file from a memory stick Creating a new folder on his desktop Using a microphone Downloading music files from the Internet [3] (d) John s friend has copied his favourite song from a CD and sent it to him by email. Which law is he breaking? _______________________________________________________ [2] G583S8 3859 22 [Turn over (e) In which file format could the song be stored? (Tick ( ) all that apply) File Format Examiner Only Marks Remark Tick ( ) .gif .jpg .mp3 .bmp .wav G583S8 3859 [2] 23 [Turn over 10 Emily, a GCSE student, has designed a website as part of her coursework. Examiner Only Marks Remark (a) Which of the following statements are true about web pages? (Tick ( ) all that apply) Tick ( ) Statement Web pages are stored as HTML files Web pages are stored as HTTP files Web pages cannot be emailed Web pages can be created using a word processing document [2] (b) Emily uses a web browser. Which three of the following statements are true about web browsers? Tick ( ) Statement Web browsers are used to write HTML code Web browsers can be used to view web pages Web browsers are search engines Web browsers provide users with URLs Web browsers allow users to visit web pages directly using the URL The URL can be entered directly into the address bar [3] G583S8 3859 24 [Turn over (c) Emily has included pictures in her web pages. Complete the sentences using the words provided. Jpeg optimized bitmap Examiner Only Marks Remark compressed Pictures to be used on a website should be in ______________________ format since these files are ______________________ and take less time to appear on a web page. Pictures in ________________________ format have not been ________________________ for use on a website and so take more time to appear. [4] (d) Emily needs to email the website folder to her teacher. How can she email the folder as a single attachment? __________________________________________________________ _______________________________________________________ [1] (e) Give two advantages to the teacher of Emily submitting her website electronically rather than on paper. 1. ________________________________________________________ __________________________________________________________ 2. ________________________________________________________ _______________________________________________________ [2] G583S8 3859 25 [Turn over 11 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). ISP Smart Card CSV Simulation Router Barcode ISDN HTML Hard Copy Backup URL Validation Email Remark RTF USB Examiner Only Marks Peripheral Device Definition Term A pattern of thick and thin vertical lines used to store data about products A credit card containing a re-writeable chip A device which connects two or more networks together. It can work out the best route for data to travel between computers A process whereby the computer checks data against a set of predefined rules ensuring it is correct A permanent copy of information usually in the form of a printout A computer program used to model a real life situation A file format which can be imported into spreadsheets and databases A standardised way of storing a document and its formatting so that it can be transferred to different word-processing applications while retaining the original formatting The language used to construct web pages A hardware component connected to the computer [10] Quality of written communication [7] G583S8 3859 26 [Turn over THIS IS THE END OF THE QUESTION PAPER G583H8 G583H8 0000 27 [Turn [Turn over S 9/07 529-010-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: