Class Outline
·
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.
·
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.
·
Windows
is an Operating System made by the company Microsoft (owned by Bill Gates, the
richest man in the world who lives in
·
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.
·
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.
§
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
·
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
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
§
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
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 “
§
Click on “
§
Click on “
§
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 “
§
Go back to the “Home” screen
o
Spend a few minutes looking up whatever information you like. How about finding
·
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.
·
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).
·
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.
·
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
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.
·
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.
·
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.
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.
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 (“
§
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
·
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
·
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.
·
Open the A: drive in My Computer.
·
In the File menu select follow the “New” menu and select “Folder”.
·
Type: “Names” and hit enter.
·
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.
·
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.
·
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
·
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.
·
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.
·
Spend ten minutes completing the class survey and hand it in to the
instructor
·
Review everything in these 15 pages until you know it by heart! Or, at least know it where you feel
comfortable using computers.
·
Use
your notes, ask the instructor if you have any questions, and Good Luck!
·
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: