1 / 25

Clarity

Clarity. Chapter S3: Clarity All Sections. Today’s Topic. Security. Hardware & Software. IS Basics. Information Quality. Types of IS. Telecommu-nications. Systems Development. PowerPoint. Functional, Crossfunctional & Interorganizational. Database Processing & Design.

dezso
Télécharger la présentation

Clarity

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. Clarity Chapter S3: Clarity 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. Objectives • List and define the five principles of the clarity goal. • Apply the spreadsheet design goal of clarity.

  4. What are the Five Spreadsheet Design Goals? • Simple • Clear • Verifiable • Accurate • Efficient

  5. What is Clarity? • Unity • Delineation • Order • Emphasis • Balance

  6. What is Unity?

  7. How Does Freeze Panes Support Unity?

  8. Print Titles

  9. Which Print Options Support Unity?

  10. Orientation

  11. Page Breaks

  12. What is Delineation? colors fonts borders

  13. What is Order?

  14. How Does Sorting Support Order?

  15. What is Emphasis? colors fonts Expanded row height

  16. How Does Conditional Formatting Support Emphasis? Before Data Entry After Data Entry

  17. How Do You Implement Conditional Formatting?

  18. What is Balance?

  19. GPA Exercise continued Apply the principle of clarity to the GPA spreadsheet we setup in the previous class period. • Steps: Consider placement, formatting and print settings to support: • Unity • Delineation • Order • Emphasis • Balance

  20. Step 1: Unity • Which Excel features would you use to support Unity? • Where would you apply those features?

  21. Step 2: Deliniation • Which Excel features would you use to support Deliniation? • Where would you apply those features?

  22. Step 3: Order • Which Excel features would you use to support Order? • Where would you apply those features?

  23. Step 4: Emphasis • Which Excel features would you use to support Emphasis? • Where would you apply those features?

  24. Step 5: Balance • Which Excel print settings would you use to support Balance?

More Related