Training

የኰልሜ ወረዳ ኢኖቬሽንና ቴክኖሎጂ ጽ/ቤት በ2018 ዓ.ም. ለሕብረተሳብችን በቴክኖሎጂና በኮምፕዩተር ክህሎቶች ላይ ሥልጠና ለመስጠት ዕቅድ ነድፎ እንቅስቃሴ ጀምሯል። ስለሆነም በጽ/ቤታችን የተዘጋጀውን የሥልጠና ዕድል ተጠቃሚ መሆን የምትፈልጉ ሁሉ ከዚህ በታች ከተዘረዘሩት የሥልጠና መስኮች የምትፈልጒትን መርጣችሁ እንድትመዘገቡና ሥልጠናውን እንድትወስዱ ጥሪያችንን እናስተላለፋለን።

1. Basic Computer Skill

Course contents
Introduction to Computers (theory 1 hour)1.1.

2. INTERMEDIATE COMPUTER SKILLS

Module Overview

Target Audience

Office staff, administrators, and civil servants who have basic computer literacy (file management, keyboard/mouse use) and wish to build practical, intermediate-level competence in Microsoft Office applications, both installed and online.

Duration

Recommended duration: 20 training sessions of approximately 90 minutes each (one session per topic), delivered over 4 to 6 weeks with hands-on computer access required throughout.

Overall Learning Outcomes

By the end of this module, trainees will be able to:

• Identify and appropriately use each application in the Microsoft Office package for everyday office tasks
• Install, activate, update, and troubleshoot Microsoft Office on an office computer
• Access and use Microsoft 365 online applications, manage a Microsoft account, and collaborate on shared documents through OneDrive
• Apply these skills directly to real institutional tasks such as report writing, record-keeping, correspondence, and team collaboration

Module Contents

Part I: The Microsoft Office Application Package

1.1 Introduction to the Microsoft Office Suite

1.2 Microsoft Word — Word Processing

1.3 Microsoft Excel — Spreadsheets

1.4 Microsoft PowerPoint — Presentations

1.5 Microsoft Outlook — Email and Calendar Management

1.6 Microsoft Access — Database Management

1.7 Microsoft OneNote — Digital Note-Taking

1.8 Microsoft Teams — Communication and Collaboration

1.9 Other Office Applications: Publisher, Visio, and OneDrive

Part II: Installing Microsoft Office Applications

2.1 System Requirements for Microsoft Office

2.2 Acquiring Microsoft Office (Licensing Options)

2.3 Step-by-Step Installation Process

2.4 Activation and Licensing Verification

2.5 Updating, Repairing, and Uninstalling Office

Part III: Online Microsoft Office Applications

3.1 Introduction to Microsoft 365 Online (Office Online)

3.2 Creating and Managing a Microsoft Account

3.3 Using Word, Excel, and PowerPoint Online

3.4 OneDrive Cloud Storage and File Sharing

3.5 Real-Time Co-Authoring and Collaboration

3.6 Microsoft Teams and Outlook Online for Communication     

ADVANCED COMPUTER SKILLSTRAINING PROGRAM

1. Course Overview

The Advanced Computer Skills Training Program is a practical, hands-on course designed to take trainees beyond basic computer familiarity into confident, professional-level use of everyday digital tools. The program targets general public trainees who already have basic computer literacy and wish to build advanced, job-ready skills in account management, computer maintenance, and the Microsoft Office suite.

The course emphasizes learning by doing: every module pairs conceptual instruction with guided practice using realistic tasks and sample files, so trainees leave each session able to apply what they learned immediately.

1.1 Target Audience

General public trainees with basic computer literacy (mouse/keyboard use, opening and saving files, basic internet browsing) who want to build advanced, employable digital skills.

1.2 Duration and Format

• Total duration: 5 weeks
• Frequency: 3 sessions per week
• Session length: 2 hours per session
• Total contact hours: 30 hours (15 sessions)
• Format: Instructor-led, hands-on computer lab sessions

1.3 Prerequisites

• Basic computer literacy: turning a computer on/off, using a mouse and keyboard
• Ability to open, save, and navigate files and folders
• Basic familiarity with the Windows desktop environment
• No prior experience with Microsoft Office is required

1.4 Software and Platform

This syllabus is written for Microsoft Office 2016, and all features described are also available in Office 2013/2010 unless noted otherwise. This ensures the course remains accessible on older institutional computers while still teaching genuinely advanced, transferable skills.

2. Overall Course Objectives

By the end of this training program, trainees will be able to:

1. Set up, secure, and manage computer user accounts and email accounts using current best practices.
2. Perform routine computer maintenance tasks that keep a machine running safely and efficiently.
3. Produce professional, well-structured documents in Microsoft Word using advanced formatting, references, and automation tools.
4. Analyze and present data confidently using advanced Microsoft Excel formulas, PivotTables, and charts.
5. Design and deliver polished, interactive presentations using advanced PowerPoint features.
6. Create print-ready publications such as brochures and newsletters using Microsoft Publisher.
7. Design simple relational databases and build queries, forms, and reports in Microsoft Access.
8. Manage professional email communication, scheduling, and contacts efficiently using Microsoft Outlook.
9. Apply digital security and organizational habits that protect data and improve everyday productivity.

3. Course Schedule

Week	Session	Topic	Hours
1	1	Module 1 – Basics of Computer Accounts	2 hrs
1	2	Module 2 – Basic Computer Maintenance (Part 1)	2 hrs
1	3	Module 2 – Basic Computer Maintenance (Part 2)	2 hrs
2	4	Module 3.1 – Advanced Word (Part 1: Layout, Styles, References)	2 hrs
2	5	Module 3.1 – Advanced Word (Part 2: Charts, Graphs, Shapes, TOC)	2 hrs
2	6	Module 3.1 – Advanced Word (Part 3: Mail Merge, Macros, Collaboration)	2 hrs
3	7	Module 3.2 – Advanced Excel (Part 1: Formulas & Functions)	2 hrs
3	8	Module 3.2 – Advanced Excel (Part 2: PivotTables, Charts, What-If Analysis)	2 hrs
3	9	Module 3.2 – Advanced Excel (Part 3: Macros/VBA, Power Query, Protection)	2 hrs
4	10	Module 3.3 – Advanced PowerPoint	2 hrs
4	11	Module 3.4 – Publisher	2 hrs
4	12	Module 3.5 – Microsoft Access (Part 1: Tables & Relationships)	2 hrs
5	13	Module 3.5 – Microsoft Access (Part 2: Queries, Forms, Reports)	2 hrs
5	14	Module 3.6 – Outlook	2 hrs
5	15	Final Review, Practical Assessment & Certification	2 hrs