COMPUTER APPRECIATION

INTRODUCTION Students name: Working status: Pc Background: Expectation: 16 September 2009 2 COMPUTER APPRECIATION

Computer Appreciation Contents and Schedule Introduction to Pc Using Win Xp ---- 6 hrs Microsoft word Level I --- 6 hrs Microsoft Power Point I --- 6 hrs Microsoft Excel I ---- 6 hrs Use of the Internet -----5hrs Revision & Evaluation -----1 hr 16 September 2009 3 COMPUTER APPRECIATION

Introduction to Pc Objectives 1. Students are expected to be able to describe a computer system 2. Students expected to understand the basic components of a computer system 3. They must be able to perform basic tasks on Pc 16 September 2009 4 COMPUTER APPRECIATION

Definition: Computer System Is an electronic device that can accept inputs as data, process , store and display results as output when needed. 16 September 2009 5 COMPUTER APPRECIATION

16 September 2009 6 COMPUTER APPRECIATION

Computer Components Hardware: These are the Physical components of the computer system that can be touched and felt. Software: These are the various Programs that are installed on the computer system Human ware : These are users of computer system 16 September 2009 7 COMPUTER APPRECIATION

Computer Hardware Examples Keyboard Mouse and Pad Monitor/Visual Display Unit (VDU) System Unit 16 September 2009 8 COMPUTER APPRECIATION

Input Device Examples Keyboard Mouse Touch Pad Joy Stick 16 September 2009 9 COMPUTER APPRECIATION

Output Device Examples Monitor Printer Plotter Speaker 16 September 2009 10 COMPUTER APPRECIATION

System Unit Components Floppy disk drive CD-ROM/CD Writer/DVD Drive Hard disk Drive- for storage purposes Random Access Memory (RAM) CPU: Central Processing Unit ALU: Arithmetic & Logic Unit Control Unit Register: for storage Mother Board Power Supply Unit 16 September 2009 11 COMPUTER APPRECIATION

16 September 2009 12 COMPUTER APPRECIATION

RAM 16 September 2009 13 COMPUTER APPRECIATION

CD ROM 16 September 2009 14 COMPUTER APPRECIATION

Floppy Diskettes and Floppy Disk Drives 5.25” floppy disk Store 360 KB of data in double density format and 1.2 MB of data in high density format. Old technology, not very common today. 3.5” floppy disk Store 720 KB of data in double density format and 1.44 MB of data in high density format. Double density format and high density format are not interchangeable 16 September 2009 15 COMPUTER APPRECIATION

16 September 2009 16 COMPUTER APPRECIATION

MOTHERBOARD Motherboards are also called System boards or main boards. Connecting device to which all other internal and external devices connect, either directly or indirectly. Contains all the tiny circuits and pathways by which data moves. 16 September 2009 17 COMPUTER APPRECIATION

MOTHERBOARD 16 September 2009 18 COMPUTER APPRECIATION

16 September 2009 19 COMPUTER APPRECIATION

Process Central Processing Unit 16 September 2009 20 COMPUTER APPRECIATION

16 September 2009 21 COMPUTER APPRECIATION

Storage Hard Disk Drive (HDD) Random Access Memory (RAM) Floppy Disk Drive Flash Disk Drive 16 September 2009 22 COMPUTER APPRECIATION

HARD DISK DRIVE (HDD) 16 September 2009 23 COMPUTER APPRECIATION

External Computer Devices/Accessories UPS: Uninterruptible Power System PRINTER SCANNER: PLOTTER 16 September 2009 24 COMPUTER APPRECIATION

ACRONYMS SCSI-Small Computer System Interface AGP-Accelerated Graphic Port ISA-Industry Standard Architecture PCI-Peripheral Component Interconnect USB-Universal Serial Bus SIMM-Single Inline Memory Module BIOS-Basic Input Output System RAM-Random Access Memory 16 September 2009 25 COMPUTER APPRECIATION

ACRONYMS(cont’d) ROM-Read Only Memory DMA-Direct Memory Access VGA-Video Graphics Array CMOS-Complimentary Metal-Oxide Semiconductor HDD-Hard Disk Drive CPU-Central Processing Unit OS-Operating System 16 September 2009 26 COMPUTER APPRECIATION

Software Operating Systems (OS) Application Packages Utility Software 16 September 2009 27 COMPUTER APPRECIATION

Operating System Primary Software that is installed on the PC It acts as an interface between user and the PC It helps to install other packages and hardware Examples e.g Win 95, Win 98, Win 2000, Millennium, Win xp, Dos, Win 3.1, Linux, Novell Netware, Unix, Red hat Linux. 16 September 2009 28 COMPUTER APPRECIATION

Application Package They are used for specific tasks Ms Office Word:- Word Processing Ms Office Excel:- Spreadsheet Ms Office PowerPoint:- Presentations Corel Draw:- Designing AutoCAD:- Architectural Design Internet explorer:- Browsing (Internet) Others include:- Print Artist, Instant Artist, Ms publisher, Ms Outlook, Ms Access, Page maker . 16 September 2009 29 COMPUTER APPRECIATION

Mouse Mouse is an input device, it has two buttons (Left and Right) mouse buttons. FUNCTIONS OF MOUSE Point and Click- Double Click - to open object Click and Drag Right Click 16 September 2009 30 COMPUTER APPRECIATION

Starting your computer system Start the system unit Start the monitor/VDU 16 September 2009 31 COMPUTER APPRECIATION

Start The System Booting Involves loading of Operating System software to make the PC functional. Computer system boots whenever you start or restart it, and it perform what we call POST during booting POST: Power On Self Test. 16 September 2009 32 COMPUTER APPRECIATION

What you see when your system is ready The desktop Desktop items/Icons Task bar start button date/time etc Cursor/Hour Glass 16 September 2009 33 COMPUTER APPRECIATION

Shutting Down the system Close all applications Click Start button on Task Bar Click Shut Down/ Turn off Computer In the What do you want the computer to do for you box, select Shut Down Click Ok 16 September 2009 34 COMPUTER APPRECIATION

Starting Application Package Double Click On the Application icon on desktop OR Click Start Button, then click the application Icon OR Click start, Point at all programs, point at Microsoft office, then click on the application icon 16 September 2009 35 COMPUTER APPRECIATION

The Application Title Bar On the application title bar you will see: File name Application type Minimize button Restore down/Maximize button Close button 16 September 2009 36 COMPUTER APPRECIATION

Changing Background Picture Right click your desktop Click properties Click on desktop tab Select a desktop item of your choice Click apply Click Ok 16 September 2009 37 COMPUTER APPRECIATION

How To Create A Folder Right click your desktop Point at New Click on Folder Rename your folder by Typing on the Keyboard. 16 September 2009 38 COMPUTER APPRECIATION

How To Create A Briefcase Right click your desktop Point at New Click on Briefcase Rename your Briefcase by Typing on the Keyboard. 16 September 2009 39 COMPUTER APPRECIATION

ASSESSMENT PLEASE THIS IS TO TEST OUR ABILITY AND HOW WELL WE UNDERSTOOD ALL WHAT WE HAVE BEEN DOING. SO IT IS NOT LIKE THE NORMAL EXAM THAT YOU MUST PASS BUT WHAT YOU KNOW ABOUT THE COURSE. THANK YOU.

Revision and Evaluation What is a computer system ? A computer system is divided into how many components? Explain What is a software and lists its components? How do you power on a system and shut it down? How do you change the background picture of your desktop? State and Explain the BASIC function of the Mouse. What are on the Uppermost Bar of an Application State the Meaning of the following: RAM, ROM, OS, POST & UPS State 4 each of the following: Storage, Input & Output Devices State Ten bars you will see in a Ms Word Environment 16 September 2009 41 COMPUTER APPRECIATION

Introducing Ms word Level 1 16 September 2009 42 COMPUTER APPRECIATION

Objectives Students are expected to be able to interact with Ms Word Interface Be able to produce documents like letters, memos etc Be able to format their documents Work with tables and templates Be able to print their documents 16 September 2009 43 COMPUTER APPRECIATION

Ms Office Word Environment Title Bar Menu Bar Standard Tool Bar Formatting Tool Bar Vertical Ruler Horizontal Ruler Vertical Scroll Bar Horizontal Scroll Bar Status Bar Document Window 16 September 2009 44 COMPUTER APPRECIATION

Advantages Of Word Processor Advantages or word processor The use of computer allows for neat job. It makes typing pleasurable. There is room for corrections such that does not leave any scar on the document. With the use of computer text could be formatted to suit the user’s taste. Document could be enhance with graphics (Pictures). It allow for the production of many copies of document as the owner will need and each appears as the original 16 September 2009 COMPUTER APPRECIATION 45

Loading Microsoft Word Microsoft Word Interface Text Entry and Editing Commands Identifying various keys on the keyboards, and use of mouse Navigation keys Text deleting, Insertion, and overwrite 16 September 2009 46 COMPUTER APPRECIATION

Working with Text Typing and Inserting Text Students to spend about sometimes to enter reasonable amount of text 16 September 2009 47 COMPUTER APPRECIATION

Navigation 16 September 2009 48 COMPUTER APPRECIATION

Selecting Text 16 September 2009 49 COMPUTER APPRECIATION

Deleting Text Deleting Text Use the BACKSPACE and DELETE keys on the keyboard to delete text. Backspace will delete text to the left of the cursor and Delete will erase text to the right. To delete a large selection of text, highlight it using any of the methods outlined above and press the DELETE key. 16 September 2009 50 COMPUTER APPRECIATION

Saving your document Click File on menu bar Click Save/Save As In the save in box select the location you are saving the file into e.g My Document , 31/2 Floppy A: e.t.c In the file name box, type the name you want to use to save the file Click on Save button 16 September 2009 51 COMPUTER APPRECIATION

Opening your document Click File on the menu bar Click Open In the Look in box, select the directory you kept the file e.g. my document or diskette Select the file name by clicking on it in the text box Click Open button 16 September 2009 52 COMPUTER APPRECIATION

Renaming Documents To rename a Word document while using the program, select File|Open and find the file you want to rename. Right-click on the document name with the mouse and select Rename from the shortcut menu. Type the new name for the file and press the ENTER key. 16 September 2009 53 COMPUTER APPRECIATION

Undo AND Redo Undo Is to reverse the actions you have just taken. Redo is to repeat any action you Undo 16 September 2009 54 COMPUTER APPRECIATION

Copy/Paste Highlight the text you want to copy Click Edit on the menu bar Click Copy Move your cursor to the location you are copying to Click Edit on the menu bar Click Paste 16 September 2009 55 COMPUTER APPRECIATION

Cut/Paste Highlight the text you want to Cut Click Edit on the menu bar Click Cut Move your cursor to the location you are cutting to Click Edit on the menu bar Click Paste 16 September 2009 56 COMPUTER APPRECIATION

To Bold/un-bold Text Highlight/Select the text you want to bold/un-bold Click B on the formatting tool bar 16 September 2009 57 COMPUTER APPRECIATION

To add italic/remove italic Highlight/Select the text you want to make italic/remove italic Click on the formatting tool bar 16 September 2009 58 COMPUTER APPRECIATION

To underline/removing underline from text Highlight/Select the text you want to underline/remove underline Click on U on the formatting tool bar 16 September 2009 59 COMPUTER APPRECIATION

Font Size Highlight/Select the text you want to change its size Click Format on the menu bar Click Font Select the Font size of your choice from the Font Size box Click Ok 16 September 2009 60 COMPUTER APPRECIATION

Font Colour Highlight/Select the text you want to change its colour Click Format on the menu bar Click Font Select the Font colour of your choice from the Font colour box Click Ok 16 September 2009 61 COMPUTER APPRECIATION

Font Type Highlight/Select the text you want to change its Font type Click Format on the menu bar Click Font Select the Font type of your choice from the Font Type box Click Ok 16 September 2009 62 COMPUTER APPRECIATION

