CIT 155 - Excel Spreadsheets
Credits: 3
3 Lecture Hours
Prerequisites: Basic skills using a personal computer and Windows operating system, keyboarding and basic exposure to Microsoft Office. Ability to effectively manage Windows files and folders. Eligibility for MAT 090 .
Description
This course introduces students to electronic spreadsheets, tables and charts for solving business and technical problems using Microsoft Excel. Students learn through applied and project-based activities that go beyond the mechanics of the software. Students utilize critical thinking activities for applied learning and problem solving. Topics include statistical, mathematical, financial and data analytical functions.
Learning Outcomes
Upon successful completion of the course, the student will:
- Create effective worksheets and workbooks with formulas and functions.
- Create and manage Excel tables, charts, PivotTables and PivotCharts.
- Perform data analysis using What-If, Goal Seek, Scenario Manager and Solver.
- Look up data using advanced functions.
- Prepare workbooks for collaboration.
- Create and modify macros.
- Apply advanced conditional formatting and filtering.
Listed Topics
- Excel workbook fundamentals
- Formulas and functions
- Cell, worksheet and workbook enhancements
- Charts and chart tools
- Pivot tables, charts and slicers
- Workbook management
- Advanced worksheet formatting
- Advanced functions and formulas
- Data analysis tools
- Macro management
Reference Materials
Textbooks/material, current and appropriate software, multimedia for lecture and demonstration as required by instructor, access to the Internet.
Students who successfully complete this course acquire general knowledge, skills and abilities that align with CCAC’s definition of an educated person. Specifically, this course fulfills these General Education Goals: - Technological Competence
- Critical Thinking & Problem Solving
Approved By: Dr. Quintin B. Bullock Date Approved: 01/02/2020
Course and Section Search
Add to Portfolio (opens a new window)
|