OADM230 Microsoft Office

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

I. Course Number and Title
OADM230 Microsoft Office
II. Number of Credits
3 credits
III. Number of Instructional Minutes
IV. Prerequisites
OADM225 (C or better) or
V. Other Pertinent Information
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. Course Learning Goals

    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.
  2. Planned Sequence of Topics and/or Learning Activities

    1. Internet research to access supportive material and hyperlinks

    2. Microsoft Word
      1. create a newsletter
      2. prepare tables and use table styles
      3. create reports using WordArt, clip art, and graphics
      4. develop diagrams
      5. insert hyperlinks
      6. develop a brochure
      7. implement a mail merge operation
      8. create a resume
    3. Microsoft Excel
      1. prepare workbooks with appropriate formatting and enhancements
      2. create charts
      3. add formulas
      4. create scenarios
      5. create grade books; use lookup to calculate averages
      6. work with complex formulas
      7. create PivotTables
      8. set up a budget
    4. Microsoft Access
      1. set up tables
      2. create customized forms
      3. create queries and reports
    5. Microsoft PowerPoint
      1. create a slide presentation
      2. add animation and graphics
      3. create a table
      4. add charts
    6. Integration
      1. create a Word document by linking data from Excel
      2. import Excel data into Access
      3. merge database information with Word to produce letters
      4. analyze database information in Excel to create charts and worksheets
      5. create a report in Word and add Excell and PowerPoint objects, as well as an Access report
      6. create a presentation in PowerPoint from a Word outline and insert data entered in Access and analyzed in Excel
      7. create a form in Access and add a picture edited in PowerPoint
  3. Assessment Methods for Course Learning Goals

    The assessment of course learning goals is based on performance-based assignments and a final applications project.
  4. Reference, Resource, or Learning Materials to be used by Student:

    See course syllabus.

Review/Approval Date - 10/98; Revised 1/2010; New Core 8/2015