1 / 73

Shelly Cashman Series Discovering Computers 2003

Shelly Cashman Series Discovering Computers 2003. Application Software. CHAPTER 2 PRIMARY OBJECTIVES. Define Application Software Explain how to start a software application Key features of widely used software Importance of the World Wide Web Searching the WEB Learning Aids.

lavonn
Download Presentation

Shelly Cashman Series Discovering Computers 2003

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. Shelly Cashman SeriesDiscovering Computers2003 Application Software

  2. CHAPTER 2 PRIMARY OBJECTIVES • Define Application Software • Explain how to start a software application • Key features of widely used software • Importance of the World Wide Web • Searching the WEB • Learning Aids

  3. Application Software • Assist in productivity/Business tools • Graphics / Multimedia • Support household / education activities • Entertainment • Facilitate communications

  4. THE OPERATING SYSTEM AND USER INTERFACE • Operating system • Tells the computer how to perform functions such as processing program instructions and transferring data between input and output devices and memory • User interface • Allows user to tell the software what to do and allows the computer to display information and processing options to the user

  5. THE OPERATING SYSTEM AND USER INTERFACE • Graphical User Interface (GUI) • Icons • Windows • Menus • List of Commands • SubMenus • Commands • Dialog Boxes • Buttons Click to see Figure 2-2

  6. PRODUCTIVITY SOFTWARE • Widely used personal computer software applications • Word processing • Spreadsheet • Database • Presentation graphics

  7. PRODUCTIVITY SOFTWARE • Fifteen widely used personal computer software applications • Personal information management • Software Suites • Accounting • Project Management

  8. PRODUCTIVITY SOFTWARE • Fifteen widely used personal computer software applications • Accounting • Groupware • Computer-aided design (CAD) • Multimedia authoring • Integrated software and software suites

  9. WORD PROCESSING SOFTWARE • Voice Recognition • Creating a word processing document • Word wrap • Macros Office ‘97: Word Video

  10. WORD PROCESSING SOFTWARE • Creating a word processing document • Word wrap • Scrolling • Insertion point • Editing a word processing document • Insert and delete • Cut, copy, and paste • Search and replace

  11. WORD PROCESSING SOFTWARE • Editing a word processing document • Spelling checker • AutoCorrect • Thesaurus • Grammar checker • Revision marks Click to see Figure 2-6

  12. WORD PROCESSING SOFTWARE • Formatting a word processing document • Font, style, and Font Size • Margins and alignment • Spacing • Auto format • Columns and tables Click to see Figure 2-7

  13. TYPEFACE

  14. WORD PROCESSING SOFTWARE • Formatting a word processing document • Graphics • Borders and shading • Page numbers, headers, and footers • Build-in styles

  15. WORD PROCESSING SOFTWARE • Printing a word processing document • Number of copies and pages • Portrait and landscape • Print preview • Creating Web pages using a word processor

  16. Popular Word Processing Programs • MS Word 2000 • Corel Word Perfect • Lotus Word Pro

  17. SPREADSHEET SOFTWARE • Organize numeric data in a tabular format called a spreadsheet or worksheet • 255 Worksheets per Workbook • 256 columns • 65,536 rows • Access different sheets by using sheet tab • Data organized in columns and rows • Intersection where a row and column meet is called a cell Click to see Figure 2-13

  18. Spreadsheets

  19. SPREADSHEET SOFTWARE • Cells contain different types of data • Labels • Values • Formulas • Functions • Macros • What-if-Analysis • Recalculation Click to see Figure 2-15

  20. Function Example =PMT(Rate, number of periods,present value)

  21. SPREADSHEET SOFTWARE • Charts • Analytical graphics • Business graphics • Charts • Line charts • Bar charts • Pie charts Click to see Figure 2-22

  22. Popular Spreadsheet Software • MS Excel • Lotus 1-2-3 • Corel Quattro Pro • MS Pocket Excel

  23. DATABASE SOFTWARE - DBMS • A Database is a collection of data stored in files - called tables • Reduces data redundancy • Improves Quality - ie. Correctness of data • Database software allows creation, retrieval, manipulation and updates of the data

  24. DATABASE SOFTWARE • Tables • Records • Fields (attributes) • Relationships

  25. DATABASE SOFTWARE • Creating a database • Make a list of the data you want to record • Define the fields • Name the fields • Determine lengths of fields • Determine the type of data • Text Numeric Memo • Currency Date Hyperlink • Data Definition Language (DDL) Click to see Figure 2-28

  26. DATABASE SOFTWARE • Database can be used to produce information • Forms • Data Entry • Validation • Reports • Queries • Selecting information Click to see Figure 2-29

  27. Forms and Queries • Data Entry Form • Products < 15.00Query

  28. Popular DBMS • MS Access • Corel Paradox • Lotus Approach • MS Visual FoxPro • Oracle

  29. PRESENTATION GRAPHICS SOFTWARE • Creates documents called slides that are used in making presentations • Used to communicate ideas • Can include • Text • Animation • Sound • Video Click to see Figure 2-30

  30. PRESENTATION GRAPHICS SOFTWARE • Print Formats • Outline • Handout • Notes page • Transparency Click to see Figure 2-31

  31. INTEGRATED SOFTWARE AND SOFTWARE SUITES • Integrated software • Combines applications such as word processing, spreadsheet, and database, into a single, easy-to-use package • Consistent command and menu structure • Pass information quickly and easily among applications • Cannot buy individual pieces • MS Works Click to see Figure 2-43

  32. INTEGRATED SOFTWARE AND SOFTWARE SUITES • Software suites • Individual applications packaged in the same box • Sold for a price that is less than buying the applications individually • Products look and work the same • Shorter development and training time • MS Office 2000

  33. End of Part I

  34. COMMUNICATIONS SOFTWARE AND WEB BROWSERS • Used to transmit data from one computer to another • Dialing directory • Automatic dialing • Automatic redialing • Automatic answer • Remote employees Click to see Figure 2-33

  35. COMMUNICATIONS SOFTWARE AND WEB BROWSERS • Online services • The Microsoft Network (MSN) • America Online • ISP • Quad Cities On Line • Internet Revealed • AT&T at Home

  36. COMMUNICATIONS SOFTWARE AND WEB BROWSERS • Online services • The Microsoft Network (MSN) • America Online • Web browsers • Web pages • Home page • Hypertext Links • http:// Click to see Figure 2-34

  37. WWW • URL - Uniform Resource Locator • Search Engines • www.altavista.com • www.refdesk.com

  38. ELECTRONIC MAIL SOFTWARE • E-Mail allows users to send messages to and receive messages from other computer users E-mail Animation

  39. ELECTRONIC MAIL SOFTWARE • Common sense rules • Keep messages short • Avoid using E-Mail for trivia and gossip • Keep the distribution list to a minimum • Avoid using all capital letters • Abbreviate as long as abbreviations can be easily understood • Make the subject as meaningful as possible • Read your mail regularly

  40. ELECTRONIC MAIL SOFTWARE Click to see Table 2-1

  41. PERSONAL INFORMATION MANAGEMENT SOFTWARE • Helps users keep track of miscellaneous bits of personal information • Capabilities • Communications software • Appointment calendars • Outliners • Electronic notepads • Data managers • Text retrieval

  42. PERSONAL FINANCE SOFTWARE • Helps users track income and expenses, pay bills, complete online transactions and evaluate financial plans • Capabilities • Reports • Enter credit card and banking transactions • Financial planning

More Related