Feb 02, 2023  
2021-2022 Catalog 
    
2021-2022 Catalog [ARCHIVED CATALOG]

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
  7. Advanced worksheet formatting
  8. Advanced functions and formulas
  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)