Transcript Exploring Microsoft Office 2003

Exploring Microsoft
Office 2003
Getting Started: 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
Central processing unit
(CPU)
Input
Output
Memory
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




Consider a UPS (uninterrupted power supply)
1 Kilobyte = 210 characters (~1,000 bytes)
1 Megabyte = 220 characters (~1,000,000 bytes)
1 Gigabyte = 230 characters (~1,000,000,000 bytes)
The Original PC had 16KB of memory
Exploring Office 2003 - Grauer and Barber
9
Auxiliary Storage

Floppy Disk



No longer standard
Hard (fixed) disk
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
The term megapixel with regard to digital
cameras refers to the number of image
sensor elements (i.e. 2048 x 1536 = 3.1
megapixels)
There is no film; images are stored in
memory; the more memory the more
pictures
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 XP 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 – 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
Computer Viruses


A computer virus is an actively infectious
program that can erase data and/or alter the
way your computer works. A virus must
replicate but requires a host program to move.
Computer viruses are spread through email,
and/or infected media (flash drive, CD-R etc).
Exploring Office 2003 - Grauer and Barber
24
Worms and Trojan Horses




Worms and Trojan Horses are malicious
software but are not viruses.
Worms self-replicate but do not require a host to
move from system to system.
Trojan horses do not self-replicate and appear
to users as valid software. Having a Trojan
installed on your system allows for unauthorized
access.
Collectively viruses, worms and Trojan horses
are referred to as malware (malicious software)
Exploring Office 2003 - Grauer and Barber
25
Antivirus Software


Antivirus software is used to prevent, detect
and remove malware.
Some popular antivirus software





Symantec Norton
McAfee
BitDefender
AVG
Kaspersky
Exploring Office 2003 - Grauer and Barber
26
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
27
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
28
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
1991 Public debut of the
WWW
Exploring Office 2003 - Grauer and Barber
29
A message travels the Internet
All that matters is the beginning and ending address
Exploring Office 2003 - Grauer and Barber
30
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

FTP – File Transfer Protocol used to transfer any
file type over a network.
Exploring Office 2003 - Grauer and Barber
31
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
32
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, www.yahoo.com or
www.google.com
Exploring Office 2003 - Grauer and Barber
33
E-mail Spam



E-mail Spam – is unsolicited email sent to
numerous recipients
In recent years over 90% of all e-mail sent is
spam.
Most spam is designed to advertise some
product or service.
Exploring Office 2003 - Grauer and Barber
34
Phishing



Phishing – attempting to acquire information
such as usernames, passwords, credit card
information online by masquerading as a
trusted entity.
Email is often used to initiate phishing scams
User will be provided a link to a website that
has the same look at the legitimate one.
Exploring Office 2003 - Grauer and Barber
35
Phishing via Spam E-Mail
Exploring Office 2003 - Grauer and Barber
36
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
37