OADM142 Basic Applications of Microsoft Excel

Department of Business Studies: Office Administration

  1. Course Number and Title

    OADM142 Basic Applications of Microsoft Excel

  2. Number of Credits

    1 credit

  3. Minimum Number of Instructional Minutes Per Semester

    1000

  4. Prerequisites

    Corequisites

    None

  5. Other Pertinent Information

    This course is offered only in the TOTAL Lab.

  6. Catalog Course Description

    This course is designed for students wishing to master the fundamentals of Microsoft Excel. Students acquire a working knowledge of Excel with emphasis on creating, modifying, and formatting worksheets; performing calculations; developing and formatting workbooks; and applying formulas, charts and graphs in spreadsheets.

  7. Required Course Content and Direction

    1. Learning Goals:

      1. Course
        2. Students will
        1. develop, modify, format, and print a worksheet; and
        2. apply formulas, charts, and graphs in spreadsheets.
      2. Core (if applicable)
        3. This course is not included in the Core.

    2. Planned Sequence of Topics and/or Learning Activities:

      1. getting started
      2. modifying a worksheet
      3. performing calculations
      4. formatting a worksheet
      5. developing a workbook
      6. printing a workbook
      7. applying formulas, charts and graphs in a spreadsheet

    3. Assessment Methods for Core Learning Goals:

      1. Course
        2. The assessment of course learning goals is based on creating a variety of performance based tasks or projects using Excel software.

      2. Core (if applicable)
        3. This course is not included in the Core.

    4. Reference, Resource, or Learning Materials to be used by Students:

      See course format.

  8. Teaching Methods Employed

    Section VIII is not being used in new and revised syllabi as of 12/10/08.

Review/Approval Date - 5/04; Revised 1/2010; Revised 4/2013