ICT Past Year Paper
ICT Past Year Paper
INFORMATIONANDCOMMUNICATIONTECHNOLOGY 0417/11
*6189791534*
Paper1Theory May/June2022
2 hours
Youmustansweronthequestionpaper.
Noadditionalmaterialsareneeded.
INSTRUCTIONS
• Answer all questions.
• Use a black or dark blue pen.
• Write your name, centre number and candidate number in the boxes at the top of the page.
• Write your answer to each question in the space provided.
• Do not use an erasable pen or correction fluid.
• Do not write on any bar codes.
• You may use an HB pencil for any diagrams, graphs or rough working.
INFORMATION
06_0417_11_2022_1.16
© UCLES 2022 [Turn over
1 Circle two network devices.
Actuator Bridge Database DVD
2 Complete each sentence using the most appropriate item from the list. Your answers must be
different in each case.
.............Hardware..............................................................................................................................
[1]
..................Software.........................................................................................................................
[1]
...................A anpplet........................................................................................................................
[1]
...........................Sensor................................................................................................................
[1]
1 .ADC.......................................................................................................................................
2 .Sensor...................................................................................................................................
[2]
4 ............................ Many laptop computers use the cloud to store data. A technician has produced
a report on his laptop computer but has stored the report on a memory stick rather than storing it
on the cloud.
Describe two advantages of using a memory stick rather than the cloud to store data.
..................................................................................................................................................
[2]
Describe the advantages and disadvantages of using these cards rather than cards that use chip
and PIN.
Advantage
Disadvantage
A stylesheet is a file that makes a webpage look nice. It changes things like colors, fonts
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b)
Explain the differences between attached stylesheets and inline style attributes.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
7 Two types of database are relational and flat file.
(a) Compare and contrast relational databases and flat file databases. Your answer must
include similarities and differences.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [8]
(b) Give, using an example, one reason why flat file databases are used in certain applications
rather than relational databases.
Reason .............................................................................................................................
...........................................................................................................................................
Example ............................................................................................................................
...........................................................................................................................................
[2]
8 When using computers people can suffer from Repetitive Strain Injury (RSI).
(a) Describe the term RSI. Include in your answer the causes of RSI.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [3]
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
9 Martin, who is a teacher, is creating a multimedia presentation to explain a topic to his students.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
4 ........................................................................................................................................
[4]
(b) Martin wants to record a message for his students. His voice will be added to the
presentation. He will also need to listen to his voice to make sure the sound is of good
quality.
1 ........................................................................................................................................
2 ........................................................................................................................................
[2]
(c) Martin will need to use software to create different types of content before including them in
the presentation.
Name two types of software that he might use and for each one, write down what he would
use it for.
© UCLES 2022 06_0417_11_2022_1.16 [Turn over
6
Software 1 ........................................................................................................................
...........................................................................................................................................
Use ...................................................................................................................................
...........................................................................................................................................
Software 2 ........................................................................................................................
...........................................................................................................................................
Use ...................................................................................................................................
...........................................................................................................................................
[4]
10 A river authority is concerned about levels of pollution in a major river. The quality of the water in
the river needs to be monitored using sensors.
(a) Name three sensors that could be used to measure the pollution in the river.
1 ........................................................................................................................................
2 ........................................................................................................................................
3 ........................................................................................................................................
[3]
(b) Discuss the advantages and disadvantages of using computers to measure the pollution in
the river rather than humans measuring the pollution.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
© UCLES 2022 06_0417_11_2022_1.16
7
........................................................................................................................................... [6]
Discuss the advantages and disadvantages of analysing a system by interviewing staff rather
than using questionnaires.
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
..................................................................................................................................................
.................................................................................................................................................. [6]
12 Many company computer network systems use WiFi as a communication system to help prevent
the issue of tripping over trailing cables.
(a) For each of the following physical safety issues describe two ways of helping to prevent them.
(i) Fire
Prevention 1 ..........................................................................................................
................................................................................................................................
Prevention 2 ..........................................................................................................
................................................................................................................................
[2]
(ii) Electrocution
Prevention 1 ..........................................................................................................
................................................................................................................................
Prevention 2 ..........................................................................................................
© UCLES 2022 06_0417_11_2022_1.16 [Turn over
8
................................................................................................................................
[2]
(b) Describe three eSafety measures which should be taken when playing games on the internet.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
[3]
(c) In order to log onto online gaming a user ID and password is needed.
Explain what is meant by a user ID and password and why they are needed.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
13 (a) Explain the need for copyright legislation when data is published on the internet.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(b) Describe methods that software producers use to prevent software copyright being broken.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
(c) Emails are used by people to communicate with each other. Copyright and using acceptable
language in the email are two of the constraints that affect the use of email.
(i) Describe four other constraints that may affect the use of email.
1 ..............................................................................................................................
..............................................................................................................................
2 ..............................................................................................................................
..............................................................................................................................
3 ..............................................................................................................................
..............................................................................................................................
4 ..............................................................................................................................
..............................................................................................................................
[4]
1 ..............................................................................................................................
..............................................................................................................................
2 ..............................................................................................................................
..............................................................................................................................
[2]
14 The manager of a medical centre keeps the doctor’s stock records in a database. The stock for
any item is not allowed to fall below 15 items and the manager keeps a maximum of 100 items in
stock.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [2]
(b) Write down the field name from the table that would be the most appropriate for each of
these validation checks. Each answer must be different.
Length ...............................................................................................................................
Type ..................................................................................................................................
[3]
(c) Name the most appropriate field from the table that could be used as a primary key in the
database.
........................................................................................................................................... [1]
15 A customer is booking a seat on a theatre’s online booking system. The customer reserves seats
using the theatre’s website and a debit card. The website displays the seats that are available
and a database stores the customer details, the payment details and the seat details.
When the customer enters their debit card details for a seat, the theatre’s computer
communicates with the bank’s computer.
(a) Describe four checks that the bank’s computer will make on the customer’s bank account.
1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................
3 ........................................................................................................................................
...........................................................................................................................................
4 ........................................................................................................................................
...........................................................................................................................................
[4]
(b) Describe the processing carried out by the theatre’s computer when making a booking.
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
........................................................................................................................................... [4]
BLANK PAGE
Permission to reproduce items where third-party owned material protected by copyright is included has been sought and cleared where possible. Every
reasonable effort has been made by the publisher (UCLES) to trace copyright holders, but if any items requiring clearance have unwittingly been included, the
publisher will be pleased to make amends at the earliest possible opportunity.
To avoid the issue of disclosure of answer-related information to candidates, all copyright acknowledgements are reproduced online in the Cambridge
Assessment International Education Copyright Acknowledgements Booklet. This is produced for each series of examinations and is freely available to download
at [Link] after the live examination series.
Cambridge Assessment International Education is part of Cambridge Assessment. Cambridge Assessment is the brand name of the University of Cambridge
Local Examinations Syndicate (UCLES), which is a department of the University of Cambridge.