Computer+Apps



= Literacy focus assessment: =

@https://goo.gl/forms/SdqKynEkWmIkIlGE3

**Password: college**
=**2016-2017 Semester 1 Final Materials**= ||
 * [[image:Stratford logo.jpg link="file:2015-2016 Computer Apps Semester 1 Final.xlsx"]] || Stratford Logo - Right Click to copy this picture ||
 * Excel Starter File || - download ||
 * Directions for Excel File || - these are in the file itself ||
 * Example for Excel Spreadsheet || - to check your work (slight modifications for 2017-2018 year) ||
 * Word Starter File || - download ||
 * [[file:2015-2016 Computer Apps Semester 1 Final - instruction set.docx|Directions for Word Document ]] || - these will be passed out - put your name on upper right hand side and turn in after test ||
 * Example for Word Document || - to check your work (slight modifications for 2017-2018 year) ||

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: A note-taking template may be viewed/copied/downloaded 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 ||

Semester 2 material


 * __ MICROSOFT ACCESS __**
 * ~ **Week 18: Microsoft Access Basics** ||
 * **Training, Quiz**
 * 1) Open a table in Datasheet view
 * 2) Undo current changes
 * 3) Enter a record in Table Datasheet view
 * 4) Edit data in a table datasheet
 * 5) Navigate records in a table
 * 6) Resize a column in a datasheet to Best Fit
 * 7) Delete a record
 * 8) Print a report
 * 9) Open a database
 * 10) Start Access
 * 11) Close the database and exit Access
 * 12) Show and hide the Navigation Pane
 * 13) Compact a database
 * 14) Save an object with a new name || **Project tasks**
 * Open a database
 * Work with records
 * Navigate records in a Datasheet view
 * Edit records
 * Undo changes to a field
 * Select records and fields
 * Delete records
 * Change the row height
 * Change the column width
 * Rearrange columns in a datasheet
 * Change the background row color ||


 * ~ **Week 19: Creating a Database** ||
 * **Training, Quiz**
 * 1) Save a table
 * 2) Define number and currency fields in a table
 * 3) Change data type in Datasheet view
 * 4) Create a table in Datasheet view
 * 5) Change data type in Design view
 * 6) Change a field's properties in Design view
 * 7) Delete a field
 * 8) Add a field to a table
 * 9) Rename a field in Design view
 * 10) Move a field in a table in Design view
 * 11) Specify a default value for a field
 * 12) Specify a required field in a table
 * 13) Set the primary key for a table
 * 14) Enter data in a date field in a table
 * 15) Add a field to a table in Datasheet view
 * 16) Create a new blank database
 * 17) Create a new database using a database template
 * 18) Create a blank Web database || **Project tasks**
 * Create and save a table
 * Design a table
 * Set a field’s data type and name in Datasheet view
 * Enter records in Datasheet view
 * Work in Design view
 * Add, delete, rename, and rearrange fields in Design view
 * Change field properties in Design view
 * Change the field size
 * Set a field’s format ||


 * ~ **Week 20: Creating Queries** ||
 * **Training, Quiz**
 * 1) Use Filter By Form in a form
 * 2) Clear a form filter in Layout view
 * 3) Use Filter By Selection in a table datasheet
 * 4) Create a one-to-many relationship
 * 5) Display a subdatasheet
 * 6) Use a datasheet to calculate a total
 * 7) Open the Relationships window
 * 8) Create a many-to-many relationship
 * 9) Enforce referential integrity in a relationship
 * 10) Create a query using the Simple Query Wizard
 * 11) Filter data in a query
 * 12) Create a query in Design view
 * 13) Use text criteria in a query
 * 14) Use a comparison operator in a query
 * 15) Add a calculated field to a query
 * 16) Sort data in a query
 * 17) Use the AND logical operator in a query
 * 18) Use the OR logical operator in a query
 * 19) Join tables in a query
 * 20) Use a date field in a query
 * 21) Add totals to a report || **Project tasks**
 * Sort data
 * Filter data
 * Create a query in Design view
 * Move and sort fields in Design view
 * Run a query
 * Add a condition to a field ||


 * ~ **Week 21: Creating and Modifying Forms** ||
 * **Training, Quiz**
 * 1) Use a form to add a record
 * 2) Search for a record using a form
 * 3) Create a form using the Form Wizard
 * 4) Create a split form
 * 5) Create a blank form in Layout view
 * 6) Resize a field on a form in Layout view
 * 7) Create a Datasheet form
 * 8) Change the theme for a form
 * 9) Remove a form control from a Control Layout
 * 10) Move a form control
 * 11) Modify a form control
 * 12) Change the font color of a form control
 * 13) Format a title in Form Design view
 * 14) Expand the Form Footer section
 * 15) Set the record source for a form
 * 16) Navigate records in a form
 * 17) Create a form with a datasheet in Layout view
 * 18) Create a multiple items form
 * 19) Create a simple form based on a table || **Project tasks**
 * Create a form with the Split Form tool
 * Create a form with the Multiple Items and Datasheet tools
 * Navigate a form
 * Modify a form
 * Add a title to a form and change its format
 * Add an unbound control to a form in Design view ||


 * ~ **Week 22: Creating and Modifying Reports** ||
 * **Training, Quiz**
 * 1) Create a report using the Report Wizard
 * 2) Preview a report
 * 3) Resize a field in a report in Layout view
 * 4) Apply a theme to a report
 * 5) Change the alternate row color in a report
 * 6) Resize a report in Design view
 * 7) Create mailing labels
 * 8) Use the Label Wizard
 * 9) Set the record source for a report
 * 10) Remove a report control from a Control Layout
 * 11) Delete a control from a report in Design view
 * 12) Enable error checking || **Project tasks**
 * Create a report using the Report tool
 * Modify a report in Layout view
 * Modify a report in Design view
 * Add a label control to a report
 * Move a control in Design view
 * Resize a report
 * Add a picture to a report ||


 * ~ **Week 23: Integrating Access** ||
 * **Training, Quiz**
 * 1) Import data from an Excel worksheet
 * 2) Import an existing table structure
 * 3) Import data from a text file
 * 4) Export data from a table into an Excel workbook
 * 5) Use the Microsoft Word Mail Merge Wizard || **Project tasks**
 * None ||


 * __ MICROSOFT POWERPOINT __**
 * ~ **Week 24: Microsoft PowerPoint Basics** ||
 * **Training, Quiz**
 * 1) Start PowerPoint
 * 2) Open an existing presentation
 * 3) Close a presentation
 * 4) Save a presentation
 * 5) Save a presentation to SkyDrive
 * 6) Exit PowerPoint
 * 7) Print full page slides
 * 8) Print handouts
 * 9) Print in grayscale
 * 10) Add a new button to the Quick Access Toolbar
 * 11) Undo an action
 * 12) Edit text in the Slide pane
 * 13) Zoom in on a slide
 * 14) Change the order of slides in a presentation
 * 15) Add text in the Outline pane
 * 16) Create a new slide with a specific layout
 * 17) Delete a slide
 * 18) Modify the font
 * 19) Change the theme colors
 * 20) Run a slide show
 * 21) Go to a specific slide during a slide show
 * 22) End a slide show
 * 23) Set the number of slides per page
 * 24) Use Notes Page view
 * 25) Print an outline || **Project tasks**
 * Open and existing presentation and view a slide show
 * Save a presentation
 * Change views
 * Use the Slides tab and outline tab
 * Use the Ribbon
 * Use the Slide pane
 * Use Slide Sorter view
 * Delete slides
 * Close a presentation and exit PowerPoint ||


 * ~ **Week 25: Creating and Enhancing PowerPoint Presentations** ||~  ||
 * **Training, Quiz**
 * 1) Create a new presentation from a template
 * 2) Create a new presentation from an existing one
 * 3) Add text to a title placeholder
 * 4) Delete an object
 * 5) Add a speaker note
 * 6) Create a slide using a content placeholder
 * 7) Change the layout of a slide
 * 8) Add a caption to a picture
 * 9) Modify font size
 * 10) Modify text color
 * 11) Create a multi-level bulleted list
 * 12) Change the size of bullets
 * 13) Change the style of a bullet
 * 14) Change a bulleted list to a numbered list
 * 15) Format a numbered list
 * 16) Promote and demote bullets in an outline
 * 17) Change a bullet to a picture
 * 18) Center text
 * 19) Change line spacing
 * 20) Insert a shape
 * 21) Apply an artistic effect to a picture
 * 22) Find and replace text
 * 23) Insert a picture
 * 24) Insert clip art
 * 25) Find clip art online
 * 26) Add text to a shape
 * 27) Add a hyperlink to a paragraph
 * 28) Add a hyperlink to a graphic
 * 29) Link to a slide in another presentation
 * 30) Link to a Word document
 * 31) Add a text box
 * 32) Add a footer to all slides except the title slide
 * 33) Insert an audio file
 * 34) Change the theme
 * 35) Change slide orientation
 * 36) Animate a bulleted list
 * 37) Apply an animation effect to a bulleted list
 * 38) Customize the direction of an animation
 * 39) Apply transition effects to a single slide
 * 40) Apply a transition effect to all slides in a presentation
 * 41) Modify the start timing of an animation
 * 42) Manually adjust slide show timings
 * 43) Add a sound to a transition
 * 44) Apply multiple animations using the Painter
 * 45) Set a trigger for an animation
 * 46) Use a motion path to animate a shape
 * 47) Check spelling
 * 48) Use the Thesaurus
 * 49) Use the Mini Translator
 * 50) Switch to Slide Master view
 * 51) Display the rulers
 * 52) Add a border to a picture
 * 53) Apply a style to a picture
 * 54) Align objects on a slide
 * 55) Recolor a picture
 * 56) Format an image
 * 57) Set transparency color for a picture
 * 58) Compress a picture
 * 59) Resize a graphic
 * 60) Add a shape to a picture
 * 61) Add audio options
 * 62) Add a background graphic to a slide || **Project tasks**
 * Create a presentation from existing templates
 * Apply themes to the entire presentation
 * Apply a theme to individual slides
 * Use the Slide Master
 * Use the Notes Master and Handout Master
 * Add slides
 * Add text to slides
 * Add notes to slides
 * Change text alignment, spacing, case, and tabs
 * Work with bullets
 * Change font attributes
 * Delete placeholders and text from slides || **[[file:Standard 22 - rev.docx|Standard 22 Project]]**

