ICT Past paper Jan 2012

Question 1) Peter is organising a school fair. He can use several software packages to help him to do this.
1. a) From the list below, select the most appropriate software package to do each of the following tasks by circling the correct letter in the boxes. (3 marks, one for each letter)
  1. A Presentation Software B Database Software C Data Logging Software D Email Software E Spread sheet Software
  2. B, E, C
2. b) Peter used his Desktop Publishing (DTP) software to show where each stall is.
  1. Give four features of DTP software used to produce the document above. (4 marks, one for each DTP)
    1. Italic, clipart, table, bold
Question 2) Tick the appropriate box to show which of the following is data, which is information and which is knowledge ( 4 marks, one for each tick)
1. Knowledge (9) Information (6)Data (3) Data (4)
Question 3
1. a) Tick which of the following statements about Bluetooth are True or False. (4 marks, one for each tick)
  1. False (5) True (2) False (7) True (4)
2. b) A Geographical Information System (GIS) can be used to capture and display information. One use of GIS is to determine how far it is from one place to another. Give one other use of GIS. (1 mark, simple answer needed)
  1. To get directions from place A to place B
3. c) Give four advantages of using broadband rather than dialup to access the Internet ( 4 marks 1 for each advantage)
  1. Easier to access websites with a lot of multimedia features
  2. You are still able to make phone calls even when connected to the internet
  3. faster internet connection
  4. Quicker to download larger files
Question 6) A teacher has set up a spreadsheet to record examination results. Part of the spreadsheet is shown below.
1. a)State the data in cell B1. (1 mark, state cell content)
  1. 50 (number/ numerical)
2. b) Which of the following formulas could be used to give the Subject Total in cell B8? (1 mark, One letter needed)
  1. A =(B1+B2+B3+B4+B5+B6+B7) B =(B3+B4+B5+B6) C =SUM(B3:B7) D =SUM(B2:B7)
    1. C- =SUM(B3:B7)
3. c) The cell C3 contains the formula =IF(B3>=$B$1, ̋Pass ̋, ̋Fail ̋). Which one of the following formulas would you expect to be contained in cell C4? (1 mark, one letter needed)
  1. A =IF(B5>=$B$1, ̋Pass ̋, ̋Fail ̋) B =IF(B4>=$B$1, ̋Pass ̋, ̋Fail ̋) C =IF(B3>=$B$1, ̋Pass ̋, ̋Fail ̋) D =IF(B3>=B1, ̋Pass ̋, ̋Fail ̋)
    1. B =IF(B4>=$B$1, ̋Pass ̋, ̋Fail ̋)
4. d) Tick the correct box to show whether the following statements are True or False.(4 marks, one for each tick)
  1. False (5) True (2) False (6) True (4)
Question 4
1. a)Tick which two of the following are advantages to customers of online shopping. (2 marks, one for each tick)
  1. (1) and (2)
2. b) Tick to show which three of the following are methods of finding a shopping website on the Internet. (3 marks, one for each tick)
  1. (2) (4) (5)
3. c)Some online stores allow shoppers to download the goods they buy. Give an example of what type of goods could be downloaded. (! mark, simple answer)
  1. Music (e.g from iTunes)
4. d)Give one method of payment used to pay for goods over the Internet. (1 mark, simple answer)
  1. Credit card or Paypal
Question 5) Many people use email
1. a) Tick which of the following statements about email are True or False. (3 marks, one for each tick)
  1. True (1) False (4) True (5)
2. b) Carbon copy is one feature of email.
  1. i) Define what is meant by carbon copy.(1 marks, define only)
    1. Carbon copy allows others to see the email even though it is not directly sent to them.
  2. ii) Give different examples of how a teacher and a pupil might use carbon copy. (2 marks, one for each example)
    1. Teacher- Email homework to students and 'CC' ing another teacher into the email
    2. Student- Emailing group work between each other, can 'CC a teacher in to also view the work.
