1 / 28

Accuracy

Accuracy. S5 Accuracy 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. Spreadsheet Design.

taurus
Download Presentation

Accuracy

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. Accuracy S5 Accuracy 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. Accuracy & Efficiency 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 accuracy goal. • Apply the spreadsheet design goal of accuracy.

  5. Required Excel Skills • Range Name • Change Legend • Change Axis • Add Data Series • ‘Other’ Pie Slice • SUM Function • AVERAGE Function • MIN & MAX Functions • COUNT Function • 3D Calculations

  6. What Steps Should You Follow to Improve Accuracy? • Know the order of operations. • Select the correct function or construct the correct formula. (Choose a function over a formula.) • Isolate assumptions. • Check relative and absolute cell references. • Double-check all calculations.

  7. What is the Order of Operations? • Parentheses • Multiplication and Division • Addition and Subtraction

  8. Order of Operations Examples • 6 / 2 * 4 = • 3 + 2 * 2 – 1 = • ( 2 * 5 ) + 15 / 5 =

  9. What’s the Difference Between Formula and Function? • Formula • created by you • = A1 + A10 • Function • keyword defined by Microsoft • =SUM(A1:D1) • Functions are more flexible than formulas

  10. Formula vs. Function Example If you delete Row 5 =SUM(C3:C5) =B3+B4+B5+B6 =SUM(C3:C6)

  11. What is the Simplest Formula? • =cell reference • Used to transfer data from one cell to another • Benefit over copy & paste: redundant location is dynamic

  12. What are the Common Functions? • SUM • AVERAGE • MIN and MAX • COUNT

  13. Common Functions Examples

  14. What Does Isolate Assumptions Mean? • Store numbers in cells • Write equations to point to cells containing numbers

  15. Isolate Assumption Example Assumption =E2+3 is incorrect =E2+H2 is correct

  16. Isolated Assumptions? How Do You Spend Your Study Time?

  17. Isolated Assumptions? How Do You Spend Your Day?

  18. What are Relative, Absolute & Mixed Cell References? The cell addresses in the copied calculation may change. Any changes are made according to the direction and distance of the destination cell from the original source cell.

  19. What are the Decision Points for Choosing the Correct Cell Reference? • Is the formula entered going to be copied? • If so, which direction? • If it’s copied vertically, do you want the row references to change? If it’s copied horizontally, do you want the column references to change? • Do you want such a change to take place?

  20. What are the Decision Points for Choosing the Correct Cell Reference?

  21. Relative/Absolute Example • Will you copy this function? • If so, which direction: vertical or horizontal? • If you copy vertically, Excel will automatically change all relative row references. Do you want those row references to change? =SUM(B2:D2)

  22. Mixed Cell References Needed? How Do You Spend Your Study Time?

  23. GPA Accuracy Activity • What equations would you use to calculate • Weighted Credits for each course • Total Semester Credits • Total Semester Weight Credits • GPA • Remember to: • Choose a function over a formula • Isolate assumptions • Check relative and absolute cell references

  24. GPA Accuracy Activity

  25. What is the Purpose of the IF Function? • IF function displays one of two possible values depending on the outcome of a logical test • Logical Test compares two things • If the Logical Test equates to TRUE, the cell is filled with the True Value. • If the Logical Test equates to FALSE, the cell is filled with the False Value.

  26. IF Label Example • If a course requires more than 3 hours of study time per week, we will label it HARD. Three or less hours of study is labeled EASY.

  27. IF Label Example • What cell is used for the logical test? • What is the logical test? • What is the true value? False value? 3

  28. IF Grade Example Use the IF function to assign Pass/Fail grades. =IF(V4>=.6,”P”,”F”)

More Related