Category: Computer

Semester I: Office Automation, Internet & Computerized Accounting (Months 1–6)

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

Goal: Build complete fluency in computer hardware basics, Windows operating system management, and touch typing.

  • Week 1: Computer Architecture & Hardware Basics

    • Generations of computers, CPU, memory (RAM, ROM, SSD/HDD), input/output devices, and peripheral setup.

  • Week 2: Windows 10/11 Operating System & File Management

    • Desktop environment, Control Panel, Task Manager, file/folder hierarchy, compression (ZIP/RAR), and system utilities.

  • Week 3: Keyboard Mastery & Digital Utilities

    • Touch typing (targeting 30+ WPM), Windows shortcut keys, Notepad, Paint, Snipping Tool, and PDF management.

  • Week 4: Internet, Cloud Tools & Month-1 Assessment

    • Web browsers, search operators, Google Drive/Docs/Sheets, professional email etiquette, and cyber safety.

    • Month-1 Evaluation: File-management & typing speed test + 30-minute theory quiz.

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

Goal: Produce professional business documents, automated mailings, and corporate presentations.

  • Week 5: MS Word — Formatting & Layout

    • Page setup, paragraph styles, tables, headers/footers, watermarks, footnotes, and Table of Contents.

  • Week 6: MS Word — Advanced Productivity

    • Mail Merge for bulk letters/certificates, Macros, Track Changes, form creation, and print-ready PDF exports.

  • Week 7: MS PowerPoint — Slide Design & Visuals

    • Slide layouts, Slide Master, SmartArt, charts, audio/video embedding, and visual hierarchy principles.

  • Week 8: MS PowerPoint — Animations & Month-2 Assessment

    • Custom animations, slide transitions, presenter view, and exporting presentations as videos/PDFs.

    • Month-2 Evaluation: Create a formatted business project report (Word) and a 10-slide presentation deck (PowerPoint).

Month 3: MS Excel & Data Management (Weeks 9–12)

Goal: Master spreadsheet formulas, data analysis, automated reporting, and business dashboards.

  • Week 9: Excel Fundamentals & Core Formulas

    • Cell referencing (relative, absolute, mixed), formatting, sorting, filtering, and SUM, AVERAGE, COUNT, MIN/MAX.

  • Week 10: Logical, Lookup & Text Functions

    • IF, AND, OR, COUNTIF, SUMIF, VLOOKUP, XLOOKUP, INDEX-MATCH, and date/text manipulation functions.

  • Week 11: Data Analysis, Pivot Tables & Charts

    • Conditional formatting, Data Validation dropdowns, Pivot Tables, Pivot Charts, Slicers, and What-If Analysis.

  • Week 12: Office Automation Project & Month-3 Assessment

    • Building an automated employee payroll sheet, student marksheet, and sales dashboard.

    • Month-3 Evaluation: Timed 60-minute Excel practical test covering formulas, Pivot Tables, and charts.

Month 4: Desktop Publishing (DTP) & Graphic Basics (Weeks 13–16)

Goal: Design print and digital marketing materials such as brochures, flyers, logos, and ID cards.

  • Week 13: Graphic Design Principles & CorelDRAW Basics

    • Color modes (RGB vs. CMYK), resolution, vector vs. raster graphics, workspace tools, shapes, and bezier curves.

  • Week 14: CorelDRAW — Print Layouts & Branding

    • Designing visiting cards, letterheads, wedding/event cards, brochures, flex banners, and basic logos.

  • Week 15: Adobe Photoshop — Image Editing & Retouching

    • Layers, selection tools, masking, color correction, background removal, and photo restoration.

  • Week 16: Social Media Creatives & Month-4 Assessment

    • Designing posters, thumbnails, and print-ready export settings (PDF/JPEG/PNG).

    • Month-4 Evaluation: Design a complete branding kit (Logo + Visiting Card + Promotional Flyer).

Month 5: Computerized Accounting — Tally ERP 9 / Tally Prime (Weeks 17–20)

Goal: Master double-entry bookkeeping, voucher entries, and inventory management in Tally.

  • Week 17: Accounting Principles & Company Setup

    • Golden rules of accounting, ledgers, groups, company creation, security control, and Tally configuration.

  • Week 18: Accounting Vouchers & Day-to-Day Entries

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

  • Week 19: Inventory Management & Godowns

    • Stock Groups, Categories, Units of Measure, Stock Items, multi-godown tracking, and batch-wise stock management.

  • Week 20: Financial Statements & Month-5 Assessment

    • Order processing, Trial Balance, Profit & Loss Account, Balance Sheet, and Stock Summary analysis.

    • Month-5 Evaluation: Complete a 1-month trading business accounting case study from raw bills to Balance Sheet.

Month 6: GST Taxation, Banking & Semester-I Exam (Weeks 21–24)

Goal: Handle GST compliance, bank reconciliation, and payroll in Tally.

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

    • Configuring CGST, SGST, IGST ledgers, HSN/SAC codes, B2B/B2C invoicing, and generating GSTR-1, GSTR-2, and GSTR-3B.

  • Week 22: TDS, Banking & Bank Reconciliation (BRS)

    • TDS deduction entries, cheque printing, payment advice, and Bank Reconciliation Statement (BRS).

  • Week 23: Tally Payroll & Data Management

    • Employee masters, attendance types, pay heads, monthly salary processing, plus backup, restore, and company data splitting.

  • Week 24: Semester-I Comprehensive Exam

    • Semester-I Practical & Theory Exam: Combined assessment covering Windows, MS Office, DTP, and Tally GST accounting.

