ADVANCE DIPLOMA IN COMPUTER APPLICATIONS(ADCA) ( M-ADCA-Q0021 )

Syllabus

Fundamentals of Computers & Operating Systems: Introduction to Computers (History, Generations, Types), Hardware & Software Components, Input & Output Devices, Number Systems & Data Representation, Types of Operating Systems (Windows, Linux), File & Folder Management.

Microsoft Office & Productivity Tools: MS Word: Document Creation, Formatting, Templates, MS Excel: Formulas, Charts, Pivot Tables, Macros, MS PowerPoint: Slide Design, Animations, Presentations, MS Access: Database Creation, Tables, Queries, Forms, MS Outlook & Email Management.

Internet & Web Technology: Basics of Internet & Web Browsing, Search Engines & Online Research, Email, Cloud Storage, Google Drive, Social Media & Digital Communication, Cybersecurity & Safe Internet Practices.

Database Management System (DBMS): Introduction to Database Management Systems, Database Architecture & Components, Relational Database Management System (RDBMS), Structured Query Language (SQL), Database Normalization, Database Security & Backup.

Web Designing & Development: HTML & CSS: Basics of Web Design, JavaScript: Interactivity & DOM Manipulation, PHP & MySQL: Dynamic Web Pages, WordPress & CMS Basics, Hosting & Domain Management.

Computer Networks & Security: Network Models: OSI & TCP/IP, LAN, WAN, MAN, Internet Protocols (IPv4, IPv6), Network Devices: Routers, Switches, Firewalls, Network Security & Cryptography, Cyber Threats & Prevention Strategies.

10th Grade (high school) or Equivalent