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

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

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter2: Formatting Workbook Text And Data

Section: Chapter Questions

Problem 3.21CP

See similar textbooks

Related questions

Concept explainers

Question

100%

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

<LastName>Takahashi</LastName>

<FirstName>Jesse</FirstName>

<City>State College</City>

</record>

<LastName>Smith</LastName>

<City>Orlando</City>

</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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.