OADM242 Excel Level II

Department of Business Studies: Office Administration

  1. Course Number and Title

    OADM242 Excel Level II (Experimental)

  2. Number of Credits

    1 credit

  3. Minimum Number of Instructional Minutes Per Semester

    1000 minutes

  4. Prerequisites

    OADM142

    Corequisites

    None

  5. Other Pertinent Information

    This course will be offered in the TOTAL Lab.

  6. Catalog Course Description

    Additional Excel spreadsheet techniques and application, including macro programming, database searching, extraction, and linking to obtain prescribed reports and graphs.

  7. Required Course Content and Direction

    1. Learning Goals:

      Students will be able to:

      1. organize a problem for solution with spreadsheet template.
      2. apply the principles of effective worksheet and database layout in building a spreadsheet template.
      3. create and use simple spreadsheet macros.
      4. use the spreadsheet’s database techniques to locate, link, extract, and combine data from multiple spreadsheets.
      5. use spreadsheet functions to prepare and printing graphs.
      6. use spreadsheet print capabilities to enhance printed output.

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

      1. Spreadsheet template definition and design
        1. Defining and organizing the problem
        2. Designing a template to solve the problem

      2. Spreadsheet macros
        1. Creation
        2. Use

      3. Spreadsheet database techniques
        1. Searching
        2. Linking
        3. Extracting
        4. Combining

      4. Graphing and Printing
        1. Creating graphs
        2. Printing graphs
        3. Enhancing reports

    3. Assessment Methods for Core Learning Goals:

      This course is not part of the Core curriculum.

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

      See course format for required textbooks.

  8. Teaching Methods Employed

    course work will be an individualized self-paced course taught in the TOTAL Lab under the supervision of full and part-time faculty.

Review/Approval Date - Unavailable