320 likes | 537 Views
Exploring Microsoft Office 2007. Essential Computing Concepts Robert Grauer and Maryann Barber. Committed to Shaping the Next Generation of IT Experts. Objectives (1 of 2). Describe components of a computer system
E N D
Exploring Microsoft Office 2007 Essential Computing Concepts Robert Grauer and Maryann Barber Committed to Shaping the Next Generation of IT Experts. Exploring Office 2003 - Grauer and Barber
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
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
Memory Input Central processing unit (CPU) Output Auxiliary Storage Auxiliary Storage Auxiliary Storage Any Computer System Exploring Office 2003 - Grauer and Barber
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
The PC Today Exploring Office 2003 - Grauer and Barber
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 Exploring Office 2003 - Grauer and Barber
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 Exploring Office 2003 - Grauer and Barber
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 Exploring Office 2003 - Grauer and Barber
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 Exploring Office 2003 - Grauer and Barber
Input Devices Exploring Office 2003 - Grauer and Barber
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
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
Lower Resolution (800 x 600) Displays 20 rows and 8 columns Exploring Office 2003 - Grauer and Barber
Higher Resolution (1024 x 768) Displays 28 rows and 12 columns Exploring Office 2003 - Grauer and Barber
The Printer • Ink Jet • Today’s entry level • Laser • Top-of-the line • Four-in-one functionality • Printer, scanner, fax, copier • Network printer Exploring Office 2003 - Grauer and Barber
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
The Purchase of a PC Exploring Office 2003 - Grauer and Barber
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
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
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
Windows Explorer - Sign indicate object is expanded Milestones in Communication is selected file Homework is the active folder Exploring Office 2003 - Grauer and Barber
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
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
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 Exploring Office 2003 - Grauer and Barber
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
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 The Internet and World Wide Web Exploring Office 2003 - Grauer and Barber
A message travels the Internet All that matters is the beginning and ending address Exploring Office 2003 - Grauer and Barber
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
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 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’ Exploring Office 2003 - Grauer and Barber
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@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 Exploring Office 2003 - Grauer and Barber
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