Transcript CompleteChapter03

Chapter 3
Basic Application Software
McGraw-Hill/Irwin
Copyright © 2007 by The McGraw-Hill Companies, Inc. All rights reserved.
Competencies (Page 1 of 2)
• Discuss common features of most software
applications
• Discuss word processors and word processing
features
• Describe spreadsheets and spreadsheet
features
• Discuss database management systems and
database management features
3-2
Page 62
Competencies (Page 2 of 2)
• Describe presentation graphics and presentation
graphics features
• Discuss integrated software and software suites
• Describe ways to share data between
applications
3-3
Page 62
Application Software
• Application Software is end user software that is
used to accomplish a variety of tasks
• Two categories
– Basic applications (focus of this chapter)
– Specialized applications
3-4
Page 64
Common Features
•
•
•
•
•
•
Graphical User Interface (GUI)
Icons
Windows
Menus
Help
Toolbars
3-7
Page 64
Toolbars
• Quick access to commonly used commands
• Contain buttons that provide shortcuts
• Examples
– Standard Toolbar
– Speech Recognition
Standard 
3-8
Page 64
Web-Based Applications
• Access to applications stored on Web sites
• Application service providers (ASP)
– Special sites
– Allows access to Web-based applications
3-9
Page 64
Speech Recognition
• Allows your voice to control application software
• For best results, use your voice and mouse or
keyboard
– Train the software
– Control a program
– Dictate a document
3-10
Page 66
Word Processors
• Used to create text-based documents
– Memos, letters, and faxes
– Newsletters, manuals, and brochures
• Word processing programs
– Microsoft Word
– Corel WordPerfect
– Lotus Word Pro
3-11
Page 68
Word Processor Features
• Word Wrap
• Editing
– Thesaurus
– Find and Replace
– Spelling and grammar checkers
• Formatting
– Font and font sizing
– Character effects
– Bulleted and numbered lists
3-12
Page 68
Word Processor Case
• Creating a Flyer
• Creating a Report
3-13
Page 68
Creating a Flyer
Return
Page 69
3-14
Creating a Report
3-15
Page 70
Spreadsheets
• Programs that manipulate numeric data
• Spreadsheet programs
– Microsoft Excel
– Corel Quattro Pro
– Lotus 1-2-3
3-16
Page 71
Spreadsheet Features
•
•
•
•
•
Workbook files
Worksheet or spreadsheet or sheet
Formulas
Functions
Analytical graphs
or charts
• What-if Analysis
3-17
Page 71
Spreadsheet Case
• Creating a Sales Forecast
• Creating a Chart
• Analyzing Your Data
3-18
Page 72
Creating a Sales Forecast
Return
3-19
Page 73
Creating a Chart
Return
Page 74
3-20
Analyzing Your Data
3-21
Page 75
Database Management
Systems DBMS
• A collection of related data
• Sets up a structure for data storage
• Database programs
– Microsoft Access
– Corel Paradox
– Lotus Approach
3-22
Page 76
Database Features
• Relational
• Tables
– Records
– Fields
•
•
•
•
Record sorting
Queries
Forms
Reports
3-23
Page 76
Database Case
• Creating a Database
• Creating a Query
3-24
Page 77
Creating a Database
Return
Page 77
3-25
Creating a Query
3-26
Page 78
Presentation Graphics
• Programs that create visually interesting
presentations
• Presentation programs
– Microsoft PowerPoint
– Corel Presentations
– Lotus Freelance Graphics
3-27
Page 79
Presentation Graphics Features
•
•
•
•
Slides
AutoContent wizard
Design templates
Master slide
3-28
Page 79
Presentation Graphics Case
• Creating a Presentation
• Updating a Presentation
3-29
Page 80
Creating a Presentation
Return
3-30
Page 80
Updating a Presentation
3-31
Page 80
Integrated Packages
• A single program that provides the functionality
of several widely used programs
– Popular with many home users
– Classified as personal or home software
• Advantages are cost and simplicity
• Disadvantages are limited functions
• Popular packages are
Microsoft Works & Apple Works
3-32
Page 81
Software Suites
• Collection of separate application programs sold
as a group
• Four types of suites
–
–
–
–
Productivity suite or Business suite
Personal suite or Home suite
Specialized suite
Utility suite
3-33
Page 82
Sharing Data Between
Applications
• Copy and paste
• Object Linking and Embedding (OLE)
– Powerful and useful features
– Connects separate applications
– Supports sharing and exchanging files
• How Object Linking and Embedding Work
3-34
Page 83
A Look to the Future
• Agents will help write papers, pay bills, and shop
on the internet
–
–
–
–
Intelligent programs
Primitive agents currently exist
Microsoft and “Clippy”
Next Generation
3-39
Page 86
Discussion Questions (Page 1 of 2)
• Explain the difference between general-purpose
and special-purpose applications.
• What is the difference between a function and a
formula? How is a formula related to what-if
analysis?
• What are presentation graphics programs? How
are they used?
3-40
Page 94
Discussion Questions (Page 2 of 2)
• Explain the difference between a linked object
and an embedded object. What are the
advantages of OLE?
• What is the difference between an integrated
package and a software suite? What are the
advantages and disadvantages of each?
3-41
Page 94