task3b

• Task 3b

  • Presentation methods
  • Features
• Dashboard

  Plays a role in enchancing appearance and effectiveness and usability allowing users to better understand and analyse the data presented
• Features-Table

  Used to see methods of payment
• Features-Graphs/charts

  • Way to visually see data that is easy to understand
  • Helps users quickly know information and indentify the trends and compare the data sets
  • Used to show ratings and methods of payment
  • There are features that could be improved and discussed below.....
• Good use of features

  • Titles with text wrap
  • Cell borders and shading
  • Comments
  • Conditional formatting
  • Merging cells
• Bad use of features

  • Colour scheme
  • Column widths
  • Axis labels (y and x) / legends
  • Chart titles
  • Title sizing
• Good use-Titles with text wrap

  • Headings used to wrap text is effective use of space eg. Without it columns would be extremely wide, unbalanced and cluttered and white space
  • Makes it look neat
  • Allows data to fit on screen without scrolling
• Good use -Gridlines and cell shading

  • Seperate the data
  • Cell shading differents between headings to quickly locate key information it makes the spreedsheet more user friendly
• Good use-Comments

  • They explain the ratings prevent confusion between high to low (1-10)
• Good use-Conditional formatting

  • Enhances visibility
  • Allows to see quick patterns and trends
• Good use-Merging cells

  • Creates clear stand out heading makes it easier to identify the purpose if the spreadsheet
  • Enchanced structure defines
  • Saves space
• Bad use- colours

  • doesn't match
  • Unprofessional looking
  • No house style
  • Lacks contrast for easy reading

  To improve

  • Use consistent colour scheme and create a house style on all charts on dashboard
  • Use max 4 colours
• Bad use- column widths

  • the "t" is cut out

  To improve

  • Widen the columns which enchances overall readability
  • Avoids errors
• Bad use- axis labels

  • Labels are crucial help people understand what they are seeing and unclear what chart represents

  To improve

  • Potential errors in decision making provides context and easier to understand
• Bad use-chart titles

  • Lack titles across charts
  • They help immediately understand people what they are seeing
  • Enchances the readability
  • Descriptive titles help draw conclusions
• Bad use - title sizing

  • Too small doesn't draw enough attention
  • Text being larger makes it more user friendly