Practice gce model questions vol1 computer_studies 2024 Past Questions

Question 1 View Details

A class of 50 students took a test. Their scores are grouped as follows: $40\text{-}49$: 5 students, $50\text{-}59$: 12 students, $60\text{-}69$: 20 students, $70\text{-}79$: 8 students, $80\text{-}89$: 5 students. Using the grouped‑data method, determine the inter‑quartile range (IQR) of the scores, and then calculate the percentage of students who scored above the third quartile $Q_{3}$. Give your answer as a whole‑number percentage.

Correct A. 22

B. 25

C. 18

D. 30

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 2 View Details

Consider the following pseudo‑code: x ← 5; y ← 0; while x < 100 do if x mod 3 = 0 then y ← y + x end if; x ← x + 7 end while; output y. What integer value is displayed when the program finishes execution?

A. 280

B. 260

C. 300

Correct D. 270

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 3 View Details

A spreadsheet records monthly sales (in thousands of naira) for the first six months: Jan = 45, Feb = 58, Mar = 62, Apr = 40, May = 55, Jun = 70. The commission on each month's sales is calculated as follows: 5 % on the first 50 k, 7 % on the amount between 50 k and 65 k, and 10 % on any amount above 65 k. (a) Compute the total commission earned for the six months. (b) The salesperson wants a total commission of 20 000 naira. Assuming the same rates apply, what additional sales (in thousands of naira) must be achieved in July to reach this target? Give the required sales as a whole number (in thousands).

A. 60

Correct B. 49

C. 55

D. 44

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 4 View Details

Who is credited with inventing the World Wide Web?

A. Leonard Kleinrock

B. Robert Kahn

Correct C. Tim Berners‑Lee

D. Vint Cerf

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 5 View Details

In which year was the Intel 4004 microprocessor, the first commercially successful microprocessor, released?

Correct A. 1971

B. 1972

C. 1974

D. 1970

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 6 View Details

A network of 8 computers uses three possible topologies, each with links of 100 Mbps. In a star topology a central hub connects to each computer; the hub can transmit to all computers simultaneously. In a bus topology all computers share a single 100 Mbps bus, and only one computer can transmit at a time. In a ring topology each computer is linked to its two neighbours and the data is passed around the ring, one transmission at a time. A file of size $10$ MB must be sent from computer A to all other computers (broadcast). Ignoring propagation delay, calculate the total time required for the broadcast in each topology and state which topology gives the minimum total time. Give the minimum time in seconds.

Correct A. 0.8

B. 1.0

C. 0.6

D. 0.9

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 7 View Details

Place the following developments in chronological order, using the letters a-d: a) Invention of the microprocessor, b) Release of the first IBM PC, c) Introduction of the World Wide Web, d) Launch of the first Apple Macintosh.

Correct A. a, b, d, c

B. a, d, b, c

C. b, a, d, c

D. a, b, c, d

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 8 View Details

A company stores a database of size $2.5$ GB. First it is compressed losslessly, reducing the size by $30\%$. Then a lossy compression reduces the size further by $40\%$ of the original size. After compression a checksum file of $0.02$ GB must also be stored. The backup media are DVDs that hold $1.5$ GB each. How many DVDs are required in total to store (i) the original uncompressed database and (ii) the compressed database together with the checksum file?

Correct A. 3

B. 2

C. 5

D. 4

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 9 View Details

A small office is allocated the class‑B address block $172.16.0.0/16$. It needs three subnets for the departments Admin (50 hosts), Sales (120 hosts) and R&D (30 hosts). Each department will use a star topology internally. Determine (a) the subnet mask (in dotted‑decimal notation) that can accommodate all three subnets with minimal waste, and (b) the network address and first usable host address for each department's subnet, allocating the subnets sequentially from the start of the address block.

A. Subnet mask: 255.255.255.128 Admin subnet: 172.16.0.0/25, first host 172.16.0.2 Sales subnet: 172.16.0.128/25, first host 172.16.0.130 R&D subnet: 172.16.1.0/25, first host 172.16.1.2

B. Subnet mask: 255.255.255.0 Admin subnet: 172.16.0.0/24, first host 172.16.0.1 Sales subnet: 172.16.1.0/24, first host 172.16.1.1 R&D subnet: 172.16.2.0/24, first host 172.16.2.1

Correct C. Subnet mask: 255.255.255.128 Admin subnet: 172.16.0.0/25, first host 172.16.0.1 Sales subnet: 172.16.0.128/25, first host 172.16.0.129 R&D subnet: 172.16.1.0/25, first host 172.16.1.1

D. Subnet mask: 255.255.255.128 Admin subnet: 172.16.0.128/25, first host 172.16.0.129 Sales subnet: 172.16.1.0/25, first host 172.16.1.1 R&D subnet: 172.16.0.0/25, first host 172.16.0.1

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 10 View Details