Download the instruction set.

This will replace the Week 25 assignments in SAM


 * [[file:Standard 22.ppsx|Finished example for Standard 22 project]]** ||


 * ~ **Week 26: Working with Visual Elements** ||~  ||
 * **Training, Quiz**
 * 1) Copy and paste an object
 * 2) Duplicate an object
 * 3) Select a paste option
 * 4) Convert text to a SmartArt graphic
 * 5) Convert WordArt to SmartArt
 * 6) Apply a style to a table
 * 7) Apply a style to a shape
 * 8) Wrap text inside a text box
 * 9) Select a slide object
 * 10) Insert a table
 * 11) Insert a SmartArt graphic
 * 12) Insert a chart
 * 13) Create a hierarchy chart
 * 14) Display the date on all slides except the title slide
 * 15) Insert WordArt
 * 16) Insert video in a slide
 * 17) Animate a shape using a motion path
 * 18) Apply an entrance animation effect to a shape
 * 19) Use the Animation Painter
 * 20) Set Slide Show Timings
 * 21) Apply an effect to an image
 * 22) Group objects on a slide
 * 23) Rotate an object
 * 24) Change the stacking order
 * 25) Apply a style to a SmartArt Diagram
 * 26) Change the colors of a SmartArt graphic
 * 27) Add a shape to a SmartArt diagram
 * 28) Distribute table rows evenly
 * 29) Add borders to a table
 * 30) Arrange table rows
 * 31) Merge cells in a table
 * 32) Split cells in a table
 * 33) Flip an object
 * 34) Change the fill color of a shape
 * 35) Apply a shadow effect to a shape
 * 36) Change the weight of a text box border
 * 37) Modify the chart style
 * 38) Change the chart type
 * 39) Change the layout of a chart
 * 40) Add a legend to a chart
 * 41) Show data labels on a chart
 * 42) Format a chart element
 * 43) Apply an effect to a video
 * 44) Apply a style to a video || **Project tasks**
 * Enter text in a SmartArt graphic
 * Create and format WordArt
 * Build a chart
 * Format a chart
 * Use the Animation Pane
 * Insert objects on a slide || **[[file:Standard 23.docx|Standard 23 Project]]**

