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

Modern computers compared to earlier computers are?     

The Slide Rule is accurate to? 

Computers are classified using the following criteria except?   

Which of the following statements are true about computer? 

I.Constructed from electronic components. II. It has self regeneration capability.

III. It has facility for storage of data and programs.       IV.It has provision tor input and output of data.

The hexadecimal number 13, expressed as a binary here is?     

The map of Nigeria is an example of ?    

The personnel who deals with the computer and its management is called?       

INSTRUCTIONS: (a) Sort the table on SURNAME and FIRST NAME in ascending order.

(b) Delete the record for employee 279.

(c) Create a report from the table and name it SALARY. The header of the report should read “EMPLOYEE SALARY”.

(d) Format:

(i) the column headings of the report with font size 14pt and bold;

(ii) the other inputs with, font size 12pt.

(e) Apply border line.

(f) Insert your full name and index number.

(g) Print and submit to the supervisor

You have been tasked to give a presentation to an audience on the topic “Computer Networks”.

Use the 2 layout below to create slides using Microsoft PowerPoint.

(a) SLIDE 1

LOCAL AREA NETWORK

A computer network located on user’s premises

A network in which a set of devices are connected together for communication

SLIDE 2

WIDE AREA NETWORK

A network of geographically dispersed telecommunication devices

The network may be private or public-shared.

SLIDE 3

ADVANTAGES OF NETWORKS

(i) Resource sharing (ii) Enhanced connectivity (ii) Enhanced communication

SLIDE 4

DISADVANTAGES OF NETWORKS

(i) Security concerns (ii) Virus attacks (iii) Network failure

(b)

INSTRUCTIONS:

(i) The font size of the heading should be 36pt and bold, font style Calibri.

(ii) The font size of the text in the body should be 32pt, font style Calibri.

(iii) Apply bullet numbering where necessary.

(iv) Format the slides using any background of your choice

(v) Insert your full name and index number as footer.

(vi) Save your work as Networks and print all the sides on a single sheet.

(vii) Submit the printout to the supervisor.

1(a) The table below shows the scores of six students in computer studies at Top Hill High School. Use the font Times New Roman with size 12 pt in spreadsheet application to prepare the information given in the table.

Insert b:

(i) new column with the heading “Name” between the first and second columns;

(ii) title “Students’ Scores in Computer Studies” above the table.

(c) Beginning from the first cell under column heading “Name” to the sixth cell, type the following: Adedigba Eze, Balango Ngozi, Agbelero Cynthia, Okeowo Sulkite, Okonia Ifedola, and Umaru Edonk.

(d) If “W/score” stands for weighted score, calculate:

(i) weighted score for each term given that weighted score comprises 20%, 30%, and 50% of raw scores for first, second, and third terms respectively;

(ii) total weighted score for the three terms.

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

(f) Save with your index number in the folder created.

(g) Print and submit to the supervisor

(a)i) What is booting?

(i) State two differences between the types of booting.

(b) What is peripheral?

(c) Give one example each of (i) input device; (ii) output device; (iii) storage devices (iv) a component found inside the system unit.

(a) Define logic gate.

(b) Give one example each of: (i) standard logic gate; (ii) alternative logic gate.

(c) Using P and Q as inputs and R as output:

(i) draw the logic symbol for an XOR logic gate: (ii) construct the truth table for XOR logic gate.

(d) List two uses of a logic gate.

(a) What is: (i) an array; (ii) a syntax error?

(b) Write QBASIC program that will input multiples of Three between 1 and 20 into a one-dimensional array and display the output on the screen.

(c) Convert D5FA,, to binary.

(a) What is a register?

(b) List two types of register.

(c) State three functions of registers.

(d) Outline three differences between a register and main memory.

(a)i) Define the term computer system.

(i) List the major components of the computer system and give one example of each.

(b)(i) List two activities involved in transferring data into information. (i) Write the following acronyms in full:

(1) EDSAC (11) EDVAC

Which of the following computer files can be used for updating the master file?
 

The statement in QBASIC that is used to add data at the end of existing sequential file is?

Arrange the following spreadsheet window parts in a hierarchical order by size:
I. worksheet
II. cell
III. workbook
IV. Range

One megabyte is equivalent to?
 

The common features of formula and function in spread- sheet are:

-Entry is preceded by = or + symbol I.

– They have fixed formats

– They operate with cell addresses

– Their results are displayed.

Which of the following options is/are true? 

The uses of spreadsheet packages include:

1. -Preparing organisation’s logo;   II. – Performing sensitivity analysis; III, – Preparing reports for senior manage- ment; IV. – Preparation of profit forecasts.

Which of the following options is true?