Transcript Chapter 3 - Home - KSU Faculty Member websites

3
BASIC
APPLICATION
SOFTWARE
McGraw-Hill Technology Education
© 2006 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
Page 58
CE06_PP03-2
Competencies (Page 2 of 2)
Discuss database management systems and database
management features
Describe presentation graphics and presentation
graphics features
Discuss integrated software and software suites
Describe ways to share data between applications
Page 58
CE06_PP03-3
Introduction
Tasks such as business correspondence, sales
projections, graphic design, and data processing
used to require trained specialists.
All these tasks, and many more, can be
accomplished using microcomputers and
application software.
Competent end users in today’s word need to
understand the capabilities of basic application
software including word processors, spreadsheets,
database management systems, and presentation
programs.
CE06_PP03-4
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
Page 60
CE06_PP03-5
Common Features
Graphical User Interface (GUI)
Icons
Windows
Menus
Toolbars
Help
Page 60
CE06_PP03-8
Toolbars
Quick access to commonly used commands
Contain buttons that provide shortcuts
Examples
Standard toolbar
Speech Recognition
Page 60
CE06_PP03-9
Microsoft Office 2007
Newest version of Microsoft Office
New Interface
– Ribbons
– Contextual Tabs
– Galleries
CE06_PP03-10
Web-Based Applications
Access to applications stored on Web sites
Application service providers (ASP)
Special sites
Allows access to Web-based applications
Page 61
CE06_PP03-11
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
CE06_PP03-12
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
Mac: Pages
Mac: SimpleText
Page 64
CE06_PP03-13
Word Processor Features
Word Wrap
Editing
Thesaurus
Spelling and grammar checkers
Find and Replace
Formatting
Font and font sizing
Character effects
Bulleted and numbered lists
Page 64
CE06_PP03-14
Word Processor Examples
Creating a Flyer
Creating a Report
CE06_PP03-15
Creating a Flyer
CE06_PP03-16
Creating a Report
Page 66
CE06_PP03-17
Spreadsheets
Programs that manipulate numeric data
Spreadsheet programs
Microsoft Excel
Corel Quattro Pro
Lotus 1-2-3
Mac: Numbers
Page 67
CE06_PP03-18
Spreadsheet Features
Workbook files
Worksheets
Formulas
Functions
Analytical graphs
or charts
What-if Analysis
Page 67
CE06_PP03-19
Spreadsheet Case
Creating a Sales Forecast
Creating a Chart
Analyzing Your Data
CE06_PP03-20
Creating a Sales Forecast
Page 69
CE06_PP03-21
Creating a Chart
Page 70
CE06_PP03-22
Analyzing Your Data
CE06_PP03-23
Database Management Systems
(DBMS)
A collection of related data
Sets up a structure for data storage
Database programs
Microsoft Access
Corel Paradox
Lotus Approach
Page 72
CE06_PP03-24
Database Features
Relational
Tables
Records
Fields
Record sorting
Queries
Forms
Reports
Page 72
CE06_PP03-25
Database Case
Creating a Database
Creating a Query
CE06_PP03-26
Creating a Database
Page 73
CE06_PP03-27
Creating a Query
Page 74
CE06_PP03-28
Presentation Graphics
Programs that create visually interesting
presentations
Presentation programs
Microsoft PowerPoint
Corel Presentations
Lotus Freelance Graphics
Page 75
CE06_PP03-29
Presentation Graphics Features
Slides
Design templates
Master slide
AutoContent wizard
Page 75
CE06_PP03-30
Presentation Graphics Case
Creating a Presentation
Updating a Presentation
CE06_PP03-31
Creating a Presentation
Page 76
CE06_PP03-32
Updating a Presentation
CE06_PP03-33
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
Page 77
CE06_PP03-34
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
Page 78
CE06_PP03-35
Sharing Data Between
Applications
Copy and paste
Object Linking and Embedding (OLE)
Powerful and useful features
Connects separate applications
Supports sharing and exchanging files
Page 79
CE06_PP03-36
Careers In IT
Computer trainers instruct new users on the latest
software or hardware
Attributes
– Good communication skills
– Teaching experience
– Detail oriented
– IT Experience
– Comfort speaking to groups is a plus
Earning potential of $26,000 to $54,000 annually
CE06_PP03-39
A Look to the Future
Web-based application software helps ease maintenance
Use of the Web to connect to
an application service provider
No programs to install
Allow for a simpler
and cheaper computing
system
Agents will help write papers, pay bills,
and shop on the internet
– Intelligent programs
– Primitive agents currently exist
– Microsoft and “Clippy”
– Next Generation
Page 81
CE06_PP03-40
Discussion Questions (Page 1 of 2)
Explain the difference between generalpurpose and special-purpose applications.
What is the difference between a function and
a formula? How is a formula related to whatif analysis?
What are presentation graphics programs?
How are they used?
Page 88
CE06_PP03-41
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?
Page 88
CE06_PP03-42