spreadsheets n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Spreadsheets PowerPoint Presentation
Download Presentation
Spreadsheets

Loading in 2 Seconds...

play fullscreen
1 / 16

Spreadsheets - PowerPoint PPT Presentation


  • 138 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Spreadsheets' - koen


Download Now 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.