LO6

SPREADSHEETS

  • designed to store text and numerical data
  • format of data can be set to meet the defined objectives, e.g currency.
  • functions and formulas can be used to calculate results.
  • graphs can be created to show results of the processing of numerical data.

DATABASES

ADVANTAGES:

DISADVANTAGES:

  • can take a long time to create.
  • data can be presented in a graph, makes spotting trends easier
  • can be imported into other documents and can be shared electronically.
  • not easy to manipulate the text.
  • data can be formatted to meet the needs of the audience.
  • errors may be introduced if dad is entered manually.
  • used to store and process data and text.
  • allow entry, storage and processing of data.
  • stored in a table(a file that is made up of records)
  • contains queries to find specific records and validations can be set for different fields.

DISADVANTAGES:

ADVANTAGES:

  • data can be filtered and queried to find relevant results.
  • passwords can be set for security
  • validations can be set to minimise input errors
  • knowledge and skills is needed to set up a database.
  • queries can be difficult to formulate.

-errors may be introduced if data is entered manually- errors in data entry, validations or queries can affect results produced.

TOOLS TO PRESENT INFORMATION

WORD PROCESSOR

  • produces, edits and formats documents that are mainly text-based.
    A: easy to correct mistakes.
    D: files can become corrupted, limited choice of symbols.

SPREADSHEET

  • stores and processes numerical data.
    A: can store numbers and text, complex calculations and What-If Analysis carried out.
    D: incorrect formulas produce incorrect results.

DATABASE

  • stores records in an organised way
    A: reports created to present results of queries
    D: needs to be kept up to date

DESKTOP PUBLISHING

  • arranges text and images into publications
    A: frames used to position text and images, text and graphics can be imported from difference sources.
    D: difficult to create precise layouts, different types of DTP software can have compatibility issues.

PRESENTATION SOFTWARE

  • creates a slideshow to present information to an audience
    A: slides includes a range of components.
    D: animations or transitions can become distracting

DEMOGRAPHICS

Gender- gender neutral colours could be used Age- presentation method and content must be appropriate to the targeted age group
Ethnicity- some audiences may not have English as their first language
Income- message or product/service needs to be targeted at the correct income group
Location- considered if the resource will be viewed online, internet issues.
Accessibility- face to face or via the cloud, consideration of disabilities.

several factors that must be considered when the method of presenting information is to be selected. These include: