1 / 27

Basic Application Software Competencies

This chapter discusses the common features of software applications such as word processors, spreadsheets, database management systems, presentation graphics, and integrated software. It also describes ways to share data between applications.

denita
Download Presentation

Basic Application Software Competencies

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 3 CHAPTER BASIC APPLICATION SOFTWARE

  2. 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

  3. Competencies (Page 2 of 2) • Discuss database management systems • Describe presentation graphics • Discuss integrated software • Describe ways to share data between applications Page 58

  4. Application Software • Basic applications • Specialized applications Page 60

  5. Common Features • Graphical User Interface (GUI) • Windows • Menus • Toolbars • Help Page 60

  6. Open Save Print Standard  Toolbars • Commonly used commands • Contain shortcuts • Most common • Standard • Formatting Page 60

  7. Web-Based Applications • Access to applications stored on Web sites • Application service providers (ASP) • Special sites • Allows access to Web-based applications Page 61

  8. 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 64

  9. Word Wrap Editing Thesaurus Spelling and grammar checkers Find and Replace Formatting Font and font sizing Character effects Bulleted and numbered lists italics size bold colors Word Processor Features Page 64

  10. Creating a Report Page 66

  11. Spreadsheets • Programs that manipulate numeric data • Spreadsheet programs • Microsoft Excel • Corel Quattro Pro • Lotus 1-2-3 Page 67

  12. Spreadsheet Features • Workbook files • Worksheets • Formulas • Functions • Analytical graphsor charts • What-if Analysis Page 67

  13. Creating a Sales Forecast Page 69

  14. Creating a Chart Page 70

  15. Database Management SystemsDBMS • A collection of related data • Sets up a structure for data storage • Database programs • Microsoft Access • Corel Paradox • Lotus Approach Page 72

  16. Database Features • Tables • Records • Fields • Record sorting • Queries • Forms • Reports Page 72

  17. Creating a Database Page 73

  18. Creating a Query Page 74

  19. Presentation Graphics • Programs that create visually interesting presentations • Presentation programs • Microsoft PowerPoint • Corel Presentations • Lotus Freelance Graphics Page 75

  20. Presentation Graphics Features • Slides • Design templates • Special effects • AutoContent wizard Page 75

  21. Creating a Presentation Page 76

  22. 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 areMicrosoft Works & Apple Works Page 77

  23. Software Suites • Collection of separate application programs sold as a group • Four types of suites • Productivity suite • Personal suite • Specialized suite • Utility suite Page 78

  24. 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

  25. A Look to the Future • Web-based application software helps ease maintenance • Use of the Web to connect toan application service provider • No programs to install • Allow for a simplerand cheaper computingsystem Page 81

  26. 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? Page 88

  27. 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

More Related