OADM 132 - Microsoft® Excel

3 Credits: (3 lecture)

Course Description
This course provides a comprehensive knowledge of Microsoft® Excel and its capabilities to create and manage spreadsheets.

Note Spring semester only.

Corequisite OADM 107 or COMP 210.

Text
Freund, S. M. & Starks, J. L. (2023). Shelly Cashman series® Microsoft® Office 365® & Excel® 2021 comprehensive (1st ed.). Boston, MA: Cengage Learning.

Objectives
The student will be able to:

A. Create worksheets with labels, values, functions, and formulas.

B. Design charts and tables.

C. Apply appropriate formatting to worksheets, tables, and charts.

D. Utilize sorting and filtering commands to edit lists.

E. Employ integration tools to incorporate other Microsoft® applications.

F. Implement “what-if analyses”.

G. Utilize print options.

Content
A. Worksheets

B. Worksheet data

C. Charts

D. Tables

E. Lists

F. Formulas

G. Functions

Student Evaluation
Objectives A through G will be assessed through textbook and simulation software assignments, application and written tests and/or quizzes, and a comprehensive final exam.