LO6 Flashcards
Why to use database over other software (4)
Data can be validated to ensure it is appropriate to store
Data can be sorted alphabetically numerically and according to dates
-You can query for data to only show what is relevant to your situation
-Reports can be generated to summaries your information this makes it easier to view
Database advantages (3)
They can store a large amount of data
Queries and reports can be used to present relevant information
Processing like validation can prevent errors
Database disadvantages (2)
Organizing the relationships between tables can be complex
Training may be required to use advanced features
Why to use spreadsheet over other software (3)
Processing can be speed up with autocomplete
Mathematical calculators are built in
Repetitive processing tasks can be automated using macros
They can convert numerical data to visual objects such as graphs and charts
Data can be converted from one currency to another, and from decimals to percentages ect
Th
spreadsheet Database disadvantages (2)
They are primary designed for numerical data
They can have a steep learning curve and may require training
Spreadsheet advantages
Can be used to store process and present data
Many tasks can be automated
Lots of tools are built-in for processing and presenting
Word processors advantages
Text can be written and edited easily
Formatting can add colors and change fonts
Objects can be added to break up text
Word processors disadvantages
It is primarily designed for text, so it can be hard to create visually appealing documents
Documents created do not always look professional
DTP stands for
desktop publishing
What can DTP be used for
Create professional documents like magazines and leaflets
DTP does what
Combing text with other objects, like images
DTP advantages
Text can be shown alongside images in a professional way
Templates are available
Documents created may be more visually appealing than one created by a word processor
Disadvantages of DTP
They can be hard to use compared to a word processes
Their file formats are less widely compatible
Presentation software advantages
Multiple sides can be used to display similar but different information
Templates can create visually appealing and professional slideshows
Disadvantages presentation software
Too many features transitions and animations can make the presentation look unprofessional
Long text and many objects can clutter slides
Target audiance
Who the information is going to be shared with
Demographics examples
gender
age
ethnicity
Public facing
Where the information is available to the general public
Availability of information (delays) what effects do they have
A processing delay might mean the information presented, it is outdated
In some cases a delay might be better than a loss of accuracy
Distribution channels
Methods through which information can be shared
Email messaging services 2 advantages and 1 disadvantage
Specific people can be reached targeted
Emails can usually be sent cheaply/freely
People may ignore emails especially if they go to the junk or spam folder
Social media advantages for a firm
Large num of ppl can be reached
Non customers may see the messaging
Social media disadvantages
Accounts may be targeted by hackers
Trolls and offensive messages may impede the core message
Website 1 advantage and two disadvantages
Can be accessed from anywhere
An internet connection is required
Information can’t be easily targeted
Intranets
Organisations internal networks
How are internal websites hosted
by intranets