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 ( BASIC TO ADVANCE )
( VOLUME -1 )
- 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
( Volume II )
- Inventory – (Stock of Goods)
- Security Deposit
- Purchase of Fixed Assets with GST
- Managing Inventory
- Stock Groups
- Stock Categories
- Multiple Godowns
- Units of Measure
- Stock Items
- Ledger Creation – Purchase, Sales and GST
- Entering Vouchers with Inventory
- Purchase Voucher
- Sales Voucher
- Credit Note for Return Inward
- Debit Note for Return Outward
- Invoicing
- Create Voucher Type – Retail Sales
- 5 Methods of Voucher Numbering
- Create Voucher Type – Cash Memo
- Creating Invoice with Company Logo
- Invoicing with Multiple Address
- E-Way Bill
- GST on Services
- Batch Wise Details
- Different Actual & Billed Quantities
- Zero Valued Entries
- Additional Cost of Purchase
- Use Discount Column in Invoices
- Multiple Price Levels & Price Lists
- Point of Sale (POS)
- Bill-Wise Details
- Interest Calculation
- Voucher Class for Automatic Interest Figures Pickup in Credit/Debit Note
- Cost Centres and Cost Categories
- Cheque Printing
- Payment of Insurance Premium with GST (Claiming ITC)
- Order Processing
- Purchase Order
- Receipt Note
- Viewing Reports of Purchase Bills Pending
- Rejection Out
- Purchase Voucher
- Stock Transfer (Stock Journal)
- Sales Order
- Delivery Note
- Viewing Reports of Sales Bills Pending
- Rejection In
- Sales Voucher
- Credit Note for Scheme Discount with GST
- Interstate Transactions
- Finalisation of Accounts
- Depreciation
- Outstanding Expenses
- Prepaid Expenses
- GST Reports – Form GSTR-3B, GSTR-1 and GSTR-2
- Generating and Printing Reports
- Financial Statements
- Balance Sheet
- Profit & Loss A/c
- Trading, Profit & Loss A/c
- Trial Balance
- Stock Summary
- Ratio Analysis
- Books & Registers
- Cash Book
- Bank Book
- Group Summary
- Group Vouchers
- Sales Register
- Purchase Register
- Journal Register
- Credit Note Register
- Debit Note Register
- POS Register
- Day Book
- Range Feature
- Statement of Accounts
- Bills Receivable
- Bills Payable
- Ageing Analysis
- Cost Centre Report
- Statistics
- List of Accounts
- Ledger
- Inventory Books & Register
- Stock Item
- Batch
- Godowns Summary
- Stock Group Summary
- Stock Category Summary
- Sales Orders Book
- Purchase Orders Book
- Delivery Note Register
- Receipt Note Register
- Rejections in Register
- Rejections out Register
- Stock Transfer Journal Register
- Physical Stock Register
- Image 2 (Topics starting from Statement of Inventory):
- Statement of Inventory
- Stock Query
- Stock Movement Analysis
- Stock Ageing Analysis
- Sale Bills Pending
- Purchase Bill Pending
- MIS Reports
- Cash Flow Statement
- Fund Flow Statement
- Exception Reports
- Export and Import of Data
- Export of Data
- Import of Data
- Export to Excel
- Security Control
- Password Policy
- Users and Password
- Security Levels (User Roles)
- Tally Audit
- Tally Vault
- Bill of Material (BOM)
- Creation of Ledgers for Purchases, Sales, GST, Parties and Expenses
- Create Multiple Godowns
- Create Unit of Measure (UOM)
- Create Stock Groups
- Create Stock Items
- Create Stock Items with Alternate Units
- Set Components (BOM)
- Entering Purchase Voucher for Raw Materials
- Entering Stock Journal Voucher for Stock Transfer
- Creating Manufacturing Journal Voucher
- Entering Manufacturing Journal Voucher
- Altering Stock Journal Voucher Using Voucher Class for Material Transfer
- Making Entry in Stock Journal Voucher Using Voucher Class
- Entering Sales Voucher with e-Way Bill information
- Stock Transfer Register
- Cost Estimation
- Tax Deducted at Source (TDS)
- TDS Reports,
- Printing TDS Challan
- Form 26Q
- Form 27Q
- Tally Software Services (TSS), Renew TSS
- Remote Access
( VOLUME -III )
- Tax Collected at Source (TCS)
- TCS Challan
- Form 27EQ
- Payroll
- Enable Payroll and its Features
- Employee Groups
- Employee Master
- Payroll Master
- Payroll Units
- Attendance / Production Type
- Pay Heads – Earning
- Pay Heads – Deduction
- Gratuity
- Salary Details Setup
- Attendance Voucher
- Payroll Voucher
- Generating / Viewing Payroll Reports
- GST Goods and Services Tax
- GST in TallyPrime
- Defining GST at Company Level
- Defining GST at Stock Group Level
- Defining GST at Stock Item Level
- B2B Inter-State Sales
- B2C(Large) Inter-State Sales
- B2C(Small)
- Credit Note
- Zero Rated Goods
- Exports Exempt
- Supply of Services
- GST Returns
- GST Based on Item Value
- Availing of Input GST Credit
- e-Way Bill
- Sales to SEZ
- Composition Scheme
- GSTR-4-Quarterly Return for Composite Dealer
- Reorder Levels
- Reminder Letters
- Confirmation Letters
- Multiple Currencies
- Budget
- Image 2:
- Scenario
- View Optional Voucher Register
- Stock Valuation
- Physical Stock
- Increase and Decrease in stock Value
- Export & Import of Data
- Migrating The Data From Old Versions To Tally Prime
- Self-Assessment
5 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 )
4 CONCEPTS OF INCOME TAX
5 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
6 ARTIFICIAL INTELLIGENCE TOOLS