DIPLOMA IN OFFICE AUTOMATION - DOAN
Duration : 6 Months / 216 Hours
OBJECTIVE
DOAN24 – GN16520-17270F
The goal of this course is to introduce software Microsoft Office. The course will discuss topics on how to create impressive business documents with Microsoft Office Word, attractive presentations using Microsoft Office PowerPoint and spreadsheets using Microsoft Office Excel, Cloud based Office Tools and Linux Operating System
COURSE OUTLINE
INTRODUCTION TO DATA ENTRY PRACTICE 👈🏽
HOW TO TYPE
- Basic requirements for the installation of English Typing Software
- Finger Positioning
- Division of Key Boards to left hand and Right hand
INTRODUCTIONS TO ENGLISH LETTERS
- English Letters
- Letters and Pronunciation
- Other exclamatory makes and Symbols
PRACTICE
- Practice on keys
- Practice on Numbers and Symbols
- Practice on Words
- Practice on sentence
LEISURE TIME – GAMES
- Typing games
- Typing Speeding games
- Sentence typing games
TYPING REPORTS
- Types of Printers
- Connecting and configuring printers
- Layout Settings
- Printing and Exporting Reports
WINDOWS OS 👈🏽
- Introduction
- Features of Operating Systems
- Types of Operating Systems
- Introduction to Windows OS
- Windows Accessories
- File Management
MICROSOFT OFFICE 👈🏽
MICROSOFT WORD
- Creating a Microsoft Word Document
- The Ribbon
- The Backstage View
- The Quick Access Toolbar
- Formatting Microsoft Word Documents
- Editing Documents
- Review and Collaborating on Documents
- Comparing and Combining Documents
- Managing Mailings
- Protecting Documents
- Finalizing Microsoft Word Documents
- Random Useful Items
MICROSOFT EXCEL (ADVANCED)
- Introduction to Excel
- Working with formulas and functions
- Data sorting and filtering
- Auditing
- Charts and tables
- Working with data
- What if analysis
- Exporting importing and reviewing a worksheet
- VBA Macro
MICROSOFT POWERPOINT
- Creating a PowerPoint Presentation
- The Ribbon
- The Quick Access Toolbar
- The Backstage View (The File Menu)
- Formatting Microsoft PowerPoint Presentations
- Working with Images
- Working with Tables and Charts
- Customizing Presentations
- Presentation Masters
- Working with Special Effects
- Using SmartArt
- Setting Up the Slide Show
- Outlines and Slides
MICROSOFT OUTLOOK
- Setting up a new email account in Microsoft Outlook
- Sending, receiving, replying, forwarding mail messages
- Including a signature in outgoing message
- Scheduling meetings with others
- Creating contacts and appointments
INTERNET & E-MAIL 👈🏽
Web Browsers and Tools
- Browser Selection
- Extensions and Add-ons
- Security and Privacy
Cloud Computing and Storage Cloud Services
- Collaboration Tools
- Data Backup
Internet Security and Compliance
- Cybersecurity Threats
- Regulatory Compliance
Email Management
- Organizing Your Inbox
- Email Etiquette
Communication Best Practices
- Effective Email Writing
- Handling Email Overload
Advanced Features
- Email Templates
- Advanced Search
INTRODUCTION TO CLOUD BASED OFFICE APPLICATIONS 👈🏽
OFFICE 365
Microsoft Office 365 Overview
- Introducing Office 365
- Identify and outline the component products
- Navigating around Office 365
- Updating your Profile in Office 365
Microsoft Word
- MS Word introduction
- Basic Editing
- Character Formatting
- Paragraph Formatting
- Managing Text flow
- Creating Tables
- Working with Themes & Tools
- inserting graphics
- formatting documents
Microsoft Excel
- Microsoft Excel Introduction
- Basic Editing
- Basic Formulas
- Using Functions
- Formatting Cells & Ranges
- Formatting worksheets
- Using Advance Formulas
- Charts & Illustrations
Microsoft PowerPoint
- Microsoft PowerPoint Introduction
- Developing presentation
- Enhancing the appearance on a presentation.
Microsoft Outlook
- Overview of Outlook
- Setting Up Outlook
- Sending and Receiving Mail
- Searching Mail
- Organizing and Managing Mail
- Creating and Sending Mail
Microsoft Sway
- Overview of Sway
- Navigating in Sway
- Adding text to Sway
- Adding media to Sway
- Changing the look of a Presentation
- Using Stack and Group Cards
- Sharing a Sway Presentation
- Using the Accessibility View in Sway
Microsoft Teams
- Introduction
- Getting Started with Teams
- Using Chat
- Working with Meetings
- Collaborating Using Teams
Microsoft SharePoint
- Introduction
- Getting Started with SharePoint Online
- SharePoint Lists
- SharePoint Libraries
- Workflows
- SharePoint Sites
Microsoft Calendar
- Introduction to Calendar
- Adding Calendar Events
- Managing Appointments and Meetings
Microsoft Contacts
- Introduction to Contacts
- Contacts Basics
- Managing Contacts
Microsoft OneDrive
- Introduction to OneDrive
- Storing and Accessing Files
- Collaboration and Sharing
- OneDrive Synchronization
Microsoft To Do
- Overview of To Do
- Creating Tasks and Lists
- Managing Tasks and Lists
- Outlook Integration
Microsoft OneNote
- Introduction to OneNote
- Creating a new Notebook (Offline & Online)
- Adding Sections and Pages to a Notebook
- Adding and formatting Content
- Printing and Sharing a Notebook
INTEGRATING WITH OFFICE APPS- AI TOOLS
- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
Microsoft 365 Security
- Introduction to Microsoft 365 Security
- Identity and Access Management
- Threat Protection
- Information Protection
GOOGLE WORKSPACE
Google Docs
- Introduction
- Organizing the google docs
- Template Gallery
Google Sheets
- Introduction
- Basic Operations
- Formatting
- Data Analysis
- Functions
Google Slides
- Overview
- Slide Basics
- Text Basics
- Adding Pictures and Shapes
- Adding Transitions and Animations
- Presenting the Slide Show
- Master Slides & Layouts
- Inserting and editing Diagrams
- Inserting and editing Videos
- Inserting Charts from Google
- Printing and Creating PDF Files
Google Forms
- Introduction
- Creating Simple Forms
- Adjusting Form Settings
- Sending Forms
- Organizing and Analyzing Responses
AI TOOLS IN OFFICE AUTOMATION 👈🏽
MICROSOFT COPILOT
Introduction
Chatting with Microsoft CoPilot
Things to Try in CoPilot
- Text Editing
- Knowledge Base
- Generating Code
- Documentation
Privacy and Security
Troubleshooting
CHATGPT
- Introduction
- Features
- Working with ChatGPT
- Generating Text
- Create Images
- Asking questions
- Limitations of ChatGPT
GEMINI
- Introduction
- Free Sign Up
- Using Gemini Prompts
- Creating Images in Gemini
- Manage How Gemini Uses Your Data
QUILLBOT
- Signing up with Quillbot
- Grammer Checker
- Paraphraser
- Co-Writer
- Summarizer
- Citation Generator
- Plagiarism Checker
ADOBE ACROBAT PRO 👈🏽
INTRODUCTION TO ACROBAT PRO INTERFACE
Workspace Overview:
- Detailed exploration of the Acrobat Pro CC 2024 workspace, including tools, panels, and menus.
- Understanding the toolbar, navigation pane, and task panes.
- Customizing the workspace to suit different tasks and preferences.
Customizing the Interface:
- Arranging and saving custom workspaces for different types of projects.
- Setting up keyboard shortcuts and preferences to enhance workflow, efficiency.
PDF Properties:
- Understanding PDF properties and settings.
- Exploring metadata, document information, and file properties.
CREATING AND EDITING PDFS
PDF Conversion:
- Converting various document types (Word, Excel, PowerPoint, images) to PDF.
- Using the Create PDF tool to generate PDFs from multiple file formats.
Editing PDFs:
- Techniques for editing text and images within PDFs.
- Using the Edit PDF tool to modify content, add text, and adjust images.
- Adding and editing links, bookmarks, and headers/footers.
Organizing PDFs:
- Combining, splitting, and organizing PDF files.
- Using the Organize Pages tool to reorder, insert, delete, and rotate pages.
- Creating and managing PDF portfolios.
FORM CREATION AND MANAGEMENT
Interactive Forms:
- Creating forms with interactive fields, checkboxes, and dropdowns.
- Using the Prepare Form tool to add form fields and set properties.
Form Validation:
- Adding validation rules to ensure data accuracy.
- Setting up calculations and formatting for form fields.
Form Data Management:
- Collecting and managing form data submissions.
- Exporting form data to Excel or other formats for analysis.
PDF SECURITY
Security Settings:
- Applying security settings to protect PDFs.
- Setting passwords and permissions to control access and editing.
Digital Signatures:
- Adding and managing digital signatures.
- Using the Certificates tool to sign documents and verify signatures.
Permissions Management:
- Setting and managing permissions for PDF access.
- Restricting printing, copying, and editing of PDF content.
INTRODUCTION TO LINUX OS 👈🏽
LIBREOFFICE WRITER
- Introducing Writer
- Working with Text
- Formatting Text
- Formatting Pages
- Printing,
- Exporting
- Emailing
- Introduction to Styles
- Working with Styles
- Working with Templates
- Images and Graphics
- Lists
- Tables of Data
- Mail Merge
- Tables of Contents, Indexes, Bibliographies
- Master Documents
- Fields
- Forms
- Spreadsheets
- Charts
- Audio video
- Formulas (equations)
- Customizing Writer
CALC
- Introduction
- Entering, Editing, and Formatting
- Creating Charts and Graphs
- Using Styles and Templates
- Using Graphics
- Printing, Exporting, E-mailing, and Signing
- Using Formulas and Functions
- Using Pivot Tables
- Data Analysis
- Linking Data
- Sharing and Reviewing Spreadsheets
- Macros
- Calc as a Database
- Setting up and Customizing
IMPRESS
- Introducing Impress
- Master Slides, Styles, and Templates
- Adding and Formatting Text
- Adding and Formatting Images
- Managing Graphic Objects
- Formatting Graphic
- OLE
- Spreadsheets
- Charts
- Audio and video
- Drawings
- text files
- HTML files
- Adding and Formatting Objects
- Slides
- Notes
- Comments
- Handouts
- Slide Shows and Photo Albums
- Saving Slide Shows
- Printing Slide Shows
- Emailing Slide Shows
- Exporting Slide Shows
- Setting Up and Customizing Impress
MANAGING ONLINE MEETINGS 👈🏽
MICROSOFT TEAMS
Introduction
- Download Teams
- Signing in to teams
- Pick a team and adding members
- Creating a Team
- Adding People to a Team
Channels and tabs
- Channels
- Tabs
- Create a Channel for the Team
Conversations, sharing files, & chat
- Start a New Conversation
- Replying to a Conversation
- Emoji, Memes, & Gifs
- Sharing a File
Collaborate in Microsoft teams
- Mention @ Someone
- Notifications
- Search for Messages, People, or Files
Meetings in teams
- Schedule a meeting in Teams
- Make it a channel meeting
- Invite people outside your organization
- Meeting Options
- Join a meeting in teams
- Join by link
- Joining as a Guest
- When is Joining as a Guest Good?
- Join from calendar
- Join in a channel
- Join from chat
Set Up Mobile Apps
- Android
- IOS
GOOGLE MEET
- Schedule a meeting from Calendar
- Start meeting from Meet
- Layout and View options
- Mute audio/video and see chat options
- Present a screen during a meeting and view participants at the same time
- Change your background
- Organize Breakout Rooms
- Open and share a Whiteboard
EXIT PROFILE
Exit Profile 👈🏽
- Understanding of MS Office & Windows
- Understanding Linux and Office Tools (Calc, Impress)
- Understanding the Concepts of Cloud Computing
- Proficiency in Configuring Online meetings using Google Team and Google Meet
CAREER PATH
Career Path 👈🏽
- Office Assistant
- Computer Operator
- IT Educator