OADM242 Excel Level II (Experimental)

Department of Business Studies: Office Administration

I. Course Number and Title
OADM242 Excel Level II (Experimental)
II. Number of Credits
1 credit
III. Number of Instructional Minutes
1000
IV. Prerequisites
OADM142
Corequisites
None
V. Other Pertinent Information
This course will be offered in the TOTAL Lab.
VI. Catalog Course Description
Additional Excel spreadsheet techniques and application, including macro programming, database searching, extraction, and linking to obtain prescribed reports and graphs.
VII. Required Course Content and Direction
  1. Course 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; and
    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 Course Learning Goals

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

    See course syllabus for required textbooks.

Review/Approval Date - Unavailable; New Core 8/2015