College of Computer and Information Science Chapter 3 Basic Application Software.
46
College of Computer and Information Science College of Computer and Information Science Chapter 3 Basic Application Software
-
Upload
rose-richard -
Category
Documents
-
view
217 -
download
1
Transcript of College of Computer and Information Science Chapter 3 Basic Application Software.
College of Computer and Information ScienceCollege of Computer and Information Science
Chapter 3
Basic Application Software
College of Computer and Information Science 3-2
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-3
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-4
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-5
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-6
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-7
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-8
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-9
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-10
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-11
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-14
Common Features
• Graphical User Interface (GUI)• Icons• Windows• Menus• Toolbars
Page 64
College of Computer and Information Science 3-15
Toolbars
• Quick access to commonly used commands• Contain buttons that provide shortcuts• Examples
– Standard Toolbar– Speech Recognition
Page 64
Standard
College of Computer and Information Science 3-16
Microsoft Office 2007
• Newest version of Microsoft Office• New Interface
– Ribbons– Contextual Tabs– Galleries
Page 65
College of Computer and Information Science 3-17
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-18
Speech Recognition
Page 66
• 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
College of Computer and Information Science 3-19
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-20
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-21
Word Processor Case
• Creating a Flyer
• Creating a Report
Page 68
College of Computer and Information Science 3-22
Creating a Flyer
Page 69
Return
College of Computer and Information Science 3-23
Creating a Report
Page 70
College of Computer and Information Science 3-24
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-25
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-26
Spreadsheet Case
• Creating a Sales Forecast
• Creating a Chart
• Analyzing Your Data
Page 72
College of Computer and Information Science 3-27
Creating a Sales Forecast
Page 73
Return
College of Computer and Information Science 3-28
Creating a Chart
Page 74
Return
College of Computer and Information Science 3-29
Analyzing Your Data
Page 75
College of Computer and Information Science 3-30
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-31
Database Features
• Relational• Tables
– Records– Fields
• Record sorting• Queries• Forms• Reports
Page 76
College of Computer and Information Science 3-32
Database Case
• Creating a Database
• Creating a Query
Page 76
College of Computer and Information Science 3-33
Creating a Database
Page 77
Return
College of Computer and Information Science 3-34
Creating a Query
Page 78
College of Computer and Information Science 3-35
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-36
Presentation Graphics Features
• Slides• AutoContent wizard• Design templates• Master slide
Page 79
College of Computer and Information Science 3-37
Presentation Graphics Case
• Creating a Presentation
• Updating a Presentation
Page 79
College of Computer and Information Science 3-38
Creating a Presentation
Page 80
Return
College of Computer and Information Science 3-39
Updating a Presentation
Page 80
College of Computer and Information Science 3-40
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-41
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 82
College of Computer and Information Science 3-42
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-43
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-45
• Explain the difference between general-purpose 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?
Discussion Questions (Page 1 of 2)
Page 92
College of Computer and Information Science 3-46
• 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
Discussion Questions (Page 2 of 2)
College of Computer and Information Science 3-47
Crossword Puzzle Answers:Across
Num. Clue Answer
4 Rectangular area that contains messages.
Window
5 System to organize and retrieve data. DBMS
8 Collection of individual applications. Software Suite
10 Rearrange records using a field. Sort
11 Formed by intersection of row and column.
Cell
14 Collection of related data. Database
16 Flyer, report, newsletter, Web page. Document
17 These make up a presentation. Slides
18 Question or request for data in a database.
Query
Down
Num. Clue Answer
1 List of commands. Menu
2 Rectangular grid of rows and columns used in programs like Excel.
Worksheet
3 Has records and fields. Table
6 Controls format and placement of slides.
Master Slide
7 Requests user input. Dialog Box
9 Moves insertion point to next line. Word Wrap
12 Series of cells. Range
13 A vertical block of cells one cell wide. Column
15 Contain buttons and menus. Toolbars
College of Computer and Information Science 3-48
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-49
The End of Chapter 3
