CPAP: Video Lectures

CPAP exam consists of two parts: (1) MS Office Word and (2) MS Office Excel. To pass the exam, you should receive 50/100 from each part.

Word

Word Workshop (Blackboard login required):

Word lesson videos (included in the exam):

Getting to Know Word	General Introduction
Creating and Opening Documents	Creating a blank document, pre-designed templates Opening an existing document
Saving and Sharing Documents	Saving, exporting and sharing
Text Basics	Adding, deleting, and moving text Find and replace specific words or phrases
Formatting Text	Adjusting the font inc. size, color Adjust the alignment of the text
Page Layout	Page orientation, margins, and size
Indents and Tabs	Setting tabs and indents
Line and Paragraph Spacing	Line and paragraph spacing
Lists	Modifying and inserting bullets, numbered lists
Breaks	Adding breaks such as a page break or a section break
Headers, Footers, and Page Numbers	Adding headers and footers such as page numbers, dates, an author's name, and footnotes etc.
Pictures and Text Wrapping	Inserting pictures
Shapes	Adding shapes such as arrows, callouts, squares etc.
Arranging Objects	Arranging the objects by aligning, ordering, rotating etc.
Tables	Creating a table Converting text to a table, and applying styles and formats
Charts	Inserting and adjusting a chart
Spelling and Grammar	Producing professional, error-free documents
Track Changes and Comments	Proofreading or collaborating on a document Editing document, marking spelling errors, or adding comments in the margins etc.
Styles	Predefining combination of font style, color, and size

Advanced topics (NOT included in the exam):

Printing Documents	Previewing and printing a document
Hyperlinks	Adding hyperlinks to text
Formatting Pictures	VPersonalizing and modifying pictures
Text Boxes and WordArt	Moving text around the document, text boxes and WordArt
Finalizing and Protecting Documents	Use several word tools to finalize and protect your document
SmartArt Graphics	Communicate information with graphics
Themes	Changing the tone of the entire document

Excel Workshop (Blackboard login required):

Excel lesson videos (content included in the exam):

Getting to Know Excel	How and why Excel is used
Creating and Opening Workbooks	Creating a blank workbook, pre-designed template Opening an existing workbook
Cell Basics	Basics of cells and cell content to calculate, analyze, and organize data
Saving and Sharing Workbooks	Saving, exporting, and sharing (using SkyDrive)
Modifying Columns, Cells, and Rows	Modifying column width and row height Wrapping text and merging cells
Formatting Cells	Formatting to customize the look and feel of the workbook
Worksheet Basics	Creating multiple worksheets to help organize the workbook Grouping worksheets
Simple Formulas	Basic arithmetic operations Using cell references to create simple formulas
Solving Real-Life Problems in Excel	Some strategies for writing formulas that work
Complex Formulas	Complex formulas with order of operations
Cell References	Relative and absolute references
Functions	Common functions such as sum, average, count, maximum etc. Different parts of a function and how to create arguments to calculate values and cell references
Sorting Data	Reorganizing a worksheet by sorting the data Sorting alphabetically, numerically, and in many other ways
Filtering Data	Using filters to to narrow down the data in the worksheet Allowing to view only the information that is needed
Charts	Illustrating the workbook data graphically, which makes it easy to visualize comparisons and trends