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

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

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 2007 Information and Communication Technology Paper 1 Foundation Tier G5801 Full Course [G5801] TUESDAY 22 MAY, AFTERNOON For Examiner s use only Question Number TIME 1 1 hour. 2 3 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 sixteen questions. 4 5 6 7 8 9 INFORMATION FOR CANDIDATES The total mark for this paper is 99, 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. 10 11 12 13 14 15 16 QWC Total Marks G581F7 3295 Marks Answer all sixteen questions Examiner Only Marks Remark For question 1 insert the appropriate letter in the space provided. 1 (a) A CD-ROM can be: A Written to but not read from B Written to and read from C Read from but not written to D Neither written to or read from Answer ___________ [1] (b) A floppy disk is an example of: A A magnetic storage device B An input device C An optical storage device D An output device Answer ___________ [1] (c) A computer can catch a virus from: A Attaching it to a printer B Typing in data using the keyboard C Connecting it to the Internet D Connecting a mouse to it Answer ___________ [1] G581F7 3295 2 [Turn over (d) If the content of a Master Slide is changed in a presentation: Examiner Only Marks A All slides in the presentation are changed B No slides in the presentation are changed C Only the first slide in the presentation is changed D Remark Only slides with animation are changed in the presentation Answer ___________ [1] (e) What do the letters PIN stand for? A Personal Identification Name B Personal Identification Number C Private Identification Name D Private Identification Number Answer ___________ [1] G581F7 3295 3 [Turn over A teacher has used an email package to create the following email. Examiner Only Marks Remark Dear Student All Classes for Monday 15th September will be held in the seminar room. The file you need for Monday is attached. A. N. Teacher (f) Cc means: A The person will receive a full copy of the email B The person will receive the email but not the attachment C The person will not receive the email but will receive the attachment D The person will not receive the email Answer ___________ [1] (g) Bcc means: A The person will receive the email and will not know who it is from B The person will receive the email and will not know who else received it C The person will not receive the email D The person will not receive a full copy of the email Answer ___________ [1] G581F7 3295 4 [Turn over (h) Which one of the following file extensions is not used for a text file format? A rtf C txt D Remark csv B Examiner Only Marks gif Answer ___________ [1] (i) Which of the following is not an input device? A Joystick B Mouse C Microphone D CD-RW Answer ___________ [1] (j) The links between web pages are called: A Animations B Hyperlinks C Hotspots D Framesets Answer ___________ [1] (k) Web pages are created using HTML. HTML means: A Hyper Text Media Language B Hyper Text Markup Language C Hyper Text Media Link D Hyper Text Markup Link Answer ___________ [1] G581F7 3295 5 [Turn over 2 Below are the Sales Figures for car sales at J J Black. A B C 1 D E F G March Average Sales Bonus? Sales Figures 2007 2 Staff Number 3 JJ123 Jack Smith 25,000.00 23,000.00 35,000.00 27,666.67 No 4 JJ126 John Doherty 25,000.00 34,098.00 23,489.00 27,529.00 No 5 JJ167 Heather Corry 24,789.00 24,590.00 32,098.00 27,159.00 No 6 JJ209 Matthew Watson 29,456.00 38,099.00 32,166.00 33,240.33 Yes 7 JJ240 Paul Davidson 31,876.00 23,457.00 31,450.00 28,927.67 No 8 JJ278 Lesley Arton 32,988.00 34,099.00 34,588.00 33,891.67 Yes 9 JJ279 Roger Seddon 35,678.00 12,890.00 29,800.00 26,122.67 No Anita Grey 34,509.00 32,099.00 35,099.00 33,902.33 Yes Total Sales 239,296.00 222,332.00 253,690.00 10 JJ568 11 Name January February 12 13 Number of employees to get bonus 3 14 15 Bonus Target 30,000.00 16 Examiner Only Marks Remark (a) On the table above, shade the cell which contains the February sales figures for John Doherty. [1] (b) What was the Total Sales amount for February? _______________________________________________________ [1] (c) Write down the formulae you would expect to find in the following cells (i) C11 __________________________________________________ (ii) F3 ________________________________________________ [2] (d) How has the data on the spreadsheet been sorted? _______________________________________________________ [1] (e) How have the cells A1 to G1 been formatted? _______________________________________________________ [1] G581F7 3295 6 [Turn over Below is a graph showing the Average Sales for each member of staff. Average Sales 40,000.00 35,000.00 30,000.00 25,000.00 20,000.00 15,000.00 10,000.00 5,000.00 - Ar R to og n er Se dd on An ita G re y Le sl ey ds on so n Pa u M at th ew W at C or er th lD av i ry ty er H ea n Jo h Ja c k D oh Sm ith Average Sales (f) In the table below, shade the columns that have been used to create this graph. A B 1 C D E F G March Average Sales Bonus? Sales Figures 2007 2 Staff Number 3 JJ123 Jack Smith 25,000.00 23,000.00 35,000.00 27,666.67 No 4 JJ126 John Doherty 25,000.00 34,098.00 23,489.00 27,529.00 No 5 JJ167 Heather Corry 24,789.00 24,590.00 32,098.00 27,159.00 No 6 JJ209 Matthew Watson 29,456.00 38,099.00 32,166.00 33,240.33 Yes 7 JJ240 Paul Davidson 31,876.00 23,457.00 31,450.00 28,927.67 No 8 JJ278 Lesley Arton 32,988.00 34,099.00 34,588.00 33,891.67 Yes 9 JJ279 Roger Seddon 35,678.00 12,890.00 29,800.00 26,122.67 No Anita Grey 34,509.00 32,099.00 35,099.00 33,902.33 Yes Total Sales 239,296.00 222,332.00 253,690.00 10 JJ568 11 Name January February 12 13 Number of employees to get bonus 3 14 15 Bonus Target 30,000.00 16 Examiner Only Marks Remark [2] G581F7 3295 7 [Turn over 3 Yescos Supermarket collects data about customers who use their reward card. Examiner Only Marks Remark Yescos have registered with the Data Commissioner so that customers are protected by law. (a) (i) What law protects customers and their data? ____________________________________________________ [1] (ii) What does the Data Commissioner do? ______________________________________________________ ____________________________________________________ [1] (b) The manager has made the following statements about his responsibility for customer data, to the local newspaper. Place a tick ( ) to show whether each statement is correct or incorrect. Statement We do not need to keep customer data safe but we must keep employee data safe. Customers have the right to access data about themselves. We can only hold data about customers for a certain amount of time and no longer. We can sell customer data to other companies in Europe without asking the customer. Correct Incorrect [4] G581F7 3295 8 [Turn over 4 Consider the following printers. Tick ( ) two statements that are true for each printer. Dot matrix printer Laser printer Ink jet printer 5 c c c c c Prints pages at a high speed. c c c c c Remark Has a print head which contains many nozzles. c c c c c Examiner Only Marks Has a print head which contains many nozzles. Is an impact printer. Print head strikes paper through a ribbon. Is a non impact printer. Is not noisy to use. [2] Is an impact printer. Print head strikes paper through a ribbon. Is a non impact printer. Produces low quality output. [2] Prints pages at a high speed. Is an impact printer. Print head strikes paper through a ribbon. Is a non impact printer. [2] James has a digital television in his room. It is interactive. (a) Give one example of how James can interact with his digital television. _______________________________________________________ [1] (b) Give two other advantages of having digital television. 1. _______________________________________________________ 2. _____________________________________________________ [2] G581F7 3295 9 [Turn over 6 Using the terms in the list below choose one term that best matches the de nition in the left hand column (use each term only once). JPEG Data Compression Pixel Multimedia Hard Copy Data Intranet Remark Backup Fax Machine Examiner Only Marks Search Engine Definition Term Reducing the size of a le by using special software. A device which is used to transfer paper-based information along telephone lines. The smallest area on a VDU that can be edited. A set of web pages available only within an organisation or school. A copy of data that is held at a safe location and used if the original le becomes lost or damaged. Raw facts and gures. The combination of text, graphics, video and sound to produce a presentation. A permanent copy of information usually in the form of a printout. A program which allows a user to nd information on the Internet. A graphics le format. [10] G581F7 3295 10 [Turn over 7 Elaine is booking flights for February. Below is a screenshot of her booking so far. Examiner Only Marks Remark (a) List three pieces of information she would have to input to the website to get these results. 1. _______________________________________________________ 2. _______________________________________________________ 3. _____________________________________________________ [3] (b) Give one advantage of booking flights this way. _______________________________________________________ [1] G581F7 3295 11 [Turn over 8 Fill in the blank spaces using words from the list below. (Use each word only once). analogue digital sensor Examiner Only Marks Remark ADC A feedback loop is an important part of many control systems. A _______________ records physical data which is in _______________ form. This data is then converted to _______________ form which the computer can understand using an _______________. G581F7 3295 12 [4] [Turn over 9 A basketball club stores information about members in a database table. A small section of the database is shown below. Member Number First name Surname Date of birth Gender Examiner Only Marks Remark Team 1234 Mary Wilson 12/3/90 F A 1245 John Sweeney 19/8/91 M A 1250 Margaret Lynas 10/4/87 F B 1304 Robert Swann 10/06/91 M A 1308 Owen Black 10/06/87 M B 1305 Phillippa Brunswick 10/05/90 F B (a) (i) What is the name of the key field in this database? ___________________________________________________ [1] (ii) Why is a key eld necessary in a database? ______________________________________________________ ___________________________________________________ [1] (iii) Give one situation when it would be necessary to add a record to the database. ___________________________________________________ [1] (b) What other feature of the database would be useful for presenting information? ______________________________________________________ [1] G581F7 3295 13 [Turn over 10 Below is a letter which John Black will send to the members of the Training and Learning Centre Examiner Only Marks Remark Training and Learning Centre North West Street Bangor Co. Down 30th June 2007 Dear Each year we add to our training programme. We listen to the needs of our members and design courses for them. There will be some new and exciting courses available in the new year. New courses include: Course Name Online shopping Using Email Wordprocessing Advanced Tutor J Harding M Granary T Gray Cost 120.00 134.00 200.00 We hope you will find one of these courses useful. Yours sincerely John Black (a) Tick one correct statement in each of the following questions. (i) The font style used for the address is: Bold underlined Bold italic Plain Bold G581F7 3295 [1] 14 [Turn over (ii) The date on the letter is: Examiner Only Marks Remark Right justified Fully justified Left justified Centred [1] (iii) The main text of the letter is: Right justified Fully justified Left justified Centred [1] (b) John is going to send this letter to some of the members. He has decided to use the mailmerge feature of the word processing software. Place the following mailmerge stages in order using the numbers 1, 2, 3, 4. Insert merge fields Merge letter with data Print the letters Create main letter G581F7 3295 [4] 15 [Turn over 11 Kate has a PC at home. She wants to connect it to the Internet. She needs the following: Examiner Only Marks Remark An ISP ISP Software Browser Software Telecommunications Line Modem (a) What do the letters ISP stand for? ______________________________________________________ [1] (b) Why does she need Browser Software? ______________________________________________________ [1] (c) What does the modem do when Kate is connected to the Internet? __________________________________________________________ ______________________________________________________ [1] Kate s parents decide to filter her Internet access. (d) How will this affect Kate when she is using the Internet? __________________________________________________________ ______________________________________________________ [1] G581F7 3295 16 [Turn over 12 An image which is to be placed into a document can be changed in the following ways: Rotate Flip Examiner Only Marks Remark Resize Using the above words, state what change has occurred for each set of pictures. Before After Change? (a) [1] (b) [1] (c) [1] G581F7 3295 17 [Turn over 13 Mike is going to buy the computer system below, but he cannot understand the descriptions in the bullet point list. Intel Pentium D 820 Processor Microsoft Windows XP Operating System 1 GB DDR RAM 160 GB Hard Disk Drive Dual Layer DVD ReWriter Drive 19" Sony Flat Panel Monitor (a) Give Mike an explanation of the following terms: Examiner Only Marks Remark (i) Hard Disk Drive ______________________________________________________ ___________________________________________________ [2] (ii) DVD Rewriter ______________________________________________________ ___________________________________________________ [2] (b) The shop assistant has mentioned that the computer also has some software supplied. What software is supplied with the computer? ______________________________________________________ [1] G581F7 3295 18 [Turn over (c) Mike decides to buy some extra software. Which software would be most suitable for each task he has to do? (Tick one for each task, the first one has been done for you.) Task Wordprocessor Spreadsheet Storing details of his CD collection Database Presentation Software Planning his spending over the next three months. Preparing his history coursework report. Storing names and addresses for his Christmas card list. Preparing information to give a talk to members of his local golf club. Examiner Only Marks Remark [4] (d) Mike is going to buy a scanner and a microphone. (i) How can he use the scanner as an input device? ______________________________________________________ ___________________________________________________ [1] (ii) How can he use the microphone as an input device? ______________________________________________________ ___________________________________________________ [1] G581F7 3295 19 [Turn over 14 Supermarkets use POS terminals for processing sales. Examiner Only Marks Remark (a) (i) What do the letters POS stand for? ___________________________________________________ [1] (ii) Name one input device found at a POS terminal. ___________________________________________________ [1] (iii) Name one output device found at a POS terminal. ___________________________________________________ [1] (iv) Give one benefit to the company of having a POS system. ______________________________________________________ ___________________________________________________ [1] (b) EFT can also take place at the terminal. (i) What is EFT? ___________________________________________________ [1] (ii) Give one advantage to the customer of using the EFT facility. ______________________________________________________ ___________________________________________________ [1] G581F7 3295 20 [Turn over 15 The person in the photograph below is using a virtual reality system to learn how to snowboard. Examiner Only Marks Remark (a) Give two advantages of using virtual reality for training. 1. _______________________________________________________ ________________________________________________________ 2. _______________________________________________________ ____________________________________________________ [2] (b) Give one other use for virtual reality. ______________________________________________________ [1] G581F7 3295 21 [Turn over 16 Banks are using technology to improve services for customers. Customers can use an ATM. Examiner Only Marks Remark (a) What do the letters ATM stand for? ______________________________________________________ [1] (b) List two things that a customer can do at an ATM. 1. _______________________________________________________ 2. ____________________________________________________ [2] (c) List one benefit to the customer of using an ATM. ______________________________________________________ [1] Quality of written communication THIS IS THE END OF THE QUESTION PAPER G581F7 3295 22 [Turn over 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. S 1/07 7-158-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: