Back to Academic Main Page

 

Introduction to Computers:

Class Outline

 

 

SESSION 1

 

I.                     Instructor’s Class Introduction

·         Distribute and have Identification Cards signed.

o        Remind the students not to lose these cards.  They must be displayed to the Supervisor in order to use the computer during Open Lab for no charge (Internet is not included).

·         Remind students to bring or purchase ($2 from the WDYHCC) a disk for next class.

·         Distribute lesson plans.

·         Read over Computer Center Rules (and explain if necessary).

·         Explain Privileges and Pricing.

·         Explain Hardware:

o        Monitor, Computer, Mouse Pad, Speakers, UPS Back-ups (remind students that work should be quickly saved and the computer turned off if there is a power failure), Printer, Scanner, External Modem, Mouse (explain function of the mouse and practice clicking), Keyboard (explain all important keys).

·         Explain Networking:

o        The Server, the Hub, connecting all the computers for printing, Internet, and security.

 

II.                   The First Step

·         Make sure the computer is on.  If you see a green light on the computer, then it is on.  The monitor may be black (it sleeps after a few minutes of nonuse).  If the computer is on and the monitor is black, you only need to move the mouse and the monitor will wake up.

·         If the computer is off, the instructor will turn it on.  Only the employees of this Center will turn the computer on or off.

·         Insert the Username that your instructor has given you.

·         Insert the Password that your instructor has given you.

o        The password is a secret so it will appear as *** to hide it’s identity in case someone is looking over your shoulder.

·         Single-click with the arrow, known as the “pointer” on the  box with the left mouse button.

·         Windows is now loading.  The read light (under the green light on the computer) is on.  Wait until the computer is finished loading, the read light will go off.  Then the computer will be ready to use.

III.                  Windows and the Desktop

·         Windows is an Operating System made by the company Microsoft (owned by Bill Gates, the richest man in the world who lives in Seattle).  An Operating System coordinates the activities within the computer and controls the use of the hardware.

·         Before we begin, please note that you should not click on or go to a place you have not been instructed to or do not understand.  It can cause problems for the computer.

·         The Desktop is the Screen in front of you.

o        The pictures, called “icons” or “short-cuts” are ways to open programs.

§         Double-click on Microsoft Word icon to open (or “launch”) the program.

§         Exit (otherwise known as “close”) Word by single clicking the (X) in the top left-hand corner.

·         The Taskbar

o        This is the bar on the bottom of the screen.

o        The symbols on the taskbar also lead to programs just like on the desktop.

§         To access them you only click once (instead of twice like on the Desktop).

§         Single-click on the  and Microsoft Word and it will open.

·         Changing the Window

o        The “window” is the loaded program (currently Word) in the form of a rectangular section of the screen that you see on the Desktop, which can be used independently from the rest of the screen.

o        The “title bar” is at the top of the window and is blue when the window is active.

o        You can “close”, “minimize”, “maximize/restore” with the buttons in the top, right-hand corner of your window with the “control icons”:

§         Minimize Word by clicking .

·         Locate Word on the Taskbar.

Maximize Word by single clicking on it in the taskbar.

§         Close Word by clicking .

·         Multiple Windows Open at Once

o        Open Excel on the Desktop.  Minimize.

o        Open Word on the Desktop.  Minimize.

o        Switch back and forth between the programs using the taskbar.

o        Close Word.

·         A Window Within a Window

o        Maximize Excel if it is not already so.

o        Minimize the “Book 1” window by clicking on  in the second row of buttons in the top, right-hand corner (located on the “secondary title bar”).

o        Maximize “Book 1” by clicking .

o        Close “Book 1” but NOT Excel by clicking  on the secondARY title bar, row of buttons.

o        Now close Excel by clicking on the top row.

 

IV.                The Start Menu

·         The Start Menu has many functions.  For now we will learn about using it to access programs.  Some programs you see in the Start Menu have short-cut icons on the Desktop and the Taskbar.

·         The Start Menu is accessed through the  button in the bottom, left-hand corner of the taskbar with only a single-click.

o        Click on Start. Highlight Programs.  Slide the pointer (no need to click yet) to the right menu that has appeared.  Highlight Microsoft Word.  Single-click to open it.

o        Close Word.  Open Excel the same way through the Start Menu. Close.

·         Two ways to close the Start Menu (or any menu) without choosing a an program or item.

o        1) Open the Start Menu; Click on an empty space in the Desktop.

o        2) Open the Start Menu; Hit the Escape button on the keyboard (top, right-hand corner) to close the opened menu.

·         Start Taskbar Launcher

o        You can access the most common programs by single clicking on the small icons on the Start Taskbar.

§         Open Word by clicking .

§         Go to the Desktop view by clicking .

§         Maximize Word.  Now close Word.

 

V.                  When you are Finished Using the Computer

·         Logging Off

o        When you are finished using the Computer make sure you must log-off.

§         When you are ready to log-off make sure you close any open programs and remove the disk, if there is one, from the A; drive.

§         Go to the Start Menu and click on “Log Off student”.  Answer “Yes” to “Are you sure you want to log off?”

 

SESSION 2

 

VI.                Commonly Used Application Software

·         Norton Anti-virus

o        Viruses infect disks, Emails, and computers.  If they get on the computer they can destroy it.  Viruses are very bad things.

o        Norton Anti-Virus detects viruses before they can hurt your computer.

·         Microsoft Paint

o        The Instructor will give you a brief demonstration.

o        On the Start Menu go to “Programs” then to “Accessories” then to Paint. Single-click to open the program.  Play with it for a few minutes.  Try to draw a happy face and Close when you are finished.

·         Solitaire / FreeCell / Minesweeper

o        These games can be good for hand-eye coordination, practice with the mouse, and a mental rest from hard work.

o        No other games are allowed in the Western District Computer Center.

o        Solitaire

§         The Instructor or one of the students who already knows how to use this program will explain how to play to the others.

§         In the Start Menu go to “Program” then “Accessories” then to “Games”.  Open Solitaire.  Play for a few minutes.  Close when you are finished.

·         Microsoft Excel

o        The displayed Budget for the Computer Center (on the wall by Computer #2) is an example of what Excel can do.

§         Open Excel on the Desktop, the Taskbar, or the Start Menu.

o        Each box is called a “cell” and is located using the letters on the columns (up and down) and the numbers on the rows (left and right).  Practice navigating through the cells with the cursor keys or the mouse.

o        Example of addition equation in Excel:

§         In cell B2, inset “4”.  Hit Enter on the keyboard.

§         In cell B3, insert “6”.  Hit Enter.

§         In cell B4, insert “=B2+B3”.  Hit Enter.

o        Close Excel; Answer “No” to “Do you want to save…”

·         Calculator

o        A simpler way to do math is to use this program.

o        From the Start menu, go to the Accessories menu and open Calculator.

o        As an example, subtract 24 from 2001; exit the program.

·         Microsoft Publisher

o        You can create Brochures, Newsletters, Invitations, Thank You Cards, Announcements, Brochures, Business Cards, and a whole lot more in Publisher.

o        In the Start menu go to “Programs” and open Publisher.

o        Example: Making a Business Cards

§         Single-click on “Business Cards”.

§         Single-click on “Accessory Bar Business Card”.

§         Click  in the bottom right-hand corner.

§         Click OK if you get the message “The Wizard will fill in you name…”

§         Click “Cancel” if you see the “Personal Information” window.

§         Move the mouse pointer and click on the title name.  Delete the name currently in the field and type your name.

§         When you have had enough, close this document by clicking on  in the top Menu bar (more on this later), highlight “Close”, and single-click.

§         Answer “No” to “Do you want to save changes…”

o        Further application of Publisher

§         Go back to the File menu and click on “New”.

§         Click on various different items to see all the things that Publisher can do.  The “Origami” and “Airplane” listings are fun.

§         Close Publisher. Answer “No” to “Do you want to save…”

·         Encyclopedia Britannica

o        This Computer Center is lucky to have an entire Encyclopedia, Dictionary, and Atlas installed on each of its computers.  If you are doing reports or just curious, you can find information on just about anything with Encyclopedia Britannica.

o        Double-click on Encyclopedia Britannica on the Desktop.

o        The Dictionary:

§         Click on “Dictionary” on the File menu.

§         Type, “discombobulate” and hit Enter.  Now you can impress your friends with big words to explain simple things.

§         Close the Dictionary window

o        The Atlas:

§         Look at the list of options on the right-hand side.  Click on “Compass”.

§         Click on “North America

§         Click on “United States

§         Click on “Seattle

§         In the File Menu above, click on “Home”

o        The Encyclopedia:

§         The Encyclopedia is a wealth of knowledge with over 80,000 articles.

§         Click on “Ask Britannica”

§         Type “Pacific Ocean

§         Go back to the “Home” screen

o        Spend a few minutes looking up whatever information you like.  How about finding Tonga on the Atlas or searching for articles about Tonga in the Encyclopedia?

 

·         Typing Master

o        A very important part of using a computer is being able to type well.  This program will provide you with extensive, yet enjoyable training and will have you typing well in a few hours.

§         Open Typing Master on the Desktop or the Start Menu.

§         Click on whoever’s name is in the box.  Type your name and hit Enter.

§         Answer “Yes” to “Are you a new user?”

§         When you are finished reading the introduction single-click on “Next” in the bottom right-hand corner to continue.

§         Continue to click “Next” reading each screen as you go.  Eventually you will come to a screen has “Begin” in the bottom right-hand corner.  Click on it to start you first lesson.  Spend the rest of the class or longer following the program’s instructions and close the program when you are finished.

§         Log Off the computer before you leave.

 

SESSION 3

 

VII.               The Drives

·         Open My Computer on the Desktop.

·         The D: drive holds the CD-ROM for programs and playing music. With a special CD-ROM Rewrite you can record information on a CD (like a floppy disk, except a CD holds much more information.

·         The A: drive is for storing documents on floppy disks.

o        To insert a floppy disk make sure the label is on top and push into slot until the square button pops up.

§         Insert a floppy disk.

§         Eject it by pressing the button.

§         Open it by double-clicking on it.

§         Use the back function  to go back to My Computer.

·         The C: drive is located inside the computer and is for storing documents and programs.

·         The K: drive is actually located on the Server computer.  It is labeled as “Class Practices on ‘Server’” and, you guessed it, it holds the class practices.  (More in the next session).

 

VIII.             Retrieving a Document

·         There are several ways to open a document.  We will discuss ways to open Class Practices.

·         Through My Computer

o        In My Computer double-click on “Class Practices on ‘Server (K:)”.

o        Double-click on the document “Scrollbar Practice”.

o        Close “Scrollbar Practice”.

o        Close My Computer.

·         Through the File Menu in Word

o        In Word, go to the File menu and click on “Open…”. (The “…” after an option in a menu of the Menu Bar means a “dialog box” will pop up.  This is another window that holds another menu with more options.)

o        Click on the down arrow  on the top-center of the window and single-click “Class Practices on ‘Server’ (K:)”.

o        Select, by single clicking, “Scrollbar Practice” and click on .  Exit Word.

 

IX.                Saving Changes

·         If you don’t save your changes, then whatever you may be working on disappears into computer heaven, never to be seen again.  So save often!

·         You must save your personal work on your floppy disk only, not the hard drive in this Computer Center.

o        Insert your disk into the A: drive.

o        Open Word.

o        Type your name on the document.

o        Go to the File Menu and click on “Save As”.

o        Click on the down arrow and highlight . Single-click.

§         Remember this step.  This is also how you would access a document on the A: if you were OPENING it.

o        Click .

·         To change the name of your file upon saving

o        Go to “Save As” in the File Menu.

o        Highlight the file name (which should be your name) and type “Name”.  Save.

o        Close the window of this document, but not Word.

 

X.                  Beginning Formatting on Microsoft Word

·         Using the Scrollbar

o        Open Document: “Scrollbar Practices”.

o        Click and hold down the mouse button on the vertical Scrollbar on the far right, pulling the document up or down.

§         View each page one at a time.

o        Click on the down arrow  on the bottom of the Scrollbar to view the document line by line.

o        Go to page 3 and click the mouse cursor on at the beginning of  FOOD and type GOOD”.

o        Close “Scrollbar Practice” without saving.

·         Highlighting chooses a selection to format

o        Open the document with your name on it from your floppy disk.

o        To highlight your name, click the “cursor” just before the first letter of your name and hold the mouse button down and swipe your name to the last letter.  Release the mouse button.

·         Increasing the Font

o        While your name is highlighted, click on the down arrow next to the number (12) on the toolbar .

o        Use the Scrollbar to find the number (48).  Click on it.

·         Bold, Italicized, and Underlined

o        Make sure that your name is highlighted and click these buttons on the toolbar.

·         Centering

o        Click on the button with the centered lines .

·         Changing the Font Type

o        With your name highlighted click the arrow next to  and use the scrollbar to choose “Ravie”.

·         Adjusting the vertical position of a selection

o        Move the cursor (your name will be un-highlighted) to the beginning of your name and hit Enter four times.

o        Now hit Backspace two times.

·         Print Preview

o        Go to Print Preview in the File Menu or click the Print Preview Tool .

o        Click anywhere on the document with the magnifying glass to zoom-in.

o        Click again to zoom out.

o        Hit “Close” on the Print Preview toolbar.

·         Spend a few minutes typing a message and practicing formatting.

·         Printing

o        Note: if you want to print this document you will have to pay $.20 for each side of a black and white document.

o        Go to Print on the File Menu.

o        Hit OK if you want to print.

·         When you are finished, save your work (your floppy) and exit Word through the File Menu.

·         Remove your disk and Log Off the computer when you leave.

 

 

SESSION 4

 

XI.                More Features in Word

·         Open Word.

·         The Help Feature

§         Go to the Help Menu and choose “Microsoft Word Help”.

§         Make sure that the menu under “tab”  is open.

§         Delete “Type your question here and then click Search” by using the Backspace key from the end of the word.

§         Type:  “How do I insert a picture”; click “Search”.  Close Help.

§         Another way to do this is to hit F1 on the keyboard.

·         More on the Toolbar

o        Icon Tools on the Tool Bar

§         The New Blank Document tool is this one, a page with the corner bent:

·         Open a new document by clicking on it. Close the document.

§         The Open tool the yellow folder with an arrow:

·         Open “Selecting Practice”.

§         “Tool tips” pop up when you slowly move the mouse’s pointer along the icons of the Toolbar.

·         Try it and see the description of the other Icon Tools.

·         The Status Bar

o        The “Status Bar” is the horizontal area in Word below the document window. .  It contains information about the document you are working on.  The “1/2” means page 1 of 2.

·         The Cursor Keys

o        The arrows in between the number pad and the main keyboard help you navigate through the document.

§         Move the cursor to the end of the document using the cursor keys.

§         Go back to the beginning of the document using the cursor keys.

·         More on Selecting and Highlighting

o        One Word highlighting by double-clicking

§         Double-click on “Scary” in the title and click the Italic Tool:

§         To un-highlight the word single-click anywhere in the document away from the word and you should see the blinking cursor.

o        Single line highlighting a by single-clicking the pointer in the left margin

§         Highlight the first line of the first paragraph and make it bold.

o        Paragraph highlighting a by double-clicking the pointer in the left margin

§         Highlight the 2nd paragraph and hit the delete key on the keyboard.

o        Whole document highlighting

§         There are several ways to do this.  In the future use whichever one is easiest for you.

§         1. Triple-click in the margin.

§         2. Use the “short-cut key” (more on this later): Ctrl+A

·         Hold down the Control button on the bottom left-hand corner of the keyboard and press A.

·         Change the font size of the whole document to 14.

§         3. Go to the Edit Menu on the Menu bar and select “Select All”.

§         4. Highlight from the beginning (top, right-hand corner) to the end of your document by holding down the mouse button.

§         5. Move the cursor to the top of the document and hold the shift button down while holding the down cursor arrow.

§         6. No, five is enough.

§         Select the whole document using whichever method you liked best and increase the font to size 26.

§         How many pages is the document now according to the Status bar?

§         Look at it in the Print Preview.  Close Print Preview.

§         Change the font back to size 12.

o        Moving and changing the size of a graphic

§         When you have the graphic selected you will see tiny square boxes outlining the area and your pointer will be four arrows in opposite directions.

·         Single-click and hold the button on top of the shark.

·         Holding the button down, slowly move the graphic to the bottom of the page.

§         Changing the size of the graphic

·         Single-click the shark.  Go to one of the corners of the highlighted area and when the pointer changes to a double arrow, pull it back and the image will be enlarged.

§         To delete a graphic, single-click on it to highlight it and hit the delete (“Del”) key on the keyboard.

§         Close this document and do not save changes.

·         Undo

o        Have you done something and want to change it back or “undo” it?

§         Open a new document.

§         Write a short sentence on what you think of computers.

§         Erase (by using Backspace) the last word of the sentence.

§         Go to the Edit Menu and select “Undo Typing”.

§         Erase the word again and undo it by using the Undo Tool .

§         Close this document, but not Word without saving.

·         Cutting and Pasting

o        Open “Cut and Paste Practice”.

o        Edit Menu method

§         (Ignore the red-squiggly lines – we will discuss those later)

§         Select (highlight) the first paragraph.

§         Go to the File menu and click on “Cut”.

§         Using the mouse or the cursor keys move the cursor AFTER the second paragraph.

§         Return to the File menu and select “Paste”.

§         Make sure there are spaces between each paragraph.

o        Using the Cut Tool  and the Paste Tool

§         Highlight the first sentence of the LAST paragraph.

§         Click the Cut Tool.

§         Move the cursor to the end of the document and use the Paste Tool to insert the sentence, as it’s own paragraph.

§         Close this document without saving the changes.

·         Page Setup

o        Open “Formatting Practice”

o        Look at it in Print Preview.  Close the Print Preview window.

o        Margins

§         Change the margins of the document to 7 cm for the TOP and BOTTOM margin and 1 cm for the LEFT and RIGHT margin by using the up and down arrow buttons (called the “Spin Box”) displayed next to the numbers .

o        Page Orientation

§         Click on the  tab near the top of the window.

§         Click  (this is known as an “option button”) in the Orientation box.  Click “OK”.

§         Look at the changes in Print Preview.

§         Close this document and do not save changes.

 

 

SESSION 5

 

XII.               More Formatting in Word

·         There are many different ways to use each feature and option in Word and other programs.  Use whichever ones you are most comfortable with.

·         Open “Formatting Practice”.

·         Look at it in Print Preview.  Close the Print Preview window.

·         Follow These Instructions to help you learn more about formatting in Word.

o        Open “Formatting2 Practice”.

o        Center and Bold the title and change the font to Broadway size 16.

o        Character Color

§         Find the Color Tool  and change the color of the title to bright green (click on the little down arrow , which initiates the “Drop-down list” on the Tool to select different colors).

o        Line-Spacing

§         Highlight the first paragraph

§         Go to the “Format” Menu and select “Paragraph”.

§         Find the  box and select “1.5 lines”.  Click “OK”.

o        Bulleted Items

§         Highlight the four lines FOLLOWING the second Paragraph.

§         Click the Bullets Tool in the Tool Bar .

o        Columns

§         Make sure the bulleted items are highlighted.

§         Find the Column Tool  , highlight two columns and click the mouse.

o        Paragraph Alignment

§         Highlight the third Paragraph.

§         Click on the Justify Tool  .

o        Indenting

§         At the beginning of the first word in the last paragraph hit “Tab” on the keyboard.

§         Hit it three more times to see what happens.

§         Backspace three times.

§         Close this document without saving it.

·         Insert and Type Over

o        See that “Insert” button to the right of “Backspace”.  Press that and you will either be able to insert a word in front of an existing word or type over it.  If the “Over” function is on you will see  in the status bar. Hit the “Insert” key to try it.

§         Open a new document.

§         Type this sentence:  “It was a hot day, today.”

§         Move the cursor before the word “hot”.

·         Make sure the Over function is off (in other words Insert function is on and you do NOT see  on the status bar).

§         Type “very” in front of “hot”.

o        Now hit the Insert button, turning the Over function on and type “cold.” over “hot.”

o        Close this document without saving it.

·         Spell and Grammar Check

o        Open “Spelling and Grammar Practice”.

o        Quick Fix Method

§         Aim the pointer on the misspelled word “flite” (with a red, squiggly line) in the first paragraph and click the RIGHT-mouse button.

§         Highlight and click “flight” to correct the error.

§         Continue doing this with all the misspelled words in the FIRST paragraph.

§         Watch out!  Sometimes Spell-Check does not catch every mistake.  Look at “fro” in the second line.  That’s supposed to be “for,” but the spell check missed it because “fro” is a word.

§         Now do Quick Fix with the grammar errors in the second paragraph.

§         If you don’t want to make the change suggested (or if you don’t understand it) click “Ignore”.

o        Check the Whole Document

§         Find the Spelling and Grammar Tool  in the Tool bar and click it to check the whole document.

§         This is different than the Quick Fix method on the short-cut menu, but it is pretty much self-explanatory.  Just highlight the word that is correct and click “Change” or “Ignore” if you don’t want to change the word.

§         Another way to do this is to go to the “Tools” Menu and select “Spelling and Grammar…”

§         Just so you know, a Third way to do this is to hit F7 on the keyboard.

·         The Thesaurus

o        Want to find a synonym (a word that has the same meaning as another)?

§         On the same document highlight “speedy” in the FIRST line of the FIRST paragraph

§         Hold down shift and hit F7 on the keyboard.

§           with the word “quick”.

§         Another way to use the Thesaurus is to find it on the Tools Menu under “Language”.

§         Try using the thesaurus function on other words.

·         The Replace Command

o        If you have typed a paper and realized that you have used the wrong word the whole time, no worries…

§         In the Edit menu click “Replace”.

§         In the “Find What:” box type “Mary”.

§         In the “Replace With:” box type your name.

§         Hit “Replace All”.  Click “OK” and close the window.

·         Short-cut Keys

o        Remember Ctrl+A to select the whole document?  There are a whole lot more of these (see print-out).  Try out some of these short-cut keys:


o        Ctrl+Z: Undo

o        Ctrl+C: Copy

o        Ctrl+X: Cut

o        Ctrl+V: Paste

o        Ctrl+B: Bold

o        Ctrl+N: New Document

o        Ctrl+A: Select the whole Document

o        Ctrl+S: Save

o        Ctrl+O: Open

o        Ctrl+P: Print

o        Ctrl+1: Single Spacing

o        Ctrl+2: Double-Spacing

 

SESSION 6

 

XIII.             A Little More Formatting in Word

·         Headers and Footers

o        Open “Header and Footer Practice”.

o        In the View Menu, click on “Header and Footer”.

o        Insert  The Exciting Life of James Cook. Center and bold it.

o        Wait for “Tool tips” to pop up on the Header and Footer Tool Bar and find the “Switch Between Header and Footer” button (this one: ).  Click it.

o        Find the “Insert Date” tool in the Header and Footer toolbar and click it to add today’s date in the Footer.

o        Hit the Tab key twice and insert the Page Number using by clicking on the “Insert Page Number” tool.  Close the Header and Footer toolbar.

·          Document Views

o        Using the Tool Bar

§         Go to the Zoom  function on the Tool bar and click on “25%”.

§         Now try “Whole Page” in the Zoom tool.

§         Return the Zoom back to 100%.

o        Print Preview

§         Go to Print Preview.

§         To view multiple pages of the document in Print Preview single-click on the “Multiple Pages” tool , highlighting the boxes down and to the right to “2 x 2” pages.  Click the mouse button.

§         Change it back to viewing one page at a time.

§         Close Print Preview by clicking “Close” on the Toolbar.

§         Close “Header and Footer Practice” and do not save changes.

 

XIV.           Creating a Folder

XV.  A computer can be considered a super-compact filing cabinet able to hold thousands of files.  Here is a way to organize them:

·         Open the A: drive in My Computer.

·         In the File menu select follow the “New” menu and select “Folder”.

·         Type: “Names” and hit enter.

 

XVI.            Moving Files

·         Single-click on the icon of the document “Fancy Name”.

·         Wait a second and click on it again, holding down the mouse button.

·         Drag the file into the new folder.

·         Do the same thing with any other name documents on your floppy.

·         When you are finished moving files, double-click on the new “Names” folder to look inside.

·         Using the  “Up” tool or the back function go back “up” to the A: drive.

·         Changing the file name

o        Single click and wait a second on the word “Names” under its folder.

o        Change the name to “Hingoa” and hit Enter on the keyboard.

·         Close this window.

 

XVII.          Templates in New Document

·         Microsoft Office provides ready-made layouts helping you make just about any document format you might need.

o        Open Microsoft Word

o        Go to the File Menu and select “New”.

o        Flip through the tabs to see how many options there are.

§         Look under “Letters and Faxes”.  These might be useful for you someday.

o        Choose the “Other Documents” tab and select “Professional Resume”.

o        Spend a few minutes to personalize the template to your information.

o        Save as “Resume” on your FLOPPY disk.  You can continue working on it outside of class time.

o        Close Word.

 

XVIII.         Fun Formatting Features in Word

·         Word Art

o        Start a new document.

o        Open the “Word Art” Tool bar.

o        Click on the “Insert WordArt” Tool .

o        Choose whichever WordArt format you want. Click “OK”.

o        Type your name.  Click “OK”.

o        Move and size your name to wherever you want.

o        Un-highlight the WordArt by clicking on the document outside the WordArt box.

·         Borders

o        Under the Format Menu select “Borders and Shading…”.

o        Click on the “Page Border” Tab.

o        Open the Art Menu and a border of your liking.  Click “OK.”

·         Inserting a Clip-art Picture

o        In the Insert Menu open “Picture” and follow the arrow to and click on “Clip Art”.

o        Single-click on the “Animal” category.

o        Single-click on the Parrot and click the Insert Tool .

o        Close the Clip-Art window.

o        Formatting the position of the picture to be placed anywhere on the page

o        Highlight the picture and right click to go to the short-cut menu.

o        Choose Format Picture

o        On the Format Picture Window choose the “Layout” tab

o        Click on the picture about “tight” and then click OK

o        Go to the “Save As” option in the File Menu and save this document on the A: drive as “Fancy Name”.

o        Close Word.

 

 

SESSION 7

 

XIX.            Excel: Calculations and Chart Construction

·         Perform calculations, analyze information, and manage lists with Spreadsheets.  Does this sound useful to you?  If not, let’s do some work with Excel and see if we can change your mind.

·         Open Excel

·         Remember that each rectangle is called a “cell”.

o        Practice navigating the cells by going to cell H16 clicking with the mouse.

o        Move to cell D7 using the cursor keys on the keyboard.

·         Drag list Function

o        In cell A1 type:1

o        In cell A2 type: 2

o        Highlight both cells (A1 and A2), click and hold on the bottom right-hand corner of the highlighted area.  You should see the pointer turn into: +.

o        While holding down the mouse button pull down to cell A10 and release.

·         Inserting

o        It is common to have to insert new rows or columns for additional information.

§         Highlight Rows 1 through 3 by clicking and holding down on their numbers:

§         Go to the Insert Menu and click on “Rows”.

§         In A1, type: Money Earned

§         In A3, type: Day

·         Formatting Columns

o        Highlight Column B (by single-clicking on the letter B).

o        Click the “Currency Style” Tool .

§          Nothing happened yet, but just wait, you’ll see.

o        Click on B4 (choose the row number, not the inserted data “4”.  B4 is next to the data “1”).

§         Type: 689.43

§         See, it automatically changed to: $689.43

o        In B5 through B13 type the following numbers, one number for each cell: 457.45, 545.45; 984.34, 783.90, 1089.23, 605.33, 324.95, 589.90, 550.32

o        In B3 type: Amount

o        It’s time to save our work.  Save on the A: (your floppy disk) as “Ice Cream Sales”.

·         Formatting the Whole Document

o        The easiest way to “Select All” in Excel is to click on the blank button  in the top, left-hand corner above 1 and to the left of A.

o        Change the font to “Courier” size 12.

o        Single click on any cell to un-highlight the whole document.

·         Fitting the width of the column to fit selection

o        Carefully move the cursor in between the B and C column on top until you see the fat plus change into a thin one with arrow pointing left and right.

o        Increase the size of column B by holding the button down and pulling to the right.

§         If you want Excel to format the column itself then double-click when the pointer is in between columns.

·         Merge and Center

o        If you want to center the contents of a cell over several cells, like you might with a title, you will want to use this function.

§         Open Print Preview.  Close.

·         Back in the regular document view you will see the boundaries of the print area as dashed lines.

§         Highlight A1 (beginning on the cell of A1) to I1.

§         Click the “Center and Merge” Tool .

§         While it is highlighted make the title Bold and increase the size to 16.

·         Changing Data in a cell

o        Click on the Title “Money Earned”

o        Using the mouse click on the formula bar (right below the tool bar).

o        Move the cursor to the end of “Money Earned” and type: Selling Ice Cream

·         Borders

o        Highlight A3 to B13.

o        Click on the “Borders” tool’s drop down list .

o        Choose “All Borders” .

o        Now Choose “Thick Box Border”   for the same highlighted region. This outlines the table.

o        Highlight cells A3 and B3.  Click .

§         While these two cells are highlighted make them bold.

·         Making a Chart

o        Highlight B3 to B13.

o        Click “Chart Wizard”   in the Tool Bar.

o        On the “Chart Type Menu” Choose “Bar”.

o        Choose the first “Chart sub-type” in the top left.  Click .

o        Click  again.

o        In the “Chart Title” Box of the “Titles” tab, change “Amount” to “Ice Cream Sales”.

o        Switch to the Data Labels Tab and click the option button “Show Value”.

o        Click .

·         Moving a Chart

o        Click and hold on any white part of the chart and move the chart next to the table making sure to no go over the dashed line showing the boundary of the page.

·         Click on any part of the spreadsheet (off the chart) and run a Print Preview.

·         Save your work on your disk and close this spreadsheet, but not Excel.

 

XX.             Excel: Table Making

·         Excel excels at a lot more than doing math and making charts.  Among a multitude of other things that we will explore in the Intermediate class, Excel can make useful tables:

o        Open a new spreadsheet.

o        Format the whole document to font size 12.

o        In A1 type: People I Know

o        In A3 type: Last Name

o        In B3 type: First Name

o        In C3 type: Phone Number

o        In D3 type: Village

o        In E3 type: Birthday

o        Make Row 3 in bold.

o        Increase the sizes of the columns to fit the words

o        Center the title over the page and make it bold.

o        Insert the names and information of five people that you know.

o        Put Borders around the table similar to the way we did it in “Ice cream Sales”.

o        Save as “People I Know” on your floppy disk.

·         Sorting

o        To sort the last names and the corresponding information highlight ROWS 4 through 8 and click on  (Sort Ascending tool).  Save.

·         Inserting an Excel table in a Word document

o        The easiest way to do this is to cut and paste.

§         First, open a new Word document, but do not close Excel.

§         Switch to Excel and Highlight A3 to E8.

§         Use the Copy function.

§         Back in the new document in Word, use the paste function.

§         Close Word (without saving) and Excel.

 

SESSION 8

 

XXI.            Class Survey

·         Spend ten minutes completing the class survey and hand it in to the instructor

 

XXII.          Review

·         Review everything in these 15 pages until you know it by heart!  Or, at least know it where you feel comfortable using computers.

 

XXIII.         Final Exam

·         Use your notes, ask the instructor if you have any questions, and Good Luck!

 

XXIV.       Any Extra Time

·         Work on your resume or the “People You Know” spreadsheet.

 

 

Notes for the graduating students:

·         After the final class of “Introduction to Computers”, your computer usage must be paid for.

·         If you help get a friend to register and pay for a future class you will receive a card that is worth three hours free Internet or general computer usage.

 

 

Author of Curriculum:  Paul Neville, Peace Corps Volunteer, Kolovai

Latest Updated: 4 October 2001

 

Back to top

 

Back to Home Page