/en-s3-ict-data-representation-file-size-spreadsheet-functions-network-ip-bandwidth-algorithm-tracing-multimedia-resolution-information-security-practice-paper/
/en-s3-ict-data-representation-file-size-spreadsheet-functions-network-ip-bandwidth-algorithm-tracing-multimedia-resolution-information-security-practice-paper/
General Inquiry: info@TutorZone.com.hk
Office Hours: Monday to Saturday - 9:00 AM to 6:00 PM
WhatsApp Monday to Sunday - 24 hours
Hotline: +852 6828 1809
Instant Support: +852 9061 3106

S3 Information and Communication Technology Practice Paper (Set 1): Data Representation, Spreadsheets, Networks, Algorithms, Multimedia and Information Security

S3 Information and Communication Technology Practice Paper (Set 1): Data Representation, Spreadsheets, Networks, Algorithms, Multimedia and Information Security

  • 2026-11-22

S3 Information and Communication Technology

S3 ICT practice set: data representation, file size, spreadsheet functions, IP addressing and subnetting, bandwidth, algorithm tracing, compression and information security.

Paper details S3 ICT practice paper with file size, spreadsheet function, IP addressing, bandwidth, algorithm tracing, compression and security tasks; answers include full working.

Section A: Data Representation and File Size (16 marks)

A student creates digital files with these settings: an image of 1024×768 pixels in 24-bit full colour; sound sampled at 44.1 kHz, 16-bit, stereo, 3 minutes long; a text file of 500 English characters, and another of 150 Chinese characters plus 350 English characters.

# Question Answer and marking notes
1 Find the uncompressed file size of the image in bytes and in MiB. Pixels = 1,024 x 768 = 786,432; 24-bit means 3 bytes per pixel; size = 786,432 x 3 = 2,359,296 bytes = 2.25 MiB.
2 The image is compressed losslessly to 589,824 bytes. Find the compression ratio. Ratio = 2,359,296 / 589,824 = 4.0 : 1.
3 Find the uncompressed size of the sound file in bytes and in MB (1 MB = 1,000,000 bytes). Bytes per second = 44,100 x 2 x 2 = 176,400; total = 176,400 x 180 = 31,752,000 bytes = 31.75 MB.
4 Compare the two text files in bytes under ASCII (8 bits per character) and UTF-8 (3 bytes per Chinese character, 1 byte per English character). File 1: 500 bytes under both ASCII and UTF-8; File 2: 500 bytes in ASCII and 150 x 3 + 350 = 800 bytes in UTF-8. Chinese characters need more bytes.

Section B: Spreadsheet Formulas and Functions (16 marks)

Cells B2:B6 of a spreadsheet hold the scores of five students: 62, 78, 45, 90 and 71. Column C will hold a pass formula and column D the weighted total.

# Question Answer and marking notes
5 State the results of =SUM(B2:B6) and =AVERAGE(B2:B6). Sum = 62 + 78 + 45 + 90 + 71 = 346; average = 346 / 5 = 69.2.
6 State the result of =COUNTIF(B2:B6,”>=70″) and explain what the function does. Result = 3 (78, 90 and 71); it counts the cells in the range that meet the condition (greater than or equal to 70).
7 If C2 holds =IF(B2>=50,”Pass”,”Fail”) filled down to C6, find the number of passes and failures. 4 passes (62, 78, 90, 71) and 1 failure (45). IF returns one of two text results depending on the condition.
8 The weighted total is 30% coursework (68 marks) plus 70% examination (74 marks). Write the formula and find the total. Formula =ROUND(0.3*68+0.7*74,1); total = 20.4 + 51.8 = 72.2 marks.

Section C: Networks, IP Addressing and Bandwidth (16 marks)

A school network uses the subnet 192.168.20.0/26 with a 60 Mbps downlink. Eight devices will be added in the hall for live streaming.

