Course Syllabus
Module 1: Computer Basics
- Introduction to computers and their components.
- Basic computer operations and functions.
Module 2: Microsoft Office 2013
- MS Word 2013:
- Introduction to word processing.
- Creating and formatting documents.
- Working with tables, graphics, and mail merge.
- Proofreading and advanced features.
- MS PowerPoint 2013:
- Creating and delivering effective presentations.
- Using multimedia, animations, and transitions.
- Mastering slide design and customization.
- MS Excel 2013:
- Introduction to spreadsheet software.
- Creating, formatting, and managing worksheets.
- Using formulas, functions, and pivot tables for data analysis.
- Advanced features like macros and data validation.
Module 3: Tally Prime with GST
- Basic Tally Prime with GST:
- Introduction to financial accounting and taxation.
- Tally fundamentals, features, and configuration.
- Accounting for service, trading, and manufacturing organizations.
- Advanced Tally Prime with GST:
- In-depth understanding of GST concepts and compliance.
- Advanced inventory management and pricing strategies.
- GST accounting and inventory reports.
Module 4: Advanced Accounting Concepts
- Non-trading organizations and their accounting.
- Rules of accounts and journal entries.
- Advanced concepts like cost centers, vouchers, and ledgers.
- Bank reconciliation and statutory compliance (TDS, TCS, etc.).
Module 5: MS Excel for Data Analysis
- Module I - Microsoft Excel:
- Introduction to Excel and data entry.
- Basic and advanced formatting techniques.
- Data analysis tools like pivot tables and charts.
- Macros for automation and advanced features.
- Module II - Functions and Formulas in Excel:
- Working with formulas and functions.
- Logical, text, financial, date and time functions.
- Lookup and reference functions for data analysis.
Module 6: Business Management with Computers
- Display and reporting for effective decision-making.
- Management control systems, budgeting, and variance analysis.
- System administration and utilities.
- Technical advantages of using computer tools in business management.
Module 7: Internet Usage
- Leveraging the internet for business operations.
- Online tools, resources, and security considerations.
Module 8: Project Work
- Hands-on project work applying concepts learned during the course.
Importance for Learner in Career Growth and Self-Employment:
- Equips students with essential computer skills for various business roles.
- Provides proficiency in Microsoft Office and Tally Prime with GST for job opportunities.
- Enhances employability and entrepreneurial skills.
- Enables students to effectively manage business operations and data using technology.