Download the instruction set

This will replace the Week 26 assignments in SAM


 * [[file:Standard 23.ppsx|**Finished example for Standard 23 Project**]]** ||


 * ~ **Week 27: Expanding on PowerPoint Basics** ||
 * **Training, Quiz**
 * 1) Record a slide show as a video
 * 2) Send a presentation by e-mail
 * 3) Export notes and slides to Word
 * 4) Package a presentation for a CD or DVD
 * 5) Modify document properties
 * 6) Use the document inspector
 * 7) Mark a presentation as final
 * 8) Protect a presentation with a password
 * 9) Display drawing guides
 * 10) Use the Format Painter
 * 11) Insert a chart linked to an Excel worksheet
 * 12) Duplicate a slide
 * 13) Insert a section into a slide show
 * 14) Insert outline text from Word
 * 15) Insert slides from other presentations
 * 16) Reuse slides from a slide library
 * 17) Insert an action button
 * 18) Edit action button hyperlink setting
 * 19) Insert a linked Excel worksheet
 * 20) Update a linked Excel worksheet
 * 21) Embed a Word table in a slide
 * 22) Set the slide size in a presentation
 * 23) Broadcast a slide show
 * 24) Use a hyperlink while running a slide show
 * 25) Retain annotations upon closing a presentation
 * 26) Highlight during a slideshow
 * 27) Set up a slide show
 * 28) Hide a slide during a slide show
 * 29) Set up a self-running slide show
 * 30) Create a custom slide show
 * 31) Rehearse timings
 * 32) Change the presentation pointer to a pen
 * 33) Insert a comment
 * 34) Show comments
 * 35) Edit a comment
 * 36) Accept changes to an entire presentation
 * 37) Reject changes to a slide in a presentation
 * 38) Compare two presentations || **Project tasks**
 * Integrate PowerPoint with other Office programs
 * Insert text from a Word outline
 * Apply a theme
 * Format text and objects
 * Replace text fonts ||


 * __ MICROSOFT OUTLOOK __**
 * ~ **Week 28: Outlook Basics and E-Mail** ||
 * **Training, Quiz**
 * 1) Start Outlook
 * 2) Create a new e-mail message
 * 3) Reply to all recipients of an e-mail
 * 4) Forward an e-mail
 * 5) Delete an e-mail
 * 6) Attach a file to an e-mail
 * 7) Set message importance
 * 8) Print an e-mail
 * 9) Create a new folder in the Inbox
 * 10) Search for e-mails containing a specific word
 * 11) Add a contact
 * 12) Categorize contacts || **Project tasks**
 * None ||


 * ~ **Week 29: Calendar** ||
 * **Training, Quiz**
 * 1) Change the calendar view
 * 2) Add an appointment to the calendar || **Project tasks**
 * None ||


 * ~ **Week 30: Working with Other Outlook Tools** ||
 * **Training, Quiz**
 * 1) Move an e-mail message to a folder
 * 2) Flag a message
 * 3) Display a ToDo list
 * 4) Create a new task
 * 5) Create a note
 * 6) Specify activities to track in the Journal || **Project tasks**
 * None ||


 * __ MICROSOFT PUBLISHER __**


 * ~ **Week 31: Microsoft Publisher Basics** ||
 * **Training, Quiz**
 * None || **Project tasks**
 * None ||


 * ~ **Week 32: Enhancing Publisher Documents** ||
 * **Training, Quiz**
 * None || **Project tasks**
 * None ||


 * ~ **Week 33:** ||
 * **Training, Quiz**
 * None || **Project tasks**
 * None ||


 * ~ **Week 34: Greenway Lawn Service** ||
 * **Training, Quiz**
 * None || **Project tasks**
 * None ||

