Goal: Build complete familiarity with computer components, Windows operating system navigation, file management, and touch typing.
Week 1: Computer Architecture & Hardware Basics
Generations and types of computers, CPU, memory (RAM, ROM, SSD/HDD), input/output devices, and peripheral connections.
Week 2: Windows 10/11 Operating System & File Management
Desktop interface, Control Panel, Task Manager, creating/organizing folders, file compression (ZIP/RAR), and system utilities.
Week 3: Keyboard Mastery & Essential Utilities
Touch typing techniques (targeting 25–30 WPM), Windows shortcut keys, Notepad, WordPad, Paint, Snipping Tool, and PDF tools.
Week 4: Internet, Cloud Tools & Month-1 Assessment
Web browsers, search techniques, Google Drive/Docs/Sheets, online form filling, email etiquette, and basic cyber safety.
Month-1 Evaluation: File-management & typing speed practical test + 30-minute theory quiz.
Goal: Master professional document creation, automated bulk mailings, and corporate presentations.
Week 5: MS Word — Formatting & Document Structure
Page setup, margins, paragraph styles, tables, headers/footers, page numbering, watermarks, and Table of Contents.
Week 6: MS Word — Advanced Office Productivity
Mail Merge for bulk letters/certificates, Macros, Track Changes, hyperlinks, form controls, and print-ready PDF exports.
Week 7: MS PowerPoint — Slide Design & Visual Hierarchy
Slide layouts, Slide Master, themes, SmartArt, charts, tables, and embedding audio/video media.
Week 8: MS PowerPoint — Animations & Month-2 Assessment
Custom animations, slide transitions, rehearsal timings, presenter view, and exporting presentations as video/PDF.
Month-2 Evaluation: Create a formatted multi-page business report (Word) and an 8-slide business pitch deck (PowerPoint).
Goal: Master spreadsheet calculations, logical/lookup functions, data validation, and visual business reporting.
Week 9: Excel Fundamentals & Core Formulas
Workbook structure, cell referencing (relative, absolute, mixed), formatting, sorting, filtering, and SUM, AVERAGE, COUNT, MIN/MAX.
Week 10: Logical, Conditional & Lookup Functions
IF, AND, OR, COUNTIF, SUMIF, VLOOKUP, XLOOKUP, and essential text/date formulas.
Week 11: Pivot Tables, Charts & Data Tools
Conditional formatting, Data Validation dropdowns, Pivot Tables, Pivot Charts, Slicers, and freeze panes/print setup.
Week 12: Office Automation Templates & Month-3 Assessment
Designing an automated employee attendance & salary register, student marksheet, and monthly sales tracker.
Month-3 Evaluation: Timed 60-minute Excel practical test covering formulas, Pivot Tables, and charts.
Goal: Manage structured office databases, configure email clients, and design basic print/marketing creatives.
Week 13: MS Outlook & MS Access Basics
Configuring email accounts in MS Outlook, calendar scheduling, and contact management.
Creating tables, primary keys, forms, queries, and printable reports in MS Access.
Week 14: CorelDRAW — Vector Design & Print Layouts
Workspace tools, shapes, typography, color modes (RGB/CMYK), and designing visiting cards, letterheads, and fee receipts.
Week 15: Adobe Photoshop — Image Editing & Graphics
Layers, selection tools, background removal, color/lighting adjustments, and photo retouching for ID cards and brochures.
Week 16: Promotional Designs & Month-4 Assessment
Designing promotional flyers, social media posters, and print-ready PDF exports.
Month-4 Evaluation: Create an MS Access customer database + a business visiting card and promotional flyer.
Goal: Master computerized double-entry bookkeeping, company configuration, and day-to-day accounting vouchers.
Week 17: Accounting Principles & Tally ERP 9 Interface
Golden rules of accounting, assets, liabilities, income, expenses, company creation, alteration, security control, and Tally Vault.
Week 18: Groups, Ledgers & F11/F12 Configurations
Pre-defined vs. custom Accounting Groups, creating/altering Ledgers (Single & Multiple mode), and configuring company features.
Week 19: Day-to-Day Accounting Vouchers
Recording Contra (F4), Payment (F5), Receipt (F6), Journal (F7), Sales (F8), Purchase (F9), Debit Note (Ctrl+F9), and Credit Note (Ctrl+F8).
Week 20: Financial Statements & Month-5 Assessment
Day Book, Cash/Bank Book, Ledger reports, Trial Balance, Profit & Loss Account, and Balance Sheet verification.
Month-5 Evaluation: Complete a 1-month service & trading company accounting assignment from raw vouchers to Balance Sheet.
Goal: Track multi-location stock, manage purchase/sales order cycles, and allocate departmental expenses.
Week 21: Inventory Masters & Godown Management
Creating Stock Groups, Stock Categories, Units of Measure (Simple & Compound), Stock Items, and multiple Godowns/Locations.
Week 22: Inventory Vouchers & Batch Tracking
Stock Journal (Alt+F7) for inter-godown transfers, Physical Stock verification (Alt+F10), batch-wise details, and manufacturing/expiry dates.
Week 23: Complete Purchase & Sales Order Cycle
Purchase Order (Alt+F4), Receipt Note (Alt+F9), Rejection Out (Alt+F6), Sales Order (Alt+F5), Delivery Note (Alt+F8), and Rejection In (Ctrl+F6).
Week 24: Cost Centers, Budgets & Month-6 Assessment
Cost Categories and Cost Centers for branch/department expense tracking, plus setting credit limits and budgets.
Month-6 Evaluation: Complete a full inventory & order-processing case study with Stock Summary and Godown reports.
Goal: Handle statutory GST/TDS compliance, bank reconciliation, employee payroll, and complete a real-world business project.
Week 25: Goods & Services Tax (GST) in Tally ERP 9
Activating GST, setting HSN/SAC codes, creating CGST, SGST, and IGST ledgers, passing intrastate & interstate B2B/B2C invoices, and viewing GSTR-1, GSTR-2, and GSTR-3B.
Week 26: TDS, Banking & Bank Reconciliation (BRS)
Configuring TDS nature of payments, deducting TDS on contractor/rent/professional bills, cheque printing, deposit slips, and Bank Reconciliation Statement (BRS).
Week 27: Tally Payroll & Data Security Management
Creating Employee Groups/Masters, Attendance/Production types, Pay Heads, processing monthly salary vouchers, plus Data Backup, Restore, and Split Company Data.
Week 28: Final Integrated Capstone Project & Certification
Capstone Project: Build a complete office & accounts portfolio for a sample business—comprising a company letterhead & invoice template (Word/CorelDRAW), an employee & sales tracker (Excel), and a full quarter of GST-compliant accounts, inventory, BRS, and Balance Sheet (Tally ERP 9).
Final Practical & Viva Exam: Combined hands-on examination across Basic Computer, Application Software, and Tally ERP 9 for final certification.
Call us at:
+91-9779600740, 9855474016