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