| |
May 10, 2025
|
|
|
|
|
2022-2023 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 MIN: 3
LECTURE HOURS MIN: 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)
|
|
