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.
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).
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.
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).
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.
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.
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.
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.
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.
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.
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).
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:
A responsive website (HTML/CSS/JS) for a business,
A database or Python billing/management tool, and
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.
Call us at:
+91-9779600740, 9855474016