Category: Computer

Month 1: Computer Fundamentals, Hardware & Windows OS (Weeks 1–4)

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.

Month 2: Application Software — MS Word & MS PowerPoint (Weeks 5–8)

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).

Month 3: Application Software — MS Excel & Data Analysis (Weeks 9–12)

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.

Month 4: MS Access, Outlook & Desktop Publishing (DTP) (Weeks 13–16)

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.

Month 5: Tally ERP 9 — Accounting Basics & Voucher Entry (Weeks 17–20)

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.

Month 6: Tally ERP 9 — Inventory Management & Order Processing (Weeks 21–24)

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.

Month 7: Tally ERP 9 — GST, TDS, Banking, Payroll & Capstone (Weeks 25–28)

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.

Top