Microsoft Word

 s 

 s 

 s 

 s 

 s 

Text Manipulation

Insert, modify, and move text and symbols

Apply and modify text formats

Correct spelling and grammar usage

Apply font and text effects

Enter and format date and time

Apply character styles

Microsoft Word Interview Project
9/11/2009

Skills Set 1 Project
9/14/2009

 Microsoft Office Master
MOUS
Certification Circle
Bunin, Clemens, Fridrichsen, Hunt, Pinard
Course Technology, a division of Thomson Learning
Copyright 2003

IT 5 ~ Application Software – Identify, evaluate, select, install, use, upgrade, and customize application software; diagnose and solve problems resulting from an application software’s installation and use.

Paragraphs

Modify paragraph formats

Set and modify tabs

Apply bullet, outline, numbering format

Apply paragraph styles

Skills Set 2 Project
9/18/2009

Skills Set 1 and 2 Quiz
9/19/2009

COM 1 ~ Foundations of Communication – Communicate in a clear, courteous, concise, and correct manner on personal and professional levels.

COM 3 ~ Technological Communication – Use technology to enhance the effectiveness of communication.

COM 4 ~ Employment Communication – Integrate all forms of communication in the successful pursuit of employment.

IT 4 ~ Information Technology and Major Business Functions – Describe the information technology components of major business functions and explain their interrelationships.

Document Format

Create and modify a header and footer

Apply and modify column settings

Modify document layout and page setup options

Create and modify tables

Preview and print documents, envelopes, and labels

Newspaper Article Revision
9/21/2009

Skills Set 3 Project
9/24/2009

COM 3 ~ Technological Communication – Use technology to enhance the effectiveness of communication.

IT 4 ~ Information Technology and Major Business Functions – Describe the information technology components of major business functions and explain their interrelationships.

IT 6 ~ Input Technologies – Use input technologies appropriately to enter and manipulate text and data.

IT 7 ~ Information Retrieval – Gather, evaluate, use, and cit information from information technology sources.

Managing Documents

Manage Files and Folders for Documents

Create Documents using templates

Save documents using different names and file formats

Create a Calendar and Your Own Resume Using a Template
9/26/2009

Workgroup Collaboration

Insert images and graphics

Create and modify diagrams and charts

Examine Charts and Create Your Own Flowchart
9/28/2009

Microsoft Word

 s 

 s 

 s 

 s 

 s 

Workgroup Collaboration

Compare and merge documents

Insert, view, and edit comments

Convert documents into web pages

Skills Set 6 Project
10/1/2009

 Microsoft Office Master
MOUS
Certification Circle
Bunin, Clemens, Fridrichsen, Hunt, Pinard
Course Technology, a division of Thomson Learning
Copyright 2003

COM 1 ~ Foundations of Communication – Communicate in a clear, courteous, concise, and correct manner on personal and professional levels.

COM 2 ~ Social Communication – Apply basic social communication skills in personal and professional situations.

COM 3 ~ Technological Communication – Use technology to enhance the effectiveness of communication.

Customizing Paragraphs

Control pagination

Sort paragraphs in lists and tables

Create tables and tables of contents
10/9/2009

Integrating with Other Applications

Create and format document sections

Create apply character and paragraph styles

Create and update document indexes and tables of contents, figures, and authorities.

Create cross-references

Add and revise endnotes and footnotes

Create and manage master documents and subdocuments

Move within documents

Create and modify forms using various form controls

Create forms and prepare forms for distribution

Create your own survey
10/11/2009

Skills Set 1-8 Project
10/16/2009

COM 3 ~ Technological Communication – Use technology to enhance the effectiveness of communication.

IT 6 ~ Input Technologies – Use input technologies appropriately to enter and manipulate text and data.

Creating and modifying tables

Use Excel data in tables

Perform calculations in Word tables

Skills Set 9 Project
10/30/2009

COMP 1 ~ Mathematical Foundations – Apply basic mathematical operations to solve problems.

COMP 2 ~ Number Relationships and Operations – Solve problems involving whole numbers, decimals, fraction, percents, ratios, averages, and proportions.

COMP 6 ~ Problem-Solving Applications – Use mathematical procedures to analyze and solve business problems.

Microsoft Word

 s 

 s 

 s 

 s 

 s 

Creating and modifying forms

Create, modify, and position graphics

Create and modify charts using data from other applications

Align text and graphics

Skills Set 10 Project
11/14/2009

 Microsoft Office Master
