Advance Diploma in Computer Application Course

COURSE CURRICULUM FOR “ADCA”

Module 1: Introduction to Computers

1. Computer Fundamentals
   1. Definition and types of computers (Analog, Digital, Hybrid)
   2. Components of a computer system (Hardware and Software)
   3. Types of software: System software, Application software
   4. Overview of Operating Systems (Windows, macOS, Linux)
   5. Input and Output devices
2. Computer Memory and Storage
   1. Primary and secondary memory
   2. RAM, ROM, Cache memory
   3. Storage devices: Hard Disk, SSD, CD/DVD, USB drives
   4. Data representation: Binary, Decimal, Hexadecimal systems

Module 2: Operating System (Windows)

1. Windows Operating System Overview
   1. Introduction to Windows environment
   2. Desktop, Start menu, Taskbar, and Control Panel
   3. File Explorer: Managing files and folders
   4. Creating, renaming, and deleting files and folders
2. Advanced Windows Features
   1. Managing system resources: Task Manager
   2. Setting up user accounts and permissions
   3. Windows utilities (Disk Cleanup, Defragmentation, Backup)
   4. System customization (Appearance, themes, screen savers)
3. File Management and System Security
   1. File extensions, file properties, and file formats
   2. Working with compressed files (ZIP)
   3. Antivirus and firewall configuration
   4. Managing system restore points and backups

Module 3: Word Processing (MS Word)

1. Introduction to MS Word
   1. MS Word interface: Ribbon, Quick Access Toolbar
   2. Creating and saving documents
   3. Formatting text: Font styles, sizes, and colors
   4. Paragraph formatting: Alignment, line spacing, indentation
2. Advanced Word Processing
   1. Using styles, templates, and themes
   2. Inserting tables, images, shapes, and smart art
   3. Headers, footers, and page numbers
   4. Spell check, grammar check, and AutoCorrect options
3. Document Formatting and Review Tools
   1. Creating and formatting bullet lists and numbered lists
   2. Tracking changes, comments, and document comparison
   3. Printing and page setup options
   4. Mail merge for letters, labels, and envelopes

Module 4: Spreadsheet Management (MS Excel)

1. Introduction to MS Excel
   1. Excel interface: Workbook, Worksheet, Ribbon
   2. Entering, editing, and formatting data in cells
   3. Basic calculations: SUM, AVERAGE, MIN, MAX
   4. Cell referencing: Relative, Absolute, and Mixed references
2. Advanced Excel Techniques
   1. Sorting, filtering, and conditional formatting
   2. Working with large datasets: Freeze Panes, Grouping
   3. Functions: VLOOKUP, HLOOKUP, IF, COUNTIF, SUMIF
   4. Data validation and drop-down lists
3. Charts and Graphs
   1. Creating various charts (Column, Line, Pie, Bar)
   2. Customizing chart styles, titles, and labels
   3. Using Sparklines to represent trends
   4. Printing and page setup options

Module 5: Presentation Software (MS PowerPoint)

1. Introduction to MS PowerPoint
   1. PowerPoint interface: Ribbon, Slides, and Design views
   2. Creating presentations and slide layouts
   3. Inserting text, images, and multimedia objects
   4. Working with templates and themes
2. Advanced Presentation Techniques
   1. Creating and formatting tables, charts, and diagrams
   2. Using transitions and animations
   3. Adding hyperlinks, action buttons, and interactivity
   4. Preparing presentations for print and presentation mode
3. Slide Show Management
   1. Custom slide shows and slide timings
   2. Presenter view and speaker notes
   3. Exporting presentations to different formats (PDF, Video)

Module 6: Database Management (MS Access)

1. Introduction to Databases
   1. Database concepts: Tables, Fields, Records, Keys
   2. Relational databases and normalization
   3. Overview of MS Access and its interface
   4. Creating a database, tables, and relationships
2. Querying and Reporting in MS Access
   1. Creating simple queries (Select, Update, Delete)
   2. Using criteria in queries and wildcard characters
   3. Designing forms for data entry and viewing
   4. Creating reports for printing and distribution
3. Advanced MS Access Techniques
   1. Setting up primary and foreign keys
   2. Data validation and lookup fields
   3. Importing data from Excel and external sources
   4. Creating macros for automation

Module 7: Internet and Web Technologies

1. Computer Networks
   1. Overview of Computer Networks
   2. Types of networks (LAN, WAN, MAN, etc.)
   3. Internet basics and networking devices (Router, Switch, Hub)
   4. Introduction to Internet Protocol (IP), DNS, and Subnetting
