Computer Studies JAMB, WAEC, NECO AND NABTEB Official Past Questions

(a) Using the star shape tool in CorelDraw, draw a 30 pts star of diameter 18 cm and fill it with grey colour.

(b) Use sharpness tool to adjust the corner sharpness of the star by 25 pts.

(c) Place three circles; circle 1, circle 2 and circle 3 with diameters 10 am, 7.6 cm and 5.4 cm respectively inside the star.

(d) Use Text tool to type ARISE AND SHINE and place it in-between circle 2 and 3.

(e) Fill cicle2 with lemon colour and circle 3 with white colour.

(f) Place five stars inside circle 3.

(g) Group your drawing.

(h) Type in your full name as a footer.

(i) Save and print your work.

(j) Submit your printout to the supervisor.

A supermarket listed ten items on sale.
Use Microsoft Excel application to create an inventory for the supermarket.
(a) Type in the following headings from cell A1 to F1 respectively.
SN, Goods Cost Price, Selling Price, Gain/Loss and Target.

(b) Populate the table by supplying ten different items sold in a supermarket. In column A, fill in the numbers 1 to 10 from cells A2 to A11. Similarly, list the ten items from cells B2 to B11. Supply Cost Price and Selling Price from cell B2 to B11. Supply Cost Price and Selling Price from cells C2 to C11 and D2 to D11 respectively. Note that it is possible to have some selling prices lower than the cost price. Create borders around the table.

(c) Use formula or function to calculate; (i) the gain (if the selling price is higher than the cost price) or the loss (if the cost price is higher than the selling price) of each item from cells E2 to E11 
(ii) 110% of the cost price of each item from cells F2 to F11.

(d) Determine whether target is met or not by typing “target met” or “target not met” in cells H2 to H11 for each item.
Note that target is met when the selling price is 110% of the cost price or more otherwise target is not met.

(e) Insert a footer and type in your full name  and index number.

(f) Save your work in the folder created on the desktop using your full name as th file name.

(g) Print your work showing formulas and functions and submit to the supervisor. 
 

Use Microsoft Word application to reproduce the circles with lines R\(_{1}\), R\(_{2}\) and R\(_{3}\) as shown in Figure 1 and perform the following tasks.
(a) Lines R\(_{1}\), R\(_{2}\) and R\(_{3}\) should be of different length.
(b) Label R\(_{1}\), R\(_{2}\) and R\(_{3}\) should be of different fonts.
(c) You are provided with Table 1. Complete the table.

(d) Group the circles in Figure 1.
(e) Insert a text box and type in your full name as the file name 
(f) Insert a footer and type in your full name and index number
(g) Save your work in the folder created on the desktop using your full name as the file name.
(h) Print your work and submit to the supervisor.

Write a QBASIC program to grade any score entered from the keyboard as either “Poor” for a score that is below 50% or “Satisfactory” for a score that is equal to or above 50%. The program execution should stop as soon as a score that is less than zero is entered.

(a)(i) Define computer graphics.

(ii) List two applications of computer graphics in advertising.

(b) Give one use of the following computer graphics application tools;

(i) Interactive Fill Tool (ii) Texture Fill Tool (iii) Envelops Tool (iv) Extrude Tool 

(c) Name one Fill Tool in computer graphic application which is needed to (i) create a background that is faded from light blue to white (ii) fill an object with two colours that blend from one to another.

(a)(i) What is Universal Serial Bus (USB)?

(ii) State two benefits of using USB connection between a computer and another device.

(b) In Table 1, three storage devices are described, Use it to answer questions 3(b)(i) and 3(b)(ii).

(i) In column 2, name the storage device being described in column 1.

(ii) Show the category of storage device being described in column 1 by ticking in any of the column 3, 4 or 5

Perform the following conversions in the stated number bases;

(a) AB1\(_{16}\) to Octal system

(b) 1110111.101\(_2\) to Denary system 

(c) 507\(_2\) to Binary system.

(a) What are “Reports” in a database system?

(b) List four (4) ways in which Reports can be viewed in database management system.

(c) Outline the steps to prints a Report in MS Access.

The following actions are the effects of virus infection in a system except

A computer program that gathers information about a person or organization without their knowledge or consent  is known known as

Which of the following options is not a similarity between computer file and manual file? Both can 

The file access method shown in Figure 12 is called 

To prevent unforeseen data loss, a user must 

The binary number 0.1101 in decimal is 

Evaluate 10011\(_2\) – 1111\(_2\) 

A single character in an EBCDIC encoding system can be represented using 

The part of the computer system shown in Figure 11 is used to 

Changing the default settings or appearance of the Taskbar in windows by a user is known as 

The windows shortcut key for closing an active application is

The screen background where icons and windows are displayed is GUI is called 

What type of relationship can you deduce from the statement a department has many employees?