Module 1: Computer Fundamentals

• Introduction to Computer and Its Characteristics
• History and Generations of Computers
• Types of Computers
• Hardware and Software
• Input and Output Devices
• CPU, ALU, CU and Memory Unit
• RAM, ROM, Cache Memory and Secondary Storage
• HDD, SSD, Pen Drive and Memory Card
• Operating System: Windows Basics
• Desktop, Start Menu, Taskbar and Settings
• Files and Folders Management
• Control Panel and System Settings
• Installing and Uninstalling Software
• Keyboard Shortcuts and Typing Practice
• Computer Troubleshooting Basics

Practical: File management, typing practice, Windows settings और basic troubleshooting।

Module 2: English and Hindi Typing

• Keyboard Layout and Finger Position
• Touch Typing Techniques
• English Typing Practice
• Hindi Typing using Unicode
• Hindi Typing Tools and Keyboard Layouts
• Typing Accuracy and Speed Improvement
• Official Letter Typing
• Paragraph and Application Typing
• Data Entry Practice
• Typing Test and Speed Assessment

Practical: English और Hindi में letters, applications और office documents टाइप करना।

Module 3: Internet, Email and Digital Office Skills

• Introduction to Internet and Web Browsers
• Search Engines and Effective Searching
• Creating and Managing Email Accounts
• Sending and Receiving Emails
• CC, BCC, Reply and Forward
• Email Attachments and File Sharing
• Downloading and Uploading Documents
• Google Drive and Cloud Storage Basics
• Online Forms and Data Submission
• PDF Files: Create, Merge and Convert
• Digital Communication Etiquette
• Cyber Security and Online Fraud Awareness
• Password Safety, OTP and Phishing Awareness
• Video Conferencing Basics

Practical: Professional email लिखना, documents attach करना, online forms भरना और files share करना।

Module 4: MS Word — Office Documentation

• Introduction to MS Word Interface
• Creating, Opening, Saving and Printing Documents
• Text Formatting: Font, Size, Color and Styles
• Paragraph Alignment, Indentation and Spacing
• Bullets and Numbering
• Page Setup, Margins and Orientation
• Page and Section Breaks
• Headers, Footers and Page Numbering
• Tables, Pictures, Shapes and SmartArt
• Find and Replace
• Spelling and Grammar Check
• Borders and Shading
• Columns and Watermarks
• Mail Merge: Letters, Labels and Envelopes
• Table of Contents and Document References
• Protecting Documents and Exporting PDF

Practical: Office letters, applications, notices, certificates, resumes, invoices और business reports बनाना।

Module 5: MS Excel — Basic to Advanced

• Workbook, Worksheet, Rows, Columns and Cells
• Data Entry and Data Formatting
• Cell References: Relative, Absolute and Mixed
• Basic Formulas and Operators
• SUM, AVERAGE, MIN, MAX and COUNT
• COUNTA, COUNTBLANK and SUBTOTAL
• IF, IFS, AND, OR and Nested IF
• SUMIF, SUMIFS, COUNTIF and COUNTIFS
• IFERROR and IFNA
• VLOOKUP, HLOOKUP and XLOOKUP
• INDEX and MATCH
• LEFT, RIGHT, MID, LEN, TRIM and CONCAT
• TODAY, NOW, DATE, DATEDIF and Date Formatting
• Sorting, Filtering and Remove Duplicates
• Data Validation and Drop-down Lists
• Conditional Formatting
• Charts and Graphs
• PivotTables and PivotCharts
• What-If Analysis and Goal Seek
• Financial Functions: PMT, IPMT, PPMT and NPER
• Protecting Sheets and Workbooks
• Print Settings and Page Layout
• Excel Templates for Office and Accounts
• Introduction to Macros and VBA Automation

Practical: Salary sheet, attendance sheet, stock register, sales report, expense statement, GST invoice और automated billing workbook।

Module 6: MS PowerPoint — Presentation Management

• Introduction to Presentation Software
• Creating and Saving Presentations
• Themes, Templates and Slide Layouts
• Text, Images, Shapes and Icons
• Tables, Charts and SmartArt
• Slide Master and Consistent Formatting
• Transitions and Animations
• Hyperlinks and Action Buttons
• Audio and Video Insertion
• Presenter View and Slide Show
• Printing Handouts and Exporting PDF
• Professional Business Presentation Design

Practical: Company profile, business proposal, course presentation और monthly performance report बनाना।

Module 7: MS Access — Database Management

