Fichas
L06/L04
Fichas del conjunto (12)
- 1Q1 There are two types of software you can use to analyse data: 1.) Spreadsheets 2.) DatabasesQ2 What is a Spreadsheet used for:
1.) Store text and numerical data
2.) Process and manipulate numerical data
3.) Produce graphs
4.) Set data types, including text, numeric, decimal, currency and percent - 2Q3 Spreadsheets contain different: 1.(Worksheets) Which is then which then form a WorkbookQ4 What is a Spreadsheet used for:
1.) Create formula and use built-in functions
2.) Carry out modelling using What-If Analysis - 3Q5 What tasks are Spreadsheets really good at: 1.) Calculating invoices 2.) Finding out the effect of price changes on sales of goods 3.) Importing data collected from, for example, a sensor or surveyQ6 What tasks are Spreadsheets really good at:
1.) Producing a graph to show how many people used a shop.
2.) Showing a business’s accounts over a year with months in a different worksheet
3.)Importing data collected from, for example, a sensor or survey - 4Q6 A _____ is made up of one or more tables which contain data? 1.) DatabaseQ7 The table will also have ______?
1.) Fields - 5Q8 Databases are much better than spreadsheets at? 1.) Storing and processing large amounts of dataQ9 You can also use a database to create?
1.) personalised letters
2.) emails and business cards
3.) Data storage
4.) All of above
Answer is (4) - 6Q10 What are the Advantages of Spreadsheets? 1.) Formulas can be used to calculate and recalculate totals 2.) What-If Analysis can be carried out using different values 3.) Data modelling can be carried outQ11 What are the Advantages of Spreadsheets?
1.) Worksheets can be used to separate different sets of data in a Workbook
2.) Data can easily be presented in tables with columns and rows - 7Q12 What are the Disadvantages of Spreadsheets? 1.) If a model is created, the results might not be realistic 2.) Spreadsheets can take a long time to createQ13 What is the Disadvantages of Spreadsheets?
1.) Errors in formulas can be difficult to spot and correct
2.) If you don't spot any errors in formulas, the results will be incorrect
3.) Text data cannot be manipulated easily - 8In terms of the software needed to present the information. What are the five main tools that you can choose between? 1.) Word Processors 2.) Spreadsheets 3.) DatabasesIn terms of the software needed to present the information.
What are the five main tools that you can choose between?
1.) Desk Top Publishing
2.) Presentation Software - 9What are environmental vulnerabilities? The tendency of the environment to respond either positively or negatively to changes in human and climatic conditions. Or something close to this.vulnerabilities of physical hazard
Wooden homes are less likely to collapse in an earthquake, but are more vulnerable to fire. theft. - 10—
- 11—
- 12—