Neco 2018 Computer Studies Question 4

Practice essay / theory question 4 from the 2018 Neco Computer Studies examination. This question covers Data and Information .

Neco 2018 Computer Studies Essay / Theory
Topic: Data and Information
Question 4 NECO • 2018 • COMPUTER_STUDIES • essay

The table below shows the number of units of product X sold by Alpha Enterprises in each month of 2023.

Question Parts

( a )
Calculate the following for the monthly sales data: (i) Total units sold in the year (ii) Mean (average) monthly sales (iii) Median monthly sales (iv) Mode of the monthly sales, if any (v) Range of monthly sales
( b )
Compare the performance of the first half of the year (January–June) with the second half (July–December). Determine the percentage increase in total sales from the first half to the second half.
( c )
Suggest the most appropriate type of graph to display the monthly sales trend and briefly explain why it is suitable.
( d )
If the company wishes to store this sales data in a database, identify two suitable data types for the ‘Month’ and ‘Units Sold’ fields, and describe one method of ensuring data integrity for the ‘Units Sold’ entries.

Detailed Solution & Marking Scheme

Get the step-by-step solution, key points required by examiners and detailed marking guidance through the Edcrib AI Tutor.

Reveal Answer

About This Question

This is Neco 2018 Computer Studies Question 4. It is one of the essay questions from the 2018 Neco Computer Studies examination.

The question covers Data and Information .

View More Neco 2018 Computer Studies Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support