MOUSCertification Circle
Bunin, Clemens, Fridrichsen, Hunt, Pinard
Course Technology, a division of Thomson Learning
Copyright 2003

Customizing Word

Create, edit, and run macros

Customize menus and toolbars

Skills Set 11 Project
11/19/2009

Skills Set 9,10, 11 Review
11/20/2009

Skills Sets 9,10,11 Quiz
11/21/2009

Workgroup Collaboration

Track, accept, and reject changes to documents

Merge input from several reviewers

Insert and modify hyperlinks to other documents and web pages

Create and edit web documents in Word

Create document versions

Protect documents

Define and modify default file locations for workgroup templates

Attach digital signatures to documents

Skills Set 12 Project
11/28/2009

COM 1 ~ Foundations of Communication – Communicate in a clear, courteous, concise, and correct manner on personal and professional levels.

COM 3 ~ Technological Communication – Use technology to enhance the effectiveness of communication.

Defining Relationships

Merge letters with a Word, Excel, or Access data source

Merge labels with a Word, Excel, or Access data source

Use Outlook data as a mail merge data source

Jeopardy Review!
11/29/2009

Microsoft Word Test
11/30/2009

Microsoft Office Specialist - Word Certification Exam
11/30/2009

COM 3 ~ Technological Communication – Use technology to enhance the effectiveness of communication.

IT 4 ~ Information Technology and Major Business Functions – Describe the information technology components of major business functions and explain their interrelationships.

IT 6 ~ Input Technologies – Use input technologies appropriately to enter and manipulate text and data.

Microsoft Excel

 s 

 s 

 s 

 s 

 s 

Getting Started

Start and Exit the Excel Program

Explore the Excel Window

Open and Close an Excel Workbook

Navigate an Excel Workbook

Explore Task Panes

Copy Workbook Files

Save Workbooks

Preview and Print a Worksheet

Get Help

Excel Review Project
12/5/2009

 Microsoft Office Master
MOUS Certification Circle
Bunin, Clemens, Fridrichsen, Hunt, Pinard
Course Technology, a division of Thomson Learning
Copyright 2003

Working with Cells and Cell Data

Insert, Delete, and Move Cells

Enter and edit cell data including text, numbers, and formulas

Check spelling

Find and replace cell data and formats

Work with a subset of data by filtering lists

Excel Skills Set 1 Project
12/10/2009

IT 4 ~ Information Technology and Major Business Functions – Describe the information technology components of major business functions and explain their interrelationships.

IT 6 ~ Input Technologies – Use input technologies appropriately to enter and manipulate text and data.

Managing Workbooks

Manage workbook files and folders

Create workbooks using templates

Save workbooks using different names and file formats

Formatting and Printing Worksheets

Apply and modify cell formats

Modify row and column settings

Apply styles

Use automated tools to format worksheets

Modify page setup options for worksheets

Preview and print worksheets and workbooks

Excel Skills Set 3 Project
12/12/2009

IT 6 ~ Input Technologies – Use input technologies appropriately to enter and manipulate text and data.

Modifying Workbooks

Insert and delete worksheets

Modify worksheet names and positions

Use 3-D references

Excel Skills Set 4
12/17/2009

Creating and Revising Formulas

Create and revise formulas

Use statistical, date and time, financial, and logical functions in formulas

Skills Set 5 Terms to Know
12/1/2009

Excel Skills Set 5 Project
12/19/2009

COMP 1 ~ Mathematical Foundations – Apply basic mathematical operations to solve problems.

Microsoft Excel

 s 

 s 

 s 

 s 

 s 

Creating and Modifying Graphics

Create, modify, position, and print charts

Create, modify, and position graphics

Business First Publication Charts
1/9/2010

Create a Chart
1/10/2010

Excel Skills Set 6 Project
1/14/2010

 Microsoft Office Master
MOUSCertification Circle
Bunin, Clemens, Fridrichsen, Hunt, Pinard
Course Technology, a division of Thomson Learning
Copyright 2003

Workgroup Collaboration

Convert worksheets into web pages

Create hyperlink

View and edit comments

COM 1 ~ Foundations of Communication – Communicate in a clear, courteous, concise, and correct manner on personal and professional levels.

COM 3 ~ Technological Communication – Use technology to enhance the effectiveness of communication.

Importing and Exporting Data

Import data to Excel

Export data from Excel

Publish worksheets and workbooks to the Web

Managing Workbooks

Create, edit, and apply templates

Create workspaces

Use data consolidation

Excel Skills Set 9 Vocabulary
1/28/2010

Excel Skill Set 9 Project
1/29/2010

Microsoft Excel

 s 

 s 

 s 

 s 

 s 

Formatting Numbers

Create and apply custom number formats

Use conditional formats

 Microsoft Office Master
MOUSCertification Circle
Bunin, Clemens, Fridrichsen, Hunt, Pinard
Course Technology, a division of Thomson Learning
Copyright 2003

Working with Ranges

Use named ranges in formulas

Use lookup and reference functions

Excel Skills Set 11 VLOOKUP Activity
2/5/2010

Excel Skills Set 11 Project
2/6/2010

Customizing Excel

Customize toolbars and menus

Create, edit, and run macros

Excel Skills Set 12 Activity
2/7/2010

Excel Skills Set 12 Project
2/7/2010

Auditing Worksheets

Audit formulas

Locate and resolve errors

Identify dependencies in formulas

Summarizing Data

Use subtotals with lists and ranges

Define and apply filters

Add group and outline criteria to ranges

Use data validation

Retrieve external data and create queries

Create extensibe markup language (XML) web queries

Analyzing Data

Create PivotTable reports and PivotChart reports

Forecast values with what-if analysis

Create and display scenarios

Workgroup Collection

Modify passwords, protections, and properties

Create a shared workbook

Track, accept, and reject changes to workbooks

Merge workbooks

Excel Skills Sets 9-13 Quiz
2/13/2010

Microsoft Word/Excel Cumulative Project
2/14/2010

Microsoft Access

 s 

 s 

 s 

 s 

 s 

Getting Started

Start Access and open a database

Identify the parts of the database window

Understand database terminology

Understand the benefits of using a relational database

Manage toolbars and understand views

Use the help system

Close a database and exit Access

Creating and using databases

Create Access databses

Open Databse objects in multiple views

Move among records

Format datasheets

Creating and modifying tables

Create and modify tables

Add a pre-defined input mask to a fields

Create lookup fields

Modify field properties

Creating and modifying queries

Create and modify select queries

Add calculated fields to select queries

Creating and modifying forms

Create display forms

Modify form properties

Viewing and organizing information

Enter, edit, and delete records

Create queries

Sort records

Sort records

Filter records

Defining Relationships

Create one-to-many relationships

Enforce referential integrity

Producing Reports

Create and format reports

Add calculated controls to reports

Preview and print reports

Microsoft Access

 s 

 s 

 s 

 s 

 s 

Why would one want to import data into Access?  What can Access do with data that other applications cannot do?

Integrating with Other Applications

Import data to Access

Export data from Access

Create a simple data Access page

Creating and modifying tables

Use data validation

Link tables

Create lookup fields and modify lookup field properties

Create and modify input masks

Creating and modifying forms

Create a form in design view

Create a switchboard and set startup options

Add subform controls to Access forms

Refining queries

Specify multiple query criteria

Create and apply advanced filters

Use aggregate functions in queries

Producing Reports

Create and modify reports

Add subreport controls to Access reports

Sort and group data in reports

Defining Relationships

Establish one-to-many relationships

Establish many-to-many relationships

Microsoft PowerPoint

 s 

 s 

 s 

 s 

 s 

Getting Started

Start PowerPoint

Understand PowerPoint views

Work with objects

Get Help

Save files

Working with Cells and Cell Data

Create presentations manually and using automated tools

Add slides to and delete slides from presentations

Modify headers and footers in the slide master

Managing Workbooks

Import text from Word

Insert, format, and modify text

Formatting and Printing Worksheets

Add tables, charts, clip art, and bitmap images to slides

Customize slide backgrounds

Add OfficeArt elements to slides

Apply cutom formats to tables

Modifying Workbooks

Apply formats to presentations

Apply animation schemes

Apply slide transitions

Customize slide formats

Customize slide templates

Manage a slide master

Rehearse timing

Rearrange slides

Modify slide layout

Add links to a presentation

Microsoft PowerPoint

 s 

 s 

 s 

 s 

 s 

Create & Revise Formulas

Preview and print slides, outlines, handouts, and speaker notes

Creating and Modifying Graphics

Import Excel charts to slides

Add sound and video to slides

Insert Word tables on slides

Export a presentation as an outline

SS7

Set up slide shows

Deliver presentations

Manage files and folders for presentations

Work with embedded fonts

Publish presentations to the Web

Use Pack and Go

Importing and Exporting Data

Set up a review cycle

Review presentation comments

Schedule and deliver presentation broadcasts

Publish presentations to the Web