Nov 30, 2020  
2020 - 2021 Catalog 
    
2020 - 2021 Catalog
Add to Portfolio (opens a new window)

CST 155 - Microsoft EXCEL

Credits: 3
Instructional Contact Hours: 3

Presents EXCEL features using personal and business applications. Emphasizes features and techniques to develop solutions to spreadsheet problems. Includes the evaluation of spreadsheets, database, report formatting, data analysis, and macros. Compares EXCEL with other electronic spreadsheets. Credit may be earned in CST 151  or CST 155 but not both.

Prerequisite(s): MATH LEVEL 3 and READING LEVEL 2. Recommend CST 133W  or basic Operating System and file management skills.
Corequisite(s): None
Lecture Hours: 45 Lab Hours: 0
Meets MTA Requirement: None
Pass/NoCredit: Yes

Outcomes and Objectives  

  1. Demonstrated understanding of electronic spreadsheets' basic concepts.
    1. Effectively use the features for entering values, labels, and formulas.
    2. Effectively use the editing features of Excel.
    3. Effectively use the basic “built-in-functions” of Excel.
    4. Understand and efficiently use the graphical user interface features.
    5. Understand and explain the terminology of electronic spreadsheets.
  2. Demonstrate understanding of electronic spreadsheets’ advanced features.
    1. Create and use named ranges.
    2. Define validation rules and criteria.
    3. Differentiate between worksheet protection and locked cell properties.
    4. Create and edit hyperlinks.
    5. Use an existing template.
    6. Create a custom workbook template.
    7. Effectively use conditional formatting.
    8. Create custom themes and cell styles.
  3. Use Excel’s charting/ graphical features.
    1. Understand the basic concepts of relating presentation graphics to sets of numbers.
    2. Understand the data to be plotted and the appropriate chart type to use.
    3. Create charts, including, but not limited to Bar, Area, Line, and Pie Charts.
    4. Manipulate and edit charts on a worksheet.
    5. Create multi-axes charts.
    6. Manage dynamic and interactive chart functions.
  4. Use Excel’s database features.
    1. Understand the basic concepts of table management.
    2. Prepare a list of records.
    3. Perform sorts on table records.
    4. Perform queries within database records.
    5. Set up selection criteria and filtering of records.
    6. Design, edit and use PivotTables and PivotCharts.
    7. Create and manage interactive dashboards. 
  5. Demonstrate ability to efficiently use macros in applications.
    1. Enable and use developer functions and shortcuts.
    2. Record, run and save a macro.
    3. Understand basic VBA code structure in order to make simple edits in the Visual Basic Editor.
    4. Understand macro security settings.
  6. Manage multiple worksheets and workbooks.
    1. Consolidate and manage data from multiple workbooks.
    2. Understand 3D references.
    3. Summarize grouped worksheets.
    4. Import and manage data from external sources.
  7. Demonstrate effective use of Advanced Functions.
    1. Understand the syntax of functions.
    2. Recognize and apply structured references in formulas.
    3. Formulate advanced formulas using a variety of functions, including but not limited to, logical, financial, text, lookup and statistical functions to solve problems.
    4. Create nested functions. 
  8. Perform a variety of what-if analyses.
    1. Effectively use goal seek.
    2. Create one- and two-variable data tables.
    3. Define, edit, and apply different scenarios using Scenario Manager.
    4. Construct a solver model applying a variety of constraints.



Add to Portfolio (opens a new window)