Exploring Microsoft Office 2003

1
Exploring Microsoft Office 2003
Getting Started Essential Computing
Concepts Robert Grauer and Maryann Barber
Committed to Shaping the Next Generation of
IT Experts.
2
Objectives (1 of 2)

• Describe components of a computer system
• Describe the contribution of IBM, Microsoft, and
  Intel in the evolution of the PC
• Discuss the purchase of a computer system
• Define microprocessor, memory, and auxiliary
  storage
• Describe a digital camera
• Distinguish between system software and
  application software
• Describe the evolution of Microsoft Windows

3
Objectives (2 of 2)

• Describe how to safeguard a system
• Define FTP and distinguish between a compressed
  file and a self-extracting file
• Describe Microsoft Office, InfoPath and OneNote
• Distinguish between HTML and XML
• Define a local area network
• Define the Internet and the World Wide Web and
  e-mail
• Describe Microsoft .Net explain what is meant by
  XML Web services

4
Case Study The Smith Family

• The opening case study focuses on the concept of
  setting up a home network that would link
  together four computers, as well as printers and
  a DSL Internet Connection. Students are asked to
  write a short document describing the advantages
  of a home network and possibly prepare a drawing
  of what the network would look like.

5
Any Computer System
6
The IBM PC

• A combined effort between IBM (credibility and
  marketing), Microsoft (operating system), and
  Intel (microprocessor) introduced in 1981
• IBM was a mainframe company it was hounded by
  antitrust legislation, and did not believe in the
  future of the PC (initial forecast was 250,000
  units)
• The PC was created as an open machine enabling
  independent contractors to develop hardware
  and/or software to improve it
• PC clones quickly followed and the market soon
  exploded IBM has a fraction of the market it
  created

7
The PC Today
8
Inside the PC

• All computers are based on the binary number
  system
• A bit or binary digit has one of two values, zero
  or one
• A byte is the smallest addressable unit of memory
  (8 bits)
• ASCII provides for 256(or 28) characters
• 01000001 A
• 01000010 B
• etc.

On
Off
9
The Microprocessor

• Original chips were numbered
• 8086, 80286, 80386, 80486
• You could buy chips from multiple vendors
• Intel trademarked its chip as the Pentium
• Pentium II, Pentium III, Pentium IV
• Clock speed (MHz or GHz) differentiates chips
• The central processing unit (cpu) or brain of
  the PC

10
Memory

• Transient (erased when power turned off)
• Consider a UPS (uninterrupted power supply)
• Measured in bytes
• 1 Kilobyte 210 characters (1,000 bytes)
• 1 Megabyte 220 characters (1,000,000 bytes)
• 1 Gigabyte 230 characters (1,000,000,000
  bytes)
• Need 256Mb or 512Mb of RAM
• Keep multiple programs data files in memory
• Graphic-intensive programs demand a lot of memory
• The Original PC had 16Kb of memory

11
Auxiliary Storage

• Floppy Disk
• No longer standard
• Hard (fixed) disk
• 30 Gb and higher
• Removable storage
• CD-ROM
• CD-R/CD-RW
• DVD/DVD-R/DVD-RW
• Zip disks
• Tape

12
Input Devices
13
The Monitor

• Resolution is expressed in picture elements or
  pixels (800 x 600 or 1024 x 768)
• The higher the resolution, the more you can see
  at one time.
• Larger monitors enable you to you run at higher
  resolutions e.g., 19 to run 1024 x 768
  comfortably
• A graphics card speeds processing

14
Lower Resolution (800 x 600)
Displays 20 rows and 8 columns
15
Higher Resolution (1024 x 768)
Displays 28 rows and 12 columns
16
The Printer

• Ink Jet
• Todays entry level
• Laser
• Top-of-the line
• Four-in-one functionality
• Printer, scanner, fax, copier
• Network printer

17
The Digital Camera

• An image is stored on a photosensitive computer
  chip, which converts the image to a series of
  pixels
• 2 megapixels is entry-level
• 3 megapixels is better
• There is no film images are stored in memory
  the more memory the more pictures
• 64Mb to 128Mb is suggested

18
The Rise of the Personal Computer

• Altair 8800 1975
• Apple II 1977
• IBM PC 1981
• First Portable PC 1983
• Apple Macintosh 1984
• Palm Pilot 1000 1996
• Apple iMac 1998

(b) iMac
19
The Purchase of a PC
20
The Purchase of a PC (continued)

• Insist on an unconditional 30-day return policy
  for full refund
• Insist on a price guarantee i.e., if the price
  goes down within 30 days, you are entitled to the
  rebate
• Pay with a credit card
• Leverage to enforce above items
• Double the manufacturers warranty up to an
  additional year
• Dont forget the software

21
Software

• System Software Microsoft Windows
• Windows XP Home Edition
• Windows XP Professional Edition
• What Windows does not have - File Compression,
  Antivirus, Graphical FTP
• Application Software Microsoft Office
• Core applications Word, Excel, Access, and
  PowerPoint
• Personal Information Manager Outlook
• Other applications FrontPage and Publisher
• New to Office 2003 - OneNote and InfoPath

22
Disk and File Management

• A file is a set of instructions or data
• Program file Microsoft Word or Microsoft Excel
• Data File Document or workbook
• Copy, move, rename or delete a file
• A folder allows us to organize our files
• May contain files and/or other folders
• A back up strategy is critical
• What (data), When (whenever it changes), Where
  (off site), How (Windows Explorer), and Who (you)

23
Windows Explorer
- Sign indicate object is expanded
Milestones in Communication is selected file
Homework is the active folder
24
Maintaining Your System
Windows update takes place automatically
Double click to install a printer
Double click to add new user
25
Antivirus Software

• A computer virus is an actively infectious
  program that can erase data and/or alter the way
  your computer works
• Worms and Trojan horses are other types of
  infectious programs, but all are bad
• Computer viruses are spread through email, and/or
  infected floppy disks
• Windows does not include an antivirus program
  i.e., you must buy it separately and update it
  frequently

26
File Transfer Protocol
Graphical FTP is not part of Windows
Where you will FTP the file
Click to upload
Selected file to FTP
27
File Compression

• Create a self-extracting file from the archive
  that does not require supporting software

• Use WinZip (or compatible) program to create a
  compressed file or archive

28
Introduction to Networks

• Most people work in a network environment
• Home network
• Local Area Network (LAN)
• Wide Area Network (WAN)
• The physical structure includes interface cards,
  cables, hubs, switches, and routers
• Protect your password!

29
From LAN to WAN
(a) Home Network
(b) Local Area Network
30
From LAN to WAN (continued)
(c) Wide Area Network
31
The Internet and World Wide Web

• The Internet
• Network of networks
• Began in 1969 as a government project
• Original network had 4 computers
• No central authority and thus impossible to know
  the exact size

• The World Wide Web
• A subset of the Internet consisting of computers
  that store hypertext documents
• Invented by Tim Berners Lee who wanted to share
  notes with colleagues at the European Particle
  Physics Laboratory (CERN) in Switzerland

32
A message travels the Internet

• All that matters is the beginning and ending
  address

33
Acronyms Abound

• HTTP HyperText Transfer Protocol is used to
  transmit Web documents
• HTTPS Secure protocol for confidential
  transactions
• HTML The language in which all Web documents
  are displayed
• TCP/IP A suite of protocols that allows
  multiple platforms to communicate
• ISP Internet Service Provider

34
The Exploring Office Web Site
Internet Explorer is the browser
Web address (or URL)
HTTP protocol
35
The Commercialization of Cyberspace

• E-commerce is the exchange of goods and services
  via the Internet. It requires a buyer and seller,
  and a place to meet

• Advantages for the Seller
• Open 24/7
• Shoppers from anywhere
• Virtual inventory is cheaper and extensive
• Lower transaction costs
• Target your customers

• Advantages for the Buyer
• Open 24/7
• Never leave home
• Easy to view and explore product line
• Comparison shop
• Web site knows you

36
E-Mail (Electronic Mail)

• E-mail is simply a means of sending messages via
  computer
• There should be no expectation of privacy
• Every e-mail address is unique and consists of
  two parts, a username and a host computer e.g.
  johndoe_at_anyschool.edu
• You can obtain an account at school, pay for an
  account through an ISP such as AOL, or get free
  email accounts at sites like www.hotmail.com or
  www.yahoo.com

37
The Mail Folders

• Inbox new messages as well as messages that
  have been read
• Outbox messages not yet sent
• Sent items messages that have been sent (moved
  here from outbox)
• Deleted items messages deleted from any folder
• Custom folders additional folders created by
  the user

38
Additional E-mail Capabilities

• Address Book
• Contains the e-mail addresses of frequent
  contacts
• Enables you to enter an alias (e.g., Bob
  instead of the complete address)
• Distribution List
• A set of e-mail addresses stored under one name
• Ideal for your professor to e-mail the class

39
Parts of the E-mail Message
Subject
Recipients
Attachment
Message text
40
Microsoft. NET

• Combination of technologies that collectively
  build complex applications over the Internet
• Based on interoperability in which a user can
  access data in any application, over any
  platform, over any device
• Uses XML Web Services
• An industry standard for data structuring
• Service is developed once
• Exported to different applications
• Microsoft Passport is the best known XML Web
  service

41
Microsoft .Net (continued)
42
Summary

• Understand components of a computer system for
  usage and purchasing
• Distinguish between system software and
  application software
• Understand disk and file management
• Understand tools, such as antivirus software,
  FTP, and File Compression
• Learn about Networks, the Internet, WWW, and
  E-mail
• Discover new Microsoft Applications

43
Questions?