Course Syllabus
Semester 1: Office Automation & Digital Workplace Skills
This semester focuses on core IT operating principles, computer architectures, and high-level productivity tools.
VedantSri +1
Module 1: Computer Fundamentals & Modern Operating Systems
- System Hardware: CPU architecture, motherboard layout, memory processing unit (RAM/ROM), and primary input/output peripherals.
- System Softwares: Operating systems configuration for Windows 10/11, file management protocols, and command-line structures (MS-DOS/Linux basics).
- Data Systematics: Binary, octal, decimal, and hexadecimal number conversions.
VedantSri +2
Module 2: Advanced Microsoft Office Suite (Workplace Productivity)
- Microsoft Word: Template compilation, multi-level styling, layout margins, document proofs, and advanced Mail Merge operations.
- Microsoft Excel: Data validation arrays, nested logic conditions, conditional charts, VLOOKUP/XLOOKUP, and Pivot Tables.
- Microsoft PowerPoint: Layout transitions, asset animation, voiceover integrations, and interactive slide creation.
VedantSri +2
Module 3: Internet Technologies, Cybersecurity & AI Tools
- Networking Foundations: LAN, WAN, and MAN setups alongside primary data routing mechanisms.
- Cybersecurity Essentials: Malware defense metrics, secure transaction checking, anti-phishing, and handling AI-driven security challenges (e.g., automated social engineering).
- AI Productivity Tools: Utilizing generative AI platforms (e.g., Microsoft Copilot, ChatGPT) for workplace research and text generation.
VedantSri +3
Module 4: Typing & Data Manipulation
- Hands-on professional data input methods, speed building, and dual-language alignment (English and local typing scripts).
🗓️ Semester 2: Professional Accounting, Design & Programming
This semester switches focus to specialized vocational tools required for corporate administrative profiles, creative fields, and basic IT management.
VedantSri +1
Module 5: Financial Accounting (Tally Prime with GST)
- Accounting Foundations: Core double-entry accounting mechanics, company creation paradigms, and ledger controls.
- Voucher Records: Creating sales, purchase, receipt, payment, and inventory management vouchers.
- Taxation Protocols: Real-time calculation and generation of GST (Goods and Services Tax) logs, invoices, and e-way bills.
VedantSri +2
Module 6: Desktop Publishing & Graphic Design (DTP)
- Adobe Photoshop: Image resolution mechanics, layer properties, color corrections, background isolations, and graphic layouts.
- CorelDRAW / Adobe Illustrator: Vector path calculations, business logo drafting, pamphlets, banners, and scalable advertisement design templates.
VedantSri +2
Module 7: Frontend Web Development Basics
- HTML5 & CSS3: Structural tag parameters, styling frameworks, grids, layouts, and page styling rules.
- JavaScript Syntax: Functional trigger scripts, basic variables, page event alerts, and simple form field validation.
VedantSri +2
Module 8: Database Management & Programming Foundations
- Microsoft Access / MySQL: Table relation links, constraints, primary key generation, and relational data architecture.
- SQL Statements: Writing database query statements (
SELECT, JOIN, UPDATE, DELETE). - Core Coding Language: Foundational programming constructs using C Language or Python (covering data types, loops, arrays, and problem-solving concepts).
VedantSri +2
📊 Examination Pattern & Passing Criteria
Evaluation Type
Component BreakdownWeightageTarget FormatWritten TheoryObjective and subjective questions on IT concepts, accounting, and syntax40%Semester-end written papersLab PracticalsLive execution of accounting, sheet management, and code scripting40%Practical assessment in the labCapstone ProjectA combination task: database-linked site, account ledger portfolio, or system program20%Final presentation and viva exam