1 / 32

Clarity

Clarity. Chapter S3: Clarity All Sections. View this presentation in slideshow mode to hear narrations. Not all slides are narrated. Narrations begin on slide #6. Today’s Topic. Security. Hardware & Software. IS Basics. Information Quality. Types of IS. Telecommu-nications.

jean
Download Presentation

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. View this presentation in slideshow mode to hear narrations Not all slides are narrated. Narrations begin on slide #6.

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

  4. Objectives • List and define the five principles of the clarity goal. • Apply the spreadsheet design goal of clarity.

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

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

  7. What is Unity?

  8. How Does Freeze Panes Support Unity?

  9. How To Use Freeze Panes?

  10. Which Print Options Support Unity?

  11. Orientation

  12. Page Breaks

  13. Print Titles

  14. Have You Been Taking Notes? Take this opportunity to ensure you have captured adequate notes for studying later.

  15. What is Delineation? colors fonts borders

  16. What is Order?

  17. How Does Sorting Support Order?

  18. What is Emphasis? colors fonts Expanded row height

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

  20. How Do You Implement Conditional Formatting?

  21. What is Balance?

  22. Have You Been Taking Notes? Take this opportunity to ensure you have captured adequate notes for studying later.

  23. GPA Exercise • Apply the principle of clarity to the GPA spreadsheet we setup in the previous class period. • You do not have to do this in Excel. You can find screenshots of the spreadsheet on subsequent slides. • Complete this activity individually or with a classmate. • Steps: Consider placement, formatting and print settings to support: • Unity • Delineation • Order • Emphasis • Balance

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

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

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

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

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

  29. Solution to Exercise • The next slide contains one solution to the exercise. To gain the most benefit from this activity, you should think about your solution to the previous five steps before viewing the next slide.

  30. One Clear Solution

  31. Have You Understood This Lecture? • Please log into Scholar and complete the Clarity Self Assessment • You can find this formative assessment in the Tests & Quizzes section of Scholar. • The assessment will be available 2/20-2/26. • This assignment is not graded.

More Related