To Align Left Highlight/Select the text you want to be in the Left Click on align Left on the formatting tool bar 16 September 2009 63 COMPUTER APPRECIATION

Align Centre Highlight/Select the text you want to be in the centre Click on Align Centre on the formatting tool bar 16 September 2009 64 COMPUTER APPRECIATION

Align Right Highlight/Select the text you want to be in the Right Click on Align Right on the formatting tool bar 16 September 2009 65 COMPUTER APPRECIATION

Justify Highlight/Select the text you want to justify Click on Justify on the formatting tool bar 16 September 2009 66 COMPUTER APPRECIATION

Adding Bullet And numbering Highlight the text you want to add Bullet/Number to Click on format on the Menu bar Click on Bullets And Numbering Select Bulleted/Numbered Tab Select the Bullet/number format of your choice Select the Color of your choice Click OK 16 September 2009 67 COMPUTER APPRECIATION

How to Insert Date and Time Click the position you want to put your date/time click insert on the menu bar Click date and time Select the date and time format of your choice Click Ok 16 September 2009 68 COMPUTER APPRECIATION

Insert Page number click Insert on the menu bar Click Page Numbers Select the position of your page number i.e top of page or bottom of page Select the alignment of your page number i.e Right, Centre, Left Click on Format button Select the number format of your choice Click Ok Click Ok 16 September 2009 69 COMPUTER APPRECIATION

Insert Header and Footer click View on the menu bar Click Header and Footer Type the header text of your choice Move to the footer by pressing the down arrow key on the keyboard Type the footer text of your choice On the header and footer dialog box Click Close 16 September 2009 70 COMPUTER APPRECIATION

How to Insert Symbols/Special character click Insert on the menu bar Click Symbols Click on Symbols tab Select the symbol of your choice Click insert Click Close 16 September 2009 71 COMPUTER APPRECIATION

Inserting Table Click Table on the menu bar Point at Insert Click Table on the popup menu that appears Select the number of columns you want from the number of column text box Select the number of Rows you want from the number of Rows text box Click Ok 16 September 2009 72 COMPUTER APPRECIATION

Font Effects Type capital N Highlight the capital N that you typed click Format on the menu bar Click Font Under Effects, Select Double strikethrough Click Ok 16 September 2009 73 COMPUTER APPRECIATION

Inserting Column. Click format on the menu bar Click column Select the number of column of your choice In the Apply to Box, pick “This point forward” Click Ok 16 September 2009 74 COMPUTER APPRECIATION

Drop cap Highlight the Letter to be dropped Click format on the menu bar Click Drop cap Click Dropped In the Line to be drop Box, Select the number of lines Click Ok. 16 September 2009 75 COMPUTER APPRECIATION

Templates Click File on menu bar Click New Click on “on my Computer” from the templates tab Click the tab for the type of template of your choice e.g. memo, envelope, Letter & Faxes e.t.c. Select the template of your choice Click Ok 16 September 2009 76 COMPUTER APPRECIATION

Line Spacing Highlight the text you want to space Click Format on the menu bar Click Paragraph Select the Line spacing of your choice from the Line spacing box. Click OK 16 September 2009 77 COMPUTER APPRECIATION

Page setup Click File on the menu bar Click Page setup Select the margin Select the orientation type e.g Landscape or Portrait. Click OK 16 September 2009 78 COMPUTER APPRECIATION

Spelling/Grammatical Errors Red line for spelling error Green line for grammatical error Solution: Press F7 From the keyboard OR Click Tool on the menu bar Click Spelling and Grammar 16 September 2009 79 COMPUTER APPRECIATION

Document protection Click Tools on the menu bar Click options Click security 16 September 2009 80 COMPUTER APPRECIATION

Print Preview Click File on the menu bar Click Print Preview 16 September 2009 81 COMPUTER APPRECIATION

Printing Click File Click Print Select the printer type Select the Page range Select the number of copies Click Ok 16 September 2009 82 COMPUTER APPRECIATION

