Transcription
COMPUTERAPPLICATIONPACKAGESAyo C.KIkhu-Omoregbe N. AOsamor V. CEkong V. ERevised Edition
McKAY Educational seriesA Division of McKAY CONSULT47/57 Martins street,19th Floor, Great Nigeria House,Lagos.Copyright 2007C. K. AyoN. A. OmoregbeV. C. OsamorV. E. oo.comveekong@ieee.orgFirst published April 2005Revised edition August 2007ISBN 9780664912All Rights ReservedNo part of this publication may be reproduced, stored in retrieval systemor transmitted in any form or by any means, electronic, mechanical,photocopying, recording, or otherwise in any form without the priorwritten permission of the copyright owners.Designed, Printed and bound in Nigeria byMcKAY Educational seriesA Division of McKAY CONSULT.
PREFACEMore than ever before, Information Technology (IT) is known to be theprime driver for all businesses particularly in the 21st century. The role ofIT in all spheres of human endeavour, particularly its application toManagement Information System (MIS) cannot be undermined.Everybody depends on timely and accurate information, made available inan appropriate level for effective decision making.Information processing has ceased to be left solely under the purview ofIT specialists, today every knowledge worker performs one MIS functionor the other, either directly or indirectly by developing their own systemsor building queries to generate required reports.ABOUT THE BOOKInformation, being a common denominator in both IT and MIS, the bookwas written primarily to empower all knowledge workers with the neededskills to make optimal use of Microsoft (MS) Office suite of applicationsin their daily quest for information. The choice of MS office is based onthe fact that it is the most widely used application on microcomputers allover the world (over 80% of PC workers). It is therefore intended to servea very wide coverage.The chapters of the book are arranged to follow a logical order of thought,without any assumption of prior computer literacy skill for the reader.The topics covered include: The Computer System, Microsoft WindowsXP operating system, MS Word, MS Excel, MS Access, MS FrontPage,MS Outlook, MS PowerPoint and Internet connectivity. Each chapter hasa set of review questions designed to help the reader test her level ofunderstanding.Computer literacy, being a general demand foremployment at whatever level, the authors have no doubt that it will be anideal study/reference material for all classes of workers.Furthermore, it is part of the Vision of Covenant University to make thestudents market and competition driven before graduation. Therefore, thebook was written following the course content for the ComputerApplication course taken by all students of the university.
ACKNOWLEDGEMENTSThis book is a product of almost two years of hard work by some talentedmembers of staff of the department of computer and information sciencesof Covenant University.In reality, we have probably lost count of all valuable contributors. Tothis group of individuals, we want to express our heartfelt and deepestregards.Specifically, we want to appreciate the following eminent personalitiesparticularly: the Chancellor, Covenant University, Bishop (Dr) DavidOyedepo; the Vice Chancellor, Professor Aize Obayan; the immediate pastActing Vice Chancellor, Dr J. A Aremu; the Registrar, Dcn YemiNathaniel; all the Deans of colleges particularly the Dean college ofscience and technology, Professor T. S Ibiyemi for creating such a veryconducive atmosphere of learning and research in the university.Finally, we want to express our gratitude to the editors/reviewers of thebook for their invaluable contributions. We say thank you all.IT IS WELL.Ayo C. K. (Ph.D, MNCS, MCPN, MCP, CCNA)Ag. Head, Computer and Information SciencesCovenant University, OtaOgun State, Nigeria
CONTENTSPrefaceAcknowledgementAbout the BookiiiiiivCHAPTER ONE INTRODUCTION1.1Computer Hardware1.2Computer software1.3Understanding computer memory1.4Preparing to use the computer1.5Caring for your computer1.6ErgonomicsReview questions1123791011CHAPTER TWOMS WINDOWS2.1Windows XP2.2Components of a window2.3Menus2.4Mouse basics2.5Start menu2.6Customizing windows desktop2.7Working with programs2.8Organizing files and folders in windows2.9Windows keyboard shortcuts2.10 Logging on and off Windows XPReview questions141418192122242733465152CHAPTER THREEWORD PROCESSING3.1Features of word processing packages3.2Microsoft Word (MS Word)3.3Using the File, Edit and View menu commands3.4Using the Insert, Format and Tools commands3.5Using the Table, Window and Help commands3.6Windows menu commands56565762707882
3.73.8Help menu commandsShortcuts for working with documentsReview questions828386CHAPTER FOURSPREADSHEET4.1Microsoft Excel4.2Creating workbook and worksheet4.3Data Entry4.4Editing a worksheet4.5Creating series4.6Checking spelling4.7Formatting a worksheet4.8Creating custom format numbers4.9Making alignments4.10 Format style4.11 Custom views4.12 Inserting Hyperlinks4.13 Printing the worksheet4.14 Scenarios4.15 Worksheet protection4.16 Creating graphsReview 157161165CHAPTER FIVEDATABASE MANAGEMENT5.1Importance of database5.2Microsoft Access5.3Creating databases using Database wizard5.4Tables5.5Validation and use of expression builder5.6Sorting data5.7Filtering5.8How to delete a table or other database objects5.9Join and relationships5.10 Query and data retrieval5.11 Creating Query using design view5.12 Creating calculated fieldsReview 8
CHAPTER SIXMS FRONTPAGE6.1Starting FrontPage6.2Reorganizing web pages6.3Creating your web6.4Understanding feature elements6.5Working with tables6.6Working with graphics6.7Working with hyperlinks6.8Working with forms6.9Working with frames6.10 Managing your web site6.11 Publishing your web siteReview APTER SEVENMS OUTLOOK7.1Overview of Microsoft outlook7.2Features of MS Outlook7.3MS Outlook operations7.4Working with calendars7.5Using Notes7.6Creating contacts7.7Working with Journals7.8Sending and receiving e-mailsReview questions269269271275275279279281282284CHAPTER EIGHT PRESENTATION IN MS POWERPOINT 2868.1Starting Power point and creating presentations2878.2Inserting pictures into presentations2938.3Creating visual effects2948.4Saving presentations2968.5Closing a presentation2978.6Views of Power point2978.7Inserting, deleting and copying slides3008.8Inserting a diagram or organizational chart3028.9Power point animation3038.10 Slide transition3058.11 Setting time for slide to advance to the next3078.12 Multimedia and recording of sound in Power point 307
8.138.14Packaging a presentation for CD/FlashdiskPreviewing and printingReview questions313315316CHAPTER NINEUSING THE INTERNET9.1What is Internet?9.2Components of the Internet9.3How to connect to the \internet and WWW9.4Using an E-mailReview 334340342
1.1 Computer Hardware 1 1.2 Computer software 2 1.3 Understanding computer memory 3 1.4 Preparing to use the computer 7 1.5 Caring for your computer 9 1.6 Ergonomics 10 Review
