1 / 23

Efficiency & Charting

Efficiency & Charting. S6 Efficiency & S7 Charting All Sections. Today’s Topic. Security. Hardware & Software. IS Basics. Information Quality. Types of IS. Telecommu-nications. Systems Development. PowerPoint. Functional, Crossfunctional & Interorganizational.

midori
Download Presentation

Efficiency & Charting

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. Efficiency & Charting S6 Efficiency & S7 Charting All Sections

  2. Today’s Topic Security Hardware & Software IS Basics Information Quality Types of IS Telecommu-nications Systems Development PowerPoint Functional, Crossfunctional & Interorganizational Database Processing & Design Spreadsheet Design E-commerce Access Excel Business Intelligence

  3. Charting Spreadsheet Design Efficiency Simplicity includes Clarity Accuracy Layout Choices Formulas Functions Macros Verifiability Formulas Functions Basic Formatting Conditional Formatting Freeze Panes Page Setup Sorting Charts implemented with Documentation Data Validation Protection

  4. Objectives • Define the efficiency goal. • Describe how the efficiency goal might be applied. • State the purpose of each chart type. • Select the proper chart type for specific problems. • Discuss common charting pitfalls and how to avoid them.

  5. Efficiency • Calculations • Macros

  6. Chart Types

  7. Chart Type Exercise Which chart type would you choose to show how your study hours have changed over your college career?

  8. Chart Type Exercise Which chart type would you choose to show how you divide your time in a typical day?

  9. Chart Type Exercise Which chart type would help you compare study hours for each semester?

  10. Chart Type Exercise Which chart type would help you compare the time spent on major activities this semester?

  11. What’s Wrong with this Chart?

  12. Real Trend

  13. What’s Wrong with this Chart?

  14. Full Trend

  15. What’s Wrong with this Chart?

  16. Real Trend

  17. What’s Wrong with this Chart?

  18. Bars You Can Compare

  19. What’s Wrong with this Chart?

  20. Maintain Proportions

  21. What’s Wrong with this Chart?

  22. Proportions You Can See

  23. Charting Guidelines • Include entire scale • Include relevant data points • Put horizontal axis in chronological order • Stack and scale pictograph images • Do not separate all pieces of pie chart • Arrange pie slices largest to smallest starting at noon

More Related