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

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?    

Which of the following charts does not display the X and Y axes?   

If you are given the contract, what would be your first step of action?        

Use the infomation belowto answer questions 42 and 43.

As a computer professional, you have just been con- tracted by a school to help them solve the problem they are facing in computing students’ results.

The school currently runs a manual system. Time and accuracy of the result are the major concerns.

What would you advise the school to do?     

The following are the guidelines for drawing flowcharts except that it?     

A logic gate contains three input variables. The total possible combination of the input variables is?      

Use the logic truth table in figure 3 to answer question
 

Given that X and Y are input variables while Z is the output. The truth table in figure 3 represents?

A  site engineer intends to acquire a computer system. What factors Will he consider if he must choose a notebook computer over a desktop computer?