IC³ Key Applications
Course Specifications
Course number: 084304
Course length: 3.0 day(s)
Course Description
Course Objective: You will create, edit, and enhance standard business documents using
Microsoft® Office 2007.
Target Student: This course is intended for individuals who want to gain basic knowledge
of working in Microsoft® Office 2007.
Prerequisites: Students should be familiar with using personal computers
and have used a mouse and keyboard. You should be comfortable in the Windows
environment and be able to use Windows to manage information on your computer.
Specifically, you should be able to launch and close programs; navigate to
information stored on the computer; and manage files and folders. Students
should have completed the following courses or possess equivalent knowledge
before starting with this course:
- IC³ Computing Fundamentals
Hardware Requirements
For this course, you will need one computer for each student
and one for the instructor. Each computer will need the following minimum
hardware components:
- A 1 GHz Pentium-class processor or faster
- Minimum 512MB of RAM or higher
- 128 MB graphics processor that supports DirectX® 9.0
- A 40 GB hard disk or larger You should have at least 1 GB
of free hard disk space available for the Office installation.
- CD/DVD R/RW drive
- A keyboard and mouse or other pointing device
- Generic Monitor (1024x768)
- Network cards and cabling for local network access
- High-speed Internet connection
- A printer (optional) or an installed printer driver
- A projection system to display the instructor’s computer
screen
Software Requirements
Each computer requires the following software:
- Microsoft® Windows® 7 Ultimate edition
- DirectX® 9.0
- Microsoft® Office Professional Plus 2007 edition.
- Microsoft Office Suite Service Pack 2
Course Objectives
Upon successful completion of this course, students will be able to:
- create a basic document using Microsoft Word.
- edit documents by locating and modifying text.
- format text.
- format paragraphs.
- add tables to a document.
- explore the Microsoft® Office Excel® 2007 environment
and create a basic worksheet.
- perform calculations.
- modify a worksheet.
- format a worksheet.
- print workbook contents.
- organize worksheet and table data using various techniques.
- create and modify charts.
- get started with PowerPoint.
- create a presentation.
- format text on slides.
Course Content
- Lesson 1: Creating a Basic Document
- Topic 1A: Explore the User Interface
- Topic 1B: Open and View a Document
- Topic 1C: Customize the Word Environment
- Topic 1D: Obtain Help
- Topic 1E: Enter Text
- Topic 1F: Save a Document
- Topic 1G: Preview and Print a Document
- Lesson 2: Editing a Document
- Topic 2A: Navigate and Select Text in a Document
- Topic 2B: Insert, Delete, or Rearrange Text
- Topic 2C: Undo Changes
- Topic 2D: Search and Replace Text
- Lesson 3: Formatting Text
- Topic 3A: Change
Font Appearance
- Topic 3B: Highlight
Text
- Lesson 4: Formatting Paragraphs
- Topic 4A: Set Tabs to Align Text
- Topic 4B: Control Paragraph Layout
- Topic 4C: Add Borders
and Shading
- Topic 4D: Apply
Styles
- Topic 4E: Create Lists
- Topic 4F: Manage Formatting
- Lesson 5: Adding Tables
- Topic 5A: Create a Table
- Topic 5B: Modify
the Table Structure
- Topic 5C: Format a Table
- Topic 5D: Convert Text to a Table or Tables to Text
- Lesson 6: Creating a Basic Worksheet
- Topic 6A: Explore the User Interface and the Ribbon
- Topic 6B: Navigate and Select in Excel
- Topic 6C: Obtain Help
- Topic 6D: Enter Data and Save a Workbook
- Topic 6E: Customize the Quick Access Toolbar
- Lesson 7: Performing Calculations
- Topic 7A: Create Basic Formulas
- Topic 7B: Calculate with Functions
- Topic 7C: Copy Formulas and Functions
- Lesson 8: Modifying a Worksheet
- Topic 8A: Manipulate
Data
- Topic 8B: Insert and Delete Cells, Columns, and Rows
- Lesson 9: Formatting a Worksheet
- Topic 9A: Modify Fonts
- Topic 9B: Add Borders and Color to Cells
- Topic 9C: Change Column Width and Row Height
- Topic 9D: Apply Number Formats
- Topic 9E: Position Cell Contents
- Topic 9F: Apply Cell Styles
- Lesson 10: Printing Workbook Contents
- Topic 10A: Print Workbook Contents Using Default Print Options
- Topic 10B: Set Print Options
- Topic 10C: Set Page Breaks
- Lesson 11: Organizing Worksheet and Table Data
- Topic 11A: Create and Modify Tables
- Topic 11B: Format Tables
- Topic 11C: Sort or Filter Worksheet or Table Data
- Lesson 12: Presenting Data Using Charts
- Topic 12A: Create a Chart
- Topic 12B: Modify Charts
- Topic 12C: Format Charts
- Lesson 13: Getting
Started with PowerPoint
- Topic 13A: Explore the User Interface
- Topic 13B: Navigate and View a Presentation
- Topic 13C: Use Microsoft PowerPoint Help
- Topic 13D: Enter Text
- Topic 13E: Save a Presentation
- Lesson 14: Creating a Presentation
- Topic 14A: Create a Presentation
- Topic 14B: Edit Text
- Topic 14C: Add Slides to a Presentation
- Topic 14D: Arrange Slides
- Topic 14E: Work with Themes
- Lesson 15: Formatting Text on Slides
- Topic 15A: Apply Character Formats
- Topic 15B: Apply Paragraph Formats
- Topic 15C: Format Text Placeholders