Course Level: Intermediate

Course Objectives

• Build essential computer and internet navigation skills

• Gain mastery in Microsoft Word, Excel, and PowerPoint

• Utilize digital communication and project collaboration platforms

• Apply data management and cybersecurity best practices

• Learn to manage digital schedules and tools effectively

• Understand social media basics and their business relevance

• Explore automation and digital productivity tools

Course Outline

Module 1: Introduction to Basic Computer Skills

• Understanding computer hardware and software

• Navigating Windows or Mac OS

• File and folder management

• Basic troubleshooting techniques

• Introduction to cloud storage

Case Study:
Participants set up and organize folders for an upcoming event, saving documents to cloud storage while implementing basic troubleshooting steps on a faulty USB device.

Module 2: Internet and Email Proficiency

• Safe and effective internet browsing

• Managing email accounts and etiquette

• Using Zoom, Skype, and web conferencing tools

• Creating email folders and filters

• Email security and spam management

Case Study:
Each participant creates a Gmail account, organizes inbox folders for different tasks, joins a Zoom meeting, and practices proper email replies for a mock internal memo.

Module 3: Microsoft Office Suite – Word

• Formatting professional documents

• Using templates and styles

• Inserting images, charts, and tables

• Collaborative editing features

• Mail merge and document automation

Case Study:
Trainees format a formal company letter using templates, collaborate via tracked changes, and send customized letters using mail merge for a staff announcement.

Module 4: Microsoft Office Suite – Excel

• Creating and formatting spreadsheets

• Common functions and formulas

• PivotTables and data charts

• Managing large data sets

• Automating reports with macros

Case Study:
Create a payroll spreadsheet, apply formulas for deductions and totals, and generate a PivotTable to summarize departmental expenses.

Module 5: Microsoft Office Suite – PowerPoint

• Building impactful presentations

• Using slide templates and themes

• Inserting videos, audio, and graphics

• Presentation delivery techniques

• Collaboration on slide decks

Case Study:
Each participant designs a presentation on “Improving Office Efficiency” using themes, animations, and embedded multimedia, then presents it to the class.

Module 6: Digital Communication and Collaboration Tools

• Microsoft Teams, Slack, and collaboration platforms

• Task/project management with Trello and Asana

• Effective use of chat and instant messaging

• Document sharing and real-time collaboration

• Virtual meeting etiquette and tools

Case Study:
Participants manage a mock project on Trello, assign roles, chat via Teams, and conduct a virtual meeting while sharing progress updates and files.

Module 7: Data Management and Cybersecurity

• Safe data storage and backup strategies

• Password creation and use of password managers

• Recognizing cybersecurity threats and phishing

• Secure file sharing practices

Case Study:
Participants simulate a phishing attack scenario, create strong passwords using a manager, and back up files to a secure cloud drive.

Module 8: Digital Calendar and Scheduling Tools

• Managing Google and Outlook Calendars

• Scheduling and sending meeting invites

• Sharing calendars and using reminders

• Integrating calendars with other apps

• Productivity tips

Case Study:
Schedule a full week’s calendar, create recurring meetings, and integrate tasks with email reminders, including time blocks for personal and work goals.

Module 9: Introduction to Social Media and Digital Marketing

• Overview of LinkedIn, Facebook, and Instagram

• Setting up a professional online presence

• Basics of content creation

• Introduction to analytics and engagement tracking

• Social media etiquette in professional settings

Case Study:
Create a LinkedIn profile for a fictional company secretary and plan a week’s worth of LinkedIn posts using basic graphic and caption tools.

Module 10: Advanced Office Tools and Productivity Enhancers

• Introduction to Zapier and automation tools

• Note-taking with OneNote and Evernote

• Using dictation and voice tools

• eSignature and digital document management

• Ongoing tech-learning resources

Case Study:
Participants automate a task using Zapier (e.g., email to task list), take notes during a meeting using OneNote, and digitally sign a PDF using DocuSign.