2021-2022 Catalog [ARCHIVED CATALOG]
|
BOAT 218 - Microsoft Excel
PREREQUISITES: Demonstrated competency through appropriate assessment or a grade of “C” or better in MATH 023 - Essentials of Algebra or MATH 080 - Mathematical Principles .
PROGRAM: Business Operations, Applications, and Technology
CREDIT HOURS: 3
LECTURE HOURS: 3
DATE OF LAST REVISION: Summer, 2020
Provides an in-depth understanding of worksheet design, charting, what-if analysis, worksheet database creation and manipulation, and OLE using Microsoft Excel. Knowledge and use of a spreadsheet will be applied to various business applications. Integration of spreadsheets in other applications will be addressed. Students are required to demonstrate course objectives through the appropriate Microsoft certification examination.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course, the student will be expected to:
- Create worksheets and workbooks.
- Navigate through worksheets and workbooks.
- Format worksheets and workbooks.
- Customize options and views for worksheets and workbooks.
- Configure worksheets and workbooks to print or save.
- Insert data in cells and ranges.
- Format cells and ranges.
- Order and group cells and ranges.
- Create a table.
- Modify a table.
- Filter and sort a table.
- Utilize cell ranges and references in formulas and functions.
- Summarize data with functions.
- Utilize conditional logic in functions.
- Format and modify text with functions.
- Create a chart.
- Format a chart.
- Insert and format an object.
- Recognize special and/or advanced software features as they relate to software certifications.
COURSE CONTENT: Topical areas of study include - Working with cells and cell data
Formatting and printing worksheets
Managing workbooks
Modifying workbooks
Creating and modifying graphics
Workgroup collaboration
Managing workbooks
Formatting numbers
Working with ranges
Auditing worksheets
Summarizing data
Analyzing data
Workgroup collaboration
Creating and revising formulas
Course Addendum - Syllabus (Click to expand)
|
