Common Course Outline
Course discipline/number/title
AOP 2360: Advanced Microsoft Excel
Catalog Description
| Credits | 3 |
|---|---|
| Hours/Week | 3 |
| Prerequisites (Course discipline/number) | AOP 1360 |
| Other requirements | None |
| MnTC Goals (if any) | NA |
Course Description
This course is designed for continued development of advanced spreadsheet knowledge and skills using Microsoft Excel. Students will be utilizing Microsoft Excel tools to analyze data, present data in a usable format, and validate data methods. Critical thinking and analysis skills will be utilized to make data-informed decisions.
Date Last Revised (Month, year)
February, 2025
Outline of Major Content Areas
- Data tables
- Advanced formulas and functions
- Conditional and logical functions
- Formula auditing, data validation, and complex problem solving
- Multiple worksheets and workbooks
- Data analysis tools
- Macros, templates, and styles
Learning Outcomes (General)
The student will be able to:
- Employ data analysis tools
- Apply advanced formulas and functions to calculate outcomes
- Create macros and templates to automate spreadsheet functions
- Perform data validation
- Format data and spreadsheets to present to different audiences
- Link multiple worksheets and workbooks
Learning Outcomes (MnTC)
NA
Methods for Evaluation of Student Learning
Methods may include but are not limited to:
- Examinations
- Assignments
- Projects
RCTC Core Outcome(s)
This course contributes to meeting the following RCTC Core Outcome(s):
- Critical Thinking
- Students will think systematically and explore information thoroughly before accepting or formulating a position or conclusion.
Special Information (if any)
None