Course Number: CA105
Course Title: Data Analysis Using Spreadsheets

STUDENT LEARNING OUTCOMES

General

The course focuses on the creation and manipulation of data in spreadsheets in order to derive solutions to various business (and non-business) scenarios. Generally, the student will demonstrate competency in the various methods of analyzing data using electronic spreadsheets and a general understanding of the pros and cons of involved in using the various methods.

Specific

The student will be able to:

 1. Format text, numbers, and dates in a workbook using accounting, fraction, and scientific number formats; create a custom format;
     use AutoFormat.
 2. Apply conditional formatting, styles, data, and chart formats.
 3. Describe and demonstrate the various ways to print a worksheet and explain advance printing features.
 4. Create and use a list using such features as viewing, sorting, and printing records specified in a search or filter.
 5. Demonstrate how to use a list to find specific records using the AutoFilter.
 6. Explain and demonstrate how to use data analysis tools using scenarios, auditing features, pivot tables and pivot charts, goal seek,
     and solver features to find unknown values.
 7. Create and use macros and explain macros as a timesaving feature.
 8. Describe and demonstrate various methods of exchanging information with other programs, such as the import and export function,
     and publishing worksheets in an HTML format for web accessibility.
 9. Demonstrate how to create and save a template, open and use the template, and use some of the templates built into the
     spreadsheet program.
10. Demonstrate how to name ranges, copy and move data between worksheets, copy an entire worksheet, and create and save a
     workspace.
11. Perform data consolidation.
12. Create and use a shared worksheet, merge data in shared workbooks, track changes, and add password protection to a workbook.
13. Describe features in an electronic spreadsheet that control how summary data is displayed, such as adding subtotals to column(s)
     and row(s) of data and grouping data for easier viewing.
14. Apply the advanced features that are available in the electronic spreadsheet to look up information and return a value to a cell,
     such as the extensive markup language, XML.
15. Write, debug, and execute advanced macro functions using Visual Basic Application (VBA) programming language.