Download the instruction page This will address career opportunities in computer programming/IT technology
 * [[file:Standard 1.docx|Standard 1]]**

Download the instruction page This will address the topic of PC set-up/troubleshooting
 * [[file:Standard 2.docx|Standard 2]]**

Download the instruction page This will address the topic of basic file management operations
 * [[file:Standard 3 - assignment.docx|Standard 3]]**

Download the instruction page This will address the topic of wireless routers
 * [[file:Standard 4.docx|Standard 4]]**

Download the instruction page This will address the topic of safe downloading.
 * [[file:Standard 5.docx|Standard 5 ]]**

Download the instruction page This will address the topic of Wi-Fi.
 * Standard 6**

Please click on the Standard 3 link above. This will address the topic of accessing/downloading Internet resources
 * [[file:Standard 3 - assignment.docx|Standard 7]]**

Download the instruction page This will address the topic of creating a business style document
 * [[file:Standard 8.jpg|Standard 8]]**

Download the instruction pages These will address the topic of using word processing program features
 * [[file:Standard 9.1.docx|Standard 9.1]] and [[file:Standard 9.2.docx|Standard 9.2]]**

Download the instruction page. This will address the topic of page enhancement.
 * [[file:Standard 10.docx|Standard 10]]**
 * [[file:Standard 10.pdf|Example page - Standard 10]]**

