Excel Chapter 10

Demonstrable Skill	Learning Activities & Informal Assessments	Formal Assessments (excluding Exams)
Import data from CSV and text files.	Excel: Excel Basics Participation Project MyLab Lesson A	Homework #1 Homework #2 Old Homework #2 MyLab Lesson A
Import data from XML files.	Excel: Excel Basics Participation Project MyLab Lesson A	MyLab Lesson A
Convert text to columns.	MyLab Lesson B	MyLab Lesson B
Use functions to manipulate text strings.	Excel: Formulas & Functions III Participation Project
Use Flash Fill to generate a series of data.	MyLab Lesson A	MyLab Lesson A

Importing XML files

The heart of this chapter is the idea of importing data. The first test for you to pass in your homework is importing the data you will be working with. All data in CS101 will come to you in the form of XML files. You can import an XML file by Data  ribbon and From Other Sources, and then From XML Data Import and selecting the desired XML file [1].

 

Importing XML files

For this chapter, always remember that you need to open Excel first, then go to Data to import data.  Don't try to directly open files that we provide you [2].

1. M. A. Poatsy, K. Mulberry, C. Krebs, L. Hogan, A. Rutledge, and E. Cameron, Exploring Microsoft Office 2013, 1st ed., vol. 2. Upper Saddle River, NJ: Pearson Education, 2013.
2. R. G. Phipps and B. M. Powell, “Excel Chapter 10,” Computer Science 101, May 18, 2016. Available: http://cs101.wvu.edu/materials/units/excel-data-analysis/excel-chapter-10/.