Advanced Diploma in Computer Application (ADCA)

Definition, characteristics, generations and classification of computers (Theory 4 + Practical 4 hrs)

CPU, memory hierarchy, input-output devices, storage devices (Theory 6 + Practical 6 hrs)

Concepts of OS, Windows and Linux environment, file management, control panel, utilities (Theory 12 + Practical 12 hrs)

Document creation, formatting, tables, mail merge, printing (Theory 5 + Practical 5 hrs)

Worksheets, formulas, functions, charts, data handling (Theory 8 + Practical 8 hrs)

Slides, themes, animation, transitions, slide show delivery (Theory 5 + Practical 5 hrs)

Database concepts, tables, queries, forms and reports (Theory 12 + Practical 12 hrs)

Networking basics, Internet, browsers, e-mail operations (Theory 4 + Practical 4 hrs)

Virus, malware, safe computing practices, data protection (Theory 2 + Practical 2 hrs)

IT applications, e-Governance services, digital India ecosystem (Theory 2 + Practical 2 hrs)

Identification of parts, assembly and disassembly of PC, CMOS setup (Theory 15 + Practical 15 hrs)

Compression tools, disk utilities, CD writing, antivirus tools (Theory 15 + Practical 15 hrs)

Network types, topologies, cabling, IP addressing basics (Theory 15 + Practical 15 hrs)

Setting up and configuring a small LAN, sharing and administration (Theory 15 + Practical 15 hrs)

ICT tools and hardware-networking laboratory with practical record

Practical examination with viva-voce

Evolution of Internet and its working principles (Theory 2 + Practical 2 hrs)

TCP/IP protocol suite, addressing, DNS (Theory 3 + Practical 3 hrs)

Types of connections, ISP, broadband, wireless access (Theory 3 + Practical 3 hrs)

LAN, WAN, network devices used for Internet access (Theory 4 + Practical 4 hrs)

WWW, FTP, chat, video conferencing, cloud services (Theory 4 + Practical 4 hrs)

E-mail working, account management, etiquette, attachments (Theory 7 + Practical 7 hrs)

Social media, e-commerce, OTT, emerging trends (Theory 3 + Practical 3 hrs)

Web servers, hosting, browsers, search engines (Theory 10 + Practical 10 hrs)

HTML tags, lists, tables, forms, images and links (Theory 12 + Practical 12 hrs)

CSS and JavaScript fundamentals for interactive pages (Theory 8 + Practical 8 hrs)

Threats, safe browsing, information privacy, IPR (Theory 4 + Practical 4 hrs)

Program, programming languages and paradigms (Theory 2 + Practical 3 hrs)

Developing algorithms and flowcharts to solve problems (Theory 6 + Practical 9 hrs)

Python installation, IDLE, first programs (Theory 2 + Practical 3 hrs)

Data types, operators, input-output, conditional and loop statements (Theory 10 + Practical 15 hrs)

Strings, Lists, Tuples, Dictionaries and their operations (Theory 6 + Practical 9 hrs)

Built-in and user-defined functions, arguments, recursion (Theory 10 + Practical 15 hrs)

Text and binary files, reading and writing data (Theory 6 + Practical 9 hrs)

Creating and importing modules and packages (Theory 2 + Practical 3 hrs)

NumPy arrays and elementary data handling (Theory 4 + Practical 6 hrs)

SDLC, feasibility study, requirement analysis (Theory 8 + Practical 8 hrs)

DBMS concepts, advantages over file systems (Theory 4 + Practical 4 hrs)

Three-level architecture, data independence (Theory 4 + Practical 4 hrs)

Relational model, keys, constraints (Theory 8 + Practical 8 hrs)

Normal forms 1NF to BCNF with case studies (Theory 8 + Practical 8 hrs)

DDL, DML, joins, views and stored queries (Theory 12 + Practical 12 hrs)

Backup strategies and recovery techniques (Theory 2 + Practical 2 hrs)

Database security, users, privileges (Theory 2 + Practical 2 hrs)

Integrity constraints and enforcement (Theory 2 + Practical 2 hrs)

Mini database application development (Theory 10 + Practical 10 hrs)

LAMP stack setup in Linux environment (Theory 2 + Practical 2 hrs)

PHP syntax, variables, control structures (Theory 4 + Practical 4 hrs)

Working with functions, arrays and objects in PHP (Theory 5 + Practical 5 hrs)

Form handling, GET and POST methods, validation (Theory 2 + Practical 2 hrs)

Client-side scripting and DOM interaction (Theory 5 + Practical 5 hrs)

Database connectivity, CRUD operations from PHP (Theory 5 + Practical 5 hrs)

State management and file handling in PHP (Theory 7 + Practical 7 hrs)

Data interchange using JSON (Theory 5 + Practical 5 hrs)

Common vulnerabilities and secure coding (Theory 4 + Practical 4 hrs)

Optimisation techniques, PEAR, PECL, extensions (Theory 10 + Practical 10 hrs)

Asynchronous requests and dynamic pages (Theory 4 + Practical 4 hrs)

Caching engines and CMS concepts including WordPress (Theory 7 + Practical 7 hrs)

Integrated laboratory work with practical record

Mini project with documentation, demonstration and seminar