You are provided with a computer system that has Microsoft PowerPoint application running . Outline the steps to be followed in performing the following tasks;
(a) Creating a four-slide presentation.
(b) Modifying the presentation to show the following on the footer of all slides except the title slide; A. Today’s date B. Slide number C. Your surname
(c) Inserting a picture saved in the picture folder of your computer hard drive on the second slide.
(d) Typing your name as the main title and personal profile as the subtitle.
(e) Making each slide to run for five seconds continuously until “Esc” key is pressed during slide show.
A Director gave a manuscript to the secretary for typesetting. The secretary is expected to provide the total number of words, lines of text, number of pages and number of paragraphs contained in the documents. After proofreading the printout, the Director effected certain corrections on the printout and instructed that the corrected version be saved with the filename “initial”.
(a) Outline the steps the secretary would take to display the numbers of words, lines of text, number of pages and number of paragraphs contained in the corrected version of the document.
(b) Highlight the steps the secretary would take to display the original and corrected versions of the screen for the Director to see at the same for comparison.
(c) List the three steps to secure the document with password in order to prevent unauthorized access to the document.
A school decides to harmonize the operation of its two campuses using a distributed database system as well as install air conditioners and uninterrupted power supply in the computer laboratory.
(a) State three (i) Importance of using distributed database (ii) disadvantages of using computer processing information in the school
(b) Give two reasons for installing the; (i) air conditioners (ii) uninterrupted power supply devices
(a) State the keyboard shortcut keys to;
(i) rotate an object in CorelDraw
(ii) position an object in CorelDraw
(iii) navigate to cell A1 in MS Excel worksheet
(b) Give one reason for including the plus sign (+) in the search text in a search engine.
(c) With the aid of diagrams, differentiate between LAN and WAN.
Ciroma Chukwuma Adekunle has just opened a computer business centre within a school environment.
(a) State three computer services that may be provided in the business center
(b) List three devices required in the business centre
(c) Give two applications software needed in the business centre.
(d) Outline two precautions that must be taken by Ciroma Chukwuma Adekunle to ensure the safety of this computer if he accepts documents in movable devices from his customers.
(a) What is a function in MS Excel?
(b) List two categories of functions in MS Excel.
(c) What is the cell referencing in MS Excel.
(d)(i) State two types of cell referencing in MS Excel.
(ii) Give one example of each type in 1(d)(i)
Figure 1 ABOVE depicts.
- A. a distributed database
- B. a parallel database
- C. an extranet
- D. an internet
Providing access control to a school is the responsibility of a
- A. database administrator
- B. programmer
- C. system administrator
- D. system analyst
A file organization that has reference which identifies a record in relation to other records is called…
- A. indexed file organization
- B. random file organization
- C. sequential file organization
- D. serial file organization
The file organisation method which allows records to be accessed in any sequence is
- A. Index
- B. random
- C. sequential
- D. serial
Which of the following database operations does not require a Data Manipulation Language?
- A. Modification of information
- B. Insertion of new information
- C. Deletion of information
- D. Creating of information
In the model; Furniture (Table, Chair, Wardrobe) Furniture is…
- A. a relation
- B. a schema
- C. a tuple
- D. an attribute
Which of the following software replicates itself without being executed by the user
- A. worm
- B. Trojan
- C. Plug-ins
- D. Driver
The following tools are used for protecting the computer against virus attack except
- A. Avast anti malware
- B. Kaspersky
- C. Norton
- D. Trojan horse
Responsibilities of a database administrator includes the following except performing
- A. database backup
- B. data recovery
- C. network maintenance
- D. user authentication
In order to protect a computer on the World Wide Web from throats, the user should
- A. Install the latest operating system version
- B. Install a single user antivirus software
- C. implement an internet security software
- D. deploy online transaction application
Any activity carried out to protect the user from hazards while using the computer is called
- A. computer ethics
- B. computer maintenance
- C. laboratory rules
- D. safety measures
One responsible way of using the computer is
- A. software piracy
- B. phishing
- C. pharming
- D. ethical hacking
One characteristics of a dirty mouse is that the mouse
- A. is not recognized by the system
- B. unmounts itself from the system
- C. pointer changes appearance
- D. pointer moves erratically
Which of the following substances is used for cleaning the mouse ball
- A. Distilled water
- B. Engine oil
- C. Isopropyl alcohol
- D. Kerosene
Graphics can be captured using the following devices except
- A. webcam
- B. scanners
- C. joystick
- D. digital camera