Course | Madison College Outline of Instruction

10106168Microsoft Office for Business Applications

Course Information

Description

Learn basic features of Excel, Word, PowerPoint, and Outlook using Microsoft Office 365. Explore Excel to create workbooks, write formulas & functions, manage data, and produce charts & graphs. Discover how Word can automatically generate footnotes, insert citations, and create a bibliography. Create presentations through PowerPoint focusing on layout and design elements. Manage email and calendar using Outlook. PREREQUISITE: File management skills; saving, organizing, retrieving files.

Total Credits

Prior Learning Assessment

Exam-College Developed Challenge Exam

Course Competencies

Communicate and Manage Email Messages using Outlook

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Add a Microsoft account to Outlook

Set language preferences and Sensitivity levels

Apply a theme

Compose, address, and send a professional email message

Open, read, print, and close an email message

Preview and save a file attachment

Display the People Pane

Reply to an email message

Check spelling as you type an email message

Attach a file to an outgoing email message

Forward an email message

Copy another person when sending an email message

Create and move messages into a folder

Delete an email message

View the mailbox size
Schedule Activities and Manage the Outlook Calendar

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Navigate within the calendar

View specific dates using the Date Navigator

Create a personal calendar

Schedule and save new appointments, including one-time and recurring appointments

Move and edit appointments

Delete a single occurrence of a recurring appointment

Delete appointments

Set the status of and a reminder for appointments

Create and schedule events, including on-time and recurring events

Edit, move, and delete events

Generate and edit meeting requests

Remove attendee names from a meeting

Respond to meeting requests

Cancel meetings

Display the calendar in Day, Work Week, Week, and Month views

Review the calendar in Overlay Mode

Print the calendar in Daily Style, Weekly Calendar Style

Change the current view to list view

Export a calendar subfolder to a storage device

Delete a personal calendar subfolder
Create and Edit Presentations Using Microsoft PowerPoint

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Create, open, and save a presentation.

Work with slides, layouts, placeholders, and text

Navigate between slides and organize content by reproducing and rearranging slides

Change theme colors and fonts

Insert headers and footers to add identifying information

Insert, resize, and align a picture from a file.

Apply and modify transition effects to add visual interest.

Preview a presentation and print slides, handouts, and outlines

Apply presentation properties
Illustrate Presentations with Pictures and Information graphics

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Work with shapes, styles, effects, and colors

Work with icons and 3D models

Search for pictures and illustrations, modify picture appearance, and compress picture file size

Use tables to organize information in a grid format of columns and rows

Format a table by applying styles, colors, and affects

Show processes and relationships with SmartArt graphics

Format a SmartArt graphic by applying styles, colors, and effects

Create charts that show relationships between data values and emphasize date in different ways based on the chart type and chart elements

Format a chart by applying preset styles or customizing individual chart elements
Create Documents with Microsoft Word

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Plan a document

Explore the Word window

Start a document

Save a document

Select text

Format text using the mini toolbar and the ribbon

View and navigate a document

Cut and paste text

Copy and paste text

Format with fonts

Set document margins

Add bullets and numbering

Insert a graphic

Apply a theme
Edit and Format Documents

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Find and replace text

Check spelling and grammar

Research Information

Insert comments

Change line spacing and indents

Apply styles to text

Insert page numbers and page breaks

Add headers and footers

Add footnotes and endnotes

Insert citations

Create a bibliography

Inspect a document
Format Text and Graphics in Microsoft Word

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Use the Format Painter

Work with tabs

Add borders and shading

Insert online pictures

Insert a table

Insert and delete rows and columns

Apply a table style

Size and scale a graphic

Draw and format shapes

Arrange graphic objects

Create SmartArt graphics
Format Tables and Documents in Word

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Modify character spacing

Work with indents

Insert a section break

Modify a table

Modify rows and columns

Sort table data

Split and merge cells

Perform calculations in tables

Modify table style options

Customize a table format

Insert a cover page
Create a Workbook using Microsoft Excel

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Explore the excel window

Enter and edit cell data

Enter formulas and use AutoSum

Copy formulas with relative and absolute cell references

Enter formulas with multiple operators

Switch worksheet views

Choose print options
Format a Worksheet

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Format values in excel

Change font and font size

Adjust column widths and row heights

Insert and delete columns and rows

Apply colors, borders, and documentation

Apply conditional formatting

Rename and move a worksheet

Check workbook spelling
Analyze Data Using Formulas

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Enter a formula using the quick analysis tool

Build logical functions

Round a value with a function

Build a statistical formula

Use date functions

Work with equation tools

Control worksheet calculations
Working with Charts

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Plan a chart

Create a chart

Move and resize a chart

Change chart design

Change chart layout

Format a chart

Summarize data with sparklines

Identify data trends
Working with Tables

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Create and format an excel table

Add and delete table data

Sort table data

Use formulas in a table

Filter a table

Look up values in a table

Summarize table data

Validate table data
Managing Workbook Data

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

View and arrange worksheets

Protect worksheets and workbooks

Save custom views of a worksheet

Prepare a worksheet for distribution

Insert hyperlinks

Save a workbook for distribution

Work with grouped data and worksheets
Integrate Microsoft Office Software

Assessment Strategies

through actual performance of the skills

using a computer and Microsoft Office 365

in submitted files as specified on the chapter learning plan by specified assignment deadlines

Criteria

Finalize an Excel spreadsheet

Finalize a Word document

Integrate Excel and Word information to enhance a PowerPoint presentation