1 / 27

“Have your answers questioned.”

“Have your answers questioned.”. Day 6: Excel Chapter 3. Cody Cutright cody.cutright@mail.wvu.edu January 27 th , 2014. Reminders. Homework #1 is due 1/31 at 11:55pm Go to CS 101 website -> Instructors -> Cody Cutright -> Assignments. Importin g data.

yehuda
Download Presentation

“Have your answers questioned.”

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. “Have your answers questioned.”

  2. Day 6:Excel Chapter 3 Cody Cutright cody.cutright@mail.wvu.edu January 27th, 2014

  3. Reminders • Homework #1 is due 1/31 at 11:55pm • Go to CS 101 website -> Instructors -> Cody Cutright -> Assignments

  4. Importin g data Importing is the process of inserting data from one application or file into another. Excel lets us import a few different types of data!

  5. Import(ant) decisions Decide ahead of time if you want to embed data or link to it. Embedded data: Is not linked to the original source, and can be edited. A change in the data in one place does not affect the other. Data as a connection: Linked to the original data, Excel can then be refreshed from the source and the data updated if any changes are made.

  6. Import a text file Text Files: (Notepad, anyone?) • .txt file extension (SomeTitle.txt) • No formatting • No sound • No video • Lots of data!

  7. Where do they come from? “When a text editor loves a character…” • Can be created in Notepad • Can be downloaded from an organization’s website (things like accident statistics, cars sold, etc) *The benefit is that you can import a text file into multiple different programs, without distorting the text.

  8. Delimiters! Delimiters are special characters that separate the data, so it doesn’t run together. The most common delimiters: Tabs: TAB (Tab delimited) Commas: , (Comma Separated Value “CSV”)

  9. Tab delimited

  10. TAB Delimited import

  11. CSV

  12. CSV import

  13. Import steps • Data Ribbon • Get External Data • From Text • Select File • Follow Wizard Prompts

  14. The wizard

  15. The wizard – cont’d

  16. The wizard – cont’d

  17. Importing from access • Databases are usually less intuitive about manipulating data, or lack the ability to do so • Maintaining a database connection (in this case Access) eliminates the need to copy/paste data into Excel

  18. Access import steps • Start Excel, open an existing workbook • Click the Data Ribbon -> Get External Data -> From Access • Select the Access Database File, click open • Choose the table or query to import (Tables are one rectangle, queries two) • Select how you want to view the data in your workbook, such as Table or PivotTable

  19. Other data sources Table 3.1

  20. Xml eXtensible Markup Language (XML) – is an industry standard for structuring data that enables data to be shared across applications, operating systems, and hardware.

  21. Why XML? • It enables data to be sent/received between disparate and otherwise incompatible systems. ***Sidenote: XML describes the structure of data, not the appearance or formatting.

  22. Understanding xml syntax 3bedrooms/2bathrooms-$1,000permonth-(305)555-1234

  23. Marked up as xml <Apartment> <Bedrooms>3</Bedrooms> <Bathrooms>2</Bathrooms> <Rent>$1,000</Rent> <Telephone>(305)555-1234</Telephone></Apartment>

  24. Importing xml data • Data Ribbon • Get External Data • From Other Sources • From XML Data Import (Excel remembers this connection, and you can refresh the data if needed)

  25. Embedding xml data • File -> Open • File Type -> XML • Select the correct file • Select how you want to open the file

More Related