OADM242 Excel Level II (Experimental)

Department of Science, Technology, Engineering & Mathematics: Office Administration

I. Course Number and Title
OADM242 Excel Level II (Experimental)
II. Number of Credits
1 credit
III. Number of Instructional Minutes
IV. Prerequisites
V. Other Pertinent Information
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