design tools

design tools

1. layout diagrams

   • provide a visual depiction
     • final spreadsheet

2. solution

   • sketched on paper first
     • easy to change when sketched

3. layout diagram should clearly indicate

   • sorting of the data
   • type of data to be entered
   • labels that assist data entry
   • chart title, axis labels and legend
   • content of each cell
   • format and conventions used in graphic representations and manipulating spreadsheet data
   • type of graphic representation
   • functions (such as mathematical calculations)
   • where cell protection should be used
   • any validation rules