* 0000800000001 *

www.dynamicpapers.com
,










,

™
Cambridge IGCSE

¬Xw@4mIsQ¢MŠ@z6W
¬NHE•lLk{v™>P”FJ‚
¥ee•u•e•EuuU¥ ¥UuU

INFORMATION AND COMMUNICATION TECHNOLOGY 0417/13

*6982938712*

Paper 1 Theory October/November 2024

1 hour 30 minutes

You must answer on the question paper.

No additional materials are needed.

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
• The total mark for this paper is 80.
• The number of marks for each question or part question is shown in brackets [ ].
• No marks will be awarded for using brand names of software packages or hardware.

This document has 12 pages.

11_0417_13_2024_1.9
© UCLES 2024 [Turn over
 * 0000800000002 *
www.dynamicpapers.com
2

DO NOT WRITE IN THIS MARGIN

,










,

1 A computer can use both ROM and RAM.

(a) State the characteristics of:

(i) ROM

................................................................................................................................

................................................................................................................................

................................................................................................................................

DO NOT WRITE IN THIS MARGIN

................................................................................................................................ [2]

(ii) RAM

................................................................................................................................

................................................................................................................................

................................................................................................................................

................................................................................................................................ [2]

DO NOT WRITE IN THIS MARGIN

(b) State one use for each of the following storage devices and media.

(i) ROM

................................................................................................................................

................................................................................................................................ [1]

(ii) RAM.

................................................................................................................................

DO NOT WRITE IN THIS MARGIN

................................................................................................................................ [1]

(iii) Blu-ray disc

................................................................................................................................

................................................................................................................................ [1]

(iv) Magnetic tape

................................................................................................................................
DO NOT WRITE IN THIS MARGIN

................................................................................................................................ [1]

© UCLES 2024 ĬÖ÷Àĝ´íÉóÑĢÍĊ½ü¸ý× 11_0417_13_2024_1.9

ĬÎÆĂÈđàÞÔĆĄööæäîÂĂ
ĥõµĕµõĥõõµåĕĥÅąĕÕÕ
 * 0000800000003 *
www.dynamicpapers.com
3
DO NOT WRITE IN THIS MARGIN

,










,

2 A computer can use different generic file formats.

(a) Describe each of the following generic file formats.

(i) csv

................................................................................................................................

................................................................................................................................

................................................................................................................................
DO NOT WRITE IN THIS MARGIN

................................................................................................................................ [2]

(ii) rar

................................................................................................................................

................................................................................................................................

................................................................................................................................
DO NOT WRITE IN THIS MARGIN

................................................................................................................................ [2]

(iii) txt

................................................................................................................................

................................................................................................................................

................................................................................................................................

................................................................................................................................ [2]
DO NOT WRITE IN THIS MARGIN

(b) The file formats txt, rar and csv are examples of generic file formats.

State three other examples of generic file formats.

1 ........................................................................................................................................

2 ........................................................................................................................................

3 ........................................................................................................................................

[3]
DO NOT WRITE IN THIS MARGIN

© UCLES 2024 ĬØ÷Àĝ´íÉóÑĢÍĊ½ú¸ý×

ĬÎÅāÀėäÎåôí³âÎøî²Ă
11_0417_13_2024_1.9 [Turn over
ĥõÅÕõĕąĕĥÅõĕĥåĥÕÅÕ
 * 0000800000004 *
www.dynamicpapers.com
4

DO NOT WRITE IN THIS MARGIN

,










,

(c) Explain the need for generic file formats.

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

........................................................................................................................................... [2]

DO NOT WRITE IN THIS MARGIN

3 Many people use portable solid-state drives (SSD) rather than portable hard disk drives (HDD).

Compare SSDs and HDDs. Your answer should include both similarities and differences.

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

DO NOT WRITE IN THIS MARGIN

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

DO NOT WRITE IN THIS MARGIN

.................................................................................................................................................. [6]

DO NOT WRITE IN THIS MARGIN

© UCLES 2024 ĬÖ÷Àĝ´íÉóÑĢÍĊ¿ü¸ÿ× 11_0417_13_2024_1.9

ĬÎÅĄÀčÒÛÒîö¼ĄòÖĞÊĂ
ĥÅĕÕµĕąµąĥąĕååÅÕÕÕ
 * 0000800000005 *
www.dynamicpapers.com
5
DO NOT WRITE IN THIS MARGIN

,










,

4 A number of different communication devices can be connected to a network.

(a) Explain how the following devices operate.

(i) Switch

................................................................................................................................

................................................................................................................................

................................................................................................................................
DO NOT WRITE IN THIS MARGIN

................................................................................................................................

................................................................................................................................

................................................................................................................................

................................................................................................................................

................................................................................................................................ [4]
DO NOT WRITE IN THIS MARGIN

(ii) Router

................................................................................................................................

................................................................................................................................

................................................................................................................................

................................................................................................................................

................................................................................................................................

................................................................................................................................
DO NOT WRITE IN THIS MARGIN

................................................................................................................................

................................................................................................................................ [4]

(b) Bridges are communication devices.

Explain what bridges are used for.

...........................................................................................................................................
DO NOT WRITE IN THIS MARGIN

........................................................................................................................................... [1]

© UCLES 2024 ĬØ÷Àĝ´íÉóÑĢÍĊ¿ú¸ÿ×

ĬÎÆăÈěÎëçČċíØĊĂкĂ
11_0417_13_2024_1.9 [Turn over
ĥÅĥĕõõĥÕĕĕÕĕåÅåĕÅÕ
 * 0000800000006 *
www.dynamicpapers.com
6

DO NOT WRITE IN THIS MARGIN

,










,

(c) Ensuring the privacy and confidentiality of data becomes more important when using computer
networks.

Evaluate the different ways in which a user can ensure the privacy and confidentiality of data
by using passwords.

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

DO NOT WRITE IN THIS MARGIN

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

DO NOT WRITE IN THIS MARGIN

...........................................................................................................................................

...........................................................................................................................................

........................................................................................................................................... [6]

DO NOT WRITE IN THIS MARGIN

DO NOT WRITE IN THIS MARGIN

© UCLES 2024 ĬÚ÷Àĝ´íÉóÑĢÍĊ¾úµý× 11_0417_13_2024_1.9

ĬÎÅăËđ¶áßÿúĈ¸òģÆÊĂ
ĥĕÅĕõÕĥõÕõõĕĥÅąÕĕÕ
 * 0000800000007 *
www.dynamicpapers.com
7
DO NOT WRITE IN THIS MARGIN

,










,

5 Repetitive strain injury (RSI) and eye strain can be caused by using a computer. Taking breaks is
one strategy for reducing these health issues.

(a) State two causes of repetitive strain injury (RSI) and give two other strategies for preventing
it.

Cause 1 ............................................................................................................................

...........................................................................................................................................

Cause 2 ............................................................................................................................
DO NOT WRITE IN THIS MARGIN

...........................................................................................................................................

Strategy 1 .........................................................................................................................

...........................................................................................................................................

Strategy 2 .........................................................................................................................

...........................................................................................................................................

[4]
DO NOT WRITE IN THIS MARGIN

(b) State two causes of eye strain and give two other strategies for preventing it.

Cause 1 ............................................................................................................................

...........................................................................................................................................

Cause 2 ............................................................................................................................

...........................................................................................................................................

Strategy 1 .........................................................................................................................
DO NOT WRITE IN THIS MARGIN

...........................................................................................................................................

Strategy 2 .........................................................................................................................

...........................................................................................................................................

[4]
DO NOT WRITE IN THIS MARGIN

© UCLES 2024 ĬÜ÷Àĝ´íÉóÑĢÍĊ¾üµý×

ĬÎÆĄÃėºÑÚùćÁĤĊ·ÆºĂ
11_0417_13_2024_1.9 [Turn over
ĥĕµÕµµąĕÅąåĕĥåĥĕąÕ
 * 0000800000008 *
www.dynamicpapers.com
8

DO NOT WRITE IN THIS MARGIN

,










,

6 Smartphones and desktop computers can be used to play video games.

Discuss the advantages and disadvantages of using a smartphone rather than a desktop computer
to play video games.

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

DO NOT WRITE IN THIS MARGIN

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

DO NOT WRITE IN THIS MARGIN

..................................................................................................................................................

..................................................................................................................................................

.................................................................................................................................................. [6]

DO NOT WRITE IN THIS MARGIN

DO NOT WRITE IN THIS MARGIN

© UCLES 2024 ĬÚ÷Àĝ´íÉóÑĢÍĊÀúµÿ× 11_0417_13_2024_1.9

ĬÎÆāÃčÌØÝ÷ĀÊÂæĕÖÂĂ
ĥåĥÕõµąµååÕĕååÅĕĕÕ
 * 0000800000009 *
www.dynamicpapers.com
9
DO NOT WRITE IN THIS MARGIN

,










,

7 Schools can use School management systems.

(a) Describe the inputs, processing and outputs required by a School management system to
show learner performance.

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................
DO NOT WRITE IN THIS MARGIN

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................
DO NOT WRITE IN THIS MARGIN

...........................................................................................................................................

...........................................................................................................................................

........................................................................................................................................... [6]

(b) Computer Aided Learning (CAL) can be part of a School management system.

Explain what is meant by Computer Aided Learning.

...........................................................................................................................................
DO NOT WRITE IN THIS MARGIN

...........................................................................................................................................

...........................................................................................................................................

........................................................................................................................................... [2]
DO NOT WRITE IN THIS MARGIN

© UCLES 2024 ĬÜ÷Àĝ´íÉóÑĢÍĊÀüµÿ×

ĬÎÅĂËěÈèÜāñÿĖÎÁÖ²Ă
11_0417_13_2024_1.9 [Turn over
ĥåĕĕµÕĥÕµÕąĕåÅåÕąÕ
 * 0000800000010 *
www.dynamicpapers.com
10

DO NOT WRITE IN THIS MARGIN

,










,

8 The manager of a plant nursery has asked a systems analyst to create a new database system to
store information about his plants. This new database system needs to store the following data.

• the unique reference number for each plant

• the common name for each plant
• if the plant is scented or non-scented
• the price of each plant on a range from $10 to $100
• the maximum height of the plant in metres

Part of the database is shown:

DO NOT WRITE IN THIS MARGIN

Ref_No Name_of_plant Scented Price ($) Height (m)

HT134 Rose Peace S 12.99 1.20

WO016 White Oak N 98.00 5.24

SP345 Spindle Tree S 25.99 9.00

(a) For each of the fields shown, state and describe the most appropriate validation check that
could be used on the data. Your answers must be different in each case.

(i) Ref_No

DO NOT WRITE IN THIS MARGIN

Validation check ....................................................................................................

Description ............................................................................................................

................................................................................................................................

[2]

(ii) Price ($)

Validation check ....................................................................................................

DO NOT WRITE IN THIS MARGIN

Description ............................................................................................................

................................................................................................................................

[2]
DO NOT WRITE IN THIS MARGIN

© UCLES 2024 ĬÚ÷Àĝ´íÉóÑĢÍĊ½ú·ý× 11_0417_13_2024_1.9

ĬÎÇāÊďÄÂãðćĤÞèñкĂ
ĥõąĕõµåµąĕÕÕåąÅĕåÕ
 * 0000800000011 *
www.dynamicpapers.com
11
DO NOT WRITE IN THIS MARGIN

,









,

(b) In the table, state the most appropriate data types to create the database using the information
given before. For any numeric field, specify the type of number.

Field name Data type

Name_of_plant

Scented

Price ($)
DO NOT WRITE IN THIS MARGIN

Height (m)

[4]

9 (a) Circle two web development layers.

Behaviour Body CSS Display

DO NOT WRITE IN THIS MARGIN

Head HTML Presentation Surface

[2]

(b) Explain why tables are used to structure elements within a web page.

...........................................................................................................................................

...........................................................................................................................................

...........................................................................................................................................
DO NOT WRITE IN THIS MARGIN

........................................................................................................................................... [2]
DO NOT WRITE IN THIS MARGIN

© UCLES 2024 ĬÜ÷Àĝ´íÉóÑĢÍĊ½ü·ý×

ĬÎÈĂÂęÀ²ÖĊúåúÐåĞÊĂ
11_0417_13_2024_1.9 [Turn over
ĥõõÕµÕÅÕĕĥąÕåĥåÕµÕ
 * 0000800000012 *
www.dynamicpapers.com
12

DO NOT WRITE IN THIS MARGIN

,









,

10 A gesture based user interface can be used in gaming devices to play games.

Describe the benefits and drawbacks of using a gesture based interface in this scenario.

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

DO NOT WRITE IN THIS MARGIN

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

..................................................................................................................................................

DO NOT WRITE IN THIS MARGIN

..................................................................................................................................................

.................................................................................................................................................. [6]

DO NOT WRITE IN THIS MARGIN

DO NOT WRITE IN THIS MARGIN

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 www.cambridgeinternational.org 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.

© UCLES 2024 ĬÚ÷Àĝ´íÉóÑĢÍĊ¿ú·ÿ× 11_0417_13_2024_1.9

ĬÎÈăÂē®·áĈñÞÜôćî²Ă
ĥÅåÕõÕÅõõÅõÕĥĥąÕåÕ