Flashcards
Cambridge nationals
Cards in this deck (13)
- 1the types of software you can use to analyse data ?database and spreadsheet
- 2what are spreadsheets used for ?Calculating invoices
Finding out the effect of price changes on sales of good
Importing data collected from like from a sensor or survey - 3what are the fields in a table called ?columns
- 4what can be used to help with the input of valid data ?input masks and validation rules
- 5what are queries used for ?queries are used to search and sort data with a specific requirement for the customer or person
- 6advantages for databasesformulas can be used for sums, columns, rows, tables and graphs can present data and cells, rows and columns can be locked to prevent other users from changing data but there are different ways to format data
- 7advantages for spreadsheetsData can easily be added, edited and deleted from the database, Data can be filtered and queried to find results, Validation rules and input masks can be used to input data correctly , Passwords can be used to keep the data secure
- 8advantages for databases and spreadsheetsData can be imported into different software, it can be saved and backed-up to prevent loss or damage and Data can also be shared electronically
- 9disadvantages for spreadsheetsSpreadsheets can take a long time to create and Some of the functions and formulas used in spreadsheets can be confusing , however errors in formulas can be difficult to spot and correct
- 10disadvantages in databasesYou need the knowledge and skills to set up and manage a database, Queries can get complicated to create and manage and Validation rules and input masks won't spot inaccurate data
- 11disadvantages in databases and spreadsheetsIf data is entered manually
the errors might not be spotted - 12environmental vulnerabilitiessome examples are: power cuts, flooding, lighting strikes, tsunamis and heat damage
- 13physical vulnerabilities
Information
- Description
- GCSE ICT Flashcards on Cambridge nationals , created by James Rowland on 14/10/2021.
- Created by
- James Rowland
- Views
- 2
- Tags
- Rating