Build Advanced Computer Application Skills
The Advanced Diploma in Computer Application (ADCA) with AI is a structured, job-oriented program designed to develop practical computer application skills from fundamentals through web technologies, programming and database concepts, including Java and JDBC.
The course covers computer fundamentals, Microsoft Windows, MS Word, MS Excel, Microsoft PowerPoint, Internet & E-Mail, HTML, CSS, JavaScript, Python, Tkinter and MySQL.
Key Highlights
Computer Fundamentals
Learn computer features, input and output devices, CPU, memory, hardware, software and operating system fundamentals.
Microsoft Office Skills
Develop practical skills in Word, Excel and PowerPoint including documents, worksheets, formulas, charts and presentations.
Web Development Basics
Learn HTML and CSS fundamentals together with JavaScript basics, forms, layouts, validation and browser-based concepts.
JavaScript & Programming
Cover JavaScript variables, data types, operators, statements, functions, objects, arrays, validation, OOPs, BOM and DOM.
Python & Tkinter
Learn Python features, data types, control statements, collections, OOPs and Tkinter GUI components.
MySQL & Database Skills
Understand MySQL databases, tables, views, queries, clauses, conditions, joins, indexes, users, privileges and functions.
Course Overview
This 12-month offline program provides 205 hours of training and combines computer applications, office productivity, web technologies, programming and database skills in one structured learning path.
Program Curriculum
The curriculum is based on the supplied ADCA brochure and is grouped into clear modules while retaining the brochure's subject areas and topics.
Module 1Computer Fundamentals & Windowsโ
- Introduction to Computer
- Features of Computers
- Input devices and output devices
- CPU, memory, hardware, software and operating system
- Introduction to Windows and its components
- System clock and calendar
- Creating, renaming and restoring folders or files on desktop
- Windows Explorer, cut, copy and paste files and folders
- Setting mouse and keyboard properties through Control Panel
Module 2Microsoft Wordโ
- Introduction to MS Word and starting MS Word
- Document window and its components
- Typing on a page
- Page setup, print preview, print, close and exit
- Undo, redo, cut, copy, paste, select all, find and replace
- Formatting text including font, font size, colour, bold, italic and underline
- Document views, toolbars, ruler and page break
- Header, footer, page number, date and time, auto text
- Symbols, pictures, clip art, WordArt, bookmark and objects
- Background, change case, themes, spelling and grammar check, language and word count
Module 3Microsoft Excelโ
- Introduction to MS Excel and its components
- Creating series and entering records
- Inserting rows, columns and cells
- Worksheet and worksheet renaming
- Formulas and cell formatting
- Charts and drawing objects
- Row and column formatting
- Hide and unhide rows, columns and sheets
Module 4Internet & E-Mailโ
- Introduction to the Internet
- Services on the Internet
- Surfing on the net
- Creating an e-mail account
- Sending and receiving e-mails and attachments
Module 5Microsoft PowerPointโ
- Background, custom animation, slide transition and custom show
- Introduction to MS PowerPoint
- Starting PowerPoint and its components
- Creating slides and inserting new slides
- Inserting different objects into slides
- Duplicate object and duplicate slide
- Run slide show and Slide Sorter
Module 6HTMLโ
- What is HTML and introduction to HTML
- HTML tags, formatting, heading, paragraph and anchor
- HTML ordered list, unordered list and description list
- HTML filepath, head, layout and responsive concepts
- Emojis and entities
- HTML form, div, id/class, media, frame/iframe and JavaScript
- HTML image, table, symbol, charset and URL encode
Module 7CSS Overview & Propertiesโ
- Introduction to CSS
- CSS syntax and selectors
- How to add CSS
- Inline, internal and external CSS with comments
- CSS background, border, display, float, font and line height
- CSS margin, opacity, overflow, padding and position
- CSS vertical align, white space, width and word wrap
- CSS outline, visibility, counter, hover and box-shadow
- CSS text-transform, lists/menu, nth selector, navigation bar and descendant selector
Module 8CSS Advancedโ
- CSS animation and transition
- CSS buttons and multiple columns
- CSS pagination and forms
- CSS website layout
Module 9JavaScript Tutorial & Basicsโ
- JavaScript introduction and examples
- External JavaScript
- JavaScript global variable
- JavaScript data types and operators
- JavaScript if statement
- JavaScript switch, loop and function
- JavaScript object and array
- JavaScript string and date
- JavaScript Math, Number and Boolean
Module 10JavaScript Functions & Validationโ
- Function definitions and parameters
- Function invocation and call
- Function apply
- JavaScript form validation and e-mail validation
Module 11JavaScript OOPsโ
- JavaScript class and object
- JavaScript prototype and constructor method
- JavaScript static methods
- JavaScript encapsulation and inheritance
- JavaScript polymorphism and abstraction
Module 12JS Exception Handling, Cookies & Eventโ
- JavaScript exception handling and try-catch
- JavaScript cookies and cookie attributes
- Cookie with multiple names
- JavaScript polymorphism and abstraction
- JavaScript addEventListener() and onclick event
Module 13JavaScript BOM & DOMโ
- JavaScript browser objects
- JavaScript Window object
- JavaScript History object
- JavaScript Navigator and Screen object
- JavaScript Document Object and getElementById
- JavaScript getElementsByName() and getElementsByTagName()
- JavaScript innerHTML and innerText property
Module 14Python Programmingโ
- Python features, history and applications
- Python installation and print function
- Text, numeric, sequence, mapping, set, Boolean and binary data types
- If-else, while loop and for loop statements
- Switch case statements
- Break and continue statements
- Collections including lists, arrays, tuples, sets and dictionary
Module 15Python OOPs & Tkinter GUIโ
- Classes and objects
- Inheritance
- Polymorphism
- Encapsulation
- Abstraction
- Tkinter Button, Canvas and Checkbutton
- Tkinter Entry, Frame and Label
- Tkinter Listbox, Menubutton and Menu
- Tkinter Message, Scrollbar and Scale
- Tkinter Spinbox, PanedWindow and LabelFrame
Module 16Python MySQLโ
- MySQL environment setup
- Database connection
- Creating new database
- Creating tables
- Insert, read and update operation
- Performing transactions
Module 17MySQL Databaseโ
- DBMS and RDBMS concepts
- MySQL history and features
- MySQL data types and connection
- Create database
- Select database
- Drop database
- Show database
Module 18MySQL Tables, Queries & Clausesโ
- Tables and views
- CREATE, ALTER and SHOW TABLE
- RENAME, DESCRIBE and TRUNCATE TABLE
- DROP, temporary and copy table
- Add, delete, show and rename column
- MySQL queries
- INSERT, UPDATE, DELETE and SELECT record
- MySQL WHERE, DISTINCT, FROM and ORDER BY
- MySQL GROUP BY and HAVING
Module 19MySQL Conditions, Keys & Joinsโ
- MySQL AND & OR
- MySQL AND OR & LIKE
- MySQL IN & NOT
- MySQL IS NULL & IS NOT NULL
- MySQL BETWEEN
- Primary, Unique, Foreign and Default key
- MySQL JOIN and INNER JOIN
- MySQL LEFT JOIN and RIGHT JOIN
- MySQL CROSS JOIN and SELF JOIN
- MySQL NATURAL JOIN
Module 20MySQL Indexes, User Management & Functionsโ
- Create, show, unique and drop index
- MySQL create user
- MySQL drop user
- MySQL show users
- Change user password
- MySQL grant privilege and revoke privilege
- MySQL IF() and IFNULL()
- MySQL NULLIF() and CASE
- MySQL count() and sum()
- MySQL avg(), min() and max()
Module 21MySQL Date Functions & Viewsโ
- NOW()
- CURDATE()
- CURTIME()
- YEAR()
- MONTH()
- DAY()
- DATEDIFF()
- DATE_FORMAT()
- What is a View?
- CREATE VIEW
- ALTER VIEW
- DROP VIEW
- Updatable views
- Advantages of views
Module 22Core Java Programmingโ
- Overview and what is Java?
- History and features of Java
- C++ vs Java
- Java variables and data types
- Keywords and operators
- If and if-else statement
- Switch case statement
- For loop and while loop statement
- Do-while loop and comments
- Continue and break statement
- Abstract class, interface and package
- Access modifiers and encapsulation
- One Dimensional Array and Two Dimensional Array
- String functions
- Java exception, try-catch, multiple catch and nested try
- Java Throw and Throws keyword
Module 23Java OOPs & Inheritanceโ
- Java OOPs concepts
- Naming convention
- Object and Class
- Constructor and Destructor
- Method, static keyword and this keyword
- Java Inheritance and Polymorphism
- Inheritance and Aggregation
- Overloading and Overriding
- Super and final keyword
- Runtime Polymorphism and Dynamic Binding
Module 24Java I/O, Collections & Networkingโ
- File Output Stream
- File Input Stream
- Buffered reader
- Buffered writer
- Random access file
- Java ArrayList
- Java LinkedList
- Java List Interface
- Java Stack
- Java Collection and Iterator Interface
- Networking Concepts
- Socket Programming
- DateFormat and SimpleDateFormat
- Get Current Date Time
Module 25Java AWT, Swing & Appletโ
- AWT Basics, AWT Button, Label, TextField and Checkbox
- Applet Basic, Graphics in Applet and JApplet class
- Painting in Applet
- Event handling in Applet
- Java ActionListener, MouseListener and KeyListener
Module 26Java LayoutManager & JDBCโ
- BorderLayout, GridBagLayout and FlowLayout
- CardLayout and GridBagLayout
- Basic RDBMS Concept and Introduction
- JDBC Driver and DB Connectivity Steps
- Connectivity with MySQL
Tools & Technologies You'll Learn
The supplied ADCA brochure highlights the core tools and technologies included in the program, covering office applications, web technologies, programming and databases.
Career-Ready Applications
The ADCA curriculum combines computer applications, office productivity, web development, programming and database skills to support practical, job-oriented learning.
Computer Applications
Build practical skills across computer fundamentals, Windows and everyday computer operations.
Office Productivity
Work with Word, Excel and PowerPoint for documents, spreadsheets and presentations.
Web Development
Learn HTML, CSS and JavaScript fundamentals for web pages, forms, layouts and scripting.
JavaScript Skills
Develop skills in functions, validation, objects, OOPs, exceptions, events, BOM and DOM.
Python & MySQL
Learn Python programming, Tkinter GUI and database connectivity with MySQL.
Database Skills
Work with MySQL databases, tables, queries, clauses, joins, indexes, users, privileges, date functions and views.
Learning & Career Support
Structured Learning
A progressive curriculum moves from computer fundamentals and office applications to web, programming and databases.
Offline Training
The brochure specifies offline as the mode of training for the ADCA program.
Industry-Relevant Curriculum
The program covers computer applications, web technologies, programming and database topics.
Practical Skills
The curriculum includes hands-on application areas such as document work, spreadsheets, presentations, web and programming topics.
Experienced Trainers
NIPSTec highlights qualified and experienced trainers as part of its training offering.
PAN India Reach
The brochure highlights NIPSTec's PAN India reach and training across students and corporates.
Why Choose NIPSTec
The supplied ADCA brochure highlights NIPSTec's 25+ years of experience, qualified and experienced trainers, job-oriented programs, industry-relevant curriculum, PAN India reach and trust across corporates, PSUs, government and private sector.
25+ Years of Experience
Training experience with students and corporates.
Qualified & Experienced Trainers
Trainer quality is highlighted as a core part of NIPSTec's offering.
Industry-Relevant Curriculum
The ADCA brochure covers computer applications, web technologies, programming and database skills.
Job-Oriented Programs
NIPSTec presents ADCA as a job-oriented program focused on practical skills and career development.
PAN India Reach
The brochure highlights NIPSTec's PAN India reach.
Trusted by Multiple Sectors
The brochure states that NIPSTec is trusted by corporates, PSUs, government and the private sector.
Enquire About the ADCA with AI Course
Interested in the ADCA with AI program? Submit your details to get course information, batch guidance and admission assistance.
Interested in ADCA with AI?
Share your details โ our counsellor will call you within 24 hours.
ADCA with AI Course FAQs
Common questions about the ADCA program
What is the ADCA with AI course?
It is the Advanced Diploma in Computer Application (ADCA) with AI, covering computer fundamentals, Microsoft Office, Internet & E-Mail, HTML, CSS, JavaScript, Python, Tkinter, MySQL and Java.
How long is the ADCA program?
The supplied brochure lists a duration of 12 months and 205 hours.
Is the ADCA course available in offline mode?
Yes. The brochure lists the mode of training as Offline.
What computer application topics are covered?
The curriculum includes computer fundamentals, Windows, Microsoft Word, Excel, PowerPoint and Internet & E-Mail.
Does the course include web development?
Yes. The brochure covers HTML, CSS and JavaScript, including forms, validation, OOPs, exceptions, cookies, events, BOM and DOM.
Is Python included in the ADCA curriculum?
Yes. Python topics include features, data types, control statements, collections, OOPs and Tkinter GUI.
Does the course cover MySQL and SQL queries?
Yes. The brochure includes MySQL databases, tables, views, INSERT, UPDATE, DELETE, SELECT, clauses, conditions, keys, joins, indexes, users, privileges, date functions and MySQL functions.
What will I learn in Microsoft Office?
The brochure covers MS Word, MS Excel and Microsoft PowerPoint, including documents, formatting, worksheets, formulas, charts, slides, objects and slide shows.
Which web technologies are included?
The curriculum includes HTML, CSS and JavaScript with topics such as responsive layouts, forms, validation, animation, transitions, objects, functions, events, BOM and DOM.
Which tools and technologies are included?
The brochure curriculum includes Microsoft Word, Excel, PowerPoint, Windows, HTML, CSS, JavaScript, Python, MySQL and Java-related technologies including JDBC.
Does the ADCA brochure include Java?
Yes. The brochure includes Core Java, OOPs, inheritance, polymorphism, abstraction, encapsulation, arrays, strings, exception handling, I/O, collections, networking, date/time, AWT, Swing, Applet, LayoutManager and JDBC with MySQL.
Where is the training conducted?
The course page is set for NIPSTec's Malviya Nagar, New Delhi location, with the brochure listing offline mode of training.
Who is the ADCA program designed for?
The brochure presents ADCA as a job-oriented program designed to develop practical computer application skills across office applications, web technologies, programming and databases.