1 / 47

Lead Black Slide

Lead Black Slide. Chapter 8. Personal Productivity and Problem Solving. Our Agenda. Improving Personal Productivity Managing Stored Data Analyzing Data Presenting Information Locating and Retrieving Information Using the Internet. Our Agenda (cont’d.).

aldona
Download Presentation

Lead Black Slide

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. Lead Black Slide Powered by DeSiaMore

  2. Chapter 8 Personal Productivity and Problem Solving Powered by DeSiaMore

  3. Our Agenda • Improving Personal Productivity • Managing Stored Data • Analyzing Data • Presenting Information • Locating and Retrieving Information Using the Internet Powered by DeSiaMore

  4. Our Agenda (cont’d.) • Solving Problems with Personal Applications • The Problem-solving Process Powered by DeSiaMore

  5. Learning Objectives • Explain how individual information systems can improve personal productivity. • Explain how stored data is managed with database software. • Describe how data is analyzed in a spreadsheet and why spreadsheet software makes the analysis easier. Powered by DeSiaMore

  6. Learning Objectives (cont’d.) • Describe several types of software used to prepare information for presentation to others. • Explain how data management, data analysis, and information presentation applications can be combined. • Describe how the Internet can be used to locate and retrieve information. Powered by DeSiaMore

  7. Learning Objectives (cont’d.) • Explain how personal computer applications are used to help individuals solve problems. • Explain the meaning of end-user computing. • Describe the activities in the problem-solving process. Powered by DeSiaMore

  8. Improving Personal Productivity Personal Productivity and Problem Solving Powered by DeSiaMore

  9. Improving Personal Productivity • Productivity has to do with how much a person contributes to a business in a period of time. • Individual information systems include computer applications that assist individuals in storing and analyzing data, presenting information and in locating and retrieving information on the Internet. Powered by DeSiaMore

  10. Managing Stored Data Personal Productivity and Problem Solving Powered by DeSiaMore

  11. Managing Stored Data • Individual information systems often require that data be stored in secondary storage in either data files or databases. • Using a database to manage data consists of three main functions: • Creating a database • Accessing a database • Updating or changing a database Powered by DeSiaMore

  12. Creating a Database • Creating a database consists of two main steps: • Entering a description of the structure of the data and the relationships. • Entering the initial data in the database, a process sometimes called populating the database. Powered by DeSiaMore

  13. Accessing a Database • Accessing data means retrieving the data from the database in secondary storage and bringing it into primary storage. Powered by DeSiaMore

  14. Updating a Database • Updating a database involves three main tasks: • Adding new data to the database • Deleting old data in the database • Changing data in the database Powered by DeSiaMore

  15. Analyzing Data Personal Productivity and Problem Solving Powered by DeSiaMore

  16. Analyzing Data • The most widely used analytical software is spreadsheet software. • A spreadsheet is an arrangement of data into rows and columns that is used to analyze the data. • With spreadsheet software an individual creates an electronic spreadsheet, or worksheet. Powered by DeSiaMore

  17. Analyzing Data (cont’d.) • One of the main reasons for making changes in a worksheet is to see what would happen to other figures when changes are made. This technique is called what-if-analysis. Powered by DeSiaMore

  18. Presenting Information Personal Productivity and Problem Solving Powered by DeSiaMore

  19. Presenting Information • Information is prepared for presentation in a text form by using word processing software. • Functions available in word processing software include: • Formatting text by selecting the font, the font size, and font style. • Editing the existing text. • Printing the document. Powered by DeSiaMore

  20. Presenting Information (cont’d.) • Information is prepared for presentation in a graphical or pictorial form by using computer graphics software. • Examples include: • Charts or graphs • Diagrams • Graphic designs • Realistic images • Computer art Powered by DeSiaMore

  21. Presenting Information (cont’d.) • Common types of computer graphics software include: • Charting software • Drawing software • Presentation graphics software • Computer-Aided Design (CAD) software Powered by DeSiaMore

  22. Presenting Information (cont’d.) • Information is prepared for presentation in a published form by using desktop publishing software. • The functions of desktop publishing (DTP) software are similar to those of word processing, except that some capabilities are more sophisticated. Powered by DeSiaMore

  23. Presenting Information (cont’d.) • Information is prepared for presentation in multimedia form using special software. • Elements of the presentation include text, graphics, animation, video, sound, voice, music and other forms. • After all parts have been prepared, they are brought together using authoring software. Powered by DeSiaMore

  24. Locating and Retrieving Information Using the Internet Personal Productivity and Problem Solving Powered by DeSiaMore

  25. Searching the World Wide Web • A browser lets a user follow links from one Web page to another to locate information. • A better approach is to use a search engine. Powered by DeSiaMore

  26. Searching the World Wide Web (cont’d.) • Three main types of search engines • A directory that contains references to Web pages. Example - Yahoo • Locating pages on the Web periodically by sending programs, sometimes called spiders, over the Web to look for new pages. Example – Alta Vista • A meta-search engine does not search the Web, rather other search engines. Example - MetaCrawler Powered by DeSiaMore

  27. Searching the World Wide Web (cont’d.) • A portal is a Web site that provides multiple services for its users. • Searching the Web using a browser can be thought of as pulling information into the users computer. • Having information sent to you automatically uses a technique called push technology. Powered by DeSiaMore

  28. Searching the World Wide Web (cont’d.) • For information obtained from the Web, the user must carefully analyze the credibility of the source of the information to ensure that what is received is accurate and relevant. Powered by DeSiaMore

  29. Solving Problems with Personal Applications Personal Productivity and Problem Solving Powered by DeSiaMore

  30. Problems, Solutions and Solution Procedures • A problem is a question to which someone does not know the answer, or a statement of something to be done. • The solution to a problem is the answer to the problem question or the result of doing what is required by the problem statement. Powered by DeSiaMore

  31. Problems, Solutions and Solution Procedures (cont’d.) • A solution procedure is a set of steps that, if carried out, results in the solution of a problem. Powered by DeSiaMore

  32. Problems, Solutions and Solution Procedures (cont’d.) • One of the main tasks in computer problem solving is determining the solution procedure needed to solve the problem. This task can be stated as follows: Given a problem, a person must figure out what steps the computer has to go through to solve the problem. Powered by DeSiaMore

  33. End-User Computing • End-user computing is the development and use of personal computer applications by end users. • The user identifies the problems to be solved, decides on the appropriate software, determines the appropriate procedures, customizes the software, and uses the software to develop a solution. Powered by DeSiaMore

  34. The Problem-Solving Process Personal Productivity and Problem Solving Powered by DeSiaMore

  35. The Problem-Solving Process • The five main activities of the problem-solving process are: • Understand and define the problem • Design the solution procedure • Implement the solution procedure, using the selected software • Test the software implementation and correct any errors • Document the result Powered by DeSiaMore

  36. Problem Definition • At a minimum the problem definition should include descriptions of the following: • The output to be produced and its layout. • The input data available and how it will be entered. • The calculations to be performed. • Other processing to be done. Powered by DeSiaMore

  37. Software Selection • Determine the appropriate type of software that will be used to implement the solution procedure. The most common alternatives are database, spreadsheet, word processing, graphics software, and statistical software, among others. Powered by DeSiaMore

  38. Solution Procedure Design • Steps necessary to solve the problem must be carefully planned. • Written notes should be made of the solution procedure. • The designing activity does not involve setting up the software to solve the problem. Powered by DeSiaMore

  39. Software Implementation • Completing the implementation requires knowing how to use the software selected. • Spreadsheet software requires that the numbers, text and formulas be entered. • Database software requires that the data is defined and entered, and that the query specifications and formats of forms and reports be created. Powered by DeSiaMore

  40. Implementation Testing • The user must test the software implementation to see it there are any errors. • Three types of errors: • Syntax error – an error in a command. • Execution error – errors appearing during execution of the software. • Logic error – generally resulting in incorrect output. Powered by DeSiaMore

  41. Documentation • Documentation is a general term used for any written description of a computer application. • Two types of documentation • User documentation – provides information so the user can understand how to use the software. • Developer documentation – is for the person who developed the software. Powered by DeSiaMore

  42. Personal Productivity and Problem Solving Key Terms Powered by DeSiaMore

  43. Authoring Software Bug Charting Software Computer-Aided Design (CAD) Software Debugging Desktop Publishing Desktop Publishing Software Documentation Drawing Software Integrated Software Portal Presentation Graphics Software Problem Push Technology Search Engine Key Terms Powered by DeSiaMore

  44. Solutions Solution Procedure Spreadsheet Suite Testing What-if Analysis Word Processing Worksheet Key Terms (cont’d.) Powered by DeSiaMore

  45. Summary • Improving Personal Productivity • Managing Stored Data • Analyzing Data • Presenting Information • Locating and Retrieving Information Using the Internet Powered by DeSiaMore

  46. Summary (cont’d.) • Solving Problems with Personal Applications • The Problem-solving Process Powered by DeSiaMore

  47. Final Black Slide Powered by DeSiaMore

More Related