Getting Help Press F1 on the keyboard OR Click Help on the menu bar Click Microsoft office Word help 16 September 2009 83 COMPUTER APPRECIATION

Class assessment First week Describe how to perform the following functions in Ms Word environment Bold, Italic, Underline and Centre Alignment Describe the BASIC Functions of the Mouse. State the Input, Output and storage devices known to you. Describe how to Preview, Print and perform Page Setup of document in ms word environment. 16 September 2009 84 COMPUTER APPRECIATION

Ms Office PowerPoint 16 September 2009 85 COMPUTER APPRECIATION

Objectives Students Must be able to start Microsoft PowerPoint They Must be able to Create slides and delete them They must be able to create a presentation using all the features 16 September 2009 86 COMPUTER APPRECIATION

Ms Office PowerPoint can be used for: Entertainment Lecture Delivery Workshop Seminar Conference paper defence Exhibition e.t.c 16 September 2009 87 COMPUTER APPRECIATION

Starting Ms Office PowerPoint Double Click On the Application Icon on Desktop Click Start > All Programs > Ms Office 16 September 2009 88 COMPUTER APPRECIATION

What you see when you start Ms PowerPoint Title bar Menu bar Standard tool bar Formatting tool bar Slide Task Pane 16 September 2009 89 COMPUTER APPRECIATION

How to Create New Slide 1. Click on Insert on your main menu bar and click on new slide OR 2. Click on New slide on your Formatting Toolbar OR 3. Press Ctrl+M on your keyboard 16 September 2009 90 COMPUTER APPRECIATION

How to Delete A Slide Click on The slide and Press Delete on your Keyboard. 16 September 2009 91 COMPUTER APPRECIATION

Steps to creating a presentation 1. Choosing of Layout 2. Choosing of Slide Design 3. Choosing Of Animations 4. Slide Transition Stage 16 September 2009 92 COMPUTER APPRECIATION

Choosing of Layout Click format on the Menu Bar Select Slide Layout 16 September 2009 93 COMPUTER APPRECIATION

Choosing of Slide Design Click format on the Menu Bar Select Slide Design 16 September 2009 94 COMPUTER APPRECIATION

Choosing Of Animations Click Slide Show on the Menu Bar Select Animation Schemes 16 September 2009 95 COMPUTER APPRECIATION

Slide Transition Stage Click Slide Show on the Menu Bar Select Slide Transition 16 September 2009 96 COMPUTER APPRECIATION

ASSESMENT How Do you create a new slide in Ms PowerPoint? How Do you Delete a Slide in Ms PowerPoint? Create a presentation of not less than 10 slides including all features like background design, sound, animation and timing.? 16 September 2009 97 COMPUTER APPRECIATION

Ms Office Excel 16 September 2009 98 COMPUTER APPRECIATION

Objectives Students Must be able to start Ms Excel They Must be able to rename a worksheet They must be able to Create and format worksheets Must be able to perform basic calculations in Ms Excel Be able to plot charts 16 September 2009 99 COMPUTER APPRECIATION

Ms Office Excel Excel Can Be Used For Data entry Data Analysis Report Generation 16 September 2009 100 COMPUTER APPRECIATION

Starting Ms Office Excel Double Click On Excel Icon on the desktop Click Start > All Programs > Ms Office then click on Excel Icon. 16 September 2009 101 COMPUTER APPRECIATION

What do you see when you start Excel? Title bar Menu bar Standard tool bar Formatting tool bar Name box Formula bar Excel Worksheet 16 September 2009 102 COMPUTER APPRECIATION

16 September 2009 103 COMPUTER APPRECIATION

Operators Addition: + Subtraction: - Multiplication: * Division: / 16 September 2009 104 COMPUTER APPRECIATION

Rename A Worksheet Right Click the worksheet name. e.g Sheet1 Click Rename Type the name you are given to the worksheet and press enter key on the keyboard 16 September 2009 105 COMPUTER APPRECIATION

Deleting A Worksheet Right Click on the worksheet Click Delete 16 September 2009 106 COMPUTER APPRECIATION

