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

using a graphic application software, create a student identity card with the heading as “CITY COMPUTER COLLEGE – NIGERIA”

(a) Size of the card is 31/2″ x 11/2″

(b) Insert “flyer pagoda” or any other graphic from the template as logo beside the heading.

(c) Format the card using the following:

background fill – 20% black; heading font type – Bernard MT Condensed, size 14 (ii) pt, colour white

(iii) write the statement, “this card identities” below the heading using Bookman Old style, 8 pt and in italics;

(iv) write the statements below under name:
Name

Admission Number – Font: Times New Roman

Year of Admission     Size: 11 pt

Signature

Line – Hairline

(d) Print and submit.  (e) Save file with your full name in the folder created der Name:

As the account clerk of an organisation, you are to prepare the table as shown below using a spreadsheet application:

(a) Copy and paste table title “Workers’ Wages” on the same sheet. Format this new table as follows:
(i) Title the new table as SALARIES
(ii) Sort the table in alphabetical order
(iii) Calculate average wage of workers per day

(iv) Calculate the max and min wages paid to the workers from the SALARIES

(b) Insert a bar chart for data in 2a

(c) Save workbook with your full name in the folder created

(d) Print and submit 

Using a word processing package, create a college timetable format titled “COLLEGE TIME TABLE” for 7 subjects (English, Maths, Biology, Chemistry, Physics, Civic Education, and Computer Studies), for 5 days with a minimum of 45 minutes duration. Lunchtime is 40 minutes, and lessons in the college have a minimum of 5 periods/week.

(a) Format the  “COLLEGE TIME TABLE” using the following:
(i) The title of the table should be aligned center, bold, and underlined;
(ii) Use table design style of any type
(iii) Days of the week should be bold
(b) Save your work with your full name in the folder created.
(c) print and submit your work

(a) Convert 1011011\(_2\) to its hexadecimal equivalent 

(b) State one difference a hacker and a scammer
(c) identify the parts labeled A, B, C and D on the keyboard shown below

(a) Convert 1011011\(_2\) to its hexadecimal equivalent 

(b) State one difference a hacker and a scammer
(c) identify the parts labeled A, B, C and D on the keyboard shown below

(a) In a tabular form, state two differences between random access memory and read only memory

(b) State four characteristics of windows operating system environment.

(c) list two examples of utility programs

(a) Match each of the following computing devices.

State one difference between star and bus topologies

(b) List four common network devices.
(c) Write the acronyms below in full

HTML, HTTP, ISP, SMTP.

(a) What are input devices?

(b) list two input devices
(c) State two uses of logic gates
(d) Draw and label the logic gate symbol for;
(i) OR gate (ii) AND gate

Opening an already existing sequential file in output (O) mode will lead to?

A student mistakenly pressed the F5 key on keyboard while browsing on the internet. This will lead to?

Arrange in hierarchical order by date the following inventions:

I. – Census machine; Il. – Abacus; lll. – Slide rule; IV.- Difference engine.

The modifier keys on the computer keyboard comprises of?      

Converting 4B7\(_{hexadecimal}\) to binary is?     

The first three steps to open an email account include:

I. – Click on create my account; II. – Go to home page; llI – Click create new account.      

Which of the following statements is true for a circuit Switching communication system?     

Which of the columns needed to be adjusted to accommodate the cells contents?

.

Use the MS Excel table below to answer questions 42 and43

The formula used to compute the TOTAL VALUE in cell D7 is?    

Which of the following function keys can be used to run slide show in a PowerPoint presentation?     

Which of the following tasks is accomplished by using bookmarks? To       

The flowchart ♦ symbol represents?