Semester II: Databases, Web Design & Programming Fundamentals (Months 7–12)

Month 7: Database Management Systems (RDBMS & SQL) (Weeks 25–28)

Goal: Design relational databases and write structured queries to store, retrieve, and manage data.

  • Week 25: Database Concepts & MS Access

    • Data vs. information, tables, primary/foreign keys, normalization basics, and creating tables, forms, and reports in MS Access.

  • Week 26: Introduction to SQL (MySQL)

    • Installing MySQL, Data Definition Language (CREATE, ALTER, DROP), and data types.

  • Week 27: Data Manipulation & Filtering

    • INSERT, UPDATE, DELETE, SELECT, WHERE, ORDER BY, GROUP BY, and aggregate functions (COUNT, SUM, AVG).

  • Week 28: Joins, Subqueries & Month-7 Assessment

    • INNER JOIN, LEFT JOIN, RIGHT JOIN, constraints (UNIQUE, NOT NULL, CHECK), and basic views.

    • Month-7 Evaluation: Design a normalized Student or Inventory database and execute 15 SQL queries.

Month 8: Web Designing — HTML5 & CSS3 (Weeks 29–32)

Goal: Build responsive, multi-page static websites from scratch using modern HTML5 and CSS3.

  • Week 29: HTML5 Structure & Semantic Tags

    • VS Code setup, document structure, headings, lists, links, images, audio/video embedding, and semantic layout tags.

  • Week 30: HTML Forms, Tables & Media

    • Building structured tables and interactive registration/contact forms with HTML5 input validations.

  • Week 31: CSS3 Styling & Box Model

    • Selectors, colors, typography, borders, margins, padding, positioning, and background styling.

  • Week 32: Modern Layouts (Flexbox, Grid) & Month-8 Assessment

    • Building mobile-responsive layouts using CSS Flexbox, CSS Grid, and Media Queries.

    • Month-8 Evaluation: Build a responsive 4-page business or institute website using HTML5 and CSS3.

Month 9: Interactive Web Development — JavaScript & Hosting (Weeks 33–36)

Goal: Add client-side interactivity to websites and deploy projects live on the web.

  • Week 33: JavaScript Fundamentals

    • Variables (let, const), data types, operators, conditional statements (if-else, switch), and loops.

  • Week 34: Functions, Arrays & Objects

    • Writing reusable functions, array methods, JSON objects, and basic client-side logic.

  • Week 35: DOM Manipulation & Form Validation

    • Selecting and modifying HTML/CSS dynamically, event listeners, interactive calculators, and real-time form validation.

  • Week 36: Web Hosting Basics & Month-9 Assessment

    • Domain names, web hosting, FTP/cPanel upload, GitHub Pages deployment, and basic SEO meta tags.

    • Month-9 Evaluation: Add interactive form validation and a dynamic price/EMI calculator to the Month-8 website.

Month 10: Programming Fundamentals with C / C++ (Weeks 37–40)

Goal: Develop strong algorithmic thinking, memory awareness, and structured programming logic.

  • Week 37: Logic Building, Flowcharts & C Basics

    • Algorithms, flowcharts, compiler setup, variables, data types, input/output (printf/scanf), and operators.

  • Week 38: Control Structures & Loops

    • Decision making (if-else, nested if, switch) and loops (for, while, do-while) with pattern and number programs.

  • Week 39: Arrays, Strings & Functions

    • 1D/2D arrays, matrix operations, string handling functions, user-defined functions, and recursion basics.

  • Week 40: Introduction to OOP (C++) & Month-10 Assessment

    • Classes, objects, constructors, encapsulation, and basic inheritance concepts in C++.

    • Month-10 Evaluation: Solve 5 timed programming problems covering loops, arrays, and functions.

Month 11: Python Programming & Modern AI Productivity (Weeks 41–44)

Goal: Write clean, practical Python scripts and leverage modern AI tools for workplace efficiency.

  • Week 41: Python Syntax & Data Structures

    • Python installation, variables, strings, Lists, Tuples, Sets, and Dictionaries.

  • Week 42: Control Flow, Functions & File Handling

    • Loops, comprehensions, modular functions, exception handling (try-except), and reading/writing CSV/text files.

  • Week 43: Practical Python Automation

    • Automating file organization, basic Excel/CSV report generation, and mini CLI utility scripts.

  • Week 44: Modern AI Tools & Digital Safety + Month-11 Assessment

    • Effective prompting for drafting, spreadsheet formula generation, presentation outlines, and cyber security/privacy best practices.

    • Month-11 Evaluation: Build a Python console application (e.g., Library Management or Expense Tracker with CSV storage).

Month 12: Capstone Project, Career Readiness & Final Certification (Weeks 45–48)

Goal: Integrate all learned skills into a complete real-world project and prepare for office/IT job placements.

  • Week 45: Resume Building & Workplace Communication

    • Drafting an ATS-friendly technical resume, LinkedIn profile setup, email etiquette, and mock HR/technical interviews.

  • Week 46–47: Final Integrated Capstone Project

    • Students build and document a complete end-to-end project combining:

      1. A responsive website (HTML/CSS/JS) for a business,

      2. A database or Python billing/management tool, and

      3. A complete Tally GST accounting & Excel financial report for the same business.

  • Week 48: Final Viva, Practical Examination & Certification

    • Final Diploma Examination: Comprehensive practical lab exam (Semester I & II), project presentation, and viva voce for final DCA certification.

Top