Goglow Hub 2-Month Computer Appreciation Training

 

Mode: Offline (In-Person Lectures)

Duration: 2 Months (8 Weeks)

Target Audience: Beginners & Anyone Looking to Improve Computer Skills

 

Month 1: Fundamental Computer Skills & Microsoft Office Basics

 

Week 1: Introduction to Computers & Typing Skills

 

    •    Understanding Computer Hardware & Software

    •    Operating System Basics (Windows Navigation, File Management)

    •    Basic Typing Techniques & Speed Improvement

    •    Hands-on: Typing Practice with Mavis Beacon & Online Tools

 

Week 2: Microsoft Word – Document Processing

 

    •    Introduction to Microsoft Word & Interface Navigation

    •    Formatting Text, Paragraphs, and Pages

    •    Working with Tables, Images, and SmartArt

    •    How to Print Documents (Print Preview, Page Setup, Choosing a Printer, Print Settings)

    •    Hands-on: Creating & Formatting Official Documents

 

Week 3: Microsoft Word – Advanced Features

 

    •    Headers, Footers, Page Numbering & Table of Contents

    •    Mail Merge & Document Templates

    •    Reviewing & Protecting Documents (Track Changes, Password Protection)

    •    Hands-on: Creating a Resume & Business Proposal

 

Week 4: Microsoft Excel – Basic Spreadsheet Operations

 

    •    Introduction to Excel & Spreadsheet Navigation

    •    Entering & Formatting Data

    •    Basic Formulas & Functions (SUM, AVERAGE, IF, COUNTIF)

    •    Hands-on: Creating & Formatting a Simple Budget Sheet

 

Month 2: Advanced Microsoft Office Skills & Internet Utilization

 

Week 5: Microsoft Excel – Data Analysis & Visualization

 

    •    Sorting & Filtering Data

    •    Creating Charts & Graphs

    •    Introduction to Pivot Tables & Data Validation

    •    Hands-on: Generating a Sales Report with Charts

 

Week 6: Microsoft Access – Database Management

 

    •    Introduction to Microsoft Access & Database Basics

    •    Creating Tables, Queries, Forms & Reports

    •    Relationships & Data Integrity in Access

    •    Hands-on: Designing a Simple Student Management System

 

Week 7: Microsoft PowerPoint – Presentation Skills

 

    •    Creating & Designing Slideshows

    •    Adding Animations, Transitions & Multimedia Elements

    •    Delivering Effective Presentations

    •    Hands-on: Creating & Presenting a Business Pitch

 

Week 8: Internet & Email Utilization + Social Media Advert Creation + Final Project

 

    •    Browsing Safely & Using Search Engines Effectively

    •    Creating & Managing Emails (Gmail, Outlook)

    •    Sending Attachments & Using Email Features (CC, BCC, Filters)

    •    Social Media Advert Creation (Basic Graphic Design with Canva, Writing Captions, Posting on Facebook, Instagram, and WhatsApp Business)

    •    Hands-on: Sending Professional Emails & Creating a Google Form

    •    Final Project: Creating a Report with Word, Excel Data, & PowerPoint Presentation

 

Certification:

 

Upon successful completion, participants will receive a Goglow Hub Computer Appreciation Certificate.