Assignments for Day One (August 2, 2021) - Please complete all Assignments, Quiz or Test
Classroom:
Read the following:
Syllabus, Course References (Windows 10, Word and Keyboard Shortcuts)
Session One - Office 365 Word (Navigate Word Screen, Shortcuts and QAT, Modify Ribbon,
Document Basics, Enter and Delete Data, Select and Replace, Text, Document Navigation and
Browsing, Edit, Find and Replace Text, Spelling and Grammar, Word Count and Thesaurus,
Symbols and Special Characters, Copy and Paste, Undo, Redo and Repeat, Characters and
Paragraphs Formatting , Font Properties, Create Lists, Paragraph Alignment, Borders and
Shading, Copy Formatting, Setting and Adjusting Tab Stops, Left and Right Indents, First Line
and Hanging Indents).
Homework:
Please read the following:
10 Word Formatting, Section Breaks, Sharing Word Build Blocks, Speak in Word and Table
Time Savers.
Lab:
Create Business Plans
Team A - Supply Business - ( )
Team B - Motor Transport Business - ( )
Review videos:
Assignments for Day Two (August 3, 2021) - Please complete all Assignments, Quiz or Test
Classroom:
Read the following:
Syllabus Recap, Excel Reference
Session Two - Office 365: Excel (Review Excel Screen, Use Command Shortcuts, Worksheet
Navigation, Enter Values and Labels, Cell Ranges, Enter Formulas, Enter Content Automatically, Referencing External Data, Editing Cell Contents, Copying and Moving Cells, Checking Spelling, Inserting and deleting Cells Rows and Columns, Use Undo, and Redo, Finding and Replacing
Content, Adding Comments to Cells and Tracking Changes).
Homework:
Please read the following:
10 Subtotal Tips, 3D Reference Summarized, Excel Relationships, Finding Duplicates, Flashfill,
and Multiple Subtotaling.
Lab:
Modify and Share the Business Plan
Create Several Excel Workbooks
Review videos:
Assignments for Day Three (August 4, 2021) - Please complete all Assignments, Quiz or Test
Classroom:
Read the following:
Syllabus Recap, Excel and PowerPoint References
Session Three - Office 365: Excel Cont'd (Formatting Text and Values, Row Height, Column
Width, Working with Cell Alignment, Cell Borders and Background, Copying Formatting,
Document Themes, Conditional Formatting)
Office 365: PowerPoint (PowerPoint Program Screen, Commands and Shortcuts, Create a new presentation, Previewing and printing a presentation, Inserting and deleting slides, Selecting a
Layout, Navigating and Organize, Inserting Text and Textboxes, Edit, Move and Copy Text, Using
Undo, Redo and Repeat, Check Spelling).
Homework:
Please read the following:
Excel and PowerPoint Reference
SumIF Helper Column, SumIF Wildcard, SumIF Negative Value, Transposing Data, and Auto-fill
Shortcuts.
Lab:
Modify and Share a Excel Workbook
Create a PowerPoint Presentation
Review videos:
Assignments for Day Four (August 5, 2021) - Please complete all Assignments, Quiz or Test
Classroom:
Read the following:
Syllabus Recap, PowerPoint Reference
Session Four - Office 365: PowerPoint Cont'd (Finding and Replacing Text, Inserting Symbols
and Special Characters, Inserting Equations, Font Styles, 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 Tabs and Indents, Changing Page Set).
Homework:
Please read the following:
PowerPoint Reference, Color Coding Appoin, Multiple Addresses, Saving Multiple Contacts,
and Total Number Emails.
Lab:
Modify and Share the PowerPoint presentation
Review videos:
Assignments for Day Five (August 6, 2021) - Please complete all Assignments, Quiz or Test
Classroom:
Read the following:
Syllabus Recap, OneNote reference
Session Five - Office 365: OneNote - (Create notebooks, Add pages, sections, and section groups to notebooks, Customize notebooks with templates, page colors, Insert pictures, tables, audio and video into your notes, Insert external data such as MS Word documents, spreadsheets, and emails into your notes, Insert characters and graphs into your notes, Use the Send to OneNote Tool to make inserting external data a breeze, Use Quick Notes when you're on the go, then easily file those notes into your notebook, Send data to OneNote from other programs).
Homework:
Please read the following:
OneNote Reference
Lab:
Create and Share a OneNote Notebook for your respective business
Create a PowerPoint presentation Online
Review videos: