Design Tools

Design Tools

1. Layout Diagrams

   • Design
     • Font size
     • Colour
     • Position of objects
       • Must be balanced
       • Appealing
   • Should indicate
     • Type of data to be entered into cells.
     • The content of each cell
     • Labels
     • Functions to be used
     • Validation rules that need to be entered
     • Where cell protection will be used
     • Formats and conventions used when manipulating spreadsheet data
     • Shape of graphic representations
     • Titles, Axis labels and Legends
     • Formats and conventions used in graphic representations
     • Sorting to be applied

2. Used to represent functionality and appearance of Solutions

   • Solutions sketched on paper
     • Enables changes without impacting on development

3. Before using a layout diagram

   • Consider
     • Amount of data
     • Type of data
     • Purpose of developing a graphic representation