Computer Operator

### Month 1 — Computer Fundamentals, Windows & MS Word **Lecture 01:** Computer Fundamentals & Introduction to Computers **Lecture 02:** Types of Computers & Generations of Computers **Lecture 03:** Computer Hardware, CPU, RAM, ROM & Storage **Lecture 04:** Input/Output Devices, Ports & Peripherals **Lecture 05:** Keyboard, Mouse & Typing Skills **Lecture 06:** Windows Introduction, Desktop, Start Menu & Taskbar **Lecture 07:** Windows Settings, Control Panel & User Accounts **Lecture 08:** File & Folder Management **Lecture 09:** File Extensions, ZIP Files & Data Organization **Lecture 10:** Windows Utilities, Task Manager & Device Manager **Lecture 11:** Software Installation & Uninstallation **Lecture 12:** Windows Installation & Bootable USB **Lecture 13:** Drivers, Updates & System Configuration **Lecture 14:** Basic Computer Troubleshooting & Maintenance **Lecture 15:** Hardware Safety & Preventive Maintenance **Lecture 16:** Windows & Computer Fundamentals Practical Assessment ### Month 2 — MS Word & MS Excel **Lecture 17:** MS Word Interface & Document Creation **Lecture 18:** Text Formatting, Fonts & Paragraphs **Lecture 19:** Bullets, Numbering, Borders & Shading **Lecture 20:** Page Setup, Margins, Orientation & Columns **Lecture 21:** Tables, Rows, Columns & Table Formatting **Lecture 22:** Images, Shapes, Icons & Text Boxes **Lecture 23:** SmartArt, WordArt & Charts **Lecture 24:** Headers, Footers, Page Numbers & Watermarks **Lecture 25:** Find, Replace, Styles & Templates **Lecture 26:** Mail Merge & Professional Documents **Lecture 27:** CV, Application, Letter & Report Preparation **Lecture 28:** Practical MS Word Project & Revision **Lecture 29:** MS Excel Interface, Workbook & Worksheet **Lecture 30:** Data Entry, Cell Formatting & Number Formats **Lecture 31:** Basic Excel Formulas & Operators **Lecture 32:** SUM, AVERAGE, MIN & MAX Functions ### Month 3 — Advanced Excel & PowerPoint **Lecture 33:** COUNT, COUNTA, COUNTBLANK & COUNTIF **Lecture 34:** SUMIF, IF, AND & OR Functions **Lecture 35:** VLOOKUP & XLOOKUP **Lecture 36:** FIND, SEARCH, LEFT, RIGHT, MID & LEN **Lecture 37:** Sorting, Filtering & Advanced Filtering **Lecture 38:** Data Validation & Drop-down Lists **Lecture 39:** Conditional Formatting & Remove Duplicates **Lecture 40:** Excel Tables & Data Management **Lecture 41:** Charts, Graphs & Data Visualization **Lecture 42:** Shapes, Icons, Hyperlinks & Excel Tools **Lecture 43:** Pivot Tables & Pivot Charts **Lecture 44:** Excel Dashboard Development **Lecture 45:** Student Result & Attendance Sheet Project **Lecture 46:** Invoice, Salary & Expense Sheet Project **Lecture 47:** Excel Revision & Practical Exercises **Lecture 48:** Excel Practical Assessment **Lecture 49:** PowerPoint Interface, Slides & Layouts **Lecture 50:** Themes, Templates & Professional Slide Design **Lecture 51:** Images, Shapes, Icons & SmartArt **Lecture 52:** Tables, Charts, Audio, Video & Hyperlinks ### Month 4 — PowerPoint, Access, Internet, Hardware, InPage & Video Editing **Lecture 53:** PowerPoint Animations & Transitions **Lecture 54:** Slide Master, Presentation Setup & Presenter View **Lecture 55:** Professional Business/Educational Presentation Project **Lecture 56:** PowerPoint Revision & Practical Assessment **Lecture 57:** MS Access — Database, Tables, Fields & Records **Lecture 58:** Access — Primary Keys, Relationships & Data Types **Lecture 59:** Access — Queries, Forms & Data Entry **Lecture 60:** Access — Reports, Sorting, Filtering & Printing **Lecture 61:** Internet, Browsers, Search Techniques & Online Services **Lecture 62:** Email, Attachments, Google Drive & Internet Safety **Lecture 63:** Computer Hardware, Parts Replacement & Troubleshooting **Lecture 64:** InPage, Basic Video Editing & Final Practical Project