3. c) An attachment is another feature of email.
  1. i) Define what is meant by an attachment. (1 mark, simple definition)
    1. A file (eg, picture or document) that has been added to an email
  2. ii) Give different examples of how a teacher and a pupil might use an attachment. (2 marks, one for each example)
    1. Teacher-Emailing cover work
    2. Student: Emailing work home
Question 7)
1. a) A college has created an indoor ‘rainforest’. The following sensors are being used to control the conditions in the rainforest. If a sensor detects a value that is too high it sends a value 1 to the computer.
  1. The four bits are sent in the order shown above. For each of the following describe the conditions in the rainforest when the following bit patterns are received. (3 marks, one for each set)
    1. i) (0000) temperature, light, humidity and moisture are at perfect level
    2. ii) (1100) Temperature and light are too high
    3. iii) (1111) The temperature, light, humidity and moisture is too high
2. b) he college uses a robot to teach computer control using the following instructions
  1. Write a set of instructions to make the robot travel the walkway shown in the plan below, pick up the rubbish and drop it in the bin. (3 marks)
    1. FWD 20, RIGHT 90, FWD 15, RIGHT 90, FWD 5, GRAB, FWD 5, RELEASE
Question 8) Computers can be used to support users with disabilities.
1. a) Other than a standard keyboard and mouse, state two input devices which would be suitable for disabled users. (2 marks, one for each input)
  1. foot mouse
  2. braille keyboard
2. b) Users can customise their desktops. Give two ways that people with poor eyesight can customise their desktops (2marks, one for each way)
  1. Enlarge font
  2. Desktop magnifier
Question9)A school football club keeps details of its members in a computer database.
1. a) state the number of records shown. (1 mark, simple answer)
  1. 7
2. b) Give the key field. (1 mark, simple answer)
  1. Membership number
3. c) State the purpose of the key field. (1 mark, basic definition)
  1. Unique field to identify e.g., person
4. d) The Gender field is coded. State two advantages of encoding data this way.(2 marks, one for each advantage)
  1. less chance of errors
  2. takes up less storage space
5. e)The club wants to find the female members who have paid their membership fees. Complete the table below to show how they can obtain this information from the database. ( 2 marks, one for each pair)
  1. Gender = Female
  2. Membership fees paid = Yes
6. f) The phrase GIGO (Garbage In Garbage Out) is often used when referring to data.
  1. i) Give an example of the error in the data shown opposite.(1 mark, identify)
    1. 2/14/2010, no 14th month
  2. ii)Describe how this error could have happened and describe a method of preventing this error. (3 marks, identify, define, explain)
    1. Range check, this checks the data is in the correct range, for example 1-12
  3. iii) One advantage of storing the data in a computer database is that it takes up less office space. Describe using examples, two other advantages to the club of using a computer to store the membership data. (4 marks, 2 descriptions and two examples)
    1. Can be easily updated, unlike paper copies that would have to be re written
    2. fast and efficient at sorting through large volumes of data,
Question 11) Cinema tickets can be booked on line. Other than name and contact details give four important items of data required when booking a cinema ticket. Discuss four advantages and one disadvantage of booking a cinema ticket online. (9 marks, 4 pieces of data, for advantages, one disadvantage needed)
1. Data required
  1. Film title
  2. Time
  3. What cinema
  4. How many tickets
2. Advangtages
  1. Can be booked 24/7
  2. May be cheaper than online
  3. Can think about what film you want to go and see
  4. No queues
3. Have to give personal details
Question 10) State one electronic method of registering school pupils and give two advantages of such systems to the school.( 3 marks, one for example 2 for advantages)
1. CMIS- COmputerised management Information systems
2. Less time is needed to produce management information
3. All of a students details can be stored in one place

Next up

ICT Past paper Jan 2012

Description

Resource summary

Media attachments

Similar

	Created by silverbubble98 over 10 years ago