S3 Information and Communication Technology Practice Paper (Set 1): Data Representation, Spreadsheets, Networks, Algorithms, Multimedia and Information Security
- 2026-11-22
S3 ICT practice set: data representation, file size, spreadsheet functions, IP addressing and subnetting, bandwidth, algorithm tracing, compression and information security.
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.



