45 questions. Try each one, then open the answer to check yourself and read the explanation.
Which of the following persons invented the punch card machine?
Answer: D (Dr. Herman Hollerith)
Herman Hollerith built the punched-card tabulating machine used for the 1890 US census.
The operation of checking input data against specified criteria is referred to as
Answer: B (data validation.)
Validation checks that input obeys set rules (range, type, format); verification only checks it was copied correctly.
Which of the following is not a source of data collection?
Answer: D (Classification)
Observation, interviews and questionnaires gather data; classification is a way of organising data already collected.
Which of the following is true about digital computers?
Answer: C (They represent numbers through a string of binary digits)
Digital computers work with discrete binary digits (0s and 1s); continuous measurement describes analogue computers.
Facebook, Twitter and WhatsApp are examples of
Answer: A (social media.)
Facebook, Twitter and WhatsApp are social media platforms where people share content and chat.
Which of the following is not an application of computers?
Answer: A (Bank notes counter)
POS terminals, ATMs and traffic light controllers are computer-controlled systems; a bank note counter is a simple counting machine.
Which of the following is a secondary storage device?
Answer: C (Floppy disk)
A floppy disk stores data permanently outside main memory; RAM and EPROM are primary memory.
Information analysis procedures include the following except
Answer: A (skin and scan.)
Analysing information means finding relationships, interpreting, concluding and spotting bias; skimming and scanning are reading techniques, not analysis.
The advantages of electronic data processing include the following except
Answer: B (hacking.)
Hacking is a threat to computer systems, not an advantage of electronic data processing.
Which of the following is not a transmission medium?
Answer: D (Modem)
A modem is a device that converts signals; cables and wireless links are the media that carry them.
Information transmission by television is classified as
Answer: A (multimedia transmission.)
Television sends pictures, sound and text together, so it is multimedia transmission.
Which of the following are the basic components of a computer network? I. A minimum of two computers II. Printers III. Network interface card
Answer: B (I and III only)
A network needs at least two computers and a way to connect them, such as a network interface card; a printer is optional.
Social networking does not promote
Answer: D (e-payment.)
Social networks help people publicise themselves, grow businesses and sell online, but payments are handled by banking and payment services.
Companies that provide internet access are referred to as
Answer: C (internet service providers.)
Internet Service Providers (ISPs) sell access to the internet.
While typing a MS word document, Akin inserted footer in the document in order to
Answer: C (insert page numbers.)
A footer holds text that repeats at the bottom of every page, most often the page numbers. Inserting a footer is the usual way to number the pages of a Word document.
The spreadsheets symbol used to convert a number to a label is
Answer: D (apostrophe sign ( ‘ ))
Typing an apostrophe before a number makes the spreadsheet treat it as text (a label).
In spreadsheets, data would not be accepted into a cell by pressing the
Answer: C (Esc key.)
Enter, Tab and the arrow keys all confirm an entry; Esc cancels it, so the data is not accepted.
A field in a database table is also known as
Answer: C (attribute.)
A field (column) describes one property of a record, so it is called an attribute.
The property of a systems software that enables it to execute more than one program at a time is referred to as
Answer: C (multitasking.)
Multitasking lets the operating system run several programs at the same time.
Which of these operations would not close MS word application?
Answer: D (Selecting close from the file menu drop down dialogue box)
Close on the File menu closes only the current document; Word itself stays open.
The feature in a database application that acts as an interface between the user and the database is called a
Answer: C (form)
A form is the screen through which users enter and view data in a database.
Planning and creating websites are stages in
Answer: C (web design.)
Web design is the planning and building of websites.
The type of data entered into a table in database follow a set of rules known as
Answer: D (constraints.)
Constraints are the rules a database applies to the data allowed in a table, such as NOT NULL or UNIQUE.
Which of the following drawing tools would create special effects on texts?
Answer: D (Word Art)
WordArt turns text into decorative styled text with effects such as shadows and curves.
The study of the effect of interaction between the computer and human users is referred to as computer
Answer: A (ergonomy.)
Ergonomics studies how people and computers interact so that work is safe and comfortable.
In MS PowerPoint, the action of holding down the left mouse key and moving the mouse around the slide would
Answer: B (drag an item.)
Holding the left button down while moving the mouse is dragging.
A file kept in case of an accident or natural disaster is called
Answer: C (back-up.)
A back-up file is a copy kept so data can be restored after loss.
Which of the following is not a preventive maintenance measure?
Answer: D (Data recovery)
Data recovery is done after a loss has happened, so it is corrective, not preventive.
Which of the following is not a safety equipment in a computer laboratory?
Answer: B (Metal detector)
Surge protectors, smoke detectors and fire extinguishers protect the lab; a metal detector is a security device.
Which of the following is not a computer professional?
Answer: D (File Manager)
Network administrators, webmasters and systems analysts are recognised computer professions; a file manager is a program.
The following are destructive softwares except
Answer: A (drivers.)
Drivers are useful programs that let the computer use hardware; the others are malware.
The type of file organization in a DVD-ROM is
Answer: A (direct access.)
A DVD-ROM lets the drive jump straight to any file, so it uses direct (random) access.
Which of these measures would not secure data in a database?
Answer: B (Data integration)
Data integration combines data from different sources; it does not protect data.
The diagram above illustrates the relationship between two tables in a database. Use it to answer questions 35 and 36.
The student ID in Table II is referred to as
Answer: B (foreign key.)
Student ID in Table II refers to the primary key of Table I, which makes it a foreign key.
The diagram above illustrates the relationship between two tables in a database.
What type of relationship exists between Tables I and II?
Answer: D (One to many)
One student in Table I can appear in many course records in Table II, a one-to-many relationship.
A program developed to protect the computer from malicious software is referred to as
Answer: C (antivirus.)
Antivirus software detects and removes malicious programs.
One of the advantages of a parallel database is
Answer: C (faster processing of data.)
A parallel database splits work across several processors, so queries run faster.
In a relational database management system, files are organized as relations and
Answer: C (tables.)
In a relational database data is stored in relations, which are tables of rows and columns.
The exchange of information over a network follow a set of rules called
Answer: D (protocols)
Protocols are the agreed rules computers follow to exchange data, e.g. TCP/IP.
Paper 2, Section A
(a) (i) Define an operating system. (ii) State two functions of an operating system (iii) List two differences between an operating system and an application system software
(b) Starting from the Save As dialogue box, outline the steps involved in paswording a document in a word processing package.
(a)(i) An operating system is the system software that controls the computer's hardware and software resources and provides a platform on which other programs run.
(ii) Any two: manages memory; manages the processor (scheduling tasks); manages files and storage; controls input/output devices; provides the user interface; provides security (user accounts, passwords).
(iii) Any two: the OS controls the computer while application software does a user task (e.g. word processing); the OS is needed for the computer to work, applications are optional; the OS is loaded first at boot, applications run on top of it; the OS works mostly without user involvement, applications are used directly by the user.
(b) In the Save As dialogue box click Tools (or Options) → General Options; type a password to open (and/or modify); click OK; retype the password to confirm and click OK; type a file name and click Save.
Give definitions in one sentence and make each difference a clear contrast.
Paper 2, Section A
(a) Define the following: (i) Database: (ii) Database Management system
(b) Mention three functions of a database management system.
(c) Mention two ways through which data can be destroyed
(d) State three precautionary measures to prevent data loss
(a)(i) A database is an organised collection of related data stored so that it can be easily accessed, managed and updated.
(ii) A DBMS is software used to create, store, retrieve, update and control access to data in a database (e.g. MS Access, Oracle, MySQL).
(b) Any three: data definition (creating/changing table structures); data storage and retrieval (queries); updating data (insert, modify, delete); security and access control; backup and recovery; controlling concurrent use by many users; maintaining data integrity.
(c) Any two: virus attack; accidental deletion; hardware failure or disk crash; power failure; fire, flood or other disaster; theft or sabotage/hacking.
(d) Any three: keep regular back-ups (off-site); install and update antivirus software; use passwords/access control; use a UPS and surge protectors; train users and handle storage media carefully.
Definitions first, then list the required number of points clearly.
Paper 2, Section A
(a) (i) Define application package (ii) State one use each of any four application packages.
(b) List two benefits of a presentation package
(c) Outline three guideline for creating a good MS Power Point Presentation
(a)(i) An application package is a ready-made program (or set of programs) written to carry out a particular user task, e.g. word processing.
(ii) Any four: word processor (MS Word) – typing and formatting documents; spreadsheet (Excel) – calculations, results and budgets; database (Access) – storing and retrieving records; presentation (PowerPoint) – making slide shows; graphics (CorelDraw) – designing cards and posters; desktop publishing (Publisher) – newsletters and flyers.
(b) Any two: makes lessons/talks more interesting with pictures, sound and animation; helps the audience understand and remember; slides are easy to edit and reuse; can be printed as handouts or shown on a projector.
(c) Any three: keep text short (few bullet points per slide); use a large readable font; use contrasting colours for text and background; use a consistent design/theme; use pictures and charts where helpful; avoid too many animations and sound effects; check spelling.
Pair each package with a real use, and give guidelines about content and design, not menu steps.
Paper 2, Section A
(a) Define: (i) Data security (ii) Data risk assessment
(b) (i) Explain the term access control in database security
(ii) List two access control methods in database security
(c) State three roles of a database administrator.
(a)(i) Data security is the protection of data from unauthorised access, change, corruption or loss.
(ii) Data risk assessment is identifying the threats to an organisation's data, judging how likely and how harmful they are, and deciding controls to reduce them.
(b)(i) Access control decides who can use the database and what each user may do (view, add, change, delete), usually after the user is identified and authenticated.
(ii) Any two: user names and passwords; role-based access (privileges/permissions); discretionary access control; mandatory access control; biometrics or access cards.
(c) Any three: designing and creating the database; granting and controlling user access; backing up and recovering data; monitoring and tuning performance; installing and upgrading the DBMS; keeping data secure and consistent; supporting users.
Define each term in one sentence, then give clear separate points.
Paper 2, Section B: Test of Practicals
Given an internet connected computer, outline a step by step procedure for carrying out the following operations:
(a) How to log on to www.mybooks.com and obtain the prices of book W, X, Y, Z and M;
(b) How to tabulate the prices in a worksheet, showing the prices in dollars and the naira equivalent, for each book and save the workbook as “Prices of Books”. Assume that the prices of the books are given in dollars, [ use $1,00 = N120.00];
(c) How to send the workbook in 5(b) as an attachment to your father's email address (myfather@yahoo.com) with the subject “Price of Books”.
(a) Open a web browser (e.g. Chrome, Firefox); type www.mybooks.com in the address bar and press Enter; search or browse for books W, X, Y, Z and M; note (or copy) the price of each.
(b) Open Excel; in A1:C1 type headings Book, Price ($), Price (N); type the book names in A2:A6 and the dollar prices in B2:B6; in C2 type =B2*120 and copy the formula down to C6; format the cells; click File → Save As, type Prices of Books and click Save.
(c) Open the browser and sign in to your e-mail account; click Compose; type myfather@yahoo.com in the To box; type Price of Books in the Subject box; click Attach, browse to Prices of Books and click Open; wait for the upload, then click Send.
Write each step in order, naming the exact button, menu or formula.
Paper 2, Section B: Test of Practicals
A student was asked to record the type of vehicle that entered the school compound the school's main gate on a Monday morning. The passage below is an excerpt from the student's report on the assignment. “Report on the vehicular traffic at the gate on Monday. 1. Introduction: I was directed by the school principal to sit at the main gate and record type and number of vehicles that passed through the gate on Monday morning. 2. Observation: I arrived the gate at about 8:00 am and left at 12 noon. During this period, I made the following observation: Car, bus, bus, car, car, lorry, motorcycle. bus, bus, car, car, car, lorry, motorcycle, tricycle, motorcycle, car, tricycle, motorcycle, bus, bus.”
(a) Beginning from the desktop, outline a step by step procedure of how to type the passage in MS word, using A4 paper size and potrait orientation.
(b) State the procedure for carrying out the following operations in the passgage: (i) Begin the second and third sentences in new paragraphs; (ii) Write the first sentence in capital letters, undeline it and bold it; (iii) Begin the first letter of a sentence with capital letters; (iv) Represent the student's observation in a table with three columns under the headings; Serial Number, Type of vehicle, Number of vehicle; (v) Merge the first two cells of the last row of the table, type “Total” and give the total number of vehiclesobserved in the column for number of vehicles; (vi) Save the document with the name “Vehicular traffic”; (vi) Print the document.
(a) Click Start → All Programs → Microsoft Office → Microsoft Word (or double-click the Word icon on the desktop); click Page Layout → Size → A4; click Orientation → Portrait; type the passage.
(b)(i) Click just before the second sentence and press Enter; do the same before the third sentence.
(ii) Select the first sentence; press Shift+F3 (or Home → Change Case → UPPERCASE); click B (Bold) and U (Underline).
(iii) Select the text and use Change Case → Sentence case (or retype the first letter with Shift held).
(iv) Insert → Table → 3 columns and enough rows; type headings Serial Number, Type of vehicle, Number of vehicle; enter: 1 Car 7, 2 Bus 6, 3 Lorry 2, 4 Motorcycle 4, 5 Tricycle 2.
(v) Select the first two cells of the last row → right-click → Merge Cells; type Total; in the third cell type 21.
(vi) File → Save As → type Vehicular traffic → Save.
(vii) File → Print (Ctrl+P) → choose printer and number of copies → OK/Print.
Count each vehicle type carefully from the list before filling the table: car 7, bus 6, lorry 2, motorcycle 4, tricycle 2, total 21.