Jun 24, 2024  

Add to Portfolio (opens a new window)

CST 155 - Microsoft EXCEL

Credits: 3
Presents EXCEL features using personal and business applications. Emphasizes features and techniques to develop solutions to spreadsheet problems. Includes evaluation of spreadsheets, data base, report formatting, 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 103  and CST 123  or CST 133W  .
Corequisite(s): None
Lecture Hours: 45 Lab Hours: 0
Meets MTA Requirement: None
Pass/NoCredit: Yes

Outcomes and Objectives
  1. Demonstrate 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 the features supplied by the Graphical User Interface of Operating System; including the Menu and Icon/Tool bars.
    5. Understand and is able to explain the terminology of electronic spreadsheets.
  2. Use Excel’s charting/graphing features.
    1. Understand the basic concepts of relating presentation graphics to sets of numbers.
    2. Creates Bar, Area, Line, and Pie Charts.
    3. Creates, places and manipulates charts on a worksheet.
  3. Use Excel’s database features.
    1. Understand the basic concepts of list management.
    2. Prepare a list of records.
    3. Perform sorts on database records.
    4. Perform queries within database records.
    5. Set up selection criteria/filtering and output spaces.
  4. Demonstrate ability to create elementary Macros.
    1. Record a Macro.
    2. Run a Macro.
    3. View a Macro.

Add to Portfolio (opens a new window)