Download the instruction page This will address the topic of creating, formatting, and editing documents.
 * [[file:Standard 11.docx|Standard 11]]**

Download the instruction page This will address the topic of proofreading.
 * [[file:Standard 12.docx|Standard 12]]**

Will be the Semester 1 Final.
 * Standard 13**

Download the instruction page This will address the topic of creating and formatting spreadsheet documents.
 * [[file:Standards 14 and 15.xlsx|Standards 14 and 15]]**

Download the **** and **** This will address the topic of utilizing formulas in spreadsheets.
 * Standard 16**

Download the **** and **** This will address the topic of utilizing charts and graphs
 * Standard 17**

Download the instruction page This will address the topic of time cards
 * [[file:Standard 18.docx|Standard 18]]**

Download the **** and **** This will address the topic of basic database knowledge
 * Standard 19**

Download the instruction page This will address the topic of running queries and reports
 * [[file:Standard 20.docx|Standard 20]]**

Download the **** and **** This will address the topic of creation of search forms
 * Standard 21**

Download the instruction set. This will replace the Week 25 assignments in SAM
 * [[file:Standard 22 - rev.docx|Standard 22 Project]]**
 * [[file:Standard 22.ppsx|Finished example for Standard 22 project]]**

Download the instruction set This will replace the Week 26 assignments in SAM
 * [[file:Standard 23.docx|Standard 23 Project]]**

Download the instruction page This will address the topic of libel/slander or datamining/phishing.
 * [[file:Standard 24.docx|Standard 24]]**

Download the instruction page This will address the topic of plagiarism/piracy/intellectual property.
 * [[file:Standard 25.docx|Standard 25]]**

Download the instruction page This will address the topic of internet/World Wide Web terminology.
 * [[file:Standard 26.docx|Standard 26]]**


 * SEMESTER 2**

For the spring semester 2016-2017:

All assignments labeled "Week" are found on the [|SAM site]. All assignments labeled "Standard" are found on this page.

Quarter 3: Week 24, Standard 22, Standard 23, Week 27, Standard 1, Standard 4, Standard 5, Standard 6, Standard 10, Standard 12, Standard 24, Standard 25 Quarter 4: Week 18, Week 19, Week 20, Week 21, Week 22, Week 23, Week 28, Week 29, Week 30, Standard 26

Blue or green? Blue or green? (2)

Deep Voice Tall Height

[|Literacy Focus - Quiz]

stop here for now