B8

The following material will be covered in the software program at @http://sam.cengage.com for the 1st semester: You may download this file by clicking on this link:


 * __ MICROSOFT WINDOWS __**
 * ~ ===**Week 1: Microsoft** **Windows 7 Basics**=== ||~ ===**Week 1b: Microsoft** **Office 2010 Basics and the Internet**=== ||
 * **Training, Quiz**
 * 1) Log on to the computer
 * 2) Size a window
 * 3) Close a window
 * 4) Maximize a window
 * 5) Redisplay a minimized window
 * 6) Minimize a window
 * 7) Move a window
 * 8) Open a window by double-clicking
 * 9) View the contents of the Recycle Bin
 * 10) Start Windows 7 Help
 * 11) Search the Help pages
 * 12) View files and folders with the Computer Window
 * 13) Display a folder in Explorer
 * 14) Change the appearance of the Documents window
 * 15) Navigate through the Windows hierarchy
 * 16) Create a folder in Explorer
 * 17) Rename a file
 * 18) Restore files
 * 19) Select a menu option || **Training, Quiz**
 * 20) Create a shortcut
 * 21) Display the Contents page in Help
 * 22) Display a document in Help
 * 23) Use Word Help ||


 * __ MICROSOFT WORD __**
 * ~ ===**Week 2:** **Microsoft Word Basics**=== ||
 * **Training, Quiz**
 * 1) Start Word
 * 2) Create a new blank document
 * 3) Open an existing document
 * 4) Save a document
 * 5) Close a document
 * 6) Exit Word
 * 7) Save a document with a new file name
 * 8) Print a document
 * 9) Print specific pages of a document
 * 10) Insert text
 * 11) Zoom in on a document
 * 12) Change the page orientation
 * 13) Change paper size
 * 14) Zoom to the width of a page
 * 15) Switch to Outline view || **Project tasks**
 * Insert text and understand word wrap
 * Navigate a document
 * Use backspace and delete
 * Save a document
 * Locate and open an existing document
 * Zoom a document
 * Select a page orientation ||


 * ~ ===**Week 3: Basic Editing**=== ||
 * **Training, Quiz**
 * 1) Undo and redo an action
 * 2) Move text
 * 3) Select text
 * 4) Select all the text in a document
 * 5) Copy and paste text
 * 6) Cut and paste text
 * 7) Use the Office Clipboard
 * 8) Use Paste Options
 * 9) Copy and paste between two open documents
 * 10) Paste all items from the Office Clipboard
 * 11) Display formatting marks
 * 12) Find and replace text
 * 13) Search for text
 * 14) Go to a page
 * 15) Insert a chart
 * 16) Use the Navigation Pane to reorganize a document
 * 17) Use the Navigation Pane to move to a new page
 * 18) Count words in a document || **Project tasks**
 * Edit text
 * Select text
 * Use the Clipboard to move and copy text
 * Use the Office Clipboard
 * Use the Find and Replace commands
 * Use the Go To command ||


 * ~ ===Week 4: Helpful Word Features=== ||
 * **Training, Quiz**
 * 1) Create an AutoCorrect entry
 * 2) Insert a date with AutoComplete
 * 3) Insert a hyperlink
 * 4) Insert a building block
 * 5) Modify a building block
 * 6) Manage building blocks
 * 7) Insert the current date into a document
 * 8) Insert a Quick Part
 * 9) Insert a symbol
 * 10) Insert an equation
 * 11) Check spelling
 * 12) Correct a misspelled word
 * 13) Use the Thesaurus
 * 14) Grammar check || **Project tasks**
 * Use AutoComplete as you type
 * Use AutoFormat as you type
 * Create and insert a Quick Part
 * Delete a Quick Part
 * Insert the date and time
 * Check spelling and grammar as you type
 * Use the Thesaurus
 * Insert symbols ||


 * ~ Week 5: Formatting Text ||
 * **Training, Quiz**
 * 1) Use the Format Painter
 * 2) Change the font
 * 3) Change the font size
 * 4) Bold text
 * 5) Italicize text
 * 6) Change the color of text
 * 7) Clear formatting
 * 8) Apply a text effect
 * 9) Apply a 3-D text effect
 * 10) Apply a style to a paragraph
 * 11) Create a new Quick Style
 * 12) Create a new style set
 * 13) Apply a Quick Style to text
 * 14) Modify a style
 * 15) Change the theme
 * 16) Change the theme colors and theme fonts
 * 17) Apply theme effects || **Project tasks**
 * Format text
 * Change the font
 * Change font attributes
 * Change text effects
 * Apply Quick Styles
 * Change themes
 * Create a new Quick Style
 * Clear formatting ||


 * ~ ===Week 6: Formatting Paragraphs and Documents=== ||
 * **Training, Quiz**
 * 1) Display the ruler
 * 2) Create a bulleted list
 * 3) Create a numbered list
 * 4) Create a multilevel list
 * 5) Create a numbered multi-level list
 * 6) Change bullet style to picture bullets
 * 7) Indent the first line of a paragraph
 * 8) Modify paragraph spacing
 * 9) Indent paragraphs
 * 10) Center a paragraph
 * 11) Adjust line spacing
 * 12) Right-align a paragraph
 * 13) Set a tab stop
 * 14) Set a tab leader
 * 15) Create a hanging indent
 * 16) Modify document margins
 * 17) Create custom margins
 * 18) Set the gutter margin
 * 19) Change the page layout for odd and even pages
 * 20) Demote text in Outline view
 * 21) Show specific levels in Outline view || **Project tasks**
 * Format paragraphs and documents
 * View the ruler
 * Set margins
 * Align text
 * Change indents
 * Adjust line spacing
 * Adjust paragraph spacing
 * Set, modify, and clear tab stops ||


 * ~ ===Week 7: Working with Graphics=== ||
 * **Training, Quiz**
 * 1) Apply shading to text
 * 2) Add a custom paragraph border
 * 3) Insert a picture
 * 4) Insert clip art
 * 5) Insert a shape
 * 6) Insert a SmartArt graphic
 * 7) Modify a SmartArt graphic
 * 8) Create WordArt
 * 9) Insert a text box
 * 10) Insert a sidebar
 * 11) Create columns
 * 12) Insert a column break
 * 13) Balance columns
 * 14) Create columns from this point forward
 * 15) Change column formatting
 * 16) Add a page border
 * 17) Add a background page color
 * 18) Use One Page view
 * 19) Modify the tone of a picture
 * 20) Recolor a picture
 * 21) Increase the sharpness of a picture
 * 22) Decrease the sharpness of a picture
 * 23) Set the transparent color in a graphic
 * 24) Wrap text around a graphic
 * 25) Place a graphic behind text
 * 26) Resize a graphic
 * 27) Crop a graphic
 * 28) Apply a chart style to a chart
 * 29) Apply a SmartArt style
 * 30) Change the layout of a SmartArt graphic
 * 31) Change SmartArt graphic colors
 * 32) Add a shape to a SmartArt graphic
 * 33) Fill a text box with color
 * 34) Apply a shadow to a shape
 * 35) Apply a 3-D effect to a shape
 * 36) Apply text effects to WordArt
 * 37) Align objects
 * 38) Change the shape of WordArt || **Project tasks**
 * Recolor pictures
 * Insert pictures
 * Add and draw shapes
 * Add text and callouts to your drawings
 * Modify a SmartArt graphic
 * Create WordArt ||


 * ~ ===Week 8: Working with Documents=== ||
 * **Training, Quiz**
 * 1) Modify document properties
 * 2) Enter a line break
 * 3) Delete a section break
 * 4) Delete a content control
 * 5) Adjust text flow options
 * 6) Insert a page break
 * 7) Insert a cover page
 * 8) Create a table
 * 9) Enter data in a table
 * 10) Convert text to a table
 * 11) Create a document header
 * 12) Insert page numbers
 * 13) Insert a section break
 * 14) Format a section of the document
 * 15) Use the Research pane
 * 16) Translate selected text
 * 17) Select a translation language
 * 18) Split the Word window
 * 19) Apply a table style
 * 20) Add shading to a table cell
 * 21) Add borders to a table
 * 22) Show gridlines in a table
 * 23) Insert a row in a table
 * 24) Delete a table column
 * 25) Merge cells in a table
 * 26) Split table cells
 * 27) Sort table rows
 * 28) Change table column width
 * 29) Align data in table cells || **Project tasks**
 * Insert table
 * Modify table
 * Merge cells
 * Format table
 * Resize the height of a row
 * Resize the width of a column
 * Insert predesigned cover page
 * Modify document properties ||


 * ~ ===Week 9: Increasing Efficiency Using Word=== ||
 * **Training, Quiz**
 * 1) Create a new document from a template
 * 2) Create a new file from an existing file
 * 3) Save a document as a template
 * 4) Set a default save location
 * 5) Customize the Quick Access Toolbar
 * 6) Convert a hyperlink to regular text
 * 7) Create and print an envelope
 * 8) Specify the merge document template
 * 9) Specify the merge data source
 * 10) Create and save a mail merge data source
 * 11) Create mailing labels using an existing data source
 * 12) Preview a mail merge
 * 13) Print merged form letters
 * 14) Insert a merge field
 * 15) Insert a comment
 * 16) Delete a comment
 * 17) Track changes in a document
 * 18) Open the Reviewing Pane
 * 19) Accept all changes in a document
 * 20) Accept individual changes in a document
 * 21) Reject changes in a document
 * 22) Compare documents
 * 23) Combine two documents
 * 24) Show source documents when comparing documents
 * 25) View documents side by side
 * 26) Manage multiple documents with synchronous scrolling || **Project tasks**
 * Create and use a template
 * Use mail merge
 * Create envelopes ||


 * __ MICROSOFT EXCEL __**


 * ~ ===Week 10: Excel Basics=== ||
 * **Training, Quiz**
 * 1) Start Excel
 * 2) Locate and open an existing workbook
 * 3) Save a workbook with a new name
 * 4) Save a file to a different location
 * 5) Close a workbook and exit Excel
 * 6) Print a worksheet
 * 7) Use Print Preview
 * 8) Undo an action
 * 9) Enter numbers in a cell
 * 10) Enter text in a cell
 * 11) Zoom in on a worksheet
 * 12) Clear cell content
 * 13) Find and replace text
 * 14) Use the Name box to select a cell || **Project tasks**
 * Start Excel
 * Explore the parts of the workbook
 * Open an existing workbook
 * Save a workbook
 * Move the active cell in a worksheet
 * Enter and change data in a cell
 * Zoom a worksheet
 * Close a workbook
 * Exit Excel ||


 * ~ ===Week 11: Changing the Appearance of a Worksheet=== ||
 * **Training, Quiz**
 * 1) Select non-adjacent cells
 * 2) Modify column width
 * 3) Modify row height
 * 4) Use the Format Painter
 * 5) Change the font
 * 6) Change the font size
 * 7) Apply bold
 * 8) Italicize text
 * 9) Add borders
 * 10) Change the font color
 * 11) Change fill color
 * 12) Rotate text
 * 13) Wrap text
 * 14) Merge cells and center their content
 * 15) Align cell contents
 * 16) Indent cell contents
 * 17) Apply the accounting number format
 * 18) Apply the percent style to a range
 * 19) Increase the number of decimal places
 * 20) Apply styles
 * 21) Create a new style
 * 22) Clear formatting
 * 23) Apply a theme to a worksheet
 * 24) Protect a worksheet || **Project tasks**
 * Resize columns and rows
 * Change column width
 * Position data within a cell
 * Align text
 * Merge and center data
 * Indent data
 * Change text orientation
 * Change the appearance of cells
 * Apply font styles
 * Choose font and fill colors
 * Apply cell borders
 * Select number formats
 * Use styles to format cells
 * Apply cell styles ||


 * ~ ===Week 12: Organizing the Worksheet=== ||
 * **Training, Quiz**
 * 1) Move cell contents
 * 2) Fill adjacent cells with formulas
 * 3) Copy cell contents
 * 4) Transpose data
 * 5) Insert a cell
 * 6) Insert rows
 * 7) Delete cells
 * 8) Delete rows
 * 9) Fill a range of cells with a series
 * 10) Autofill a numeric series
 * 11) Copy 3-D references
 * 12) Insert a header
 * 13) Change worksheet margins
 * 14) Modify worksheet orientation
 * 15) Set the print area
 * 16) Insert a page break
 * 17) Fit a worksheet to one page for printing
 * 18) Define print titles
 * 19) Use Scale to Fit to print
 * 20) Check spelling
 * 21) Freeze rows and columns
 * 22) Use Page Break Preview
 * 23) Use Page Layout view
 * 24) Split the Excel window into panes || **Project tasks**
 * Copy and move cells
 * Insert and delete rows, columns, and cells
 * Split a worksheet window
 * Check spelling in a worksheet
 * Insert headers and footers in a worksheet ||


 * ~ ===Week 13: Entering Worksheet Formulas=== ||
 * **Training, Quiz**
 * 1) Set a workbook to manually recalculate
 * 2) Use relative cell references
 * 3) Use absolute cell references
 * 4) Create a formula using the SUM function
 * 5) Print formulas
 * 6) Enter a formula using the keyboard || **Project tasks**
 * Enter a formula
 * Edit formulas
 * Create formulas quickly
 * Show formulas in the worksheet
 * Calculate formulas manually ||


 * ~ ===Week 14: Using Functions=== ||
 * **Training, Quiz**
 * 1) Create a formula using the IF function
 * 2) Create a formula using the NOW function
 * 3) Create a formula using the PMT function
 * 4) Create a formula using the COUNT function
 * 5) Create a formula using the PV function
 * 6) Create a formula using the OR function
 * 7) Create a formula using the IFERROR function
 * 8) Create a formula using the PROPER function || **Project tasks**
 * Enter formulas with functions
 * Use functions to solve mathematical problems
 * Use functions to solve statistical problems
 * Use functions to solve financial problems
 * Use logical functions to make decisions in a worksheet
 * Use functions to insert times and dates in a worksheet ||


 * ~ ===Week 15: Enhancing a Worksheet=== ||
 * **Training, Quiz**
 * 1) Save a workbook in an earlier format
 * 2) Save a workbook as a Web page
 * 3) Save a workbook as a template
 * 4) Save a workbook as a PDF
 * 5) Save a workbook in CSV file format
 * 6) Create a new workbook from a template
 * 7) Check the compatibility of a workbook
 * 8) Hide a worksheet
 * 9) Apply conditional formatting to a range of cells
 * 10) Add a conditional formatting rule
 * 11) Hide and unhide columns
 * 12) Sort a table on multiple fields
 * 13) Filter a table
 * 14) Filter a table using multiple columns
 * 15) Insert clip art
 * 16) Insert a picture
 * 17) Insert a screenshot
 * 18) Insert a SmartArt graphic
 * 19) Insert a hyperlink
 * 20) Open the Research task pane
 * 21) Add a comment
 * 22) Delete a comment
 * 23) Edit a comment
 * 24) Show all comments
 * 25) Format a graphic
 * 26) Change the contrast of an image || **Project tasks**
 * Sort data
 * Apply conditional formatting
 * Hide columns and rows
 * Add a shape to a worksheet
 * Insert a hyperlink ||


 * ~ ===Week 16: Working with Multiple Worksheets and Workbooks=== ||
 * **Training, Quiz**
 * 1) Print a section of the worksheet
 * 2) Print all worksheets in a workbook
 * 3) Rename a worksheet
 * 4) Format worksheet tabs
 * 5) Reorder worksheets
 * 6) Navigate between worksheets
 * 7) Insert a new worksheet
 * 8) Copy a worksheet
 * 9) Group worksheets
 * 10) Delete a worksheet
 * 11) Copy 3-D references
 * 12) Create 3-D references || **Project tasks**
 * Move between worksheets
 * Identify worksheets
 * Rename worksheets within a workbook
 * Change sheet tab colors
 * Reposition worksheets within a workbook
 * Consolidate workbook data ||


 * ~ ===Week 17: Working with Charts=== ||
 * **Training, Quiz**
 * 1) Set border color
 * 2) Create a column chart
 * 3) Create a 3-D pie chart
 * 4) Resize a chart
 * 5) Position a chart
 * 6) Create a chart sheet
 * 7) Create a sparkline for a range of numeric cells
 * 8) Apply a sparkline style
 * 9) Modify the format of a sparkline
 * 10) Apply a style to a chart
 * 11) Format a chart element
 * 12) Change the chart type
 * 13) Explode a 3-D pie chart
 * 14) Format a chart data series
 * 15) Insert a chart title
 * 16) Move a legend in a chart
 * 17) Add data labels
 * 18) Add a data table to a chart
 * 19) Modify chart data labels
 * 20) Modify a chart axis
 * 21) Display gridlines on a chart
 * 22) Create a custom number chart axis format || **Project tasks**
 * Create a chart
 * Update a data source
 * Design a chart
 * Format and modify a chart
 * Insert sparklines ||

stop here for now