OST-BTC8010 - MS Office Admin Pro

Course Description

This comprehensive course is designed to transform you into a tech-savvy professional. Dive deep into the world of computer fundamentals and master Microsoft Office applications. Whether you're a beginner or looking to sharpen your skills, this course offers everything you need to excel in today’s digital landscape. This course aims to help you become proficient in the essential digital tools that power the modern workplace. Register and embrace the opportunity to enhance your career and personal productivity. 

Course Outline

Introduction to Computing and Digital Communication 

• The Information Age: Understanding the evolution and impact of information technology. 
• The Internet and Social Media: Basics of the internet, browsing, and social media platforms. 
• Digital Communication: Email etiquette, instant messaging, and collaborative tools. 

Online Safety and Computer Hardware 

• Online Safety and Security: Protecting personal information and understanding cybersecurity basics. 
• Evaluating Online Information: Critical assessment of online content and sources. 
• Computer Hardware: Overview of computer components and their functions. 

System Software and File Management 

• System Software: Operating systems, updates, and system settings. 
• File Management: Organizing, storing, and retrieving files efficiently. 
• Application Software: Introduction to common software applications. 

Networking, Databases, and Information Systems 

• Networking and User Accounts: Basics of networking, creating, and managing user accounts. 
• Databases: Introduction to databases and data management. 
• Computer Programming: Basic programming concepts and logic. 
• Information Systems: Role of information systems in organizations. 

Getting Started with Microsoft Office 

• Getting Started with Office: Introduction to the Microsoft Office suite. 
• Customizing Views and Options: Personalizing Office applications for better efficiency. 
• Printing Files: Printing documents and managing print settings. 
• Navigating Files: Efficiently navigating and managing Office files. 
• Working with Objects: Inserting and manipulating objects in documents. 
• Using Office Collaboration Features: Collaborative tools within Office applications. 

Microsoft Word – Basics and Advanced Features 

• Managing References: Using references, citations, and bibliographies. 
• Managing Headers, Footers, and Sections: Customizing document layout. 
• Using Macros: Automating tasks with macros. 
• Word Live Projects: Hands-on project to apply Word skills. 

Microsoft Word – Document Creation and Formatting 

• Editing Documents: Advanced editing techniques. 
• Inserting Illustrations and Other Elements: Adding images and other elements. 
• Creating and Formatting Tables: Table creation and formatting. 
• Using Themes, Styles, and Templates: Utilizing pre-designed themes and templates. 

Microsoft Excel – Basics and Data Management 

• Summarizing Complex Data: Using functions and formulas to summarize data. 
• Creating and Managing Workbooks: Workbook creation and management. 
• Organizing and Entering Data: Data entry and organization techniques. 
• Changing Properties and Printing Worksheets: Customizing and printing worksheets. 

Microsoft Excel – Advanced Features 

• Formatting Cells: Cell formatting and styles. 
• Entering Simple Formulas: Basic formula creation. 
• Using Advanced Functions: Advanced Excel functions. 
• Displaying Data in Charts: Creating and customizing charts. 
• Organizing Data in Tables: Table creation and data organization. 

Microsoft PowerPoint – Basics and Presentation Skills 

• Introduction to PowerPoint: Basics of Microsoft PowerPoint. 
• Delivering Presentations: Effective presentation delivery techniques. 
• Creating and Managing Presentations: Presentation creation and management. 
• Formatting Textual Content: Text formatting in slides. 
• Formatting Tables and Charts: Adding and formatting tables and charts. 
• Formatting Pictures and Other Media: Incorporating and formatting media elements. 

Microsoft Outlook – Email and Calendar Management 

• Applying Animations and Transitions: Using animations and transitions in slides. 
• Introduction to Outlook: Basics of Microsoft Outlook. 
• Sending and Receiving Messages: Managing emails. 
• Managing Messages: Organizing and sorting emails. 
• Working with the Calendar: Scheduling and managing calendar events. 
• Managing Contacts and Groups: Organizing contacts and distribution lists. 

Learner Outcomes

1. Understand the fundamental concepts of computer hardware and software. 
2. Demonstrate effective digital communication and online safety practices. 
3. Evaluate and utilize online information critically. 
4. Proficiently use Microsoft Office applications, including Word, Excel, PowerPoint, and Outlook. 
5. Create, format, and manage documents, spreadsheets, and presentations. 
6. Apply advanced features of Microsoft Office to enhance productivity. 
7. Organize and manage data using various tools and functions in Excel. 
8. Develop and deliver effective presentations using PowerPoint. 
9. Manage email communication and calendar events using Outlook. 
10. Collaborate with others using Microsoft Office collaboration features. 

Notes

Target Population: 

This class is recommended for people new to technology who want to obtain basic computer skills to advance their career or education. People who are new to the MS Office Suite or have been using an older version can also benefit from this training. 

Central Piedmont Community College Continuing Ed Certificate: 

A certificate of completion for the class will be issued to participants with at least 80% attendance, class participation, and completion of hands-on practice and projects. 

Industry Certification: 

This course prepares for these certifications: 

• TestOut Office Pro 
• MO-110: MS Word® Associate 
• MO-210: MS Excel® Associate 
• MO-310: MS PowerPoint® Associate 

Method of Instruction: 

Blended learning with lectures, videos, class discussions, live demonstrations, hands-on exercises in a simulation environment. Outside homework, practice and projects are assigned. 

Evaluation: 

Completion three levels of lab simulations: Skills, Challenge, and Projects. Class attendance is required for successful completion. 

Recommendations