Category: Computer

Month 1: Computer Fundamentals & Operating Systems (Weeks 1–4)

Goal: Build complete familiarity with computer hardware, Windows OS navigation, file management, and safe internet usage.

  • Week 1: Computer Hardware, Software & OS Basics

    • Input/output devices, CPU architecture, memory types (RAM, ROM, SSD/HDD), and peripheral connections.

    • Navigating the Windows 10/11 interface, Control Panel, Task Manager, and system settings.

  • Week 2: File Management & Essential Utilities

    • Creating, organizing, compressing (ZIP/RAR), and backing up files and folders.

    • Installing/uninstalling software, managing device drivers, and using basic troubleshooting tools.

  • Week 3: Keyboard Mastery & Digital Basics

    • Touch typing techniques (targeting 25–30 WPM) and essential Windows shortcut keys.

    • Using Notepad, WordPad, Paint, Snipping Tool, and PDF readers/converters.

  • Week 4: Internet, Email & Month-1 Assessment

    • Web browsers, search operators, cloud storage (Google Drive), and online form filling.

    • Professional email writing, attachments, CC/BCC etiquette, and basic cyber hygiene.

    • Month-1 Evaluation: Practical file-management test + 30-minute theory & shortcut quiz.

Month 2: MS Office & Office Automation (Weeks 5–8)

Goal: Master workplace documentation, spreadsheet calculations, and business presentations.

  • Week 5: MS Word — Professional Documentation

    • Page layout, paragraph formatting, headers/footers, tables, and styles.

    • Mail merge for bulk letters/certificates, track changes, and exporting print-ready PDFs.

  • Week 6: MS Excel — Formulas & Data Organization

    • Cell referencing (relative, absolute), sorting, filtering, and conditional formatting.

    • Core functions: , and text/date functions.

  • Week 7: MS Excel—Charts, Pivot Tables & Data Validation

    • Creating dynamic pivot tables, pivot charts, and data validation dropdowns.

    • Designing attendance sheets, salary registers, and basic sales trackers.

  • Week 8: MS PowerPoint & Month-2 Assessment

    • Slide layouts, master slide design, animations, transitions, and embedding charts/media.

    • Month-2 Evaluation: Create a formatted business report (Word), sales dashboard (Excel), and 5-slide pitch deck (PowerPoint).

Month 3: Computer Networking Fundamentals (Weeks 9–12)

Goal: Understand how networks operate, build physical LAN cables, and configure IP addressing.

  • Week 9: Networking Basics & Topologies

    • Types of networks (LAN, MAN, WAN, PAN) and network topologies (star, mesh, bus, hybrid).

    • Understanding networking hardware: Switches, routers, modems, access points, and NICs.

  • Week 10: OSI Model, TCP/IP & Network Protocols

    • Layered architecture of the OSI and TCP/IP models.

    • Core protocols and ports: HTTP/HTTPS, FTP, SMTP, DNS, DHCP, and SSH.

  • Week 11: Cabling, Crimping & Physical Setup

    • Twisted-pair cables (Cat5e, Cat6), fiber optics basics, and RJ45 connectors.

    • Hands-on lab: Straight-through and crossover cable crimping (T568A/T568B) and testing with a LAN tester.

  • Week 12: IP Addressing, Subnetting & Month-3 Assessment

    • IPv4 vs. IPv6, Private vs. Public IPs, and IP classes (Class A, B, C).

    • Basic subnet masking and configuring static vs. dynamic (DHCP) IP addresses on PCs.

    • Month-3 Evaluation: Crimp a working Cat6 patch cable and configure a 2-PC peer-to-peer LAN connection.

Month 4: Network Administration, Sharing & Security (Weeks 13–16)

Goal: Set up small-office networks, share resources, diagnose connectivity issues, and secure endpoints.

  • Week 13: Router Configuration & Wi-Fi Setup

    • Accessing router admin panels, configuring WAN/LAN settings, SSID, WPA2/WPA3 security, and MAC filtering.

    • Setting up port forwarding, DMZ, and basic bandwidth control (QoS).

  • Week 14: Resource Sharing & Workgroup Management

    • Configuring Windows Workgroups, sharing folders with read/write permissions, and mapping network drives.

    • Installing and sharing network printers across multiple workstations.

  • Week 15: Command-Line Diagnostics & Troubleshooting

    • Mastering network CLI commands:

    • Diagnosing IP conflicts, DNS failures, gateway timeouts, and hardware faults.

  • Week 16: Network Security & Month-4 Assessment

    • Windows Defender Firewall rules, antivirus management, VPN basics, and phishing defense.

    • Month-4 Evaluation: Set up a complete multi-PC lab network with router configuration, shared folders/printer, and fault troubleshooting.

Month 5: Tally ERP 9 — Core Accounting & Inventory (Weeks 17–20)

Goal: Master computerized double-entry bookkeeping, voucher recording, and stock management in Tally ERP 9.

  • Week 17: Accounting Principles & Tally Interface

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

    • Company creation, alteration, security control, Tally Vault, and F11/F12 configuration settings.

  • Week 18: Masters Creation & Accounting Vouchers

    • Creating and managing accounting groups and ledgers (single and multiple modes).

    • Recording daily transactions using Contra (F4), Payment (F5), Receipt (F6), Journal (F7), Sales (F8), and Purchase (F9) vouchers.

  • Week 19: Inventory Management & Godown Tracking

    • Creating Stock Groups, Stock Categories, Units of Measure, and Stock Items.

    • Managing multiple godowns/locations, batch-wise details, and stock transfers.

  • Week 20: Order Processing & Month-5 Assessment

    • Purchase Orders, Sales Orders, Receipt Notes, Delivery Notes, and Rejection In/Out Vouchers.

    • Generating Trial Balance, Profit & Loss Account, Balance Sheet, and Stock Summary.

    • Month-5 Evaluation: Complete a 1-month trading company accounting and inventory case study from raw bills to balance sheet.

Month 6: Tally ERP 9 — Taxation (GST/TDS), Banking & Capstone (Weeks 21–24)

Goal: Handle statutory compliance, banking reconciliation, payroll, and complete an end-to-end business project.

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

    • Enabling GST, configuring CGST, SGST, and IGST ledgers, and setting HSN/SAC codes.

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

  • Week 22: TDS, TCS & Banking Operations

    • Configuring the nature of TDS payments, deducting TDS on expenses, and generating TDS reports.

    • Check printing, deposit slips, payment advice, and Bank Reconciliation Statement (BRS).

  • Week 23: Payroll, Cost Centers & Data Security

    • Setting up employee masters, attendance/production types, and pay heads and processing monthly payroll.

    • Cost Centers/Categories for department-wise expense tracking, plus Data Backup, Restore, and Split Company Data.

  • Week 24: Final Capstone Project & Certification

    • Integrated Capstone Project: Set up a networked office lab (3 PCs sharing a Tally data folder over LAN) and process a full quarter of GST-compliant business accounts, inventory, BRS, and final financial reports.

    • Final Viva & Practical Exam: Combined evaluation across Basic Computer, Networking, and Tally ERP 9 for final diploma certification.

Evaluation & Tracking System

  • Bi-Weekly Lab Practicals: Every second Friday features a timed 60-minute practical test covering that fortnight's module (office formatting, LAN setup, or Tally voucher entry).

  • Student Lab Logbook: Each student maintains a daily practical record signed off by the instructor

Top