Transcript Exploring Microsoft Office 2003

Exploring Microsoft
Office 2007
Essential Computing
Concepts
Robert Grauer and Maryann Barber
CommittedExploring
to Shaping
the Next Generation of IT Experts.
Office 2003 - Grauer and Barber
1
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
Exploring Office 2003 - Grauer and Barber
2
Objectives (2 of 2)




Describe how to safeguard a system
Define FTP and distinguish between a
compressed file and a self-extracting file
Define a local area network
Define the Internet and the World Wide Web
and e-mail
Exploring Office 2003 - Grauer and Barber
3
Any Computer System
Memory
Input
Central processing unit
(CPU)
Output
Auxiliary Storage
Auxiliary
Storage
Auxiliary
Storage
Exploring Office 2003 - Grauer and Barber
4
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
Exploring Office 2003 - Grauer and Barber
5
The PC Today
Exploring Office 2003 - Grauer and Barber
6
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.
Exploring Office 2003 - Grauer and Barber
On
Off
7
The Microprocessor

Original chips were numbered



Intel trademarked its chip as the Pentium



8086, 80286, 80386, 80486
You could buy chips from multiple vendors
Pentium II, Pentium III, Pentium IV
Clock speed (MHz or GHz) differentiates chips
The central processing unit (cpu) or “brain”
of the PC
Exploring Office 2003 - Grauer and Barber
8
Memory

Transient (erased when power turned off)


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



Consider a UPS (uninterrupted power supply)
Keep multiple programs & data files in memory
Graphic-intensive programs demand a lot of memory
The Original PC had 16Kb of memory
Exploring Office 2003 - Grauer and Barber
9
Auxiliary Storage

Floppy Disk


Hard (fixed) disk


No longer standard
30 Gb and higher
Removable storage





CD-ROM
CD-R/CD-RW
DVD/DVD-R/DVD-RW
Zip disks
Tape
Exploring Office 2003 - Grauer and Barber
10
Input Devices
Exploring Office 2003 - Grauer and Barber
11
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
Exploring Office 2003 - Grauer and Barber
12
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
Exploring Office 2003 - Grauer and Barber
13
Lower Resolution (800 x 600)
Displays 20 rows and
8 columns
Exploring Office 2003 - Grauer and Barber
14
Higher Resolution (1024 x 768)
Displays 28 rows and
12 columns
Exploring Office 2003 - Grauer and Barber
15
The Printer

Ink Jet


Laser


Top-of-the line
Four-in-one functionality


Today’s entry level
Printer, scanner, fax,
copier
Network printer
Exploring Office 2003 - Grauer and Barber
16
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
Exploring Office 2003 - Grauer and Barber
17
The Purchase of a PC
Exploring Office 2003 - Grauer and Barber
18
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 manufacturer’s warranty up to an
additional year
Don’t forget the software
Exploring Office 2003 - Grauer and Barber
19
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
Exploring Office 2003 - Grauer and Barber
20
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)
Exploring Office 2003 - Grauer and Barber
21
Windows Explorer
- Sign indicate object
is expanded
Homework is the
active folder
Exploring Office 2003 - Grauer and Barber
Milestones in
Communication is
selected file
22
Maintaining Your System
Windows update takes place
automatically
Double click to install
a printer
Double click to add
new user
Exploring Office 2003 - Grauer and Barber
23
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
Exploring Office 2003 - Grauer and Barber
24
File Compression

Use WinZip (or
compatible) program to
create a compressed
file or archive

Create a self-extracting
file from the archive that
does not require
supporting software
Exploring Office 2003 - Grauer and Barber
25
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!
Exploring Office 2003 - Grauer and Barber
26
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
Exploring Office 2003 - Grauer and Barber
27
A message travels the Internet
All that matters is the beginning and ending address
Exploring Office 2003 - Grauer and Barber
28
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
Exploring Office 2003 - Grauer and Barber
29
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
Exploring Office 2003 - Grauer and Barber
30
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. [email protected]
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
Exploring Office 2003 - Grauer and Barber
31
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
Exploring Office 2003 - Grauer and Barber
32