Course Syllabus
1 BASIC :
Module 1: Introduction to Computer
- Basic components:
- Input devices (Keyboard, Mouse, Scanner)
- Output devices (Monitor, Printer, Speaker)
- CPU (ALU, CU)
- Memory:
- Primary (RAM, ROM)
- Secondary (Hard Disk, Pen Drive)
Module 2: Operating System (Windows Basics)
- Basics of Windows OS
- Desktop, Icons, Taskbar
- Start menu and Control Panel
- File and folder management:
- Create, rename, delete
- Copy, move files
- Basic system tools
Module 3: Word Processing (MS Word / LibreOffice Writer)
- Introduction to word processor
- Creating and saving documents
- Editing text
- Formatting:
- Font, paragraph, alignment
- Page setup
- Bullets and numbering
- Tables
- Insert images and shapes
- Printing documents
Module 4: MS Excel
- Introduction to spreadsheet
- Workbook and worksheet
- Data entry and editing
- Formatting cells
- Basic formulas:
- SUM, AVERAGE, MIN, MAX
- Charts (bar, pie, line)
- Sorting and filtering
Module 5: Presentation (MS PowerPoint )
- Introduction to presentation software
- Creating slides
- Slide layouts and themes
- Adding text, images, charts
- Animations and transitions
- Running slide show
Module 6: Internet and Web Browsing
- Introduction to Internet
- Uses of Internet
- Web browsers (like Google Chrome, Mozilla Firefox)
- Opening websites
- Searching information using search engines
- Downloading files
Module 7: Email
- Introduction to Email
- Creating email account
- Sending and receiving emails
- Attachments
- Inbox, Outbox, Drafts
- Email etiquette
2 CCC ( Course on Computer Concepts )
What is CCC?
CCC is a basic computer literacy course conducted by National Institute of Electronics & Information Technology
It is designed to provide basic IT knowledge to common people.
3 TALLY
- Basics of accounting
- features of Tally Prime
- Introduction to Tally Prime
- Creating a Company
- Selecting / shutting / Altering/ Deletion a Company
- Company Creation - Practical
- Setting up Accounts head
- Introduction to goods and services tax ( GST )
- Example of manual accounting for simple trading accounting without GST journal entries
- Altering a Company's features and configuration
- accounting Master Creation
- ledger Alteration / craetion of a single Ledger for practical example
- Viewing opening Trial Balance
- Data entry in tally
- trial balance in tally
- Printing Trial balance in tally
- Statement of sundry creditors and sundry debtors
- Balance sheet
- finalisation of Accounts
- Backup
- Restore
- Split company Data
- Ledger crfeation for A/CS related to GST
- Bill wise details
- Voucher entry with GST
- Printing sales invoice with GST
- Generating & Printing Reports
4 ADVANCE EXCEL:
- Introduction to advance excel
- Excel interface
- File Operations
- Rows, Columns & cells
- Data Entry
- Editing Data
- Cell formatting
- Worksheet management
- Basic formulas
- Basic functions
- Keyboard shortcuts
- Advanced formulas & functions
- Logical & text functions
- Date & Time functions
- Mathematical & statistical functions
- Lookup & Reference Techniques
- Data Validation & protection
- Conditional formatting
- Pivot tables & pivot charts
- Power Query ( get & transform data )
- What - if Analsis tools
- Data analysis tools
- Financial & accounting functions
- Advanced formulas& fuctions
- logical & text fuctions
- Date & Time functions
- Mathematical & Stastical functios
- Stock in and stock out
- income tax sheet ( SLAB )
5 CONCEPTS OF INCOME TAX
6 BUSY( Accounting Software )
1. Basics & Company Setup
- Company Creation and Configuration
- Master Configuration (Account, Item, Material Centre)
- Creating Account Groups and Ledgers
- Creating Item Groups and Item Masters
- Unit of Measure (UOM) Management
2. Inventory Management
- Stock Management (Item-wise & Group-wise)
- Multiple Godowns / Material Centres
- Batch-wise Details (Expiry & Manufacturing Date)
- Serial Number Tracking
- Unit Conversion (Alternative Units)
- Physical Stock Verification
3. GST Management in BUSY
- GST Configuration (Company & Item Level)
- B2B and B2C Invoicing
- GST on Services
- Input Tax Credit (ITC) Adjustment
- GST Returns (GSTR-1, GSTR-3B, GSTR-9)
- E-Way Bill Generation & Integration
4. Voucher Entry & Operations
- Purchase and Sales Vouchers
- Purchase Return (Debit Note) & Sales Return (Credit Note)
- Payment and Receipt Vouchers
- Contra and Journal Entries
- POS (Point of Sale) Billing
5. Advanced Inventory & Manufacturing
- Bill of Material (BOM) & Production
- Stock Transfer & Stock Journal
- Additional Cost of Purchase
- Different Actual & Billed Quantities
- Reorder Levels & Warnings
6. Taxation (TDS & TCS)
- TDS Configuration and Entry
- TDS Reports & Challan Printing
- TCS Management
7. Payroll Management
- Employee Master & Pay Heads
- Attendance / Production Management
- Salary Calculation & Slip Generation
- Payroll Statutory Reports
8. Financial Reports & MIS
- Final Results (Balance Sheet, P&L, Trial Balance)
- Cash Flow & Fund Flow Statements
- Ratio Analysis
- Sales/Purchase Analysis
- Ageing Analysis (Receivable & Payable)
- Broker-wise Reporting
9. Data Management & Security
- Data Backup and Restore
- Export/Import of Data (Excel/XML)
- User Rights & Security Control
- Audit Trail (Activity Log)
- Multiple Currency Management
10. Utilities & Add-ons
- Voucher/Document Printing Design
- SMS & Email Integration
- BNS (BUSY Notification Service)
- Busy Mobile App Synchronization
7 ARTIFICIAL INTELLIGENCE TOOLS