After successful completion of this course, students will be able to use the integration features of Microsoft® Office to copy, paste, link, and embed files from one program to another using Word, Excel, Access, and PowerPoint. Basic through advanced integration skills are covered.

Registered Students | Overall Course Objectives | Major Course Topics | Course Format | Orientation | Course Requirements | Materials | Exams

Registered Students

Immediately after enrolling, send Cathy Sutton an e-mail at csutton@howardcc.edu; include your name, the semester, the course and section. You will receive specific course instructions the week classes start.

Overall Course Objectives

This course is for students who have completed courses on the Internet and on many Microsoft Office applications and want to learn how to integrate one application with another. Once you have completed this course you will be able to:

• Complete real-world projects relating to the Microsoft Office suite of products.
• Integrate multiple software products while completing projects.
• Demonstrate 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 total-problem solutions.
• Integrate and reinforce skills and knowledge acquired in previous courses. 

Major Course Topics

• Perform research on the Internet to access supportive material and hyperlinks
• Use Word to:
• • Draft responses
  • Prepare tables
  • Create reports, using WordArt, clip art, graphics, and textboxes
  • Develop diagrams
  • Insert hyperlinks
  • AutoFormat tables
  • Develop a questionnaire as a Word and a Web document
  • Implement a mail merge operation
• Use Excel to:
• • Prepare workbooks with appropriate formatting and enhancements
  • Create charts
  • Add formulas
  • Add macros
  • Create grade books; use lookup to calculate averages
  • Work with complex formulas
  • Add hyperlinks
  • Convert a workbook to a Web document
• Use Access to:
• • Maintain a membership list
  • Create customized forms
  • Create queries and reports
• Use PowerPoint to:
• • Create a slide presentation
  • Add animation and graphics
  • Add action buttons and transitions
  • Add charts
• Use Integration to:
• • Create a Word document by summarizing data from Excel
  • Import Excel data into Access
  • Import data stored in Word into an Excel workbook
  • Apply formatting to Excel documents and convert them to Web documents
  • Implement a Merge process using Excel and Word
  • Embed a workbook into PowerPoint
  • Revise a database structure, create an input form, and export the tables to Excel
  • Publish an Excel workbook to the Web that has interactive capabilities

This course:

• Is not self-paced. However, you may accelerate your pace so that you may finish the course in fewer than 14 weeks.
• Does not require on-campus meetings. Please note, however, that all CMSY-136 online students are welcome to come to the Office Technology classroom to do classwork and/or to get personal help from an instructor.
• Does not require real-time chats.
• Uses email for communication.

Required:

• Cram, Carol. Microsoft Office 2007 – Illustrated Projects. Course Technology, 2008.
• Buy your textbooks from our online Bookstore, or visit our Bookstore.

Technical Requirements for Online Courses:

Review the Technical Requirements link above. The course requires:

• Internet Explorer

There are no exams in this course.

If you have any questions or comments about this course, please send a message to Cathy Sutton, csutton@howardcc.edu.

Last updated on 17-Feb-09 © Howard Community College, 2000