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

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.
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.
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.
Demonstrate ability to create elementary Macros.
1. Record a Macro.
2. Run a Macro.
3. View a Macro.