OADM230 Microsoft Office

Department of Business Studies: Office Administration

I. Course Number and Title
OADM230 Microsoft Office
II. Number of Credits
3 credits
III. Minimum Number of Instructional Minutes Per Semester
2250
IV. Prerequisites
OADM225 (C or better)
Corequisites
OADM226
V. Other Pertinent Information
This course is offered only in the TOTAL Lab.
VI. Catalog Course Description
This is a project-based hands-on approach course using integration features of Microsoft Office to copy, paste, link, and embed files from one program to another using Microsoft Word, Access, Excel and PowerPoint.
VII. Required Course Content and Direction
  1. Learning Goals:

    1. Course
    2. Students will
      1. complete real-world projects relating to the Microsoft Office suite of products;
      2. integrate multiple software products while completing projects;
      3. demonstrate an understanding of creative and critical thinking skills while completing projects;
      4. develop independent work habits;
      5. select Internet search engine tools for locating appropriate information;
      6. use multimedia and graphics to enhance document and presentation design, layout, functionality and appearance;
      7. analyze real-world business problems and then apply appropriate media and strategies to develop solutions; and
      8. integrate and reinforce skills and knowledge acquired in previous courses.

    3. Core (if applicable)
    4. This course is not included in the Core.
  2. Planned Sequence of Topics and/or Learning Activities:

    1. Internet research to access supportive material and hyperlinks

    2. Microsoft Word

      • create a newsletter
      • prepare tables and use table styles
      • create reports using WordArt, clip art, and graphics
      • develop diagrams
      • insert hyperlinks
      • develop a brochure
      • implement a mail merge operation
      • create a resume

    3. Microsoft Excel

      • prepare workbooks with appropriate formatting and enhancements
      • create charts
      • add formulas
      • create scenarios
      • create grade books; use lookup to calculate averages
      • work with complex formulas
      • create PivotTables
      • set up a budget

    4. Microsoft Access

      • set up tables
      • create customized forms
      • create queries and reports

    5. Microsoft PowerPoint

      • create a slide presentation
      • add animation and graphics
      • create a table
      • add charts

    6. Integration

      • create a Word document by linking data from Excel
      • import Excel data into Access
      • merge database information with Word to produce letters
      • analyze database information in Excel to create charts and worksheets
      • create a report in Word and add Excell and PowerPoint objects as well as an Access report
      • create a presentation in PowerPoint from a Word outline, and insert data entered in Access and analyzed in Excel
      • create a form in Access and add a picture edited in PowerPoint
  3. Assessment Methods for Core Learning Goals:

    1. Course
    2. The assessment of course learning goals is based on performance based assignments and a final applications project.

    3. Core (if applicable)
    4. This course is not included in the Core.
  4. Reference, Resource, or Learning Materials to be used by Students:

    See course format.
VIII. Teaching Methods Employed
Section VIII is not being used in new and revised syllabi as of 12/10/08.

Review/Approval Date - 10/98; Revised 1/2010