Flashcards
LO6 - Flashcards
Flashcards do conjunto (29)
- 1What are two types of software used to analyse data?Spreadsheets and Databases
- 2What can I spreadsheet be used for?Storing text and numerical data, process and manipulate numerical data, produce graphs, set data types including text, numerical, decimal, currency and percent
- 3What are spreadsheets really good for?Calculating invoices, finding out the effect of price changes on sales of goods
- 4What is a database?A database if made up of one or more tables which contain data (records).
Businesses use databases to store and process numerical and text data, although databases are not great at performing calculations. - 5What can you use databases for?Databases can be used to create personalised letters, emails and business cards.
- 6Advantages for SpreadsheetsFormulas can be used to calculate and recalculate totals. What-if analysis can be carried out using different values. Data can easily be presented in tables and columns and rows.
- 7Advantages for DatabasesLots of records can be stored in tables. Data can easily be added, edited and deleted from the database. Passwords can be used to keep the data secure.
- 8Advantages for bothData can be imported into different software. For example, word processors, DTP and presentation software. Data can be saved and backed-up to prevent loss or damage. Data can be shared electronically.
- 9Disadvantages for SpreadsheetsSpreadsheets can take a long time to create. Errors in formulas can be difficult to spot and correct. Text data cannot be manipulated easily.
- 10Disadvantages for DatabasesQueries can get complicated to create and manage. Validation rules and input masks won't spot inaccurate data.
- 11Disadvantages for bothIf data is entered manually, errors might not be spotted.
- 12Examples of spreadsheetsCalculating invoices, producing graphs.
- 13Examples of databasesHolding customer of employee data.
- 14The tools and techniques used to present the information will depend onWhat information needs to be presented
- 15In terms of the software needed to present the information, there are five main tools that you can choose betweenSpreadsheets, databases, word processors.
- 16Advantages of a word processorDocuments can be saved and retrieved later. Spelling and grammar mistakes can be discovered quicker, mail merge can be used to create personalised documents
- 17Disadvantages of word processorsThere may be a limited choice of symbols, need a device with word processing software to create the document.
- 18Advantages of presentation softwareSlides can use a range of different components. A template can be used to make all the slides the same.
- 19Disadvantages of presentation softwarePresentations could become unprofessional if too many features or effects are used, too much text could make it hard to read/understand.
- 20Word Processor PurposeTo produce, edit and format documents that mainly contain text
- 21Word Processor Examples of UseWriting letters, reports and mail merge.
- 22SpreadsheetTo store and process numerical data in tables
- 23Spreadsheet - examples of useAnalyse financial data using formulas.
- 24DatabaseTo store data in related tables
- 25Database - examples of useHandling customer contact data
- 26DTPTo arrange text and images into publications like flyers
- 27DTP - examples of useCreating documents such as newsletters and leaflets
- 28Presentation SoftwareTo create a slideshow to present to an audience
- 29Presentation Software - examples of useCreating presentations
Informações
- Descrição
- Cambridge Nationals - LO6: Trial Exams - Key Words, Revision.
- Criado por
- Carlo Tritta
- Visualizações
- 43
- Tags
- Avaliação