Chapter3
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Chapter3 as PDF for free.
More details
- Words: 1,020
- Pages: 7
Competencies (Page 1 of 2)
Chapter 3 Basic Application Software
McGraw-Hill/Irwin
Copyright © 2008 by The McGraw-Hill Companies, Inc. All rights reserved.
• 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
Introduction
Competencies (Page 2 of 2)
• 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.
• Describe presentation graphics and presentation graphics features • Discuss integrated software and software suites • Describe ways to share data between applications
3-3
Page 62
3-4
Page 63
Application Software
Basic Applications
• Application software is end user software that is used to accomplish a variety of tasks • Two categories
• Basic applications are also called generalpurpose • Common types
– Basic applications (focus of this chapter) – Specialized applications
– – – –
Word processors Spreadsheets Database management systems Presentation graphics
Return Page 64
3-5
Page 64
3-6
1
Specialized Applications
Common Features
• Also known as special-purpose applications • Includes thousands of other programs that are more narrowly focused on specific disciplines and occupations • Best known
• • • • •
– Graphic programs (Photoshop, CorelDraw,Picasa) – Audio & video editors(SoundForge9, VegasPro8) – Multimedia creation programs (Video Avatar, CyberLink PowerDirector) – Web authoring (MacroMedia Dreamweaver, Microsoft FrontPage) – Virtual reality programs (Real Space Viewer 2.0) 3-7
Page 64
Graphical User Interface (GUI) Icons Windows Menus Toolbars
3-8
Page 64
Toolbars
Microsoft Office 2007
• Quick access to commonly used commands • Contain buttons that provide shortcuts • Examples – Standard Toolbar – Speech Recognition
• Newest version of Microsoft Office • New Interface – Ribbons – Contextual Tabs – Galleries
Standard
3-9
Page 64
3-10
Page 65
Web-Based Applications
Speech Recognition
• Access to applications stored on Web sites • Application service providers (ASP)
• Allows your voice to control application software • For best results, use your voice and mouse or keyboard
– Special sites – Allows access to Web-based applications
– Train the software – Control a program – Dictate a document
Page 64
3-11
Page 66
3-12
2
Word Processors
Word Processor Features
• Used to create text-based documents
• Word Wrap • Editing
– Memos, letters, and faxes – Newsletters, manuals, and brochures
– Thesaurus – Find and Replace – Spelling and grammar checkers
• Word processing programs – Microsoft Word – Corel WordPerfect – Lotus Word Pro
• Formatting – Font and font sizing – Character effects – Bulleted and numbered lists 3-13
Page 68
3-14
Page 68
Word Processor Case
Creating a Flyer
• Creating a Flyer • Creating a Report
3-15
Page 68
Return Page 69
Creating a Report
3-16
Spreadsheets • Programs that manipulate numeric data • Spreadsheet programs – Microsoft Excel – Corel Quattro Pro – Lotus 1-2-3
Page 70
3-17
Page 71
3-18
3
Spreadsheet Features
Spreadsheet Case
• • • • •
Workbook files Worksheet or spreadsheet or sheet Formulas Functions Analytical graphs or charts • What-if Analysis
• Creating a Sales Forecast • Creating a Chart • Analyzing Your Data
3-19
Page 71
3-20
Page 72
Creating a Sales Forecast
Creating a Chart
Return 3-21
Page 73
Return Page 74
3-22
Database Management Systems (DBMS)
Analyzing Your Data
• A collection of related data • Sets up a structure for data storage • Database programs – Microsoft Access – Corel Paradox – Lotus Approach
Page 75
3-23
Page 76
3-24
4
Database Case
Database Features • Relational • Tables – Records – Fields • Record sorting • Queries • Forms • Reports
• Creating a Database • Creating a Query
3-25
Page 76
Creating a Database
Return Page 77
Creating a Query
3-27
3-28
Page 78
Presentation Graphics
Presentation Graphics Features
• Programs that create visually interesting presentations
• • • •
• Presentation programs – Microsoft PowerPoint – Corel Presentations – Lotus Freelance Graphics
Page 79
3-26
Page 76
3-29
Page 79
Slides AutoContent wizard Design templates Master slide
3-30
5
Presentation Graphics Case
Creating a Presentation
• Creating a Presentation • Updating a Presentation
Return 3-31
Page 79
3-32
Page 80
Updating a Presentation
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-33
Page 80
3-34
Page 81
Software Suites
Careers In IT
• Collection of separate application programs sold as a group • Four types of suites – – – –
• Computer trainers instruct new users on the latest software or hardware • Attributes
Productivity suite or Business suite Personal suite or Home suite Specialized suite Utility suite
– – – – –
Good communication skills Teaching experience Detail oriented IT Experience Comfort speaking to groups is a plus
• Earning potential of $26,000 to $54,000 Return annually Page 82
3-35
Page 83
3-36
6
Discussion Questions (Page 1 of 2)
A Look to the Future • Agents will help write papers, pay bills, and shop on the internet – – – –
• 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?
Intelligent programs Primitive agents currently exist Microsoft and “Clippy” Next Generation
Page 84
3-37
Page 92
3-38
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
3-39
7
Chapter 3 Basic Application Software
McGraw-Hill/Irwin
Copyright © 2008 by The McGraw-Hill Companies, Inc. All rights reserved.
• 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
Introduction
Competencies (Page 2 of 2)
• 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.
• Describe presentation graphics and presentation graphics features • Discuss integrated software and software suites • Describe ways to share data between applications
3-3
Page 62
3-4
Page 63
Application Software
Basic Applications
• Application software is end user software that is used to accomplish a variety of tasks • Two categories
• Basic applications are also called generalpurpose • Common types
– Basic applications (focus of this chapter) – Specialized applications
– – – –
Word processors Spreadsheets Database management systems Presentation graphics
Return Page 64
3-5
Page 64
3-6
1
Specialized Applications
Common Features
• Also known as special-purpose applications • Includes thousands of other programs that are more narrowly focused on specific disciplines and occupations • Best known
• • • • •
– Graphic programs (Photoshop, CorelDraw,Picasa) – Audio & video editors(SoundForge9, VegasPro8) – Multimedia creation programs (Video Avatar, CyberLink PowerDirector) – Web authoring (MacroMedia Dreamweaver, Microsoft FrontPage) – Virtual reality programs (Real Space Viewer 2.0) 3-7
Page 64
Graphical User Interface (GUI) Icons Windows Menus Toolbars
3-8
Page 64
Toolbars
Microsoft Office 2007
• Quick access to commonly used commands • Contain buttons that provide shortcuts • Examples – Standard Toolbar – Speech Recognition
• Newest version of Microsoft Office • New Interface – Ribbons – Contextual Tabs – Galleries
Standard
3-9
Page 64
3-10
Page 65
Web-Based Applications
Speech Recognition
• Access to applications stored on Web sites • Application service providers (ASP)
• Allows your voice to control application software • For best results, use your voice and mouse or keyboard
– Special sites – Allows access to Web-based applications
– Train the software – Control a program – Dictate a document
Page 64
3-11
Page 66
3-12
2
Word Processors
Word Processor Features
• Used to create text-based documents
• Word Wrap • Editing
– Memos, letters, and faxes – Newsletters, manuals, and brochures
– Thesaurus – Find and Replace – Spelling and grammar checkers
• Word processing programs – Microsoft Word – Corel WordPerfect – Lotus Word Pro
• Formatting – Font and font sizing – Character effects – Bulleted and numbered lists 3-13
Page 68
3-14
Page 68
Word Processor Case
Creating a Flyer
• Creating a Flyer • Creating a Report
3-15
Page 68
Return Page 69
Creating a Report
3-16
Spreadsheets • Programs that manipulate numeric data • Spreadsheet programs – Microsoft Excel – Corel Quattro Pro – Lotus 1-2-3
Page 70
3-17
Page 71
3-18
3
Spreadsheet Features
Spreadsheet Case
• • • • •
Workbook files Worksheet or spreadsheet or sheet Formulas Functions Analytical graphs or charts • What-if Analysis
• Creating a Sales Forecast • Creating a Chart • Analyzing Your Data
3-19
Page 71
3-20
Page 72
Creating a Sales Forecast
Creating a Chart
Return 3-21
Page 73
Return Page 74
3-22
Database Management Systems (DBMS)
Analyzing Your Data
• A collection of related data • Sets up a structure for data storage • Database programs – Microsoft Access – Corel Paradox – Lotus Approach
Page 75
3-23
Page 76
3-24
4
Database Case
Database Features • Relational • Tables – Records – Fields • Record sorting • Queries • Forms • Reports
• Creating a Database • Creating a Query
3-25
Page 76
Creating a Database
Return Page 77
Creating a Query
3-27
3-28
Page 78
Presentation Graphics
Presentation Graphics Features
• Programs that create visually interesting presentations
• • • •
• Presentation programs – Microsoft PowerPoint – Corel Presentations – Lotus Freelance Graphics
Page 79
3-26
Page 76
3-29
Page 79
Slides AutoContent wizard Design templates Master slide
3-30
5
Presentation Graphics Case
Creating a Presentation
• Creating a Presentation • Updating a Presentation
Return 3-31
Page 79
3-32
Page 80
Updating a Presentation
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-33
Page 80
3-34
Page 81
Software Suites
Careers In IT
• Collection of separate application programs sold as a group • Four types of suites – – – –
• Computer trainers instruct new users on the latest software or hardware • Attributes
Productivity suite or Business suite Personal suite or Home suite Specialized suite Utility suite
– – – – –
Good communication skills Teaching experience Detail oriented IT Experience Comfort speaking to groups is a plus
• Earning potential of $26,000 to $54,000 Return annually Page 82
3-35
Page 83
3-36
6
Discussion Questions (Page 1 of 2)
A Look to the Future • Agents will help write papers, pay bills, and shop on the internet – – – –
• 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?
Intelligent programs Primitive agents currently exist Microsoft and “Clippy” Next Generation
Page 84
3-37
Page 92
3-38
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
3-39
7
