OADM230 Microsoft Office
Department of Science, Technology, Engineering & Mathematics: STEM Department Archive
- I. Course Number and Title
- OADM230 Microsoft Office Course No Longer Offered
- II. Number of Credits
- 3 credits
- III. Number of Instructional Minutes
- 2250
- IV. Prerequisites
- OADM225 (C or better) or
- Corequisites
- OADM226
- 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
-
-
Course Learning Goals
Students will:
- complete real-world projects relating to the Microsoft Office suite of products;
- integrate multiple software products while completing projects;
- demonstrate an understanding of creative and critical thinking skills while completing projects;
- develop independent work habits;
- select Internet search engine tools for locating appropriate information;
- use multimedia and graphics to enhance document and presentation design, layout, functionality, and appearance;
- analyze real-world business problems and then apply appropriate media and strategies to develop solutions; and
- integrate and reinforce skills and knowledge acquired in previous courses.
-
Planned Sequence of Topics and/or Learning Activities
- Internet research to access supportive material and hyperlinks
- 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
- 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
- Microsoft Access
- set up tables
- create customized forms
- create queries and reports
- Microsoft PowerPoint
- create a slide presentation
- add animation and graphics
- create a table
- add charts
- 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
-
Assessment Methods for Course Learning Goals
The assessment of course learning goals is based on performance-based assignments and a final applications project. -
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; Archived 04/04/2019