MS Office 2016 Boot Camp

Mrs. Rebecca Smith (Becky) - Setup a Administration Company (Simply The Best Admin)

Homework:

Please read the following:

10 Word Formatting Tips, Section Breaks, Sharing Word Building Blocks and Speak in Word

Microsoft Office 2016 Word Student Introduction Guide Book (chapter three and four only)

Lab:

Prepare a simple word document (business plan), for your respective project.

Instructor video:

Express Computers (Step-by-step)

Review videos:

Word Introduction

Assignments for Week Two (June 23, 2020) - Please complete all Assignments, Quiz or Test.

Classroom:

Read the following:

Syllabus Recap

Session Two - Introduction to Office Word 2016 Continued - Formatting characters, formatting paragraphs, work with font properties, creating lists, paragraph alignment, apply built-in styles to text, manage outline levels, markup document, insert comments, track changes, compare and merge documents, control content changes, restrict actions/access by using a password, co-author documents.

Homework:

Please read the following:

Finding Duplicates, Multiple Subtotaling fun, SumIF ( ) and helper column, 3D Reference Summarize,

10 Subtotal Tips, Auto fill shortcuts, Flash Fill, Excel Relationship, SumIF() negative value

Lab:

Modify your Business Plan and create a Mail Merge document and send the files to the instructor

before the class ends.

Instructor video:

Mail Merge

Review videos:

Mail Merge Part One

Mail Merge Part Two

Mail Merge Part Two

Mail Merge Envelopes and Lables

Assignments for Week Three (June 30, 2020) - Please complete all Assignments, Quiz or Test

Classroom:

Read the following:

Syllabus Recap, Microsoft Office 2016 Excel Reference

Session Three - What's New in Excel 2016?, Review the Excel Scree, Using Command Shortcuts, Navigating a Worksheet, Entering Labels and Values, Work with Cell Ranges, Entering Formulas, Entering Content Automatically, Referencing External Data, Editing Cell Contents, Copying and Moving Cells, Checking Spelling, Inserting and Delete Cells, Rows, and Columns.

Homework:

Please read the following:

Finding Duplicates, Multiple Subtotaling fun, SumIFs ( ) and helper column, 3D Reference Summarize,

10 Subtotal Tips

Lab:

Prepare a simple Excel database with a simple query (Company Balanced Workbook).

Instructor video:

SharePoint's Excel Part One Videos

Review videos:

Excel New Features

Excel Introduction

Sharing workbook and track changes

Assignments for Week Four (July 7, 2020) - Please complete all Assignments, Quiz or Test

Classroom:

Read the following:

Syllabus Recap

Session Four - Using Undo and Redo, Finding and Replacing Content, Adding Comments to Cells, Tracking Changes, Formatting a Worksheet, Formatting Text & Values, Row Height (Column Width), Working with Cell Alignment, Cell Borders and Background, Copy Formatting, Apply and Modify Cell Styles, Using Document Themes, Conditional Formatting, Name groups of data, Define Excel Tables, Create Formulas to calculate values.

Homework:

Please read the following:

Auto fill shortcuts, Flash Fill, Excel Relationship, SumIFs() negative value

Lab:

Modify the Company Balanced Workbook, then submit to the instructor before 12:00 pm on

July 17, 2020.

Instructor video:

SharePoint's Excel Part Two Videos

Review videos:

Excel Intermediate

Assignments for Week Five (July 13, 2020) - Please complete All Assignments, Quiz or Tests

Classroom:

Read the following:

Syllabus Recap, Microsoft Office Access 2016 Reference

Session Five - What's New in Access 2016?, Introduction to Databases, The Access Program Screen, Database Objects, Adding, Editing and Deleting, Planning a Database, Creating a New Database, Create and Modify a Table, Create Basic Query's, Creating a Form, Creating a Report, Creating Mailing Labels, Convert an Access Database, Find, Filter, Sort & Format, Adjust Columns and Rows.

Homework:

Please read the following:

N/A

Lab:

prepare a simple Access database with a simple query.

Instructor video:

SharePoint's Access Part One Videos

Review videos:

Introduction to Access 2016

Assignments for Week Six (July 20, 2020) - Please complete All Assignments, Quiz or Tests

Classroom:

Please read the following:

Syllabus Recap

Session Six - Microsoft Office Access Continued - Tables and Fields, Field Properties, Indexing & Primary Keys, Required & Default Data, Validating Data, Input Masks and Lookups, Understanding Table Relationships, Create Table Relationships, Enforcing Referential Integrity, Relationship Types.

Homework:

Please read the following:

N/A

Lab:

Modify Access Database

Instructor video:

SharePoint Access Part Two Videos

Review videos:

Intermediate to Access 2016

Assignments for Week Seven (July 27, 2020) - Please complete All Assignments, Quiz or Tests

Classroom:

Read the following:

Syllabus Recap, Microsoft Office PowerPoint 2016 References

Session Seven - What's New in PowerPoint 2016?, PowerPoint Program Screen, Commands and Shortcuts, Creating a New Presentation, Previewing and Printing a Presentation, Inserting and Editing Text, Inserting Text and Textboxes, Edit, Move and Copy Text, Using Undo, Redo and Repeat, Checking Your Spelling, Finding and Replacing Text, Inserting Symbols and Special Characters, Inserting Equations.

Homework:

Please read the following:

N/A

Lab:

Create a PowerPoint presentation

Instructor video:

Review videos:

Introduction to PowerPoint 2016

Assignments for Week Eight (August 4, 2020) - Please complete all Assignments, Quiz or Test

Classroom:

Read the following:

Syllabus Recap

Session Eight - Microsoft PowerPoint Continued - Font Styles, Using WordArt, Viewing a Presentation, Changing Views, Using the Zoom Controls, Using the Outline Pane, Working with the Presentation Window, Working with Multiple Presentations, Formatting a Presentation, Using Document Themes, Changing the Background of a Slide, Rearranging Slides, Adding Headers and Footers, Using the Slide Master, Working with Bullets and Numbered Lists, Formatting Paragraphs, Working with Tabs and Indents, Changing Page Setup.

Homework:

Please read the following:

None

Lab:

Modify PowerPoint presentation, send to the Instructor for a grade.

Please send the Fillable Student Evaluation Form, located in the files below; to the Instructor

via email by 11:00 am on Wednesday, August 5, 2020.

Instructor video:

None

Project Assignment:

Brainstorm Activity: As a reminder all participants will be assigned a Business related project that

will require them to complete a 15 minute (10 slide) PowerPoint presentation online

using sound, graphics, documents, spreadsheets, videos, music, etc.

Mrs. Rozeline Lacroix - Setup a Supply Company ( )

Mrs. Miriam Rodriguez - Setup a Motor Transport Company (Rodmen Transport Services, Inc.)

Mrs. Rebecca Smith (Becky) - Setup a Administration Company (Simply The Best Admin)

Review videos:

Intermediate to PowerPoint 2016