Delta College logo

Microsoft EXCEL

Course NumberCST 155
Credits3
Lab Hours0
Lecture Hours45
Course DescriptionPresents 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 only one of the following: CST 151, CIS 132, CST 155, or CIS 136. (45-0)


Outcomes and Objectives

Student understands the basic concepts of Electronic Spreadsheets. To meet this outcome, the student should do the following:
Objectives:
  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.

Student effectively uses the charting/graphing features of EXCEL. To meet this outcome, the student should do the following:
Objectives:
  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.

Student effectively uses the Database feature/s of EXCEL. To meet this outcome, the student should do the following:
Objectives:
  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. Able to set up selection criteria/filtering and output spaces.

Student understands the basics of Macros and is able to create elementary Macros. To meet this outcome, the student should do the following:
Objectives:
  1. Record a Macro.
  2. Run a Macro.
  3. View a Macro.




1961 Delta Road, University Center MI 48710 | 989-686-9000 | info@delta.edu
Delta College is an Equal Opportunity Organization, committed to excellence through inclusiveness and diversity.
Copyright ©