1 / 15

Databases and Speadsheets

Lesson 4. Databases and Speadsheets. Lesson Objective: Understand the main features and differences between Database and Spreadsheet software. Learning Outcome: Clearly identify the uses of both types of software and use the correct terminology when describing their functions. Question.

alton
Download Presentation

Databases and Speadsheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lesson 4 Databases and Speadsheets Lesson Objective:Understand the main features and differences between Database and Spreadsheet software. Learning Outcome:Clearly identify the uses of both types of software and use the correct terminology when describing their functions.

  2. Question • What’s the point of today’s lesson?

  3. Which software do we use? • Database… Microsoft Access • Spreadsheet… Microsoft Excel NB In the exam DO NOT mention specific software products like those above. Always refer to them as Database and Spreadsheet applications.

  4. Table (FILE) structure NB The exam board prefer to call these things FILES as and not Data Tables … try not to get confused This is theFIELD NAME This is a RECORD Each Record contains at least oneFIELD

  5. Key features of databases • Storing large amounts of structured data (using data types and validation) • Searching for items (queries) • Sorting items (queries) • Producing Reports

  6. File and Key Field Each table usually has a KEY FIELD. The Key Field is UNIQUE to the record. The Key Field is used to refer to the record in other data tables (FILES)

  7. Two features of key fields • They are UNIQUE to the record • They are used to REFER to the record in other files

  8. Example Key Field Foreign key when in another table Key Field

  9. Flat file / relational database A flat file database does not make use of keys, the same data is often typed in repeatedly (in this example, the continent name) A Relational database uses keys and foreign keys across the different data tables.

  10. Queries Queries are used to limit the number of fields, the number of records and to sort in order. E.g: [Continent] = ‘Europe’ AND [Population] > 40000000

  11. Key features of spreadsheets • Formulas to make calculations • Appearance using features like cell fill and conditional formatting • Graphs and charts to display data.

  12. Spreadsheets Column Cell Row Cells can contain Text, Numbers or Formulae. What is the formula in CellD16? =B16*C16

  13. Conditional Formulas What formula would you put in cell C3 to indicate a retake if the exam mark is below 40? =IF( B3 < 40 ,”Yes” ,”No” )

  14. Graph plotting and charts What would you do to create a chart to show the cost of feeding the animals? Select the relevant data in columns, then apply the chart wizard

More Related