ACISTEST2 - • 91 of spreadsheets created by EXPERIENCED users contain SIGNIFICANT errors o Report grade as F when it is really a C 4 Spreadsheet

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
FEBRUARY 21 EXCEL: Spreadsheet Design 1. Key Features of Spreadsheet Applications Allow: Complex computations Presentation of results in graphical form Flexible formatting and layout of data and reporting Rapid entry and use of small amounts of data that do not need to be grouped and regrouped for repeated long term use Spreadsheet is good for collecting data and processing data as long as you are processing who data set; use database when you want to process parts of data o Use for grades, need all test grades o Registrar uses certain grades (ie. Seniors, ACIS major, etc.) o Use whole data spreadsheet o Use some of the rows database 2. Why Spreadsheet Design? 80% of companies use spreadsheets for managing financial data 94% of spreadsheets created by professional users contain errors Over 5% of the cells in professional jobs create errors 3. Are errors large enough to make a difference? 5% of all spreadsheets contain “show stopper” errors o Serious errors that affect the whole
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: • 91% of spreadsheets created by EXPERIENCED users contain SIGNIFICANT errors o Report grade as F when it is really a C 4. Spreadsheet Goals • CLEAR • FLEXIBLE • EFFICIENT • VERIFIABLE • ACCURATE 5. Clear • Simplicity: spreadsheet contains one idea per row and one idea per column • Unity: Like things are together (tests are either in one column or one row, students are grouped together, different things look different- i.e. TEST column width is wider than the HOMEWORK column width) o Make things look visual different if they should be separated (font changes/size, different colors) • Emphasis: draw attention to important parts of the spreadsheet\ o EX: headings, total points possible (for grading criteria), averages have color attached to them • Balance: taking a rough look a spreadsheet, and make sure it roughly looks like a rectangle (jagged border is okay; one rectangle with another tacked on is NOT okay)...
View Full Document

This note was uploaded on 04/20/2008 for the course ACIS 1504 taught by Professor Jmlacoste during the Spring '07 term at Virginia Tech.

Page1 / 2

ACISTEST2 - • 91 of spreadsheets created by EXPERIENCED users contain SIGNIFICANT errors o Report grade as F when it is really a C 4 Spreadsheet

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online