CIS 138 Applied Spreadsheet Application II (2 credits)
Prerequisite CIS 137 with a 2.0 or higher.
Course Description
Microsoft Excel is an integral part of most business organizations. It is a robust data tracking, analytical, and decision-making tool used by for-profit and non-profit organizations around the world. It is commonly applied for operational, marketing, and financial computations decision-making. Business professionals who hold Excel certifications demonstrate facility with this powerful software and ability to add value to an organization. This course covers the advanced topics in Microsoft Excel and ties to the second level Microsoft Office Specialist (MOS) certification exam.
Course Content
1. Advanced spreadsheet functionality
2. Templates
3. Functions
4. Advanced charting and Trend-lines
5. Pivot Tables and Pivot Charts
6. Data security and legal access
Student Outcomes
1. Manage workbook options and settings such as templates, ribbons, macros, protection, and versions.
2. Apply custom number, conditional, filtering, color, style, theme, and international formats and layouts.
3. Create and use advanced date, time, logical, statistical, financial, and lookup formulas/functions.
4. Create advanced charts and tables to include trend-lines, dual-axis, chart templates, Pivot Tables, Pivot Charts, and Slicers.
5. Maintain safe, secure, and valid data and spreadsheet files according to business and legal requirements.
6. Solve business problems in such fields as accounting, finance, operations, and marketing using spreadsheet capabilities.
7. Provide legal, owner, and user spreadsheet documentation.
Degree Outcomes
Effective Communication: Graduates will be able to exchange messages in a variety of contexts using multiple methods. Program Outcome: Develop queries, forms and reports to meet user information requirements.
Lecture Contact Hours 20
Lab Contact Hours 0
Clinical Contact Hours 0
Total Contact Hours 20
Add to Portfolio (opens a new window)
|
