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. Students will be able to gather and use information on the World Wide Web.

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:
    • 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
  • Use Excel to:
    • 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
  • Use Access to:
    • Set up tables
    • Create customized forms
    • Create queries and reports
  • Use PowerPoint to:
    • Create a slide presentation
    • Add animation and graphics
    • Create a table
    • Add charts
• • Use Integration to:
  • • 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 Excel 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

Required:

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

Technical Requirements:

Review the Technical Requirements link above. The course requires:

• Internet Explorer or
• Netscape

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 21-Dec-07 © Howard Community College, 2000