Syllabus of Computer Science for grade 12
1. DBMS Concepts
1.1 Introduction to DBMS: Understand the aspects and fundamentals of Database Management Systems (DBMS).
1.2 Advantages of DBMS: Learn the benefits and efficiencies of using a DBMS.
1.3 DDL and DML: Define Data Definition Language (DDL) and Data Manipulation Language (DML) and their uses.
1.4 Database Models: Introduction and application of different database models.
1.5 Normalization: Understand the concept and importance of normalization in databases.
1.6 Centralized vs Distributed Databases: Compare and contrast centralized and distributed databases.
1.7 Database Security: Introduction to database security concepts and practical applications.
2. Concept of Network and Data Communication
2.1 Communication Systems: Describe the basic elements and models of communication systems.
2.2 Data Communication: Understand the elements and modes of data communication.
2.3 LAN and WAN: Define Local Area Network (LAN) and Wide Area Network (WAN) and their applications.
2.4 Transmission Media: Describe different types of transmission media and their uses.
2.5 Transmission Impairments: Define terminologies related to transmission impairments.
2.6 Network Architecture: Introduction to network architecture.
2.7 Network Terms and Tools: Define basic terms and tools used in computer networks.
2.8 Network Devices and Topologies: Understand and use various network devices, tools, and topologies.
2.9 OSI Model and IP Addressing: State the concept of OSI Reference Model and Internet Protocol Addressing.
3. Web Technology II (CSS, JavaScript, PHP)
3.1 Internet Technology: Introduction to internet technology.
3.2 Server-side and Client-side Scripting: Understand and differentiate between server-side and client-side scripting.
3.3 JavaScript Fundamentals: Introduction to JavaScript fundamentals and data types; adding JavaScript to an HTML page.
3.4 JavaScript Variables and Operators: Introduction and use of variables and operators in JavaScript.
3.5 JavaScript Functions and Control Structures: Use functions and control structures in JavaScript.
3.6 Object-Based Programming with JavaScript: Apply object-based programming and event handling in JavaScript.
3.7 PHP Basics: Introduction to basic programming concepts in PHP.
3.8 PHP Variables and Operators: Use operators and variables in PHP.
3.9 Database Connectivity in PHP: Introduction and use of database connectivity in PHP.
3.10 SQL Queries and Database Creation: Use SQL queries to create and manage SQL databases.
4. Programming II
4.1 C Programming Review: Review the fundamental concepts of C programming.
4.2 Functions in C: Introduction to functions with prototypes, call, and return statements.
4.3 Library and User-Defined Functions: Understand the concepts and advantages of library and user-defined functions.
4.4 Storage and Recursion: State and apply the concepts of storage and recursion in programming.
4.5 Structures and Unions: Introduction and differentiation between structures and unions.
4.6 Pointers: Define and apply the concept of pointers in C.
4.7 Data Files: Understand the concept of data files, both sequential and random.
4.8 File Manipulation Functions: Apply various file manipulation functions.
4.9 File Operations: Open, read, write, and append data in files.
5. Object-Oriented Programming (OOP) Concepts
5.1 Introduction to OOP: Introduction to Object-Oriented Programming (OOP) paradigms and features.
5.2 Advantages and Applications of OOP: State the advantages and practical applications of OOP.
6. Software Process Model (SDLC)
6.1 Software Projects and SDLC: State the concept of software projects, software development processes, and the Software Development Life Cycle (SDLC).
6.2 System Analyst vs Software Engineer: Compare the roles of system analysts and software engineers.
6.3 System Design: Introduction to the concept of system design.
6.4 Software and Quality: Understand the relationship between software development and quality.
6.5 Software Development Models: Explain various software development models.
7. Recent Trends in ICT
7.1 Recent Trends in ICT: Describe the latest trends and advancements in Information and Communication Technology (ICT).