Moving A Worksheet Right Click the worksheet name. e.g Sheet1 Click Move or Copy Click the Location from the “Before sheet” Box e.g. Move to End, sheet1etc. 16 September 2009 107 COMPUTER APPRECIATION

How To Insert A Worksheet Right Click the worksheet name. e.g Sheet1 Click Insert Select Excel Worksheet Click Ok 16 September 2009 108 COMPUTER APPRECIATION

Tax = 10/100*Basic 16 September 2009 109 COMPUTER APPRECIATION

Creating A Chart Highlight the Cells You want on the Chart Click Insert On the Menu Bar Select Chart Indicate Chart Type Indicate Chart Sub-Type Click Next Click Next Click Next Select As New Sheet Click Finish 16 September 2009 110 COMPUTER APPRECIATION

Assesment How do you Rename a worksheet in Ms Excel How do you Create a New Worksheet in Ms Excel Create a payroll using Ms Excel which will include allowances (Transport, Clothing, medical, feeding) , tax of 3% truncated to 3 decimal places of 10 workers and plot a graph for the allowances included in the payroll. 16 September 2009 111 COMPUTER APPRECIATION

Use Of The Internet 16 September 2009 112 COMPUTER APPRECIATION

Objectives Students must be able to know the benefits of the internet They must be able to launch the Internet They must be able to Surf the Web They must know how to Send mails and receive mails. 16 September 2009 113 COMPUTER APPRECIATION

The Internet Internet can be defined as interconnection of computers and computer networks globally for resource sharing and easy communication 16 September 2009 114 COMPUTER APPRECIATION

Network Is the interconnection of computers and computer related devices for resource sharing and easy means of communication 16 September 2009 115 COMPUTER APPRECIATION

Types of Network LAN: Local Area Network WAN: Wide Area Network GAN: Global Area Network MAN: Metropolitan Area Network CAN: Campus Area Network 16 September 2009 116 COMPUTER APPRECIATION

Connecting to internet Wired Computer/Telephone line/Modem/ISP Modem: Modulation-Demodulation ISP: Internet services Provider Wireless VSAT: Computer/VSAT/ISP RADIO: Computer/Radio/ISP VSAT: Very Small Aperture Terminal 16 September 2009 117 COMPUTER APPRECIATION

Facilities Email : Electronic Mail Newsgroup Internet relay chart FTP/Browsing. FTP: file transfer protocol 16 September 2009 118 COMPUTER APPRECIATION

Starting Internet Start Internet by: 1. click Start 2. Click Internet explorer. OR Double click Internet Explorer Icon on the Desktop 16 September 2009 119 COMPUTER APPRECIATION

www.yahoo.co.uk 16 September 2009 120 COMPUTER APPRECIATION

16 September 2009 121 COMPUTER APPRECIATION www.cnn.com www= world wide web Cnn= company name or domain name Com= commercial i.e the nature of services the company renders on internet edu= education Org= organization net= internet services mil= military ng= nigeria . gov= government Ca= canada Uk= united kingdom Us= united state

Revision and Evaluation What is internet? What are the facilities of the Internet? What is the meaning of E-Mail & www? State steps to search for information on net. What is meaning of the following: WAN, LAN, MAN, GAN, FTP, VSAT & ISP 16 September 2009 122 COMPUTER APPRECIATION

For further Information: OLALEKAN ADEEKO 08034457492 lincolndemo@yahoo.com 16 September 2009 123 COMPUTER APPRECIATION

Be Thankful It is easy to be thankful for the good things. A life of rich fulfilment comes to those who are also thankful for the setbacks. Find at least a way to be thankful for your troubles and they can become your blessings. Remember to give thanks in all situations; because it is an opportunity for God to demonstrate His saving grace and delivering power in your life. Give thanks with a grateful heart!!! Your ATTITUDE to God determines your ALTITUDE in life! Align your WORD with "THE WORD" and see your WORLD change for the BEST! 16 September 2009 124 COMPUTER APPRECIATION