ACIS 1504 Lecture Notes - Lecture 5: Spreadsheet, Microsoft Powerpoint
Document Summary
Security tip of the day: keep your operating system up to date. Disable any guest accounts, rename our administrator account. Turn of your sharing if you"re not using it. *half of spreadsheets by professionals have major errors, for example formula is not right so number is not right at bottom. Throw-away: spreadsheets you use once, use excel like powerpoint, to pretty up data. Reusable: real world, used more than once, whether daily, weekly, annually. **design (making choices, where they"re going to go, colors) Use (day in and day out, entering data, producing output, analyzing of data, longer phase) Five design goals: simple, clear, verifiable, accurate, efficient. Every single row and column should contain one idea. Data that will be analyzed should be placed in columns. Column d midterm, column e final exam, or column f project 1. Two ideas: is a grade scale at the bottom of grade book, have violated one idea per column rule; makes spreadsheet less flexible.