Skip to main content

Excel Chapter 10

Chapter Demonstrable Skills

After completing the Excel Chapter 10 portion of the Excel & Data Analysis unit, students will be able to:

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
  • Homework #3
  • 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

Chapter Notes

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].

 

Tips & Tricks

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].

References

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