Feb 27, 2024
2021-2022 Catalog
 Select a Catalog 2023-2024 Catalog 2022-2023 Catalog [ARCHIVED CATALOG] 2021-2022 Catalog [ARCHIVED CATALOG] 2020-2021 Catalog [ARCHIVED CATALOG] 2019-2020 Catalog [ARCHIVED CATALOG] 2018-2019 Catalog [ARCHIVED CATALOG] 2017-2018 Catalog [ARCHIVED CATALOG] 2016-2017 Catalog [ARCHIVED CATALOG]
 HELP 2021-2022 Catalog [ARCHIVED CATALOG] Print-Friendly Page (opens a new window) Add to Portfolio (opens a new window)

# 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:

1. Create effective worksheets and workbooks with formulas and functions.
2. Create and manage Excel tables, charts, PivotTables and PivotCharts.
3. Perform data analysis using What-If, Goal Seek, Scenario Manager and Solver.
4. Look up data using advanced functions.
5. Prepare workbooks for collaboration.
6. Create and modify macros.
7. Apply advanced conditional formatting and filtering.
Listed Topics
1. Excel workbook fundamentals
2. Formulas and functions
3. Cell, worksheet and workbook enhancements
4. Charts and chart tools
5. Pivot tables, charts and slicers
6. Workbook management
9. Data analysis tools
10. 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)