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

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?   

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

Which of the file organization methods can be accessed both randomly and sequentially?     

Effects of file insecurity include the following except?   

The following actions are sources of breaches in computing except?   

In BCD encoding system, 25, will be represented as?   

Multiply 101\(_2\) by 11\(_2\)       

A bit as used in computing in digital communication is?      

Which of the options labeled I to IV give two stages involved in booting?

I. Power On self test II. Loading of Operating System IIl. Loading of email IV. Power On Safe Mode

The disk operating system will label three hard drives as?     

 After several ‘save’ and ‘delete’ operations, there remain many scattered areas of data too small to be used productively. This describes?

Data that is copied from an application is stored in the?        

Which of the following is true when data maintained in MS Excel workbook is linked to a word document? The word document