In a spreadsheet the months January to June are listed in cells B3:B8. The expense categories Rent, Food, Transport and Entertainment are in columns C to F, with the monthly amounts entered in the range C3:F8. (a) Write a formula to calculate the total annual expense for all categories. (b) Write a formula to calculate the average monthly expense for each category. (c) Assuming column G contains the total expense for each month (e.g., G3 = SUM(C3:F3)), write a formula that returns the month name (from column B) with the highest total expense. (d) Provide the conditional‑formatting formula that highlights any individual expense cell in C3:F8 that exceeds 20 % of that month's total expense.

A. a) =SUM(C3:F9) b) Rent: =AVERAGE(C3:C7); Food: =AVERAGE(D3:D7); Transport: =AVERAGE(E3:E7); Entertainment: =AVERAGE(F3:F7) c) =INDEX(B3:B8, MATCH(MAX(G3:G8), G3:G8, 1)) d) Conditional‑formatting formula: =C3>0.2*SUM($C$3:$F$8)

Correct B. a) =SUM(C3:F8) b) Rent: =AVERAGE(C3:C8); Food: =AVERAGE(D3:D8); Transport: =AVERAGE(E3:E8); Entertainment: =AVERAGE(F3:F8) c) =INDEX(B3:B8, MATCH(MAX(G3:G8), G3:G8, 0)) d) Conditional‑formatting formula: =C3>0.2*SUM($C3:$F3)

C. a) =SUM(C3:F8)*12 b) Rent: =AVERAGE(C3:C8); Food: =AVERAGE(D3:D8); Transport: =AVERAGE(E3:E8); Entertainment: =MEDIAN(F3:F8) c) =INDEX(B3:B8, MATCH(LARGE(G3:G8,2), G3:G8, 0)) d) Conditional‑formatting formula: =C3>0.15*SUM($C3:$F3)

D. a) =SUM(C3:E8) b) Rent: =AVERAGE(C3:C8); Food: =AVERAGE(D3:D8); Transport: =AVERAGE(F3:F8); Entertainment: =AVERAGE(E3:E8) c) =INDEX(B3:B8, MATCH(MIN(G3:G8), G3:G8, 0)) d) Conditional‑formatting formula: =C3>0.25*SUM($C3:$F3)

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 11 View Details

Consider the following pseudocode where N is a positive integer: SET total = 0 SET i = 1 WHILE i <= N IF i MOD 3 = 0 THEN total = total + i ELSE IF i < 10 THEN total = total + i*i ENDIF i = i + 2 ENDWHILE OUTPUT total If $N = 15$, what value is output?

A. 108

B. 87

Correct C. 102

D. 96

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 12 View Details

A program reads an 8‑bit binary number B and converts it to a signed decimal integer using two's complement representation, then adds 7 to the result before outputting it. The conversion algorithm is: READ B IF most significant bit of B = 0 THEN D = binary_to_decimal(B) ELSE Invert all bits of B to get B' Add 1 to B' to obtain B'' D = - binary_to_decimal(B'') ENDIF OUTPUT D + 7 If the input binary string is $B = 10100101$, what integer does the program output?

A. 172

B. -83

Correct C. -84

D. -91

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 13 View Details

An IPv4 address is $192.168.58.130$ with subnet mask $255.255.255.224$. Determine the network address, the broadcast address, and the number of usable host addresses in this subnet.

A. Network: 192.168.58.129, Broadcast: 192.168.58.159, Usable hosts: 30

B. Network: 192.168.58.128, Broadcast: 192.168.58.159, Usable hosts: 32

C. Network: 192.168.58.128, Broadcast: 192.168.58.158, Usable hosts: 29

Correct D. Network: 192.168.58.128, Broadcast: 192.168.58.159, Usable hosts: 30

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 14 View Details

Consider a relation R(A, B, C, D) with the functional dependencies: $A \rightarrow B,\; B \rightarrow C,\; A \rightarrow D$. (a) What is the highest normal form (up to BCNF) that R satisfies? (b) Decompose R into a collection of relations that are in Boyce‑Codd Normal Form (BCNF). List the resulting relation schemas.

A. (a) 2NF; (b) {R1(A, B), R2(B, C, D)}

Correct B. (a) 2NF; (b) {R1(B, C), R2(A, B, D)}

C. (a) 3NF; (b) {R1(B, C), R2(A, D)}

D. (a) 1NF; (b) {R1(B, C), R2(A, B, D)}

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 15 View Details

The following pseudocode implements insertion sort on an array A[1…n]: FOR i = 2 TO n key = A[i] j = i - 1 WHILE j > 0 AND A[j] > key A[j+1] = A[j] j = j - 1 ENDWHILE A[j+1] = key ENDFOR Assuming the input array is initially sorted in strictly descending order, how many comparisons between array elements and the variable `key` are performed when the algorithm runs on an array of size $n = 10$?

A. 55

B. 60

Correct C. 54

D. 45

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 16 View Details

A computer has the following components with their power consumptions: CPU 95 W, GPU 150 W, HDD 10 W, SSD 5 W, motherboard 50 W, and two fans each 5 W. The recommended power‑supply headroom is 20 %. Is a 350 W PSU adequate?

Correct A. No, it is not adequate; a minimum of 384 W is required.

B. No, it is not adequate; a minimum of 350 W is required.

C. No, it is not adequate; a minimum of 400 W is required.

D. Yes, it is adequate; a 350 W PSU is sufficient.

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 17 View Details

Consider the following HTML and CSS: HTML: <div id="content"> <p class="note" style="color: yellow;">Important</p> </div> CSS: #content p { color: blue; } .note { color: green; } #content .note { color: red !important; } What colour will the paragraph text finally be displayed as in a browser?

A. yellow

B. blue

C. green

Correct D. red

Correct Answer: D

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 18 View Details

The following CSS media queries are defined: @media (max-width: 800px) { .sidebar { display: none; } } @media (min-width: 600px) { .sidebar { display: block; width: 200px; } } @media (min-width: 750px) and (max-width: 900px) { .sidebar { width: 250px; } } In the HTML there is <div class="sidebar">Menu</div>. At a viewport width of 770 px, what are the computed values of the display and width properties for the .sidebar element?

A. display: none; width: 200 px

Correct B. display: block; width: 250 px

C. display: block; width: 200 px

D. display: none; width: 250 px

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 19 View Details

A risk analyst evaluates three assets using the formula Risk = Likelihood × Impact (Impact is rated 1-5). The data are: - Asset A: Likelihood 0.2, Impact 5 - Asset B: Likelihood 0.5, Impact 3 - Asset C: Likelihood 0.1, Impact 4 Which asset should be given the highest priority for mitigation?

Correct A. Asset B

B. Asset C

C. Asset A

D. Asset D

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 20 View Details

In a spreadsheet, cells A1 to A4 contain the numbers 120, 85, 95 and 110 respectively. Cell B1 has the formula =IF(AND(A1>=100, A1<=130), "Pass", "Fail") and this formula is copied down to B2:B4 using relative references. What values appear in cells B1 through B4?

A. Pass, Pass, Fail, Pass

Correct B. Pass, Fail, Fail, Pass

C. Fail, Fail, Fail, Pass

D. Pass, Fail, Pass, Pass

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 21 View Details

Consider the following Python code: ```python n = 50 i = 1 total = 0 while i < n: i = i + 1 if i % 2 == 0: i = i + 2 if i % 3 == 0: total = total + i*i ``` What value is stored in `total` after the loop finishes?

A. 4200

Correct B. 4320

C. 4500

D. 4080

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 22 View Details

A company records quarterly sales (in units) for three products. In Q1 the sales are: Product A = 1200, Product B = 800, Product C = 500. The following growth information is given: - From Q1 to Q2, Product A grows by 10 %, Product C grows by 5 %, and Product B grows by an unknown percentage $x\%$. - From Q2 to Q3, Product A grows by 8 %, Product B grows by 12 %, and Product C grows by an unknown percentage $y\%$. - The total sales increase by 30 % from Q1 to Q2. - The total sales increase by 20 % from Q2 to Q3. - From Q3 to Q4 each product grows by the same percentage $p$. In Q4 the sales of Product B are known to be 1500 units. What is the total sales of all three products in Q4 (rounded to the nearest whole unit)?

A. 2300

B. 2400

Correct C. 2369

D. 2500

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 23 View Details

A desktop computer is powered by a 12 V supply unit rated at 300 W. The following components are installed: - CPU: 65 W - GPU: 150 W - Hard‑disk drive: 10 W - Solid‑state drive: 5 W - Each additional 12 V fan consumes 2 W. Assuming all components operate at the full 12 V, how many extra fans can be added without exceeding the power‑supply rating?

A. 36

B. 33

Correct C. 34

D. 35

Correct Answer: C

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 24 View Details

Examine the following Python function: ```python def mystery(n): count = 0 for i in range(1, n+1): j = i while j > 0: if j % 2 == 0: count += 1 j = j // 2 else: count += 2 j = j - 1 return count ``` What integer does `mystery(6)` return?

Correct A. 26

B. 24

C. 30

D. 28

Correct Answer: A

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

Question 25 View Details

A relational table stores information about university students with the following attributes: `StudentID, CourseCode, Instructor, Room, Time` Functional dependencies are: 1. $StudentID \rightarrow CourseCode$ 2. $CourseCode \rightarrow Instructor, Room, Time$ 3. $Instructor \rightarrow Room$ Determine the highest normal form the table satisfies. If it is not in Third Normal Form, provide a lossless‑decomposition into tables that are in 3NF.

A. The table is in 2NF only. A 3NF decomposition is: StudentCourse(StudentID, CourseCode) CourseInstructor(CourseCode, Instructor) InstructorRoom(Instructor, Room, Time)

Correct B. The table is in 2NF only. A 3NF decomposition is: StudentCourse(StudentID, CourseCode) CourseInstructorTime(CourseCode, Instructor, Time) InstructorRoom(Instructor, Room)

C. The table is in 3NF. No further decomposition is needed.

D. The table is in 1NF only. A 3NF decomposition is: StudentCourse(StudentID, CourseCode, Instructor) CourseTime(CourseCode, Time) InstructorRoom(Instructor, Room)

Correct Answer: B

Want to see the full step-by-step solution? Unlock AI Explanation & Analytics

gce model questions vol1 2024 computer_studies | Objective

Master the Exam!

Help others prepare! Share this practice hub: