Practice neco computer_studies 2023 Past Questions

Question 1 View Details

A spreadsheet records the following sales data (Units Sold and Unit Price in naira): Row 1: 120 units at 1 500 ₦; Row 2: 85 units at 2 400 ₦; Row 3: 200 units at 950 ₦; Row 4: 60 units at 3 200 ₦. The commission policy is: \(5\%\) of the first \(200{,}000\) ₦ of total sales, and \(7\%\) of any amount above \(200{,}000\) ₦. The total commission earned is to be written in words in a Word document where each page can contain at most 2 500 characters. The written commission occupies 45 characters for every full or partial thousand naira. How many pages are required for the document?

A. 0

Correct B. 1

C. 2

D. 3

Correct Answer: B

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

Question 2 View Details

In a spreadsheet the start date of a project is entered as 12 March 2024. Using a formula that adds \(45\) working days (Monday-Friday) while excluding the public holidays 1 May 2024, 15 May 2024 and 1 June 2024, the resulting date is to be placed in the header of a Word document. The header occupies 28 characters on each page. The body of the document contains 12 340 characters. Each page can hold 2 800 characters of body text in addition to the header. How many pages will the printed document have?

A. 6

B. 8

C. 4

Correct D. 5

Correct Answer: D

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

Question 3 View Details

A school surveyed 200 students about their preferred operating system. The results are: Form 1 - Windows 30, macOS 10, Linux 5; Form 2 - Windows 40, macOS 12, Linux 8; Form 3 - Windows 55, macOS 15, Linux 25. If a student is selected at random from the whole school and it is known that the student does not use Windows, what is the probability that the student uses Linux? Give your answer as a decimal rounded to three decimal places.

Correct A. 0.507

B. 0.467

C. 0.190

D. 0.543

Correct Answer: A

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

Question 4 View Details

Software package A depends on packages B and C. Package B depends on D. Package C depends on D and E. Package E depends on F. Packages D and F have no further dependencies. If a user installs package A, how many distinct packages (including A) must be installed to satisfy all dependencies?

A. 8

B. 5

C. 7

Correct D. 6

Correct Answer: D

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

Question 5 View Details

An organisation has been allocated the IPv4 address block \(192.168.64.0/20\). It needs subnets that can accommodate at most 500 usable hosts each. Determine the subnet mask to use, the total number of such subnets that can be created, and give the first usable IP address of the third subnet (counting subnets from the start of the block). Provide only the first usable IP address of the third subnet.

A. 192.168.66.1

B. 192.168.68.2

C. 192.168.70.1

Correct D. 192.168.68.1

Correct Answer: D

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

Question 6 View Details

An instructor uses a spreadsheet to compute final grades. The spreadsheet has four assessment columns: Test 1 (out of 20 marks), Test 2 (out of 30 marks), Project (out of 25 marks) and Exam (out of 50 marks). The overall grade (out of 100) is calculated with the formula \( \text{Grade}= \frac{\text{Test1}}{20}\times15 + \frac{\text{Test2}}{30}\times20 + \frac{\text{Project}}{25}\times25 + \frac{\text{Exam}}{50}\times40 \). Student A obtained 16 in Test 1, 24 in Test 2, 20 in the Project and 42 in the Exam. The teacher will generate report cards using a Word mail‑merge where each page can contain at most 4 student records. If the class has 57 students, how many pages are required to print all report cards?

A. 13

Correct B. 15

C. 16

D. 14

Correct Answer: B

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

Question 7 View Details

An IT manager evaluates two assets for security risk.\n- Asset A is valued at ₦200,000. The likelihood of a malware attack on it is 0.4 and the impact factor is 0.7.\n- Asset B is valued at ₦90,000. The likelihood of a data‑breach attack on it is 0.15 and the impact factor is 0.8.\nRisk is calculated as \( \text{Risk}= \text{Likelihood}\times(\text{Value}\times\text{Impact factor}) \).\nIf a risk greater than ₦30,000 requires the implementation of "encryption", otherwise "antivirus" is sufficient, which security control should be applied?

