Transcript Chapter 3 Basic Application Software

Chapter 3
Basic Application Software
College of Computer and Information Science
Key Words & Terms
•
•
•
•
•
•
•
•
•
•
•
•
•
analytical graph: 分析图
application software: 应用软件
AutoContent wizard: 内容提示向导
basic application: 通用软件
bulleted list: 带标注段落
business suite: 商用套件
button:按钮
cell: 单元格
character effect: 文字效果
chart: 图表
column:列，栏
computer trainer：计算机培训师
contextual tab: 文本标签
College of Computer and Information Science
3-2
Key Words & Terms
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
database:数据库
database management system (DBMS):数据库管理系统
database manager:数据库管理系统
design template：设计模板
dialog box:对话框
document:文本
editing:编辑
field:域
find and replace:查找替换
font:字体
font size:字号
form:表
format:格式
formula:公式
function:函数
College of Computer and Information Science
3-3
Key Words & Terms
•
•
•
•
•
•
•
•
•
•
•
•
•
galleries：图片库
grammar checker:语法检查器
graphical user interface (GUI):图形用户界面
home software:家用版软件
home suite:家用套件
icons:图标
integrated package:集成软件包
label:标签
master slide:主幻灯片
menu:菜单
menu bar:菜单栏
numbered list:编号序列
numeric entry:数字栏
College of Computer and Information Science
3-4
Key Words & Terms
•
•
•
•
•
•
•
•
•
•
•
•
•
personal software:个人版软件
personal suite:个人套件
pointer:指针
presentation graphic:演示图形
productivity suite:商用套件
query:查询
range:一组连续的单元格
recalculation:再计算
record:记录
relational database:关系数据库
report:报表
ribbons：ribbon 功能区
row:行
College of Computer and Information Science
3-5
Key Words & Terms
•
•
•
•
•
•
•
•
•
•
•
•
sheet:工作表
slide:幻灯片
software suite:套装软件
sort:排序
specialized applications:专用软件
specialized suite:专用软件套件
speech recognition：语音识别
spelling checker:拼写检查器
spread sheet:电子表格
system software:系统软件
table:表格
text entry:文本栏
College of Computer and Information Science
3-6
Key Words & Terms
•
•
•
•
•
•
•
•
•
•
thesaurus:辞典
toolbar:工具栏
user interface:用户界面
utility suite:工具套件
what-if analysis：推测分析
window:窗口
word processor:文字处理器
word wrap:文字回环/自动换行
workbook file:工作表文件
worksheet:工作表，电子表格
College of Computer and Information Science
3-7
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
Page 62
College of Computer and Information Science
3-8
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
Page 62
College of Computer and Information Science
3-9
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.
Page 63
College of Computer and Information Science
3-10
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 64
College of Computer and Information Science
3-11
Common Features
•
•
•
•
•
Page 64
Graphical User Interface (GUI)
Icons
Windows
Menus
Toolbars
College of Computer and Information Science
3-14
Toolbars
• Quick access to commonly used commands
• Contain buttons that provide shortcuts
• Examples
– Standard Toolbar
– Speech Recognition
Standard 
Page 64
College of Computer and Information Science
3-15
Microsoft Office 2007
• Newest version of Microsoft Office
• New Interface
– Ribbons
– Contextual Tabs
– Galleries
Page 65
College of Computer and Information Science
3-16
Web-Based Applications
• Access to applications stored on Web sites
• Application service providers (ASP)
– Special sites
– Allows access to Web-based applications
Page 64
College of Computer and Information Science
3-17
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
Page 66
College of Computer and Information Science
3-18
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
Page 68
College of Computer and Information Science
3-19
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
Page 68
College of Computer and Information Science
3-20
Word Processor Case
• Creating a Flyer
• Creating a Report
Page 68
College of Computer and Information Science
3-21
Creating a Flyer
Return
Page 69
College of Computer and Information Science
3-22
Creating a Report
Page 70
College of Computer and Information Science
3-23
Spreadsheets
• Programs that manipulate numeric data
• Spreadsheet programs
– Microsoft Excel
– Corel Quattro Pro
– Lotus 1-2-3
Page 71
College of Computer and Information Science
3-24
Spreadsheet Features
•
•
•
•
•
Workbook files
Worksheet or spreadsheet or sheet
Formulas
Functions
Analytical graphs
or charts
• What-if Analysis
Page 71
College of Computer and Information Science
3-25
Spreadsheet Case
• Creating a Sales Forecast
• Creating a Chart
• Analyzing Your Data
Page 72
College of Computer and Information Science
3-26
Creating a Sales Forecast
Return
Page 73
College of Computer and Information Science
3-27
Creating a Chart
Return
Page 74
College of Computer and Information Science
3-28
Analyzing Your Data
Page 75
College of Computer and Information Science
3-29
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 76
College of Computer and Information Science
3-30
Database Features
• Relational
• Tables
– Records
– Fields
• Record sorting
• Queries
• Forms
• Reports
Page 76
College of Computer and Information Science
3-31
Database Case
• Creating a Database
• Creating a Query
Page 76
College of Computer and Information Science
3-32
Creating a Database
Return
Page 77
College of Computer and Information Science
3-33
Creating a Query
Page 78
College of Computer and Information Science
3-34
Presentation Graphics
• Programs that create visually interesting
presentations
• Presentation programs
– Microsoft PowerPoint
– Corel Presentations
– Lotus Freelance Graphics
Page 79
College of Computer and Information Science
3-35
Presentation Graphics Features
•
•
•
•
Page 79
Slides
AutoContent wizard
Design templates
Master slide
College of Computer and Information Science
3-36
Presentation Graphics Case
• Creating a Presentation
• Updating a Presentation
Page 79
College of Computer and Information Science
3-37
Creating a Presentation
Return
Page 80
College of Computer and Information Science
3-38
Updating a Presentation
Page 80
College of Computer and Information Science
3-39
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 81
College of Computer and Information Science
3-40
Software Suites
• Collection of separate application programs
sold as a group
• Four types of suites
–
–
–
–
Page 82
Productivity suite or Business suite
Personal suite or Home suite
Specialized suite
Utility suite
College of Computer and Information Science
3-41
Object Linking
• A link is made from the source file to the
destination file
• Use when you want the destination
document to contain the most updated
data
College of Computer and Information Science
3-42
Object Embedding
• Object from the source file is embedded in
the destination document
• Object becomes part of the destination
document
• Changes made to the embedded object
not reflected in the original source file
College of Computer and Information Science
3-43
Discussion Questions (Page 1 of 2)
• Explain the difference between generalpurpose and special-purpose applications.
• Discuss the common features of most
software programs. Describe the new
interface introduced with 2007 Microsoft
Office.
• What is the difference between a function
and a formula? How is a formula related to
what-if analysis?
Page 92
College of Computer and Information Science
3-45
Discussion Questions (Page 2 of 2)
• What are presentation graphics programs?
How are they used?
• What is the difference between an integrated
package and a software suite? What are the
advantages and disadvantages of each?
Page 92
College of Computer and Information Science
3-46
Crossword Puzzle Answers:
Across
Num.
Down
Clue
Answer
Num.
Clue
Answer
4
Rectangular area that contains
messages.
Window
1
List of commands.
Menu
5
System to organize and retrieve data.
DBMS
2
Rectangular grid of rows and columns
used in programs like Excel.
Worksheet
8
Collection of individual applications.
Software Suite
3
Has records and fields.
Table
6
Controls format and placement of
slides.
Master Slide
7
Requests user input.
Dialog Box
Moves insertion point to next line.
Word Wrap
10
Rearrange records using a field.
Sort
11
Formed by intersection of row and
column.
Cell
14
Collection of related data.
Database
9
16
Flyer, report, newsletter, Web page.
Document
12
Series of cells.
Range
17
These make up a presentation.
Slides
13
A vertical block of cells one cell wide.
Column
18
Question or request for data in a
database.
Query
15
Contain buttons and menus.
Toolbars
College of Computer and Information Science
3-47
Answers for Multiple Choice and Matching
Num
Multiple Choice Answers
Matching Answers
1
D
J
2
D
A
3
B
C
4
D
H
5
D
B
6
A
D
7
B
I
8
B
E
9
C
G
10
D
F
College of Computer and Information Science
3-48
The End of Chapter 3
College of Computer and Information Science
3-49