2. Introduction to the Internet
   1. Basics of the Internet, WWW, Web browsers (Chrome, Firefox, etc.)
   2. Search engines and online research
   3. Email concepts, creating and sending emails
   4. Using cloud storage (Google Drive, OneDrive, etc.)
   5. Understanding HTML, CSS, and basic web page structure
   6. Introduction to web browsers and browser settings
   7. Downloading, uploading, and sharing files online

Module 8: Social Media Platforms

1. Introduction to Social Media
   1. The Evolution of Social Media
   2. The Impact of Social Media on Society and Business
   3. Overview of Major Platforms (Facebook, Instagram, Twitter, LinkedIn, TikTok, etc.)
2. Understanding Social Media Platforms
   1. Deep Dive into Facebook: Features, Ads, and Strategies
   2. Instagram Essentials: Visual Storytelling & Growth Hacks
   3. Twitter Tactics: Engagement, Trends, and Twitter Spaces
   4. LinkedIn for Professionals: Networking and B2B Marketing

Module 9: Digital Financial Tools and Applications

1. Introduction to Digital Finance
   1. The Evolution of Financial Technology
   2. Key Concepts in Digital Finance
   3. Benefits and Risks of Digital Financial Tools
2. Digital Banking and Payment Solution
   1. Online Banking vs. Traditional Banking
   2. Digital Wallets and Mobile Payments (PayPal, Phonepe, Paytm, Google Pay)
   3. Contactless Payments & Security Considerations

Module 10: Soft Skills and Office Automation

1. Email and Communication Skills
   1. Creating professional emails
   2. Email etiquette, managing attachments, and signatures
   3. Using Microsoft Outlook or Google Mail for communication
2. Office Automation Tools
   1. Scheduling and calendar management
   2. Task management tools (To-do lists, Google Keep, etc.)
   3. Creating documents, presentations, and spreadsheets on the cloud
3. Soft Skills for Professional Growth
   1. Time management, teamwork, and problem-solving
   2. Communication and interpersonal skills
   3. Developing a professional mindset for the workplace

Module 11: Accounting with Tally Prime

1. Accounting Basics
   1. Introduction to Accounting
   2. Types of Accounting
   3. Understanding Accounting Principles
   4. Accounting Modes
   5. Accounting Rules
   6. Double Entry System of Bookkeeping
   7. Creating and Managing Chart of accounts
   8. Creating Accounting Vouchers
   9. Managing Contra, Journal, & Credit Note
2.  Tally Prime Fundamentals
   1. Company Features
   2. Configuration of Tally
   3. Getting Functions with Tally Prime
   4. Creating and Configuring a company in Tally
   5. Setting Up a Company’s Financial Year
   6. Tally Vault
3.  Accounting Masters in Tally Prime
   1. Understanding Chart of Groups
   2. What are Groups?
   3. Multiple Groups
   4. Understanding Ledgers
   5. How to Create & Manage Chart of Accounts?
   6. Creation of Account Vouchers
4. Inventory Management In Tally Prime
   1. Understanding Stock Groups
   2. Multiple Stock Groups
   3. Understanding Stock Categories
   4. Multiple Stock Categories
   5. Measure Units
   6. Stock Items
5. Vouchers Entries
   1. Introduction to Voucher Entry
   2. Types of Vouchers
   3. Chart of Vouchers
   4. Understanding Accounting Vouchers
   5. Understanding Inventory Vouchers
   6. Invoicing

Module 12: Programming Basics (Additional)

1. Introduction to Programming Concepts
   1. What is programming? Overview of programming languages
   2. Basic concepts: Variables, operators, and data types
   3. Flow control: Conditions and loops (if-else, for, while)
   4. Functions and procedures
2. Introduction to a Programming Language (e.g., C or Python)
   1. Writing simple programs: Input, processing, and output
   2. Basic data structures: Arrays, lists, strings
   3. Introduction to debugging and testing code

Module 13: Basic IT Skills and Office Automation (Additional)

1. Using Basic IT Tools
   1. Installing and using software applications
   2. Using PDF readers and PDF creation tools (Adobe Acrobat Reader)
   3. Data backup and restoration processes
   4. Basic troubleshooting and maintenance of computer systems
2. Automation Tools for Office Work
   1. Creating automated reports in MS Excel using templates and formulas
   2. Setting up calendar events and reminders
   3. Using collaborative tools like Google Docs, Google Sheets for real-time document sharing and editing
   4. Managing tasks and schedules using Microsoft Outlook or Google Calendar

Module 14: Project and Evaluation

1. Practical Project
   1. Apply all learned skills to a real-world project (Database creation, report generation, office automation)
2. Assessment
   1. Written exams and practical assessments
   2. Project evaluation and presentation
3. Certification and Conclusion
   1. Course completion certificate
   2. Feedback and recommendations for further studies