Correct A. encryption

B. firewall

C. antivirus

D. intrusion detection

Correct Answer: A

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

Question 8 View Details

Consider the following HTML element and CSS rules.\nHTML: Sample text\nCSS:\n1. p { color: blue; }\n2. .highlight { color: green; }\n3. #intro { color: red; }\n(a) What is the final text colour of the paragraph as rendered by the browser?\n(b) If the element is modified to include an inline style attribute: Sample text, what colour will now be displayed? Provide the two colours in order, separated by a comma.

Correct A. red, orange

B. green, orange

C. red, red

D. blue, orange

Correct Answer: A

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

Question 9 View Details

Which computer hardware component is primarily responsible for temporarily storing data that the CPU needs to access quickly while programs are running?

A. CPU

B. ROM

Correct C. RAM

D. Hard Drive

Correct Answer: C

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

Question 10 View Details

In a star network a central switch connects eight computers. The cable lengths from each computer to the switch are: 5 m, 7 m, 6 m, 8 m, 5 m, 9 m, 4 m and 6 m.\nWhat total length of cable is required to connect all computers, and what length should be purchased if a 10 % extra backup cable is added? Give the final length in metres, rounded to the nearest whole number.

A. 50

B. 56

Correct C. 55

D. 54

Correct Answer: C

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

Question 11 View Details

In a spreadsheet, cells A2:A6 contain quantities 12, 7, 15, 9, 20 respectively and cells B2:B6 contain unit prices 250, 340, 180, 410, 150 respectively. Column C computes the total price for each row as (C = A \times B). Column D applies a discount using the formula (D = \text{IF}(C>3000,\;0.9\times C,\;C)\). What is the sum of the values in D2:D6?

Correct A. 14401

B. 13293

C. 13801

D. 14770

Correct Answer: A

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

Question 12 View Details

Consider the following Python function: ```python def process(nums): total = 0 i = 0 while i < len(nums): if nums[i] % 2 == 0: total += nums[i] else: total -= nums[i] if total > 50: total = total // 2 if total < 0: total = 0 i += 1 return total ``` If `nums = [12, 7, 9, 14, 5, 20]`, what integer value does `process(nums)` return?

A. 33

Correct B. 29

C. 25

D. 0

Correct Answer: B

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

Question 13 View Details

A survey of 30 students recorded the number of hours they used a computer per week, grouped as follows: 0‑2 hrs: 5 students, 3‑5 hrs: 12 students, 6‑8 hrs: 9 students, 9‑11 hrs: 4 students. What is the minimum number of hours a student must have used a computer per week to be in the top 25 % of usage?

A. 5

B. 9

Correct C. 6

D. 7

Correct Answer: C

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

Question 14 View Details

In which year was the IBM PC (model 5150), the first commercially successful personal computer, introduced to the market?

A. 1983

B. 1985

C. 1979

Correct D. 1981

Correct Answer: D

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

Question 15 View Details

A computer system has a two‑level memory hierarchy. The L1 cache has an access time of 2 ns and a hit rate of 0.90. The L2 cache has an access time of 10 ns and a hit rate of 0.95 for accesses that miss in L1. Main memory access time is 80 ns. Using the formula \(AMAT = t_{L1} + (1-h_{L1})\times[t_{L2} + (1-h_{L2})\times t_{M}]\), calculate the average memory access time (AMAT) in nanoseconds, rounded to one decimal place.

A. 4.2

Correct B. 3.4

C. 2.8

D. 5.0

Correct Answer: B

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

Question 16 View Details

In which year was the ENIAC first publicly demonstrated?

A. 1945

B. 1947

Correct C. 1946

D. 1950

Correct Answer: C

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

Question 17 View Details

Consider the following HTML element and CSS rules applied in the order shown: HTML: Sample text CSS: 1) p { background-color: yellow; } 2) .note { background-color: green; } 3) #intro { background-color: blue; } 4) p.note { background-color: red; } 5) #intro.note { background-color: orange; } What is the final background colour of the paragraph when the page is rendered?

