1 / 28

Verifiability

Verifiability. Chapter S4: Verifiability 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.

meghan
Télécharger la présentation

Verifiability

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. Verifiability Chapter S4: Verifiability 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 • Define the verifiability goal. • Apply the spreadsheet design goal of verifiability.

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

  5. What is Verifiability? • Easy to understand • Minimize erroneous data entry

  6. How Can I Make A Spreadsheet Understandable?

  7. How Can I Make A Spreadsheet Understandable?

  8. How Can I Make A Spreadsheet Understandable?

  9. How Can I Make A Spreadsheet Understandable?

  10. How Can I Make A Spreadsheet Understandable?

  11. How Does Data Validation Minimize Errors?

  12. What Decisions Must Be Made Regarding Data Validation? • Which cells may require data validation? • What rules can I establish to identify incorrect data? • Is this rule accurate 100% of the time? • What should my error message be?

  13. How Do You Implement Data Validation?

  14. How Does Protection Minimize Errors?

  15. What Decision Must Be Made Regarding Worksheet Protection? • Which cells may require protection?

  16. How Do You Implement Worksheet Protection? (Step 1)

  17. How Do You Implement Worksheet Protection? (Step 2)

  18. GPA Exercise continued • Recall the workbook created to track QCA. • How could you support the verifiability design goal in this workbook?

  19. GPA Exercise Steps • What documentation features already exist to support Verifiability? • What documentation features could be added to improve Verifiability? Consider appropriate use of: • Comments • Range Names • Documentation Worksheet • Data Validation • Protection

  20. Step 1: Existing Documentation • What documentation features already exist to support Verifiability?

  21. Step 2: Additional Documentation • What documentation features could be added to improve Verifiability?

  22. Step 3: Comment • Think of a situation in which a comment might be appropriate. Which cell would you attach the comment to? • What would the comment be?

  23. Step 4: Range Names • Which range(s) could you name to improve the Verifiability of the worksheet? • How would you write the formulas to use these range names?

  24. Step 5: Documentation Sheet • What would you include on a documentation worksheet? How would you format that sheet?

  25. Step 6: Data Validation • Which cells should you apply data validation to? • What would be your validation rules?

  26. Step 7: Protection • Which cells would you unlock before turning on protection?

  27. Step 7: Protection • Which worksheet actions would you allow when protection is turned on?

More Related