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. Minimum Number of Instructional Minutes Per Semester
1000 minutes
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. 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.
VIII. 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