| |
Apr 30, 2025
|
|
|
|
|
2021-2022 Catalog [ARCHIVED CATALOG]
|
BOAT 207 - Integrated Microsoft Office Applications
PREREQUISITES: Demonstrated competency through appropriate assessment or earning a grade of “C” or better in ENGL 083 - Reading Strategies for College and ENGL 093 - Introduction to College Writing , or ENGL 095 - Integrated Reading and Writing or ENGL 075 - Co-Requisite Integrated Reading & Writing and 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: Fall, 2020
Emphasizes the identification and practice of the appropriate use of technology to communicate and solve business problems and aid in decision making. Focuses primary attention to developing business problem-solving skills and decision-making skills using Excel. Also explores the advanced integration features associated with Microsoft Access, Microsoft Word and PowerPoint.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course, the student will be expected to:
- Explain the purpose of information systems to support organizations and enhance productivity.
- Explain the physical components and operation of microcomputers.
- Utilize word processing software.
- Employ spreadsheet capabilities, functions, and skills to solve business problems.
- Employ database capabilities, functions, and skills to solve business problems.
- Utilize presentation software.
- Explain the difference between computer operating systems and user software programs.
- Identify when to use appropriate features within a software application.
- Utilize internet applications and “cloud” technologies in business situations.
- Utilize collaboration technologies.
- Explain security goals, response to threats, and safeguards.
- Discuss issues related to the ethical use of information technology.
COURSE CONTENT: Topical areas of study include - Use a database program to create objects using the following features:
- Design a table using a relational database program.
- Build simple and aggregate queries.
- Build queries with formulas.
- Create queries (pattern match, list of values, parameter, and/or, calculated fields, aggregate functions).
- Create and modify tables, reports, and forms from tables and queries.
Use a spreadsheet program to create and format files using the following features:
- Create and format charts.
- Create and use PivotTables.
- Create and use named ranges.
- Create macros.
- Link worksheets, using 3-D cell references, and link workbooks.
- Lock cells and protect worksheets and workbooks.
- Sort and Filter data.
- Understand spreadsheet design.
- Use absolute cell references when appropriate.
- Use Math functions, including SUM, AVERAGE, MAX, MIN, COUNTIF, SUMIF, AVERAGEIF and ROUND.
- Use financial functions, including FV, PMT, IPMT, PPMT.
- Use Logical functions including IF, Nested IF, AND, and OR.
- Use Lookup functions, including VLOOKUP and Nested VLOOKUP.
- Use the Solver.
- Use the Subtotal feature.
- Use What-If Analysis tools, including Scenarios.
- Use Absolute and Relative cell references.
Use a word processing program to create and format files using the following features:
Use a presentation software program to create and format files using the following features:
- Add visual elements to a presentation.
- Create, customize, and deliver presentations.
Course Addendum - Syllabus (Click to expand)
|
|
