Category: Computer

Month 1: Basic Computer, Internet & MS Word / PowerPoint (Weeks 1–4)

Goal: Build complete operational fluency in Windows, digital communication, professional documentation, and presentations.

  • Week 1: Computer Fundamentals, Windows 10/11 & Typing

    • Computer components (CPU, RAM, ROM, SSD/HDD), input/output devices, and peripheral connections.

    • Navigating Windows 10/11, Control Panel, Task Manager, folder hierarchy, file compression (ZIP/RAR), and touch typing fundamentals.

  • Week 2: Internet Productivity, Email & Digital Utilities

    • Web browsers, search operators, online form filling, Google Drive/Docs, and PDF merging/converting tools.

    • Writing professional emails (To, CC, BCC, attachments) and basic cyber hygiene.

  • Week 3: Application Software — MS Word

    • Page margins, paragraph formatting, styles, tables, headers/footers, page numbers, and watermarks.

    • Mail Merge for bulk letters/certificates, hyperlinks, and print-ready PDF exports.

  • Week 4: Application Software — MS PowerPoint & Month-1 Exam

    • Slide layouts, Slide Master, themes, SmartArt, charts, custom animations, slide transitions, and presenter view.

    • Month-1 Evaluation: Typing speed & file-management test + formatted official letter (Word) and 6-slide presentation (PowerPoint).

Month 2: MS Excel & Tally ERP 9 Accounting Foundations (Weeks 5–8)

Goal: Master workplace data analysis in Excel and transition into computerized double-entry accounting in Tally ERP 9.

  • Week 5: MS Excel — Core Formulas & Logical Functions

    • Workbook navigation, relative vs. absolute cell referencing, sorting, filtering, and SUM, AVERAGE, COUNT, MIN/MAX.

    • Conditional and lookup formulas: IF, AND, OR, COUNTIF, SUMIF, VLOOKUP, and XLOOKUP.

  • Week 6: MS Excel — Pivot Tables, Charts & Business Trackers

    • Conditional formatting, Data Validation dropdowns, Pivot Tables, Pivot Charts, and print page-break setup.

    • Building an automated employee attendance/salary register and a monthly sales summary sheet.

  • Week 7: Tally ERP 9 — Accounting Principles & Company Setup

    • Golden rules of accounting, assets, liabilities, income, and expenses.

    • Company creation, alteration, security control, Tally Vault, F11/F12 configurations, and creating Accounting Groups and Ledgers (Single & Multiple modes).

  • Week 8: Tally ERP 9 — Day-to-Day Vouchers & Month-2 Exam

    • Recording Contra (F4), Payment (F5), Receipt (F6), Journal (F7), Sales (F8), Purchase (F9), Debit Note (Ctrl+F9), and Credit Note (Ctrl+F8).

    • Inspecting Day Book, Cash/Bank Book, Trial Balance, Profit & Loss Account, and Balance Sheet.

    • Month-2 Evaluation: Timed Excel formula/Pivot test + 1-month service and trading company voucher entry assignment in Tally ERP 9.

Month 3: Tally ERP 9 Inventory, GST, Banking & Capstone (Weeks 9–12)

Goal: Manage multi-location stock, process GST-compliant tax invoices, reconcile bank statements, and complete an end-to-end business project.

  • Week 9: Inventory Management & Order Processing

    • Creating Stock Groups, Stock Categories, Units of Measure, Stock Items, and multiple Godowns/Locations.

    • Inter-godown Stock Journal (Alt+F7) transfers, Purchase Orders (Alt+F4), Sales Orders (Alt+F5), Receipt/Delivery Notes, and Stock Summary analysis.

  • Week 10: Goods & Services Tax (GST) in Tally ERP 9

    • Activating GST, configuring HSN/SAC codes, and creating CGST, SGST, and IGST ledgers.

    • Recording intrastate and interstate B2B/B2C tax invoices, credit/debit notes, and generating GSTR-1, GSTR-2, and GSTR-3B reports.

  • Week 11: Banking (BRS), TDS/Payroll & Data Security

    • Cheque printing, payment advice, and Bank Reconciliation Statement (BRS).

    • Basic TDS deduction entries, simple monthly salary/payroll vouchers, Data Backup, Restore, and exporting financial reports to PDF/Excel.

  • Week 12: Final Integrated Capstone & Certification Exam

    • Capstone Project: Prepare an employee salary & sales tracker in Excel alongside a complete 1-month GST-compliant trading business (vouchers, inventory, BRS, and Balance Sheet) in Tally ERP 9.

    • Final Certification Exam: Practical lab exam + viva voce covering Basic Computer, MS Office, and Tally ERP 9.

Top