Spreadsheets
This presentation is the property of its rightful owner.
Sponsored Links
1 / 16

Spreadsheets PowerPoint PPT Presentation


  • 93 Views
  • Uploaded on
  • Presentation posted in: General

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.

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Spreadsheets

Spreadsheets

  • Linking

  • Database capabilities

  • Analysis Tools

  • Graphing :

    • lies graphs tell.


Other calculation tools

Other Calculation Tools

  • accounting software.

  • tax preparation software.

  • statistics & data analysis.

  • mathematical software tools.


Information visualization

Information Visualization

  • depict information using spatial or graphical representations.

  • facilitate comparison, pattern recognition, change detection.

  • cognitive skills that make use of the visual system.


Information visualization1

Information Visualization

Problem : How can we understand large datasets?

Solution : the human perceptual system, convert information into a graphical representation.


Simulation

Simulation

  • computer modeling.

  • abstractions.

  • spreadsheets, programming languages, mathematical and statistical packages.


Simulation1

Simulation

  • Cost

  • Safety

  • Projection

  • Visualization

  • Replication


Simulation2

Simulation

  • Assumptions – garbage in garbage out

  • abstraction / simplification

  • Reliance


Database

Database :

  • collection of information.

  • data management tool.

  • huge volumes.

  • like a filing system.

  • providing answers.


Where are databases

Where are Databases?

  • airline scheduling & reservations.

  • banking and financial institutions.

  • student records.

  • calendar & appointment software.

  • inventory systems.

  • Geographic Information System (GIS)


Technically

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.


Typically

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.


Database operations

Database Operations

  • browsing – looking through.

  • query – a question you ask.

  • sort – ordering data.

  • report – present desired info.


Database terms

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


Relational database

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.


  • Login