Getting Started
1. Getting to Know Office Versions.
2. Introduction to MindTap & SAM.
3. Using SAM Projects and Textbook Projects.
4. Getting Started with File Management.
5. Getting Started with Microsoft OneNote.
6. Getting Started with Microsoft Office Online and OneDrive.
7. Getting Started with Microsoft Teams.
8. Getting Started with Office for Mac.
9. Embracing Change in Technology.
TECHNOLOGY FOR SUCCESS: COMPUTER CONCEPTS
Module 1: Impact of Digital Technology
Module 2: The Web
Module 3: Computer Hardware
Module 4: Operating Systems and File Management
Module 5: Software and Apps
Module 6: Security and Safety
Module 7: Digital Media
Module 8: Program and App Use and Development
Module 9: Web Development
Module 10: Networking
Module 11: Digital Communication
Module 12: Digital Transformation: Cloud, eCommerce, and AI
Module 13: Databases
Module 14: Digital Ethics and Lifestyle
OPERATING SYSTEMS (FROM THE SHELLY CASHMAN SERIES)
Module 1: Introduction to Windows
Module 2: Working with the Windows Desktop
Module 3: File and Folder Management
Module 4: Personalizing you Work Environment
Module 5: Advanced Personalization and Customization
Module 6: Advanced Searching Techniques
Module 7: Microsoft Edge
Module 8: Mastering Digital Media
Module 9: Understanding Security, Networking and Utilities
Module 10: Getting Started with Mac OS
MICROSOFT TEAMS
Module 1: Introduction to Teams
Module 2: Making Meetings More Productive
Module 3: Build an Effective Work Team
MICROSOFT WORD
Tips for using Microsoft Word for Mac
Embracing Change in Word
Module 1: Creating and Editing a Document
Module 2: Navigating and Formatting a Document
Module 3: Creating Tables and a Multipage Report
Module 4: Enhancing Page Layout and Design
Module 5: Working with Templates, Themes, and Styles
Module 6: Using Mail Merge
Module 7: Collaborating with Others and Integrating Data
Module 8: Customizing Word and Automating Your Work
Module 9: Creating Online Forms Using Advanced Table Techniques
Module 10: Managing Long Documents
MICROSOFT EXCEL
Tips for using Microsoft Excel for Mac
Embracing Change in Excel
Module 1: Getting Started with Excel: Tracking Miscellaneous Expenses for a Conference
Module 2: Formatting Workbook Text and Data - Creating a Sales Report
Module 3: Performing Calculations with Formulas and Functions - Staffing a Call Center
Module 4: Analyzing and Charting Financial Data - Preparing an Investment Report
Module 5: Generating Reports from Multiple Worksheets and Workbooks - Summarizing Profit and Loss Statements
Module 6: Managing Data with Data Tools - Analyzing Employment Data
Module 7: Summarizing Data with Pivot Tables - Preparing a Social Media Marketing Report
Module 8: Performing What-If Analyses - Maximizing Profits with the Right Product Mix
Module 9: Exploring Financial Tools and Functions - Analyzing a Business Plan
Module 10: Analyzing Data with Business Intelligence Tools - Presenting Sales and Revenue Data
Module 11: Exploring Pivot Table Design - Summarizing Sales and Revenue Data
Module 12: Developing an Excel Application - Creating a Data Entry App
Appendix A: Customizing your Excel Workspace
Appendix B: Introducing Power BI - Analyzing Big Data in a Sales Report
Appendix C: Collaborating with your Team
MICROSOFT ACCESS
Embracing Change in Access
Module 1: Creating a Database - Tracking Patient, Visit, and Billing Data
Module 2: Building a Database and Defining Table Relationships - Creating the Billing and Patient Tables
Module 3: Maintaining and Querying a Database - Updating and Retrieving Information About Patients, Visits, and Invoices
Module 4: Creating Forms and Reports - Using Forms and Reports to Display Patient and Visit Data
Module 5: Creating Advanced Queries and Enhancing Table Design - Making the Clinic Database Easier to Use
Module 6: Using Form Tools and Creating Custom Forms - Creating Forms for Lakewood Community Health Services
Module 7: Creating Custom Reports - Creating Custom Reports for Lakewood Community Health Services
Module 8: Sharing, Integrating, and Analyzing Data - Importing, Exporting, Linking, and Analyzing Data in the Clinic Database
Module 9: Using Action Queries and Advanced Table Relationships - Enhancing User Interaction with The Health
Module 10: Automating Tasks with Macros - Creating a User Interface for the Health Database
Module 11: Using and Writing Visual Basic for Applications Code - Creating VBA Code for The Health Database
Module 12: Managing and Securing a Database - Administering the Health
Appendix A: Relational Databases and Database Design
MICROSOFT POWERPOINT
Tips for using Microsoft PowerPoint for Mac
Embracing Change in PowerPoint
Module 1: Creating a Presentation – Presenting information about an Insurance Company
Module 2: Adding Media and Special Effects – Using Media in a Presentation for a Veterinary Hospital
Module 3: Applying Advanced Formatting to Objects: Formatting Objects in a Presentation for a Sales and Marketing Company
Module 4: Advanced Animations and Distributing Presentations: Creating an Advanced Presentation for Agricultural Development
Module 5: Integrating PowerPoint with Other Programs: Creating a Presentation for a Rowing Convention
Module 6: Customizing Presentations and the PowerPoint Environment - Creating a Presentation for a City-Wide Green Challenge
MICROSOFT OUTLOOK (FROM THE SHELLY CASHMAN SERIES)
Module 1: Managing Email Messages with Outlook
Module 2: Managing Calendars with Outlook
Module 3: Managing Contacts and Personal Contact Information with Outlook
Module 4: Creating and Managing Tasks with Outlook
Module 5: Customizing Outlook
CAREER READINESS
Using Resume Assistant Powered by LinkedIn
Building an Online Portfolio using PathBrite
Microsoft Office Specialist (MOS) Certification Resources
