Microsoft Excel

Welcome to Excel 2003! I hope you will enjoy learning about Excel Spreadsheets in this class. A spreadsheet is a set of columns and rows with or without lines, like a table, used to organize information. This information quite often involves numbers but does not have to.

Microsoft's two main products are Windows, which is an Operating System, and the Office Products, which include Word, Excel, PowerPoint, Access, and Outlook. Some versions of Office also come with Publisher. We will be using Excel 2003. There has been a recent release of Excel 2007 which looks quite different than its earlier versions. The basics have always been the same. The following are a few things you should already know how to do:

  • Start up your computer
  • Use the left and right mouse buttons. Left-click to make something happen; right-click to see what options are available
  • Start up programs using icons on the desktop AND the Start menu
  • Locate the keyboard-note the Shift, Crtl, Spacebar, Caps Lock, Tab, Enter or Return, Delete, Backspace, arrow and Esc keys
  • Motivation to search and read about what you are interested in
  • Willingness to EXPLORE and NOT be afraid of technology-it will not blow up!!!

Materials you may need

  • Notebook and pencil or pen
  • Headphones?

***Please put cell phones on vibrate or turn off during class***

CLASS BLOG!!!!!

http://pelionmiddleschool.edublogs.org/


Class Schedule

Day 1

Day 3

6-6:30 Introduction, paperwork, etc./getting to my web page 6-6:15 Questions and Answers/Class Blog (reminder)
6:30-7:15 Windows Review--WHAT IS EXCEL? (Example=Survey w/chart) 6:15-6:45
7:15-7:45 Cells, adjustments, Exploring Menus, toolbars/Getting help!/Class Blog 6:45-7:30
7:45-8 Break 7:30-7:45 Break
8-8:15 PT Training Session 1 7:30-8:15

8:15-9 More Examples
look at web pages below

basicbudget

cheese

clemolina


expanded budget

stolen items

weekly pricelist

times table

8:15-9 Use what you know
http://support.microsoft.com/kb/318117 labels  

Day 2

Day 4

6-6:15 Questions and Answers/Class Blog

copy DDCMyDocs folder to your desktop

6-6:15 Questions and Answers/Class Blog (reminder)
6:15-6:45  
6:45-7:30 Templates and Wizards--Make an invoice, etc  
7:30-7:45 Break  
7:30-8:15  

8:15-9 continue or try another type of project/questions
Other resources-books, software, podcasts!

shortcut keys, organizing files and folders,

Terms (If I mention a term not listed, please write it down and ask me about it when opportunity rises)

Alignment (Left, Center, Right)
Application
Backspace Key
Bold
Bullet
Clipart
Cursor
Delete Key
Desktop
Double-click
Double-Space
Drop-down Menu
Edit Menu
Enter Key
Escape Key
File
File Menu
Folder
Font
Font Size
Hover
Insertion point
Italics
Left-Click
Maximize
Menu
Minimize
Operating System
Right-Click
Select/selection
Shift Key
Single-Space
Spacebar
Start Menu
Tab
Task Pane
Title Bar
Toolbar
Underlined

Cell
Column
Row
Formula Bar
Formula
Standard Toolbar
Formatting Toolbar
Workbook
Worksheet
Default
G:\ Drive
Network Drives
Local Drives


The Excel Interface

Can you name the elements in this picture?


OBJECTIVES

Some Objectives from the Microsoft Office Specialist Site

Free Tutorials

http://www.computer-training-software.com/excel-2003.htm **** FREE VIDEOS! (see left side- "Getting to Know Word")

http://www.lexington1.net/technology/instruct/tutorials/lyden.htm ***** Very Helpful!

Just Excel Basics ***** START HERE*****

http://wordtips.vitalnews.com/

http://www.evisa.com/e/sbooks/lib10/sbooktoc.htm
http://www.internet4classrooms.com/on-line_word.htm ****
http://www.educationonlineforcomputers.com/blogs/Free_Microsoft_Office_Training_Tutorial_Resources.php
 
http://www.fgcu.edu/support/office2000/word/index.html

Books

http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?z=y&endeca=1&isbn=0735615233&itm=10
http://word.mvps.org/Tutorials/Books/Word2003PersonalTrainer.htm

Quizzes

http://www.writefix.com/ICDL/mod3.htm
http://www.internet4classrooms.com/msword_toolbar.htm
 
 
 

Other Office Applications

http://www.internet4classrooms.com/on-line.htm
 
 
Home