Course Description

This course deals with a comprehensive study of Microsoft Office Excel spreadsheet software and the business applications which can be created and used with the software. The entry of data with different formats, formula creations, file transfer of data, graphing, data tables, solver programs, apply what-if scenarios and an introduction to macros will be covered. Course content is mapped to the current Microsoft Office Specialist (MOS) Excel learning objectives and students enrolled in this course will take the certification exam. Group 2 course.

Credit Hours

3

Contact Hours

3

Lecture Hours

3

General Education Outcomes supported by this course

Quantitative Reasoning

Course Learning Outcomes

Knowledge:

• Identify spreadsheet concepts.
• Identify industry standards including best-practice guidelines.

Application:

• Create workbooks.
• Modify workbooks.
• Maintain an electronic file and folder structure containing course files.
• Mathematical models to solve problems.

Integration:

• Integrate knowledge of MS Excel with real-life situations.

Human Dimension:

• Identify various ways MS Excel is used in industry.

Caring - Civic Learning:

• Research MS Excel features of interest to share with others.

Learning How to Learn:

• Identify sites that explain spreadsheet concepts.