# Question Answer and marking notes
9 On a 60 Mbps downlink, how many seconds are needed at best to download a 750 MB file? (1 MB = 8 Mbit) Data = 750 x 8 = 6,000 Mbit; time = 6,000 / 60 = 100 s (about 1.7 minutes).
10 How many addresses does a /26 subnet contain and how many are usable for hosts? Host bits = 32 – 26 = 6; total addresses = 2^6 = 64; usable hosts = 64 – 2 = 62.
11 State the network address and the broadcast address of the subnet containing 192.168.20.130. Block size is 64, so .128 to .191 form one subnet; network address = 192.168.20.128 and broadcast address = 192.168.20.191.
12 Each of the 8 devices needs 2 Mbps for streaming and 5 Mbps is shared for browsing. Find the total bandwidth needed; if the local link provides only 20 Mbps, what is the shortfall? Streaming = 8 x 2 = 16 Mbps; total = 16 + 5 = 21 Mbps; shortfall = 21 – 20 = 1 Mbps, so more capacity or lower quality is needed.

Section D: Algorithms and Program Tracing (18 marks)

Program 1: total = 0; for i in range(1, 6): total = total + i*i. Program 2: n = 64; while n > 1: n = n // 2.

# Question Answer and marking notes
13 Trace Program 1 and state the final value of total. i takes 1, 2, 3, 4, 5 and the squares are added: 1 + 4 + 9 + 16 + 25 = 55.
14 How many times does n = n // 2 run in Program 2, and what is n when the loop ends? 64 to 32 to 16 to 8 to 4 to 2 to 1, so it runs 6 times and n = 1 at the end.
15 For 40 sorted items, compare the worst-case number of comparisons in linear search with that in binary search. Linear search worst case = 40 comparisons; binary search worst case = ceil(log2(40)) = 6.
16 First pass of bubble sort (smallest first) on [4, 2, 7, 1]: give the number of comparisons, swaps and the array after the pass. Compare 4 > 2 (swap) to [2,4,7,1]; 4 < 7 (no swap); 7 > 1 (swap) to [2,4,1,7]. So 3 comparisons, 2 swaps and the array is [2, 4, 1, 7].

Section E: Multimedia Resolution and Compression (18 marks)

A digital photo is printed at 300 dpi at 6 inches by 4 inches in 24-bit colour; a video is 1280×720, 24-bit, 25 frames per second, 10 seconds long.

# Question Answer and marking notes
17 Find the total number of pixels and the megapixel count of the photo. Pixels = (300 x 6) x (300 x 4) = 1,800 x 1,200 = 2,160,000, that is 2.16 MP.
18 Find the uncompressed size of the photo in bytes and in MiB. Size = 2,160,000 x 3 = 6,480,000 bytes = 6.18 MiB.
19 Find the uncompressed size of the video in bytes and in MiB. Each frame = 1280 x 720 x 3 = 2,764,800 bytes; total = 2,764,800 x 25 x 10 = 691,200,000 bytes = 659.18 MiB.
20 After 10:1 compression, what is the video size in bytes and MiB? Explain how this differs from lossless compression. Size = 691,200,000 / 10 = 69,120,000 bytes = 65.92 MiB. Lossy compression discards some data for a smaller file and cannot be restored exactly, while lossless compression can.

Section F: Information Security and Digital Literacy (16 marks)

A system password is 8 characters long from 62 possible characters (26 upper case, 26 lower case, 10 digits); a bank card PIN has 4 digits and the card locks after 3 wrong entries; of 500 staff, 40 percent clicked a phishing link and 25 percent of those entered their credentials.

# Question Answer and marking notes
21 Find the total number of possible 8-character passwords. Each of the 8 positions has 62 choices, so 62^8 = 218,340,105,584,896 combinations.
22 If 1,000,000,000 combinations can be tried each second, how many seconds and about how many days are needed to try them all? Time = 218,340,105,584,896 / 10^9 = 218,340.1 s; divided by 86,400 is about 2.53 days.
23 With only 3 attempts allowed, what is the chance of guessing a 4-digit PIN, as a percentage? A 4-digit PIN has 10,000 combinations; the chance is 3 / 10,000 = 0.030 percent.
24 Find the number of staff who clicked the phishing link and the number who entered credentials, and state one measure that reduces the risk. Clicked = 500 x 40 percent = 200 staff; entered credentials = 200 x 25 percent = 50. Measure: enable two-factor authentication, check sender domains and run regular phishing drills.

Find a tutor — freeTutor Registration →

A TutorZone practice paper; original questions and passages, not publisher material.

Join as a tutor or coach — academic, music, sports, arts, STEM. Free to register. See how it works →