Data Exchange assignment. Create an Excel Spreadsheet with Column names: LastName FirstName City State Age Major Enter 10 rows of data to populate your spreadsheet with test data. Save this file as an XLSX (standard Excel Format); base spreadsheet. Save and view the data in its ‘raw’ format Save this file as Windows Comma Separated .CSV Close Excel Open this .CSV file using a text editor (e.g. Notepad) Take a screen shot of this and include it in your writeup document What you notice that’s different about this format vs the standard XLSX format?  XML Using your TEXT editor, create a file called ‘studentdata.xml’ Enter the studentdata.xml below as the XML schema and save it Open your original .XLSX file On the Developer tab, open the ‘XML Source’ task pane If you don't see the Developer tab, do the following to display it: Click File > Options. In the pane on the left, click the Customize Ribbon category. Under Main Tabs, check the Developer box, then click OK. Click XML Maps or XML Source depending on Excel version Click ‘Add’ and Select your schema XML file you just created Map your elements against your XLSX file Drag the tree elements on the right over your column header in the spreadsheet On the Developer tab, under the XML group, click Export Save your file as FinalDataSet.xml Open this new XML file using your TEXT editor Take a screen shot of this and include it in your writeup document What do you notice about the file format output? Example Pages http://www.excel-easy.com/examples/xml.html (Links to an external site.) https://www.udemy.com/blog/excel-to-xml/ (Links to an external site.) If you can't complete with Excel, another option is using online CSVToXML translator tool that converts comma-separated value (CSV) files to XML. However you must first rename your .csv file as .txt then on webpage at https://xmlgrid.net/csvToXml.html (Links to an external site.) under "Source Data:" click on "Open File" to navigate to your .txt file and submit to tool for processing into XML. Your output will be slightly different than using Excel but you'll get an XML document that you can submit for assignment credit. studentdata.xml <studentdata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">     <record>        <LastName>Takahashi</LastName>        <FirstName>Jesse</FirstName>        <City>State College</City>        <State>PA</State>        <Age>19</Age>        <Major>IST</Major>     </record>     <record>        <LastName>Smith</LastName>        <FirstName>John</FirstName>        <City>Orlando</City>        <State>FL</State>        <Age>18</Age>        <Major>SRA</Major>     </record> </studentdata>   Writeup Document to be submitted Screen shot of your text-based CSV flat file What you notice that’s different about this format (CSV) vs the standard XLSX format? Screen shot of your text-based XML output file What do you notice about the file format output of your XML file?       PreviousNext

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

Data Exchange assignment. Create an Excel Spreadsheet with Column names:

  1. LastName
  2. FirstName
  3. City
  4. State
  5. Age
  6. Major

Enter 10 rows of data to populate your spreadsheet with test data. Save this file as an XLSX (standard Excel Format); base spreadsheet.

  1. Save and view the data in its ‘raw’ format
  2. Save this file as Windows Comma Separated .CSV
  3. Close Excel
  4. Open this .CSV file using a text editor (e.g. Notepad)
  5. Take a screen shot of this and include it in your writeup document
  6. What you notice that’s different about this format vs the standard XLSX format?

 XML

  1. Using your TEXT editor, create a file called ‘studentdata.xml’
  2. Enter the studentdata.xml below as the XML schema and save it
  3. Open your original .XLSX file
  4. On the Developer tab, open the ‘XML Source’ task pane
  5. If you don't see the Developer tab, do the following to display it:
  6. Click File > Options.
  7. In the pane on the left, click the Customize Ribbon category.
  8. Under Main Tabs, check the Developer box, then click OK.
  9. Click XML Maps or XML Source depending on Excel version
  10. Click ‘Add’ and Select your schema XML file you just created
  11. Map your elements against your XLSX file
  12. Drag the tree elements on the right over your column header in the spreadsheet
  13. On the Developer tab, under the XML group, click Export
  14. Save your file as FinalDataSet.xml
  15. Open this new XML file using your TEXT editor
  16. Take a screen shot of this and include it in your writeup document
  17. What do you notice about the file format output?

Example Pages

http://www.excel-easy.com/examples/xml.html (Links to an external site.)

https://www.udemy.com/blog/excel-to-xml/ (Links to an external site.)

If you can't complete with Excel, another option is using online CSVToXML translator tool that converts comma-separated value (CSV) files to XML. However you must first rename your .csv file as .txt then on webpage at https://xmlgrid.net/csvToXml.html (Links to an external site.) under "Source Data:" click on "Open File" to navigate to your .txt file and submit to tool for processing into XML. Your output will be slightly different than using Excel but you'll get an XML document that you can submit for assignment credit.


studentdata.xml

<studentdata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <record>

       <LastName>Takahashi</LastName>

       <FirstName>Jesse</FirstName>

       <City>State College</City>

       <State>PA</State>

       <Age>19</Age>

       <Major>IST</Major>

    </record>

    <record>

       <LastName>Smith</LastName>

       <FirstName>John</FirstName>

       <City>Orlando</City>

       <State>FL</State>

       <Age>18</Age>

       <Major>SRA</Major>

    </record>

</studentdata>

 

Writeup Document to be submitted

  1. Screen shot of your text-based CSV flat file
  2. What you notice that’s different about this format (CSV) vs the standard XLSX format?
  1. Screen shot of your text-based XML output file
  2. What do you notice about the file format output of your XML file?
 
 
 
PreviousNext
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Elements of Tables
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education