Diploma in Computer Application
Designed to help candidates prepare for the certification exams offered by CTTIC. Focus on the specific requirements and skill sets tested.
The Diploma in Computer Applications (DCA) is a one-year comprehensive government approved program designed to provide foundational and practical knowledge in computer applications. This course covers essential computer concepts, operating systems, system engineering, and programming languages, ensuring students develop strong technical skills. Intensive lab sessions complement theoretical lessons, allowing students to gain hands-on experience in programming and software applications.
Duration: 720 Hours (1 Year)
Eligibility: 10th Standard Pass & Above
Why is This Course Important?
In today’s digital era, basic computer literacy and technical skills are essential in almost every industry. The DCA program offers a solid foundation in computer operations, programming, and software applications, preparing students for various IT and office-based roles. It bridges the gap between basic computer knowledge and professional IT skills, making it highly valuable for individuals seeking entry-level positions or enhancing their current skills.
Benefits of the DCA Course
- Foundation in IT Skills: Gain essential knowledge of computer systems, programming, and database management.
- Hands-on Experience: Practical lab sessions help in implementing theoretical concepts.
- Job Readiness: Prepares students for entry-level IT roles and office-based positions.
- Career Flexibility: Opens up multiple career paths in various sectors.
- Skill Development: Improves problem-solving, technical, and software handling skills.
What Will You Learn from This Course?
- Basic to Advanced Computer Skills covering operating systems and office tools.
- Programming Knowledge in Python, C++, Java, and Visual Basic.Net.
- Database Management through RDBMS and SQL.
- Software Application Proficiency in Office Suite and system engineering concepts.
- Project Development skills through hands-on project work.
Who Will Benefit Most from This Course?
- Students who have completed 10th standard and want to pursue a career in IT.
- Job Seekers aiming for entry-level positions in IT and administrative roles.
- Office Staff looking to improve their computer proficiency.
- Entrepreneurs and small business owners wanting to handle basic IT operations independently.
- Professionals seeking to upgrade their technical skills for career advancement.
- Computer Fundamentals - Introduction
- Functional Organization of Computer
- Hardware & Software
- Network & Data Communication
- Number Systems
- Hardware & software requirement for internet
- Internet services
- Types of personal computers
- Algorithm and Flow chart
- Windows OS - Introduction, Versions and Elements of Windows Screen
- MS-DOS Part 1 - Booting Process, Commands and File Types
- MS-DOS Part 2- Batch Files and External DOS Commands
- Linux OS - Introduction to Linux
- Linux OS - Commands
- Linux OS - Utilities
- Object oriented Programming Languages
- principles of oops
- Over view of C++
- Tokens
- Example for C++ Sample Programming
- Variables, Data Types and Operators
- Arrays in C++
- Example for Arrays in C++
- pointers
- Strings
- Other Data Types
- Functions
- Classes and Objects
- Constructors and Destructors
- Inheritance and Polymorphism
- Managing Console I/O Operations and Working With files
- Exception Handling
- IF AND OR and SUM if , COUNT IF
- Pivot and Vlookup
- Sort and Formatting
- Powerful Data Analysis
- Charts
- Introduction to .NET
- VB.NET Basics Part1
- VB.NET Basics Part 2
- Windows Forms and Common Controls
- Containers
- Menu & Toolbars
- Data, Components and Printing
- Dialogs
- Crystal Reports
- Sub Procedures, Functions n User Control
- Class and modules
- Sample Exercise using complete Structures with MS SQL Database
- Introduction to DBMS
- Entity and relational Data models
- Relational Data Models
- Database Normalization
- Relational Algebra and Relational Calculus
- Backup and Recovery
- Database Security and Integrity
- Design and Development of Database Applications on CRDBMS
- A brief Introduction to Mongo DB (NOSQL DB)
- Introduction to System Engineering
- Systems documentation consideration
- System Planning
- Input/output
- System Implementation and Maintenance
- Introduction to Management Information System (MIS)
- Introduction to Python
- Python Data Types and Data structures
- Flow Control, Functions and Modules
- File Handling and Regular Expressions
- Object Oriented programming and Exception handling
- Towards Data Science
- Introduction to Java
- Overview of Java language
- Constants, Variables and Data Types
- Operators and Expression
- Decision making and branching
- Classes, Objects and methods
- Arrays, Strings and Vectors
- Inheritance and Interfaces
- Packages in Java
- Managing errors and exceptions
- Multithreaded programming
- Java APIs
- Network Programming in Java
- Introduction to SQL
- SQL Commands
- Views and Indexes
- Sub queries
- Joins, Unions, Intersection, Minus
- Unions
- Cursors in SQL
- Embedded SQL
- Stored procedures
- Functions in SQL
- Practical Exercises for SQL
- INTRODUCTIONS TO MS WORD
- INSERT TABLE
- INSERT SHAPES
- PICTURES AND LINK
- Header and Footer, Smart Art, Drop Cap, Book Mark
- Page design
- Layout and View
- Mail merge
- Introduction Table and Data type
- Lookup Wizard and Filter
- Query
- Form and Report
- Introduction to Powerpoint
- Shapes, Image and 3D
- Table, Chart and Link
- Create a Presentation
- How to use 3D model and Shapes
- Introduction
- Text functions
- Mathematical functions
- Logical functions
- what is the table and features
- Logical function problems
- chart
- Goal seek and Pivot Table
- V Lookup
Lorem ipsum is simply dummy text of the printing typesetting industry. Lorem ipsum has been the industry's standard.
4.9
2,488 Reviews
Herman miller
Lorem ipsum dolor sit sed do eiusmod tempor incididunt labore enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate.
Wilbur haddock
Lorem ipsum dolor sit sed do eiusmod tempor incididunt labore enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate.
Colene landin
Lorem ipsum dolor sit sed do eiusmod tempor incididunt labore enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate.