1 / 16

Spreadsheets

Spreadsheets. Linking Database capabilities Analysis Tools Graphing : lies graphs tell. Other Calculation Tools. accounting software. tax preparation software. statistics & data analysis. mathematical software tools. Information Visualization.

koen
Download Presentation

Spreadsheets

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. Spreadsheets • Linking • Database capabilities • Analysis Tools • Graphing : • lies graphs tell.

  2. Other Calculation Tools • accounting software. • tax preparation software. • statistics & data analysis. • mathematical software tools.

  3. Information Visualization • depict information using spatial or graphical representations. • facilitate comparison, pattern recognition, change detection. • cognitive skills that make use of the visual system.

  4. Information Visualization Problem : How can we understand large datasets? Solution : the human perceptual system, convert information into a graphical representation.

  5. Simulation • computer modeling. • abstractions. • spreadsheets, programming languages, mathematical and statistical packages.

  6. Simulation • Cost • Safety • Projection • Visualization • Replication

  7. Simulation • Assumptions – garbage in garbage out • abstraction / simplification • Reliance

  8. Database : • collection of information. • data management tool. • huge volumes. • like a filing system. • providing answers.

  9. Where are Databases? • airline scheduling & reservations. • banking and financial institutions. • student records. • calendar & appointment software. • inventory systems. • Geographic Information System (GIS)

  10. Technically : • Database - collection of information. • Database Software : • maintains the collection. • DBMS : Database Management System. • database is like the books in the library, database software is like the librarian.

  11. Typically : • “database” refers to the entire thing, the information and the management software. • at the library the books, the librarian, the system for organizing and accessing the books are all needed.

  12. Database Operations • browsing – looking through. • query – a question you ask. • sort – ordering data. • report – present desired info.

  13. Database Terms • table – organized as tables. • record – row, info about an item. • field – column, attribute of the item. • field type – restrict what can got in a field (calculated, numeric, data, etc) • view – how you see the data • form : one record and a time • list : as a table

  14. Relational Database • information is broken into tables that are related. • information is stored only once, and tables are linked when the data is needed. • there may be hundreds of tables. DBMS takes care of this for you. • most databases are relational.

More Related