Correct A. orange

B. blue

C. green

D. red

Correct Answer: A

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

Question 18 View Details

A webpage contains the following resources: - Five images, each originally 120 KB. Three are saved as JPEG with a 30 % size reduction, and two are saved as PNG with a 20 % size reduction. - A CSS file originally 45 KB, minified to 30 KB. - A JavaScript file originally 80 KB, minified to 55 KB. - The HTML document is 20 KB. The browser caches images for 30 days and caches the CSS and JavaScript files for 7 days. A user visits the page once per day for a 30‑day month. On the first day all resources are fetched; on subsequent days only resources that are no longer cached are fetched. Calculate the total amount of data transferred over the month, expressed in megabytes (MB) to two decimal places.

A. 1.57 MB

B. 1.31 MB

Correct C. 1.43 MB

D. 1.24 MB

Correct Answer: C

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

Question 19 View Details

Consider the following Python code: ```python x = 0 for i in range(1, 6): for j in range(1, i+1): if (i*j) % 3 == 0: x += i - j else: x += j - i ``` After the loops finish, what is the final value stored in variable `x`?

A. -10

B. -6

C. 8

Correct D. -8

Correct Answer: D

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

Question 20 View Details

A company evaluates three security threats using a risk matrix. Likelihood and impact are rated as Low = 1, Medium = 2, High = 3. The risk score for a threat is calculated as: \[\text{Risk Score}=\text{Likelihood}\times\text{Impact}\] The threats are: - Threat A: Likelihood = High, Impact = Medium\n- Threat B: Likelihood = Medium, Impact = High\n- Threat C: Likelihood = Low, Impact = Low\nThe company can implement a security control that reduces the likelihood of any one threat by one level (e.g., High→Medium) at a cost of 2 units. With a budget of 2 units, only one threat can be treated. Which threat should be prioritized to achieve the greatest reduction in total risk score? Provide the name of the threat (A, B, or C).

A. D

B. A

Correct C. B

D. C

Correct Answer: C

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

Question 21 View Details

Consider the following Python code: ```python x = 0 for i in range(1, 7): for j in range(1, i+1): if (i*j) % 3 == 0: x += i - j else: x += j - i ``` What is the final value of the variable \(x\) after the loops complete?

A. 5

Correct B. 7

C. 9

D. 12

Correct Answer: B

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

Question 22 View Details

An 8‑bit signed integer is stored in two's‑complement form. The value \(-45\) is represented, then a left circular shift of three bits is performed on the bit pattern. What decimal value does the resulting bit pattern represent when interpreted again as an 8‑bit two's‑complement integer?

Correct A. -98

B. 58

C. -70

D. -126

Correct Answer: A

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

Question 23 View Details

A computer system draws current from a 12 V rail as follows: CPU requires 5 A, and a cooling fan requires 0.5 A. To protect the circuit a fuse is chosen with a 20 % safety margin above the maximum expected current. Standard fuse ratings are 5 A, 7 A, 10 A, etc. What is the minimum standard fuse rating (in amperes) that should be used on the 12 V rail?

A. 8

Correct B. 7

C. 5

D. 6

Correct Answer: B

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

Question 24 View Details

Given the following pseudocode, where each statement inside the innermost loop takes constant time, determine the time‑complexity in Big‑O notation as a function of \(n\).\n\n``` for i = 1 to n: for j = 1 to i: for k = 1 to n step i: do constant‑time work ```

A. O(n^{2} \log n)

B. O(n^{3})

Correct C. O(n^{2})

D. O(n \log n)

Correct Answer: C

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

Question 25 View Details

The following Python function is defined: ```python def f(n): if n <= 1: return 1 else: return f(n-1) + 2*f(n-2) ``` What value is printed by the statement `print(f(5))`?

Correct A. 21

B. 23

C. 27

D. 19

Correct Answer: A

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

neco 2023 computer_studies | Objective

Master the Exam!

Help others prepare! Share this practice hub: