Zusammenfassung der Ressource
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.
- 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)
- A Presentation Software
B Database Software C
Data Logging Software D
Email Software E Spread
sheet Software
- B, E, C
- b) Peter used his Desktop Publishing (DTP) software to show where each stall is.
- Give four features of DTP
software used to produce the
document above. (4 marks, one
for each DTP)
- 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)
- Knowledge (9) Information (6)Data (3) Data (4)
- Question 3
- a) Tick which of the following statements about Bluetooth are True or False. (4 marks, one for each tick)
- False (5) True (2) False (7) True (4)
- 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)
- To get directions from place A to place B
- c) Give four advantages of using broadband rather than dialup to access the Internet ( 4 marks 1 for each advantage)
- Easier to access websites with a lot of multimedia features
- You are still able to make phone calls even when connected to the internet
- faster internet connection
- 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.
- a)State the data in cell B1. (1 mark, state cell content)
- 50 (number/ numerical)
- b) Which of the following formulas could be used to give the Subject Total in cell B8? (1
mark, One letter needed)
- A =(B1+B2+B3+B4+B5+B6+B7) B =(B3+B4+B5+B6) C =SUM(B3:B7) D =SUM(B2:B7)
- C- =SUM(B3:B7)
- 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)
- 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 ̋)
- B =IF(B4>=$B$1, ̋Pass ̋, ̋Fail ̋)
- d) Tick the correct box to show whether the following statements are True or False.(4 marks, one for each
tick)
- False (5) True (2) False (6) True (4)
- Question 4
- a)Tick which two of the following are advantages to customers of online shopping. (2 marks, one for each tick)
- (1) and (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)
- (2) (4) (5)
- 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)
- Music (e.g from iTunes)
- d)Give one method of payment used to pay for goods over the Internet. (1
mark, simple answer)
- Credit card or Paypal
- Question 5) Many people use email
- a) Tick which of the following statements about email are True or False. (3
marks, one for each tick)
- True (1) False (4) True (5)
- b) Carbon copy is one feature of email.
- i) Define what is meant by carbon copy.(1 marks, define only)
- Carbon copy allows others to see the email even though it is not directly sent to them.
- ii) Give different examples of how a teacher and a pupil might use carbon copy. (2
marks, one for each example)
- Teacher- Email homework to students and 'CC' ing another teacher into the email
- Student- Emailing group work between each other, can 'CC a
teacher in to also view the work.
- c) An attachment is another feature of email.
- i) Define what is meant by an attachment. (1 mark, simple definition)
- A file (eg, picture or document) that has been added to an email
- ii) Give different examples of how a teacher and a pupil might use an attachment. (2 marks, one for each example)
- Teacher-Emailing cover work
- Student: Emailing work home
- Question 7)
- 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.
- 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)
- i) (0000) temperature, light, humidity and moisture are at perfect level
- ii) (1100) Temperature and light are too high
- iii) (1111) The temperature, light, humidity and moisture is too high
- b) he college uses a robot to teach computer control using the following instructions
- 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)
- 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.
- 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)
- foot mouse
- braille keyboard
- b) Users can customise their desktops. Give two
ways that people with poor eyesight can customise
their desktops (2marks, one for each way)
- Enlarge font
- Desktop magnifier
- Question9)A school football club keeps details of its members in a computer database.
- a) state the number of
records shown. (1 mark,
simple answer)
- 7
- b) Give the key field.
(1 mark, simple
answer)
- Membership number
- c) State the purpose of the
key field. (1 mark, basic
definition)
- Unique field to identify e.g., person
- d) The Gender field is coded. State two advantages of encoding data this
way.(2 marks, one for each advantage)
- less chance of errors
- takes up less storage space
- 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)
- Gender = Female
- Membership fees paid = Yes
- f) The phrase GIGO (Garbage In Garbage Out) is often used when referring to data.
- i) Give an example of the
error in the data shown
opposite.(1 mark, identify)
- 2/14/2010, no 14th month
- ii)Describe how this error could
have happened and describe a
method of preventing this error. (3
marks, identify, define, explain)
- Range check, this checks the data is in the correct
range, for example 1-12
- 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)
- Can be easily updated, unlike paper copies that would have to be re written
- 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)
- Data required
- Film title
- Time
- What cinema
- How many tickets
- Advangtages
- Can be booked 24/7
- May be cheaper than online
- Can think about what film you want to go and see
- No queues
- 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)
- CMIS- COmputerised management Information systems
- Less time is needed to
produce management
information
- All of a students details can be stored in one place