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

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

27 pages, 71 questions, 0 questions with responses, 0 total responses,

	ccea_gcse	+Fave Message
	Profile Timeline Uploads Q & A

Home > ccea_gcse >

Formatting page ...

Centre Number 7 1 Candidate Number General Certificate of Secondary Education 2010 Information and Communication Technology Full Course Paper 1 Foundation Tier G5801 For Examiner s use only Question Marks Number [G5801] MONDAY 21 JUNE, MORNING 1 2 TIME 3 1 hour. 4 5 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. Complete in blue or black ink only. Do not write in pencil or with a gel pen. Answer all fourteen questions. INFORMATION FOR CANDIDATES 6 7 8 9 10 11 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. 12 13 14 QWC Total Marks 6271 (jun10G5801) Examiner Number 2 Answer all fourteen questions Examiner Only Marks For question 1 insert the appropriate letter in the space provided 1 (a) Computer technology allows us to create virtual worlds for gaming and training. Which of the following is NOT a feature of a virtual world? A Online and interactive B Online and batch processed C Online and real-time D Online and computer based Answer ___________ [1] (b) Which of the following correctly describes what the boot-up program on a computer does? A It carries out hardware checks and loads the operating system into the hard disc from main memory B It carries out hardware checks and loads the operating system into cache memory from the hard disc C It carries out hardware checks and loads the operating system into the hard disc from cache memory D It carries out hardware checks and loads the operating system into main memory from the hard disc Answer ___________ [1] 6271 (02) Remark 3 (c) Which of the following statements about teleworking is NOT true? Examiner Only Marks A Teleworking cuts down on company overheads B Teleworking means more travelling for employees C Teleworking requires employees to make use of technology D Remark Teleworking allows companies to employ people from a wider geographic area Answer ___________ [1] (d) Which of the following is NOT provided by a typical EPOS system? A Automatic tracking of stock B Bar code reading C Itemised receipt D Immediate transfer of funds Answer ___________ [1] (e) Select the memory chip used to store control programs in electronic devices in the home. A Cache B ROM C Main D RAM Answer ___________ [1] 6271 (03) [Turn over 4 (f) Which statement is TRUE about The Data Protection Act? Examiner Only Marks A Allows data subjects to view all data held about them and other people in a file B Allows data subjects to view all data held about them and have it corrected if it is incorrect C Does not allow all data subjects to view all data held about themselves D Does not allow data subjects to have data corrected if it is incorrect Answer ___________ [1] (g) According to The Data Protection Act, the data controller A Ensures that data is not transferred B Ensures that data is not accessed by data subjects C Ensures that data is stored securely D Ensures that data is accessed by all data subjects Answer ___________ [1] (h) Multimedia presentation software allows A The use of slide masters and efficient numeric calculation B The use of slide masters and the storage of records C The storage of records and the inclusion of navigation buttons D The inclusion of sound and navigation buttons Answer ___________ [1] 6271 (04) Remark 5 (i) Which of the following is a magnetic storage device? Examiner Only Marks A CD-R B DVD-RW C Flash Memory Stick D Remark External Hard Drive Answer ___________ [1] (j) A simulation is a A graphic which has been edited B spreadsheet which returns correct results C computer program used to model a real life situation D database which contains reports Answer ___________ [1] Total Question 1 6271 (05) [Turn over 6 2 Andrew has a photography business. He has bought word processing software for his computer. (a) He will use a template to create a brochure advertising his company. What is a template? _________________________________________________________ _______________________________________________________ [2] (b) The template will allow Andrew to produce the brochure very quickly. List ONE other advantage to Andrew of using a template to create a brochure. _________________________________________________________ _______________________________________________________ [1] 6271 (06) Examiner Only Marks Remark 7 (c) Consider the following features of a word processor. Tick ( ) TWO boxes that best describe each feature. Features Mailmerge Examiner Only Marks Remark Description Uses a database Provides step by step instructions Helps users complete tasks Requires fields to be added to the main document Allows users to add new words Helps ensure spelling is correct [2] Wizard Uses a database Provides step by step instructions Helps users complete tasks Requires fields to be added to the main document Allows users to add new words Helps ensure spelling is correct [2] Dictionary Uses a database Provides step by step instructions Helps users complete tasks Requires fields to be added to the main document Allows users to add new words Helps ensure spelling is correct Total Question 2 [2] 6271 (07) [Turn over 8 3 Robert is carrying out a science experiment at school. He needs to monitor the weather temperature in C and take a reading each hour for a 5 day period. Examiner Only Marks Remark (a) Robert s science teacher suggests using data logging. Complete the sentence using the following words (use each word only once). TEMPERATURE SENSOR INTERVAL CAPTURE Data logging involves the use of a _____________ to _____________ data. The time taken between each reading is called the data logging _____________ . In this case a _____________ sensor would be appropriate. [4] Total Question 3 6271 (08) 9 4 Owen has a digital television in his living room and has bought his mum a digital camera for her birthday. Examiner Only Marks Remark (a) List ONE advantage of using a digital camera to encourage Owen s mum to use her new camera. ______________________________________________________ [1] (b) The camera has a touch screen for changing settings. Tick ( ) TWO statements which are true about touch screen technology. Statement Tick ( ) Most touch screens show blurry images. A touch screen can be used as an input device. A touch screen requires a high level of ICT knowledge to use. A touch screen can be used as an output device. [2] (c) Owen s digital television is interactive. List TWO ways in which he can make use of this feature. 1. ______________________________________________________ _________________________________________________________ 2. ______________________________________________________ ______________________________________________________ [2] Total Question 4 6271 (09) [Turn over 10 5 Eleanor works for the local newspaper. She is responsible for photographs and graphics. She is creating a 50 Years Ago page for the town. Examiner Only Marks Remark (a) She has been given old photographs. Suggest ONE method for getting these onto the computer. ______________________________________________________ [1] (b) Eleanor is using photographs taken by a local photographer 15 years ago. If she does not seek his permission what law is she breaking? ______________________________________________________ [2] (c) Whilst creating the 50 Years Ago page, Eleanor s computer breaks down. She discovers that the computer has become infected with a virus. (i) What is a virus? _____________________________________________________ __________________________________________________ [2] (ii) List TWO things Eleanor could have done to prevent the virus infection. 1. ___________________________________________________ _____________________________________________________ 2. ___________________________________________________ __________________________________________________ [2] (iii) Eleanor discovers that the virus has been created by someone in her office. What law has this person broken? __________________________________________________ [1] 6271 (10) Total Question 5 11 6 AMAZINGBOOKS.COM is an online bookshop. Books can be ordered online and delivered to customers homes. Examiner Only Marks Remark (a) Mary has ordered a book and paid by credit card. Give ONE advantage to Mary of shopping online. _________________________________________________________ ______________________________________________________ [1] (b) John has ordered a book for download to his iPhone. Give ONE advantage of ordering a book for download instead of through the post. _________________________________________________________ ______________________________________________________ [1] (c) Give ONE reason why a password would be necessary when a customer is logging on to their account at AMAZINGBOOKS.COM. _________________________________________________________ ______________________________________________________ [1] (d) The website manager has decided to try to prevent hacking. Tick ( ) ONE statement which is true about hacking. Statement Tick ( ) Hacking involves placing data on the Internet Hacking involves unauthorised access to the system Hacking breaks the Data Protection Act [1] Total Question 6 6271 (11) [Turn over 12 7 E GCSE Niamh is a GCSE student. She has created the following files and folders for herxaminer Only Marks Remark coursework. (a) In the table below, circle the statement which is correct. The first one has been done for you. Filename Statement has been Assignment 1 created by a word processor has been created by a graphics package has been created by presentation software has been created by a is a folder spreadsheet package has been Assignment 2 created by a word processor has been created by a graphics package has been created by presentation software has been created by a is a folder spreadsheet package has been Assignment 3 created by a word processor has been created by a graphics package has been created by presentation software has been created by a is a folder spreadsheet package has been created by a word processor has been created by a graphics package has been created by presentation software has been created by a is a folder spreadsheet package database [3] Examiner Only Marks 6271 (12) Remark 13 (b) Niamh has been told by her teacher to make a backup of the coursework folder. Examiner Only Marks Remark (i) What is a backup? _____________________________________________________ __________________________________________________ [1] (ii) Why should Niamh keep a backup? _____________________________________________________ __________________________________________________ [1] (iii) Niamh chooses CD-R to make her backup. List ONE feature of CD-R which makes it suitable for backup. __________________________________________________ [1] Total Question 7 6271 (13) [Turn over 14 8 Happy Days Bank provide their customers with: Examiner Only Marks Remark Debit and Credit cards Online banking (a) The debit and credit cards contain smart chip technology. List TWO features of a smart chip. 1. ______________________________________________________ 2. ___________________________________________________ [2] (b) The debit and credit cards also contain a magnetic stripe. Circle TWO of the boxes below which contain statements which are TRUE about magnetic stripes. Data on a magnetic stripe can be read by humans Data on a magnetic stripe can be damaged by magnetic fields Magnetic stripes can hold very large quantities of data Data on a magnetic stripe must be read by a special reader [2] (c) Some customers make use of the online banking facility and ATM. (i) What do the letters ATM stand for? __________________________________________________ [1] (ii) List TWO features available for customers at an ATM. 1. ___________________________________________________ _____________________________________________________ 2. ___________________________________________________ __________________________________________________ [2] 6271 (14) Total Question 8 15 BLANK PAGE (Questions continue overleaf) 6271 (15) [Turn over 16 9 The Internet exists on a WAN. Examiner Only Marks (a) What do the letters WAN stand for? ______________________________________________________ [1] (b) George needs to go online. Tick ( ) ONE statement which best explains why he needs each of the following items. Item Search Engine Statement To upload and download files To display webpages To find webpages To get connected to the Internet To allow data transfer from his PC to the Internet Web Browser To upload and download files To display webpages To find webpages To get connected to the Internet To allow data transfer from his PC to the Internet Telecommunications link To upload and download files To display webpages To find webpages To get connected to the Internet To allow data transfer from his PC to the Internet [3] 6271 (16) Remark 17 (c) George contacts his ISP to see what facilities they provide. Examiner Only Marks Remark (i) What do the letters ISP stand for? __________________________________________________ [1] (ii) Tick ( ) TWO functions that an ISP would normally provide. An ISP would Tick ( ) Install software for the user Provide an e-mail service Provide different bandwidth options Maintain the user s PC [2] Total Question 9 6271 (17) [Turn over 18 10 PC GLOBE are a computer company. They have a website. The website address for the company is www.pcglobe.com Examiner Only Marks Remark (a) What do the letters www in the website address stand for? ____________________________________________________ [1] (b) Below is a page containing contact details. This page contains hyperlinks. (i) What is a hyperlink? _____________________________________________________ __________________________________________________ [1] (ii) List ONE piece of information on the webpage shown which is likely to be a hyperlink. __________________________________________________ [1] 6271 (18) Total Question 10 19 BLANK PAGE (Questions continue overleaf) 6271 (19) [Turn over 20 11 David is setting up a small printing company. He stores details of his customersExaminertheir and Only Marks Remark orders in a database, part of which can be seen below. Order ID Forename Surname Street Town Postcode Order Description Price Date Placed Completion Date Collected BRO01 Peter Brown 22 Highways Larne BT56 8UJ 200 Wedding Invites 100.00 21/03/10 21/04/10 Yes FOR02 Clarke Forest 12 Shrewsbury Road Larne BT56 8KO 500 Business Cards 150.00 23/03/10 05/04/10 No MON08 Aislinn Mone 45 Heather Way Belfast BT5 8MN 50 Party Invites 25.00 12/04/10 20/04/10 Yes ARN04 Jane Arnold 2 The Gardens Newry BT34 8AS 40 Thank You Cards 20.00 12/04/10 15/05/10 No GRA05 Norman Grant 16 Grinan Road Belfast BT6 2RF 100 Business Cards 40.00 19/04/10 20/05/10 Yes (a) Highlight ONE record in the table above. [1] Examiner Only Marks Remark (b) How many fields are there in the table above? ______________________________________________________ [1] (c) Suggest a suitable data type for each of the following fields. (i) Order ID __________________________________________________ [1] (ii) Collected __________________________________________________ [1] (d) David wants to find all customers who placed orders over 80. Which feature of the database software would he use to do this? ______________________________________________________ [1] Total Question 11 6271 (20) 21 BLANK PAGE (Questions continue overleaf) 6271 (21) [Turn over 22 Examiner to 12 RW Hairdresser Supplies sell electrical equipment. The manager creates a spreadsheetOnly Marks calculate the profit from the sales in the store each month. An example for May 2010Remark is included below. A B C D E F G Sales Total Percentage Profit Profit ( ) 1 RW Hairdresser Supplies 2 3 DATE 1st 31st May 4 5 Stock No Description Quantity Sold 6 CC01 Deep Conditioner 4.00 200 800.00 10% 80.00 7 CC02 Blonde Shampoo 5.00 500 2,500.00 25% 625.00 8 CC03 Heated Rollers 41.00 150 6,150.00 25% 1,537.50 9 KE03 GHD Straighteners 99.00 100 9,900.00 15% 1,485.00 10 TO67 RM Straighteners 54.00 55 2,970.00 15% 445.50 11 TV14 IconicRW Hair Gel 6.00 450 2,700.00 25% 675.00 12 TV35 IconicRW Mousse 4.99 200 998.00 30% 299.40 13 DP01 IconicRW Hairspray 4.99 300 1,497.00 25% 374.25 14 BR01 GHD Curling Irons 75.00 50 3,750.00 20% 750.00 15 EC10 Vent Hairbrush 7.99 100 799.00 10% 79.90 16 DI23 Round Curling Brush 8.99 25 224.75 25% 56.19 Total 32,288.75 Price 17 (a) The text in Row 2 has been centred. State ONE other way in which the cells in Row 2 have been formatted. ______________________________________________________ [1] (b) How has the Price column been formatted? ______________________________________________________ [1] 6271 (22) 6,407.74 Examiner Only Marks Remark 23 (c) The manager has used a formula to calculate the profit for the Vent Hairbrush. Tick ( ) the correct formula used. Formula Examiner Only Marks Remark Tick ( ) =E15*F15 =E15+F15 =C15*D15 [1] (d) Write down the cell reference for the total sales figure for May. ______________________________________________________ [1] (e) The manager has created the following chart. (i) Give the cell references of the cell ranges used to create the graph. __________________________________________________ [1] __________________________________________________ [1] (ii) Which item has made the most profit? Total Question 12 __________________________________________________ [1] 6271 (23) [Turn over 24 13 Using the terms in the list below choose ONE term that best matches the definition in the left-hand column. (Use each term only once.) BLIND CARBON COPY GRAPHICAL USER INTERFACE LASER PRINTER VIDEO CONFERENCING BITMAP Definition Examiner Only Marks Remark CD-ROM FACSIMILE COMPRESSION WEB FILTERING UPLOADING Term Software which includes windows, icons, menus and pointers A device which allows the electronic transmission of paper documents Communicating across a network using sound and images A method of making a file smaller in size A method used to prevent websites and webpages from being accessed Sending an e-mail to recipients when they can only see their own details and not those of other recipients An output device which uses toner to place images on paper A storage medium which can only be read from A picture file which has not been optimised for use on the Internet A method of placing files on the Internet [10] 6271 (24) Total Question 13 25 BLANK PAGE (Questions continue overleaf) 6271 (25) [Turn over 26 14 Anthony runs Electronic Supermarket and is creating a letterhead for his business. Here is the original image Anthony used. (a) Look at the images below and select one word from the list which best describes what effect has been applied to the image in each case. (Use each word only once.) Flip Image 6271 (26) Resize Crop Rotate Effect Examiner Only Marks Remark 27 Examiner Only Marks Remark [4] 6271 (27) [Turn over 28 (b) Anthony has bought notebook computers for his employees who travel around Northern Ireland. Here is part of the specification of the computer. Memory Size Hard Drive Capacity CD/DVD Drive Screen Size/Type TV-out Wireless Enabled Battery life (up to) Weight 3 GB 250 GB One 11.6 YES YES 8 hours 1.58 kg Which feature would be most suitable for doing each of the following tasks. Tick ( ) one in each row. Task TV-Out Hard Disk Optical Drive Wireless Enabled Connecting to the wireless network Installing new software Connecting to a TV Storing coursework files [4] 6271 (28) Examiner Only Marks Remark 29 (c) Why are each of the following useful to the employees who travel around Northern Ireland? Examiner Only Marks Remark (i) Battery life (up to) 8 hours. _____________________________________________________ __________________________________________________ [1] (ii) Weight 1.58 kg. _____________________________________________________ __________________________________________________ [1] THIS IS THE END OF THE QUESTION PAPER Total Question 14 Quality of Written Communication 6271 (29) [Turn over (30) (31) Permission to reproduce all copyright material has been applied for. In some cases, efforts to contact copyright holders may have been unsuccessful and CCEA will be happy to rectify any omissions of acknowledgement in future if notified. 110035 (32)

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: