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

A data bus that is capable of transferring 8 bytes of data at once can be rated as?   

In Figure 1, the value of Z when X = 1 and Y=0 is?     

In Figure 1, the value of Z when X = 1 and Y=0 is?   

which of the following logic operations would select a record when at least one condition is satisfied?        

Handwritten letters, typeset documents or printout Characters can be read into the computer by?       

Arrange the following inventions in chronological order.

I. Slide Rule ll. Pascaline llI. Analytical Engine IV. Difference Engine

Pascal’s calculating machine was useful in?    

Under classification by data representation. computers can be?      

Choose the incorrect statement about microcomputers?   

The equivalent of the decimal number 89 in base 4 is?    

The communication of knowledge, concepts and ideas is referred to as?    

Which of the following is not a step involved in data conversion?

As a database administrator for a company, create a table named tbl-Employee in a database application package containing the fields:

“Employee Name”, “Department”, “Assumption Date”, Address and “Designation”.

(a) Enter the data as shown in the table tbl-Employee

tbl-Employee

(b)Sort the data using the Assumption date from oldest to newest.

(c) Create a report in tabular, landscape using the tbl-Employee table.

(d) Insert your full name and index number as a label on the report.

(e) Save the report as rpt-Employee.

(f) Print your work and submit to the supervisor.

Use a spreadsheet application to do the following. (a) In cell A1, type “My One Week Expenses On Five items”.

(b) In row 2, type column-by-column the following: “ITEM”, 1ST DAY, “2ND DAY, “3RD  DAY”, *4TH DAY, “5THDAY”, “6TH DAY” and “7TH DAY”.

(c) In column A, starting from A3 to A7, List the items you spent money on.

(d) Enter the amount spent on each item for each day in their respective columns.

Note: select your own items and the amount spent.

(e) In cells 12 and A8. type “TOTAL N”.

(f) Using formula/function compute the total expenses for each day and for each item.

(g) Create borders around the table.

(h) Insert a footer and type in your full name and index number. (i) Below the table, type in the formula that was used:

(i) in cell 18: (ii) for summing from B3 to H3.

Note: Enclose your formula in quotes ave your work with your full name in the folder created on the desktop.

(k) Print your work and submit to the supervisor.

Using a word Processing application package, create a vising card for a system administrator of a software company using the following specifications:

(a) Size of the card is 3.5″ x 2″, (b) Office and Residential Address separated by a line; (C) the card should be copied m three places on the same page: (d) note that.

(i) the background colour must be grey scale: (ii) the card should be in shadow style, (iii) titlte “Visitor”

Uppercase

Highlight-gray-25%

Font size – 10 pt.

Font type – Georgia:

(iv) Office Address and Residential Address –  1.15 spacing

Font Type-Cambria

Font Size – 7 pt.

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

(f) Save your work with your full name in the folder created on the desktop.

(g) Print your work and submit to the Supervisor.

(a)(i) Define the term encryption. (ii) Tick two authentication techniques involved in security measure from Table 1.

Table 1

  (ii) Outline two features of data encryption. (b) While exchanging data with a friend through your mobile phone, you observed that it took a longer time than usual. Outline four factors that may be responsible for the delay in the data transfer.

(a) (i) Identify Figure 1 above. (ii) Name the parts labeled I, J, K, and L in Figure 1

(b)(i) Define the documentation stage in the Program Development Life Cycle. (ii) List three characteristics of a good computer program.

(a) Explain the following terms: (i) storage device; (ii) virtual memory.

(b) Two storage devices have capacities 2KB and 2MB respectively. (i) Calculate the number of bits that each of 2KB and 2MB can hold. 2 KB: 2 MB

(i) Putting the two storage together, calculate the total capacity in bytes.

(a) A musician intends to record music on a storage medium. List four ways that the music file can organized in the storage medium.

(b) State two basic operations on computer file. (c) Explain the following computer terms: (i) file (ii) re cord

(a) i() What is firewall? (ii) List two methods used in protecting the computer system.

(b) Explain the following stages of the System Development Life Cycle: (i) feasibility study; (ii) design; (iii) maintenance.

Password reset disk should be created?