• Introduction to Database and DBMS
• Tables, Records and Fields
• Data Types and Field Properties
• Primary Key and Foreign Key
• Creating Relationships Between Tables
• Queries and Query Criteria
• Forms for Data Entry
• Reports and Report Formatting
• Sorting, Filtering and Searching Records
• Importing and Exporting Data
• Database Backup and Basic Security

Practical: Student records, employee database, customer database और inventory records बनाना।

Module 8: Office Management and Administration

• Introduction to Office Management
• Roles and Responsibilities of an Office Manager
• Office Organization and Workflow
• Front Office and Reception Management
• Visitor and Appointment Management
• Telephone and Professional Communication
• Incoming and Outgoing Mail Management
• Letter, Memo, Notice and Circular Drafting
• File Management and Document Classification
• Record Keeping and Office Registers
• Attendance and Leave Registers
• Employee and Customer Record Management
• Meeting Scheduling and Minutes of Meeting
• Travel and Event Arrangement
• Office Inventory and Stationery Management
• Dispatch and Courier Register
• Document Scanning, Printing and Photocopying
• Data Confidentiality and Record Retention
• Office Expense and Petty Cash Register
• Time Management and Workplace Ethics

Practical: Office का daily workflow, reception register, dispatch register, attendance register और document filing system तैयार करना।

Module 9: Business Communication and Employability Skills

• Business English and Professional Vocabulary
• Written and Verbal Communication
• Professional Email Writing
• Telephone Conversation Skills
• Business Letters and Official Applications
• Customer Handling and Complaint Management
• Teamwork and Workplace Behaviour
• Interview Preparation
• Resume and Cover Letter Preparation
• Presentation and Public Speaking
• Time Management and Problem Solving
• Basic Spoken English for Office Work

Module 10: Accounting Fundamentals

• Introduction to Accounting
• Objectives and Importance of Accounting
• Basic Accounting Terminology
• Assets, Liabilities and Capital
• Drawings, Revenue and Expenses
• Debtors and Creditors
• Accounting Equation
• Types of Accounts
• Golden Rules of Accounting
• Debit and Credit Concepts
• Double Entry System
• Journal Entries
• Ledger Posting
• Cash Book and Petty Cash Book
• Purchase Book and Sales Book
• Purchase Return and Sales Return
• Trial Balance
• Trading Account
• Profit and Loss Account
• Balance Sheet
• Depreciation and Adjustments
• Outstanding and Prepaid Expenses
• Accrued Income and Income Received in Advance
• Bad Debts and Provision Basics
• Bank Reconciliation Statement (BRS)
• Financial Year and Accounting Period

Module 11: Tally Prime — Computerized Accounting

• Introduction to Tally Prime
• Installation and Basic Navigation
• Company Creation and Configuration
• Financial Year and Books Beginning Date
• Groups and Ledger Creation
• Accounting Voucher Types
• Contra, Payment and Receipt Entries
• Journal Entries
• Sales and Purchase Entries
• Debit Note and Credit Note
• Cash and Bank Transactions
• Bill-wise Details and Outstanding Reports
• Cost Centres and Cost Categories
• Inventory Masters and Stock Groups
• Stock Items, Units and Godowns
• Purchase and Sales with Inventory
• Order Processing
• Stock Journal and Physical Stock
• Bank Reconciliation
• Credit Limit and Credit Period
• Outstanding Receivables and Payables
• Payroll Basics
• Trial Balance and Profit & Loss Reports
• Balance Sheet and Cash Flow Reports
• Data Backup, Restore and Export
• Security Controls and User Access
• Year-end Adjustments and Closing Books

Practical: एक काल्पनिक business की company बनाकर पूरे financial year के purchase, sales, payment, receipt, stock और final accounts तैयार करना।

Module 12: Practical Projects and Office Internship Simulation

इस module में विद्यार्थियों से वास्तविक office जैसा काम करवाया जाएगा।

1. Office Documentation Project: Official letters, notices, email, reports और filing system।
2. Advanced Excel Project: Salary sheet, attendance, MIS dashboard और automated reports।
3. Accounting Project: Journal से Balance Sheet तक manual accounts।
4. Tally Prime Project: Company creation, vouchers, inventory और financial reports।
5. GST Project: Tax invoice, purchase register, sales register और GST reconciliation।
6. Payroll Project: Employee master, attendance, salary register और payslips।
7. Billing Project: Invoice generation, payment tracking और stock deduction।
8. Final Integrated Project: एक काल्पनिक कंपनी के office records, accounts, inventory और monthly reports तैयार करना।